Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.00013399124145508 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00078415870666504 / seconds
host not found setting manual db connection
loadtime:0.0012321472167969 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.001708984375 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0020411014556885 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0020990371704102 / seconds
zipcode:
loadtime:0.0021171569824219 / seconds
Query Executed:select * from search_referrer where page_hash='30e092c4cfd38701becd5dc7d1d1b25e' limit 10 DB:ezrox_toadli
loadtime:0.0025060176849365 / seconds
Operation header executed (non global)
loadtime:0.0025560855865479 / seconds
Operation leaderboard executed (non global)
loadtime:0.0026710033416748 / seconds
Operation square executed (non global)
loadtime:0.0027101039886475 / seconds
Operation square_bottom executed (non global)
loadtime:0.0027899742126465 / seconds
Operation smallsquare executed (non global)
loadtime:0.0028200149536133 / seconds
Operation headeradright executed (non global)
loadtime:0.0028400421142578 / seconds
Operation google_analytics executed (non global)
loadtime:0.0028581619262695 / seconds
Operation topstories executed (non global)
loadtime:0.0028781890869141 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0028979778289795 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0029151439666748 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0033321380615234 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0034961700439453 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0035340785980225 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0036439895629883 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0037920475006104 / seconds
Template key: archive_menu pushed
loadtime:0.003803014755249 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0038330554962158 / seconds
Template key: get_gravatar pushed
loadtime:0.003838062286377 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0038430690765381 / seconds
*10)-10)+1 | start:0
loadtime:0.0038671493530273 / seconds
Query loaded from cache:select * from categories where cat_URLid='cable-and-other-pay-television-services'
loadtime:0.0039060115814209 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='alabama'
loadtime:0.003931999206543 / seconds
DB connected to localhost business_master_new
loadtime:0.0042760372161865 / seconds
Query Executed:select * from `al_catmap` where sic='4841' order by city ascDB:business_master_new
loadtime:0.32879114151001 / seconds
Query stored in cache : _QUERY_www.toadli.come225a23c00c7fd69ed3bd31cc4ba5381
loadtime:0.32968306541443 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='alabama'
loadtime:0.32973098754883 / seconds
Query Executed:select sum(totalcount) as totalsum from `al_catmap` where sic='4841'DB:business_master_new
loadtime:0.33297801017761 / seconds
Query stored in cache : _QUERY_www.toadli.com20d2af8dcf7b4be57011c7c4ab5803b9
loadtime:0.33300018310547 / seconds
594 / 11
loadtime:0.33303213119507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abbeville' limit 1
loadtime:0.33307814598083 / seconds
Query Executed:select id FROM `al` where city='Abbeville' && SIC_code='4841'DB:business_master_new
loadtime:0.33659505844116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Abernant' limit 1
loadtime:0.3366391658783 / seconds
Query Executed:select id FROM `al` where city='Abernant' && SIC_code='4841'DB:business_master_new
loadtime:0.33944916725159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adamsville' limit 1
loadtime:0.33949518203735 / seconds
Query Executed:select id FROM `al` where city='Adamsville' && SIC_code='4841'DB:business_master_new
loadtime:0.33997797966003 / seconds
Query loaded from cache:select * from geodata_geocity where city='Addison' limit 1
loadtime:0.34000897407532 / seconds
Query Executed:select id FROM `al` where city='Addison' && SIC_code='4841'DB:business_master_new
loadtime:0.34042811393738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Adger' limit 1
loadtime:0.3404700756073 / seconds
Query Executed:select id FROM `al` where city='Adger' && SIC_code='4841'DB:business_master_new
loadtime:0.34086012840271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Akron' limit 1
loadtime:0.34090304374695 / seconds
Query Executed:select id FROM `al` where city='Akron' && SIC_code='4841'DB:business_master_new
loadtime:0.34720516204834 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alabaster' limit 1
loadtime:0.34723520278931 / seconds
Query Executed:select id FROM `al` where city='Alabaster' && SIC_code='4841'DB:business_master_new
loadtime:0.48964214324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alberta' limit 1
loadtime:0.48970198631287 / seconds
Query Executed:select id FROM `al` where city='Alberta' && SIC_code='4841'DB:business_master_new
loadtime:0.49538111686707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Albertville' limit 1
loadtime:0.49542903900146 / seconds
Query Executed:select id FROM `al` where city='Albertville' && SIC_code='4841'DB:business_master_new
loadtime:0.49709510803223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexander City' limit 1
loadtime:0.49714517593384 / seconds
Query Executed:select id FROM `al` where city='Alexander City' && SIC_code='4841'DB:business_master_new
loadtime:0.49868297576904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alexandria' limit 1
loadtime:0.49874210357666 / seconds
Query Executed:select id FROM `al` where city='Alexandria' && SIC_code='4841'DB:business_master_new
loadtime:0.49923419952393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aliceville' limit 1
loadtime:0.49926614761353 / seconds
Query Executed:select id FROM `al` where city='Aliceville' && SIC_code='4841'DB:business_master_new
loadtime:0.49976897239685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Allgood' limit 1
loadtime:0.49981212615967 / seconds
Query Executed:select id FROM `al` where city='Allgood' && SIC_code='4841'DB:business_master_new
loadtime:0.50305604934692 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alma' limit 1
loadtime:0.50308609008789 / seconds
Query Executed:select id FROM `al` where city='Alma' && SIC_code='4841'DB:business_master_new
loadtime:0.5038161277771 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.50385713577271 / seconds
Query Executed:select id FROM `al` where city='Alpine' && SIC_code='4841'DB:business_master_new
loadtime:0.50425815582275 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.50429201126099 / seconds
Query Executed:select id FROM `al` where city='Alton' && SIC_code='4841'DB:business_master_new
loadtime:0.50629305839539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altoona' limit 1
loadtime:0.50633502006531 / seconds
Query Executed:select id FROM `al` where city='Altoona' && SIC_code='4841'DB:business_master_new
loadtime:0.50683403015137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Andalusia' limit 1
loadtime:0.50688314437866 / seconds
Query Executed:select id FROM `al` where city='Andalusia' && SIC_code='4841'DB:business_master_new
loadtime:0.50844717025757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anderson' limit 1
loadtime:0.50848603248596 / seconds
Query Executed:select id FROM `al` where city='Anderson' && SIC_code='4841'DB:business_master_new
loadtime:0.52355813980103 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annemanie' limit 1
loadtime:0.52360606193542 / seconds
Query Executed:select id FROM `al` where city='Annemanie' && SIC_code='4841'DB:business_master_new
loadtime:0.52488899230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Anniston' limit 1
loadtime:0.52491998672485 / seconds
Query Executed:select id FROM `al` where city='Anniston' && SIC_code='4841'DB:business_master_new
loadtime:0.52646708488464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arab' limit 1
loadtime:0.52651906013489 / seconds
Query Executed:select id FROM `al` where city='Arab' && SIC_code='4841'DB:business_master_new
loadtime:0.52808117866516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ardmore' limit 1
loadtime:0.52811217308044 / seconds
Query Executed:select id FROM `al` where city='Ardmore' && SIC_code='4841'DB:business_master_new
loadtime:0.52856612205505 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ariton' limit 1
loadtime:0.52860903739929 / seconds
Query Executed:select id FROM `al` where city='Ariton' && SIC_code='4841'DB:business_master_new
loadtime:0.52905416488647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arley' limit 1
loadtime:0.5290961265564 / seconds
Query Executed:select id FROM `al` where city='Arley' && SIC_code='4841'DB:business_master_new
loadtime:0.52949213981628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Arlington' limit 1
loadtime:0.52954196929932 / seconds
Query Executed:select id FROM `al` where city='Arlington' && SIC_code='4841'DB:business_master_new
loadtime:0.55019497871399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashford' limit 1
loadtime:0.55024313926697 / seconds
Query Executed:select id FROM `al` where city='Ashford' && SIC_code='4841'DB:business_master_new
loadtime:0.5507709980011 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashland' limit 1
loadtime:0.55080914497375 / seconds
Query Executed:select id FROM `al` where city='Ashland' && SIC_code='4841'DB:business_master_new
loadtime:0.55129504203796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ashville' limit 1
loadtime:0.55134606361389 / seconds
Query Executed:select id FROM `al` where city='Ashville' && SIC_code='4841'DB:business_master_new
loadtime:0.55186414718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Athens' limit 1
loadtime:0.55189514160156 / seconds
Query Executed:select id FROM `al` where city='Athens' && SIC_code='4841'DB:business_master_new
loadtime:0.5534360408783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Atmore' limit 1
loadtime:0.55348801612854 / seconds
Query Executed:select id FROM `al` where city='Atmore' && SIC_code='4841'DB:business_master_new
loadtime:0.55502510070801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Attalla' limit 1
loadtime:0.55505514144897 / seconds
Query Executed:select id FROM `al` where city='Attalla' && SIC_code='4841'DB:business_master_new
loadtime:0.55559706687927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Auburn' limit 1
loadtime:0.55564498901367 / seconds
Query Executed:select id FROM `al` where city='Auburn' && SIC_code='4841'DB:business_master_new
loadtime:0.55721616744995 / seconds
Query loaded from cache:select * from geodata_geocity where city='Autaugaville' limit 1
loadtime:0.55725312232971 / seconds
Query Executed:select id FROM `al` where city='Autaugaville' && SIC_code='4841'DB:business_master_new
loadtime:0.55764198303223 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axis' limit 1
loadtime:0.55768418312073 / seconds
Query Executed:select id FROM `al` where city='Axis' && SIC_code='4841'DB:business_master_new
loadtime:0.55807900428772 / seconds
Query loaded from cache:select * from geodata_geocity where city='Baileyton' limit 1
loadtime:0.55812001228333 / seconds
Query Executed:select id FROM `al` where city='Baileyton' && SIC_code='4841'DB:business_master_new
loadtime:0.55852603912354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Banks' limit 1
loadtime:0.5585560798645 / seconds
Query Executed:select id FROM `al` where city='Banks' && SIC_code='4841'DB:business_master_new
loadtime:0.55894207954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bankston' limit 1
loadtime:0.55898308753967 / seconds
Query Executed:select id FROM `al` where city='Bankston' && SIC_code='4841'DB:business_master_new
loadtime:0.58497214317322 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bay Minette' limit 1
loadtime:0.58500719070435 / seconds
Query Executed:select id FROM `al` where city='Bay Minette' && SIC_code='4841'DB:business_master_new
loadtime:0.58656215667725 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bayou La Batre' limit 1
loadtime:0.58660697937012 / seconds
Query Executed:select id FROM `al` where city='Bayou La Batre' && SIC_code='4841'DB:business_master_new
loadtime:0.58709096908569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear Creek' limit 1
loadtime:0.58712100982666 / seconds
Query Executed:select id FROM `al` where city='Bear Creek' && SIC_code='4841'DB:business_master_new
loadtime:0.58752417564392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beatrice' limit 1
loadtime:0.58756518363953 / seconds
Query Executed:select id FROM `al` where city='Beatrice' && SIC_code='4841'DB:business_master_new
loadtime:0.59882712364197 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaverton' limit 1
loadtime:0.5988621711731 / seconds
Query Executed:select id FROM `al` where city='Beaverton' && SIC_code='4841'DB:business_master_new
loadtime:0.60676407814026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belk' limit 1
loadtime:0.60681200027466 / seconds
Query Executed:select id FROM `al` where city='Belk' && SIC_code='4841'DB:business_master_new
loadtime:0.61098313331604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bellamy' limit 1
loadtime:0.61102819442749 / seconds
Query Executed:select id FROM `al` where city='Bellamy' && SIC_code='4841'DB:business_master_new
loadtime:0.61321711540222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Belle Mina' limit 1
loadtime:0.6132481098175 / seconds
Query Executed:select id FROM `al` where city='Belle Mina' && SIC_code='4841'DB:business_master_new
loadtime:0.62378406524658 / seconds
Query loaded from cache:select * from geodata_geocity where city='Berry' limit 1
loadtime:0.62383913993835 / seconds
Query Executed:select id FROM `al` where city='Berry' && SIC_code='4841'DB:business_master_new
loadtime:0.62428402900696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bessemer' limit 1
loadtime:0.62432312965393 / seconds
Query Executed:select id FROM `al` where city='Bessemer' && SIC_code='4841'DB:business_master_new
loadtime:0.62590503692627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bigbee' limit 1
loadtime:0.6259491443634 / seconds
Query Executed:select id FROM `al` where city='Bigbee' && SIC_code='4841'DB:business_master_new
loadtime:0.62642502784729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Billingsley' limit 1
loadtime:0.62646818161011 / seconds
Query Executed:select id FROM `al` where city='Billingsley' && SIC_code='4841'DB:business_master_new
loadtime:0.63973116874695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Birmingham' limit 1
loadtime:0.6397750377655 / seconds
Query Executed:select id FROM `al` where city='Birmingham' && SIC_code='4841'DB:business_master_new
loadtime:0.6413631439209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Black' limit 1
loadtime:0.64142203330994 / seconds
Query Executed:select id FROM `al` where city='Black' && SIC_code='4841'DB:business_master_new
loadtime:0.64601707458496 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blountsville' limit 1
loadtime:0.64606118202209 / seconds
Query Executed:select id FROM `al` where city='Blountsville' && SIC_code='4841'DB:business_master_new
loadtime:0.64657211303711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boaz' limit 1
loadtime:0.64660310745239 / seconds
Query Executed:select id FROM `al` where city='Boaz' && SIC_code='4841'DB:business_master_new
loadtime:0.6481831073761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boligee' limit 1
loadtime:0.64823508262634 / seconds
Query Executed:select id FROM `al` where city='Boligee' && SIC_code='4841'DB:business_master_new
loadtime:0.66496205329895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Air' limit 1
loadtime:0.66500496864319 / seconds
Query Executed:select id FROM `al` where city='Bon Air' && SIC_code='4841'DB:business_master_new
loadtime:0.66777205467224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bon Secour' limit 1
loadtime:0.66782116889954 / seconds
Query Executed:select id FROM `al` where city='Bon Secour' && SIC_code='4841'DB:business_master_new
loadtime:0.66826820373535 / seconds
Query loaded from cache:select * from geodata_geocity where city='Booth' limit 1
loadtime:0.66829800605774 / seconds
Query Executed:select id FROM `al` where city='Booth' && SIC_code='4841'DB:business_master_new
loadtime:0.6696240901947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boykin' limit 1
loadtime:0.66966414451599 / seconds
Query Executed:select id FROM `al` where city='Boykin' && SIC_code='4841'DB:business_master_new
loadtime:0.67074799537659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Branchville' limit 1
loadtime:0.6707911491394 / seconds
Query Executed:select id FROM `al` where city='Branchville' && SIC_code='4841'DB:business_master_new
loadtime:0.67105102539062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brantley' limit 1
loadtime:0.67108106613159 / seconds
Query Executed:select id FROM `al` where city='Brantley' && SIC_code='4841'DB:business_master_new
loadtime:0.67148208618164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bremen' limit 1
loadtime:0.67152214050293 / seconds
Query Executed:select id FROM `al` where city='Bremen' && SIC_code='4841'DB:business_master_new
loadtime:0.67197704315186 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brent' limit 1
loadtime:0.6720130443573 / seconds
Query Executed:select id FROM `al` where city='Brent' && SIC_code='4841'DB:business_master_new
loadtime:0.67243504524231 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brewton' limit 1
loadtime:0.67247819900513 / seconds
Query Executed:select id FROM `al` where city='Brewton' && SIC_code='4841'DB:business_master_new
loadtime:0.67404818534851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeport' limit 1
loadtime:0.67409801483154 / seconds
Query Executed:select id FROM `al` where city='Bridgeport' && SIC_code='4841'DB:business_master_new
loadtime:0.67450404167175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brierfield' limit 1
loadtime:0.67453408241272 / seconds
Query Executed:select id FROM `al` where city='Brierfield' && SIC_code='4841'DB:business_master_new
loadtime:0.67495107650757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.67499303817749 / seconds
Query Executed:select id FROM `al` where city='Brighton' && SIC_code='4841'DB:business_master_new
loadtime:0.67523312568665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brilliant' limit 1
loadtime:0.6752610206604 / seconds
Query Executed:select id FROM `al` where city='Brilliant' && SIC_code='4841'DB:business_master_new
loadtime:0.67563009262085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brooklyn' limit 1
loadtime:0.67566609382629 / seconds
Query Executed:select id FROM `al` where city='Brooklyn' && SIC_code='4841'DB:business_master_new
loadtime:0.67894101142883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookside' limit 1
loadtime:0.67898917198181 / seconds
Query Executed:select id FROM `al` where city='Brookside' && SIC_code='4841'DB:business_master_new
loadtime:0.68342304229736 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brookwood' limit 1
loadtime:0.68347215652466 / seconds
Query Executed:select id FROM `al` where city='Brookwood' && SIC_code='4841'DB:business_master_new
loadtime:0.68394112586975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brownsboro' limit 1
loadtime:0.68397212028503 / seconds
Query Executed:select id FROM `al` where city='Brownsboro' && SIC_code='4841'DB:business_master_new
loadtime:0.68439412117004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brundidge' limit 1
loadtime:0.68443608283997 / seconds
Query Executed:select id FROM `al` where city='Brundidge' && SIC_code='4841'DB:business_master_new
loadtime:0.68507719039917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryant' limit 1
loadtime:0.68510699272156 / seconds
Query Executed:select id FROM `al` where city='Bryant' && SIC_code='4841'DB:business_master_new
loadtime:0.68552398681641 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bucks' limit 1
loadtime:0.68556618690491 / seconds
Query Executed:select id FROM `al` where city='Bucks' && SIC_code='4841'DB:business_master_new
loadtime:0.69098711013794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Buhl' limit 1
loadtime:0.69102811813354 / seconds
Query Executed:select id FROM `al` where city='Buhl' && SIC_code='4841'DB:business_master_new
loadtime:0.69141316413879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burkville' limit 1
loadtime:0.69144201278687 / seconds
Query Executed:select id FROM `al` where city='Burkville' && SIC_code='4841'DB:business_master_new
loadtime:0.69380211830139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnt Corn' limit 1
loadtime:0.69384407997131 / seconds
Query Executed:select id FROM `al` where city='Burnt Corn' && SIC_code='4841'DB:business_master_new
loadtime:0.69451999664307 / seconds
Query loaded from cache:select * from geodata_geocity where city='Burnwell' limit 1
loadtime:0.69454908370972 / seconds
Query Executed:select id FROM `al` where city='Burnwell' && SIC_code='4841'DB:business_master_new
loadtime:0.6952919960022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Butler' limit 1
loadtime:0.69533205032349 / seconds
Query Executed:select id FROM `al` where city='Butler' && SIC_code='4841'DB:business_master_new
loadtime:0.69586420059204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bynum' limit 1
loadtime:0.69591498374939 / seconds
Query Executed:select id FROM `al` where city='Bynum' && SIC_code='4841'DB:business_master_new
loadtime:0.70522809028625 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cahaba Heights' limit 1
loadtime:0.70526003837585 / seconds
Query Executed:select id FROM `al` where city='Cahaba Heights' && SIC_code='4841'DB:business_master_new
loadtime:0.70718097686768 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calera' limit 1
loadtime:0.70722413063049 / seconds
Query Executed:select id FROM `al` where city='Calera' && SIC_code='4841'DB:business_master_new
loadtime:0.70878314971924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Calvert' limit 1
loadtime:0.708820104599 / seconds
Query Executed:select id FROM `al` where city='Calvert' && SIC_code='4841'DB:business_master_new
loadtime:0.71501708030701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camden' limit 1
loadtime:0.71506118774414 / seconds
Query Executed:select id FROM `al` where city='Camden' && SIC_code='4841'DB:business_master_new
loadtime:0.71556305885315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Camp Hill' limit 1
loadtime:0.71559309959412 / seconds
Query Executed:select id FROM `al` where city='Camp Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.71602916717529 / seconds
Query loaded from cache:select * from geodata_geocity where city='Campbell' limit 1
loadtime:0.71607303619385 / seconds
Query Executed:select id FROM `al` where city='Campbell' && SIC_code='4841'DB:business_master_new
loadtime:0.71683216094971 / seconds
Query loaded from cache:select * from geodata_geocity where city='Capshaw' limit 1
loadtime:0.71687316894531 / seconds
Query Executed:select id FROM `al` where city='Capshaw' && SIC_code='4841'DB:business_master_new
loadtime:0.7218611240387 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carbon Hill' limit 1
loadtime:0.72189617156982 / seconds
Query Executed:select id FROM `al` where city='Carbon Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.72231411933899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cardiff' limit 1
loadtime:0.72235512733459 / seconds
Query Executed:select id FROM `al` where city='Cardiff' && SIC_code='4841'DB:business_master_new
loadtime:0.72261309623718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Carrollton' limit 1
loadtime:0.72265100479126 / seconds
Query Executed:select id FROM `al` where city='Carrollton' && SIC_code='4841'DB:business_master_new
loadtime:0.72308707237244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castleberry' limit 1
loadtime:0.7231171131134 / seconds
Query Executed:select id FROM `al` where city='Castleberry' && SIC_code='4841'DB:business_master_new
loadtime:0.72349810600281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Catherine' limit 1
loadtime:0.72353911399841 / seconds
Query Executed:select id FROM `al` where city='Catherine' && SIC_code='4841'DB:business_master_new
loadtime:0.7308361530304 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cecil' limit 1
loadtime:0.73086714744568 / seconds
Query Executed:select id FROM `al` where city='Cecil' && SIC_code='4841'DB:business_master_new
loadtime:0.73643612861633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Bluff' limit 1
loadtime:0.73647809028625 / seconds
Query Executed:select id FROM `al` where city='Cedar Bluff' && SIC_code='4841'DB:business_master_new
loadtime:0.73693299293518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centre' limit 1
loadtime:0.73696303367615 / seconds
Query Executed:select id FROM `al` where city='Centre' && SIC_code='4841'DB:business_master_new
loadtime:0.73851203918457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centreville' limit 1
loadtime:0.73855400085449 / seconds
Query Executed:select id FROM `al` where city='Centreville' && SIC_code='4841'DB:business_master_new
loadtime:0.73904204368591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chancellor' limit 1
loadtime:0.73908400535583 / seconds
Query Executed:select id FROM `al` where city='Chancellor' && SIC_code='4841'DB:business_master_new
loadtime:0.73949909210205 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chapman' limit 1
loadtime:0.73953604698181 / seconds
Query Executed:select id FROM `al` where city='Chapman' && SIC_code='4841'DB:business_master_new
loadtime:0.74215602874756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chatom' limit 1
loadtime:0.74219608306885 / seconds
Query Executed:select id FROM `al` where city='Chatom' && SIC_code='4841'DB:business_master_new
loadtime:0.74264907836914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chelsea' limit 1
loadtime:0.74267816543579 / seconds
Query Executed:select id FROM `al` where city='Chelsea' && SIC_code='4841'DB:business_master_new
loadtime:0.74316906929016 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cherokee' limit 1
loadtime:0.74321007728577 / seconds
Query Executed:select id FROM `al` where city='Cherokee' && SIC_code='4841'DB:business_master_new
loadtime:0.74364399909973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Childersburg' limit 1
loadtime:0.74368000030518 / seconds
Query Executed:select id FROM `al` where city='Childersburg' && SIC_code='4841'DB:business_master_new
loadtime:0.74419403076172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Choccolocco' limit 1
loadtime:0.74423599243164 / seconds
Query Executed:select id FROM `al` where city='Choccolocco' && SIC_code='4841'DB:business_master_new
loadtime:0.74847602844238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chunchula' limit 1
loadtime:0.74851107597351 / seconds
Query Executed:select id FROM `al` where city='Chunchula' && SIC_code='4841'DB:business_master_new
loadtime:0.74894309043884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Citronelle' limit 1
loadtime:0.74898719787598 / seconds
Query Executed:select id FROM `al` where city='Citronelle' && SIC_code='4841'DB:business_master_new
loadtime:0.74948906898499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clanton' limit 1
loadtime:0.74953103065491 / seconds
Query Executed:select id FROM `al` where city='Clanton' && SIC_code='4841'DB:business_master_new
loadtime:0.7510871887207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clay' limit 1
loadtime:0.7511260509491 / seconds
Query Executed:select id FROM `al` where city='Clay' && SIC_code='4841'DB:business_master_new
loadtime:0.75149703025818 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clayton' limit 1
loadtime:0.7515389919281 / seconds
Query Executed:select id FROM `al` where city='Clayton' && SIC_code='4841'DB:business_master_new
loadtime:0.75200319290161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.75204706192017 / seconds
Query Executed:select id FROM `al` where city='Cleveland' && SIC_code='4841'DB:business_master_new
loadtime:0.75248718261719 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clinton' limit 1
loadtime:0.75252604484558 / seconds
Query Executed:select id FROM `al` where city='Clinton' && SIC_code='4841'DB:business_master_new
loadtime:0.75413608551025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clio' limit 1
loadtime:0.75417113304138 / seconds
Query Executed:select id FROM `al` where city='Clio' && SIC_code='4841'DB:business_master_new
loadtime:0.75458407402039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clopton' limit 1
loadtime:0.75462818145752 / seconds
Query Executed:select id FROM `al` where city='Clopton' && SIC_code='4841'DB:business_master_new
loadtime:0.75768804550171 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coaling' limit 1
loadtime:0.75775098800659 / seconds
Query Executed:select id FROM `al` where city='Coaling' && SIC_code='4841'DB:business_master_new
loadtime:0.76097202301025 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coden' limit 1
loadtime:0.76100206375122 / seconds
Query Executed:select id FROM `al` where city='Coden' && SIC_code='4841'DB:business_master_new
loadtime:0.7614061832428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffee Springs' limit 1
loadtime:0.76144909858704 / seconds
Query Executed:select id FROM `al` where city='Coffee Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.78486609458923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coffeeville' limit 1
loadtime:0.78491401672363 / seconds
Query Executed:select id FROM `al` where city='Coffeeville' && SIC_code='4841'DB:business_master_new
loadtime:0.7853410243988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coker' limit 1
loadtime:0.78537201881409 / seconds
Query Executed:select id FROM `al` where city='Coker' && SIC_code='4841'DB:business_master_new
loadtime:0.78579020500183 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinsville' limit 1
loadtime:0.78583312034607 / seconds
Query Executed:select id FROM `al` where city='Collinsville' && SIC_code='4841'DB:business_master_new
loadtime:0.78629612922668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbia' limit 1
loadtime:0.78634405136108 / seconds
Query Executed:select id FROM `al` where city='Columbia' && SIC_code='4841'DB:business_master_new
loadtime:0.78677916526794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Columbiana' limit 1
loadtime:0.78682112693787 / seconds
Query Executed:select id FROM `al` where city='Columbiana' && SIC_code='4841'DB:business_master_new
loadtime:0.78837513923645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cook Springs' limit 1
loadtime:0.78840613365173 / seconds
Query Executed:select id FROM `al` where city='Cook Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.79365611076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosa Pines' limit 1
loadtime:0.79370307922363 / seconds
Query Executed:select id FROM `al` where city='Coosa Pines' && SIC_code='4841'DB:business_master_new
loadtime:0.79400706291199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coosada' limit 1
loadtime:0.79404401779175 / seconds
Query Executed:select id FROM `al` where city='Coosada' && SIC_code='4841'DB:business_master_new
loadtime:0.80322909355164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cordova' limit 1
loadtime:0.80327796936035 / seconds
Query Executed:select id FROM `al` where city='Cordova' && SIC_code='4841'DB:business_master_new
loadtime:0.80373311042786 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottondale' limit 1
loadtime:0.80378699302673 / seconds
Query Executed:select id FROM `al` where city='Cottondale' && SIC_code='4841'DB:business_master_new
loadtime:0.80630397796631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonton' limit 1
loadtime:0.80634713172913 / seconds
Query Executed:select id FROM `al` where city='Cottonton' && SIC_code='4841'DB:business_master_new
loadtime:0.81074905395508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.81079912185669 / seconds
Query Executed:select id FROM `al` where city='Cottonwood' && SIC_code='4841'DB:business_master_new
loadtime:0.8112461566925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Courtland' limit 1
loadtime:0.81127715110779 / seconds
Query Executed:select id FROM `al` where city='Courtland' && SIC_code='4841'DB:business_master_new
loadtime:0.81169009208679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cowarts' limit 1
loadtime:0.81174302101135 / seconds
Query Executed:select id FROM `al` where city='Cowarts' && SIC_code='4841'DB:business_master_new
loadtime:0.81213212013245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coy' limit 1
loadtime:0.81216716766357 / seconds
Query Executed:select id FROM `al` where city='Coy' && SIC_code='4841'DB:business_master_new
loadtime:0.81400609016418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cragford' limit 1
loadtime:0.81404709815979 / seconds
Query Executed:select id FROM `al` where city='Cragford' && SIC_code='4841'DB:business_master_new
loadtime:0.81442403793335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crane Hill' limit 1
loadtime:0.81445407867432 / seconds
Query Executed:select id FROM `al` where city='Crane Hill' && SIC_code='4841'DB:business_master_new
loadtime:0.81487917900085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Creola' limit 1
loadtime:0.81492900848389 / seconds
Query Executed:select id FROM `al` where city='Creola' && SIC_code='4841'DB:business_master_new
loadtime:0.81536912918091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cromwell' limit 1
loadtime:0.8154091835022 / seconds
Query Executed:select id FROM `al` where city='Cromwell' && SIC_code='4841'DB:business_master_new
loadtime:0.81598210334778 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cropwell' limit 1
loadtime:0.81601715087891 / seconds
Query Executed:select id FROM `al` where city='Cropwell' && SIC_code='4841'DB:business_master_new
loadtime:0.81645703315735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Crossville' limit 1
loadtime:0.81649899482727 / seconds
Query Executed:select id FROM `al` where city='Crossville' && SIC_code='4841'DB:business_master_new
loadtime:0.8186399936676 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cuba' limit 1
loadtime:0.81868815422058 / seconds
Query Executed:select id FROM `al` where city='Cuba' && SIC_code='4841'DB:business_master_new
loadtime:0.81979298591614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cullman' limit 1
loadtime:0.81984210014343 / seconds
Query Executed:select id FROM `al` where city='Cullman' && SIC_code='4841'DB:business_master_new
loadtime:0.82139205932617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cusseta' limit 1
loadtime:0.8214430809021 / seconds
Query Executed:select id FROM `al` where city='Cusseta' && SIC_code='4841'DB:business_master_new
loadtime:0.83482217788696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dadeville' limit 1
loadtime:0.83485817909241 / seconds
Query Executed:select id FROM `al` where city='Dadeville' && SIC_code='4841'DB:business_master_new
loadtime:0.8354229927063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daleville' limit 1
loadtime:0.83547520637512 / seconds
Query Executed:select id FROM `al` where city='Daleville' && SIC_code='4841'DB:business_master_new
loadtime:0.83602619171143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Danville' limit 1
loadtime:0.8360641002655 / seconds
Query Executed:select id FROM `al` where city='Danville' && SIC_code='4841'DB:business_master_new
loadtime:0.83647608757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daphne' limit 1
loadtime:0.83651804924011 / seconds
Query Executed:select id FROM `al` where city='Daphne' && SIC_code='4841'DB:business_master_new
loadtime:0.83807706832886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dauphin Island' limit 1
loadtime:0.83811402320862 / seconds
Query Executed:select id FROM `al` where city='Dauphin Island' && SIC_code='4841'DB:business_master_new
loadtime:0.83854913711548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Daviston' limit 1
loadtime:0.83859205245972 / seconds
Query Executed:select id FROM `al` where city='Daviston' && SIC_code='4841'DB:business_master_new
loadtime:0.83898520469666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dawson' limit 1
loadtime:0.83903002738953 / seconds
Query Executed:select id FROM `al` where city='Dawson' && SIC_code='4841'DB:business_master_new
loadtime:0.84832406044006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deatsville' limit 1
loadtime:0.84837198257446 / seconds
Query Executed:select id FROM `al` where city='Deatsville' && SIC_code='4841'DB:business_master_new
loadtime:0.84886717796326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Decatur' limit 1
loadtime:0.84891200065613 / seconds
Query Executed:select id FROM `al` where city='Decatur' && SIC_code='4841'DB:business_master_new
loadtime:0.85047817230225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delmar' limit 1
loadtime:0.85051512718201 / seconds
Query Executed:select id FROM `al` where city='Delmar' && SIC_code='4841'DB:business_master_new
loadtime:0.85247611999512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.85251903533936 / seconds
Query Executed:select id FROM `al` where city='Delta' && SIC_code='4841'DB:business_master_new
loadtime:0.86346316337585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Demopolis' limit 1
loadtime:0.86349320411682 / seconds
Query Executed:select id FROM `al` where city='Demopolis' && SIC_code='4841'DB:business_master_new
loadtime:0.86506700515747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Detroit' limit 1
loadtime:0.86511611938477 / seconds
Query Executed:select id FROM `al` where city='Detroit' && SIC_code='4841'DB:business_master_new
loadtime:0.8758761882782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dickinson' limit 1
loadtime:0.87592005729675 / seconds
Query Executed:select id FROM `al` where city='Dickinson' && SIC_code='4841'DB:business_master_new
loadtime:0.87813305854797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixiana' limit 1
loadtime:0.87817716598511 / seconds
Query Executed:select id FROM `al` where city='Dixiana' && SIC_code='4841'DB:business_master_new
loadtime:0.87876915931702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dixons Mills' limit 1
loadtime:0.87881517410278 / seconds
Query Executed:select id FROM `al` where city='Dixons Mills' && SIC_code='4841'DB:business_master_new
loadtime:0.88979315757751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Docena' limit 1
loadtime:0.8898241519928 / seconds
Query Executed:select id FROM `al` where city='Docena' && SIC_code='4841'DB:business_master_new
loadtime:0.89344120025635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dolomite' limit 1
loadtime:0.89348411560059 / seconds
Query Executed:select id FROM `al` where city='Dolomite' && SIC_code='4841'DB:business_master_new
loadtime:0.89389300346375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dora' limit 1
loadtime:0.89392399787903 / seconds
Query Executed:select id FROM `al` where city='Dora' && SIC_code='4841'DB:business_master_new
loadtime:0.89440011978149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dothan' limit 1
loadtime:0.89444303512573 / seconds
Query Executed:select id FROM `al` where city='Dothan' && SIC_code='4841'DB:business_master_new
loadtime:0.89603209495544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Double Springs' limit 1
loadtime:0.89607310295105 / seconds
Query Executed:select id FROM `al` where city='Double Springs' && SIC_code='4841'DB:business_master_new
loadtime:0.89656901359558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Douglas' limit 1
loadtime:0.89661312103271 / seconds
Query Executed:select id FROM `al` where city='Douglas' && SIC_code='4841'DB:business_master_new
loadtime:0.90600109100342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dozier' limit 1
loadtime:0.9060320854187 / seconds
Query Executed:select id FROM `al` where city='Dozier' && SIC_code='4841'DB:business_master_new
loadtime:0.90643310546875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duncanville' limit 1
loadtime:0.90647506713867 / seconds
Query Executed:select id FROM `al` where city='Duncanville' && SIC_code='4841'DB:business_master_new
loadtime:0.90688610076904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutton' limit 1
loadtime:0.9069299697876 / seconds
Query Executed:select id FROM `al` where city='Dutton' && SIC_code='4841'DB:business_master_new
loadtime:0.90731000900269 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Brewton' limit 1
loadtime:0.90734100341797 / seconds
Query Executed:select id FROM `al` where city='East Brewton' && SIC_code='4841'DB:business_master_new
loadtime:0.90832018852234 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Tallassee' limit 1
loadtime:0.90836215019226 / seconds
Query Executed:select id FROM `al` where city='East Tallassee' && SIC_code='4841'DB:business_master_new
loadtime:0.90934705734253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eastaboga' limit 1
loadtime:0.90937614440918 / seconds
Query Executed:select id FROM `al` where city='Eastaboga' && SIC_code='4841'DB:business_master_new
loadtime:0.90981316566467 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echola' limit 1
loadtime:0.90985417366028 / seconds
Query Executed:select id FROM `al` where city='Echola' && SIC_code='4841'DB:business_master_new
loadtime:0.9133780002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eclectic' limit 1
loadtime:0.91340708732605 / seconds
Query Executed:select id FROM `al` where city='Eclectic' && SIC_code='4841'DB:business_master_new
loadtime:0.9138879776001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Edwardsville' limit 1
loadtime:0.91392803192139 / seconds
Query Executed:select id FROM `al` where city='Edwardsville' && SIC_code='4841'DB:business_master_new
loadtime:0.91508507728577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eight Mile' limit 1
loadtime:0.91512107849121 / seconds
Query Executed:select id FROM `al` where city='Eight Mile' && SIC_code='4841'DB:business_master_new
loadtime:0.91557097434998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elba' limit 1
loadtime:0.91561102867126 / seconds
Query Executed:select id FROM `al` where city='Elba' && SIC_code='4841'DB:business_master_new
loadtime:0.91612601280212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.91616797447205 / seconds
Query Executed:select id FROM `al` where city='Elberta' && SIC_code='4841'DB:business_master_new
loadtime:0.9166522026062 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eldridge' limit 1
loadtime:0.91668105125427 / seconds
Query Executed:select id FROM `al` where city='Eldridge' && SIC_code='4841'DB:business_master_new
loadtime:0.92622709274292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elkmont' limit 1
loadtime:0.92626905441284 / seconds
Query Executed:select id FROM `al` where city='Elkmont' && SIC_code='4841'DB:business_master_new
loadtime:0.9267110824585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmore' limit 1
loadtime:0.92677712440491 / seconds
Query Executed:select id FROM `al` where city='Elmore' && SIC_code='4841'DB:business_master_new
loadtime:0.92718911170959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elrod' limit 1
loadtime:0.92722010612488 / seconds
Query Executed:select id FROM `al` where city='Elrod' && SIC_code='4841'DB:business_master_new
loadtime:0.93035006523132 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emelle' limit 1
loadtime:0.93039798736572 / seconds
Query Executed:select id FROM `al` where city='Emelle' && SIC_code='4841'DB:business_master_new
loadtime:0.94248914718628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Empire' limit 1
loadtime:0.9425220489502 / seconds
Query Executed:select id FROM `al` where city='Empire' && SIC_code='4841'DB:business_master_new
loadtime:0.94293904304504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.94298410415649 / seconds
Query Executed:select id FROM `al` where city='Enterprise' && SIC_code='4841'DB:business_master_new
loadtime:0.94455718994141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Epes' limit 1
loadtime:0.94460797309875 / seconds
Query Executed:select id FROM `al` where city='Epes' && SIC_code='4841'DB:business_master_new
loadtime:0.95158314704895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Equality' limit 1
loadtime:0.95161914825439 / seconds
Query Executed:select id FROM `al` where city='Equality' && SIC_code='4841'DB:business_master_new
loadtime:0.95951700210571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Estillfork' limit 1
loadtime:0.95956301689148 / seconds
Query Executed:select id FROM `al` where city='Estillfork' && SIC_code='4841'DB:business_master_new
loadtime:0.96074104309082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ethelsville' limit 1
loadtime:0.9607720375061 / seconds
Query Executed:select id FROM `al` where city='Ethelsville' && SIC_code='4841'DB:business_master_new
loadtime:0.96115612983704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eufaula' limit 1
loadtime:0.96119999885559 / seconds
Query Executed:select id FROM `al` where city='Eufaula' && SIC_code='4841'DB:business_master_new
loadtime:0.96276497840881 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eutaw' limit 1
loadtime:0.96281003952026 / seconds
Query Executed:select id FROM `al` where city='Eutaw' && SIC_code='4841'DB:business_master_new
loadtime:0.96330714225769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eva' limit 1
loadtime:0.96334910392761 / seconds
Query Executed:select id FROM `al` where city='Eva' && SIC_code='4841'DB:business_master_new
loadtime:0.96378111839294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Evergreen' limit 1
loadtime:0.96381616592407 / seconds
Query Executed:select id FROM `al` where city='Evergreen' && SIC_code='4841'DB:business_master_new
loadtime:0.96433305740356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Excel' limit 1
loadtime:0.96437811851501 / seconds
Query Executed:select id FROM `al` where city='Excel' && SIC_code='4841'DB:business_master_new
loadtime:0.96479105949402 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fackler' limit 1
loadtime:0.96483707427979 / seconds
Query Executed:select id FROM `al` where city='Fackler' && SIC_code='4841'DB:business_master_new
loadtime:0.96980500221252 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairfield' limit 1
loadtime:0.96984815597534 / seconds
Query Executed:select id FROM `al` where city='Fairfield' && SIC_code='4841'DB:business_master_new
loadtime:0.97040009498596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairhope' limit 1
loadtime:0.97043013572693 / seconds
Query Executed:select id FROM `al` where city='Fairhope' && SIC_code='4841'DB:business_master_new
loadtime:0.97200798988342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Falkville' limit 1
loadtime:0.97205805778503 / seconds
Query Executed:select id FROM `al` where city='Falkville' && SIC_code='4841'DB:business_master_new
loadtime:0.97251915931702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Faunsdale' limit 1
loadtime:0.97255802154541 / seconds
Query Executed:select id FROM `al` where city='Faunsdale' && SIC_code='4841'DB:business_master_new
loadtime:0.98226404190063 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.98231315612793 / seconds
Query Executed:select id FROM `al` where city='Fayette' && SIC_code='4841'DB:business_master_new
loadtime:0.98390913009644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fitzpatrick' limit 1
loadtime:0.98396420478821 / seconds
Query Executed:select id FROM `al` where city='Fitzpatrick' && SIC_code='4841'DB:business_master_new
loadtime:0.99297213554382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Five Points' limit 1
loadtime:0.99300813674927 / seconds
Query Executed:select id FROM `al` where city='Five Points' && SIC_code='4841'DB:business_master_new
loadtime:1.0042791366577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flat Rock' limit 1
loadtime:1.0043261051178 / seconds
Query Executed:select id FROM `al` where city='Flat Rock' && SIC_code='4841'DB:business_master_new
loadtime:1.0048241615295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Flomaton' limit 1
loadtime:1.004851102829 / seconds
Query Executed:select id FROM `al` where city='Flomaton' && SIC_code='4841'DB:business_master_new
loadtime:1.0053310394287 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florala' limit 1
loadtime:1.0053791999817 / seconds
Query Executed:select id FROM `al` where city='Florala' && SIC_code='4841'DB:business_master_new
loadtime:1.0058610439301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Florence' limit 1
loadtime:1.0058891773224 / seconds
Query Executed:select id FROM `al` where city='Florence' && SIC_code='4841'DB:business_master_new
loadtime:1.0074751377106 / seconds
Query loaded from cache:select * from geodata_geocity where city='Foley' limit 1
loadtime:1.0075290203094 / seconds
Query Executed:select id FROM `al` where city='Foley' && SIC_code='4841'DB:business_master_new
loadtime:1.0091280937195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forest Home' limit 1
loadtime:1.0091769695282 / seconds
Query Executed:select id FROM `al` where city='Forest Home' && SIC_code='4841'DB:business_master_new
loadtime:1.0144062042236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Forkland' limit 1
loadtime:1.014454126358 / seconds
Query Executed:select id FROM `al` where city='Forkland' && SIC_code='4841'DB:business_master_new
loadtime:1.023020029068 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Davis' limit 1
loadtime:1.0230560302734 / seconds
Query Executed:select id FROM `al` where city='Fort Davis' && SIC_code='4841'DB:business_master_new
loadtime:1.0254940986633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Deposit' limit 1
loadtime:1.025542974472 / seconds
Query Executed:select id FROM `al` where city='Fort Deposit' && SIC_code='4841'DB:business_master_new
loadtime:1.0260081291199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Mitchell' limit 1
loadtime:1.0260419845581 / seconds
Query Executed:select id FROM `al` where city='Fort Mitchell' && SIC_code='4841'DB:business_master_new
loadtime:1.0264930725098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Payne' limit 1
loadtime:1.0265440940857 / seconds
Query Executed:select id FROM `al` where city='Fort Payne' && SIC_code='4841'DB:business_master_new
loadtime:1.0281670093536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Rucker' limit 1
loadtime:1.0282101631165 / seconds
Query Executed:select id FROM `al` where city='Fort Rucker' && SIC_code='4841'DB:business_master_new
loadtime:1.0286781787872 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fosters' limit 1
loadtime:1.0287389755249 / seconds
Query Executed:select id FROM `al` where city='Fosters' && SIC_code='4841'DB:business_master_new
loadtime:1.029149055481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Franklin' limit 1
loadtime:1.0291950702667 / seconds
Query Executed:select id FROM `al` where city='Franklin' && SIC_code='4841'DB:business_master_new
loadtime:1.0351510047913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Frisco City' limit 1
loadtime:1.0351979732513 / seconds
Query Executed:select id FROM `al` where city='Frisco City' && SIC_code='4841'DB:business_master_new
loadtime:1.0356690883636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitdale' limit 1
loadtime:1.0357251167297 / seconds
Query Executed:select id FROM `al` where city='Fruitdale' && SIC_code='4841'DB:business_master_new
loadtime:1.0466041564941 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruithurst' limit 1
loadtime:1.0466401576996 / seconds
Query Executed:select id FROM `al` where city='Fruithurst' && SIC_code='4841'DB:business_master_new
loadtime:1.0568912029266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fulton' limit 1
loadtime:1.0569381713867 / seconds
Query Executed:select id FROM `al` where city='Fulton' && SIC_code='4841'DB:business_master_new
loadtime:1.0622820854187 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fultondale' limit 1
loadtime:1.0623171329498 / seconds
Query Executed:select id FROM `al` where city='Fultondale' && SIC_code='4841'DB:business_master_new
loadtime:1.0627961158752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Furman' limit 1
loadtime:1.0628349781036 / seconds
Query Executed:select id FROM `al` where city='Furman' && SIC_code='4841'DB:business_master_new
loadtime:1.0638751983643 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fyffe' limit 1
loadtime:1.0639100074768 / seconds
Query Executed:select id FROM `al` where city='Fyffe' && SIC_code='4841'DB:business_master_new
loadtime:1.0643990039825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gadsden' limit 1
loadtime:1.0644471645355 / seconds
Query Executed:select id FROM `al` where city='Gadsden' && SIC_code='4841'DB:business_master_new
loadtime:1.0660610198975 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainestown' limit 1
loadtime:1.0661070346832 / seconds
Query Executed:select id FROM `al` where city='Gainestown' && SIC_code='4841'DB:business_master_new
loadtime:1.0681500434875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gainesville' limit 1
loadtime:1.0682020187378 / seconds
Query Executed:select id FROM `al` where city='Gainesville' && SIC_code='4841'DB:business_master_new
loadtime:1.0764100551605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallant' limit 1
loadtime:1.0764591693878 / seconds
Query Executed:select id FROM `al` where city='Gallant' && SIC_code='4841'DB:business_master_new
loadtime:1.0850121974945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gallion' limit 1
loadtime:1.0850470066071 / seconds
Query Executed:select id FROM `al` where city='Gallion' && SIC_code='4841'DB:business_master_new
loadtime:1.0854921340942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gantt' limit 1
loadtime:1.085541009903 / seconds
Query Executed:select id FROM `al` where city='Gantt' && SIC_code='4841'DB:business_master_new
loadtime:1.0910811424255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:1.0911400318146 / seconds
Query Executed:select id FROM `al` where city='Garden City' && SIC_code='4841'DB:business_master_new
loadtime:1.0981750488281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gardendale' limit 1
loadtime:1.0982110500336 / seconds
Query Executed:select id FROM `al` where city='Gardendale' && SIC_code='4841'DB:business_master_new
loadtime:1.099837064743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gaylesville' limit 1
loadtime:1.0998921394348 / seconds
Query Executed:select id FROM `al` where city='Gaylesville' && SIC_code='4841'DB:business_master_new
loadtime:1.1003561019897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geneva' limit 1
loadtime:1.1004021167755 / seconds
Query Executed:select id FROM `al` where city='Geneva' && SIC_code='4841'DB:business_master_new
loadtime:1.100967168808 / seconds
Query loaded from cache:select * from geodata_geocity where city='Georgiana' limit 1
loadtime:1.1010181903839 / seconds
Query Executed:select id FROM `al` where city='Georgiana' && SIC_code='4841'DB:business_master_new
loadtime:1.1014890670776 / seconds
Query loaded from cache:select * from geodata_geocity where city='Geraldine' limit 1
loadtime:1.1015250682831 / seconds
Query Executed:select id FROM `al` where city='Geraldine' && SIC_code='4841'DB:business_master_new
loadtime:1.1019630432129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gilbertown' limit 1
loadtime:1.1020021438599 / seconds
Query Executed:select id FROM `al` where city='Gilbertown' && SIC_code='4841'DB:business_master_new
loadtime:1.1024219989777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glen Allen' limit 1
loadtime:1.1024479866028 / seconds
Query Executed:select id FROM `al` where city='Glen Allen' && SIC_code='4841'DB:business_master_new
loadtime:1.1043241024017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glencoe' limit 1
loadtime:1.104376077652 / seconds
Query Executed:select id FROM `al` where city='Glencoe' && SIC_code='4841'DB:business_master_new
loadtime:1.1047701835632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:1.1048121452332 / seconds
Query Executed:select id FROM `al` where city='Glenwood' && SIC_code='4841'DB:business_master_new
loadtime:1.1108989715576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodsprings' limit 1
loadtime:1.1109480857849 / seconds
Query Executed:select id FROM `al` where city='Goodsprings' && SIC_code='4841'DB:business_master_new
loadtime:1.1133131980896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodwater' limit 1
loadtime:1.1133480072021 / seconds
Query Executed:select id FROM `al` where city='Goodwater' && SIC_code='4841'DB:business_master_new
loadtime:1.113795042038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goodway' limit 1
loadtime:1.1138341426849 / seconds
Query Executed:select id FROM `al` where city='Goodway' && SIC_code='4841'DB:business_master_new
loadtime:1.1150810718536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordo' limit 1
loadtime:1.1151161193848 / seconds
Query Executed:select id FROM `al` where city='Gordo' && SIC_code='4841'DB:business_master_new
loadtime:1.1155610084534 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gordon' limit 1
loadtime:1.1156029701233 / seconds
Query Executed:select id FROM `al` where city='Gordon' && SIC_code='4841'DB:business_master_new
loadtime:1.1160461902618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:1.1160969734192 / seconds
Query Executed:select id FROM `al` where city='Goshen' && SIC_code='4841'DB:business_master_new
loadtime:1.1165289878845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grady' limit 1
loadtime:1.1165721416473 / seconds
Query Executed:select id FROM `al` where city='Grady' && SIC_code='4841'DB:business_master_new
loadtime:1.1266901493073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graham' limit 1
loadtime:1.1267440319061 / seconds
Query Executed:select id FROM `al` where city='Graham' && SIC_code='4841'DB:business_master_new
loadtime:1.1348731517792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grand Bay' limit 1
loadtime:1.1349210739136 / seconds
Query Executed:select id FROM `al` where city='Grand Bay' && SIC_code='4841'DB:business_master_new
loadtime:1.1354351043701 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grant' limit 1
loadtime:1.1354711055756 / seconds
Query Executed:select id FROM `al` where city='Grant' && SIC_code='4841'DB:business_master_new
loadtime:1.1359801292419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Graysville' limit 1
loadtime:1.1360189914703 / seconds
Query Executed:select id FROM `al` where city='Graysville' && SIC_code='4841'DB:business_master_new
loadtime:1.1364281177521 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green Pond' limit 1
loadtime:1.1364541053772 / seconds
Query Executed:select id FROM `al` where city='Green Pond' && SIC_code='4841'DB:business_master_new
loadtime:1.1434950828552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greensboro' limit 1
loadtime:1.1435441970825 / seconds
Query Executed:select id FROM `al` where city='Greensboro' && SIC_code='4841'DB:business_master_new
loadtime:1.1441130638123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:1.1441640853882 / seconds
Query Executed:select id FROM `al` where city='Greenville' && SIC_code='4841'DB:business_master_new
loadtime:1.1457481384277 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grove Hill' limit 1
loadtime:1.1457901000977 / seconds
Query Executed:select id FROM `al` where city='Grove Hill' && SIC_code='4841'DB:business_master_new
loadtime:1.1463429927826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Groveoak' limit 1
loadtime:1.1463980674744 / seconds
Query Executed:select id FROM `al` where city='Groveoak' && SIC_code='4841'DB:business_master_new
loadtime:1.1563491821289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guin' limit 1
loadtime:1.1563839912415 / seconds
Query Executed:select id FROM `al` where city='Guin' && SIC_code='4841'DB:business_master_new
loadtime:1.156867980957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gulf Shores' limit 1
loadtime:1.1569180488586 / seconds
Query Executed:select id FROM `al` where city='Gulf Shores' && SIC_code='4841'DB:business_master_new
loadtime:1.1584930419922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunter Afs' limit 1
loadtime:1.158536195755 / seconds
Query Executed:select id FROM `al` where city='Gunter Afs' && SIC_code='4841'DB:business_master_new
loadtime:1.1588401794434 / seconds
Query loaded from cache:select * from geodata_geocity where city='Guntersville' limit 1
loadtime:1.1588790416718 / seconds
Query Executed:select id FROM `al` where city='Guntersville' && SIC_code='4841'DB:business_master_new
loadtime:1.1604640483856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gurley' limit 1
loadtime:1.1605072021484 / seconds
Query Executed:select id FROM `al` where city='Gurley' && SIC_code='4841'DB:business_master_new
loadtime:1.1610519886017 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hackleburg' limit 1
loadtime:1.1611070632935 / seconds
Query Executed:select id FROM `al` where city='Hackleburg' && SIC_code='4841'DB:business_master_new
loadtime:1.1615340709686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Haleyville' limit 1
loadtime:1.1615791320801 / seconds
Query Executed:select id FROM `al` where city='Haleyville' && SIC_code='4841'DB:business_master_new
loadtime:1.1631700992584 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hamilton' limit 1
loadtime:1.1632051467896 / seconds
Query Executed:select id FROM `al` where city='Hamilton' && SIC_code='4841'DB:business_master_new
loadtime:1.1647670269012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanceville' limit 1
loadtime:1.1648230552673 / seconds
Query Executed:select id FROM `al` where city='Hanceville' && SIC_code='4841'DB:business_master_new
loadtime:1.1654031276703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harpersville' limit 1
loadtime:1.165452003479 / seconds
Query Executed:select id FROM `al` where city='Harpersville' && SIC_code='4841'DB:business_master_new
loadtime:1.165892124176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartford' limit 1
loadtime:1.1659390926361 / seconds
Query Executed:select id FROM `al` where city='Hartford' && SIC_code='4841'DB:business_master_new
loadtime:1.166454076767 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hartselle' limit 1
loadtime:1.1664900779724 / seconds
Query Executed:select id FROM `al` where city='Hartselle' && SIC_code='4841'DB:business_master_new
loadtime:1.168074131012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Harvest' limit 1
loadtime:1.168121099472 / seconds
Query Executed:select id FROM `al` where city='Harvest' && SIC_code='4841'DB:business_master_new
loadtime:1.1686601638794 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatchechubbee' limit 1
loadtime:1.1687030792236 / seconds
Query Executed:select id FROM `al` where city='Hatchechubbee' && SIC_code='4841'DB:business_master_new
loadtime:1.1750741004944 / seconds
Query loaded from cache:select * from geodata_geocity where city='Havana' limit 1
loadtime:1.1751229763031 / seconds
Query Executed:select id FROM `al` where city='Havana' && SIC_code='4841'DB:business_master_new
loadtime:1.1756219863892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayden' limit 1
loadtime:1.1756570339203 / seconds
Query Executed:select id FROM `al` where city='Hayden' && SIC_code='4841'DB:business_master_new
loadtime:1.1761410236359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hayneville' limit 1
loadtime:1.1761770248413 / seconds
Query Executed:select id FROM `al` where city='Hayneville' && SIC_code='4841'DB:business_master_new
loadtime:1.1766641139984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hazel Green' limit 1
loadtime:1.1767380237579 / seconds
Query Executed:select id FROM `al` where city='Hazel Green' && SIC_code='4841'DB:business_master_new
loadtime:1.1772980690002 / seconds
Query loaded from cache:select * from geodata_geocity where city='Headland' limit 1
loadtime:1.1773381233215 / seconds
Query Executed:select id FROM `al` where city='Headland' && SIC_code='4841'DB:business_master_new
loadtime:1.1778581142426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heflin' limit 1
loadtime:1.1778981685638 / seconds
Query Executed:select id FROM `al` where city='Heflin' && SIC_code='4841'DB:business_master_new
loadtime:1.1784300804138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helena' limit 1
loadtime:1.1784691810608 / seconds
Query Executed:select id FROM `al` where city='Helena' && SIC_code='4841'DB:business_master_new
loadtime:1.1790330410004 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henagar' limit 1
loadtime:1.1790821552277 / seconds
Query Executed:select id FROM `al` where city='Henagar' && SIC_code='4841'DB:business_master_new
loadtime:1.1795880794525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Higdon' limit 1
loadtime:1.1796231269836 / seconds
Query Executed:select id FROM `al` where city='Higdon' && SIC_code='4841'DB:business_master_new
loadtime:1.1800651550293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland Home' limit 1
loadtime:1.180114030838 / seconds
Query Executed:select id FROM `al` where city='Highland Home' && SIC_code='4841'DB:business_master_new
loadtime:1.1805419921875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hillsboro' limit 1
loadtime:1.1805880069733 / seconds
Query Executed:select id FROM `al` where city='Hillsboro' && SIC_code='4841'DB:business_master_new
loadtime:1.1810591220856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hodges' limit 1
loadtime:1.181095123291 / seconds
Query Executed:select id FROM `al` where city='Hodges' && SIC_code='4841'DB:business_master_new
loadtime:1.1884090900421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hokes Bluff' limit 1
loadtime:1.1884551048279 / seconds
Query Executed:select id FROM `al` where city='Hokes Bluff' && SIC_code='4841'DB:business_master_new
loadtime:1.1898820400238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollins' limit 1
loadtime:1.1899220943451 / seconds
Query Executed:select id FROM `al` where city='Hollins' && SIC_code='4841'DB:business_master_new
loadtime:1.1915221214294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holly Pond' limit 1
loadtime:1.1915709972382 / seconds
Query Executed:select id FROM `al` where city='Holly Pond' && SIC_code='4841'DB:business_master_new
loadtime:1.1920521259308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollytree' limit 1
loadtime:1.1920871734619 / seconds
Query Executed:select id FROM `al` where city='Hollytree' && SIC_code='4841'DB:business_master_new
loadtime:1.1952970027924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hollywood' limit 1
loadtime:1.195347070694 / seconds
Query Executed:select id FROM `al` where city='Hollywood' && SIC_code='4841'DB:business_master_new
loadtime:1.1957700252533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holt' limit 1
loadtime:1.195808172226 / seconds
Query Executed:select id FROM `al` where city='Holt' && SIC_code='4841'DB:business_master_new
loadtime:1.1961331367493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holy Trinity' limit 1
loadtime:1.1961681842804 / seconds
Query Executed:select id FROM `al` where city='Holy Trinity' && SIC_code='4841'DB:business_master_new
loadtime:1.1973819732666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Homewood' limit 1
loadtime:1.1974301338196 / seconds
Query Executed:select id FROM `al` where city='Homewood' && SIC_code='4841'DB:business_master_new
loadtime:1.2042350769043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honoraville' limit 1
loadtime:1.2042820453644 / seconds
Query Executed:select id FROM `al` where city='Honoraville' && SIC_code='4841'DB:business_master_new
loadtime:1.2148141860962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hope Hull' limit 1
loadtime:1.2148489952087 / seconds
Query Executed:select id FROM `al` where city='Hope Hull' && SIC_code='4841'DB:business_master_new
loadtime:1.215311050415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Horton' limit 1
loadtime:1.2153570652008 / seconds
Query Executed:select id FROM `al` where city='Horton' && SIC_code='4841'DB:business_master_new
loadtime:1.2158319950104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Houston' limit 1
loadtime:1.215882062912 / seconds
Query Executed:select id FROM `al` where city='Houston' && SIC_code='4841'DB:business_master_new
loadtime:1.2227430343628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hueytown' limit 1
loadtime:1.2227840423584 / seconds
Query Executed:select id FROM `al` where city='Hueytown' && SIC_code='4841'DB:business_master_new
loadtime:1.2282271385193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntsville' limit 1
loadtime:1.2282750606537 / seconds
Query Executed:select id FROM `al` where city='Huntsville' && SIC_code='4841'DB:business_master_new
loadtime:1.2298901081085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurtsboro' limit 1
loadtime:1.2299380302429 / seconds
Query Executed:select id FROM `al` where city='Hurtsboro' && SIC_code='4841'DB:business_master_new
loadtime:1.2303671836853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huxford' limit 1
loadtime:1.2304170131683 / seconds
Query Executed:select id FROM `al` where city='Huxford' && SIC_code='4841'DB:business_master_new
loadtime:1.2344441413879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ider' limit 1
loadtime:1.2344930171967 / seconds
Query Executed:select id FROM `al` where city='Ider' && SIC_code='4841'DB:business_master_new
loadtime:1.234934091568 / seconds
Query loaded from cache:select * from geodata_geocity where city='Indian Springs' limit 1
loadtime:1.2349619865417 / seconds
Query Executed:select id FROM `al` where city='Indian Springs' && SIC_code='4841'DB:business_master_new
loadtime:1.2352690696716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irondale' limit 1
loadtime:1.2353150844574 / seconds
Query Executed:select id FROM `al` where city='Irondale' && SIC_code='4841'DB:business_master_new
loadtime:1.2398900985718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Irvington' limit 1
loadtime:1.2399251461029 / seconds
Query Executed:select id FROM `al` where city='Irvington' && SIC_code='4841'DB:business_master_new
loadtime:1.2404370307922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jachin' limit 1
loadtime:1.2404839992523 / seconds
Query Executed:select id FROM `al` where city='Jachin' && SIC_code='4841'DB:business_master_new
loadtime:1.2433869838715 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jack' limit 1
loadtime:1.2434220314026 / seconds
Query Executed:select id FROM `al` where city='Jack' && SIC_code='4841'DB:business_master_new
loadtime:1.2499761581421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jackson' limit 1
loadtime:1.2500231266022 / seconds
Query Executed:select id FROM `al` where city='Jackson' && SIC_code='4841'DB:business_master_new
loadtime:1.2506401538849 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksons Gap' limit 1
loadtime:1.250687122345 / seconds
Query Executed:select id FROM `al` where city='Jacksons Gap' && SIC_code='4841'DB:business_master_new
loadtime:1.2511520385742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jacksonville' limit 1
loadtime:1.2511870861053 / seconds
Query Executed:select id FROM `al` where city='Jacksonville' && SIC_code='4841'DB:business_master_new
loadtime:1.2527620792389 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jasper' limit 1
loadtime:1.2528111934662 / seconds
Query Executed:select id FROM `al` where city='Jasper' && SIC_code='4841'DB:business_master_new
loadtime:1.2544009685516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jefferson' limit 1
loadtime:1.2544569969177 / seconds
Query Executed:select id FROM `al` where city='Jefferson' && SIC_code='4841'DB:business_master_new
loadtime:1.2553009986877 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jemison' limit 1
loadtime:1.255350112915 / seconds
Query Executed:select id FROM `al` where city='Jemison' && SIC_code='4841'DB:business_master_new
loadtime:1.2558381557465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jones' limit 1
loadtime:1.2558650970459 / seconds
Query Executed:select id FROM `al` where city='Jones' && SIC_code='4841'DB:business_master_new
loadtime:1.2592010498047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joppa' limit 1
loadtime:1.2592489719391 / seconds
Query Executed:select id FROM `al` where city='Joppa' && SIC_code='4841'DB:business_master_new
loadtime:1.2596981525421 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellerman' limit 1
loadtime:1.259770154953 / seconds
Query Executed:select id FROM `al` where city='Kellerman' && SIC_code='4841'DB:business_master_new
loadtime:1.2600281238556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kellyton' limit 1
loadtime:1.2600591182709 / seconds
Query Executed:select id FROM `al` where city='Kellyton' && SIC_code='4841'DB:business_master_new
loadtime:1.2747390270233 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kennedy' limit 1
loadtime:1.2747890949249 / seconds
Query Executed:select id FROM `al` where city='Kennedy' && SIC_code='4841'DB:business_master_new
loadtime:1.2752311229706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Killen' limit 1
loadtime:1.275276184082 / seconds
Query Executed:select id FROM `al` where city='Killen' && SIC_code='4841'DB:business_master_new
loadtime:1.2758259773254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kimberly' limit 1
loadtime:1.2758531570435 / seconds
Query Executed:select id FROM `al` where city='Kimberly' && SIC_code='4841'DB:business_master_new
loadtime:1.2847311496735 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinsey' limit 1
loadtime:1.2847940921783 / seconds
Query Executed:select id FROM `al` where city='Kinsey' && SIC_code='4841'DB:business_master_new
loadtime:1.2851140499115 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kinston' limit 1
loadtime:1.2851600646973 / seconds
Query Executed:select id FROM `al` where city='Kinston' && SIC_code='4841'DB:business_master_new
loadtime:1.2855930328369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Knoxville' limit 1
loadtime:1.2856290340424 / seconds
Query Executed:select id FROM `al` where city='Knoxville' && SIC_code='4841'DB:business_master_new
loadtime:1.2897911071777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laceys Spring' limit 1
loadtime:1.2898380756378 / seconds
Query Executed:select id FROM `al` where city='Laceys Spring' && SIC_code='4841'DB:business_master_new
loadtime:1.2903571128845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lafayette' limit 1
loadtime:1.2904050350189 / seconds
Query Executed:select id FROM `al` where city='Lafayette' && SIC_code='4841'DB:business_master_new
loadtime:1.2909541130066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lanett' limit 1
loadtime:1.2909879684448 / seconds
Query Executed:select id FROM `al` where city='Lanett' && SIC_code='4841'DB:business_master_new
loadtime:1.2916030883789 / seconds
Query loaded from cache:select * from geodata_geocity where city='Langston' limit 1
loadtime:1.2916569709778 / seconds
Query Executed:select id FROM `al` where city='Langston' && SIC_code='4841'DB:business_master_new
loadtime:1.2971301078796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapine' limit 1
loadtime:1.2971661090851 / seconds
Query Executed:select id FROM `al` where city='Lapine' && SIC_code='4841'DB:business_master_new
loadtime:1.2976150512695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lavaca' limit 1
loadtime:1.2976620197296 / seconds
Query Executed:select id FROM `al` where city='Lavaca' && SIC_code='4841'DB:business_master_new
loadtime:1.2979290485382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lawley' limit 1
loadtime:1.2979600429535 / seconds
Query Executed:select id FROM `al` where city='Lawley' && SIC_code='4841'DB:business_master_new
loadtime:1.3014199733734 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:1.3014671802521 / seconds
Query Executed:select id FROM `al` where city='Leeds' && SIC_code='4841'DB:business_master_new
loadtime:1.3020761013031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leesburg' limit 1
loadtime:1.302139043808 / seconds
Query Executed:select id FROM `al` where city='Leesburg' && SIC_code='4841'DB:business_master_new
loadtime:1.3025681972504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leighton' limit 1
loadtime:1.3025951385498 / seconds
Query Executed:select id FROM `al` where city='Leighton' && SIC_code='4841'DB:business_master_new
loadtime:1.3030300140381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leroy' limit 1
loadtime:1.3030691146851 / seconds
Query Executed:select id FROM `al` where city='Leroy' && SIC_code='4841'DB:business_master_new
loadtime:1.3034811019897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lester' limit 1
loadtime:1.303512096405 / seconds
Query Executed:select id FROM `al` where city='Lester' && SIC_code='4841'DB:business_master_new
loadtime:1.3081111907959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Letohatchee' limit 1
loadtime:1.3081500530243 / seconds
Query Executed:select id FROM `al` where city='Letohatchee' && SIC_code='4841'DB:business_master_new
loadtime:1.3085629940033 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lexington' limit 1
loadtime:1.308601140976 / seconds
Query Executed:select id FROM `al` where city='Lexington' && SIC_code='4841'DB:business_master_new
loadtime:1.3090710639954 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lillian' limit 1
loadtime:1.3091170787811 / seconds
Query Executed:select id FROM `al` where city='Lillian' && SIC_code='4841'DB:business_master_new
loadtime:1.3095691204071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lincoln' limit 1
loadtime:1.3095951080322 / seconds
Query Executed:select id FROM `al` where city='Lincoln' && SIC_code='4841'DB:business_master_new
loadtime:1.3100960254669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Linden' limit 1
loadtime:1.3101420402527 / seconds
Query Executed:select id FROM `al` where city='Linden' && SIC_code='4841'DB:business_master_new
loadtime:1.3106331825256 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lineville' limit 1
loadtime:1.3106601238251 / seconds
Query Executed:select id FROM `al` where city='Lineville' && SIC_code='4841'DB:business_master_new
loadtime:1.3111340999603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lisman' limit 1
loadtime:1.311182975769 / seconds
Query Executed:select id FROM `al` where city='Lisman' && SIC_code='4841'DB:business_master_new
loadtime:1.3115890026093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Livingston' limit 1
loadtime:1.3116261959076 / seconds
Query Executed:select id FROM `al` where city='Livingston' && SIC_code='4841'DB:business_master_new
loadtime:1.312185049057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loachapoka' limit 1
loadtime:1.3122301101685 / seconds
Query Executed:select id FROM `al` where city='Loachapoka' && SIC_code='4841'DB:business_master_new
loadtime:1.3181281089783 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lockhart' limit 1
loadtime:1.3181791305542 / seconds
Query Executed:select id FROM `al` where city='Lockhart' && SIC_code='4841'DB:business_master_new
loadtime:1.3252589702606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Locust Fork' limit 1
loadtime:1.3253080844879 / seconds
Query Executed:select id FROM `al` where city='Locust Fork' && SIC_code='4841'DB:business_master_new
loadtime:1.3257400989532 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:1.3257710933685 / seconds
Query Executed:select id FROM `al` where city='Logan' && SIC_code='4841'DB:business_master_new
loadtime:1.3338060379028 / seconds
Query loaded from cache:select * from geodata_geocity where city='Louisville' limit 1
loadtime:1.3338551521301 / seconds
Query Executed:select id FROM `al` where city='Louisville' && SIC_code='4841'DB:business_master_new
loadtime:1.3343040943146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lower Peach Tree' limit 1
loadtime:1.3343391418457 / seconds
Query Executed:select id FROM `al` where city='Lower Peach Tree' && SIC_code='4841'DB:business_master_new
loadtime:1.3407411575317 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lowndesboro' limit 1
loadtime:1.3407900333405 / seconds
Query Executed:select id FROM `al` where city='Lowndesboro' && SIC_code='4841'DB:business_master_new
loadtime:1.3412280082703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loxley' limit 1
loadtime:1.3412630558014 / seconds
Query Executed:select id FROM `al` where city='Loxley' && SIC_code='4841'DB:business_master_new
loadtime:1.3417811393738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Luverne' limit 1
loadtime:1.3418300151825 / seconds
Query Executed:select id FROM `al` where city='Luverne' && SIC_code='4841'DB:business_master_new
loadtime:1.3423511981964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynn' limit 1
loadtime:1.3423960208893 / seconds
Query Executed:select id FROM `al` where city='Lynn' && SIC_code='4841'DB:business_master_new
loadtime:1.3428061008453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Madison' limit 1
loadtime:1.3428540229797 / seconds
Query Executed:select id FROM `al` where city='Madison' && SIC_code='4841'DB:business_master_new
loadtime:1.3444700241089 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia' limit 1
loadtime:1.3445250988007 / seconds
Query Executed:select id FROM `al` where city='Magnolia' && SIC_code='4841'DB:business_master_new
loadtime:1.3469750881195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magnolia Springs' limit 1
loadtime:1.3470160961151 / seconds
Query Executed:select id FROM `al` where city='Magnolia Springs' && SIC_code='4841'DB:business_master_new
loadtime:1.347442150116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Malcolm' limit 1
loadtime:1.3474910259247 / seconds
Query Executed:select id FROM `al` where city='Malcolm' && SIC_code='4841'DB:business_master_new
loadtime:1.3488790988922 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maplesville' limit 1
loadtime:1.3489291667938 / seconds
Query Executed:select id FROM `al` where city='Maplesville' && SIC_code='4841'DB:business_master_new
loadtime:1.3493931293488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marbury' limit 1
loadtime:1.3494381904602 / seconds
Query Executed:select id FROM `al` where city='Marbury' && SIC_code='4841'DB:business_master_new
loadtime:1.3498389720917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Margaret' limit 1
loadtime:1.3498661518097 / seconds
Query Executed:select id FROM `al` where city='Margaret' && SIC_code='4841'DB:business_master_new
loadtime:1.3555860519409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion' limit 1
loadtime:1.355633020401 / seconds
Query Executed:select id FROM `al` where city='Marion' && SIC_code='4841'DB:business_master_new
loadtime:1.3562049865723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marion Junction' limit 1
loadtime:1.3562541007996 / seconds
Query Executed:select id FROM `al` where city='Marion Junction' && SIC_code='4841'DB:business_master_new
loadtime:1.3566851615906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mathews' limit 1
loadtime:1.3567340373993 / seconds
Query Executed:select id FROM `al` where city='Mathews' && SIC_code='4841'DB:business_master_new
loadtime:1.3621411323547 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maxwell Afb' limit 1
loadtime:1.3621900081635 / seconds
Query Executed:select id FROM `al` where city='Maxwell Afb' && SIC_code='4841'DB:business_master_new
loadtime:1.3633019924164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Maylene' limit 1
loadtime:1.3633441925049 / seconds
Query Executed:select id FROM `al` where city='Maylene' && SIC_code='4841'DB:business_master_new
loadtime:1.3637850284576 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Calla' limit 1
loadtime:1.3638231754303 / seconds
Query Executed:select id FROM `al` where city='Mc Calla' && SIC_code='4841'DB:business_master_new
loadtime:1.3643360137939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Intosh' limit 1
loadtime:1.364382982254 / seconds
Query Executed:select id FROM `al` where city='Mc Intosh' && SIC_code='4841'DB:business_master_new
loadtime:1.3648080825806 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Kenzie' limit 1
loadtime:1.3648431301117 / seconds
Query Executed:select id FROM `al` where city='Mc Kenzie' && SIC_code='4841'DB:business_master_new
loadtime:1.3652579784393 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Shan' limit 1
loadtime:1.3653070926666 / seconds
Query Executed:select id FROM `al` where city='Mc Shan' && SIC_code='4841'DB:business_master_new
loadtime:1.3661201000214 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mc Williams' limit 1
loadtime:1.3661561012268 / seconds
Query Executed:select id FROM `al` where city='Mc Williams' && SIC_code='4841'DB:business_master_new
loadtime:1.3667101860046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mcintosh' limit 1
loadtime:1.3667631149292 / seconds
Query Executed:select id FROM `al` where city='Mcintosh' && SIC_code='4841'DB:business_master_new
loadtime:1.367035150528 / seconds
Query loaded from cache:select * from geodata_geocity where city='Megargel' limit 1
loadtime:1.3670670986176 / seconds
Query Executed:select id FROM `al` where city='Megargel' && SIC_code='4841'DB:business_master_new
loadtime:1.3685901165009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Melvin' limit 1
loadtime:1.368625164032 / seconds
Query Executed:select id FROM `al` where city='Melvin' && SIC_code='4841'DB:business_master_new
loadtime:1.3712520599365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mentone' limit 1
loadtime:1.3712990283966 / seconds
Query Executed:select id FROM `al` where city='Mentone' && SIC_code='4841'DB:business_master_new
loadtime:1.3717091083527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meridianville' limit 1
loadtime:1.3717679977417 / seconds
Query Executed:select id FROM `al` where city='Meridianville' && SIC_code='4841'DB:business_master_new
loadtime:1.3722569942474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midland City' limit 1
loadtime:1.3723020553589 / seconds
Query Executed:select id FROM `al` where city='Midland City' && SIC_code='4841'DB:business_master_new
loadtime:1.3731951713562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:1.3732550144196 / seconds
Query Executed:select id FROM `al` where city='Midway' && SIC_code='4841'DB:business_master_new
loadtime:1.3739860057831 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millbrook' limit 1
loadtime:1.3740520477295 / seconds
Query Executed:select id FROM `al` where city='Millbrook' && SIC_code='4841'DB:business_master_new
loadtime:1.3750820159912 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millerville' limit 1
loadtime:1.3751420974731 / seconds
Query Executed:select id FROM `al` where city='Millerville' && SIC_code='4841'DB:business_master_new
loadtime:1.3777890205383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millport' limit 1
loadtime:1.3778390884399 / seconds
Query Executed:select id FROM `al` where city='Millport' && SIC_code='4841'DB:business_master_new
loadtime:1.3782861232758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millry' limit 1
loadtime:1.378326177597 / seconds
Query Executed:select id FROM `al` where city='Millry' && SIC_code='4841'DB:business_master_new
loadtime:1.3787801265717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minter' limit 1
loadtime:1.3788180351257 / seconds
Query Executed:select id FROM `al` where city='Minter' && SIC_code='4841'DB:business_master_new
loadtime:1.3866140842438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mobile' limit 1
loadtime:1.386666059494 / seconds
Query Executed:select id FROM `al` where city='Mobile' && SIC_code='4841'DB:business_master_new
loadtime:1.388288974762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroeville' limit 1
loadtime:1.3883371353149 / seconds
Query Executed:select id FROM `al` where city='Monroeville' && SIC_code='4841'DB:business_master_new
loadtime:1.3890311717987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montevallo' limit 1
loadtime:1.3890810012817 / seconds
Query Executed:select id FROM `al` where city='Montevallo' && SIC_code='4841'DB:business_master_new
loadtime:1.3896911144257 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montgomery' limit 1
loadtime:1.3897621631622 / seconds
Query Executed:select id FROM `al` where city='Montgomery' && SIC_code='4841'DB:business_master_new
loadtime:1.3913521766663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montrose' limit 1
loadtime:1.391410112381 / seconds
Query Executed:select id FROM `al` where city='Montrose' && SIC_code='4841'DB:business_master_new
loadtime:1.3918371200562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moody' limit 1
loadtime:1.3918709754944 / seconds
Query Executed:select id FROM `al` where city='Moody' && SIC_code='4841'DB:business_master_new
loadtime:1.3924090862274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mooresville' limit 1
loadtime:1.3924582004547 / seconds
Query Executed:select id FROM `al` where city='Mooresville' && SIC_code='4841'DB:business_master_new
loadtime:1.3979630470276 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morris' limit 1
loadtime:1.3980150222778 / seconds
Query Executed:select id FROM `al` where city='Morris' && SIC_code='4841'DB:business_master_new
loadtime:1.3984761238098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morvin' limit 1
loadtime:1.3985111713409 / seconds
Query Executed:select id FROM `al` where city='Morvin' && SIC_code='4841'DB:business_master_new
loadtime:1.3992590904236 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moulton' limit 1
loadtime:1.3993082046509 / seconds
Query Executed:select id FROM `al` where city='Moulton' && SIC_code='4841'DB:business_master_new
loadtime:1.4008691310883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moundville' limit 1
loadtime:1.4009041786194 / seconds
Query Executed:select id FROM `al` where city='Moundville' && SIC_code='4841'DB:business_master_new
loadtime:1.4013710021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Hope' limit 1
loadtime:1.4014191627502 / seconds
Query Executed:select id FROM `al` where city='Mount Hope' && SIC_code='4841'DB:business_master_new
loadtime:1.4094140529633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Meigs' limit 1
loadtime:1.4094631671906 / seconds
Query Executed:select id FROM `al` where city='Mount Meigs' && SIC_code='4841'DB:business_master_new
loadtime:1.4175500869751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Olive' limit 1
loadtime:1.4175841808319 / seconds
Query Executed:select id FROM `al` where city='Mount Olive' && SIC_code='4841'DB:business_master_new
loadtime:1.4180681705475 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Vernon' limit 1
loadtime:1.4181170463562 / seconds
Query Executed:select id FROM `al` where city='Mount Vernon' && SIC_code='4841'DB:business_master_new
loadtime:1.4185271263123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Brook' limit 1
loadtime:1.418555021286 / seconds
Query Executed:select id FROM `al` where city='Mountain Brook' && SIC_code='4841'DB:business_master_new
loadtime:1.4191210269928 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Hope' limit 1
loadtime:1.4191691875458 / seconds
Query Executed:select id FROM `al` where city='Mt Hope' && SIC_code='4841'DB:business_master_new
loadtime:1.4194390773773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Olive' limit 1
loadtime:1.4194660186768 / seconds
Query Executed:select id FROM `al` where city='Mt Olive' && SIC_code='4841'DB:business_master_new
loadtime:1.4200279712677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Vernon' limit 1
loadtime:1.4200851917267 / seconds
Query Executed:select id FROM `al` where city='Mt Vernon' && SIC_code='4841'DB:business_master_new
loadtime:1.4206571578979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mulga' limit 1
loadtime:1.4206922054291 / seconds
Query Executed:select id FROM `al` where city='Mulga' && SIC_code='4841'DB:business_master_new
loadtime:1.4211540222168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Munford' limit 1
loadtime:1.4212021827698 / seconds
Query Executed:select id FROM `al` where city='Munford' && SIC_code='4841'DB:business_master_new
loadtime:1.4216392040253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscadine' limit 1
loadtime:1.4216740131378 / seconds
Query Executed:select id FROM `al` where city='Muscadine' && SIC_code='4841'DB:business_master_new
loadtime:1.42604804039 / seconds
Query loaded from cache:select * from geodata_geocity where city='Muscle Shoals' limit 1
loadtime:1.4260830879211 / seconds
Query Executed:select id FROM `al` where city='Muscle Shoals' && SIC_code='4841'DB:business_master_new
loadtime:1.4276530742645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myrtlewood' limit 1
loadtime:1.4277021884918 / seconds
Query Executed:select id FROM `al` where city='Myrtlewood' && SIC_code='4841'DB:business_master_new
loadtime:1.4301731586456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nanafalia' limit 1
loadtime:1.4302070140839 / seconds
Query Executed:select id FROM `al` where city='Nanafalia' && SIC_code='4841'DB:business_master_new
loadtime:1.4338901042938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nauvoo' limit 1
loadtime:1.4339389801025 / seconds
Query Executed:select id FROM `al` where city='Nauvoo' && SIC_code='4841'DB:business_master_new
loadtime:1.4344091415405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Needham' limit 1
loadtime:1.4344401359558 / seconds
Query Executed:select id FROM `al` where city='Needham' && SIC_code='4841'DB:business_master_new
loadtime:1.4381129741669 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Brockton' limit 1
loadtime:1.4381580352783 / seconds
Query Executed:select id FROM `al` where city='New Brockton' && SIC_code='4841'DB:business_master_new
loadtime:1.4386160373688 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Hope' limit 1
loadtime:1.4386670589447 / seconds
Query Executed:select id FROM `al` where city='New Hope' && SIC_code='4841'DB:business_master_new
loadtime:1.4391641616821 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Market' limit 1
loadtime:1.4392070770264 / seconds
Query Executed:select id FROM `al` where city='New Market' && SIC_code='4841'DB:business_master_new
loadtime:1.4397070407867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newbern' limit 1
loadtime:1.4397950172424 / seconds
Query Executed:select id FROM `al` where city='Newbern' && SIC_code='4841'DB:business_master_new
loadtime:1.4496080875397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:1.4496500492096 / seconds
Query Executed:select id FROM `al` where city='Newton' && SIC_code='4841'DB:business_master_new
loadtime:1.4501700401306 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newville' limit 1
loadtime:1.4502141475677 / seconds
Query Executed:select id FROM `al` where city='Newville' && SIC_code='4841'DB:business_master_new
loadtime:1.4506440162659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Normal' limit 1
loadtime:1.4506850242615 / seconds
Query Executed:select id FROM `al` where city='Normal' && SIC_code='4841'DB:business_master_new
loadtime:1.4563961029053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Northport' limit 1
loadtime:1.4564361572266 / seconds
Query Executed:select id FROM `al` where city='Northport' && SIC_code='4841'DB:business_master_new
loadtime:1.458065032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Notasulga' limit 1
loadtime:1.4581170082092 / seconds
Query Executed:select id FROM `al` where city='Notasulga' && SIC_code='4841'DB:business_master_new
loadtime:1.4585950374603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak Hill' limit 1
loadtime:1.4586260318756 / seconds
Query Executed:select id FROM `al` where city='Oak Hill' && SIC_code='4841'DB:business_master_new
loadtime:1.4597561359406 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakman' limit 1
loadtime:1.4598090648651 / seconds
Query Executed:select id FROM `al` where city='Oakman' && SIC_code='4841'DB:business_master_new
loadtime:1.4602530002594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Odenville' limit 1
loadtime:1.4602930545807 / seconds
Query Executed:select id FROM `al` where city='Odenville' && SIC_code='4841'DB:business_master_new
loadtime:1.4608201980591 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ohatchee' limit 1
loadtime:1.4608561992645 / seconds
Query Executed:select id FROM `al` where city='Ohatchee' && SIC_code='4841'DB:business_master_new
loadtime:1.4612879753113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oneonta' limit 1
loadtime:1.4613289833069 / seconds
Query Executed:select id FROM `al` where city='Oneonta' && SIC_code='4841'DB:business_master_new
loadtime:1.4629380702972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opelika' limit 1
loadtime:1.4629690647125 / seconds
Query Executed:select id FROM `al` where city='Opelika' && SIC_code='4841'DB:business_master_new
loadtime:1.4645640850067 / seconds
Query loaded from cache:select * from geodata_geocity where city='Opp' limit 1
loadtime:1.464607000351 / seconds
Query Executed:select id FROM `al` where city='Opp' && SIC_code='4841'DB:business_master_new
loadtime:1.4652011394501 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orange Beach' limit 1
loadtime:1.4652390480042 / seconds
Query Executed:select id FROM `al` where city='Orange Beach' && SIC_code='4841'DB:business_master_new
loadtime:1.4668321609497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orrville' limit 1
loadtime:1.4668831825256 / seconds
Query Executed:select id FROM `al` where city='Orrville' && SIC_code='4841'DB:business_master_new
loadtime:1.467315196991 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owens Cross Rds' limit 1
loadtime:1.4673521518707 / seconds
Query Executed:select id FROM `al` where city='Owens Cross Rds' && SIC_code='4841'DB:business_master_new
loadtime:1.4676480293274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Owens Cross Roads' limit 1
loadtime:1.4676849842072 / seconds
Query Executed:select id FROM `al` where city='Owens Cross Roads' && SIC_code='4841'DB:business_master_new
loadtime:1.4682490825653 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oxford' limit 1
loadtime:1.4682919979095 / seconds
Query Executed:select id FROM `al` where city='Oxford' && SIC_code='4841'DB:business_master_new
loadtime:1.4698860645294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ozark' limit 1
loadtime:1.4699521064758 / seconds
Query Executed:select id FROM `al` where city='Ozark' && SIC_code='4841'DB:business_master_new
loadtime:1.4715261459351 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paint Rock' limit 1
loadtime:1.4715650081635 / seconds
Query Executed:select id FROM `al` where city='Paint Rock' && SIC_code='4841'DB:business_master_new
loadtime:1.4775850772858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Palmerdale' limit 1
loadtime:1.47762799263 / seconds
Query Executed:select id FROM `al` where city='Palmerdale' && SIC_code='4841'DB:business_master_new
loadtime:1.4803822040558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panola' limit 1
loadtime:1.4804120063782 / seconds
Query Executed:select id FROM `al` where city='Panola' && SIC_code='4841'DB:business_master_new
loadtime:1.4852051734924 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pansey' limit 1
loadtime:1.4852480888367 / seconds
Query Executed:select id FROM `al` where city='Pansey' && SIC_code='4841'DB:business_master_new
loadtime:1.4902989864349 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parrish' limit 1
loadtime:1.4903299808502 / seconds
Query Executed:select id FROM `al` where city='Parrish' && SIC_code='4841'DB:business_master_new
loadtime:1.4907541275024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pelham' limit 1
loadtime:1.490797996521 / seconds
Query Executed:select id FROM `al` where city='Pelham' && SIC_code='4841'DB:business_master_new
loadtime:1.4924111366272 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pell City' limit 1
loadtime:1.4924499988556 / seconds
Query Executed:select id FROM `al` where city='Pell City' && SIC_code='4841'DB:business_master_new
loadtime:1.4941711425781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pennington' limit 1
loadtime:1.494225025177 / seconds
Query Executed:select id FROM `al` where city='Pennington' && SIC_code='4841'DB:business_master_new
loadtime:1.4946660995483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perdido' limit 1
loadtime:1.4947052001953 / seconds
Query Executed:select id FROM `al` where city='Perdido' && SIC_code='4841'DB:business_master_new
loadtime:1.5037121772766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Perdue Hill' limit 1
loadtime:1.5037870407104 / seconds
Query Executed:select id FROM `al` where city='Perdue Hill' && SIC_code='4841'DB:business_master_new
loadtime:1.5082910060883 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterman' limit 1
loadtime:1.5083260536194 / seconds
Query Executed:select id FROM `al` where city='Peterman' && SIC_code='4841'DB:business_master_new
loadtime:1.5193071365356 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peterson' limit 1
loadtime:1.5193591117859 / seconds
Query Executed:select id FROM `al` where city='Peterson' && SIC_code='4841'DB:business_master_new
loadtime:1.5241301059723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Petrey' limit 1
loadtime:1.5241720676422 / seconds
Query Executed:select id FROM `al` where city='Petrey' && SIC_code='4841'DB:business_master_new
loadtime:1.524943113327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phenix City' limit 1
loadtime:1.5249791145325 / seconds
Query Executed:select id FROM `al` where city='Phenix City' && SIC_code='4841'DB:business_master_new
loadtime:1.5265440940857 / seconds
Query loaded from cache:select * from geodata_geocity where city='Phil Campbell' limit 1
loadtime:1.5265920162201 / seconds
Query Executed:select id FROM `al` where city='Phil Campbell' && SIC_code='4841'DB:business_master_new
loadtime:1.5270969867706 / seconds
Query loaded from cache:select * from geodata_geocity where city='Piedmont' limit 1
loadtime:1.5271320343018 / seconds
Query Executed:select id FROM `al` where city='Piedmont' && SIC_code='4841'DB:business_master_new
loadtime:1.5277330875397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pike Road' limit 1
loadtime:1.5277950763702 / seconds
Query Executed:select id FROM `al` where city='Pike Road' && SIC_code='4841'DB:business_master_new
loadtime:1.5282711982727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinckard' limit 1
loadtime:1.5283169746399 / seconds
Query Executed:select id FROM `al` where city='Pinckard' && SIC_code='4841'DB:business_master_new
loadtime:1.5356061458588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Apple' limit 1
loadtime:1.5356411933899 / seconds
Query Executed:select id FROM `al` where city='Pine Apple' && SIC_code='4841'DB:business_master_new
loadtime:1.545755147934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Hill' limit 1
loadtime:1.5458030700684 / seconds
Query Executed:select id FROM `al` where city='Pine Hill' && SIC_code='4841'DB:business_master_new
loadtime:1.5462791919708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pinson' limit 1
loadtime:1.5463230609894 / seconds
Query Executed:select id FROM `al` where city='Pinson' && SIC_code='4841'DB:business_master_new
loadtime:1.5479230880737 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pisgah' limit 1
loadtime:1.5479581356049 / seconds
Query Executed:select id FROM `al` where city='Pisgah' && SIC_code='4841'DB:business_master_new
loadtime:1.548436164856 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pittsview' limit 1
loadtime:1.5484821796417 / seconds
Query Executed:select id FROM `al` where city='Pittsview' && SIC_code='4841'DB:business_master_new
loadtime:1.5488951206207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plantersville' limit 1
loadtime:1.5489220619202 / seconds
Query Executed:select id FROM `al` where city='Plantersville' && SIC_code='4841'DB:business_master_new
loadtime:1.5608191490173 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Grove' limit 1
loadtime:1.5608639717102 / seconds
Query Executed:select id FROM `al` where city='Pleasant Grove' && SIC_code='4841'DB:business_master_new
loadtime:1.5613551139832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Point Clear' limit 1
loadtime:1.5613951683044 / seconds
Query Executed:select id FROM `al` where city='Point Clear' && SIC_code='4841'DB:business_master_new
loadtime:1.5618140697479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Prattville' limit 1
loadtime:1.5618460178375 / seconds
Query Executed:select id FROM `al` where city='Prattville' && SIC_code='4841'DB:business_master_new
loadtime:1.5637500286102 / seconds
Query loaded from cache:select * from geodata_geocity where city='Princeton' limit 1
loadtime:1.5638110637665 / seconds
Query Executed:select id FROM `al` where city='Princeton' && SIC_code='4841'DB:business_master_new
loadtime:1.5657451152802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Quinton' limit 1
loadtime:1.5657951831818 / seconds
Query Executed:select id FROM `al` where city='Quinton' && SIC_code='4841'DB:business_master_new
loadtime:1.5662350654602 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ragland' limit 1
loadtime:1.5662801265717 / seconds
Query Executed:select id FROM `al` where city='Ragland' && SIC_code='4841'DB:business_master_new
loadtime:1.5667450428009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainbow City' limit 1
loadtime:1.5667791366577 / seconds
Query Executed:select id FROM `al` where city='Rainbow City' && SIC_code='4841'DB:business_master_new
loadtime:1.5683670043945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rainsville' limit 1
loadtime:1.5684161186218 / seconds
Query Executed:select id FROM `al` where city='Rainsville' && SIC_code='4841'DB:business_master_new
loadtime:1.5690240859985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ralph' limit 1
loadtime:1.5690591335297 / seconds
Query Executed:select id FROM `al` where city='Ralph' && SIC_code='4841'DB:business_master_new
loadtime:1.5757510662079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ramer' limit 1
loadtime:1.5758090019226 / seconds
Query Executed:select id FROM `al` where city='Ramer' && SIC_code='4841'DB:business_master_new
loadtime:1.5762641429901 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ranburne' limit 1
loadtime:1.5763111114502 / seconds
Query Executed:select id FROM `al` where city='Ranburne' && SIC_code='4841'DB:business_master_new
loadtime:1.5767590999603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:1.5767991542816 / seconds
Query Executed:select id FROM `al` where city='Randolph' && SIC_code='4841'DB:business_master_new
loadtime:1.5806641578674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Range' limit 1
loadtime:1.5807001590729 / seconds
Query Executed:select id FROM `al` where city='Range' && SIC_code='4841'DB:business_master_new
loadtime:1.5818819999695 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Bay' limit 1
loadtime:1.5819311141968 / seconds
Query Executed:select id FROM `al` where city='Red Bay' && SIC_code='4841'DB:business_master_new
loadtime:1.582435131073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Red Level' limit 1
loadtime:1.5824701786041 / seconds
Query Executed:select id FROM `al` where city='Red Level' && SIC_code='4841'DB:business_master_new
loadtime:1.5829031467438 / seconds
Query loaded from cache:select * from geodata_geocity where city='Reform' limit 1
loadtime:1.5829410552979 / seconds
Query Executed:select id FROM `al` where city='Reform' && SIC_code='4841'DB:business_master_new
loadtime:1.5834100246429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rehobeth' limit 1
loadtime:1.5834460258484 / seconds
Query Executed:select id FROM `al` where city='Rehobeth' && SIC_code='4841'DB:business_master_new
loadtime:1.5837261676788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Remlap' limit 1
loadtime:1.5837790966034 / seconds
Query Executed:select id FROM `al` where city='Remlap' && SIC_code='4841'DB:business_master_new
loadtime:1.5842840671539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Repton' limit 1
loadtime:1.5843150615692 / seconds
Query Executed:select id FROM `al` where city='Repton' && SIC_code='4841'DB:business_master_new
loadtime:1.5847451686859 / seconds
Query loaded from cache:select * from geodata_geocity where city='River Falls' limit 1
loadtime:1.5847890377045 / seconds
Query Executed:select id FROM `al` where city='River Falls' && SIC_code='4841'DB:business_master_new
loadtime:1.5888941287994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:1.58895611763 / seconds
Query Executed:select id FROM `al` where city='Riverside' && SIC_code='4841'DB:business_master_new
loadtime:1.5893800258636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roanoke' limit 1
loadtime:1.5894269943237 / seconds
Query Executed:select id FROM `al` where city='Roanoke' && SIC_code='4841'DB:business_master_new
loadtime:1.591010093689 / seconds
Query loaded from cache:select * from geodata_geocity where city='Robertsdale' limit 1
loadtime:1.5910542011261 / seconds
Query Executed:select id FROM `al` where city='Robertsdale' && SIC_code='4841'DB:business_master_new
loadtime:1.5926361083984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rock Mills' limit 1
loadtime:1.5926780700684 / seconds
Query Executed:select id FROM `al` where city='Rock Mills' && SIC_code='4841'DB:business_master_new
loadtime:1.5935401916504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockford' limit 1
loadtime:1.5935909748077 / seconds
Query Executed:select id FROM `al` where city='Rockford' && SIC_code='4841'DB:business_master_new
loadtime:1.5940420627594 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rogersville' limit 1
loadtime:1.5940940380096 / seconds
Query Executed:select id FROM `al` where city='Rogersville' && SIC_code='4841'DB:business_master_new
loadtime:1.5946481227875 / seconds
Query loaded from cache:select * from geodata_geocity where city='Russellville' limit 1
loadtime:1.5946960449219 / seconds
Query Executed:select id FROM `al` where city='Russellville' && SIC_code='4841'DB:business_master_new
loadtime:1.5962760448456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rutledge' limit 1
loadtime:1.5963242053986 / seconds
Query Executed:select id FROM `al` where city='Rutledge' && SIC_code='4841'DB:business_master_new
loadtime:1.6021640300751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ryland' limit 1
loadtime:1.6022050380707 / seconds
Query Executed:select id FROM `al` where city='Ryland' && SIC_code='4841'DB:business_master_new
loadtime:1.604905128479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Safford' limit 1
loadtime:1.6049461364746 / seconds
Query Executed:select id FROM `al` where city='Safford' && SIC_code='4841'DB:business_master_new
loadtime:1.6094601154327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saginaw' limit 1
loadtime:1.609500169754 / seconds
Query Executed:select id FROM `al` where city='Saginaw' && SIC_code='4841'DB:business_master_new
loadtime:1.6099021434784 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint Stephens' limit 1
loadtime:1.6099390983582 / seconds
Query Executed:select id FROM `al` where city='Saint Stephens' && SIC_code='4841'DB:business_master_new
loadtime:1.6118969917297 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.6119480133057 / seconds
Query Executed:select id FROM `al` where city='Salem' && SIC_code='4841'DB:business_master_new
loadtime:1.6124091148376 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salitpa' limit 1
loadtime:1.6124420166016 / seconds
Query Executed:select id FROM `al` where city='Salitpa' && SIC_code='4841'DB:business_master_new
loadtime:1.6127071380615 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samantha' limit 1
loadtime:1.6127450466156 / seconds
Query Executed:select id FROM `al` where city='Samantha' && SIC_code='4841'DB:business_master_new
loadtime:1.6138529777527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Samson' limit 1
loadtime:1.6139011383057 / seconds
Query Executed:select id FROM `al` where city='Samson' && SIC_code='4841'DB:business_master_new
loadtime:1.6143851280212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saraland' limit 1
loadtime:1.6144211292267 / seconds
Query Executed:select id FROM `al` where city='Saraland' && SIC_code='4841'DB:business_master_new
loadtime:1.6160271167755 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sardis' limit 1
loadtime:1.6160821914673 / seconds
Query Executed:select id FROM `al` where city='Sardis' && SIC_code='4841'DB:business_master_new
loadtime:1.6243422031403 / seconds
Query loaded from cache:select * from geodata_geocity where city='Satsuma' limit 1
loadtime:1.62437915802 / seconds
Query Executed:select id FROM `al` where city='Satsuma' && SIC_code='4841'DB:business_master_new
loadtime:1.6248860359192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sawyerville' limit 1
loadtime:1.6249330043793 / seconds
Query Executed:select id FROM `al` where city='Sawyerville' && SIC_code='4841'DB:business_master_new
loadtime:1.6317100524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sayre' limit 1
loadtime:1.6317961215973 / seconds
Query Executed:select id FROM `al` where city='Sayre' && SIC_code='4841'DB:business_master_new
loadtime:1.632287979126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scottsboro' limit 1
loadtime:1.6323261260986 / seconds
Query Executed:select id FROM `al` where city='Scottsboro' && SIC_code='4841'DB:business_master_new
loadtime:1.6341891288757 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seale' limit 1
loadtime:1.6342430114746 / seconds
Query Executed:select id FROM `al` where city='Seale' && SIC_code='4841'DB:business_master_new
loadtime:1.634800195694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Section' limit 1
loadtime:1.6348459720612 / seconds
Query Executed:select id FROM `al` where city='Section' && SIC_code='4841'DB:business_master_new
loadtime:1.6353371143341 / seconds
Query loaded from cache:select * from geodata_geocity where city='Selma' limit 1
loadtime:1.6353890895844 / seconds
Query Executed:select id FROM `al` where city='Selma' && SIC_code='4841'DB:business_master_new
loadtime:1.6369740962982 / seconds
Query loaded from cache:select * from geodata_geocity where city='Seminole' limit 1
loadtime:1.637011051178 / seconds
Query Executed:select id FROM `al` where city='Seminole' && SIC_code='4841'DB:business_master_new
loadtime:1.6374080181122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Semmes' limit 1
loadtime:1.6374690532684 / seconds
Query Executed:select id FROM `al` where city='Semmes' && SIC_code='4841'DB:business_master_new
loadtime:1.6390521526337 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shannon' limit 1
loadtime:1.6391000747681 / seconds
Query Executed:select id FROM `al` where city='Shannon' && SIC_code='4841'DB:business_master_new
loadtime:1.6414430141449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sheffield' limit 1
loadtime:1.641487121582 / seconds
Query Executed:select id FROM `al` where city='Sheffield' && SIC_code='4841'DB:business_master_new
loadtime:1.6430840492249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shelby' limit 1
loadtime:1.6431241035461 / seconds
Query Executed:select id FROM `al` where city='Shelby' && SIC_code='4841'DB:business_master_new
loadtime:1.6435530185699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shoal Creek' limit 1
loadtime:1.6435940265656 / seconds
Query Executed:select id FROM `al` where city='Shoal Creek' && SIC_code='4841'DB:business_master_new
loadtime:1.6439261436462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shorter' limit 1
loadtime:1.6439871788025 / seconds
Query Executed:select id FROM `al` where city='Shorter' && SIC_code='4841'DB:business_master_new
loadtime:1.6444330215454 / seconds
Query loaded from cache:select * from geodata_geocity where city='Shorterville' limit 1
loadtime:1.6444749832153 / seconds
Query Executed:select id FROM `al` where city='Shorterville' && SIC_code='4841'DB:business_master_new
loadtime:1.6545550823212 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silas' limit 1
loadtime:1.6546041965485 / seconds
Query Executed:select id FROM `al` where city='Silas' && SIC_code='4841'DB:business_master_new
loadtime:1.6550781726837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Siluria' limit 1
loadtime:1.6551129817963 / seconds
Query Executed:select id FROM `al` where city='Siluria' && SIC_code='4841'DB:business_master_new
loadtime:1.6558310985565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Silverhill' limit 1
loadtime:1.6558740139008 / seconds
Query Executed:select id FROM `al` where city='Silverhill' && SIC_code='4841'DB:business_master_new
loadtime:1.6563351154327 / seconds
Query loaded from cache:select * from geodata_geocity where city='Skipperville' limit 1
loadtime:1.656375169754 / seconds
Query Executed:select id FROM `al` where city='Skipperville' && SIC_code='4841'DB:business_master_new
loadtime:1.6608600616455 / seconds
Query loaded from cache:select * from geodata_geocity where city='Slocomb' limit 1
loadtime:1.660914182663 / seconds
Query Executed:select id FROM `al` where city='Slocomb' && SIC_code='4841'DB:business_master_new
loadtime:1.6614429950714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smiths Station' limit 1
loadtime:1.6614770889282 / seconds
Query Executed:select id FROM `al` where city='Smiths Station' && SIC_code='4841'DB:business_master_new
loadtime:1.6619939804077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snow Hill' limit 1
loadtime:1.6620211601257 / seconds
Query Executed:select id FROM `al` where city='Snow Hill' && SIC_code='4841'DB:business_master_new
loadtime:1.6628670692444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Somerville' limit 1
loadtime:1.6629161834717 / seconds
Query Executed:select id FROM `al` where city='Somerville' && SIC_code='4841'DB:business_master_new
loadtime:1.663407087326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanish Fort' limit 1
loadtime:1.6634349822998 / seconds
Query Executed:select id FROM `al` where city='Spanish Fort' && SIC_code='4841'DB:business_master_new
loadtime:1.6640341281891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:1.6640791893005 / seconds
Query Executed:select id FROM `al` where city='Springville' && SIC_code='4841'DB:business_master_new
loadtime:1.6646211147308 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sprott' limit 1
loadtime:1.6646511554718 / seconds
Query Executed:select id FROM `al` where city='Sprott' && SIC_code='4841'DB:business_master_new
loadtime:1.6658730506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spruce Pine' limit 1
loadtime:1.6659240722656 / seconds
Query Executed:select id FROM `al` where city='Spruce Pine' && SIC_code='4841'DB:business_master_new
loadtime:1.6663401126862 / seconds
Query loaded from cache:select * from geodata_geocity where city='St Elmo' limit 1
loadtime:1.6663751602173 / seconds
Query Executed:select id FROM `al` where city='St Elmo' && SIC_code='4841'DB:business_master_new
loadtime:1.6666491031647 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stanton' limit 1
loadtime:1.6666820049286 / seconds
Query Executed:select id FROM `al` where city='Stanton' && SIC_code='4841'DB:business_master_new
loadtime:1.6707801818848 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stapleton' limit 1
loadtime:1.6708130836487 / seconds
Query Executed:select id FROM `al` where city='Stapleton' && SIC_code='4841'DB:business_master_new
loadtime:1.6711981296539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Steele' limit 1
loadtime:1.6712381839752 / seconds
Query Executed:select id FROM `al` where city='Steele' && SIC_code='4841'DB:business_master_new
loadtime:1.6716501712799 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterrett' limit 1
loadtime:1.6716780662537 / seconds
Query Executed:select id FROM `al` where city='Sterrett' && SIC_code='4841'DB:business_master_new
loadtime:1.672149181366 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stevenson' limit 1
loadtime:1.6721920967102 / seconds
Query Executed:select id FROM `al` where city='Stevenson' && SIC_code='4841'DB:business_master_new
loadtime:1.6726841926575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:1.672737121582 / seconds
Query Executed:select id FROM `al` where city='Stockton' && SIC_code='4841'DB:business_master_new
loadtime:1.6731560230255 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sulligent' limit 1
loadtime:1.6732070446014 / seconds
Query Executed:select id FROM `al` where city='Sulligent' && SIC_code='4841'DB:business_master_new
loadtime:1.6736581325531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sumiton' limit 1
loadtime:1.6736960411072 / seconds
Query Executed:select id FROM `al` where city='Sumiton' && SIC_code='4841'DB:business_master_new
loadtime:1.6741721630096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summerdale' limit 1
loadtime:1.6742231845856 / seconds
Query Executed:select id FROM `al` where city='Summerdale' && SIC_code='4841'DB:business_master_new
loadtime:1.6747419834137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sweet Water' limit 1
loadtime:1.6747930049896 / seconds
Query Executed:select id FROM `al` where city='Sweet Water' && SIC_code='4841'DB:business_master_new
loadtime:1.6751961708069 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylacauga' limit 1
loadtime:1.675234079361 / seconds
Query Executed:select id FROM `al` where city='Sylacauga' && SIC_code='4841'DB:business_master_new
loadtime:1.6768391132355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvan Springs' limit 1
loadtime:1.6768891811371 / seconds
Query Executed:select id FROM `al` where city='Sylvan Springs' && SIC_code='4841'DB:business_master_new
loadtime:1.6771600246429 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sylvania' limit 1
loadtime:1.6771881580353 / seconds
Query Executed:select id FROM `al` where city='Sylvania' && SIC_code='4841'DB:business_master_new
loadtime:1.6775720119476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talladega' limit 1
loadtime:1.6776189804077 / seconds
Query Executed:select id FROM `al` where city='Talladega' && SIC_code='4841'DB:business_master_new
loadtime:1.6791930198669 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tallassee' limit 1
loadtime:1.6792511940002 / seconds
Query Executed:select id FROM `al` where city='Tallassee' && SIC_code='4841'DB:business_master_new
loadtime:1.6798770427704 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tanner' limit 1
loadtime:1.6799240112305 / seconds
Query Executed:select id FROM `al` where city='Tanner' && SIC_code='4841'DB:business_master_new
loadtime:1.6803550720215 / seconds
Query loaded from cache:select * from geodata_geocity where city='Taylor' limit 1
loadtime:1.6804029941559 / seconds
Query Executed:select id FROM `al` where city='Taylor' && SIC_code='4841'DB:business_master_new
loadtime:1.6806581020355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Theodore' limit 1
loadtime:1.6806890964508 / seconds
Query Executed:select id FROM `al` where city='Theodore' && SIC_code='4841'DB:business_master_new
loadtime:1.682245016098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomaston' limit 1
loadtime:1.6822891235352 / seconds
Query Executed:select id FROM `al` where city='Thomaston' && SIC_code='4841'DB:business_master_new
loadtime:1.6940801143646 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thomasville' limit 1
loadtime:1.6941471099854 / seconds
Query Executed:select id FROM `al` where city='Thomasville' && SIC_code='4841'DB:business_master_new
loadtime:1.694836139679 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thorsby' limit 1
loadtime:1.6948750019073 / seconds
Query Executed:select id FROM `al` where city='Thorsby' && SIC_code='4841'DB:business_master_new
loadtime:1.6953740119934 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tibbie' limit 1
loadtime:1.6954171657562 / seconds
Query Executed:select id FROM `al` where city='Tibbie' && SIC_code='4841'DB:business_master_new
loadtime:1.6990671157837 / seconds
Query loaded from cache:select * from geodata_geocity where city='Titus' limit 1
loadtime:1.6991159915924 / seconds
Query Executed:select id FROM `al` where city='Titus' && SIC_code='4841'DB:business_master_new
loadtime:1.6996290683746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toney' limit 1
loadtime:1.6996710300446 / seconds
Query Executed:select id FROM `al` where city='Toney' && SIC_code='4841'DB:business_master_new
loadtime:1.7001919746399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Town Creek' limit 1
loadtime:1.700236082077 / seconds
Query Executed:select id FROM `al` where city='Town Creek' && SIC_code='4841'DB:business_master_new
loadtime:1.7006890773773 / seconds
Query loaded from cache:select * from geodata_geocity where city='Townley' limit 1
loadtime:1.7007482051849 / seconds
Query Executed:select id FROM `al` where city='Townley' && SIC_code='4841'DB:business_master_new
loadtime:1.7075171470642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toxey' limit 1
loadtime:1.7075669765472 / seconds
Query Executed:select id FROM `al` where city='Toxey' && SIC_code='4841'DB:business_master_new
loadtime:1.7153351306915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trafford' limit 1
loadtime:1.7153861522675 / seconds
Query Executed:select id FROM `al` where city='Trafford' && SIC_code='4841'DB:business_master_new
loadtime:1.7158560752869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trinity' limit 1
loadtime:1.7159171104431 / seconds
Query Executed:select id FROM `al` where city='Trinity' && SIC_code='4841'DB:business_master_new
loadtime:1.7164301872253 / seconds
Query loaded from cache:select * from geodata_geocity where city='Troy' limit 1
loadtime:1.7164771556854 / seconds
Query Executed:select id FROM `al` where city='Troy' && SIC_code='4841'DB:business_master_new
loadtime:1.7180671691895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trussville' limit 1
loadtime:1.718132019043 / seconds
Query Executed:select id FROM `al` where city='Trussville' && SIC_code='4841'DB:business_master_new
loadtime:1.7198901176453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscaloosa' limit 1
loadtime:1.7199339866638 / seconds
Query Executed:select id FROM `al` where city='Tuscaloosa' && SIC_code='4841'DB:business_master_new
loadtime:1.7216742038727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuscumbia' limit 1
loadtime:1.721743106842 / seconds
Query Executed:select id FROM `al` where city='Tuscumbia' && SIC_code='4841'DB:business_master_new
loadtime:1.7233340740204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuskegee' limit 1
loadtime:1.723393201828 / seconds
Query Executed:select id FROM `al` where city='Tuskegee' && SIC_code='4841'DB:business_master_new
loadtime:1.7249710559845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuskegee Inst' limit 1
loadtime:1.725025177002 / seconds
Query Executed:select id FROM `al` where city='Tuskegee Inst' && SIC_code='4841'DB:business_master_new
loadtime:1.7253701686859 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tuskegee Institute' limit 1
loadtime:1.7254021167755 / seconds
Query Executed:select id FROM `al` where city='Tuskegee Institute' && SIC_code='4841'DB:business_master_new
loadtime:1.7259151935577 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tyler' limit 1
loadtime:1.7259550094604 / seconds
Query Executed:select id FROM `al` where city='Tyler' && SIC_code='4841'DB:business_master_new
loadtime:1.7263979911804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Grove' limit 1
loadtime:1.7264401912689 / seconds
Query Executed:select id FROM `al` where city='Union Grove' && SIC_code='4841'DB:business_master_new
loadtime:1.7269480228424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Union Springs' limit 1
loadtime:1.7269849777222 / seconds
Query Executed:select id FROM `al` where city='Union Springs' && SIC_code='4841'DB:business_master_new
loadtime:1.728569984436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uniontown' limit 1
loadtime:1.7286360263824 / seconds
Query Executed:select id FROM `al` where city='Uniontown' && SIC_code='4841'DB:business_master_new
loadtime:1.7291181087494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Uriah' limit 1
loadtime:1.729159116745 / seconds
Query Executed:select id FROM `al` where city='Uriah' && SIC_code='4841'DB:business_master_new
loadtime:1.7295770645142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valhermoso Spgs' limit 1
loadtime:1.7296121120453 / seconds
Query Executed:select id FROM `al` where city='Valhermoso Spgs' && SIC_code='4841'DB:business_master_new
loadtime:1.7299041748047 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valhermoso Springs' limit 1
loadtime:1.7299451828003 / seconds
Query Executed:select id FROM `al` where city='Valhermoso Springs' && SIC_code='4841'DB:business_master_new
loadtime:1.7363481521606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley' limit 1
loadtime:1.7363801002502 / seconds
Query Executed:select id FROM `al` where city='Valley' && SIC_code='4841'DB:business_master_new
loadtime:1.7381269931793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Grande' limit 1
loadtime:1.7381720542908 / seconds
Query Executed:select id FROM `al` where city='Valley Grande' && SIC_code='4841'DB:business_master_new
loadtime:1.7387320995331 / seconds
Query loaded from cache:select * from geodata_geocity where city='Valley Head' limit 1
loadtime:1.738762140274 / seconds
Query Executed:select id FROM `al` where city='Valley Head' && SIC_code='4841'DB:business_master_new
loadtime:1.7392010688782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vance' limit 1
loadtime:1.7392411231995 / seconds
Query Executed:select id FROM `al` where city='Vance' && SIC_code='4841'DB:business_master_new
loadtime:1.7396740913391 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vandiver' limit 1
loadtime:1.7397110462189 / seconds
Query Executed:select id FROM `al` where city='Vandiver' && SIC_code='4841'DB:business_master_new
loadtime:1.7401790618896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Verbena' limit 1
loadtime:1.7402231693268 / seconds
Query Executed:select id FROM `al` where city='Verbena' && SIC_code='4841'DB:business_master_new
loadtime:1.7406530380249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:1.7406980991364 / seconds
Query Executed:select id FROM `al` where city='Vernon' && SIC_code='4841'DB:business_master_new
loadtime:1.7424299716949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vestavia Hills' limit 1
loadtime:1.7424621582031 / seconds
Query Executed:select id FROM `al` where city='Vestavia Hills' && SIC_code='4841'DB:business_master_new
loadtime:1.74573802948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vina' limit 1
loadtime:1.745786190033 / seconds
Query Executed:select id FROM `al` where city='Vina' && SIC_code='4841'DB:business_master_new
loadtime:1.7462141513824 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vincent' limit 1
loadtime:1.7462561130524 / seconds
Query Executed:select id FROM `al` where city='Vincent' && SIC_code='4841'DB:business_master_new
loadtime:1.7466762065887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vinemont' limit 1
loadtime:1.7467291355133 / seconds
Query Executed:select id FROM `al` where city='Vinemont' && SIC_code='4841'DB:business_master_new
loadtime:1.7472281455994 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vredenburgh' limit 1
loadtime:1.7472569942474 / seconds
Query Executed:select id FROM `al` where city='Vredenburgh' && SIC_code='4841'DB:business_master_new
loadtime:1.7539370059967 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wadley' limit 1
loadtime:1.7539830207825 / seconds
Query Executed:select id FROM `al` where city='Wadley' && SIC_code='4841'DB:business_master_new
loadtime:1.7544651031494 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wagarville' limit 1
loadtime:1.7544980049133 / seconds
Query Executed:select id FROM `al` where city='Wagarville' && SIC_code='4841'DB:business_master_new
loadtime:1.7791891098022 / seconds
Query loaded from cache:select * from geodata_geocity where city='Walnut Grove' limit 1
loadtime:1.7792320251465 / seconds
Query Executed:select id FROM `al` where city='Walnut Grove' && SIC_code='4841'DB:business_master_new
loadtime:1.7796361446381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ward' limit 1
loadtime:1.7796940803528 / seconds
Query Executed:select id FROM `al` where city='Ward' && SIC_code='4841'DB:business_master_new
loadtime:1.782585144043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Warrior' limit 1
loadtime:1.7826399803162 / seconds
Query Executed:select id FROM `al` where city='Warrior' && SIC_code='4841'DB:business_master_new
loadtime:1.7842261791229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waterloo' limit 1
loadtime:1.7842581272125 / seconds
Query Executed:select id FROM `al` where city='Waterloo' && SIC_code='4841'DB:business_master_new
loadtime:1.7847280502319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wattsville' limit 1
loadtime:1.7847731113434 / seconds
Query Executed:select id FROM `al` where city='Wattsville' && SIC_code='4841'DB:business_master_new
loadtime:1.7870690822601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Waverly' limit 1
loadtime:1.7871141433716 / seconds
Query Executed:select id FROM `al` where city='Waverly' && SIC_code='4841'DB:business_master_new
loadtime:1.7875239849091 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weaver' limit 1
loadtime:1.7875549793243 / seconds
Query Executed:select id FROM `al` where city='Weaver' && SIC_code='4841'DB:business_master_new
loadtime:1.7879769802094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Webb' limit 1
loadtime:1.7880191802979 / seconds
Query Executed:select id FROM `al` where city='Webb' && SIC_code='4841'DB:business_master_new
loadtime:1.7885591983795 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wedowee' limit 1
loadtime:1.7885890007019 / seconds
Query Executed:select id FROM `al` where city='Wedowee' && SIC_code='4841'DB:business_master_new
loadtime:1.7891910076141 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:1.7892351150513 / seconds
Query Executed:select id FROM `al` where city='Wellington' && SIC_code='4841'DB:business_master_new
loadtime:1.7897942066193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Weogufka' limit 1
loadtime:1.7898252010345 / seconds
Query Executed:select id FROM `al` where city='Weogufka' && SIC_code='4841'DB:business_master_new
loadtime:1.7945501804352 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Blocton' limit 1
loadtime:1.7945921421051 / seconds
Query Executed:select id FROM `al` where city='West Blocton' && SIC_code='4841'DB:business_master_new
loadtime:1.7950630187988 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Greene' limit 1
loadtime:1.7951049804688 / seconds
Query Executed:select id FROM `al` where city='West Greene' && SIC_code='4841'DB:business_master_new
loadtime:1.7962679862976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Westover' limit 1
loadtime:1.7963001728058 / seconds
Query Executed:select id FROM `al` where city='Westover' && SIC_code='4841'DB:business_master_new
loadtime:1.7967410087585 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wetumpka' limit 1
loadtime:1.7967841625214 / seconds
Query Executed:select id FROM `al` where city='Wetumpka' && SIC_code='4841'DB:business_master_new
loadtime:1.7983560562134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whatley' limit 1
loadtime:1.7983961105347 / seconds
Query Executed:select id FROM `al` where city='Whatley' && SIC_code='4841'DB:business_master_new
loadtime:1.803188085556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilmer' limit 1
loadtime:1.8032310009003 / seconds
Query Executed:select id FROM `al` where city='Wilmer' && SIC_code='4841'DB:business_master_new
loadtime:1.8037011623383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilsonville' limit 1
loadtime:1.803747177124 / seconds
Query Executed:select id FROM `al` where city='Wilsonville' && SIC_code='4841'DB:business_master_new
loadtime:1.8042230606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wilton' limit 1
loadtime:1.8042759895325 / seconds
Query Executed:select id FROM `al` where city='Wilton' && SIC_code='4841'DB:business_master_new
loadtime:1.8075811862946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Winfield' limit 1
loadtime:1.8076260089874 / seconds
Query Executed:select id FROM `al` where city='Winfield' && SIC_code='4841'DB:business_master_new
loadtime:1.8093271255493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland' limit 1
loadtime:1.8093800544739 / seconds
Query Executed:select id FROM `al` where city='Woodland' && SIC_code='4841'DB:business_master_new
loadtime:1.8098180294037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodstock' limit 1
loadtime:1.8098800182343 / seconds
Query Executed:select id FROM `al` where city='Woodstock' && SIC_code='4841'DB:business_master_new
loadtime:1.8103342056274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodville' limit 1
loadtime:1.8103730678558 / seconds
Query Executed:select id FROM `al` where city='Woodville' && SIC_code='4841'DB:business_master_new
loadtime:1.8108010292053 / seconds
Query loaded from cache:select * from geodata_geocity where city='York' limit 1
loadtime:1.8108329772949 / seconds
Query Executed:select id FROM `al` where city='York' && SIC_code='4841'DB:business_master_new
loadtime:1.8113260269165 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.8114111423492 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.8116221427917 / seconds
Operation template executed (chunk cache operation)
loadtime:1.8117020130157 / seconds
template override:Default
loadtime:1.8117361068726 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:1.8124890327454 / seconds
Template Constructed, Array Rows:49
loadtime:1.812735080719 / seconds
TOTAL EXECUTION TIME: 1.81253
loadtime:1.8128290176392 / seconds

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


PAGE OBJECT DATA


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



_GET


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


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:1.812833070755
TOTAL KEY ARRAYS: 69