Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.5115432739258E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00040411949157715 / seconds
host not found setting manual db connection
loadtime:0.00074410438537598 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00095200538635254 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0011270046234131 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.001176118850708 / seconds
zipcode:
loadtime:0.0011951923370361 / seconds
Query Executed:select * from search_referrer where page_hash='41faa6f2cc9c9dc773fd2252c0c0e741' limit 10 DB:ezrox_toadli
loadtime:0.0013961791992188 / seconds
Operation header executed (non global)
loadtime:0.0014162063598633 / seconds
Operation leaderboard executed (non global)
loadtime:0.0014572143554688 / seconds
Operation square executed (non global)
loadtime:0.0014710426330566 / seconds
Operation square_bottom executed (non global)
loadtime:0.0014841556549072 / seconds
Operation smallsquare executed (non global)
loadtime:0.0014960765838623 / seconds
Operation headeradright executed (non global)
loadtime:0.0015079975128174 / seconds
Operation google_analytics executed (non global)
loadtime:0.0015180110931396 / seconds
Operation topstories executed (non global)
loadtime:0.0015301704406738 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0015420913696289 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0015521049499512 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0018191337585449 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0019731521606445 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0020101070404053 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0020730495452881 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0021140575408936 / seconds
Template key: archive_menu pushed
loadtime:0.0021190643310547 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0021250247955322 / seconds
Template key: get_gravatar pushed
loadtime:0.002129077911377 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0021331310272217 / seconds
*10)-10)+1 | start:0
loadtime:0.002155065536499 / seconds
Query loaded from cache:select * from categories where cat_URLid='retail-bakeries'
loadtime:0.0021970272064209 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.0022270679473877 / seconds
DB connected to localhost business_master_new
loadtime:0.002507209777832 / seconds
Query Executed:select * from `nc_catmap` where sic='5461' order by city ascDB:business_master_new
loadtime:0.09331202507019 / seconds
Query stored in cache : _QUERY_www.toadli.comf88427692a958f0f37ae50d22e4438b6
loadtime:0.094628095626831 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='north-carolina'
loadtime:0.094696044921875 / seconds
Query Executed:select sum(totalcount) as totalsum from `nc_catmap` where sic='5461'DB:business_master_new
loadtime:0.099269151687622 / seconds
Query stored in cache : _QUERY_www.toadli.comfd87d7a1f1c93c985535b79656ef8dc5
loadtime:0.099299192428589 / seconds
820 / 11
loadtime:0.099341154098511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aberdeen' limit 1
loadtime:0.099394083023071 / seconds
Query Executed:select id FROM `nc` where city='Aberdeen' && SIC_code='5461'DB:business_master_new
loadtime:0.12088108062744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Advance' limit 1
loadtime:0.12094116210938 / seconds
Query Executed:select id FROM `nc` where city='Advance' && SIC_code='5461'DB:business_master_new
loadtime:0.12233018875122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ahoskie' limit 1
loadtime:0.12238907814026 / seconds
Query Executed:select id FROM `nc` where city='Ahoskie' && SIC_code='5461'DB:business_master_new
loadtime:0.12451505661011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alamance' limit 1
loadtime:0.1245641708374 / seconds
Query Executed:select id FROM `nc` where city='Alamance' && SIC_code='5461'DB:business_master_new
loadtime:0.14048314094543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albemarle' limit 1
loadtime:0.14052605628967 / seconds
Query Executed:select id FROM `nc` where city='Albemarle' && SIC_code='5461'DB:business_master_new
loadtime:0.14312815666199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albertson' limit 1
loadtime:0.14318919181824 / seconds
Query Executed:select id FROM `nc` where city='Albertson' && SIC_code='5461'DB:business_master_new
loadtime:0.1609001159668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander' limit 1
loadtime:0.16095018386841 / seconds
Query Executed:select id FROM `nc` where city='Alexander' && SIC_code='5461'DB:business_master_new
loadtime:0.18879413604736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexis' limit 1
loadtime:0.18884110450745 / seconds
Query Executed:select id FROM `nc` where city='Alexis' && SIC_code='5461'DB:business_master_new
loadtime:0.20436716079712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alliance' limit 1
loadtime:0.20442509651184 / seconds
Query Executed:select id FROM `nc` where city='Alliance' && SIC_code='5461'DB:business_master_new
loadtime:0.21489906311035 / seconds
Query loaded from cache:select * from geodata_geocity where city='Almond' limit 1
loadtime:0.21494722366333 / seconds
Query Executed:select id FROM `nc` where city='Almond' && SIC_code='5461'DB:business_master_new
loadtime:0.22325801849365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamahaw' limit 1
loadtime:0.22329807281494 / seconds
Query Executed:select id FROM `nc` where city='Altamahaw' && SIC_code='5461'DB:business_master_new
loadtime:0.22962307929993 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andrews' limit 1
loadtime:0.2296781539917 / seconds
Query Executed:select id FROM `nc` where city='Andrews' && SIC_code='5461'DB:business_master_new
loadtime:0.23050308227539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Angier' limit 1
loadtime:0.23053812980652 / seconds
Query Executed:select id FROM `nc` where city='Angier' && SIC_code='5461'DB:business_master_new
loadtime:0.23213219642639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ansonville' limit 1
loadtime:0.23219108581543 / seconds
Query Executed:select id FROM `nc` where city='Ansonville' && SIC_code='5461'DB:business_master_new
loadtime:0.25636005401611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Apex' limit 1
loadtime:0.25639510154724 / seconds
Query Executed:select id FROM `nc` where city='Apex' && SIC_code='5461'DB:business_master_new
loadtime:0.26152014732361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arapahoe' limit 1
loadtime:0.26158499717712 / seconds
Query Executed:select id FROM `nc` where city='Arapahoe' && SIC_code='5461'DB:business_master_new
loadtime:0.27864003181458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ararat' limit 1
loadtime:0.27869009971619 / seconds
Query Executed:select id FROM `nc` where city='Ararat' && SIC_code='5461'DB:business_master_new
loadtime:0.30486702919006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Archdale' limit 1
loadtime:0.30491518974304 / seconds
Query Executed:select id FROM `nc` where city='Archdale' && SIC_code='5461'DB:business_master_new
loadtime:0.30751299858093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arden' limit 1
loadtime:0.30755400657654 / seconds
Query Executed:select id FROM `nc` where city='Arden' && SIC_code='5461'DB:business_master_new
loadtime:0.31007504463196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ash' limit 1
loadtime:0.31013607978821 / seconds
Query Executed:select id FROM `nc` where city='Ash' && SIC_code='5461'DB:business_master_new
loadtime:0.310791015625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheboro' limit 1
loadtime:0.31083917617798 / seconds
Query Executed:select id FROM `nc` where city='Asheboro' && SIC_code='5461'DB:business_master_new
loadtime:0.31484508514404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Asheville' limit 1
loadtime:0.31490707397461 / seconds
Query Executed:select id FROM `nc` where city='Asheville' && SIC_code='5461'DB:business_master_new
loadtime:0.58564805984497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atkinson' limit 1
loadtime:0.58579421043396 / seconds
Query Executed:select id FROM `nc` where city='Atkinson' && SIC_code='5461'DB:business_master_new
loadtime:0.6084520816803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic' limit 1
loadtime:0.60850715637207 / seconds
Query Executed:select id FROM `nc` where city='Atlantic' && SIC_code='5461'DB:business_master_new
loadtime:0.6229190826416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atlantic Beach' limit 1
loadtime:0.62297010421753 / seconds
Query Executed:select id FROM `nc` where city='Atlantic Beach' && SIC_code='5461'DB:business_master_new
loadtime:0.62385606765747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aulander' limit 1
loadtime:0.62388920783997 / seconds
Query Executed:select id FROM `nc` where city='Aulander' && SIC_code='5461'DB:business_master_new
loadtime:0.62452721595764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.62457299232483 / seconds
Query Executed:select id FROM `nc` where city='Aurora' && SIC_code='5461'DB:business_master_new
loadtime:0.62525415420532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Autryville' limit 1
loadtime:0.62531208992004 / seconds
Query Executed:select id FROM `nc` where city='Autryville' && SIC_code='5461'DB:business_master_new
loadtime:0.62596201896667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Avon' limit 1
loadtime:0.62600612640381 / seconds
Query Executed:select id FROM `nc` where city='Avon' && SIC_code='5461'DB:business_master_new
loadtime:0.62667608261108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ayden' limit 1
loadtime:0.62670922279358 / seconds
Query Executed:select id FROM `nc` where city='Ayden' && SIC_code='5461'DB:business_master_new
loadtime:0.62756204605103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aydlett' limit 1
loadtime:0.62761402130127 / seconds
Query Executed:select id FROM `nc` where city='Aydlett' && SIC_code='5461'DB:business_master_new
loadtime:0.63285708427429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Badin' limit 1
loadtime:0.63291621208191 / seconds
Query Executed:select id FROM `nc` where city='Badin' && SIC_code='5461'DB:business_master_new
loadtime:0.65533304214478 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bahama' limit 1
loadtime:0.65537714958191 / seconds
Query Executed:select id FROM `nc` where city='Bahama' && SIC_code='5461'DB:business_master_new
loadtime:0.65603399276733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bailey' limit 1
loadtime:0.65607500076294 / seconds
Query Executed:select id FROM `nc` where city='Bailey' && SIC_code='5461'DB:business_master_new
loadtime:0.65675115585327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bakersville' limit 1
loadtime:0.65681219100952 / seconds
Query Executed:select id FROM `nc` where city='Bakersville' && SIC_code='5461'DB:business_master_new
loadtime:0.65752220153809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bald Head Island' limit 1
loadtime:0.65756511688232 / seconds
Query Executed:select id FROM `nc` where city='Bald Head Island' && SIC_code='5461'DB:business_master_new
loadtime:0.65835618972778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam' limit 1
loadtime:0.65841007232666 / seconds
Query Executed:select id FROM `nc` where city='Balsam' && SIC_code='5461'DB:business_master_new
loadtime:0.66528010368347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Balsam Grove' limit 1
loadtime:0.6653151512146 / seconds
Query Executed:select id FROM `nc` where city='Balsam Grove' && SIC_code='5461'DB:business_master_new
loadtime:0.67312407493591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banner Elk' limit 1
loadtime:0.67317700386047 / seconds
Query Executed:select id FROM `nc` where city='Banner Elk' && SIC_code='5461'DB:business_master_new
loadtime:0.67425012588501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barco' limit 1
loadtime:0.67430210113525 / seconds
Query Executed:select id FROM `nc` where city='Barco' && SIC_code='5461'DB:business_master_new
loadtime:0.68829417228699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barium Springs' limit 1
loadtime:0.68835210800171 / seconds
Query Executed:select id FROM `nc` where city='Barium Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.69453001022339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnardsville' limit 1
loadtime:0.69458103179932 / seconds
Query Executed:select id FROM `nc` where city='Barnardsville' && SIC_code='5461'DB:business_master_new
loadtime:0.695237159729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Barnesville' limit 1
loadtime:0.6952850818634 / seconds
Query Executed:select id FROM `nc` where city='Barnesville' && SIC_code='5461'DB:business_master_new
loadtime:0.69707703590393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bat Cave' limit 1
loadtime:0.69712018966675 / seconds
Query Executed:select id FROM `nc` where city='Bat Cave' && SIC_code='5461'DB:business_master_new
loadtime:0.70809102058411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bath' limit 1
loadtime:0.70814204216003 / seconds
Query Executed:select id FROM `nc` where city='Bath' && SIC_code='5461'DB:business_master_new
loadtime:0.70881319046021 / seconds
Query loaded from cache:select * from geodata_geocity where city='Battleboro' limit 1
loadtime:0.70887017250061 / seconds
Query Executed:select id FROM `nc` where city='Battleboro' && SIC_code='5461'DB:business_master_new
loadtime:0.70957708358765 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayboro' limit 1
loadtime:0.70961904525757 / seconds
Query Executed:select id FROM `nc` where city='Bayboro' && SIC_code='5461'DB:business_master_new
loadtime:0.71028614044189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.71034502983093 / seconds
Query Executed:select id FROM `nc` where city='Bear Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.71096110343933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaufort' limit 1
loadtime:0.71101021766663 / seconds
Query Executed:select id FROM `nc` where city='Beaufort' && SIC_code='5461'DB:business_master_new
loadtime:0.71195316314697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beech Mountain' limit 1
loadtime:0.71200513839722 / seconds
Query Executed:select id FROM `nc` where city='Beech Mountain' && SIC_code='5461'DB:business_master_new
loadtime:0.7134051322937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belews Creek' limit 1
loadtime:0.71345806121826 / seconds
Query Executed:select id FROM `nc` where city='Belews Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.71409821510315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belhaven' limit 1
loadtime:0.71413421630859 / seconds
Query Executed:select id FROM `nc` where city='Belhaven' && SIC_code='5461'DB:business_master_new
loadtime:0.71487402915955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellarthur' limit 1
loadtime:0.71493220329285 / seconds
Query Executed:select id FROM `nc` where city='Bellarthur' && SIC_code='5461'DB:business_master_new
loadtime:0.72101521492004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belmont' limit 1
loadtime:0.72106218338013 / seconds
Query Executed:select id FROM `nc` where city='Belmont' && SIC_code='5461'DB:business_master_new
loadtime:0.72209715843201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belvidere' limit 1
loadtime:0.72215604782104 / seconds
Query Executed:select id FROM `nc` where city='Belvidere' && SIC_code='5461'DB:business_master_new
loadtime:0.73868012428284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bennett' limit 1
loadtime:0.73873209953308 / seconds
Query Executed:select id FROM `nc` where city='Bennett' && SIC_code='5461'DB:business_master_new
loadtime:0.76973414421082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Benson' limit 1
loadtime:0.76978421211243 / seconds
Query Executed:select id FROM `nc` where city='Benson' && SIC_code='5461'DB:business_master_new
loadtime:0.77074599266052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer City' limit 1
loadtime:0.7708101272583 / seconds
Query Executed:select id FROM `nc` where city='Bessemer City' && SIC_code='5461'DB:business_master_new
loadtime:0.7716121673584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethania' limit 1
loadtime:0.77164912223816 / seconds
Query Executed:select id FROM `nc` where city='Bethania' && SIC_code='5461'DB:business_master_new
loadtime:0.78249502182007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bethel' limit 1
loadtime:0.78255009651184 / seconds
Query Executed:select id FROM `nc` where city='Bethel' && SIC_code='5461'DB:business_master_new
loadtime:0.78319406509399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beulaville' limit 1
loadtime:0.78323316574097 / seconds
Query Executed:select id FROM `nc` where city='Beulaville' && SIC_code='5461'DB:business_master_new
loadtime:0.78400921821594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biltmore Lake' limit 1
loadtime:0.78404021263123 / seconds
Query Executed:select id FROM `nc` where city='Biltmore Lake' && SIC_code='5461'DB:business_master_new
loadtime:0.7842800617218 / seconds
Query loaded from cache:select * from geodata_geocity where city='Biscoe' limit 1
loadtime:0.78431820869446 / seconds
Query Executed:select id FROM `nc` where city='Biscoe' && SIC_code='5461'DB:business_master_new
loadtime:0.78498816490173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Creek' limit 1
loadtime:0.78503704071045 / seconds
Query Executed:select id FROM `nc` where city='Black Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.79556918144226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black Mountain' limit 1
loadtime:0.79560518264771 / seconds
Query Executed:select id FROM `nc` where city='Black Mountain' && SIC_code='5461'DB:business_master_new
loadtime:0.79657220840454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bladenboro' limit 1
loadtime:0.79662609100342 / seconds
Query Executed:select id FROM `nc` where city='Bladenboro' && SIC_code='5461'DB:business_master_new
loadtime:0.79736804962158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanch' limit 1
loadtime:0.79740309715271 / seconds
Query Executed:select id FROM `nc` where city='Blanch' && SIC_code='5461'DB:business_master_new
loadtime:0.81278800964355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blounts Creek' limit 1
loadtime:0.81284213066101 / seconds
Query Executed:select id FROM `nc` where city='Blounts Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.82811403274536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blowing Rock' limit 1
loadtime:0.82815599441528 / seconds
Query Executed:select id FROM `nc` where city='Blowing Rock' && SIC_code='5461'DB:business_master_new
loadtime:0.82901215553284 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boger City' limit 1
loadtime:0.82904314994812 / seconds
Query Executed:select id FROM `nc` where city='Boger City' && SIC_code='5461'DB:business_master_new
loadtime:0.82927417755127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boiling Springs' limit 1
loadtime:0.82931518554688 / seconds
Query Executed:select id FROM `nc` where city='Boiling Springs' && SIC_code='5461'DB:business_master_new
loadtime:0.82993817329407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolivia' limit 1
loadtime:0.8299720287323 / seconds
Query Executed:select id FROM `nc` where city='Bolivia' && SIC_code='5461'DB:business_master_new
loadtime:0.83069705963135 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bolton' limit 1
loadtime:0.83073306083679 / seconds
Query Executed:select id FROM `nc` where city='Bolton' && SIC_code='5461'DB:business_master_new
loadtime:0.83131098747253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonlee' limit 1
loadtime:0.83134603500366 / seconds
Query Executed:select id FROM `nc` where city='Bonlee' && SIC_code='5461'DB:business_master_new
loadtime:0.84123015403748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boomer' limit 1
loadtime:0.84126615524292 / seconds
Query Executed:select id FROM `nc` where city='Boomer' && SIC_code='5461'DB:business_master_new
loadtime:0.86458420753479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boone' limit 1
loadtime:0.86463618278503 / seconds
Query Executed:select id FROM `nc` where city='Boone' && SIC_code='5461'DB:business_master_new
loadtime:0.86620712280273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boonville' limit 1
loadtime:0.86626315116882 / seconds
Query Executed:select id FROM `nc` where city='Boonville' && SIC_code='5461'DB:business_master_new
loadtime:0.86693120002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bostic' limit 1
loadtime:0.86698508262634 / seconds
Query Executed:select id FROM `nc` where city='Bostic' && SIC_code='5461'DB:business_master_new
loadtime:0.86764311790466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bowdens' limit 1
loadtime:0.86768507957458 / seconds
Query Executed:select id FROM `nc` where city='Bowdens' && SIC_code='5461'DB:business_master_new
loadtime:0.8685359954834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brasstown' limit 1
loadtime:0.86858415603638 / seconds
Query Executed:select id FROM `nc` where city='Brasstown' && SIC_code='5461'DB:business_master_new
loadtime:0.88704419136047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brevard' limit 1
loadtime:0.88709306716919 / seconds
Query Executed:select id FROM `nc` where city='Brevard' && SIC_code='5461'DB:business_master_new
loadtime:0.88827300071716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeton' limit 1
loadtime:0.88833022117615 / seconds
Query Executed:select id FROM `nc` where city='Bridgeton' && SIC_code='5461'DB:business_master_new
loadtime:0.91475415229797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Broadway' limit 1
loadtime:0.91481900215149 / seconds
Query Executed:select id FROM `nc` where city='Broadway' && SIC_code='5461'DB:business_master_new
loadtime:0.9154851436615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Browns Summit' limit 1
loadtime:0.9155261516571 / seconds
Query Executed:select id FROM `nc` where city='Browns Summit' && SIC_code='5461'DB:business_master_new
loadtime:0.91626906394958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brunswick' limit 1
loadtime:0.91632008552551 / seconds
Query Executed:select id FROM `nc` where city='Brunswick' && SIC_code='5461'DB:business_master_new
loadtime:0.9228310585022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryson City' limit 1
loadtime:0.92288017272949 / seconds
Query Executed:select id FROM `nc` where city='Bryson City' && SIC_code='5461'DB:business_master_new
loadtime:0.92373704910278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buies Creek' limit 1
loadtime:0.92378520965576 / seconds
Query Executed:select id FROM `nc` where city='Buies Creek' && SIC_code='5461'DB:business_master_new
loadtime:0.94705104827881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bullock' limit 1
loadtime:0.94710111618042 / seconds
Query Executed:select id FROM `nc` where city='Bullock' && SIC_code='5461'DB:business_master_new
loadtime:0.9598240852356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunn' limit 1
loadtime:0.95985913276672 / seconds
Query Executed:select id FROM `nc` where city='Bunn' && SIC_code='5461'DB:business_master_new
loadtime:0.96051907539368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bunnlevel' limit 1
loadtime:0.96058011054993 / seconds
Query Executed:select id FROM `nc` where city='Bunnlevel' && SIC_code='5461'DB:business_master_new
loadtime:0.99014520645142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burgaw' limit 1
loadtime:0.99021410942078 / seconds
Query Executed:select id FROM `nc` where city='Burgaw' && SIC_code='5461'DB:business_master_new
loadtime:0.99117016792297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burlington' limit 1
loadtime:0.99122714996338 / seconds
Query Executed:select id FROM `nc` where city='Burlington' && SIC_code='5461'DB:business_master_new
loadtime:0.99932909011841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnsville' limit 1
loadtime:0.99939608573914 / seconds
Query Executed:select id FROM `nc` where city='Burnsville' && SIC_code='5461'DB:business_master_new
loadtime:1.0004100799561 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butner' limit 1
loadtime:1.0004460811615 / seconds
Query Executed:select id FROM `nc` where city='Butner' && SIC_code='5461'DB:business_master_new
loadtime:1.0011651515961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butters' limit 1
loadtime:1.001216173172 / seconds
Query Executed:select id FROM `nc` where city='Butters' && SIC_code='5461'DB:business_master_new
loadtime:1.0014581680298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buxton' limit 1
loadtime:1.0014941692352 / seconds
Query Executed:select id FROM `nc` where city='Buxton' && SIC_code='5461'DB:business_master_new
loadtime:1.0022270679474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bynum' limit 1
loadtime:1.0022780895233 / seconds
Query Executed:select id FROM `nc` where city='Bynum' && SIC_code='5461'DB:business_master_new
loadtime:1.0054271221161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calabash' limit 1
loadtime:1.0054790973663 / seconds
Query Executed:select id FROM `nc` where city='Calabash' && SIC_code='5461'DB:business_master_new
loadtime:1.0063090324402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calypso' limit 1
loadtime:1.0063560009003 / seconds
Query Executed:select id FROM `nc` where city='Calypso' && SIC_code='5461'DB:business_master_new
loadtime:1.0184471607208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:1.0184960365295 / seconds
Query Executed:select id FROM `nc` where city='Camden' && SIC_code='5461'DB:business_master_new
loadtime:1.0192291736603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cameron' limit 1
loadtime:1.0192861557007 / seconds
Query Executed:select id FROM `nc` where city='Cameron' && SIC_code='5461'DB:business_master_new
loadtime:1.0199851989746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Lejeune' limit 1
loadtime:1.0200271606445 / seconds
Query Executed:select id FROM `nc` where city='Camp Lejeune' && SIC_code='5461'DB:business_master_new
loadtime:1.0206501483917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candler' limit 1
loadtime:1.0206952095032 / seconds
Query Executed:select id FROM `nc` where city='Candler' && SIC_code='5461'DB:business_master_new
loadtime:1.0216782093048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Candor' limit 1
loadtime:1.0217220783234 / seconds
Query Executed:select id FROM `nc` where city='Candor' && SIC_code='5461'DB:business_master_new
loadtime:1.0224030017853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Canton' limit 1
loadtime:1.0224621295929 / seconds
Query Executed:select id FROM `nc` where city='Canton' && SIC_code='5461'DB:business_master_new
loadtime:1.0233449935913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cape Carteret' limit 1
loadtime:1.0234050750732 / seconds
Query Executed:select id FROM `nc` where city='Cape Carteret' && SIC_code='5461'DB:business_master_new
loadtime:1.0269520282745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Caroleen' limit 1
loadtime:1.0270111560822 / seconds
Query Executed:select id FROM `nc` where city='Caroleen' && SIC_code='5461'DB:business_master_new
loadtime:1.0343410968781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Beach' limit 1
loadtime:1.0343861579895 / seconds
Query Executed:select id FROM `nc` where city='Carolina Beach' && SIC_code='5461'DB:business_master_new
loadtime:1.0352940559387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carolina Shores' limit 1
loadtime:1.0353519916534 / seconds
Query Executed:select id FROM `nc` where city='Carolina Shores' && SIC_code='5461'DB:business_master_new
loadtime:1.0360472202301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrboro' limit 1
loadtime:1.0360751152039 / seconds
Query Executed:select id FROM `nc` where city='Carrboro' && SIC_code='5461'DB:business_master_new
loadtime:1.0369811058044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carthage' limit 1
loadtime:1.0370361804962 / seconds
Query Executed:select id FROM `nc` where city='Carthage' && SIC_code='5461'DB:business_master_new
loadtime:1.0378742218018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cary' limit 1
loadtime:1.0379230976105 / seconds
Query Executed:select id FROM `nc` where city='Cary' && SIC_code='5461'DB:business_master_new
loadtime:1.0451581478119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Casar' limit 1
loadtime:1.0452291965485 / seconds
Query Executed:select id FROM `nc` where city='Casar' && SIC_code='5461'DB:business_master_new
loadtime:1.0712811946869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cashiers' limit 1
loadtime:1.0713291168213 / seconds
Query Executed:select id FROM `nc` where city='Cashiers' && SIC_code='5461'DB:business_master_new
loadtime:1.072172164917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castalia' limit 1
loadtime:1.0722110271454 / seconds
Query Executed:select id FROM `nc` where city='Castalia' && SIC_code='5461'DB:business_master_new
loadtime:1.1015632152557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Hayne' limit 1
loadtime:1.1016120910645 / seconds
Query Executed:select id FROM `nc` where city='Castle Hayne' && SIC_code='5461'DB:business_master_new
loadtime:1.1024041175842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catawba' limit 1
loadtime:1.1024451255798 / seconds
Query Executed:select id FROM `nc` where city='Catawba' && SIC_code='5461'DB:business_master_new
loadtime:1.1031601428986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Falls' limit 1
loadtime:1.1032130718231 / seconds
Query Executed:select id FROM `nc` where city='Cedar Falls' && SIC_code='5461'DB:business_master_new
loadtime:1.1058490276337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Grove' limit 1
loadtime:1.1058990955353 / seconds
Query Executed:select id FROM `nc` where city='Cedar Grove' && SIC_code='5461'DB:business_master_new
loadtime:1.1291961669922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Island' limit 1
loadtime:1.1292471885681 / seconds
Query Executed:select id FROM `nc` where city='Cedar Island' && SIC_code='5461'DB:business_master_new
loadtime:1.139139175415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Mountain' limit 1
loadtime:1.1391770839691 / seconds
Query Executed:select id FROM `nc` where city='Cedar Mountain' && SIC_code='5461'DB:business_master_new
loadtime:1.1622841358185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Point' limit 1
loadtime:1.1623301506042 / seconds
Query Executed:select id FROM `nc` where city='Cedar Point' && SIC_code='5461'DB:business_master_new
loadtime:1.1632261276245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cerro Gordo' limit 1
loadtime:1.1632602214813 / seconds
Query Executed:select id FROM `nc` where city='Cerro Gordo' && SIC_code='5461'DB:business_master_new
loadtime:1.1897029876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chadbourn' limit 1
loadtime:1.1897451877594 / seconds
Query Executed:select id FROM `nc` where city='Chadbourn' && SIC_code='5461'DB:business_master_new
loadtime:1.1905200481415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapel Hill' limit 1
loadtime:1.1905570030212 / seconds
Query Executed:select id FROM `nc` where city='Chapel Hill' && SIC_code='5461'DB:business_master_new
loadtime:1.1980872154236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Charlotte' limit 1
loadtime:1.1981391906738 / seconds
Query Executed:select id FROM `nc` where city='Charlotte' && SIC_code='5461'DB:business_master_new
loadtime:1.205363035202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:1.2054719924927 / seconds
Query Executed:select id FROM `nc` where city='Cherokee' && SIC_code='5461'DB:business_master_new
loadtime:1.2062711715698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherry Point' limit 1
loadtime:1.2063040733337 / seconds
Query Executed:select id FROM `nc` where city='Cherry Point' && SIC_code='5461'DB:business_master_new
loadtime:1.2233421802521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherryville' limit 1
loadtime:1.2233800888062 / seconds
Query Executed:select id FROM `nc` where city='Cherryville' && SIC_code='5461'DB:business_master_new
loadtime:1.2242391109467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chimney Rock' limit 1
loadtime:1.2242732048035 / seconds
Query Executed:select id FROM `nc` where city='Chimney Rock' && SIC_code='5461'DB:business_master_new
loadtime:1.2385430335999 / seconds
Query loaded from cache:select * from geodata_geocity where city='China Grove' limit 1
loadtime:1.2385730743408 / seconds
Query Executed:select id FROM `nc` where city='China Grove' && SIC_code='5461'DB:business_master_new
loadtime:1.2394630908966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chinquapin' limit 1
loadtime:1.2395031452179 / seconds
Query Executed:select id FROM `nc` where city='Chinquapin' && SIC_code='5461'DB:business_master_new
loadtime:1.2679891586304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chocowinity' limit 1
loadtime:1.2680242061615 / seconds
Query Executed:select id FROM `nc` where city='Chocowinity' && SIC_code='5461'DB:business_master_new
loadtime:1.268806219101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Claremont' limit 1
loadtime:1.2688460350037 / seconds
Query Executed:select id FROM `nc` where city='Claremont' && SIC_code='5461'DB:business_master_new
loadtime:1.2695791721344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarendon' limit 1
loadtime:1.269611120224 / seconds
Query Executed:select id FROM `nc` where city='Clarendon' && SIC_code='5461'DB:business_master_new
loadtime:1.2877221107483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkton' limit 1
loadtime:1.2877700328827 / seconds
Query Executed:select id FROM `nc` where city='Clarkton' && SIC_code='5461'DB:business_master_new
loadtime:1.2884771823883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:1.2885119915009 / seconds
Query Executed:select id FROM `nc` where city='Clayton' && SIC_code='5461'DB:business_master_new
loadtime:1.2898070812225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clemmons' limit 1
loadtime:1.2898590564728 / seconds
Query Executed:select id FROM `nc` where city='Clemmons' && SIC_code='5461'DB:business_master_new
loadtime:1.2910120487213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:1.2910680770874 / seconds
Query Executed:select id FROM `nc` where city='Cleveland' && SIC_code='5461'DB:business_master_new
loadtime:1.2917430400848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cliffside' limit 1
loadtime:1.2917950153351 / seconds
Query Executed:select id FROM `nc` where city='Cliffside' && SIC_code='5461'DB:business_master_new
loadtime:1.2999541759491 / seconds
Query loaded from cache:select * from geodata_geocity where city='Climax' limit 1
loadtime:1.3000011444092 / seconds
Query Executed:select id FROM `nc` where city='Climax' && SIC_code='5461'DB:business_master_new
loadtime:1.3006811141968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:1.3007261753082 / seconds
Query Executed:select id FROM `nc` where city='Clinton' && SIC_code='5461'DB:business_master_new
loadtime:1.3022871017456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clyde' limit 1
loadtime:1.3023431301117 / seconds
Query Executed:select id FROM `nc` where city='Clyde' && SIC_code='5461'DB:business_master_new
loadtime:1.303108215332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coats' limit 1
loadtime:1.3031551837921 / seconds
Query Executed:select id FROM `nc` where city='Coats' && SIC_code='5461'DB:business_master_new
loadtime:1.3038511276245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cofield' limit 1
loadtime:1.3038949966431 / seconds
Query Executed:select id FROM `nc` where city='Cofield' && SIC_code='5461'DB:business_master_new
loadtime:1.3172221183777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coinjock' limit 1
loadtime:1.3172709941864 / seconds
Query Executed:select id FROM `nc` where city='Coinjock' && SIC_code='5461'DB:business_master_new
loadtime:1.3466191291809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colerain' limit 1
loadtime:1.3466651439667 / seconds
Query Executed:select id FROM `nc` where city='Colerain' && SIC_code='5461'DB:business_master_new
loadtime:1.3473291397095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coleridge' limit 1
loadtime:1.3473811149597 / seconds
Query Executed:select id FROM `nc` where city='Coleridge' && SIC_code='5461'DB:business_master_new
loadtime:1.3481161594391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Colfax' limit 1
loadtime:1.3481690883636 / seconds
Query Executed:select id FROM `nc` where city='Colfax' && SIC_code='5461'DB:business_master_new
loadtime:1.3488421440125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collettsville' limit 1
loadtime:1.3488922119141 / seconds
Query Executed:select id FROM `nc` where city='Collettsville' && SIC_code='5461'DB:business_master_new
loadtime:1.3601841926575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:1.3602321147919 / seconds
Query Executed:select id FROM `nc` where city='Columbia' && SIC_code='5461'DB:business_master_new
loadtime:1.3609721660614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbus' limit 1
loadtime:1.3610231876373 / seconds
Query Executed:select id FROM `nc` where city='Columbus' && SIC_code='5461'DB:business_master_new
loadtime:1.3617370128632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Comfort' limit 1
loadtime:1.3617720603943 / seconds
Query Executed:select id FROM `nc` where city='Comfort' && SIC_code='5461'DB:business_master_new
loadtime:1.3651390075684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Como' limit 1
loadtime:1.365180015564 / seconds
Query Executed:select id FROM `nc` where city='Como' && SIC_code='5461'DB:business_master_new
loadtime:1.3769950866699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Concord' limit 1
loadtime:1.3770360946655 / seconds
Query Executed:select id FROM `nc` where city='Concord' && SIC_code='5461'DB:business_master_new
loadtime:1.3846700191498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conetoe' limit 1
loadtime:1.3847301006317 / seconds
Query Executed:select id FROM `nc` where city='Conetoe' && SIC_code='5461'DB:business_master_new
loadtime:1.39377617836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Spgs' limit 1
loadtime:1.3938150405884 / seconds
Query Executed:select id FROM `nc` where city='Connellys Spgs' && SIC_code='5461'DB:business_master_new
loadtime:1.3954820632935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Connellys Springs' limit 1
loadtime:1.3955221176147 / seconds
Query Executed:select id FROM `nc` where city='Connellys Springs' && SIC_code='5461'DB:business_master_new
loadtime:1.3957622051239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conover' limit 1
loadtime:1.3957931995392 / seconds
Query Executed:select id FROM `nc` where city='Conover' && SIC_code='5461'DB:business_master_new
loadtime:1.3970730304718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Conway' limit 1
loadtime:1.3971140384674 / seconds
Query Executed:select id FROM `nc` where city='Conway' && SIC_code='5461'DB:business_master_new
loadtime:1.3977131843567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cooleemee' limit 1
loadtime:1.3977429866791 / seconds
Query Executed:select id FROM `nc` where city='Cooleemee' && SIC_code='5461'DB:business_master_new
loadtime:1.3983280658722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corapeake' limit 1
loadtime:1.3983540534973 / seconds
Query Executed:select id FROM `nc` where city='Corapeake' && SIC_code='5461'DB:business_master_new
loadtime:1.4081881046295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:1.4082272052765 / seconds
Query Executed:select id FROM `nc` where city='Cordova' && SIC_code='5461'DB:business_master_new
loadtime:1.416403055191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornelius' limit 1
loadtime:1.416454076767 / seconds
Query Executed:select id FROM `nc` where city='Cornelius' && SIC_code='5461'DB:business_master_new
loadtime:1.4181652069092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corolla' limit 1
loadtime:1.4182281494141 / seconds
Query Executed:select id FROM `nc` where city='Corolla' && SIC_code='5461'DB:business_master_new
loadtime:1.4189600944519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Council' limit 1
loadtime:1.4190201759338 / seconds
Query Executed:select id FROM `nc` where city='Council' && SIC_code='5461'DB:business_master_new
loadtime:1.4385101795197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cove City' limit 1
loadtime:1.4385690689087 / seconds
Query Executed:select id FROM `nc` where city='Cove City' && SIC_code='5461'DB:business_master_new
loadtime:1.4688911437988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cramerton' limit 1
loadtime:1.4689381122589 / seconds
Query Executed:select id FROM `nc` where city='Cramerton' && SIC_code='5461'DB:business_master_new
loadtime:1.4695930480957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creedmoor' limit 1
loadtime:1.469642162323 / seconds
Query Executed:select id FROM `nc` where city='Creedmoor' && SIC_code='5461'DB:business_master_new
loadtime:1.4705080986023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creston' limit 1
loadtime:1.470566034317 / seconds
Query Executed:select id FROM `nc` where city='Creston' && SIC_code='5461'DB:business_master_new
loadtime:1.4885540008545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creswell' limit 1
loadtime:1.4885911941528 / seconds
Query Executed:select id FROM `nc` where city='Creswell' && SIC_code='5461'DB:business_master_new
loadtime:1.489226102829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossnore' limit 1
loadtime:1.4892771244049 / seconds
Query Executed:select id FROM `nc` where city='Crossnore' && SIC_code='5461'DB:business_master_new
loadtime:1.5022811889648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crouse' limit 1
loadtime:1.5023260116577 / seconds
Query Executed:select id FROM `nc` where city='Crouse' && SIC_code='5461'DB:business_master_new
loadtime:1.5236520767212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crumpler' limit 1
loadtime:1.5237040519714 / seconds
Query Executed:select id FROM `nc` where city='Crumpler' && SIC_code='5461'DB:business_master_new
loadtime:1.5473630428314 / seconds
Query loaded from cache:select * from geodata_geocity where city='Culberson' limit 1
loadtime:1.5473990440369 / seconds
Query Executed:select id FROM `nc` where city='Culberson' && SIC_code='5461'DB:business_master_new
loadtime:1.5482361316681 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullowhee' limit 1
loadtime:1.5482811927795 / seconds
Query Executed:select id FROM `nc` where city='Cullowhee' && SIC_code='5461'DB:business_master_new
loadtime:1.5489552021027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumberland' limit 1
loadtime:1.5490012168884 / seconds
Query Executed:select id FROM `nc` where city='Cumberland' && SIC_code='5461'DB:business_master_new
loadtime:1.5576040744781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cumnock' limit 1
loadtime:1.5576581954956 / seconds
Query Executed:select id FROM `nc` where city='Cumnock' && SIC_code='5461'DB:business_master_new
loadtime:1.5582251548767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currie' limit 1
loadtime:1.5582790374756 / seconds
Query Executed:select id FROM `nc` where city='Currie' && SIC_code='5461'DB:business_master_new
loadtime:1.580402135849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Currituck' limit 1
loadtime:1.5804390907288 / seconds
Query Executed:select id FROM `nc` where city='Currituck' && SIC_code='5461'DB:business_master_new
loadtime:1.5810379981995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dallas' limit 1
loadtime:1.5810790061951 / seconds
Query Executed:select id FROM `nc` where city='Dallas' && SIC_code='5461'DB:business_master_new
loadtime:1.5819439888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dana' limit 1
loadtime:1.5820090770721 / seconds
Query Executed:select id FROM `nc` where city='Dana' && SIC_code='5461'DB:business_master_new
loadtime:1.595073223114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danbury' limit 1
loadtime:1.595113992691 / seconds
Query Executed:select id FROM `nc` where city='Danbury' && SIC_code='5461'DB:business_master_new
loadtime:1.595813035965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davidson' limit 1
loadtime:1.5958700180054 / seconds
Query Executed:select id FROM `nc` where city='Davidson' && SIC_code='5461'DB:business_master_new
loadtime:1.5968310832977 / seconds
Query loaded from cache:select * from geodata_geocity where city='Davis' limit 1
loadtime:1.5968751907349 / seconds
Query Executed:select id FROM `nc` where city='Davis' && SIC_code='5461'DB:business_master_new
loadtime:1.6042981147766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Gap' limit 1
loadtime:1.6043510437012 / seconds
Query Executed:select id FROM `nc` where city='Deep Gap' && SIC_code='5461'DB:business_master_new
loadtime:1.6049621105194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deep Run' limit 1
loadtime:1.6049971580505 / seconds
Query Executed:select id FROM `nc` where city='Deep Run' && SIC_code='5461'DB:business_master_new
loadtime:1.6055960655212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delco' limit 1
loadtime:1.6056351661682 / seconds
Query Executed:select id FROM `nc` where city='Delco' && SIC_code='5461'DB:business_master_new
loadtime:1.6062350273132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denton' limit 1
loadtime:1.6062731742859 / seconds
Query Executed:select id FROM `nc` where city='Denton' && SIC_code='5461'DB:business_master_new
loadtime:1.6070330142975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Denver' limit 1
loadtime:1.6070671081543 / seconds
Query Executed:select id FROM `nc` where city='Denver' && SIC_code='5461'DB:business_master_new
loadtime:1.6084752082825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dillsboro' limit 1
loadtime:1.6085221767426 / seconds
Query Executed:select id FROM `nc` where city='Dillsboro' && SIC_code='5461'DB:business_master_new
loadtime:1.6091110706329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dobson' limit 1
loadtime:1.6091470718384 / seconds
Query Executed:select id FROM `nc` where city='Dobson' && SIC_code='5461'DB:business_master_new
loadtime:1.6099681854248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dover' limit 1
loadtime:1.6100051403046 / seconds
Query Executed:select id FROM `nc` where city='Dover' && SIC_code='5461'DB:business_master_new
loadtime:1.6422472000122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Drexel' limit 1
loadtime:1.6422820091248 / seconds
Query Executed:select id FROM `nc` where city='Drexel' && SIC_code='5461'DB:business_master_new
loadtime:1.6429431438446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dublin' limit 1
loadtime:1.6429810523987 / seconds
Query Executed:select id FROM `nc` where city='Dublin' && SIC_code='5461'DB:business_master_new
loadtime:1.6623241901398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dudley' limit 1
loadtime:1.6623492240906 / seconds
Query Executed:select id FROM `nc` where city='Dudley' && SIC_code='5461'DB:business_master_new
loadtime:1.6630551815033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dunn' limit 1
loadtime:1.663104057312 / seconds
Query Executed:select id FROM `nc` where city='Dunn' && SIC_code='5461'DB:business_master_new
loadtime:1.6644151210785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durants Neck' limit 1
loadtime:1.6644661426544 / seconds
Query Executed:select id FROM `nc` where city='Durants Neck' && SIC_code='5461'DB:business_master_new
loadtime:1.6649432182312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Durham' limit 1
loadtime:1.6649839878082 / seconds
Query Executed:select id FROM `nc` where city='Durham' && SIC_code='5461'DB:business_master_new
loadtime:1.6728980541229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Rock' limit 1
loadtime:1.672975063324 / seconds
Query Executed:select id FROM `nc` where city='Eagle Rock' && SIC_code='5461'DB:business_master_new
loadtime:1.6733109951019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Springs' limit 1
loadtime:1.6733570098877 / seconds
Query Executed:select id FROM `nc` where city='Eagle Springs' && SIC_code='5461'DB:business_master_new
loadtime:1.6911799907684 / seconds
Query loaded from cache:select * from geodata_geocity where city='Earl' limit 1
loadtime:1.6912159919739 / seconds
Query Executed:select id FROM `nc` where city='Earl' && SIC_code='5461'DB:business_master_new
loadtime:1.6976871490479 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Bend' limit 1
loadtime:1.6977360248566 / seconds
Query Executed:select id FROM `nc` where city='East Bend' && SIC_code='5461'DB:business_master_new
loadtime:1.6985020637512 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Fayettevlle' limit 1
loadtime:1.6985461711884 / seconds
Query Executed:select id FROM `nc` where city='East Fayettevlle' && SIC_code='5461'DB:business_master_new
loadtime:1.6990640163422 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Flat Rock' limit 1
loadtime:1.6991050243378 / seconds
Query Executed:select id FROM `nc` where city='East Flat Rock' && SIC_code='5461'DB:business_master_new
loadtime:1.699755191803 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Lake' limit 1
loadtime:1.6998171806335 / seconds
Query Executed:select id FROM `nc` where city='East Lake' && SIC_code='5461'DB:business_master_new
loadtime:1.7005710601807 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Spencer' limit 1
loadtime:1.700611114502 / seconds
Query Executed:select id FROM `nc` where city='East Spencer' && SIC_code='5461'DB:business_master_new
loadtime:1.721363067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:1.7214961051941 / seconds
Query Executed:select id FROM `nc` where city='Eden' && SIC_code='5461'DB:business_master_new
loadtime:1.7239420413971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edenton' limit 1
loadtime:1.7239990234375 / seconds
Query Executed:select id FROM `nc` where city='Edenton' && SIC_code='5461'DB:business_master_new
loadtime:1.7249670028687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edneyville' limit 1
loadtime:1.7250092029572 / seconds
Query Executed:select id FROM `nc` where city='Edneyville' && SIC_code='5461'DB:business_master_new
loadtime:1.7392601966858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edward' limit 1
loadtime:1.7393081188202 / seconds
Query Executed:select id FROM `nc` where city='Edward' && SIC_code='5461'DB:business_master_new
loadtime:1.7483780384064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Efland' limit 1
loadtime:1.7484221458435 / seconds
Query Executed:select id FROM `nc` where city='Efland' && SIC_code='5461'DB:business_master_new
loadtime:1.7491071224213 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabeth City' limit 1
loadtime:1.7491571903229 / seconds
Query Executed:select id FROM `nc` where city='Elizabeth City' && SIC_code='5461'DB:business_master_new
loadtime:1.7507691383362 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elizabethtown' limit 1
loadtime:1.7508490085602 / seconds
Query Executed:select id FROM `nc` where city='Elizabethtown' && SIC_code='5461'DB:business_master_new
loadtime:1.7518301010132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elk Park' limit 1
loadtime:1.7518711090088 / seconds
Query Executed:select id FROM `nc` where city='Elk Park' && SIC_code='5461'DB:business_master_new
loadtime:1.7525110244751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkin' limit 1
loadtime:1.7525670528412 / seconds
Query Executed:select id FROM `nc` where city='Elkin' && SIC_code='5461'DB:business_master_new
loadtime:1.7535030841827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellenboro' limit 1
loadtime:1.75355219841 / seconds
Query Executed:select id FROM `nc` where city='Ellenboro' && SIC_code='5461'DB:business_master_new
loadtime:1.7542350292206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ellerbe' limit 1
loadtime:1.7542700767517 / seconds
Query Executed:select id FROM `nc` where city='Ellerbe' && SIC_code='5461'DB:business_master_new
loadtime:1.7549560070038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elm City' limit 1
loadtime:1.7550051212311 / seconds
Query Executed:select id FROM `nc` where city='Elm City' && SIC_code='5461'DB:business_master_new
loadtime:1.75572514534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon' limit 1
loadtime:1.7557671070099 / seconds
Query Executed:select id FROM `nc` where city='Elon' && SIC_code='5461'DB:business_master_new
loadtime:1.7565321922302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elon College' limit 1
loadtime:1.7565882205963 / seconds
Query Executed:select id FROM `nc` where city='Elon College' && SIC_code='5461'DB:business_master_new
loadtime:1.7674090862274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emerald Isle' limit 1
loadtime:1.7674570083618 / seconds
Query Executed:select id FROM `nc` where city='Emerald Isle' && SIC_code='5461'DB:business_master_new
loadtime:1.7682721614838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enfield' limit 1
loadtime:1.768326997757 / seconds
Query Executed:select id FROM `nc` where city='Enfield' && SIC_code='5461'DB:business_master_new
loadtime:1.7690930366516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Engelhard' limit 1
loadtime:1.7691450119019 / seconds
Query Executed:select id FROM `nc` where city='Engelhard' && SIC_code='5461'DB:business_master_new
loadtime:1.8075351715088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enka' limit 1
loadtime:1.807578086853 / seconds
Query Executed:select id FROM `nc` where city='Enka' && SIC_code='5461'DB:business_master_new
loadtime:1.845712184906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ennice' limit 1
loadtime:1.8457670211792 / seconds
Query Executed:select id FROM `nc` where city='Ennice' && SIC_code='5461'DB:business_master_new
loadtime:1.8707571029663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ernul' limit 1
loadtime:1.8708181381226 / seconds
Query Executed:select id FROM `nc` where city='Ernul' && SIC_code='5461'DB:business_master_new
loadtime:1.8818800449371 / seconds
Query loaded from cache:select * from geodata_geocity where city='Erwin' limit 1
loadtime:1.8819231987 / seconds
Query Executed:select id FROM `nc` where city='Erwin' && SIC_code='5461'DB:business_master_new
loadtime:1.8826320171356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ether' limit 1
loadtime:1.8826580047607 / seconds
Query Executed:select id FROM `nc` where city='Ether' && SIC_code='5461'DB:business_master_new
loadtime:1.8905200958252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Etowah' limit 1
loadtime:1.8905591964722 / seconds
Query Executed:select id FROM `nc` where city='Etowah' && SIC_code='5461'DB:business_master_new
loadtime:1.8911950588226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eure' limit 1
loadtime:1.8912320137024 / seconds
Query Executed:select id FROM `nc` where city='Eure' && SIC_code='5461'DB:business_master_new
loadtime:1.9021430015564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:1.9021780490875 / seconds
Query Executed:select id FROM `nc` where city='Eureka' && SIC_code='5461'DB:business_master_new
loadtime:1.9032201766968 / seconds
Query loaded from cache:select * from geodata_geocity where city='Everetts' limit 1
loadtime:1.9032480716705 / seconds
Query Executed:select id FROM `nc` where city='Everetts' && SIC_code='5461'DB:business_master_new
loadtime:1.9090352058411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:1.9090700149536 / seconds
Query Executed:select id FROM `nc` where city='Evergreen' && SIC_code='5461'DB:business_master_new
loadtime:1.9251852035522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fair Bluff' limit 1
loadtime:1.9252262115479 / seconds
Query Executed:select id FROM `nc` where city='Fair Bluff' && SIC_code='5461'DB:business_master_new
loadtime:1.9258720874786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:1.9259190559387 / seconds
Query Executed:select id FROM `nc` where city='Fairfield' && SIC_code='5461'DB:business_master_new
loadtime:1.9438791275024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairmont' limit 1
loadtime:1.9439342021942 / seconds
Query Executed:select id FROM `nc` where city='Fairmont' && SIC_code='5461'DB:business_master_new
loadtime:1.9446971416473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:1.9447450637817 / seconds
Query Executed:select id FROM `nc` where city='Fairview' && SIC_code='5461'DB:business_master_new
loadtime:1.9455680847168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faison' limit 1
loadtime:1.9456191062927 / seconds
Query Executed:select id FROM `nc` where city='Faison' && SIC_code='5461'DB:business_master_new
loadtime:1.9465770721436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faith' limit 1
loadtime:1.946720123291 / seconds
Query Executed:select id FROM `nc` where city='Faith' && SIC_code='5461'DB:business_master_new
loadtime:1.9689772129059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falcon' limit 1
loadtime:1.9690141677856 / seconds
Query Executed:select id FROM `nc` where city='Falcon' && SIC_code='5461'DB:business_master_new
loadtime:1.9811902046204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkland' limit 1
loadtime:1.9812440872192 / seconds
Query Executed:select id FROM `nc` where city='Falkland' && SIC_code='5461'DB:business_master_new
loadtime:1.9910440444946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fallston' limit 1
loadtime:1.9910800457001 / seconds
Query Executed:select id FROM `nc` where city='Fallston' && SIC_code='5461'DB:business_master_new
loadtime:2.0163671970367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmville' limit 1
loadtime:2.0164141654968 / seconds
Query Executed:select id FROM `nc` where city='Farmville' && SIC_code='5461'DB:business_master_new
loadtime:2.0172941684723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayetteville' limit 1
loadtime:2.0173439979553 / seconds
Query Executed:select id FROM `nc` where city='Fayetteville' && SIC_code='5461'DB:business_master_new
loadtime:2.0251271724701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fearrington Vlg' limit 1
loadtime:2.0251932144165 / seconds
Query Executed:select id FROM `nc` where city='Fearrington Vlg' && SIC_code='5461'DB:business_master_new
loadtime:2.0254690647125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferguson' limit 1
loadtime:2.025505065918 / seconds
Query Executed:select id FROM `nc` where city='Ferguson' && SIC_code='5461'DB:business_master_new
loadtime:2.0561029911041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:2.0561830997467 / seconds
Query Executed:select id FROM `nc` where city='Flat Rock' && SIC_code='5461'DB:business_master_new
loadtime:2.0571291446686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fleetwood' limit 1
loadtime:2.0572001934052 / seconds
Query Executed:select id FROM `nc` where city='Fleetwood' && SIC_code='5461'DB:business_master_new
loadtime:2.0968551635742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fletcher' limit 1
loadtime:2.0969281196594 / seconds
Query Executed:select id FROM `nc` where city='Fletcher' && SIC_code='5461'DB:business_master_new
loadtime:2.098069190979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fontana Dam' limit 1
loadtime:2.0981240272522 / seconds
Query Executed:select id FROM `nc` where city='Fontana Dam' && SIC_code='5461'DB:business_master_new
loadtime:2.1011340618134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest City' limit 1
loadtime:2.101184129715 / seconds
Query Executed:select id FROM `nc` where city='Forest City' && SIC_code='5461'DB:business_master_new
loadtime:2.1023550033569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Bragg' limit 1
loadtime:2.1024131774902 / seconds
Query Executed:select id FROM `nc` where city='Fort Bragg' && SIC_code='5461'DB:business_master_new
loadtime:2.103166103363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain' limit 1
loadtime:2.1032140254974 / seconds
Query Executed:select id FROM `nc` where city='Fountain' && SIC_code='5461'DB:business_master_new
loadtime:2.1285581588745 / seconds
Query loaded from cache:select * from geodata_geocity where city='Four Oaks' limit 1
loadtime:2.1286151409149 / seconds
Query Executed:select id FROM `nc` where city='Four Oaks' && SIC_code='5461'DB:business_master_new
loadtime:2.1294701099396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:2.1295170783997 / seconds
Query Executed:select id FROM `nc` where city='Franklin' && SIC_code='5461'DB:business_master_new
loadtime:2.1348130702972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinton' limit 1
loadtime:2.1348600387573 / seconds
Query Executed:select id FROM `nc` where city='Franklinton' && SIC_code='5461'DB:business_master_new
loadtime:2.1356301307678 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklinville' limit 1
loadtime:2.1356902122498 / seconds
Query Executed:select id FROM `nc` where city='Franklinville' && SIC_code='5461'DB:business_master_new
loadtime:2.136372089386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fremont' limit 1
loadtime:2.1364190578461 / seconds
Query Executed:select id FROM `nc` where city='Fremont' && SIC_code='5461'DB:business_master_new
loadtime:2.1371221542358 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco' limit 1
loadtime:2.1371710300446 / seconds
Query Executed:select id FROM `nc` where city='Frisco' && SIC_code='5461'DB:business_master_new
loadtime:2.1699850559235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fuquay Varina' limit 1
loadtime:2.17005610466 / seconds
Query Executed:select id FROM `nc` where city='Fuquay Varina' && SIC_code='5461'DB:business_master_new
loadtime:2.171471118927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:2.1715261936188 / seconds
Query Executed:select id FROM `nc` where city='Garland' && SIC_code='5461'DB:business_master_new
loadtime:2.1722581386566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garner' limit 1
loadtime:2.172306060791 / seconds
Query Executed:select id FROM `nc` where city='Garner' && SIC_code='5461'DB:business_master_new
loadtime:2.1738421916962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garysburg' limit 1
loadtime:2.1738770008087 / seconds
Query Executed:select id FROM `nc` where city='Garysburg' && SIC_code='5461'DB:business_master_new
loadtime:2.1949369907379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaston' limit 1
loadtime:2.1949920654297 / seconds
Query Executed:select id FROM `nc` where city='Gaston' && SIC_code='5461'DB:business_master_new
loadtime:2.2211620807648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gastonia' limit 1
loadtime:2.2212190628052 / seconds
Query Executed:select id FROM `nc` where city='Gastonia' && SIC_code='5461'DB:business_master_new
loadtime:2.229022026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gates' limit 1
loadtime:2.2290990352631 / seconds
Query Executed:select id FROM `nc` where city='Gates' && SIC_code='5461'DB:business_master_new
loadtime:2.2576642036438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gatesville' limit 1
loadtime:2.2577722072601 / seconds
Query Executed:select id FROM `nc` where city='Gatesville' && SIC_code='5461'DB:business_master_new
loadtime:2.2586240768433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Germanton' limit 1
loadtime:2.2586832046509 / seconds
Query Executed:select id FROM `nc` where city='Germanton' && SIC_code='5461'DB:business_master_new
loadtime:2.2593531608582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gerton' limit 1
loadtime:2.2593891620636 / seconds
Query Executed:select id FROM `nc` where city='Gerton' && SIC_code='5461'DB:business_master_new
loadtime:2.2632842063904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibson' limit 1
loadtime:2.2633321285248 / seconds
Query Executed:select id FROM `nc` where city='Gibson' && SIC_code='5461'DB:business_master_new
loadtime:2.2781791687012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gibsonville' limit 1
loadtime:2.2782402038574 / seconds
Query Executed:select id FROM `nc` where city='Gibsonville' && SIC_code='5461'DB:business_master_new
loadtime:2.2790341377258 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glade Valley' limit 1
loadtime:2.2790701389313 / seconds
Query Executed:select id FROM `nc` where city='Glade Valley' && SIC_code='5461'DB:business_master_new
loadtime:2.2942080497742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Alpine' limit 1
loadtime:2.2942600250244 / seconds
Query Executed:select id FROM `nc` where city='Glen Alpine' && SIC_code='5461'DB:business_master_new
loadtime:2.3167750835419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Raven' limit 1
loadtime:2.316822052002 / seconds
Query Executed:select id FROM `nc` where city='Glen Raven' && SIC_code='5461'DB:business_master_new
loadtime:2.3173282146454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale Springs' limit 1
loadtime:2.317369222641 / seconds
Query Executed:select id FROM `nc` where city='Glendale Springs' && SIC_code='5461'DB:business_master_new
loadtime:2.3257761001587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendon' limit 1
loadtime:2.3258290290833 / seconds
Query Executed:select id FROM `nc` where city='Glendon' && SIC_code='5461'DB:business_master_new
loadtime:2.326523065567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenville' limit 1
loadtime:2.3265612125397 / seconds
Query Executed:select id FROM `nc` where city='Glenville' && SIC_code='5461'DB:business_master_new
loadtime:2.3568739891052 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:2.3569250106812 / seconds
Query Executed:select id FROM `nc` where city='Glenwood' && SIC_code='5461'DB:business_master_new
loadtime:2.3603050708771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gloucester' limit 1
loadtime:2.3603391647339 / seconds
Query Executed:select id FROM `nc` where city='Gloucester' && SIC_code='5461'DB:business_master_new
loadtime:2.3660101890564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Godwin' limit 1
loadtime:2.3660562038422 / seconds
Query Executed:select id FROM `nc` where city='Godwin' && SIC_code='5461'DB:business_master_new
loadtime:2.3891789913177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gold Hill' limit 1
loadtime:2.3892199993134 / seconds
Query Executed:select id FROM `nc` where city='Gold Hill' && SIC_code='5461'DB:business_master_new
loadtime:2.3898952007294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldsboro' limit 1
loadtime:2.3899471759796 / seconds
Query Executed:select id FROM `nc` where city='Goldsboro' && SIC_code='5461'DB:business_master_new
loadtime:2.4020240306854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goldston' limit 1
loadtime:2.4020800590515 / seconds
Query Executed:select id FROM `nc` where city='Goldston' && SIC_code='5461'DB:business_master_new
loadtime:2.4405519962311 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:2.440603017807 / seconds
Query Executed:select id FROM `nc` where city='Graham' && SIC_code='5461'DB:business_master_new
loadtime:2.4417631626129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grandy' limit 1
loadtime:2.4418280124664 / seconds
Query Executed:select id FROM `nc` where city='Grandy' && SIC_code='5461'DB:business_master_new
loadtime:2.4424970149994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Falls' limit 1
loadtime:2.4425311088562 / seconds
Query Executed:select id FROM `nc` where city='Granite Falls' && SIC_code='5461'DB:business_master_new
loadtime:2.4434561729431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Granite Quarry' limit 1
loadtime:2.4435031414032 / seconds
Query Executed:select id FROM `nc` where city='Granite Quarry' && SIC_code='5461'DB:business_master_new
loadtime:2.4800100326538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsboro' limit 1
loadtime:2.4800460338593 / seconds
Query Executed:select id FROM `nc` where city='Grantsboro' && SIC_code='5461'DB:business_master_new
loadtime:2.5009741783142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grassy Creek' limit 1
loadtime:2.5010261535645 / seconds
Query Executed:select id FROM `nc` where city='Grassy Creek' && SIC_code='5461'DB:business_master_new
loadtime:2.5076742172241 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Mountain' limit 1
loadtime:2.5077230930328 / seconds
Query Executed:select id FROM `nc` where city='Green Mountain' && SIC_code='5461'DB:business_master_new
loadtime:2.5224750041962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenmountain' limit 1
loadtime:2.5225250720978 / seconds
Query Executed:select id FROM `nc` where city='Greenmountain' && SIC_code='5461'DB:business_master_new
loadtime:2.5227751731873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:2.5228199958801 / seconds
Query Executed:select id FROM `nc` where city='Greensboro' && SIC_code='5461'DB:business_master_new
loadtime:2.5316500663757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:2.5317251682281 / seconds
Query Executed:select id FROM `nc` where city='Greenville' && SIC_code='5461'DB:business_master_new
loadtime:2.5388841629028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grifton' limit 1
loadtime:2.5389490127563 / seconds
Query Executed:select id FROM `nc` where city='Grifton' && SIC_code='5461'DB:business_master_new
loadtime:2.5396671295166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grimesland' limit 1
loadtime:2.5397100448608 / seconds
Query Executed:select id FROM `nc` where city='Grimesland' && SIC_code='5461'DB:business_master_new
loadtime:2.5404071807861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grover' limit 1
loadtime:2.5404531955719 / seconds
Query Executed:select id FROM `nc` where city='Grover' && SIC_code='5461'DB:business_master_new
loadtime:2.5411570072174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulf' limit 1
loadtime:2.541216135025 / seconds
Query Executed:select id FROM `nc` where city='Gulf' && SIC_code='5461'DB:business_master_new
loadtime:2.5450780391693 / seconds
Query loaded from cache:select * from geodata_geocity where city='Halifax' limit 1
loadtime:2.5451331138611 / seconds
Query Executed:select id FROM `nc` where city='Halifax' && SIC_code='5461'DB:business_master_new
loadtime:2.5459570884705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hallsboro' limit 1
loadtime:2.5459899902344 / seconds
Query Executed:select id FROM `nc` where city='Hallsboro' && SIC_code='5461'DB:business_master_new
loadtime:2.5673151016235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:2.5673642158508 / seconds
Query Executed:select id FROM `nc` where city='Hamilton' && SIC_code='5461'DB:business_master_new
loadtime:2.579204082489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamlet' limit 1
loadtime:2.5792551040649 / seconds
Query Executed:select id FROM `nc` where city='Hamlet' && SIC_code='5461'DB:business_master_new
loadtime:2.580146074295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hampstead' limit 1
loadtime:2.5801901817322 / seconds
Query Executed:select id FROM `nc` where city='Hampstead' && SIC_code='5461'DB:business_master_new
loadtime:2.581148147583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamptonville' limit 1
loadtime:2.5812101364136 / seconds
Query Executed:select id FROM `nc` where city='Hamptonville' && SIC_code='5461'DB:business_master_new
loadtime:2.5818881988525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harbinger' limit 1
loadtime:2.5819160938263 / seconds
Query Executed:select id FROM `nc` where city='Harbinger' && SIC_code='5461'DB:business_master_new
loadtime:2.5825080871582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harkers Island' limit 1
loadtime:2.5825572013855 / seconds
Query Executed:select id FROM `nc` where city='Harkers Island' && SIC_code='5461'DB:business_master_new
loadtime:2.6155622005463 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harmony' limit 1
loadtime:2.6156101226807 / seconds
Query Executed:select id FROM `nc` where city='Harmony' && SIC_code='5461'DB:business_master_new
loadtime:2.6163251399994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrells' limit 1
loadtime:2.6163771152496 / seconds
Query Executed:select id FROM `nc` where city='Harrells' && SIC_code='5461'DB:business_master_new
loadtime:2.6170241832733 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrellsville' limit 1
loadtime:2.6170570850372 / seconds
Query Executed:select id FROM `nc` where city='Harrellsville' && SIC_code='5461'DB:business_master_new
loadtime:2.6292161941528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harris' limit 1
loadtime:2.6292631626129 / seconds
Query Executed:select id FROM `nc` where city='Harris' && SIC_code='5461'DB:business_master_new
loadtime:2.6319961547852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harrisburg' limit 1
loadtime:2.6320431232452 / seconds
Query Executed:select id FROM `nc` where city='Harrisburg' && SIC_code='5461'DB:business_master_new
loadtime:2.6329309940338 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hassell' limit 1
loadtime:2.6329801082611 / seconds
Query Executed:select id FROM `nc` where city='Hassell' && SIC_code='5461'DB:business_master_new
loadtime:2.6366112232208 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatteras' limit 1
loadtime:2.6366460323334 / seconds
Query Executed:select id FROM `nc` where city='Hatteras' && SIC_code='5461'DB:business_master_new
loadtime:2.6373300552368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havelock' limit 1
loadtime:2.6373801231384 / seconds
Query Executed:select id FROM `nc` where city='Havelock' && SIC_code='5461'DB:business_master_new
loadtime:2.6383430957794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haw River' limit 1
loadtime:2.638402223587 / seconds
Query Executed:select id FROM `nc` where city='Haw River' && SIC_code='5461'DB:business_master_new
loadtime:2.639151096344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayesville' limit 1
loadtime:2.6392149925232 / seconds
Query Executed:select id FROM `nc` where city='Hayesville' && SIC_code='5461'DB:business_master_new
loadtime:2.6401240825653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hays' limit 1
loadtime:2.6401791572571 / seconds
Query Executed:select id FROM `nc` where city='Hays' && SIC_code='5461'DB:business_master_new
loadtime:2.6408290863037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazelwood' limit 1
loadtime:2.640878200531 / seconds
Query Executed:select id FROM `nc` where city='Hazelwood' && SIC_code='5461'DB:business_master_new
loadtime:2.6531372070312 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henderson' limit 1
loadtime:2.6531841754913 / seconds
Query Executed:select id FROM `nc` where city='Henderson' && SIC_code='5461'DB:business_master_new
loadtime:2.6549692153931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hendersonville' limit 1
loadtime:2.6550221443176 / seconds
Query Executed:select id FROM `nc` where city='Hendersonville' && SIC_code='5461'DB:business_master_new
loadtime:2.6625201702118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrico' limit 1
loadtime:2.6625690460205 / seconds
Query Executed:select id FROM `nc` where city='Henrico' && SIC_code='5461'DB:business_master_new
loadtime:2.6775619983673 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrietta' limit 1
loadtime:2.6776101589203 / seconds
Query Executed:select id FROM `nc` where city='Henrietta' && SIC_code='5461'DB:business_master_new
loadtime:2.6858131885529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hertford' limit 1
loadtime:2.6858651638031 / seconds
Query Executed:select id FROM `nc` where city='Hertford' && SIC_code='5461'DB:business_master_new
loadtime:2.6867451667786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hickory' limit 1
loadtime:2.6868200302124 / seconds
Query Executed:select id FROM `nc` where city='Hickory' && SIC_code='5461'DB:business_master_new
loadtime:2.6948461532593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiddenite' limit 1
loadtime:2.6949000358582 / seconds
Query Executed:select id FROM `nc` where city='Hiddenite' && SIC_code='5461'DB:business_master_new
loadtime:2.6955292224884 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Point' limit 1
loadtime:2.6955761909485 / seconds
Query Executed:select id FROM `nc` where city='High Point' && SIC_code='5461'DB:business_master_new
loadtime:2.7027721405029 / seconds
Query loaded from cache:select * from geodata_geocity where city='High Shoals' limit 1
loadtime:2.7028510570526 / seconds
Query Executed:select id FROM `nc` where city='High Shoals' && SIC_code='5461'DB:business_master_new
loadtime:2.7112190723419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highfalls' limit 1
loadtime:2.7112700939178 / seconds
Query Executed:select id FROM `nc` where city='Highfalls' && SIC_code='5461'DB:business_master_new
loadtime:2.7188501358032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highlands' limit 1
loadtime:2.7188971042633 / seconds
Query Executed:select id FROM `nc` where city='Highlands' && SIC_code='5461'DB:business_master_new
loadtime:2.719868183136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildebran' limit 1
loadtime:2.7199211120605 / seconds
Query Executed:select id FROM `nc` where city='Hildebran' && SIC_code='5461'DB:business_master_new
loadtime:2.7206680774689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsborough' limit 1
loadtime:2.7207190990448 / seconds
Query Executed:select id FROM `nc` where city='Hillsborough' && SIC_code='5461'DB:business_master_new
loadtime:2.72199010849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobbsville' limit 1
loadtime:2.7220392227173 / seconds
Query Executed:select id FROM `nc` where city='Hobbsville' && SIC_code='5461'DB:business_master_new
loadtime:2.7352521419525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobgood' limit 1
loadtime:2.7353022098541 / seconds
Query Executed:select id FROM `nc` where city='Hobgood' && SIC_code='5461'DB:business_master_new
loadtime:2.7485370635986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hobucken' limit 1
loadtime:2.7485780715942 / seconds
Query Executed:select id FROM `nc` where city='Hobucken' && SIC_code='5461'DB:business_master_new
loadtime:2.7508761882782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hoffman' limit 1
loadtime:2.7509272098541 / seconds
Query Executed:select id FROM `nc` where city='Hoffman' && SIC_code='5461'DB:business_master_new
loadtime:2.7616350650787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden Beach' limit 1
loadtime:2.761687040329 / seconds
Query Executed:select id FROM `nc` where city='Holden Beach' && SIC_code='5461'DB:business_master_new
loadtime:2.7692201137543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollister' limit 1
loadtime:2.7692670822144 / seconds
Query Executed:select id FROM `nc` where city='Hollister' && SIC_code='5461'DB:business_master_new
loadtime:2.7958281040192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Ridge' limit 1
loadtime:2.7958810329437 / seconds
Query Executed:select id FROM `nc` where city='Holly Ridge' && SIC_code='5461'DB:business_master_new
loadtime:2.7967531681061 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Springs' limit 1
loadtime:2.7968120574951 / seconds
Query Executed:select id FROM `nc` where city='Holly Springs' && SIC_code='5461'DB:business_master_new
loadtime:2.7977480888367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hookerton' limit 1
loadtime:2.7977921962738 / seconds
Query Executed:select id FROM `nc` where city='Hookerton' && SIC_code='5461'DB:business_master_new
loadtime:2.8220810890198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope Mills' limit 1
loadtime:2.82213306427 / seconds
Query Executed:select id FROM `nc` where city='Hope Mills' && SIC_code='5461'DB:business_master_new
loadtime:2.8241941928864 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horse Shoe' limit 1
loadtime:2.8242540359497 / seconds
Query Executed:select id FROM `nc` where city='Horse Shoe' && SIC_code='5461'DB:business_master_new
loadtime:2.8261420726776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hot Springs' limit 1
loadtime:2.8262600898743 / seconds
Query Executed:select id FROM `nc` where city='Hot Springs' && SIC_code='5461'DB:business_master_new
loadtime:2.8277630805969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hubert' limit 1
loadtime:2.8279302120209 / seconds
Query Executed:select id FROM `nc` where city='Hubert' && SIC_code='5461'DB:business_master_new
loadtime:2.8298850059509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hudson' limit 1
loadtime:2.8300402164459 / seconds
Query Executed:select id FROM `nc` where city='Hudson' && SIC_code='5461'DB:business_master_new
loadtime:2.8318841457367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntersville' limit 1
loadtime:2.832043170929 / seconds
Query Executed:select id FROM `nc` where city='Huntersville' && SIC_code='5461'DB:business_master_new
loadtime:2.836373090744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurdle Mills' limit 1
loadtime:2.8364360332489 / seconds
Query Executed:select id FROM `nc` where city='Hurdle Mills' && SIC_code='5461'DB:business_master_new
loadtime:2.8371810913086 / seconds
Query loaded from cache:select * from geodata_geocity where city='Icard' limit 1
loadtime:2.8372440338135 / seconds
Query Executed:select id FROM `nc` where city='Icard' && SIC_code='5461'DB:business_master_new
loadtime:2.8524100780487 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Trail' limit 1
loadtime:2.8524529933929 / seconds
Query Executed:select id FROM `nc` where city='Indian Trail' && SIC_code='5461'DB:business_master_new
loadtime:2.853588104248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Iron Station' limit 1
loadtime:2.8536400794983 / seconds
Query Executed:select id FROM `nc` where city='Iron Station' && SIC_code='5461'DB:business_master_new
loadtime:2.8543231487274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivanhoe' limit 1
loadtime:2.854367017746 / seconds
Query Executed:select id FROM `nc` where city='Ivanhoe' && SIC_code='5461'DB:business_master_new
loadtime:2.8675501346588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:2.8676011562347 / seconds
Query Executed:select id FROM `nc` where city='Jackson' && SIC_code='5461'DB:business_master_new
loadtime:2.8683090209961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson Springs' limit 1
loadtime:2.8683440685272 / seconds
Query Executed:select id FROM `nc` where city='Jackson Springs' && SIC_code='5461'DB:business_master_new
loadtime:2.8899321556091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:2.8899672031403 / seconds
Query Executed:select id FROM `nc` where city='Jacksonville' && SIC_code='5461'DB:business_master_new
loadtime:2.901535987854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamestown' limit 1
loadtime:2.9016020298004 / seconds
Query Executed:select id FROM `nc` where city='Jamestown' && SIC_code='5461'DB:business_master_new
loadtime:2.9025361537933 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jamesville' limit 1
loadtime:2.9025862216949 / seconds
Query Executed:select id FROM `nc` where city='Jamesville' && SIC_code='5461'DB:business_master_new
loadtime:2.9032142162323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jarvisburg' limit 1
loadtime:2.9032511711121 / seconds
Query Executed:select id FROM `nc` where city='Jarvisburg' && SIC_code='5461'DB:business_master_new
loadtime:2.9200170040131 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:2.9200630187988 / seconds
Query Executed:select id FROM `nc` where city='Jefferson' && SIC_code='5461'DB:business_master_new
loadtime:2.9208881855011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonas Ridge' limit 1
loadtime:2.9209320545197 / seconds
Query Executed:select id FROM `nc` where city='Jonas Ridge' && SIC_code='5461'DB:business_master_new
loadtime:2.9270620346069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jonesville' limit 1
loadtime:2.9271280765533 / seconds
Query Executed:select id FROM `nc` where city='Jonesville' && SIC_code='5461'DB:business_master_new
loadtime:2.9281661510468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Julian' limit 1
loadtime:2.928239107132 / seconds
Query Executed:select id FROM `nc` where city='Julian' && SIC_code='5461'DB:business_master_new
loadtime:2.9288802146912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kannapolis' limit 1
loadtime:2.9289259910583 / seconds
Query Executed:select id FROM `nc` where city='Kannapolis' && SIC_code='5461'DB:business_master_new
loadtime:2.930643081665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelford' limit 1
loadtime:2.9307191371918 / seconds
Query Executed:select id FROM `nc` where city='Kelford' && SIC_code='5461'DB:business_master_new
loadtime:2.9394521713257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kelly' limit 1
loadtime:2.9395232200623 / seconds
Query Executed:select id FROM `nc` where city='Kelly' && SIC_code='5461'DB:business_master_new
loadtime:2.9572582244873 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenansville' limit 1
loadtime:2.9573450088501 / seconds
Query Executed:select id FROM `nc` where city='Kenansville' && SIC_code='5461'DB:business_master_new
loadtime:2.9588680267334 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenly' limit 1
loadtime:2.9589161872864 / seconds
Query Executed:select id FROM `nc` where city='Kenly' && SIC_code='5461'DB:business_master_new
loadtime:2.9603090286255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kernersville' limit 1
loadtime:2.9603950977325 / seconds
Query Executed:select id FROM `nc` where city='Kernersville' && SIC_code='5461'DB:business_master_new
loadtime:2.9637141227722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kill Devil Hills' limit 1
loadtime:2.9637720584869 / seconds
Query Executed:select id FROM `nc` where city='Kill Devil Hills' && SIC_code='5461'DB:business_master_new
loadtime:2.965989112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='King' limit 1
loadtime:2.9660630226135 / seconds
Query Executed:select id FROM `nc` where city='King' && SIC_code='5461'DB:business_master_new
loadtime:2.9678862094879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kings Mountain' limit 1
loadtime:2.9679570198059 / seconds
Query Executed:select id FROM `nc` where city='Kings Mountain' && SIC_code='5461'DB:business_master_new
loadtime:2.9700469970703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingstown' limit 1
loadtime:2.9701020717621 / seconds
Query Executed:select id FROM `nc` where city='Kingstown' && SIC_code='5461'DB:business_master_new
loadtime:2.9704751968384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinston' limit 1
loadtime:2.9705140590668 / seconds
Query Executed:select id FROM `nc` where city='Kinston' && SIC_code='5461'DB:business_master_new
loadtime:2.97496509552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kipling' limit 1
loadtime:2.9750242233276 / seconds
Query Executed:select id FROM `nc` where city='Kipling' && SIC_code='5461'DB:business_master_new
loadtime:2.9810709953308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kittrell' limit 1
loadtime:2.9811160564423 / seconds
Query Executed:select id FROM `nc` where city='Kittrell' && SIC_code='5461'DB:business_master_new
loadtime:2.9825541973114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kitty Hawk' limit 1
loadtime:2.9826021194458 / seconds
Query Executed:select id FROM `nc` where city='Kitty Hawk' && SIC_code='5461'DB:business_master_new
loadtime:2.985591173172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knightdale' limit 1
loadtime:2.9856841564178 / seconds
Query Executed:select id FROM `nc` where city='Knightdale' && SIC_code='5461'DB:business_master_new
loadtime:2.9889490604401 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knotts Island' limit 1
loadtime:2.9891052246094 / seconds
Query Executed:select id FROM `nc` where city='Knotts Island' && SIC_code='5461'DB:business_master_new
loadtime:3.0088381767273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kure Beach' limit 1
loadtime:3.0088810920715 / seconds
Query Executed:select id FROM `nc` where city='Kure Beach' && SIC_code='5461'DB:business_master_new
loadtime:3.0100140571594 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Grange' limit 1
loadtime:3.0100622177124 / seconds
Query Executed:select id FROM `nc` where city='La Grange' && SIC_code='5461'DB:business_master_new
loadtime:3.012314081192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Junaluska' limit 1
loadtime:3.0123620033264 / seconds
Query Executed:select id FROM `nc` where city='Lake Junaluska' && SIC_code='5461'DB:business_master_new
loadtime:3.0436379909515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Lure' limit 1
loadtime:3.0437390804291 / seconds
Query Executed:select id FROM `nc` where city='Lake Lure' && SIC_code='5461'DB:business_master_new
loadtime:3.0459361076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Santeetlah' limit 1
loadtime:3.0459721088409 / seconds
Query Executed:select id FROM `nc` where city='Lake Santeetlah' && SIC_code='5461'DB:business_master_new
loadtime:3.0465140342712 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Toxaway' limit 1
loadtime:3.0465660095215 / seconds
Query Executed:select id FROM `nc` where city='Lake Toxaway' && SIC_code='5461'DB:business_master_new
loadtime:3.0484910011292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Waccamaw' limit 1
loadtime:3.0485332012177 / seconds
Query Executed:select id FROM `nc` where city='Lake Waccamaw' && SIC_code='5461'DB:business_master_new
loadtime:3.0501251220703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lakeview' limit 1
loadtime:3.0501730442047 / seconds
Query Executed:select id FROM `nc` where city='Lakeview' && SIC_code='5461'DB:business_master_new
loadtime:3.0581040382385 / seconds
Query loaded from cache:select * from geodata_geocity where city='Landis' limit 1
loadtime:3.058158159256 / seconds
Query Executed:select id FROM `nc` where city='Landis' && SIC_code='5461'DB:business_master_new
loadtime:3.0591750144958 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lansing' limit 1
loadtime:3.0592160224915 / seconds
Query Executed:select id FROM `nc` where city='Lansing' && SIC_code='5461'DB:business_master_new
loadtime:3.0601739883423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lasker' limit 1
loadtime:3.0602011680603 / seconds
Query Executed:select id FROM `nc` where city='Lasker' && SIC_code='5461'DB:business_master_new
loadtime:3.0608110427856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lattimore' limit 1
loadtime:3.0608530044556 / seconds
Query Executed:select id FROM `nc` where city='Lattimore' && SIC_code='5461'DB:business_master_new
loadtime:3.072573184967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Hill' limit 1
loadtime:3.0726480484009 / seconds
Query Executed:select id FROM `nc` where city='Laurel Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.0734071731567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurel Springs' limit 1
loadtime:3.0734481811523 / seconds
Query Executed:select id FROM `nc` where city='Laurel Springs' && SIC_code='5461'DB:business_master_new
loadtime:3.1050341129303 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laurinburg' limit 1
loadtime:3.1050720214844 / seconds
Query Executed:select id FROM `nc` where city='Laurinburg' && SIC_code='5461'DB:business_master_new
loadtime:3.1073250770569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawndale' limit 1
loadtime:3.1074080467224 / seconds
Query Executed:select id FROM `nc` where city='Lawndale' && SIC_code='5461'DB:business_master_new
loadtime:3.1086270809174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawsonville' limit 1
loadtime:3.1086671352386 / seconds
Query Executed:select id FROM `nc` where city='Lawsonville' && SIC_code='5461'DB:business_master_new
loadtime:3.1270270347595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leasburg' limit 1
loadtime:3.1270771026611 / seconds
Query Executed:select id FROM `nc` where city='Leasburg' && SIC_code='5461'DB:business_master_new
loadtime:3.1427421569824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leicester' limit 1
loadtime:3.1428101062775 / seconds
Query Executed:select id FROM `nc` where city='Leicester' && SIC_code='5461'DB:business_master_new
loadtime:3.1436212062836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leland' limit 1
loadtime:3.1436810493469 / seconds
Query Executed:select id FROM `nc` where city='Leland' && SIC_code='5461'DB:business_master_new
loadtime:3.1446721553802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lemon Springs' limit 1
loadtime:3.1447250843048 / seconds
Query Executed:select id FROM `nc` where city='Lemon Springs' && SIC_code='5461'DB:business_master_new
loadtime:3.1510810852051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lenoir' limit 1
loadtime:3.1511371135712 / seconds
Query Executed:select id FROM `nc` where city='Lenoir' && SIC_code='5461'DB:business_master_new
loadtime:3.1527190208435 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodville' limit 1
loadtime:3.1527681350708 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodville' && SIC_code='5461'DB:business_master_new
loadtime:3.1810441017151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston Woodvl' limit 1
loadtime:3.1810941696167 / seconds
Query Executed:select id FROM `nc` where city='Lewiston Woodvl' && SIC_code='5461'DB:business_master_new
loadtime:3.1815981864929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewisville' limit 1
loadtime:3.181645154953 / seconds
Query Executed:select id FROM `nc` where city='Lewisville' && SIC_code='5461'DB:business_master_new
loadtime:3.1825711727142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:3.1826510429382 / seconds
Query Executed:select id FROM `nc` where city='Lexington' && SIC_code='5461'DB:business_master_new
loadtime:3.1943590641022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Liberty' limit 1
loadtime:3.1944191455841 / seconds
Query Executed:select id FROM `nc` where city='Liberty' && SIC_code='5461'DB:business_master_new
loadtime:3.1953511238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lilesville' limit 1
loadtime:3.1953980922699 / seconds
Query Executed:select id FROM `nc` where city='Lilesville' && SIC_code='5461'DB:business_master_new
loadtime:3.2284250259399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lillington' limit 1
loadtime:3.2284660339355 / seconds
Query Executed:select id FROM `nc` where city='Lillington' && SIC_code='5461'DB:business_master_new
loadtime:3.2299580574036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincolnton' limit 1
loadtime:3.2300209999084 / seconds
Query Executed:select id FROM `nc` where city='Lincolnton' && SIC_code='5461'DB:business_master_new
loadtime:3.2314281463623 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:3.2314851284027 / seconds
Query Executed:select id FROM `nc` where city='Linden' && SIC_code='5461'DB:business_master_new
loadtime:3.2321510314941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville' limit 1
loadtime:3.2322061061859 / seconds
Query Executed:select id FROM `nc` where city='Linville' && SIC_code='5461'DB:business_master_new
loadtime:3.2328372001648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linville Falls' limit 1
loadtime:3.2328782081604 / seconds
Query Executed:select id FROM `nc` where city='Linville Falls' && SIC_code='5461'DB:business_master_new
loadtime:3.2401940822601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linwood' limit 1
loadtime:3.2402431964874 / seconds
Query Executed:select id FROM `nc` where city='Linwood' && SIC_code='5461'DB:business_master_new
loadtime:3.2408730983734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzerland' limit 1
loadtime:3.240923166275 / seconds
Query Executed:select id FROM `nc` where city='Little Switzerland' && SIC_code='5461'DB:business_master_new
loadtime:3.2491891384125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Little Switzrlnd' limit 1
loadtime:3.2492241859436 / seconds
Query Executed:select id FROM `nc` where city='Little Switzrlnd' && SIC_code='5461'DB:business_master_new
loadtime:3.2494711875916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Littleton' limit 1
loadtime:3.2495131492615 / seconds
Query Executed:select id FROM `nc` where city='Littleton' && SIC_code='5461'DB:business_master_new
loadtime:3.250333070755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust' limit 1
loadtime:3.2503809928894 / seconds
Query Executed:select id FROM `nc` where city='Locust' && SIC_code='5461'DB:business_master_new
loadtime:3.2510640621185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Longwood' limit 1
loadtime:3.2511031627655 / seconds
Query Executed:select id FROM `nc` where city='Longwood' && SIC_code='5461'DB:business_master_new
loadtime:3.2626981735229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisburg' limit 1
loadtime:3.2627491950989 / seconds
Query Executed:select id FROM `nc` where city='Louisburg' && SIC_code='5461'DB:business_master_new
loadtime:3.2638401985168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowell' limit 1
loadtime:3.2638862133026 / seconds
Query Executed:select id FROM `nc` where city='Lowell' && SIC_code='5461'DB:business_master_new
loadtime:3.2645871639252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowgap' limit 1
loadtime:3.2646310329437 / seconds
Query Executed:select id FROM `nc` where city='Lowgap' && SIC_code='5461'DB:business_master_new
loadtime:3.2905941009521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowland' limit 1
loadtime:3.2906510829926 / seconds
Query Executed:select id FROM `nc` where city='Lowland' && SIC_code='5461'DB:business_master_new
loadtime:3.2928261756897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lucama' limit 1
loadtime:3.2928771972656 / seconds
Query Executed:select id FROM `nc` where city='Lucama' && SIC_code='5461'DB:business_master_new
loadtime:3.293534040451 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumber Bridge' limit 1
loadtime:3.2935881614685 / seconds
Query Executed:select id FROM `nc` where city='Lumber Bridge' && SIC_code='5461'DB:business_master_new
loadtime:3.3135921955109 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lumberton' limit 1
loadtime:3.3136410713196 / seconds
Query Executed:select id FROM `nc` where city='Lumberton' && SIC_code='5461'DB:business_master_new
loadtime:3.3153281211853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:3.3153891563416 / seconds
Query Executed:select id FROM `nc` where city='Lynn' && SIC_code='5461'DB:business_master_new
loadtime:3.3246581554413 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macclesfield' limit 1
loadtime:3.3247001171112 / seconds
Query Executed:select id FROM `nc` where city='Macclesfield' && SIC_code='5461'DB:business_master_new
loadtime:3.3532440662384 / seconds
Query loaded from cache:select * from geodata_geocity where city='Macon' limit 1
loadtime:3.35329413414 / seconds
Query Executed:select id FROM `nc` where city='Macon' && SIC_code='5461'DB:business_master_new
loadtime:3.3657641410828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:3.3658230304718 / seconds
Query Executed:select id FROM `nc` where city='Madison' && SIC_code='5461'DB:business_master_new
loadtime:3.3667731285095 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maggie Valley' limit 1
loadtime:3.3668310642242 / seconds
Query Executed:select id FROM `nc` where city='Maggie Valley' && SIC_code='5461'DB:business_master_new
loadtime:3.3675761222839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:3.3676211833954 / seconds
Query Executed:select id FROM `nc` where city='Magnolia' && SIC_code='5461'DB:business_master_new
loadtime:3.3682851791382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maiden' limit 1
loadtime:3.3683211803436 / seconds
Query Executed:select id FROM `nc` where city='Maiden' && SIC_code='5461'DB:business_master_new
loadtime:3.3691310882568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mamers' limit 1
loadtime:3.3691840171814 / seconds
Query Executed:select id FROM `nc` where city='Mamers' && SIC_code='5461'DB:business_master_new
loadtime:3.3738641738892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manns Harbor' limit 1
loadtime:3.3739061355591 / seconds
Query Executed:select id FROM `nc` where city='Manns Harbor' && SIC_code='5461'DB:business_master_new
loadtime:3.3941781520844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manson' limit 1
loadtime:3.3942379951477 / seconds
Query Executed:select id FROM `nc` where city='Manson' && SIC_code='5461'DB:business_master_new
loadtime:3.4119851589203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manteo' limit 1
loadtime:3.4120321273804 / seconds
Query Executed:select id FROM `nc` where city='Manteo' && SIC_code='5461'DB:business_master_new
loadtime:3.41299700737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple' limit 1
loadtime:3.4130401611328 / seconds
Query Executed:select id FROM `nc` where city='Maple' && SIC_code='5461'DB:business_master_new
loadtime:3.4200642108917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maple Hill' limit 1
loadtime:3.4201052188873 / seconds
Query Executed:select id FROM `nc` where city='Maple Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.4434571266174 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marble' limit 1
loadtime:3.4435031414032 / seconds
Query Executed:select id FROM `nc` where city='Marble' && SIC_code='5461'DB:business_master_new
loadtime:3.4441812038422 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margarettsville' limit 1
loadtime:3.4442231655121 / seconds
Query Executed:select id FROM `nc` where city='Margarettsville' && SIC_code='5461'DB:business_master_new
loadtime:3.4478771686554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marietta' limit 1
loadtime:3.4479751586914 / seconds
Query Executed:select id FROM `nc` where city='Marietta' && SIC_code='5461'DB:business_master_new
loadtime:3.4503040313721 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:3.4503421783447 / seconds
Query Executed:select id FROM `nc` where city='Marion' && SIC_code='5461'DB:business_master_new
loadtime:3.451562166214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mars Hill' limit 1
loadtime:3.4516110420227 / seconds
Query Executed:select id FROM `nc` where city='Mars Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.4523510932922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshall' limit 1
loadtime:3.4523911476135 / seconds
Query Executed:select id FROM `nc` where city='Marshall' && SIC_code='5461'DB:business_master_new
loadtime:3.4532032012939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshallberg' limit 1
loadtime:3.4532430171967 / seconds
Query Executed:select id FROM `nc` where city='Marshallberg' && SIC_code='5461'DB:business_master_new
loadtime:3.4647161960602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marshville' limit 1
loadtime:3.4647581577301 / seconds
Query Executed:select id FROM `nc` where city='Marshville' && SIC_code='5461'DB:business_master_new
loadtime:3.465546131134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marston' limit 1
loadtime:3.4655930995941 / seconds
Query Executed:select id FROM `nc` where city='Marston' && SIC_code='5461'DB:business_master_new
loadtime:3.4760050773621 / seconds
Query loaded from cache:select * from geodata_geocity where city='Matthews' limit 1
loadtime:3.4760510921478 / seconds
Query Executed:select id FROM `nc` where city='Matthews' && SIC_code='5461'DB:business_master_new
loadtime:3.4866871833801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maury' limit 1
loadtime:3.4867660999298 / seconds
Query Executed:select id FROM `nc` where city='Maury' && SIC_code='5461'DB:business_master_new
loadtime:3.4951570034027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxton' limit 1
loadtime:3.4952201843262 / seconds
Query Executed:select id FROM `nc` where city='Maxton' && SIC_code='5461'DB:business_master_new
loadtime:3.4961030483246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayodan' limit 1
loadtime:3.496157169342 / seconds
Query Executed:select id FROM `nc` where city='Mayodan' && SIC_code='5461'DB:business_master_new
loadtime:3.4968190193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maysville' limit 1
loadtime:3.4968571662903 / seconds
Query Executed:select id FROM `nc` where city='Maysville' && SIC_code='5461'DB:business_master_new
loadtime:3.497533082962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Adenville' limit 1
loadtime:3.4975972175598 / seconds
Query Executed:select id FROM `nc` where city='Mc Adenville' && SIC_code='5461'DB:business_master_new
loadtime:3.5153381824493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Farlan' limit 1
loadtime:3.5153901576996 / seconds
Query Executed:select id FROM `nc` where city='Mc Farlan' && SIC_code='5461'DB:business_master_new
loadtime:3.5174961090088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Grady' limit 1
loadtime:3.5175452232361 / seconds
Query Executed:select id FROM `nc` where city='Mc Grady' && SIC_code='5461'DB:business_master_new
loadtime:3.524257183075 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Leansville' limit 1
loadtime:3.5243141651154 / seconds
Query Executed:select id FROM `nc` where city='Mc Leansville' && SIC_code='5461'DB:business_master_new
loadtime:3.5254402160645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccain' limit 1
loadtime:3.5254991054535 / seconds
Query Executed:select id FROM `nc` where city='Mccain' && SIC_code='5461'DB:business_master_new
loadtime:3.5260260105133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mccutcheon Field' limit 1
loadtime:3.5260541439056 / seconds
Query Executed:select id FROM `nc` where city='Mccutcheon Field' && SIC_code='5461'DB:business_master_new
loadtime:3.5290009975433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mebane' limit 1
loadtime:3.5290501117706 / seconds
Query Executed:select id FROM `nc` where city='Mebane' && SIC_code='5461'DB:business_master_new
loadtime:3.5304620265961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merritt' limit 1
loadtime:3.5305120944977 / seconds
Query Executed:select id FROM `nc` where city='Merritt' && SIC_code='5461'DB:business_master_new
loadtime:3.5377361774445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Merry Hill' limit 1
loadtime:3.5377922058105 / seconds
Query Executed:select id FROM `nc` where city='Merry Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.5551810264587 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micaville' limit 1
loadtime:3.5552229881287 / seconds
Query Executed:select id FROM `nc` where city='Micaville' && SIC_code='5461'DB:business_master_new
loadtime:3.5716731548309 / seconds
Query loaded from cache:select * from geodata_geocity where city='Micro' limit 1
loadtime:3.57173204422 / seconds
Query Executed:select id FROM `nc` where city='Micro' && SIC_code='5461'DB:business_master_new
loadtime:3.5817070007324 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middleburg' limit 1
loadtime:3.5817542076111 / seconds
Query Executed:select id FROM `nc` where city='Middleburg' && SIC_code='5461'DB:business_master_new
loadtime:3.5914812088013 / seconds
Query loaded from cache:select * from geodata_geocity where city='Middlesex' limit 1
loadtime:3.5915291309357 / seconds
Query Executed:select id FROM `nc` where city='Middlesex' && SIC_code='5461'DB:business_master_new
loadtime:3.5927760601044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland' limit 1
loadtime:3.5928361415863 / seconds
Query Executed:select id FROM `nc` where city='Midland' && SIC_code='5461'DB:business_master_new
loadtime:3.5942230224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway Park' limit 1
loadtime:3.5942590236664 / seconds
Query Executed:select id FROM `nc` where city='Midway Park' && SIC_code='5461'DB:business_master_new
loadtime:3.5952470302582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mill Spring' limit 1
loadtime:3.5953030586243 / seconds
Query Executed:select id FROM `nc` where city='Mill Spring' && SIC_code='5461'DB:business_master_new
loadtime:3.5961492061615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millers Creek' limit 1
loadtime:3.5961921215057 / seconds
Query Executed:select id FROM `nc` where city='Millers Creek' && SIC_code='5461'DB:business_master_new
loadtime:3.5975592136383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mills River' limit 1
loadtime:3.5975890159607 / seconds
Query Executed:select id FROM `nc` where city='Mills River' && SIC_code='5461'DB:business_master_new
loadtime:3.5988512039185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milton' limit 1
loadtime:3.5989000797272 / seconds
Query Executed:select id FROM `nc` where city='Milton' && SIC_code='5461'DB:business_master_new
loadtime:3.6096131801605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milwaukee' limit 1
loadtime:3.6096661090851 / seconds
Query Executed:select id FROM `nc` where city='Milwaukee' && SIC_code='5461'DB:business_master_new
loadtime:3.6100480556488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mineral Springs' limit 1
loadtime:3.6100871562958 / seconds
Query Executed:select id FROM `nc` where city='Mineral Springs' && SIC_code='5461'DB:business_master_new
loadtime:3.6205031871796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minneapolis' limit 1
loadtime:3.6205501556396 / seconds
Query Executed:select id FROM `nc` where city='Minneapolis' && SIC_code='5461'DB:business_master_new
loadtime:3.6237540245056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mint Hill' limit 1
loadtime:3.6237940788269 / seconds
Query Executed:select id FROM `nc` where city='Mint Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.6260600090027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Misenheimer' limit 1
loadtime:3.62610912323 / seconds
Query Executed:select id FROM `nc` where city='Misenheimer' && SIC_code='5461'DB:business_master_new
loadtime:3.6296901702881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mocksville' limit 1
loadtime:3.6297271251678 / seconds
Query Executed:select id FROM `nc` where city='Mocksville' && SIC_code='5461'DB:business_master_new
loadtime:3.6313970088959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moncure' limit 1
loadtime:3.6314470767975 / seconds
Query Executed:select id FROM `nc` where city='Moncure' && SIC_code='5461'DB:business_master_new
loadtime:3.632098197937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:3.6321380138397 / seconds
Query Executed:select id FROM `nc` where city='Monroe' && SIC_code='5461'DB:business_master_new
loadtime:3.6340510845184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma' limit 1
loadtime:3.6340980529785 / seconds
Query Executed:select id FROM `nc` where city='Montezuma' && SIC_code='5461'DB:business_master_new
loadtime:3.6416780948639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montreat' limit 1
loadtime:3.6417300701141 / seconds
Query Executed:select id FROM `nc` where city='Montreat' && SIC_code='5461'DB:business_master_new
loadtime:3.6525740623474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresboro' limit 1
loadtime:3.6526122093201 / seconds
Query Executed:select id FROM `nc` where city='Mooresboro' && SIC_code='5461'DB:business_master_new
loadtime:3.653293132782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresville' limit 1
loadtime:3.6533401012421 / seconds
Query Executed:select id FROM `nc` where city='Mooresville' && SIC_code='5461'DB:business_master_new
loadtime:3.6612010002136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moravian Falls' limit 1
loadtime:3.6612620353699 / seconds
Query Executed:select id FROM `nc` where city='Moravian Falls' && SIC_code='5461'DB:business_master_new
loadtime:3.6619172096252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morehead City' limit 1
loadtime:3.6619670391083 / seconds
Query Executed:select id FROM `nc` where city='Morehead City' && SIC_code='5461'DB:business_master_new
loadtime:3.6634640693665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morganton' limit 1
loadtime:3.663526058197 / seconds
Query Executed:select id FROM `nc` where city='Morganton' && SIC_code='5461'DB:business_master_new
loadtime:3.6653640270233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morrisville' limit 1
loadtime:3.6654231548309 / seconds
Query Executed:select id FROM `nc` where city='Morrisville' && SIC_code='5461'DB:business_master_new
loadtime:3.6671161651611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morven' limit 1
loadtime:3.6671760082245 / seconds
Query Executed:select id FROM `nc` where city='Morven' && SIC_code='5461'DB:business_master_new
loadtime:3.6949651241302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Airy' limit 1
loadtime:3.6950151920319 / seconds
Query Executed:select id FROM `nc` where city='Mount Airy' && SIC_code='5461'DB:business_master_new
loadtime:3.6967620849609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Gilead' limit 1
loadtime:3.6968309879303 / seconds
Query Executed:select id FROM `nc` where city='Mount Gilead' && SIC_code='5461'DB:business_master_new
loadtime:3.6975882053375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Holly' limit 1
loadtime:3.6976320743561 / seconds
Query Executed:select id FROM `nc` where city='Mount Holly' && SIC_code='5461'DB:business_master_new
loadtime:3.698637008667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Mourne' limit 1
loadtime:3.6986880302429 / seconds
Query Executed:select id FROM `nc` where city='Mount Mourne' && SIC_code='5461'DB:business_master_new
loadtime:3.7082722187042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:3.7083220481873 / seconds
Query Executed:select id FROM `nc` where city='Mount Olive' && SIC_code='5461'DB:business_master_new
loadtime:3.7093291282654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:3.7093720436096 / seconds
Query Executed:select id FROM `nc` where city='Mount Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:3.7101471424103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Ulla' limit 1
loadtime:3.7102091312408 / seconds
Query Executed:select id FROM `nc` where city='Mount Ulla' && SIC_code='5461'DB:business_master_new
loadtime:3.7394261360168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:3.7394731044769 / seconds
Query Executed:select id FROM `nc` where city='Mountain Home' && SIC_code='5461'DB:business_master_new
loadtime:3.7530930042267 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moyock' limit 1
loadtime:3.7531371116638 / seconds
Query Executed:select id FROM `nc` where city='Moyock' && SIC_code='5461'DB:business_master_new
loadtime:3.7538850307465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Airy' limit 1
loadtime:3.7539341449738 / seconds
Query Executed:select id FROM `nc` where city='Mt Airy' && SIC_code='5461'DB:business_master_new
loadtime:3.76243019104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Gilead' limit 1
loadtime:3.762481212616 / seconds
Query Executed:select id FROM `nc` where city='Mt Gilead' && SIC_code='5461'DB:business_master_new
loadtime:3.7634952068329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Holly' limit 1
loadtime:3.7635440826416 / seconds
Query Executed:select id FROM `nc` where city='Mt Holly' && SIC_code='5461'DB:business_master_new
loadtime:3.7749130725861 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Mourne' limit 1
loadtime:3.7749621868134 / seconds
Query Executed:select id FROM `nc` where city='Mt Mourne' && SIC_code='5461'DB:business_master_new
loadtime:3.7752411365509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:3.775279045105 / seconds
Query Executed:select id FROM `nc` where city='Mt Olive' && SIC_code='5461'DB:business_master_new
loadtime:3.7771830558777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:3.7772212028503 / seconds
Query Executed:select id FROM `nc` where city='Mt Pleasant' && SIC_code='5461'DB:business_master_new
loadtime:3.7848742008209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Ulla' limit 1
loadtime:3.784900188446 / seconds
Query Executed:select id FROM `nc` where city='Mt Ulla' && SIC_code='5461'DB:business_master_new
loadtime:3.7851710319519 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murfreesboro' limit 1
loadtime:3.785206079483 / seconds
Query Executed:select id FROM `nc` where city='Murfreesboro' && SIC_code='5461'DB:business_master_new
loadtime:3.7859880924225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murphy' limit 1
loadtime:3.7860381603241 / seconds
Query Executed:select id FROM `nc` where city='Murphy' && SIC_code='5461'DB:business_master_new
loadtime:3.7872312068939 / seconds
Query loaded from cache:select * from geodata_geocity where city='N Topsail Beach' limit 1
loadtime:3.7872650623322 / seconds
Query Executed:select id FROM `nc` where city='N Topsail Beach' && SIC_code='5461'DB:business_master_new
loadtime:3.788024187088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nags Head' limit 1
loadtime:3.7880630493164 / seconds
Query Executed:select id FROM `nc` where city='Nags Head' && SIC_code='5461'DB:business_master_new
loadtime:3.788999080658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nakina' limit 1
loadtime:3.7890341281891 / seconds
Query Executed:select id FROM `nc` where city='Nakina' && SIC_code='5461'DB:business_master_new
loadtime:3.8043901920319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Naples' limit 1
loadtime:3.8044281005859 / seconds
Query Executed:select id FROM `nc` where city='Naples' && SIC_code='5461'DB:business_master_new
loadtime:3.8165941238403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nashville' limit 1
loadtime:3.8166291713715 / seconds
Query Executed:select id FROM `nc` where city='Nashville' && SIC_code='5461'DB:business_master_new
loadtime:3.8175511360168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Navassa' limit 1
loadtime:3.8175940513611 / seconds
Query Executed:select id FROM `nc` where city='Navassa' && SIC_code='5461'DB:business_master_new
loadtime:3.8192870616913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nebo' limit 1
loadtime:3.8193211555481 / seconds
Query Executed:select id FROM `nc` where city='Nebo' && SIC_code='5461'DB:business_master_new
loadtime:3.8209490776062 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Bern' limit 1
loadtime:3.8210310935974 / seconds
Query Executed:select id FROM `nc` where city='New Bern' && SIC_code='5461'DB:business_master_new
loadtime:3.8361401557922 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hill' limit 1
loadtime:3.8361880779266 / seconds
Query Executed:select id FROM `nc` where city='New Hill' && SIC_code='5461'DB:business_master_new
loadtime:3.8694801330566 / seconds
Query loaded from cache:select * from geodata_geocity where city='New London' limit 1
loadtime:3.869518995285 / seconds
Query Executed:select id FROM `nc` where city='New London' && SIC_code='5461'DB:business_master_new
loadtime:3.8702480792999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newell' limit 1
loadtime:3.8702840805054 / seconds
Query Executed:select id FROM `nc` where city='Newell' && SIC_code='5461'DB:business_master_new
loadtime:3.8859810829163 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newland' limit 1
loadtime:3.8860352039337 / seconds
Query Executed:select id FROM `nc` where city='Newland' && SIC_code='5461'DB:business_master_new
loadtime:3.8869121074677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newport' limit 1
loadtime:3.8869600296021 / seconds
Query Executed:select id FROM `nc` where city='Newport' && SIC_code='5461'DB:business_master_new
loadtime:3.8879001140594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:3.8879580497742 / seconds
Query Executed:select id FROM `nc` where city='Newton' && SIC_code='5461'DB:business_master_new
loadtime:3.8894531726837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton Grove' limit 1
loadtime:3.8895070552826 / seconds
Query Executed:select id FROM `nc` where city='Newton Grove' && SIC_code='5461'DB:business_master_new
loadtime:3.8902502059937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norlina' limit 1
loadtime:3.8903071880341 / seconds
Query Executed:select id FROM `nc` where city='Norlina' && SIC_code='5461'DB:business_master_new
loadtime:3.8909530639648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norman' limit 1
loadtime:3.8909912109375 / seconds
Query Executed:select id FROM `nc` where city='Norman' && SIC_code='5461'DB:business_master_new
loadtime:3.895327091217 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Wilkesboro' limit 1
loadtime:3.8953680992126 / seconds
Query Executed:select id FROM `nc` where city='North Wilkesboro' && SIC_code='5461'DB:business_master_new
loadtime:3.8968691825867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Norwood' limit 1
loadtime:3.8969271183014 / seconds
Query Executed:select id FROM `nc` where city='Norwood' && SIC_code='5461'DB:business_master_new
loadtime:3.8976302146912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:3.8976759910583 / seconds
Query Executed:select id FROM `nc` where city='Oak City' && SIC_code='5461'DB:business_master_new
loadtime:3.9129521846771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Island' limit 1
loadtime:3.9130082130432 / seconds
Query Executed:select id FROM `nc` where city='Oak Island' && SIC_code='5461'DB:business_master_new
loadtime:3.9138422012329 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Ridge' limit 1
loadtime:3.9138920307159 / seconds
Query Executed:select id FROM `nc` where city='Oak Ridge' && SIC_code='5461'DB:business_master_new
loadtime:3.91463804245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakboro' limit 1
loadtime:3.9146730899811 / seconds
Query Executed:select id FROM `nc` where city='Oakboro' && SIC_code='5461'DB:business_master_new
loadtime:3.9154481887817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocean Isle Beach' limit 1
loadtime:3.9156060218811 / seconds
Query Executed:select id FROM `nc` where city='Ocean Isle Beach' && SIC_code='5461'DB:business_master_new
loadtime:3.91663813591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ocracoke' limit 1
loadtime:3.9166970252991 / seconds
Query Executed:select id FROM `nc` where city='Ocracoke' && SIC_code='5461'DB:business_master_new
loadtime:3.917417049408 / seconds
Query loaded from cache:select * from geodata_geocity where city='Old Fort' limit 1
loadtime:3.9174671173096 / seconds
Query Executed:select id FROM `nc` where city='Old Fort' && SIC_code='5461'DB:business_master_new
loadtime:3.9181990623474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olin' limit 1
loadtime:3.9182472229004 / seconds
Query Executed:select id FROM `nc` where city='Olin' && SIC_code='5461'DB:business_master_new
loadtime:3.931401014328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Olivia' limit 1
loadtime:3.931449174881 / seconds
Query Executed:select id FROM `nc` where city='Olivia' && SIC_code='5461'DB:business_master_new
loadtime:3.9496130943298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oriental' limit 1
loadtime:3.9496660232544 / seconds
Query Executed:select id FROM `nc` where city='Oriental' && SIC_code='5461'DB:business_master_new
loadtime:3.950376033783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orrum' limit 1
loadtime:3.9504270553589 / seconds
Query Executed:select id FROM `nc` where city='Orrum' && SIC_code='5461'DB:business_master_new
loadtime:3.9640262126923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Otto' limit 1
loadtime:3.964075088501 / seconds
Query Executed:select id FROM `nc` where city='Otto' && SIC_code='5461'DB:business_master_new
loadtime:3.9863510131836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:3.9864292144775 / seconds
Query Executed:select id FROM `nc` where city='Oxford' && SIC_code='5461'DB:business_master_new
loadtime:3.9876770973206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pantego' limit 1
loadtime:3.9877231121063 / seconds
Query Executed:select id FROM `nc` where city='Pantego' && SIC_code='5461'DB:business_master_new
loadtime:3.9884312152863 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parkton' limit 1
loadtime:3.988468170166 / seconds
Query Executed:select id FROM `nc` where city='Parkton' && SIC_code='5461'DB:business_master_new
loadtime:3.9897410869598 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parmele' limit 1
loadtime:3.989785194397 / seconds
Query Executed:select id FROM `nc` where city='Parmele' && SIC_code='5461'DB:business_master_new
loadtime:3.9921162128448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Patterson' limit 1
loadtime:3.992161989212 / seconds
Query Executed:select id FROM `nc` where city='Patterson' && SIC_code='5461'DB:business_master_new
loadtime:3.999941110611 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paw Creek' limit 1
loadtime:3.9999949932098 / seconds
Query Executed:select id FROM `nc` where city='Paw Creek' && SIC_code='5461'DB:business_master_new
loadtime:4.0171530246735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peachland' limit 1
loadtime:4.0172162055969 / seconds
Query Executed:select id FROM `nc` where city='Peachland' && SIC_code='5461'DB:business_master_new
loadtime:4.0179250240326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:4.0179719924927 / seconds
Query Executed:select id FROM `nc` where city='Pelham' && SIC_code='5461'DB:business_master_new
loadtime:4.0185701847076 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pembroke' limit 1
loadtime:4.0186011791229 / seconds
Query Executed:select id FROM `nc` where city='Pembroke' && SIC_code='5461'DB:business_master_new
loadtime:4.0194201469421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pendleton' limit 1
loadtime:4.0194661617279 / seconds
Query Executed:select id FROM `nc` where city='Pendleton' && SIC_code='5461'DB:business_master_new
loadtime:4.0253970623016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penland' limit 1
loadtime:4.0254530906677 / seconds
Query Executed:select id FROM `nc` where city='Penland' && SIC_code='5461'DB:business_master_new
loadtime:4.0297281742096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Penrose' limit 1
loadtime:4.0297570228577 / seconds
Query Executed:select id FROM `nc` where city='Penrose' && SIC_code='5461'DB:business_master_new
loadtime:4.045686006546 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pfafftown' limit 1
loadtime:4.0457730293274 / seconds
Query Executed:select id FROM `nc` where city='Pfafftown' && SIC_code='5461'DB:business_master_new
loadtime:4.0466270446777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pikeville' limit 1
loadtime:4.0466721057892 / seconds
Query Executed:select id FROM `nc` where city='Pikeville' && SIC_code='5461'DB:business_master_new
loadtime:4.0473501682281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pilot Mountain' limit 1
loadtime:4.0473830699921 / seconds
Query Executed:select id FROM `nc` where city='Pilot Mountain' && SIC_code='5461'DB:business_master_new
loadtime:4.0482351779938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hall' limit 1
loadtime:4.04829621315 / seconds
Query Executed:select id FROM `nc` where city='Pine Hall' && SIC_code='5461'DB:business_master_new
loadtime:4.056282043457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Knoll Shrs' limit 1
loadtime:4.056312084198 / seconds
Query Executed:select id FROM `nc` where city='Pine Knoll Shrs' && SIC_code='5461'DB:business_master_new
loadtime:4.0579340457916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Level' limit 1
loadtime:4.0579741001129 / seconds
Query Executed:select id FROM `nc` where city='Pine Level' && SIC_code='5461'DB:business_master_new
loadtime:4.0586090087891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinebluff' limit 1
loadtime:4.0586330890656 / seconds
Query Executed:select id FROM `nc` where city='Pinebluff' && SIC_code='5461'DB:business_master_new
loadtime:4.0592241287231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinehurst' limit 1
loadtime:4.0592601299286 / seconds
Query Executed:select id FROM `nc` where city='Pinehurst' && SIC_code='5461'DB:business_master_new
loadtime:4.0605170726776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineola' limit 1
loadtime:4.0605511665344 / seconds
Query Executed:select id FROM `nc` where city='Pineola' && SIC_code='5461'DB:business_master_new
loadtime:4.0702431201935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetops' limit 1
loadtime:4.0702810287476 / seconds
Query Executed:select id FROM `nc` where city='Pinetops' && SIC_code='5461'DB:business_master_new
loadtime:4.0709471702576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinetown' limit 1
loadtime:4.0709700584412 / seconds
Query Executed:select id FROM `nc` where city='Pinetown' && SIC_code='5461'DB:business_master_new
loadtime:4.0715579986572 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pineville' limit 1
loadtime:4.0715930461884 / seconds
Query Executed:select id FROM `nc` where city='Pineville' && SIC_code='5461'DB:business_master_new
loadtime:4.0730412006378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piney Creek' limit 1
loadtime:4.0730981826782 / seconds
Query Executed:select id FROM `nc` where city='Piney Creek' && SIC_code='5461'DB:business_master_new
loadtime:4.0892980098724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pink Hill' limit 1
loadtime:4.0893321037292 / seconds
Query Executed:select id FROM `nc` where city='Pink Hill' && SIC_code='5461'DB:business_master_new
loadtime:4.0900661945343 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinnacle' limit 1
loadtime:4.0901021957397 / seconds
Query Executed:select id FROM `nc` where city='Pinnacle' && SIC_code='5461'DB:business_master_new
loadtime:4.0907511711121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah Forest' limit 1
loadtime:4.0907831192017 / seconds
Query Executed:select id FROM `nc` where city='Pisgah Forest' && SIC_code='5461'DB:business_master_new
loadtime:4.0915060043335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsboro' limit 1
loadtime:4.091539144516 / seconds
Query Executed:select id FROM `nc` where city='Pittsboro' && SIC_code='5461'DB:business_master_new
loadtime:4.0925731658936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Garden' limit 1
loadtime:4.0926191806793 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Garden' && SIC_code='5461'DB:business_master_new
loadtime:4.0933210849762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Hill' limit 1
loadtime:4.093355178833 / seconds
Query Executed:select id FROM `nc` where city='Pleasant Hill' && SIC_code='5461'DB:business_master_new
loadtime:4.0982069969177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plumtree' limit 1
loadtime:4.0982360839844 / seconds
Query Executed:select id FROM `nc` where city='Plumtree' && SIC_code='5461'DB:business_master_new
loadtime:4.1033232212067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:4.1033592224121 / seconds
Query Executed:select id FROM `nc` where city='Plymouth' && SIC_code='5461'DB:business_master_new
loadtime:4.1041941642761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Harbor' limit 1
loadtime:4.1042342185974 / seconds
Query Executed:select id FROM `nc` where city='Point Harbor' && SIC_code='5461'DB:business_master_new
loadtime:4.1048231124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkton' limit 1
loadtime:4.1048581600189 / seconds
Query Executed:select id FROM `nc` where city='Polkton' && SIC_code='5461'DB:business_master_new
loadtime:4.105476140976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Polkville' limit 1
loadtime:4.1055011749268 / seconds
Query Executed:select id FROM `nc` where city='Polkville' && SIC_code='5461'DB:business_master_new
loadtime:4.116669178009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pollocksville' limit 1
loadtime:4.1167039871216 / seconds
Query Executed:select id FROM `nc` where city='Pollocksville' && SIC_code='5461'DB:business_master_new
loadtime:4.1173570156097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope A F B' limit 1
loadtime:4.1173801422119 / seconds
Query Executed:select id FROM `nc` where city='Pope A F B' && SIC_code='5461'DB:business_master_new
loadtime:4.1176331043243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pope Afb' limit 1
loadtime:4.1176700592041 / seconds
Query Executed:select id FROM `nc` where city='Pope Afb' && SIC_code='5461'DB:business_master_new
loadtime:4.1202201843262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Poplar Branch' limit 1
loadtime:4.1202621459961 / seconds
Query Executed:select id FROM `nc` where city='Poplar Branch' && SIC_code='5461'DB:business_master_new
loadtime:4.1323530673981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Potecasi' limit 1
loadtime:4.132404088974 / seconds
Query Executed:select id FROM `nc` where city='Potecasi' && SIC_code='5461'DB:business_master_new
loadtime:4.1343381404877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powells Point' limit 1
loadtime:4.1343910694122 / seconds
Query Executed:select id FROM `nc` where city='Powells Point' && SIC_code='5461'DB:business_master_new
loadtime:4.1350951194763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Powellsville' limit 1
loadtime:4.1351389884949 / seconds
Query Executed:select id FROM `nc` where city='Powellsville' && SIC_code='5461'DB:business_master_new
loadtime:4.1383290290833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:4.1383771896362 / seconds
Query Executed:select id FROM `nc` where city='Princeton' && SIC_code='5461'DB:business_master_new
loadtime:4.1391351222992 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeville' limit 1
loadtime:4.1391839981079 / seconds
Query Executed:select id FROM `nc` where city='Princeville' && SIC_code='5461'DB:business_master_new
loadtime:4.1394391059875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Proctorville' limit 1
loadtime:4.139475107193 / seconds
Query Executed:select id FROM `nc` where city='Proctorville' && SIC_code='5461'DB:business_master_new
loadtime:4.1435739994049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prospect Hill' limit 1
loadtime:4.1436161994934 / seconds
Query Executed:select id FROM `nc` where city='Prospect Hill' && SIC_code='5461'DB:business_master_new
loadtime:4.1570692062378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:4.1571221351624 / seconds
Query Executed:select id FROM `nc` where city='Providence' && SIC_code='5461'DB:business_master_new
loadtime:4.1728720664978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Purlear' limit 1
loadtime:4.1729261875153 / seconds
Query Executed:select id FROM `nc` where city='Purlear' && SIC_code='5461'DB:business_master_new
loadtime:4.1921141147614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raeford' limit 1
loadtime:4.1921570301056 / seconds
Query Executed:select id FROM `nc` where city='Raeford' && SIC_code='5461'DB:business_master_new
loadtime:4.1931581497192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Raleigh' limit 1
loadtime:4.1932051181793 / seconds
Query Executed:select id FROM `nc` where city='Raleigh' && SIC_code='5461'DB:business_master_new
loadtime:4.2010819911957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramseur' limit 1
loadtime:4.2011950016022 / seconds
Query Executed:select id FROM `nc` where city='Ramseur' && SIC_code='5461'DB:business_master_new
loadtime:4.2019650936127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randleman' limit 1
loadtime:4.2020170688629 / seconds
Query Executed:select id FROM `nc` where city='Randleman' && SIC_code='5461'DB:business_master_new
loadtime:4.2029740810394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Oak' limit 1
loadtime:4.2030260562897 / seconds
Query Executed:select id FROM `nc` where city='Red Oak' && SIC_code='5461'DB:business_master_new
loadtime:4.2107110023499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Springs' limit 1
loadtime:4.2109961509705 / seconds
Query Executed:select id FROM `nc` where city='Red Springs' && SIC_code='5461'DB:business_master_new
loadtime:4.2117872238159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reidsville' limit 1
loadtime:4.2118451595306 / seconds
Query Executed:select id FROM `nc` where city='Reidsville' && SIC_code='5461'DB:business_master_new
loadtime:4.2135181427002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Resrch Trngle Pk' limit 1
loadtime:4.2135720252991 / seconds
Query Executed:select id FROM `nc` where city='Resrch Trngle Pk' && SIC_code='5461'DB:business_master_new
loadtime:4.2173490524292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rex' limit 1
loadtime:4.2174031734467 / seconds
Query Executed:select id FROM `nc` where city='Rex' && SIC_code='5461'DB:business_master_new
loadtime:4.218857049942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rhodhiss' limit 1
loadtime:4.218887090683 / seconds
Query Executed:select id FROM `nc` where city='Rhodhiss' && SIC_code='5461'DB:business_master_new
loadtime:4.2223150730133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rich Square' limit 1
loadtime:4.2223660945892 / seconds
Query Executed:select id FROM `nc` where city='Rich Square' && SIC_code='5461'DB:business_master_new
loadtime:4.2230191230774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:4.2230741977692 / seconds
Query Executed:select id FROM `nc` where city='Richfield' && SIC_code='5461'DB:business_master_new
loadtime:4.2237300872803 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richlands' limit 1
loadtime:4.2237582206726 / seconds
Query Executed:select id FROM `nc` where city='Richlands' && SIC_code='5461'DB:business_master_new
loadtime:4.2246031761169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgecrest' limit 1
loadtime:4.224641084671 / seconds
Query Executed:select id FROM `nc` where city='Ridgecrest' && SIC_code='5461'DB:business_master_new
loadtime:4.230042219162 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ridgeway' limit 1
loadtime:4.2300841808319 / seconds
Query Executed:select id FROM `nc` where city='Ridgeway' && SIC_code='5461'DB:business_master_new
loadtime:4.2312960624695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riegelwood' limit 1
loadtime:4.2313280105591 / seconds
Query Executed:select id FROM `nc` where city='Riegelwood' && SIC_code='5461'DB:business_master_new
loadtime:4.2320120334625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke Rapids' limit 1
loadtime:4.2320580482483 / seconds
Query Executed:select id FROM `nc` where city='Roanoke Rapids' && SIC_code='5461'DB:business_master_new
loadtime:4.2335150241852 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring Gap' limit 1
loadtime:4.2335560321808 / seconds
Query Executed:select id FROM `nc` where city='Roaring Gap' && SIC_code='5461'DB:business_master_new
loadtime:4.2450520992279 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roaring River' limit 1
loadtime:4.2451031208038 / seconds
Query Executed:select id FROM `nc` where city='Roaring River' && SIC_code='5461'DB:business_master_new
loadtime:4.2457680702209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbins' limit 1
loadtime:4.2458510398865 / seconds
Query Executed:select id FROM `nc` where city='Robbins' && SIC_code='5461'DB:business_master_new
loadtime:4.2465550899506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robbinsville' limit 1
loadtime:4.2466180324554 / seconds
Query Executed:select id FROM `nc` where city='Robbinsville' && SIC_code='5461'DB:business_master_new
loadtime:4.2474381923676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robersonville' limit 1
loadtime:4.2474770545959 / seconds
Query Executed:select id FROM `nc` where city='Robersonville' && SIC_code='5461'DB:business_master_new
loadtime:4.2481920719147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockingham' limit 1
loadtime:4.2482450008392 / seconds
Query Executed:select id FROM `nc` where city='Rockingham' && SIC_code='5461'DB:business_master_new
loadtime:4.2497701644897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockwell' limit 1
loadtime:4.2498681545258 / seconds
Query Executed:select id FROM `nc` where city='Rockwell' && SIC_code='5461'DB:business_master_new
loadtime:4.2506330013275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Mount' limit 1
loadtime:4.2506999969482 / seconds
Query Executed:select id FROM `nc` where city='Rocky Mount' && SIC_code='5461'DB:business_master_new
loadtime:4.2582240104675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rocky Point' limit 1
loadtime:4.2582750320435 / seconds
Query Executed:select id FROM `nc` where city='Rocky Point' && SIC_code='5461'DB:business_master_new
loadtime:4.2590141296387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rodanthe' limit 1
loadtime:4.2590720653534 / seconds
Query Executed:select id FROM `nc` where city='Rodanthe' && SIC_code='5461'DB:business_master_new
loadtime:4.2808921337128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roduco' limit 1
loadtime:4.2809340953827 / seconds
Query Executed:select id FROM `nc` where city='Roduco' && SIC_code='5461'DB:business_master_new
loadtime:4.2812700271606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rolesville' limit 1
loadtime:4.2813200950623 / seconds
Query Executed:select id FROM `nc` where city='Rolesville' && SIC_code='5461'DB:business_master_new
loadtime:4.2820041179657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ronda' limit 1
loadtime:4.2820451259613 / seconds
Query Executed:select id FROM `nc` where city='Ronda' && SIC_code='5461'DB:business_master_new
loadtime:4.2827160358429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roper' limit 1
loadtime:4.2827651500702 / seconds
Query Executed:select id FROM `nc` where city='Roper' && SIC_code='5461'DB:business_master_new
loadtime:4.2834441661835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rose Hill' limit 1
loadtime:4.2834939956665 / seconds
Query Executed:select id FROM `nc` where city='Rose Hill' && SIC_code='5461'DB:business_master_new
loadtime:4.2842841148376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roseboro' limit 1
loadtime:4.2843420505524 / seconds
Query Executed:select id FROM `nc` where city='Roseboro' && SIC_code='5461'DB:business_master_new
loadtime:4.2851581573486 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rosman' limit 1
loadtime:4.2851941585541 / seconds
Query Executed:select id FROM `nc` where city='Rosman' && SIC_code='5461'DB:business_master_new
loadtime:4.2858312129974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rougemont' limit 1
loadtime:4.2858810424805 / seconds
Query Executed:select id FROM `nc` where city='Rougemont' && SIC_code='5461'DB:business_master_new
loadtime:4.2865650653839 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rowland' limit 1
loadtime:4.2866060733795 / seconds
Query Executed:select id FROM `nc` where city='Rowland' && SIC_code='5461'DB:business_master_new
loadtime:4.2873220443726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxboro' limit 1
loadtime:4.287379026413 / seconds
Query Executed:select id FROM `nc` where city='Roxboro' && SIC_code='5461'DB:business_master_new
loadtime:4.2890291213989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roxobel' limit 1
loadtime:4.2890770435333 / seconds
Query Executed:select id FROM `nc` where city='Roxobel' && SIC_code='5461'DB:business_master_new
loadtime:4.2985110282898 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ruffin' limit 1
loadtime:4.2985692024231 / seconds
Query Executed:select id FROM `nc` where city='Ruffin' && SIC_code='5461'DB:business_master_new
loadtime:4.299252986908 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rural Hall' limit 1
loadtime:4.2993001937866 / seconds
Query Executed:select id FROM `nc` where city='Rural Hall' && SIC_code='5461'DB:business_master_new
loadtime:4.3000659942627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford Clg' limit 1
loadtime:4.3001070022583 / seconds
Query Executed:select id FROM `nc` where city='Rutherford Clg' && SIC_code='5461'DB:business_master_new
loadtime:4.3011181354523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherford College' limit 1
loadtime:4.3011651039124 / seconds
Query Executed:select id FROM `nc` where city='Rutherford College' && SIC_code='5461'DB:business_master_new
loadtime:4.3194940090179 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutherfordton' limit 1
loadtime:4.3195300102234 / seconds
Query Executed:select id FROM `nc` where city='Rutherfordton' && SIC_code='5461'DB:business_master_new
loadtime:4.3216240406036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Pauls' limit 1
loadtime:4.3217821121216 / seconds
Query Executed:select id FROM `nc` where city='Saint Pauls' && SIC_code='5461'DB:business_master_new
loadtime:4.3228430747986 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salemburg' limit 1
loadtime:4.3228859901428 / seconds
Query Executed:select id FROM `nc` where city='Salemburg' && SIC_code='5461'DB:business_master_new
loadtime:4.3235352039337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salisbury' limit 1
loadtime:4.3235950469971 / seconds
Query Executed:select id FROM `nc` where city='Salisbury' && SIC_code='5461'DB:business_master_new
loadtime:4.331404209137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salter Path' limit 1
loadtime:4.3314650058746 / seconds
Query Executed:select id FROM `nc` where city='Salter Path' && SIC_code='5461'DB:business_master_new
loadtime:4.3520150184631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saluda' limit 1
loadtime:4.3520600795746 / seconds
Query Executed:select id FROM `nc` where city='Saluda' && SIC_code='5461'DB:business_master_new
loadtime:4.3528261184692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salvo' limit 1
loadtime:4.3528831005096 / seconds
Query Executed:select id FROM `nc` where city='Salvo' && SIC_code='5461'DB:business_master_new
loadtime:4.366886138916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy Ridge' limit 1
loadtime:4.3669390678406 / seconds
Query Executed:select id FROM `nc` where city='Sandy Ridge' && SIC_code='5461'DB:business_master_new
loadtime:4.3875091075897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sanford' limit 1
loadtime:4.3875570297241 / seconds
Query Executed:select id FROM `nc` where city='Sanford' && SIC_code='5461'DB:business_master_new
loadtime:4.3952391147614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sapphire' limit 1
loadtime:4.3952879905701 / seconds
Query Executed:select id FROM `nc` where city='Sapphire' && SIC_code='5461'DB:business_master_new
loadtime:4.4158210754395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga' limit 1
loadtime:4.4158711433411 / seconds
Query Executed:select id FROM `nc` where city='Saratoga' && SIC_code='5461'DB:business_master_new
loadtime:4.4192020893097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saxapahaw' limit 1
loadtime:4.4192500114441 / seconds
Query Executed:select id FROM `nc` where city='Saxapahaw' && SIC_code='5461'DB:business_master_new
loadtime:4.4230470657349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scaly Mountain' limit 1
loadtime:4.4230902194977 / seconds
Query Executed:select id FROM `nc` where city='Scaly Mountain' && SIC_code='5461'DB:business_master_new
loadtime:4.4330580234528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotland Neck' limit 1
loadtime:4.4331111907959 / seconds
Query Executed:select id FROM `nc` where city='Scotland Neck' && SIC_code='5461'DB:business_master_new
loadtime:4.4338781833649 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scotts' limit 1
loadtime:4.4339060783386 / seconds
Query Executed:select id FROM `nc` where city='Scotts' && SIC_code='5461'DB:business_master_new
loadtime:4.4373490810394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottville' limit 1
loadtime:4.4374001026154 / seconds
Query Executed:select id FROM `nc` where city='Scottville' && SIC_code='5461'DB:business_master_new
loadtime:4.4400432109833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scranton' limit 1
loadtime:4.4400930404663 / seconds
Query Executed:select id FROM `nc` where city='Scranton' && SIC_code='5461'DB:business_master_new
loadtime:4.4454531669617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seaboard' limit 1
loadtime:4.4454882144928 / seconds
Query Executed:select id FROM `nc` where city='Seaboard' && SIC_code='5461'DB:business_master_new
loadtime:4.4599370956421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seagrove' limit 1
loadtime:4.4599871635437 / seconds
Query Executed:select id FROM `nc` where city='Seagrove' && SIC_code='5461'DB:business_master_new
loadtime:4.4607520103455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sealevel' limit 1
loadtime:4.4608111381531 / seconds
Query Executed:select id FROM `nc` where city='Sealevel' && SIC_code='5461'DB:business_master_new
loadtime:4.4676940441132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sedalia' limit 1
loadtime:4.4677422046661 / seconds
Query Executed:select id FROM `nc` where city='Sedalia' && SIC_code='5461'DB:business_master_new
loadtime:4.4713921546936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:4.4714300632477 / seconds
Query Executed:select id FROM `nc` where city='Selma' && SIC_code='5461'DB:business_master_new
loadtime:4.47234416008 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semora' limit 1
loadtime:4.472382068634 / seconds
Query Executed:select id FROM `nc` where city='Semora' && SIC_code='5461'DB:business_master_new
loadtime:4.484827041626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semr Johnson Afb' limit 1
loadtime:4.4848771095276 / seconds
Query Executed:select id FROM `nc` where city='Semr Johnson Afb' && SIC_code='5461'DB:business_master_new
loadtime:4.485472202301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Devils' limit 1
loadtime:4.4855132102966 / seconds
Query Executed:select id FROM `nc` where city='Seven Devils' && SIC_code='5461'DB:business_master_new
loadtime:4.4857740402222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seven Springs' limit 1
loadtime:4.4858322143555 / seconds
Query Executed:select id FROM `nc` where city='Seven Springs' && SIC_code='5461'DB:business_master_new
loadtime:4.4864540100098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Severn' limit 1
loadtime:4.4864900112152 / seconds
Query Executed:select id FROM `nc` where city='Severn' && SIC_code='5461'DB:business_master_new
loadtime:4.48930311203 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shallotte' limit 1
loadtime:4.4893450737 / seconds
Query Executed:select id FROM `nc` where city='Shallotte' && SIC_code='5461'DB:business_master_new
loadtime:4.4904429912567 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:4.4904980659485 / seconds
Query Executed:select id FROM `nc` where city='Shannon' && SIC_code='5461'DB:business_master_new
loadtime:4.4911260604858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sharpsburg' limit 1
loadtime:4.4911670684814 / seconds
Query Executed:select id FROM `nc` where city='Sharpsburg' && SIC_code='5461'DB:business_master_new
loadtime:4.4918231964111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shawboro' limit 1
loadtime:4.4918611049652 / seconds
Query Executed:select id FROM `nc` where city='Shawboro' && SIC_code='5461'DB:business_master_new
loadtime:4.5023581981659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:4.5024201869965 / seconds
Query Executed:select id FROM `nc` where city='Shelby' && SIC_code='5461'DB:business_master_new
loadtime:4.5045549869537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sherrills Ford' limit 1
loadtime:4.5046141147614 / seconds
Query Executed:select id FROM `nc` where city='Sherrills Ford' && SIC_code='5461'DB:business_master_new
loadtime:4.5052690505981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shiloh' limit 1
loadtime:4.5053260326385 / seconds
Query Executed:select id FROM `nc` where city='Shiloh' && SIC_code='5461'DB:business_master_new
loadtime:4.5159301757812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siler City' limit 1
loadtime:4.5159931182861 / seconds
Query Executed:select id FROM `nc` where city='Siler City' && SIC_code='5461'DB:business_master_new
loadtime:4.5170931816101 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siloam' limit 1
loadtime:4.5171530246735 / seconds
Query Executed:select id FROM `nc` where city='Siloam' && SIC_code='5461'DB:business_master_new
loadtime:4.5297181606293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Simpson' limit 1
loadtime:4.5297791957855 / seconds
Query Executed:select id FROM `nc` where city='Simpson' && SIC_code='5461'DB:business_master_new
loadtime:4.5365991592407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sims' limit 1
loadtime:4.5366489887238 / seconds
Query Executed:select id FROM `nc` where city='Sims' && SIC_code='5461'DB:business_master_new
loadtime:4.5616161823273 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skyland' limit 1
loadtime:4.5616521835327 / seconds
Query Executed:select id FROM `nc` where city='Skyland' && SIC_code='5461'DB:business_master_new
loadtime:4.5623631477356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:4.5624132156372 / seconds
Query Executed:select id FROM `nc` where city='Smithfield' && SIC_code='5461'DB:business_master_new
loadtime:4.5640170574188 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smyrna' limit 1
loadtime:4.5640761852264 / seconds
Query Executed:select id FROM `nc` where city='Smyrna' && SIC_code='5461'DB:business_master_new
loadtime:4.5752921104431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sneads Ferry' limit 1
loadtime:4.575343132019 / seconds
Query Executed:select id FROM `nc` where city='Sneads Ferry' && SIC_code='5461'DB:business_master_new
loadtime:4.5762221813202 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Camp' limit 1
loadtime:4.5762650966644 / seconds
Query Executed:select id FROM `nc` where city='Snow Camp' && SIC_code='5461'DB:business_master_new
loadtime:4.5769321918488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Hill' limit 1
loadtime:4.5769820213318 / seconds
Query Executed:select id FROM `nc` where city='Snow Hill' && SIC_code='5461'DB:business_master_new
loadtime:4.5778341293335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sophia' limit 1
loadtime:4.5778779983521 / seconds
Query Executed:select id FROM `nc` where city='Sophia' && SIC_code='5461'DB:business_master_new
loadtime:4.5786061286926 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Brunswick' limit 1
loadtime:4.5786550045013 / seconds
Query Executed:select id FROM `nc` where city='South Brunswick' && SIC_code='5461'DB:business_master_new
loadtime:4.5816941261292 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Mills' limit 1
loadtime:4.5817441940308 / seconds
Query Executed:select id FROM `nc` where city='South Mills' && SIC_code='5461'DB:business_master_new
loadtime:4.6019811630249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Pines' limit 1
loadtime:4.60294008255 / seconds
Query Executed:select id FROM `nc` where city='Southern Pines' && SIC_code='5461'DB:business_master_new
loadtime:4.6044380664825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southern Shores' limit 1
loadtime:4.6044931411743 / seconds
Query Executed:select id FROM `nc` where city='Southern Shores' && SIC_code='5461'DB:business_master_new
loadtime:4.6060400009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southmont' limit 1
loadtime:4.6060681343079 / seconds
Query Executed:select id FROM `nc` where city='Southmont' && SIC_code='5461'DB:business_master_new
loadtime:4.6137351989746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Southport' limit 1
loadtime:4.6137800216675 / seconds
Query Executed:select id FROM `nc` where city='Southport' && SIC_code='5461'DB:business_master_new
loadtime:4.6149580478668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sparta' limit 1
loadtime:4.6150090694427 / seconds
Query Executed:select id FROM `nc` where city='Sparta' && SIC_code='5461'DB:business_master_new
loadtime:4.6159040927887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Speed' limit 1
loadtime:4.6159410476685 / seconds
Query Executed:select id FROM `nc` where city='Speed' && SIC_code='5461'DB:business_master_new
loadtime:4.6162450313568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spencer' limit 1
loadtime:4.6162760257721 / seconds
Query Executed:select id FROM `nc` where city='Spencer' && SIC_code='5461'DB:business_master_new
loadtime:4.6169130802155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spindale' limit 1
loadtime:4.6169371604919 / seconds
Query Executed:select id FROM `nc` where city='Spindale' && SIC_code='5461'DB:business_master_new
loadtime:4.617683172226 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Hope' limit 1
loadtime:4.6177260875702 / seconds
Query Executed:select id FROM `nc` where city='Spring Hope' && SIC_code='5461'DB:business_master_new
loadtime:4.6184480190277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring Lake' limit 1
loadtime:4.6184811592102 / seconds
Query Executed:select id FROM `nc` where city='Spring Lake' && SIC_code='5461'DB:business_master_new
loadtime:4.6193740367889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce Pine' limit 1
loadtime:4.6193990707397 / seconds
Query Executed:select id FROM `nc` where city='Spruce Pine' && SIC_code='5461'DB:business_master_new
loadtime:4.6202840805054 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Pauls' limit 1
loadtime:4.6203200817108 / seconds
Query Executed:select id FROM `nc` where city='St Pauls' && SIC_code='5461'DB:business_master_new
loadtime:4.6208620071411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stacy' limit 1
loadtime:4.6209001541138 / seconds
Query Executed:select id FROM `nc` where city='Stacy' && SIC_code='5461'DB:business_master_new
loadtime:4.6234431266785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Staley' limit 1
loadtime:4.6234781742096 / seconds
Query Executed:select id FROM `nc` where city='Staley' && SIC_code='5461'DB:business_master_new
loadtime:4.6240870952606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stallings' limit 1
loadtime:4.6241171360016 / seconds
Query Executed:select id FROM `nc` where city='Stallings' && SIC_code='5461'DB:business_master_new
loadtime:4.6249971389771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanfield' limit 1
loadtime:4.625039100647 / seconds
Query Executed:select id FROM `nc` where city='Stanfield' && SIC_code='5461'DB:business_master_new
loadtime:4.6256492137909 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanley' limit 1
loadtime:4.6256840229034 / seconds
Query Executed:select id FROM `nc` where city='Stanley' && SIC_code='5461'DB:business_master_new
loadtime:4.6264870166779 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stantonsburg' limit 1
loadtime:4.6265211105347 / seconds
Query Executed:select id FROM `nc` where city='Stantonsburg' && SIC_code='5461'DB:business_master_new
loadtime:4.6271290779114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Star' limit 1
loadtime:4.6271681785583 / seconds
Query Executed:select id FROM `nc` where city='Star' && SIC_code='5461'DB:business_master_new
loadtime:4.627758026123 / seconds
Query loaded from cache:select * from geodata_geocity where city='State Road' limit 1
loadtime:4.6277890205383 / seconds
Query Executed:select id FROM `nc` where city='State Road' && SIC_code='5461'DB:business_master_new
loadtime:4.6284251213074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Statesville' limit 1
loadtime:4.6284561157227 / seconds
Query Executed:select id FROM `nc` where city='Statesville' && SIC_code='5461'DB:business_master_new
loadtime:4.6362850666046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stedman' limit 1
loadtime:4.6363360881805 / seconds
Query Executed:select id FROM `nc` where city='Stedman' && SIC_code='5461'DB:business_master_new
loadtime:4.637001991272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stella' limit 1
loadtime:4.6370391845703 / seconds
Query Executed:select id FROM `nc` where city='Stella' && SIC_code='5461'DB:business_master_new
loadtime:4.6434421539307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stem' limit 1
loadtime:4.6434700489044 / seconds
Query Executed:select id FROM `nc` where city='Stem' && SIC_code='5461'DB:business_master_new
loadtime:4.6591410636902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokes' limit 1
loadtime:4.6591780185699 / seconds
Query Executed:select id FROM `nc` where city='Stokes' && SIC_code='5461'DB:business_master_new
loadtime:4.6718621253967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stokesdale' limit 1
loadtime:4.6719000339508 / seconds
Query Executed:select id FROM `nc` where city='Stokesdale' && SIC_code='5461'DB:business_master_new
loadtime:4.6726591587067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stoneville' limit 1
loadtime:4.6727020740509 / seconds
Query Executed:select id FROM `nc` where city='Stoneville' && SIC_code='5461'DB:business_master_new
loadtime:4.6734590530396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stonewall' limit 1
loadtime:4.673495054245 / seconds
Query Executed:select id FROM `nc` where city='Stonewall' && SIC_code='5461'DB:business_master_new
loadtime:4.6761209964752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stony Point' limit 1
loadtime:4.676146030426 / seconds
Query Executed:select id FROM `nc` where city='Stony Point' && SIC_code='5461'DB:business_master_new
loadtime:4.6767711639404 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stovall' limit 1
loadtime:4.6768159866333 / seconds
Query Executed:select id FROM `nc` where city='Stovall' && SIC_code='5461'DB:business_master_new
loadtime:4.6828200817108 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stumpy Point' limit 1
loadtime:4.6828520298004 / seconds
Query Executed:select id FROM `nc` where city='Stumpy Point' && SIC_code='5461'DB:business_master_new
loadtime:4.6905751228333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Grove' limit 1
loadtime:4.6906130313873 / seconds
Query Executed:select id FROM `nc` where city='Sugar Grove' && SIC_code='5461'DB:business_master_new
loadtime:4.6912400722504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sugar Mountain' limit 1
loadtime:4.691269159317 / seconds
Query Executed:select id FROM `nc` where city='Sugar Mountain' && SIC_code='5461'DB:business_master_new
loadtime:4.6915111541748 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerfield' limit 1
loadtime:4.6915440559387 / seconds
Query Executed:select id FROM `nc` where city='Summerfield' && SIC_code='5461'DB:business_master_new
loadtime:4.6923680305481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunbury' limit 1
loadtime:4.6924130916595 / seconds
Query Executed:select id FROM `nc` where city='Sunbury' && SIC_code='5461'DB:business_master_new
loadtime:4.7088840007782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunset Beach' limit 1
loadtime:4.708927154541 / seconds
Query Executed:select id FROM `nc` where city='Sunset Beach' && SIC_code='5461'DB:business_master_new
loadtime:4.7096312046051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Supply' limit 1
loadtime:4.7096810340881 / seconds
Query Executed:select id FROM `nc` where city='Supply' && SIC_code='5461'DB:business_master_new
loadtime:4.7108330726624 / seconds
Query loaded from cache:select * from geodata_geocity where city='Surf City' limit 1
loadtime:4.7108881473541 / seconds
Query Executed:select id FROM `nc` where city='Surf City' && SIC_code='5461'DB:business_master_new
loadtime:4.71231508255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swannanoa' limit 1
loadtime:4.7123460769653 / seconds
Query Executed:select id FROM `nc` where city='Swannanoa' && SIC_code='5461'DB:business_master_new
loadtime:4.713121175766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swanquarter' limit 1
loadtime:4.7131640911102 / seconds
Query Executed:select id FROM `nc` where city='Swanquarter' && SIC_code='5461'DB:business_master_new
loadtime:4.7138071060181 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swansboro' limit 1
loadtime:4.7138421535492 / seconds
Query Executed:select id FROM `nc` where city='Swansboro' && SIC_code='5461'DB:business_master_new
loadtime:4.7147741317749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Swepsonville' limit 1
loadtime:4.7148439884186 / seconds
Query Executed:select id FROM `nc` where city='Swepsonville' && SIC_code='5461'DB:business_master_new
loadtime:4.720762014389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylva' limit 1
loadtime:4.7208180427551 / seconds
Query Executed:select id FROM `nc` where city='Sylva' && SIC_code='5461'DB:business_master_new
loadtime:4.721871137619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabor City' limit 1
loadtime:4.7219321727753 / seconds
Query Executed:select id FROM `nc` where city='Tabor City' && SIC_code='5461'DB:business_master_new
loadtime:4.7227141857147 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tapoco' limit 1
loadtime:4.7227561473846 / seconds
Query Executed:select id FROM `nc` where city='Tapoco' && SIC_code='5461'DB:business_master_new
loadtime:4.7230319976807 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tar Heel' limit 1
loadtime:4.7230751514435 / seconds
Query Executed:select id FROM `nc` where city='Tar Heel' && SIC_code='5461'DB:business_master_new
loadtime:4.7373251914978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarawa Terrace' limit 1
loadtime:4.7373750209808 / seconds
Query Executed:select id FROM `nc` where city='Tarawa Terrace' && SIC_code='5461'DB:business_master_new
loadtime:4.7384331226349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tarboro' limit 1
loadtime:4.7384741306305 / seconds
Query Executed:select id FROM `nc` where city='Tarboro' && SIC_code='5461'DB:business_master_new
loadtime:4.7394821643829 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylorsville' limit 1
loadtime:4.739538192749 / seconds
Query Executed:select id FROM `nc` where city='Taylorsville' && SIC_code='5461'DB:business_master_new
loadtime:4.7406611442566 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teachey' limit 1
loadtime:4.7407190799713 / seconds
Query Executed:select id FROM `nc` where city='Teachey' && SIC_code='5461'DB:business_master_new
loadtime:4.7505760192871 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terrell' limit 1
loadtime:4.7506170272827 / seconds
Query Executed:select id FROM `nc` where city='Terrell' && SIC_code='5461'DB:business_master_new
loadtime:4.7636849880219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomasville' limit 1
loadtime:4.7637331485748 / seconds
Query Executed:select id FROM `nc` where city='Thomasville' && SIC_code='5461'DB:business_master_new
loadtime:4.765319108963 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thurmond' limit 1
loadtime:4.7653741836548 / seconds
Query Executed:select id FROM `nc` where city='Thurmond' && SIC_code='5461'DB:business_master_new
loadtime:4.7737231254578 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tillery' limit 1
loadtime:4.7737641334534 / seconds
Query Executed:select id FROM `nc` where city='Tillery' && SIC_code='5461'DB:business_master_new
loadtime:4.7760140895844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Timberlake' limit 1
loadtime:4.7760710716248 / seconds
Query Executed:select id FROM `nc` where city='Timberlake' && SIC_code='5461'DB:business_master_new
loadtime:4.776750087738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toast' limit 1
loadtime:4.776792049408 / seconds
Query Executed:select id FROM `nc` where city='Toast' && SIC_code='5461'DB:business_master_new
loadtime:4.7804322242737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tobaccoville' limit 1
loadtime:4.7804651260376 / seconds
Query Executed:select id FROM `nc` where city='Tobaccoville' && SIC_code='5461'DB:business_master_new
loadtime:4.8012821674347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Todd' limit 1
loadtime:4.8013381958008 / seconds
Query Executed:select id FROM `nc` where city='Todd' && SIC_code='5461'DB:business_master_new
loadtime:4.812616109848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topsail Beach' limit 1
loadtime:4.8126511573792 / seconds
Query Executed:select id FROM `nc` where city='Topsail Beach' && SIC_code='5461'DB:business_master_new
loadtime:4.8168740272522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Topton' limit 1
loadtime:4.8171150684357 / seconds
Query Executed:select id FROM `nc` where city='Topton' && SIC_code='5461'DB:business_master_new
loadtime:4.8264892101288 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townsville' limit 1
loadtime:4.8265202045441 / seconds
Query Executed:select id FROM `nc` where city='Townsville' && SIC_code='5461'DB:business_master_new
loadtime:4.8292880058289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Traphill' limit 1
loadtime:4.8293180465698 / seconds
Query Executed:select id FROM `nc` where city='Traphill' && SIC_code='5461'DB:business_master_new
loadtime:4.8392930030823 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trent Woods' limit 1
loadtime:4.8393180370331 / seconds
Query Executed:select id FROM `nc` where city='Trent Woods' && SIC_code='5461'DB:business_master_new
loadtime:4.8399791717529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:4.840017080307 / seconds
Query Executed:select id FROM `nc` where city='Trenton' && SIC_code='5461'DB:business_master_new
loadtime:4.8406841754913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinity' limit 1
loadtime:4.8407142162323 / seconds
Query Executed:select id FROM `nc` where city='Trinity' && SIC_code='5461'DB:business_master_new
loadtime:4.841509103775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troutman' limit 1
loadtime:4.8415551185608 / seconds
Query Executed:select id FROM `nc` where city='Troutman' && SIC_code='5461'DB:business_master_new
loadtime:4.8422861099243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:4.8423202037811 / seconds
Query Executed:select id FROM `nc` where city='Troy' && SIC_code='5461'DB:business_master_new
loadtime:4.8430981636047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tryon' limit 1
loadtime:4.8431341648102 / seconds
Query Executed:select id FROM `nc` where city='Tryon' && SIC_code='5461'DB:business_master_new
loadtime:4.843857049942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuckasegee' limit 1
loadtime:4.843896150589 / seconds
Query Executed:select id FROM `nc` where city='Tuckasegee' && SIC_code='5461'DB:business_master_new
loadtime:4.8511011600494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turkey' limit 1
loadtime:4.8511381149292 / seconds
Query Executed:select id FROM `nc` where city='Turkey' && SIC_code='5461'DB:business_master_new
loadtime:4.8680830001831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Turnersburg' limit 1
loadtime:4.8681080341339 / seconds
Query Executed:select id FROM `nc` where city='Turnersburg' && SIC_code='5461'DB:business_master_new
loadtime:4.8700702190399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuxedo' limit 1
loadtime:4.870108127594 / seconds
Query Executed:select id FROM `nc` where city='Tuxedo' && SIC_code='5461'DB:business_master_new
loadtime:4.8751940727234 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyner' limit 1
loadtime:4.8752360343933 / seconds
Query Executed:select id FROM `nc` where city='Tyner' && SIC_code='5461'DB:business_master_new
loadtime:4.8902521133423 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:4.8902840614319 / seconds
Query Executed:select id FROM `nc` where city='Union Grove' && SIC_code='5461'DB:business_master_new
loadtime:4.890928030014 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Mills' limit 1
loadtime:4.8909721374512 / seconds
Query Executed:select id FROM `nc` where city='Union Mills' && SIC_code='5461'DB:business_master_new
loadtime:4.9107780456543 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valdese' limit 1
loadtime:4.9108180999756 / seconds
Query Executed:select id FROM `nc` where city='Valdese' && SIC_code='5461'DB:business_master_new
loadtime:4.9118371009827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vale' limit 1
loadtime:4.9118831157684 / seconds
Query Executed:select id FROM `nc` where city='Vale' && SIC_code='5461'DB:business_master_new
loadtime:4.9125621318817 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valle Crucis' limit 1
loadtime:4.9125959873199 / seconds
Query Executed:select id FROM `nc` where city='Valle Crucis' && SIC_code='5461'DB:business_master_new
loadtime:4.9185991287231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vanceboro' limit 1
loadtime:4.9186451435089 / seconds
Query Executed:select id FROM `nc` where city='Vanceboro' && SIC_code='5461'DB:business_master_new
loadtime:4.919625043869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandemere' limit 1
loadtime:4.9197201728821 / seconds
Query Executed:select id FROM `nc` where city='Vandemere' && SIC_code='5461'DB:business_master_new
loadtime:4.9250521659851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vass' limit 1
loadtime:4.9250900745392 / seconds
Query Executed:select id FROM `nc` where city='Vass' && SIC_code='5461'DB:business_master_new
loadtime:4.9257471561432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vaughan' limit 1
loadtime:4.9257810115814 / seconds
Query Executed:select id FROM `nc` where city='Vaughan' && SIC_code='5461'DB:business_master_new
loadtime:4.9272181987762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vilas' limit 1
loadtime:4.9272441864014 / seconds
Query Executed:select id FROM `nc` where city='Vilas' && SIC_code='5461'DB:business_master_new
loadtime:4.927894115448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waco' limit 1
loadtime:4.9279291629791 / seconds
Query Executed:select id FROM `nc` where city='Waco' && SIC_code='5461'DB:business_master_new
loadtime:4.9303951263428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wade' limit 1
loadtime:4.9304330348969 / seconds
Query Executed:select id FROM `nc` where city='Wade' && SIC_code='5461'DB:business_master_new
loadtime:4.9487001895905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadesboro' limit 1
loadtime:4.948734998703 / seconds
Query Executed:select id FROM `nc` where city='Wadesboro' && SIC_code='5461'DB:business_master_new
loadtime:4.9496750831604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagram' limit 1
loadtime:4.9497110843658 / seconds
Query Executed:select id FROM `nc` where city='Wagram' && SIC_code='5461'DB:business_master_new
loadtime:4.9651861190796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wake Forest' limit 1
loadtime:4.9652230739594 / seconds
Query Executed:select id FROM `nc` where city='Wake Forest' && SIC_code='5461'DB:business_master_new
loadtime:4.9668970108032 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walkertown' limit 1
loadtime:4.9669351577759 / seconds
Query Executed:select id FROM `nc` where city='Walkertown' && SIC_code='5461'DB:business_master_new
loadtime:4.9676430225372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallace' limit 1
loadtime:4.9676802158356 / seconds
Query Executed:select id FROM `nc` where city='Wallace' && SIC_code='5461'DB:business_master_new
loadtime:4.968563079834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallburg' limit 1
loadtime:4.968602180481 / seconds
Query Executed:select id FROM `nc` where city='Wallburg' && SIC_code='5461'DB:business_master_new
loadtime:4.9787051677704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Cove' limit 1
loadtime:4.9787430763245 / seconds
Query Executed:select id FROM `nc` where city='Walnut Cove' && SIC_code='5461'DB:business_master_new
loadtime:4.979542016983 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walstonburg' limit 1
loadtime:4.9795660972595 / seconds
Query Executed:select id FROM `nc` where city='Walstonburg' && SIC_code='5461'DB:business_master_new
loadtime:4.9906690120697 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wanchese' limit 1
loadtime:4.9907040596008 / seconds
Query Executed:select id FROM `nc` where city='Wanchese' && SIC_code='5461'DB:business_master_new
loadtime:4.9913151264191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warne' limit 1
loadtime:4.9913430213928 / seconds
Query Executed:select id FROM `nc` where city='Warne' && SIC_code='5461'DB:business_master_new
loadtime:4.9958980083466 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrensville' limit 1
loadtime:4.9959330558777 / seconds
Query Executed:select id FROM `nc` where city='Warrensville' && SIC_code='5461'DB:business_master_new
loadtime:5.0105900764465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrenton' limit 1
loadtime:5.0106241703033 / seconds
Query Executed:select id FROM `nc` where city='Warrenton' && SIC_code='5461'DB:business_master_new
loadtime:5.0127370357513 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warsaw' limit 1
loadtime:5.0128672122955 / seconds
Query Executed:select id FROM `nc` where city='Warsaw' && SIC_code='5461'DB:business_master_new
loadtime:5.0151371955872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:5.0152010917664 / seconds
Query Executed:select id FROM `nc` where city='Washington' && SIC_code='5461'DB:business_master_new
loadtime:5.0176591873169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Watha' limit 1
loadtime:5.0177271366119 / seconds
Query Executed:select id FROM `nc` where city='Watha' && SIC_code='5461'DB:business_master_new
loadtime:5.0188601016998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waves' limit 1
loadtime:5.0188970565796 / seconds
Query Executed:select id FROM `nc` where city='Waves' && SIC_code='5461'DB:business_master_new
loadtime:5.0245862007141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waxhaw' limit 1
loadtime:5.0246222019196 / seconds
Query Executed:select id FROM `nc` where city='Waxhaw' && SIC_code='5461'DB:business_master_new
loadtime:5.0256431102753 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waynesville' limit 1
loadtime:5.0256860256195 / seconds
Query Executed:select id FROM `nc` where city='Waynesville' && SIC_code='5461'DB:business_master_new
loadtime:5.0270011425018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weaverville' limit 1
loadtime:5.0270380973816 / seconds
Query Executed:select id FROM `nc` where city='Weaverville' && SIC_code='5461'DB:business_master_new
loadtime:5.0283091068268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webster' limit 1
loadtime:5.0283761024475 / seconds
Query Executed:select id FROM `nc` where city='Webster' && SIC_code='5461'DB:business_master_new
loadtime:5.0337491035461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weddington' limit 1
loadtime:5.0337841510773 / seconds
Query Executed:select id FROM `nc` where city='Weddington' && SIC_code='5461'DB:business_master_new
loadtime:5.0346632003784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Welcome' limit 1
loadtime:5.034698009491 / seconds
Query Executed:select id FROM `nc` where city='Welcome' && SIC_code='5461'DB:business_master_new
loadtime:5.0353519916534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weldon' limit 1
loadtime:5.0353920459747 / seconds
Query Executed:select id FROM `nc` where city='Weldon' && SIC_code='5461'DB:business_master_new
loadtime:5.0360569953918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendell' limit 1
loadtime:5.0360851287842 / seconds
Query Executed:select id FROM `nc` where city='Wendell' && SIC_code='5461'DB:business_master_new
loadtime:5.0370230674744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wentworth' limit 1
loadtime:5.0370571613312 / seconds
Query Executed:select id FROM `nc` where city='Wentworth' && SIC_code='5461'DB:business_master_new
loadtime:5.0546350479126 / seconds
Query loaded from cache:select * from geodata_geocity where city='West End' limit 1
loadtime:5.0546660423279 / seconds
Query Executed:select id FROM `nc` where city='West End' && SIC_code='5461'DB:business_master_new
loadtime:5.0553970336914 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jefferson' limit 1
loadtime:5.055438041687 / seconds
Query Executed:select id FROM `nc` where city='West Jefferson' && SIC_code='5461'DB:business_master_new
loadtime:5.0563321113586 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westfield' limit 1
loadtime:5.0563740730286 / seconds
Query Executed:select id FROM `nc` where city='Westfield' && SIC_code='5461'DB:business_master_new
loadtime:5.0788650512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whispering Pines' limit 1
loadtime:5.078898191452 / seconds
Query Executed:select id FROM `nc` where city='Whispering Pines' && SIC_code='5461'DB:business_master_new
loadtime:5.0794231891632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitakers' limit 1
loadtime:5.0794610977173 / seconds
Query Executed:select id FROM `nc` where city='Whitakers' && SIC_code='5461'DB:business_master_new
loadtime:5.0805912017822 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Oak' limit 1
loadtime:5.0806820392609 / seconds
Query Executed:select id FROM `nc` where city='White Oak' && SIC_code='5461'DB:business_master_new
loadtime:5.0931789875031 / seconds
Query loaded from cache:select * from geodata_geocity where city='White Plains' limit 1
loadtime:5.0932040214539 / seconds
Query Executed:select id FROM `nc` where city='White Plains' && SIC_code='5461'DB:business_master_new
loadtime:5.0949821472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiteville' limit 1
loadtime:5.0950200557709 / seconds
Query Executed:select id FROM `nc` where city='Whiteville' && SIC_code='5461'DB:business_master_new
loadtime:5.0961980819702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whitsett' limit 1
loadtime:5.0962421894073 / seconds
Query Executed:select id FROM `nc` where city='Whitsett' && SIC_code='5461'DB:business_master_new
loadtime:5.09690117836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whittier' limit 1
loadtime:5.0969381332397 / seconds
Query Executed:select id FROM `nc` where city='Whittier' && SIC_code='5461'DB:business_master_new
loadtime:5.0975790023804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilbar' limit 1
loadtime:5.0976021289825 / seconds
Query Executed:select id FROM `nc` where city='Wilbar' && SIC_code='5461'DB:business_master_new
loadtime:5.0978410243988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilkesboro' limit 1
loadtime:5.0978782176971 / seconds
Query Executed:select id FROM `nc` where city='Wilkesboro' && SIC_code='5461'DB:business_master_new
loadtime:5.0988721847534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:5.098913192749 / seconds
Query Executed:select id FROM `nc` where city='Willard' && SIC_code='5461'DB:business_master_new
loadtime:5.0995450019836 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williamston' limit 1
loadtime:5.0995759963989 / seconds
Query Executed:select id FROM `nc` where city='Williamston' && SIC_code='5461'DB:business_master_new
loadtime:5.1005620956421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Williston' limit 1
loadtime:5.100594997406 / seconds
Query Executed:select id FROM `nc` where city='Williston' && SIC_code='5461'DB:business_master_new
loadtime:5.1020410060883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willow Spring' limit 1
loadtime:5.1020700931549 / seconds
Query Executed:select id FROM `nc` where city='Willow Spring' && SIC_code='5461'DB:business_master_new
loadtime:5.1027932167053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmington' limit 1
loadtime:5.1028411388397 / seconds
Query Executed:select id FROM `nc` where city='Wilmington' && SIC_code='5461'DB:business_master_new
loadtime:5.1106970310211 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilson' limit 1
loadtime:5.1107571125031 / seconds
Query Executed:select id FROM `nc` where city='Wilson' && SIC_code='5461'DB:business_master_new
loadtime:5.1125600337982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsons Mills' limit 1
loadtime:5.1125991344452 / seconds
Query Executed:select id FROM `nc` where city='Wilsons Mills' && SIC_code='5461'DB:business_master_new
loadtime:5.1167290210724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Windsor' limit 1
loadtime:5.1168591976166 / seconds
Query Executed:select id FROM `nc` where city='Windsor' && SIC_code='5461'DB:business_master_new
loadtime:5.1185841560364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfall' limit 1
loadtime:5.1186330318451 / seconds
Query Executed:select id FROM `nc` where city='Winfall' && SIC_code='5461'DB:business_master_new
loadtime:5.1278421878815 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wingate' limit 1
loadtime:5.1278851032257 / seconds
Query Executed:select id FROM `nc` where city='Wingate' && SIC_code='5461'DB:business_master_new
loadtime:5.1285560131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winnabow' limit 1
loadtime:5.1289021968842 / seconds
Query Executed:select id FROM `nc` where city='Winnabow' && SIC_code='5461'DB:business_master_new
loadtime:5.1430740356445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winston Salem' limit 1
loadtime:5.1431181430817 / seconds
Query Executed:select id FROM `nc` where city='Winston Salem' && SIC_code='5461'DB:business_master_new
loadtime:5.1505310535431 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winterville' limit 1
loadtime:5.150593996048 / seconds
Query Executed:select id FROM `nc` where city='Winterville' && SIC_code='5461'DB:business_master_new
loadtime:5.1514592170715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winton' limit 1
loadtime:5.1514980792999 / seconds
Query Executed:select id FROM `nc` where city='Winton' && SIC_code='5461'DB:business_master_new
loadtime:5.152104139328 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wise' limit 1
loadtime:5.1521301269531 / seconds
Query Executed:select id FROM `nc` where city='Wise' && SIC_code='5461'DB:business_master_new
loadtime:5.1542592048645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:5.1543002128601 / seconds
Query Executed:select id FROM `nc` where city='Woodland' && SIC_code='5461'DB:business_master_new
loadtime:5.163497209549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodleaf' limit 1
loadtime:5.1635432243347 / seconds
Query Executed:select id FROM `nc` where city='Woodleaf' && SIC_code='5461'DB:business_master_new
loadtime:5.1648390293121 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Bch' limit 1
loadtime:5.16495013237 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Bch' && SIC_code='5461'DB:business_master_new
loadtime:5.1730661392212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wrightsville Beach' limit 1
loadtime:5.1731150150299 / seconds
Query Executed:select id FROM `nc` where city='Wrightsville Beach' && SIC_code='5461'DB:business_master_new
loadtime:5.173858165741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yadkinville' limit 1
loadtime:5.1738910675049 / seconds
Query Executed:select id FROM `nc` where city='Yadkinville' && SIC_code='5461'DB:business_master_new
loadtime:5.1748130321503 / seconds
Query loaded from cache:select * from geodata_geocity where city='Yanceyville' limit 1
loadtime:5.1748621463776 / seconds
Query Executed:select id FROM `nc` where city='Yanceyville' && SIC_code='5461'DB:business_master_new
loadtime:5.175595998764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Youngsville' limit 1
loadtime:5.1756331920624 / seconds
Query Executed:select id FROM `nc` where city='Youngsville' && SIC_code='5461'DB:business_master_new
loadtime:5.1764500141144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zebulon' limit 1
loadtime:5.176488161087 / seconds
Query Executed:select id FROM `nc` where city='Zebulon' && SIC_code='5461'DB:business_master_new
loadtime:5.1774501800537 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zionville' limit 1
loadtime:5.1774871349335 / seconds
Query Executed:select id FROM `nc` where city='Zionville' && SIC_code='5461'DB:business_master_new
loadtime:5.1780951023102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Zirconia' limit 1
loadtime:5.1781342029572 / seconds
Query Executed:select id FROM `nc` where city='Zirconia' && SIC_code='5461'DB:business_master_new
loadtime:5.1787641048431 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:5.1788580417633 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:5.179071187973 / seconds
Operation template executed (chunk cache operation)
loadtime:5.179151058197 / seconds
template override:Default
loadtime:5.179169178009 / 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:5.1799831390381 / seconds
Template Constructed, Array Rows:49
loadtime:5.180230140686 / seconds
TOTAL EXECUTION TIME: 5.18004
loadtime:5.1803431510925 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => retail-bakeries [stateURLid] => north-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:5.1803481578827
TOTAL KEY ARRAYS: 69