Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:7.0095062255859E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0007011890411377 / seconds
host not found setting manual db connection
loadtime:0.0014820098876953 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017571449279785 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0019640922546387 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0020442008972168 / seconds
zipcode:
loadtime:0.0020720958709717 / seconds
Query Executed:select * from search_referrer where page_hash='a47d98a0e360bd3b1cbe81fa77149818' limit 10 DB:ezrox_toadli
loadtime:0.0023410320281982 / seconds
Operation header executed (non global)
loadtime:0.002357006072998 / seconds
Operation leaderboard executed (non global)
loadtime:0.0024001598358154 / seconds
Operation square executed (non global)
loadtime:0.0024161338806152 / seconds
Operation square_bottom executed (non global)
loadtime:0.0024290084838867 / seconds
Operation smallsquare executed (non global)
loadtime:0.0024411678314209 / seconds
Operation headeradright executed (non global)
loadtime:0.0024521350860596 / seconds
Operation google_analytics executed (non global)
loadtime:0.0024631023406982 / seconds
Operation topstories executed (non global)
loadtime:0.0024740695953369 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0024850368499756 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0024950504302979 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0027790069580078 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0030300617218018 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0030980110168457 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.0032000541687012 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0032730102539062 / seconds
Template key: archive_menu pushed
loadtime:0.0032830238342285 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0032939910888672 / seconds
Template key: get_gravatar pushed
loadtime:0.0033001899719238 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0033071041107178 / seconds
*10)-10)+1 | start:0
loadtime:0.0033431053161621 / seconds
Query loaded from cache:select * from categories where cat_URLid='national-commercial-banks'
loadtime:0.0034229755401611 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.0034430027008057 / seconds
DB connected to localhost business_master_new
loadtime:0.003709077835083 / seconds
Query Executed:select * from `ut_catmap` where sic='6021' order by city ascDB:business_master_new
loadtime:0.026663064956665 / seconds
Query stored in cache : _QUERY_www.toadli.comf2ecd469df3b6a01ed02b3fa80ea38c5
loadtime:0.027114152908325 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.027147054672241 / seconds
Query Executed:select sum(totalcount) as totalsum from `ut_catmap` where sic='6021'DB:business_master_new
loadtime:0.028760194778442 / seconds
Query stored in cache : _QUERY_www.toadli.com53bef39d4e851f40ac66dd7a3bf67b42
loadtime:0.028804063796997 / seconds
279 / 11
loadtime:0.028840065002441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.028882026672363 / seconds
Query Executed:select id FROM `ut` where city='Alpine' && SIC_code='6021'DB:business_master_new
loadtime:0.031522989273071 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.031583070755005 / seconds
Query Executed:select id FROM `ut` where city='Alta' && SIC_code='6021'DB:business_master_new
loadtime:0.031963109970093 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.031998157501221 / seconds
Query Executed:select id FROM `ut` where city='Altamont' && SIC_code='6021'DB:business_master_new
loadtime:0.033604145050049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.033660173416138 / seconds
Query Executed:select id FROM `ut` where city='Alton' && SIC_code='6021'DB:business_master_new
loadtime:0.034073114395142 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altonah' limit 1
loadtime:0.034170150756836 / seconds
Query Executed:select id FROM `ut` where city='Altonah' && SIC_code='6021'DB:business_master_new
loadtime:0.034584045410156 / seconds
Query loaded from cache:select * from geodata_geocity where city='American Fork' limit 1
loadtime:0.034625053405762 / seconds
Query Executed:select id FROM `ut` where city='American Fork' && SIC_code='6021'DB:business_master_new
loadtime:0.037804126739502 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aneth' limit 1
loadtime:0.037856101989746 / seconds
Query Executed:select id FROM `ut` where city='Aneth' && SIC_code='6021'DB:business_master_new
loadtime:0.038177013397217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annabella' limit 1
loadtime:0.03823709487915 / seconds
Query Executed:select id FROM `ut` where city='Annabella' && SIC_code='6021'DB:business_master_new
loadtime:0.038699150085449 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antimony' limit 1
loadtime:0.038748979568481 / seconds
Query Executed:select id FROM `ut` where city='Antimony' && SIC_code='6021'DB:business_master_new
loadtime:0.039168119430542 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.039204120635986 / seconds
Query Executed:select id FROM `ut` where city='Aurora' && SIC_code='6021'DB:business_master_new
loadtime:0.039736986160278 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axtell' limit 1
loadtime:0.03978705406189 / seconds
Query Executed:select id FROM `ut` where city='Axtell' && SIC_code='6021'DB:business_master_new
loadtime:0.040131092071533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear River City' limit 1
loadtime:0.040167093276978 / seconds
Query Executed:select id FROM `ut` where city='Bear River City' && SIC_code='6021'DB:business_master_new
loadtime:0.051352024078369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.051417112350464 / seconds
Query Executed:select id FROM `ut` where city='Beaver' && SIC_code='6021'DB:business_master_new
loadtime:0.052503108978271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beryl' limit 1
loadtime:0.052558183670044 / seconds
Query Executed:select id FROM `ut` where city='Beryl' && SIC_code='6021'DB:business_master_new
loadtime:0.061773061752319 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bicknell' limit 1
loadtime:0.061820983886719 / seconds
Query Executed:select id FROM `ut` where city='Bicknell' && SIC_code='6021'DB:business_master_new
loadtime:0.062393188476562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Water' limit 1
loadtime:0.062430143356323 / seconds
Query Executed:select id FROM `ut` where city='Big Water' && SIC_code='6021'DB:business_master_new
loadtime:0.0627601146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Canyon' limit 1
loadtime:0.062808990478516 / seconds
Query Executed:select id FROM `ut` where city='Bingham Canyon' && SIC_code='6021'DB:business_master_new
loadtime:0.068171977996826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanding' limit 1
loadtime:0.068224191665649 / seconds
Query Executed:select id FROM `ut` where city='Blanding' && SIC_code='6021'DB:business_master_new
loadtime:0.069478034973145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluebell' limit 1
loadtime:0.069523096084595 / seconds
Query Executed:select id FROM `ut` where city='Bluebell' && SIC_code='6021'DB:business_master_new
loadtime:0.069953203201294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluff' limit 1
loadtime:0.070003032684326 / seconds
Query Executed:select id FROM `ut` where city='Bluff' && SIC_code='6021'DB:business_master_new
loadtime:0.070516109466553 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonanza' limit 1
loadtime:0.070544004440308 / seconds
Query Executed:select id FROM `ut` where city='Bonanza' && SIC_code='6021'DB:business_master_new
loadtime:0.070846080780029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.07089900970459 / seconds
Query Executed:select id FROM `ut` where city='Boulder' && SIC_code='6021'DB:business_master_new
loadtime:0.080980062484741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bountiful' limit 1
loadtime:0.081015110015869 / seconds
Query Executed:select id FROM `ut` where city='Bountiful' && SIC_code='6021'DB:business_master_new
loadtime:0.25635409355164 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brian Head' limit 1
loadtime:0.25649809837341 / seconds
Query Executed:select id FROM `ut` where city='Brian Head' && SIC_code='6021'DB:business_master_new
loadtime:0.25718998908997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeland' limit 1
loadtime:0.25722408294678 / seconds
Query Executed:select id FROM `ut` where city='Bridgeland' && SIC_code='6021'DB:business_master_new
loadtime:0.25758814811707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigham City' limit 1
loadtime:0.25762820243835 / seconds
Query Executed:select id FROM `ut` where city='Brigham City' && SIC_code='6021'DB:business_master_new
loadtime:0.25859117507935 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.25864100456238 / seconds
Query Executed:select id FROM `ut` where city='Brighton' && SIC_code='6021'DB:business_master_new
loadtime:0.25895309448242 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce' limit 1
loadtime:0.25898909568787 / seconds
Query Executed:select id FROM `ut` where city='Bryce' && SIC_code='6021'DB:business_master_new
loadtime:0.25938701629639 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce Canyon' limit 1
loadtime:0.25942707061768 / seconds
Query Executed:select id FROM `ut` where city='Bryce Canyon' && SIC_code='6021'DB:business_master_new
loadtime:0.25979709625244 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cache Junction' limit 1
loadtime:0.25983214378357 / seconds
Query Executed:select id FROM `ut` where city='Cache Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.26010918617249 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonville' limit 1
loadtime:0.26014518737793 / seconds
Query Executed:select id FROM `ut` where city='Cannonville' && SIC_code='6021'DB:business_master_new
loadtime:0.26051712036133 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Dale' limit 1
loadtime:0.26054215431213 / seconds
Query Executed:select id FROM `ut` where city='Castle Dale' && SIC_code='6021'DB:business_master_new
loadtime:0.26113319396973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar City' limit 1
loadtime:0.26119017601013 / seconds
Query Executed:select id FROM `ut` where city='Cedar City' && SIC_code='6021'DB:business_master_new
loadtime:0.26611018180847 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Valley' limit 1
loadtime:0.26617002487183 / seconds
Query Executed:select id FROM `ut` where city='Cedar Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.27205419540405 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerfield' limit 1
loadtime:0.2721061706543 / seconds
Query Executed:select id FROM `ut` where city='Centerfield' && SIC_code='6021'DB:business_master_new
loadtime:0.27265000343323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.27269220352173 / seconds
Query Executed:select id FROM `ut` where city='Centerville' && SIC_code='6021'DB:business_master_new
loadtime:0.27353000640869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.27356815338135 / seconds
Query Executed:select id FROM `ut` where city='Central' && SIC_code='6021'DB:business_master_new
loadtime:0.27388906478882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Valley' limit 1
loadtime:0.27392816543579 / seconds
Query Executed:select id FROM `ut` where city='Central Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.27422714233398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.27425909042358 / seconds
Query Executed:select id FROM `ut` where city='Chester' && SIC_code='6021'DB:business_master_new
loadtime:0.27460217475891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.27463912963867 / seconds
Query Executed:select id FROM `ut` where city='Circleville' && SIC_code='6021'DB:business_master_new
loadtime:0.27513599395752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cisco' limit 1
loadtime:0.27518820762634 / seconds
Query Executed:select id FROM `ut` where city='Cisco' && SIC_code='6021'DB:business_master_new
loadtime:0.27547812461853 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.27551698684692 / seconds
Query Executed:select id FROM `ut` where city='Clarkston' && SIC_code='6021'DB:business_master_new
loadtime:0.27594017982483 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.27597212791443 / seconds
Query Executed:select id FROM `ut` where city='Clawson' && SIC_code='6021'DB:business_master_new
loadtime:0.27625203132629 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.27627611160278 / seconds
Query Executed:select id FROM `ut` where city='Clearfield' && SIC_code='6021'DB:business_master_new
loadtime:0.27736115455627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.2774350643158 / seconds
Query Executed:select id FROM `ut` where city='Cleveland' && SIC_code='6021'DB:business_master_new
loadtime:0.28646302223206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalville' limit 1
loadtime:0.28650498390198 / seconds
Query Executed:select id FROM `ut` where city='Coalville' && SIC_code='6021'DB:business_master_new
loadtime:0.28711104393005 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinston' limit 1
loadtime:0.28716111183167 / seconds
Query Executed:select id FROM `ut` where city='Collinston' && SIC_code='6021'DB:business_master_new
loadtime:0.28757214546204 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinne' limit 1
loadtime:0.28760409355164 / seconds
Query Executed:select id FROM `ut` where city='Corinne' && SIC_code='6021'DB:business_master_new
loadtime:0.28810501098633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.28814220428467 / seconds
Query Executed:select id FROM `ut` where city='Cornish' && SIC_code='6021'DB:business_master_new
loadtime:0.28843903541565 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.28846502304077 / seconds
Query Executed:select id FROM `ut` where city='Cottonwood' && SIC_code='6021'DB:business_master_new
loadtime:0.28870320320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.28873920440674 / seconds
Query Executed:select id FROM `ut` where city='Croydon' && SIC_code='6021'DB:business_master_new
loadtime:0.28901600837708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dammeron Valley' limit 1
loadtime:0.28904914855957 / seconds
Query Executed:select id FROM `ut` where city='Dammeron Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.29508304595947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.29511404037476 / seconds
Query Executed:select id FROM `ut` where city='Delta' && SIC_code='6021'DB:business_master_new
loadtime:0.29580616950989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deweyville' limit 1
loadtime:0.2958550453186 / seconds
Query Executed:select id FROM `ut` where city='Deweyville' && SIC_code='6021'DB:business_master_new
loadtime:0.29622006416321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.29624605178833 / seconds
Query Executed:select id FROM `ut` where city='Draper' && SIC_code='6021'DB:business_master_new
loadtime:0.30083417892456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duchesne' limit 1
loadtime:0.30089497566223 / seconds
Query Executed:select id FROM `ut` where city='Duchesne' && SIC_code='6021'DB:business_master_new
loadtime:0.30151605606079 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village' limit 1
loadtime:0.30155301094055 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village' && SIC_code='6021'DB:business_master_new
loadtime:0.30205607414246 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village Cpu' limit 1
loadtime:0.30210614204407 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village Cpu' && SIC_code='6021'DB:business_master_new
loadtime:0.30238318443298 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Vlg' limit 1
loadtime:0.30241107940674 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Vlg' && SIC_code='6021'DB:business_master_new
loadtime:0.30272006988525 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugway' limit 1
loadtime:0.30277109146118 / seconds
Query Executed:select id FROM `ut` where city='Dugway' && SIC_code='6021'DB:business_master_new
loadtime:0.30329203605652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutch John' limit 1
loadtime:0.30333709716797 / seconds
Query Executed:select id FROM `ut` where city='Dutch John' && SIC_code='6021'DB:business_master_new
loadtime:0.30383801460266 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Mountain' limit 1
loadtime:0.30387306213379 / seconds
Query Executed:select id FROM `ut` where city='Eagle Mountain' && SIC_code='6021'DB:business_master_new
loadtime:0.30439710617065 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Carbon' limit 1
loadtime:0.30443906784058 / seconds
Query Executed:select id FROM `ut` where city='East Carbon' && SIC_code='6021'DB:business_master_new
loadtime:0.30492210388184 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echo' limit 1
loadtime:0.3049681186676 / seconds
Query Executed:select id FROM `ut` where city='Echo' && SIC_code='6021'DB:business_master_new
loadtime:0.30522918701172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.30525612831116 / seconds
Query Executed:select id FROM `ut` where city='Eden' && SIC_code='6021'DB:business_master_new
loadtime:0.30585598945618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.30591607093811 / seconds
Query Executed:select id FROM `ut` where city='Elberta' && SIC_code='6021'DB:business_master_new
loadtime:0.31200504302979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmo' limit 1
loadtime:0.31204199790955 / seconds
Query Executed:select id FROM `ut` where city='Elmo' && SIC_code='6021'DB:business_master_new
loadtime:0.31741404533386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsinore' limit 1
loadtime:0.31746506690979 / seconds
Query Executed:select id FROM `ut` where city='Elsinore' && SIC_code='6021'DB:business_master_new
loadtime:0.31801605224609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.31806302070618 / seconds
Query Executed:select id FROM `ut` where city='Emery' && SIC_code='6021'DB:business_master_new
loadtime:0.32381820678711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.32385420799255 / seconds
Query Executed:select id FROM `ut` where city='Enterprise' && SIC_code='6021'DB:business_master_new
loadtime:0.32438802719116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:0.3244411945343 / seconds
Query Executed:select id FROM `ut` where city='Ephraim' && SIC_code='6021'DB:business_master_new
loadtime:0.32502198219299 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escalante' limit 1
loadtime:0.32505702972412 / seconds
Query Executed:select id FROM `ut` where city='Escalante' && SIC_code='6021'DB:business_master_new
loadtime:0.32557702064514 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.32562208175659 / seconds
Query Executed:select id FROM `ut` where city='Eureka' && SIC_code='6021'DB:business_master_new
loadtime:0.3261091709137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.3261342048645 / seconds
Query Executed:select id FROM `ut` where city='Fairview' && SIC_code='6021'DB:business_master_new
loadtime:0.32665419578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.32669806480408 / seconds
Query Executed:select id FROM `ut` where city='Farmington' && SIC_code='6021'DB:business_master_new
loadtime:0.32741117477417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.32745718955994 / seconds
Query Executed:select id FROM `ut` where city='Fayette' && SIC_code='6021'DB:business_master_new
loadtime:0.32779812812805 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferron' limit 1
loadtime:0.32782411575317 / seconds
Query Executed:select id FROM `ut` where city='Ferron' && SIC_code='6021'DB:business_master_new
loadtime:0.32831406593323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fielding' limit 1
loadtime:0.32834720611572 / seconds
Query Executed:select id FROM `ut` where city='Fielding' && SIC_code='6021'DB:business_master_new
loadtime:0.33339619636536 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fillmore' limit 1
loadtime:0.33343601226807 / seconds
Query Executed:select id FROM `ut` where city='Fillmore' && SIC_code='6021'DB:business_master_new
loadtime:0.33401417732239 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Duchesne' limit 1
loadtime:0.33405208587646 / seconds
Query Executed:select id FROM `ut` where city='Fort Duchesne' && SIC_code='6021'DB:business_master_new
loadtime:0.33456110954285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Green' limit 1
loadtime:0.33460307121277 / seconds
Query Executed:select id FROM `ut` where city='Fountain Green' && SIC_code='6021'DB:business_master_new
loadtime:0.33505821228027 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.33508205413818 / seconds
Query Executed:select id FROM `ut` where city='Fruitland' && SIC_code='6021'DB:business_master_new
loadtime:0.34004211425781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.34008312225342 / seconds
Query Executed:select id FROM `ut` where city='Garden City' && SIC_code='6021'DB:business_master_new
loadtime:0.34060907363892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.34064507484436 / seconds
Query Executed:select id FROM `ut` where city='Garland' && SIC_code='6021'DB:business_master_new
loadtime:0.34116506576538 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.34119701385498 / seconds
Query Executed:select id FROM `ut` where city='Garrison' && SIC_code='6021'DB:business_master_new
loadtime:0.34159016609192 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genola' limit 1
loadtime:0.34161520004272 / seconds
Query Executed:select id FROM `ut` where city='Genola' && SIC_code='6021'DB:business_master_new
loadtime:0.3418710231781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.34190607070923 / seconds
Query Executed:select id FROM `ut` where city='Glendale' && SIC_code='6021'DB:business_master_new
loadtime:0.3463830947876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.34641909599304 / seconds
Query Executed:select id FROM `ut` where city='Glenwood' && SIC_code='6021'DB:business_master_new
loadtime:0.34677600860596 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.34680104255676 / seconds
Query Executed:select id FROM `ut` where city='Goshen' && SIC_code='6021'DB:business_master_new
loadtime:0.34727716445923 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsville' limit 1
loadtime:0.34730911254883 / seconds
Query Executed:select id FROM `ut` where city='Grantsville' && SIC_code='6021'DB:business_master_new
loadtime:0.3478581905365 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green River' limit 1
loadtime:0.34789419174194 / seconds
Query Executed:select id FROM `ut` where city='Green River' && SIC_code='6021'DB:business_master_new
loadtime:0.34841799736023 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.34845399856567 / seconds
Query Executed:select id FROM `ut` where city='Greenville' && SIC_code='6021'DB:business_master_new
loadtime:0.34868717193604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.34872508049011 / seconds
Query Executed:select id FROM `ut` where city='Greenwich' && SIC_code='6021'DB:business_master_new
loadtime:0.34895801544189 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grouse Creek' limit 1
loadtime:0.3489830493927 / seconds
Query Executed:select id FROM `ut` where city='Grouse Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.34922504425049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunlock' limit 1
loadtime:0.34925699234009 / seconds
Query Executed:select id FROM `ut` where city='Gunlock' && SIC_code='6021'DB:business_master_new
loadtime:0.34951210021973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.34953618049622 / seconds
Query Executed:select id FROM `ut` where city='Gunnison' && SIC_code='6021'DB:business_master_new
loadtime:0.35003614425659 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gusher' limit 1
loadtime:0.35007619857788 / seconds
Query Executed:select id FROM `ut` where city='Gusher' && SIC_code='6021'DB:business_master_new
loadtime:0.35034513473511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanksville' limit 1
loadtime:0.35038208961487 / seconds
Query Executed:select id FROM `ut` where city='Hanksville' && SIC_code='6021'DB:business_master_new
loadtime:0.35085606575012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanna' limit 1
loadtime:0.35089111328125 / seconds
Query Executed:select id FROM `ut` where city='Hanna' && SIC_code='6021'DB:business_master_new
loadtime:0.35120320320129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.35123705863953 / seconds
Query Executed:select id FROM `ut` where city='Hatch' && SIC_code='6021'DB:business_master_new
loadtime:0.3567841053009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber City' limit 1
loadtime:0.35681509971619 / seconds
Query Executed:select id FROM `ut` where city='Heber City' && SIC_code='6021'DB:business_master_new
loadtime:0.35757398605347 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helper' limit 1
loadtime:0.35761904716492 / seconds
Query Executed:select id FROM `ut` where city='Helper' && SIC_code='6021'DB:business_master_new
loadtime:0.35817909240723 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henefer' limit 1
loadtime:0.35821914672852 / seconds
Query Executed:select id FROM `ut` where city='Henefer' && SIC_code='6021'DB:business_master_new
loadtime:0.3639919757843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrieville' limit 1
loadtime:0.36402606964111 / seconds
Query Executed:select id FROM `ut` where city='Henrieville' && SIC_code='6021'DB:business_master_new
loadtime:0.36433219909668 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herriman' limit 1
loadtime:0.36435604095459 / seconds
Query Executed:select id FROM `ut` where city='Herriman' && SIC_code='6021'DB:business_master_new
loadtime:0.36491417884827 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.36495113372803 / seconds
Query Executed:select id FROM `ut` where city='Hiawatha' && SIC_code='6021'DB:business_master_new
loadtime:0.36521005630493 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:0.36523413658142 / seconds
Query Executed:select id FROM `ut` where city='Highland' && SIC_code='6021'DB:business_master_new
loadtime:0.36555504798889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildale' limit 1
loadtime:0.36558699607849 / seconds
Query Executed:select id FROM `ut` where city='Hildale' && SIC_code='6021'DB:business_master_new
loadtime:0.3660900592804 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Afb' limit 1
loadtime:0.36612200737 / seconds
Query Executed:select id FROM `ut` where city='Hill Afb' && SIC_code='6021'DB:business_master_new
loadtime:0.36664700508118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Air Force Base' limit 1
loadtime:0.36667704582214 / seconds
Query Executed:select id FROM `ut` where city='Hill Air Force Base' && SIC_code='6021'DB:business_master_new
loadtime:0.36695718765259 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinckley' limit 1
loadtime:0.36699414253235 / seconds
Query Executed:select id FROM `ut` where city='Hinckley' && SIC_code='6021'DB:business_master_new
loadtime:0.3738100528717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hite' limit 1
loadtime:0.37384605407715 / seconds
Query Executed:select id FROM `ut` where city='Hite' && SIC_code='6021'DB:business_master_new
loadtime:0.37410807609558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.37413620948792 / seconds
Query Executed:select id FROM `ut` where city='Holden' && SIC_code='6021'DB:business_master_new
loadtime:0.3793351650238 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holladay' limit 1
loadtime:0.37938213348389 / seconds
Query Executed:select id FROM `ut` where city='Holladay' && SIC_code='6021'DB:business_master_new
loadtime:0.37986397743225 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honeyville' limit 1
loadtime:0.37988710403442 / seconds
Query Executed:select id FROM `ut` where city='Honeyville' && SIC_code='6021'DB:business_master_new
loadtime:0.38035607337952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.38040208816528 / seconds
Query Executed:select id FROM `ut` where city='Hooper' && SIC_code='6021'DB:business_master_new
loadtime:0.38091707229614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:0.38095021247864 / seconds
Query Executed:select id FROM `ut` where city='Howell' && SIC_code='6021'DB:business_master_new
loadtime:0.38127613067627 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.38130021095276 / seconds
Query Executed:select id FROM `ut` where city='Huntington' && SIC_code='6021'DB:business_master_new
loadtime:0.38184905052185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntsville' limit 1
loadtime:0.38189005851746 / seconds
Query Executed:select id FROM `ut` where city='Huntsville' && SIC_code='6021'DB:business_master_new
loadtime:0.38238620758057 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurricane' limit 1
loadtime:0.38241100311279 / seconds
Query Executed:select id FROM `ut` where city='Hurricane' && SIC_code='6021'DB:business_master_new
loadtime:0.38305711746216 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.38309907913208 / seconds
Query Executed:select id FROM `ut` where city='Hyde Park' && SIC_code='6021'DB:business_master_new
loadtime:0.38363909721375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyrum' limit 1
loadtime:0.38366413116455 / seconds
Query Executed:select id FROM `ut` where city='Hyrum' && SIC_code='6021'DB:business_master_new
loadtime:0.38422513008118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ibapah' limit 1
loadtime:0.38426613807678 / seconds
Query Executed:select id FROM `ut` where city='Ibapah' && SIC_code='6021'DB:business_master_new
loadtime:0.38464903831482 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivins' limit 1
loadtime:0.38467812538147 / seconds
Query Executed:select id FROM `ut` where city='Ivins' && SIC_code='6021'DB:business_master_new
loadtime:0.38518500328064 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jensen' limit 1
loadtime:0.38521909713745 / seconds
Query Executed:select id FROM `ut` where city='Jensen' && SIC_code='6021'DB:business_master_new
loadtime:0.38569712638855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph' limit 1
loadtime:0.38573002815247 / seconds
Query Executed:select id FROM `ut` where city='Joseph' && SIC_code='6021'DB:business_master_new
loadtime:0.3861072063446 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction' limit 1
loadtime:0.38613104820251 / seconds
Query Executed:select id FROM `ut` where city='Junction' && SIC_code='6021'DB:business_master_new
loadtime:0.39238405227661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamas' limit 1
loadtime:0.39241909980774 / seconds
Query Executed:select id FROM `ut` where city='Kamas' && SIC_code='6021'DB:business_master_new
loadtime:0.39300608634949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanab' limit 1
loadtime:0.39303708076477 / seconds
Query Executed:select id FROM `ut` where city='Kanab' && SIC_code='6021'DB:business_master_new
loadtime:0.3936882019043 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanarraville' limit 1
loadtime:0.39373016357422 / seconds
Query Executed:select id FROM `ut` where city='Kanarraville' && SIC_code='6021'DB:business_master_new
loadtime:0.39412999153137 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanosh' limit 1
loadtime:0.39415502548218 / seconds
Query Executed:select id FROM `ut` where city='Kanosh' && SIC_code='6021'DB:business_master_new
loadtime:0.39910817146301 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaysville' limit 1
loadtime:0.39914417266846 / seconds
Query Executed:select id FROM `ut` where city='Kaysville' && SIC_code='6021'DB:business_master_new
loadtime:0.400062084198 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearns' limit 1
loadtime:0.40009307861328 / seconds
Query Executed:select id FROM `ut` where city='Kearns' && SIC_code='6021'DB:business_master_new
loadtime:0.40070915222168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:0.40075016021729 / seconds
Query Executed:select id FROM `ut` where city='Kenilworth' && SIC_code='6021'DB:business_master_new
loadtime:0.40099310874939 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.40102410316467 / seconds
Query Executed:select id FROM `ut` where city='Kingston' && SIC_code='6021'DB:business_master_new
loadtime:0.40131020545959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koosharem' limit 1
loadtime:0.4013340473175 / seconds
Query Executed:select id FROM `ut` where city='Koosharem' && SIC_code='6021'DB:business_master_new
loadtime:0.4059100151062 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Sal' limit 1
loadtime:0.40594410896301 / seconds
Query Executed:select id FROM `ut` where city='La Sal' && SIC_code='6021'DB:business_master_new
loadtime:0.4109251499176 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Verkin' limit 1
loadtime:0.41095018386841 / seconds
Query Executed:select id FROM `ut` where city='La Verkin' && SIC_code='6021'DB:business_master_new
loadtime:0.41164708137512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Powell' limit 1
loadtime:0.41168212890625 / seconds
Query Executed:select id FROM `ut` where city='Lake Powell' && SIC_code='6021'DB:business_master_new
loadtime:0.41865921020508 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laketown' limit 1
loadtime:0.41868305206299 / seconds
Query Executed:select id FROM `ut` where city='Laketown' && SIC_code='6021'DB:business_master_new
loadtime:0.41919016838074 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapoint' limit 1
loadtime:0.41922497749329 / seconds
Query Executed:select id FROM `ut` where city='Lapoint' && SIC_code='6021'DB:business_master_new
loadtime:0.42550015449524 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:0.42553210258484 / seconds
Query Executed:select id FROM `ut` where city='Layton' && SIC_code='6021'DB:business_master_new
loadtime:0.43026518821716 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leamington' limit 1
loadtime:0.43031716346741 / seconds
Query Executed:select id FROM `ut` where city='Leamington' && SIC_code='6021'DB:business_master_new
loadtime:0.43065905570984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:0.43069505691528 / seconds
Query Executed:select id FROM `ut` where city='Leeds' && SIC_code='6021'DB:business_master_new
loadtime:0.43116307258606 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehi' limit 1
loadtime:0.43118715286255 / seconds
Query Executed:select id FROM `ut` where city='Lehi' && SIC_code='6021'DB:business_master_new
loadtime:0.43203711509705 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levan' limit 1
loadtime:0.43207907676697 / seconds
Query Executed:select id FROM `ut` where city='Levan' && SIC_code='6021'DB:business_master_new
loadtime:0.43251419067383 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:0.43254804611206 / seconds
Query Executed:select id FROM `ut` where city='Lewiston' && SIC_code='6021'DB:business_master_new
loadtime:0.43304920196533 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.43308210372925 / seconds
Query Executed:select id FROM `ut` where city='Lindon' && SIC_code='6021'DB:business_master_new
loadtime:0.43380999565125 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loa' limit 1
loadtime:0.43385100364685 / seconds
Query Executed:select id FROM `ut` where city='Loa' && SIC_code='6021'DB:business_master_new
loadtime:0.43431711196899 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.43434500694275 / seconds
Query Executed:select id FROM `ut` where city='Logan' && SIC_code='6021'DB:business_master_new
loadtime:0.43884921073914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.43889904022217 / seconds
Query Executed:select id FROM `ut` where city='Lyman' && SIC_code='6021'DB:business_master_new
loadtime:0.43922400474548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynndyl' limit 1
loadtime:0.43925499916077 / seconds
Query Executed:select id FROM `ut` where city='Lynndyl' && SIC_code='6021'DB:business_master_new
loadtime:0.43958616256714 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magna' limit 1
loadtime:0.43962121009827 / seconds
Query Executed:select id FROM `ut` where city='Magna' && SIC_code='6021'DB:business_master_new
loadtime:0.4403030872345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manila' limit 1
loadtime:0.4403440952301 / seconds
Query Executed:select id FROM `ut` where city='Manila' && SIC_code='6021'DB:business_master_new
loadtime:0.4408221244812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manti' limit 1
loadtime:0.44084620475769 / seconds
Query Executed:select id FROM `ut` where city='Manti' && SIC_code='6021'DB:business_master_new
loadtime:0.44139719009399 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:0.44143915176392 / seconds
Query Executed:select id FROM `ut` where city='Mantua' && SIC_code='6021'DB:business_master_new
loadtime:0.44575500488281 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.44579005241394 / seconds
Query Executed:select id FROM `ut` where city='Mapleton' && SIC_code='6021'DB:business_master_new
loadtime:0.4464271068573 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysvale' limit 1
loadtime:0.44645619392395 / seconds
Query Executed:select id FROM `ut` where city='Marysvale' && SIC_code='6021'DB:business_master_new
loadtime:0.44693613052368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:0.44698405265808 / seconds
Query Executed:select id FROM `ut` where city='Mayfield' && SIC_code='6021'DB:business_master_new
loadtime:0.4473831653595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.44741010665894 / seconds
Query Executed:select id FROM `ut` where city='Meadow' && SIC_code='6021'DB:business_master_new
loadtime:0.44777917861938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:0.44781804084778 / seconds
Query Executed:select id FROM `ut` where city='Mendon' && SIC_code='6021'DB:business_master_new
loadtime:0.44829916954041 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Hat' limit 1
loadtime:0.44833207130432 / seconds
Query Executed:select id FROM `ut` where city='Mexican Hat' && SIC_code='6021'DB:business_master_new
loadtime:0.44874215126038 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midvale' limit 1
loadtime:0.4487771987915 / seconds
Query Executed:select id FROM `ut` where city='Midvale' && SIC_code='6021'DB:business_master_new
loadtime:0.45329713821411 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:0.45336008071899 / seconds
Query Executed:select id FROM `ut` where city='Midway' && SIC_code='6021'DB:business_master_new
loadtime:0.45391798019409 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.45395517349243 / seconds
Query Executed:select id FROM `ut` where city='Milford' && SIC_code='6021'DB:business_master_new
loadtime:0.45450901985168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:0.45455598831177 / seconds
Query Executed:select id FROM `ut` where city='Millville' && SIC_code='6021'DB:business_master_new
loadtime:0.45505905151367 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minersville' limit 1
loadtime:0.45510506629944 / seconds
Query Executed:select id FROM `ut` where city='Minersville' && SIC_code='6021'DB:business_master_new
loadtime:0.46246099472046 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moab' limit 1
loadtime:0.46249413490295 / seconds
Query Executed:select id FROM `ut` where city='Moab' && SIC_code='6021'DB:business_master_new
loadtime:0.46335911750793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:0.46342515945435 / seconds
Query Executed:select id FROM `ut` where city='Modena' && SIC_code='6021'DB:business_master_new
loadtime:0.46371412277222 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mona' limit 1
loadtime:0.46374106407166 / seconds
Query Executed:select id FROM `ut` where city='Mona' && SIC_code='6021'DB:business_master_new
loadtime:0.46422219276428 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.46425700187683 / seconds
Query Executed:select id FROM `ut` where city='Monroe' && SIC_code='6021'DB:business_master_new
loadtime:0.46480703353882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma Creek' limit 1
loadtime:0.46485018730164 / seconds
Query Executed:select id FROM `ut` where city='Montezuma Creek' && SIC_code='6021'DB:business_master_new
loadtime:0.47235298156738 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.47241401672363 / seconds
Query Executed:select id FROM `ut` where city='Monticello' && SIC_code='6021'DB:business_master_new
loadtime:0.47346520423889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Valley' limit 1
loadtime:0.47354507446289 / seconds
Query Executed:select id FROM `ut` where city='Monument Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.47980403900146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.4798572063446 / seconds
Query Executed:select id FROM `ut` where city='Morgan' && SIC_code='6021'DB:business_master_new
loadtime:0.48053312301636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moroni' limit 1
loadtime:0.48057818412781 / seconds
Query Executed:select id FROM `ut` where city='Moroni' && SIC_code='6021'DB:business_master_new
loadtime:0.48109316825867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.48112916946411 / seconds
Query Executed:select id FROM `ut` where city='Mount Carmel' && SIC_code='6021'DB:business_master_new
loadtime:0.48152899742126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.48157000541687 / seconds
Query Executed:select id FROM `ut` where city='Mount Pleasant' && SIC_code='6021'DB:business_master_new
loadtime:0.48221302032471 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:0.4822461605072 / seconds
Query Executed:select id FROM `ut` where city='Mountain Home' && SIC_code='6021'DB:business_master_new
loadtime:0.48263216018677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.48267006874084 / seconds
Query Executed:select id FROM `ut` where city='Mt Carmel' && SIC_code='6021'DB:business_master_new
loadtime:0.48290419578552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.48293399810791 / seconds
Query Executed:select id FROM `ut` where city='Mt Pleasant' && SIC_code='6021'DB:business_master_new
loadtime:0.48334503173828 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.48338603973389 / seconds
Query Executed:select id FROM `ut` where city='Murray' && SIC_code='6021'DB:business_master_new
loadtime:0.48391199111938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myton' limit 1
loadtime:0.48394799232483 / seconds
Query Executed:select id FROM `ut` where city='Myton' && SIC_code='6021'DB:business_master_new
loadtime:0.48442006111145 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.48444509506226 / seconds
Query Executed:select id FROM `ut` where city='Neola' && SIC_code='6021'DB:business_master_new
loadtime:0.49198508262634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nephi' limit 1
loadtime:0.49203515052795 / seconds
Query Executed:select id FROM `ut` where city='Nephi' && SIC_code='6021'DB:business_master_new
loadtime:0.49273920059204 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Harmony' limit 1
loadtime:0.49278903007507 / seconds
Query Executed:select id FROM `ut` where city='New Harmony' && SIC_code='6021'DB:business_master_new
loadtime:0.49685311317444 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:0.49690198898315 / seconds
Query Executed:select id FROM `ut` where city='Newcastle' && SIC_code='6021'DB:business_master_new
loadtime:0.49730515480042 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.49733400344849 / seconds
Query Executed:select id FROM `ut` where city='Newton' && SIC_code='6021'DB:business_master_new
loadtime:0.50277018547058 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salt Lake' limit 1
loadtime:0.50281000137329 / seconds
Query Executed:select id FROM `ut` where city='North Salt Lake' && SIC_code='6021'DB:business_master_new
loadtime:0.50363516807556 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:0.50368309020996 / seconds
Query Executed:select id FROM `ut` where city='Oak City' && SIC_code='6021'DB:business_master_new
loadtime:0.50410008430481 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:0.50412607192993 / seconds
Query Executed:select id FROM `ut` where city='Oakley' && SIC_code='6021'DB:business_master_new
loadtime:0.50465106964111 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oasis' limit 1
loadtime:0.50468802452087 / seconds
Query Executed:select id FROM `ut` where city='Oasis' && SIC_code='6021'DB:business_master_new
loadtime:0.50492310523987 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.50494813919067 / seconds
Query Executed:select id FROM `ut` where city='Ogden' && SIC_code='6021'DB:business_master_new
loadtime:0.50951910018921 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeville' limit 1
loadtime:0.50958013534546 / seconds
Query Executed:select id FROM `ut` where city='Orangeville' && SIC_code='6021'DB:business_master_new
loadtime:0.51685619354248 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orderville' limit 1
loadtime:0.51688313484192 / seconds
Query Executed:select id FROM `ut` where city='Orderville' && SIC_code='6021'DB:business_master_new
loadtime:0.52295804023743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orem' limit 1
loadtime:0.52300119400024 / seconds
Query Executed:select id FROM `ut` where city='Orem' && SIC_code='6021'DB:business_master_new
loadtime:0.5275239944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panguitch' limit 1
loadtime:0.5275661945343 / seconds
Query Executed:select id FROM `ut` where city='Panguitch' && SIC_code='6021'DB:business_master_new
loadtime:0.52815198898315 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:0.52819418907166 / seconds
Query Executed:select id FROM `ut` where city='Paradise' && SIC_code='6021'DB:business_master_new
loadtime:0.5286819934845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paragonah' limit 1
loadtime:0.52871704101562 / seconds
Query Executed:select id FROM `ut` where city='Paragonah' && SIC_code='6021'DB:business_master_new
loadtime:0.52909207344055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park City' limit 1
loadtime:0.52911710739136 / seconds
Query Executed:select id FROM `ut` where city='Park City' && SIC_code='6021'DB:business_master_new
loadtime:0.53361105918884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Valley' limit 1
loadtime:0.53366017341614 / seconds
Query Executed:select id FROM `ut` where city='Park Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.53395414352417 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parowan' limit 1
loadtime:0.53397917747498 / seconds
Query Executed:select id FROM `ut` where city='Parowan' && SIC_code='6021'DB:business_master_new
loadtime:0.53457307815552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.53461599349976 / seconds
Query Executed:select id FROM `ut` where city='Payson' && SIC_code='6021'DB:business_master_new
loadtime:0.53542399406433 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoa' limit 1
loadtime:0.53546500205994 / seconds
Query Executed:select id FROM `ut` where city='Peoa' && SIC_code='6021'DB:business_master_new
loadtime:0.54114508628845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Valley' limit 1
loadtime:0.5411810874939 / seconds
Query Executed:select id FROM `ut` where city='Pine Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.54147911071777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Grove' limit 1
loadtime:0.54150414466858 / seconds
Query Executed:select id FROM `ut` where city='Pleasant Grove' && SIC_code='6021'DB:business_master_new
loadtime:0.54244899749756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.54249501228333 / seconds
Query Executed:select id FROM `ut` where city='Plymouth' && SIC_code='6021'DB:business_master_new
loadtime:0.54294013977051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:0.54297208786011 / seconds
Query Executed:select id FROM `ut` where city='Portage' && SIC_code='6021'DB:business_master_new
loadtime:0.54326105117798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Price' limit 1
loadtime:0.54329204559326 / seconds
Query Executed:select id FROM `ut` where city='Price' && SIC_code='6021'DB:business_master_new
loadtime:0.54414701461792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:0.54418420791626 / seconds
Query Executed:select id FROM `ut` where city='Providence' && SIC_code='6021'DB:business_master_new
loadtime:0.54477000236511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provo' limit 1
loadtime:0.54481220245361 / seconds
Query Executed:select id FROM `ut` where city='Provo' && SIC_code='6021'DB:business_master_new
loadtime:0.54931116104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randlett' limit 1
loadtime:0.54935312271118 / seconds
Query Executed:select id FROM `ut` where city='Randlett' && SIC_code='6021'DB:business_master_new
loadtime:0.54978609085083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.54982304573059 / seconds
Query Executed:select id FROM `ut` where city='Randolph' && SIC_code='6021'DB:business_master_new
loadtime:0.55032420158386 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:0.55036115646362 / seconds
Query Executed:select id FROM `ut` where city='Redmond' && SIC_code='6021'DB:business_master_new
loadtime:0.55778503417969 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:0.55782413482666 / seconds
Query Executed:select id FROM `ut` where city='Richfield' && SIC_code='6021'DB:business_master_new
loadtime:0.55870819091797 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.55874013900757 / seconds
Query Executed:select id FROM `ut` where city='Richmond' && SIC_code='6021'DB:business_master_new
loadtime:0.55930113792419 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.559326171875 / seconds
Query Executed:select id FROM `ut` where city='Riverside' && SIC_code='6021'DB:business_master_new
loadtime:0.5597231388092 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.55975818634033 / seconds
Query Executed:select id FROM `ut` where city='Riverton' && SIC_code='6021'DB:business_master_new
loadtime:0.56072521209717 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.56076717376709 / seconds
Query Executed:select id FROM `ut` where city='Rockville' && SIC_code='6021'DB:business_master_new
loadtime:0.56113314628601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.56116700172424 / seconds
Query Executed:select id FROM `ut` where city='Roosevelt' && SIC_code='6021'DB:business_master_new
loadtime:0.56193709373474 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.56198120117188 / seconds
Query Executed:select id FROM `ut` where city='Roy' && SIC_code='6021'DB:business_master_new
loadtime:0.56273317337036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush Valley' limit 1
loadtime:0.56276416778564 / seconds
Query Executed:select id FROM `ut` where city='Rush Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.56312417984009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.56316113471985 / seconds
Query Executed:select id FROM `ut` where city='Saint George' && SIC_code='6021'DB:business_master_new
loadtime:0.56767916679382 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.56773114204407 / seconds
Query Executed:select id FROM `ut` where city='Salem' && SIC_code='6021'DB:business_master_new
loadtime:0.56829905509949 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salina' limit 1
loadtime:0.56832909584045 / seconds
Query Executed:select id FROM `ut` where city='Salina' && SIC_code='6021'DB:business_master_new
loadtime:0.56890106201172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salt Lake City' limit 1
loadtime:0.56894111633301 / seconds
Query Executed:select id FROM `ut` where city='Salt Lake City' && SIC_code='6021'DB:business_master_new
loadtime:0.57359910011292 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy' limit 1
loadtime:0.57372307777405 / seconds
Query Executed:select id FROM `ut` where city='Sandy' && SIC_code='6021'DB:business_master_new
loadtime:0.57822799682617 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.57828712463379 / seconds
Query Executed:select id FROM `ut` where city='Santa Clara' && SIC_code='6021'DB:business_master_new
loadtime:0.57890009880066 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santaquin' limit 1
loadtime:0.57893204689026 / seconds
Query Executed:select id FROM `ut` where city='Santaquin' && SIC_code='6021'DB:business_master_new
loadtime:0.57952809333801 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga Springs' limit 1
loadtime:0.57956910133362 / seconds
Query Executed:select id FROM `ut` where city='Saratoga Springs' && SIC_code='6021'DB:business_master_new
loadtime:0.58011102676392 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scipio' limit 1
loadtime:0.58013916015625 / seconds
Query Executed:select id FROM `ut` where city='Scipio' && SIC_code='6021'DB:business_master_new
loadtime:0.58051419258118 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sevier' limit 1
loadtime:0.58055114746094 / seconds
Query Executed:select id FROM `ut` where city='Sevier' && SIC_code='6021'DB:business_master_new
loadtime:0.5808470249176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigurd' limit 1
loadtime:0.58087801933289 / seconds
Query Executed:select id FROM `ut` where city='Sigurd' && SIC_code='6021'DB:business_master_new
loadtime:0.58130717277527 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:0.58133101463318 / seconds
Query Executed:select id FROM `ut` where city='Smithfield' && SIC_code='6021'DB:business_master_new
loadtime:0.58199620246887 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowbird' limit 1
loadtime:0.58203721046448 / seconds
Query Executed:select id FROM `ut` where city='Snowbird' && SIC_code='6021'DB:business_master_new
loadtime:0.5824019908905 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowville' limit 1
loadtime:0.58242607116699 / seconds
Query Executed:select id FROM `ut` where city='Snowville' && SIC_code='6021'DB:business_master_new
loadtime:0.58706116676331 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Jordan' limit 1
loadtime:0.58709597587585 / seconds
Query Executed:select id FROM `ut` where city='South Jordan' && SIC_code='6021'DB:business_master_new
loadtime:0.58835005760193 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Salt Lake' limit 1
loadtime:0.58839416503906 / seconds
Query Executed:select id FROM `ut` where city='South Salt Lake' && SIC_code='6021'DB:business_master_new
loadtime:0.58879017829895 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanish Fork' limit 1
loadtime:0.58882403373718 / seconds
Query Executed:select id FROM `ut` where city='Spanish Fork' && SIC_code='6021'DB:business_master_new
loadtime:0.58977198600769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring City' limit 1
loadtime:0.58981609344482 / seconds
Query Executed:select id FROM `ut` where city='Spring City' && SIC_code='6021'DB:business_master_new
loadtime:0.59727811813354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springdale' limit 1
loadtime:0.59730505943298 / seconds
Query Executed:select id FROM `ut` where city='Springdale' && SIC_code='6021'DB:business_master_new
loadtime:0.59783720970154 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:0.59787797927856 / seconds
Query Executed:select id FROM `ut` where city='Springville' && SIC_code='6021'DB:business_master_new
loadtime:0.59879899024963 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.59882998466492 / seconds
Query Executed:select id FROM `ut` where city='St George' && SIC_code='6021'DB:business_master_new
loadtime:0.59935903549194 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.59941005706787 / seconds
Query Executed:select id FROM `ut` where city='Sterling' && SIC_code='6021'DB:business_master_new
loadtime:0.59979200363159 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:0.59982514381409 / seconds
Query Executed:select id FROM `ut` where city='Stockton' && SIC_code='6021'DB:business_master_new
loadtime:0.60529398918152 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.60531902313232 / seconds
Query Executed:select id FROM `ut` where city='Summit' && SIC_code='6021'DB:business_master_new
loadtime:0.60568118095398 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunnyside' limit 1
loadtime:0.60571599006653 / seconds
Query Executed:select id FROM `ut` where city='Sunnyside' && SIC_code='6021'DB:business_master_new
loadtime:0.60605406761169 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syracuse' limit 1
loadtime:0.60607814788818 / seconds
Query Executed:select id FROM `ut` where city='Syracuse' && SIC_code='6021'DB:business_master_new
loadtime:0.60677313804626 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabiona' limit 1
loadtime:0.6068160533905 / seconds
Query Executed:select id FROM `ut` where city='Tabiona' && SIC_code='6021'DB:business_master_new
loadtime:0.60720920562744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talmage' limit 1
loadtime:0.60724210739136 / seconds
Query Executed:select id FROM `ut` where city='Talmage' && SIC_code='6021'DB:business_master_new
loadtime:0.60760903358459 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teasdale' limit 1
loadtime:0.6076340675354 / seconds
Query Executed:select id FROM `ut` where city='Teasdale' && SIC_code='6021'DB:business_master_new
loadtime:0.60798406600952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terra' limit 1
loadtime:0.60802006721497 / seconds
Query Executed:select id FROM `ut` where city='Terra' && SIC_code='6021'DB:business_master_new
loadtime:0.60827302932739 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.60829710960388 / seconds
Query Executed:select id FROM `ut` where city='Thompson' && SIC_code='6021'DB:business_master_new
loadtime:0.60859417915344 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tooele' limit 1
loadtime:0.60862898826599 / seconds
Query Executed:select id FROM `ut` where city='Tooele' && SIC_code='6021'DB:business_master_new
loadtime:0.60960006713867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toquerville' limit 1
loadtime:0.60963797569275 / seconds
Query Executed:select id FROM `ut` where city='Toquerville' && SIC_code='6021'DB:business_master_new
loadtime:0.61626005172729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrey' limit 1
loadtime:0.61629605293274 / seconds
Query Executed:select id FROM `ut` where city='Torrey' && SIC_code='6021'DB:business_master_new
loadtime:0.61678409576416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremonton' limit 1
loadtime:0.61680817604065 / seconds
Query Executed:select id FROM `ut` where city='Tremonton' && SIC_code='6021'DB:business_master_new
loadtime:0.61751699447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.61755800247192 / seconds
Query Executed:select id FROM `ut` where city='Trenton' && SIC_code='6021'DB:business_master_new
loadtime:0.61794114112854 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tridell' limit 1
loadtime:0.61797213554382 / seconds
Query Executed:select id FROM `ut` where city='Tridell' && SIC_code='6021'DB:business_master_new
loadtime:0.6182701587677 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tropic' limit 1
loadtime:0.61829400062561 / seconds
Query Executed:select id FROM `ut` where city='Tropic' && SIC_code='6021'DB:business_master_new
loadtime:0.61877703666687 / seconds
Query loaded from cache:select * from geodata_geocity where city='Venice' limit 1
loadtime:0.61881613731384 / seconds
Query Executed:select id FROM `ut` where city='Venice' && SIC_code='6021'DB:business_master_new
loadtime:0.61910009384155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernal' limit 1
loadtime:0.61912798881531 / seconds
Query Executed:select id FROM `ut` where city='Vernal' && SIC_code='6021'DB:business_master_new
loadtime:0.62016010284424 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.62020516395569 / seconds
Query Executed:select id FROM `ut` where city='Vernon' && SIC_code='6021'DB:business_master_new
loadtime:0.62054419517517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veyo' limit 1
loadtime:0.62056803703308 / seconds
Query Executed:select id FROM `ut` where city='Veyo' && SIC_code='6021'DB:business_master_new
loadtime:0.62606716156006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgin' limit 1
loadtime:0.62610220909119 / seconds
Query Executed:select id FROM `ut` where city='Virgin' && SIC_code='6021'DB:business_master_new
loadtime:0.62652516365051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:0.62655401229858 / seconds
Query Executed:select id FROM `ut` where city='Wales' && SIC_code='6021'DB:business_master_new
loadtime:0.62690806388855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallsburg' limit 1
loadtime:0.62694001197815 / seconds
Query Executed:select id FROM `ut` where city='Wallsburg' && SIC_code='6021'DB:business_master_new
loadtime:0.63298201560974 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.63301515579224 / seconds
Query Executed:select id FROM `ut` where city='Washington' && SIC_code='6021'DB:business_master_new
loadtime:0.63369607925415 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:0.63373208045959 / seconds
Query Executed:select id FROM `ut` where city='Wellington' && SIC_code='6021'DB:business_master_new
loadtime:0.63424205780029 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsville' limit 1
loadtime:0.63427400588989 / seconds
Query Executed:select id FROM `ut` where city='Wellsville' && SIC_code='6021'DB:business_master_new
loadtime:0.63483214378357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendover' limit 1
loadtime:0.63486218452454 / seconds
Query Executed:select id FROM `ut` where city='Wendover' && SIC_code='6021'DB:business_master_new
loadtime:0.63538813591003 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.63542699813843 / seconds
Query Executed:select id FROM `ut` where city='West Haven' && SIC_code='6021'DB:business_master_new
loadtime:0.63568115234375 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jordan' limit 1
loadtime:0.63570618629456 / seconds
Query Executed:select id FROM `ut` where city='West Jordan' && SIC_code='6021'DB:business_master_new
loadtime:0.64023900032043 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Valley' limit 1
loadtime:0.64029216766357 / seconds
Query Executed:select id FROM `ut` where city='West Valley' && SIC_code='6021'DB:business_master_new
loadtime:0.64078998565674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiterocks' limit 1
loadtime:0.64082503318787 / seconds
Query Executed:select id FROM `ut` where city='Whiterocks' && SIC_code='6021'DB:business_master_new
loadtime:0.64117097854614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.64119911193848 / seconds
Query Executed:select id FROM `ut` where city='Willard' && SIC_code='6021'DB:business_master_new
loadtime:0.64171814918518 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Hills' limit 1
loadtime:0.64175319671631 / seconds
Query Executed:select id FROM `ut` where city='Woodland Hills' && SIC_code='6021'DB:business_master_new
loadtime:0.64198112487793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.64200401306152 / seconds
Query Executed:select id FROM `ut` where city='Woodruff' && SIC_code='6021'DB:business_master_new
loadtime:0.64246416091919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross' limit 1
loadtime:0.64249706268311 / seconds
Query Executed:select id FROM `ut` where city='Woods Cross' && SIC_code='6021'DB:business_master_new
loadtime:0.6469521522522 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.64703702926636 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.6472110748291 / seconds
Operation template executed (chunk cache operation)
loadtime:0.64729118347168 / seconds
template override:Default
loadtime:0.64731121063232 / seconds
Query Executed: select *,template_page.header as header, template_page.content as content, template_page.footer as footer from template LEFT JOIN template_page on template_page.template_id=template.id where template.name='Default' && template_page.name='categorycity.php' group by template.id DB:ezrox_toadli
loadtime:0.64808416366577 / seconds
Template Constructed, Array Rows:49
loadtime:0.64830708503723 / seconds
TOTAL EXECUTION TIME: 0.64812
loadtime:0.64840698242188 / 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] => national-commercial-banks [stateURLid] => utah )


_COOKIES


Array ( )


PAGES IN CACHE





CLASS OBJECT


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


MEMCACHED STATS




TOTAL EXECTUTION TIME:0.64841198921204
TOTAL KEY ARRAYS: 69