Select the City for your Business Review



DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:8.7976455688477E-5 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00189208984375 / seconds
host not found setting manual db connection
loadtime:0.0098040103912354 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.010063171386719 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.01029896736145 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.01036810874939 / seconds
zipcode:
loadtime:0.010396003723145 / seconds
Query Executed:select * from search_referrer where page_hash='7f4498d6285a94bc2b798eee12d506f5' limit 10 DB:ezrox_toadli
loadtime:0.010691165924072 / seconds
Operation header executed (non global)
loadtime:0.010724067687988 / seconds
Operation leaderboard executed (non global)
loadtime:0.010776996612549 / seconds
Operation square executed (non global)
loadtime:0.010807037353516 / seconds
Operation square_bottom executed (non global)
loadtime:0.010833978652954 / seconds
Operation smallsquare executed (non global)
loadtime:0.010861158370972 / seconds
Operation headeradright executed (non global)
loadtime:0.010885953903198 / seconds
Operation google_analytics executed (non global)
loadtime:0.010910987854004 / seconds
Operation topstories executed (non global)
loadtime:0.01093602180481 / seconds
Operation businessnearyou executed (non global)
loadtime:0.010962963104248 / seconds
Operation memberbuscount executed (non global)
loadtime:0.010987997055054 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.011260032653809 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.011455059051514 / seconds
Operation categories executed (global stored into APC)
loadtime:0.011505126953125 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.011590957641602 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.011645078659058 / seconds
Template key: archive_menu pushed
loadtime:0.011654138565063 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.011667966842651 / seconds
Template key: get_gravatar pushed
loadtime:0.011675119400024 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.011687994003296 / seconds
*10)-10)+1 | start:0
loadtime:0.011736154556274 / seconds
Query loaded from cache:select * from categories where cat_URLid='beauty-shops'
loadtime:0.01178503036499 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.011821985244751 / seconds
DB connected to localhost business_master_new
loadtime:0.012153148651123 / seconds
Query Executed:select * from `ut_catmap` where sic='7231' order by city ascDB:business_master_new
loadtime:0.023269176483154 / seconds
Query stored in cache : _QUERY_www.toadli.com1fd13b5ca63c6af35befd3a0767e39f9
loadtime:0.024490118026733 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.024563074111938 / seconds
Query Executed:select sum(totalcount) as totalsum from `ut_catmap` where sic='7231'DB:business_master_new
loadtime:0.026204109191895 / seconds
Query stored in cache : _QUERY_www.toadli.comfa39ab139c3bdd004aa3dc481d969946
loadtime:0.026244163513184 / seconds
279 / 11
loadtime:0.02631402015686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.026385068893433 / seconds
Query Executed:select id FROM `ut` where city='Alpine' && SIC_code='7231'DB:business_master_new
loadtime:0.031795024871826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.031891107559204 / seconds
Query Executed:select id FROM `ut` where city='Alta' && SIC_code='7231'DB:business_master_new
loadtime:0.032448053359985 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.032516002655029 / seconds
Query Executed:select id FROM `ut` where city='Altamont' && SIC_code='7231'DB:business_master_new
loadtime:0.03354811668396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.033627986907959 / seconds
Query Executed:select id FROM `ut` where city='Alton' && SIC_code='7231'DB:business_master_new
loadtime:0.034212112426758 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altonah' limit 1
loadtime:0.034280061721802 / seconds
Query Executed:select id FROM `ut` where city='Altonah' && SIC_code='7231'DB:business_master_new
loadtime:0.034871101379395 / seconds
Query loaded from cache:select * from geodata_geocity where city='American Fork' limit 1
loadtime:0.034937143325806 / seconds
Query Executed:select id FROM `ut` where city='American Fork' && SIC_code='7231'DB:business_master_new
loadtime:0.053266048431396 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aneth' limit 1
loadtime:0.05339503288269 / seconds
Query Executed:select id FROM `ut` where city='Aneth' && SIC_code='7231'DB:business_master_new
loadtime:0.053915023803711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Annabella' limit 1
loadtime:0.053980112075806 / seconds
Query Executed:select id FROM `ut` where city='Annabella' && SIC_code='7231'DB:business_master_new
loadtime:0.054592132568359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Antimony' limit 1
loadtime:0.05466103553772 / seconds
Query Executed:select id FROM `ut` where city='Antimony' && SIC_code='7231'DB:business_master_new
loadtime:0.05522608757019 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.05528712272644 / seconds
Query Executed:select id FROM `ut` where city='Aurora' && SIC_code='7231'DB:business_master_new
loadtime:0.056144952774048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axtell' limit 1
loadtime:0.056220054626465 / seconds
Query Executed:select id FROM `ut` where city='Axtell' && SIC_code='7231'DB:business_master_new
loadtime:0.056720018386841 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bear River City' limit 1
loadtime:0.056796073913574 / seconds
Query Executed:select id FROM `ut` where city='Bear River City' && SIC_code='7231'DB:business_master_new
loadtime:0.057522058486938 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.057585000991821 / seconds
Query Executed:select id FROM `ut` where city='Beaver' && SIC_code='7231'DB:business_master_new
loadtime:0.061942100524902 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beryl' limit 1
loadtime:0.062030076980591 / seconds
Query Executed:select id FROM `ut` where city='Beryl' && SIC_code='7231'DB:business_master_new
loadtime:0.062809944152832 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bicknell' limit 1
loadtime:0.062878131866455 / seconds
Query Executed:select id FROM `ut` where city='Bicknell' && SIC_code='7231'DB:business_master_new
loadtime:0.063738107681274 / seconds
Query loaded from cache:select * from geodata_geocity where city='Big Water' limit 1
loadtime:0.063809156417847 / seconds
Query Executed:select id FROM `ut` where city='Big Water' && SIC_code='7231'DB:business_master_new
loadtime:0.0642991065979 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bingham Canyon' limit 1
loadtime:0.064365148544312 / seconds
Query Executed:select id FROM `ut` where city='Bingham Canyon' && SIC_code='7231'DB:business_master_new
loadtime:0.065030097961426 / seconds
Query loaded from cache:select * from geodata_geocity where city='Blanding' limit 1
loadtime:0.065090179443359 / seconds
Query Executed:select id FROM `ut` where city='Blanding' && SIC_code='7231'DB:business_master_new
loadtime:0.069254159927368 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluebell' limit 1
loadtime:0.069343090057373 / seconds
Query Executed:select id FROM `ut` where city='Bluebell' && SIC_code='7231'DB:business_master_new
loadtime:0.069992065429688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bluff' limit 1
loadtime:0.070055961608887 / seconds
Query Executed:select id FROM `ut` where city='Bluff' && SIC_code='7231'DB:business_master_new
loadtime:0.070971012115479 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bonanza' limit 1
loadtime:0.07103705406189 / seconds
Query Executed:select id FROM `ut` where city='Bonanza' && SIC_code='7231'DB:business_master_new
loadtime:0.071529150009155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.07158899307251 / seconds
Query Executed:select id FROM `ut` where city='Boulder' && SIC_code='7231'DB:business_master_new
loadtime:0.072437047958374 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bountiful' limit 1
loadtime:0.072502136230469 / seconds
Query Executed:select id FROM `ut` where city='Bountiful' && SIC_code='7231'DB:business_master_new
loadtime:0.096724033355713 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brian Head' limit 1
loadtime:0.096894025802612 / seconds
Query Executed:select id FROM `ut` where city='Brian Head' && SIC_code='7231'DB:business_master_new
loadtime:0.09790301322937 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bridgeland' limit 1
loadtime:0.097970008850098 / seconds
Query Executed:select id FROM `ut` where city='Bridgeland' && SIC_code='7231'DB:business_master_new
loadtime:0.098474979400635 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brigham City' limit 1
loadtime:0.098541021347046 / seconds
Query Executed:select id FROM `ut` where city='Brigham City' && SIC_code='7231'DB:business_master_new
loadtime:0.11029195785522 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.11040806770325 / seconds
Query Executed:select id FROM `ut` where city='Brighton' && SIC_code='7231'DB:business_master_new
loadtime:0.11086416244507 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce' limit 1
loadtime:0.1109299659729 / seconds
Query Executed:select id FROM `ut` where city='Bryce' && SIC_code='7231'DB:business_master_new
loadtime:0.11148405075073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bryce Canyon' limit 1
loadtime:0.11154794692993 / seconds
Query Executed:select id FROM `ut` where city='Bryce Canyon' && SIC_code='7231'DB:business_master_new
loadtime:0.1120879650116 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cache Junction' limit 1
loadtime:0.11214900016785 / seconds
Query Executed:select id FROM `ut` where city='Cache Junction' && SIC_code='7231'DB:business_master_new
loadtime:0.11259007453918 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cannonville' limit 1
loadtime:0.11266016960144 / seconds
Query Executed:select id FROM `ut` where city='Cannonville' && SIC_code='7231'DB:business_master_new
loadtime:0.11322808265686 / seconds
Query loaded from cache:select * from geodata_geocity where city='Castle Dale' limit 1
loadtime:0.11328911781311 / seconds
Query Executed:select id FROM `ut` where city='Castle Dale' && SIC_code='7231'DB:business_master_new
loadtime:0.11676812171936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar City' limit 1
loadtime:0.11685609817505 / seconds
Query Executed:select id FROM `ut` where city='Cedar City' && SIC_code='7231'DB:business_master_new
loadtime:0.13595604896545 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cedar Valley' limit 1
loadtime:0.1360981464386 / seconds
Query Executed:select id FROM `ut` where city='Cedar Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.1368670463562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerfield' limit 1
loadtime:0.13693308830261 / seconds
Query Executed:select id FROM `ut` where city='Centerfield' && SIC_code='7231'DB:business_master_new
loadtime:0.13782501220703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.13790106773376 / seconds
Query Executed:select id FROM `ut` where city='Centerville' && SIC_code='7231'DB:business_master_new
loadtime:0.14633297920227 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.14642715454102 / seconds
Query Executed:select id FROM `ut` where city='Central' && SIC_code='7231'DB:business_master_new
loadtime:0.1469841003418 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Valley' limit 1
loadtime:0.14705204963684 / seconds
Query Executed:select id FROM `ut` where city='Central Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.14753913879395 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.14760208129883 / seconds
Query Executed:select id FROM `ut` where city='Chester' && SIC_code='7231'DB:business_master_new
loadtime:0.14816212654114 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.14822316169739 / seconds
Query Executed:select id FROM `ut` where city='Circleville' && SIC_code='7231'DB:business_master_new
loadtime:0.1490581035614 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cisco' limit 1
loadtime:0.14912009239197 / seconds
Query Executed:select id FROM `ut` where city='Cisco' && SIC_code='7231'DB:business_master_new
loadtime:0.14960598945618 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.14967107772827 / seconds
Query Executed:select id FROM `ut` where city='Clarkston' && SIC_code='7231'DB:business_master_new
loadtime:0.15031099319458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clawson' limit 1
loadtime:0.15037202835083 / seconds
Query Executed:select id FROM `ut` where city='Clawson' && SIC_code='7231'DB:business_master_new
loadtime:0.15096306800842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.15102410316467 / seconds
Query Executed:select id FROM `ut` where city='Clearfield' && SIC_code='7231'DB:business_master_new
loadtime:0.16632294654846 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.16644501686096 / seconds
Query Executed:select id FROM `ut` where city='Cleveland' && SIC_code='7231'DB:business_master_new
loadtime:0.16719698905945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Coalville' limit 1
loadtime:0.16728115081787 / seconds
Query Executed:select id FROM `ut` where city='Coalville' && SIC_code='7231'DB:business_master_new
loadtime:0.17137098312378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Collinston' limit 1
loadtime:0.17146015167236 / seconds
Query Executed:select id FROM `ut` where city='Collinston' && SIC_code='7231'DB:business_master_new
loadtime:0.17209601402283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Corinne' limit 1
loadtime:0.17217206954956 / seconds
Query Executed:select id FROM `ut` where city='Corinne' && SIC_code='7231'DB:business_master_new
loadtime:0.17319202423096 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.17325496673584 / seconds
Query Executed:select id FROM `ut` where city='Cornish' && SIC_code='7231'DB:business_master_new
loadtime:0.17385101318359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.17392706871033 / seconds
Query Executed:select id FROM `ut` where city='Cottonwood' && SIC_code='7231'DB:business_master_new
loadtime:0.17440414428711 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.17446517944336 / seconds
Query Executed:select id FROM `ut` where city='Croydon' && SIC_code='7231'DB:business_master_new
loadtime:0.17495799064636 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dammeron Valley' limit 1
loadtime:0.17502498626709 / seconds
Query Executed:select id FROM `ut` where city='Dammeron Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.1756579875946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.17571806907654 / seconds
Query Executed:select id FROM `ut` where city='Delta' && SIC_code='7231'DB:business_master_new
loadtime:0.18144297599792 / seconds
Query loaded from cache:select * from geodata_geocity where city='Deweyville' limit 1
loadtime:0.18153405189514 / seconds
Query Executed:select id FROM `ut` where city='Deweyville' && SIC_code='7231'DB:business_master_new
loadtime:0.18212413787842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.18219208717346 / seconds
Query Executed:select id FROM `ut` where city='Draper' && SIC_code='7231'DB:business_master_new
loadtime:0.20166707038879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duchesne' limit 1
loadtime:0.20180416107178 / seconds
Query Executed:select id FROM `ut` where city='Duchesne' && SIC_code='7231'DB:business_master_new
loadtime:0.20536708831787 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village' limit 1
loadtime:0.20545196533203 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village' && SIC_code='7231'DB:business_master_new
loadtime:0.20622110366821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village Cpu' limit 1
loadtime:0.20628595352173 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village Cpu' && SIC_code='7231'DB:business_master_new
loadtime:0.20677495002747 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Vlg' limit 1
loadtime:0.20684003829956 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Vlg' && SIC_code='7231'DB:business_master_new
loadtime:0.20732617378235 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugway' limit 1
loadtime:0.20739102363586 / seconds
Query Executed:select id FROM `ut` where city='Dugway' && SIC_code='7231'DB:business_master_new
loadtime:0.20831704139709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutch John' limit 1
loadtime:0.20837807655334 / seconds
Query Executed:select id FROM `ut` where city='Dutch John' && SIC_code='7231'DB:business_master_new
loadtime:0.20917296409607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Mountain' limit 1
loadtime:0.20925307273865 / seconds
Query Executed:select id FROM `ut` where city='Eagle Mountain' && SIC_code='7231'DB:business_master_new
loadtime:0.22686505317688 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Carbon' limit 1
loadtime:0.22693109512329 / seconds
Query Executed:select id FROM `ut` where city='East Carbon' && SIC_code='7231'DB:business_master_new
loadtime:0.2278881072998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echo' limit 1
loadtime:0.22797012329102 / seconds
Query Executed:select id FROM `ut` where city='Echo' && SIC_code='7231'DB:business_master_new
loadtime:0.22842001914978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.22848200798035 / seconds
Query Executed:select id FROM `ut` where city='Eden' && SIC_code='7231'DB:business_master_new
loadtime:0.24528002738953 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.24535894393921 / seconds
Query Executed:select id FROM `ut` where city='Elberta' && SIC_code='7231'DB:business_master_new
loadtime:0.2459671497345 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmo' limit 1
loadtime:0.24603700637817 / seconds
Query Executed:select id FROM `ut` where city='Elmo' && SIC_code='7231'DB:business_master_new
loadtime:0.24663615226746 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsinore' limit 1
loadtime:0.24671506881714 / seconds
Query Executed:select id FROM `ut` where city='Elsinore' && SIC_code='7231'DB:business_master_new
loadtime:0.24747800827026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.24755716323853 / seconds
Query Executed:select id FROM `ut` where city='Emery' && SIC_code='7231'DB:business_master_new
loadtime:0.24824213981628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.24830412864685 / seconds
Query Executed:select id FROM `ut` where city='Enterprise' && SIC_code='7231'DB:business_master_new
loadtime:0.249183177948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:0.24926209449768 / seconds
Query Executed:select id FROM `ut` where city='Ephraim' && SIC_code='7231'DB:business_master_new
loadtime:0.25340104103088 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escalante' limit 1
loadtime:0.25347900390625 / seconds
Query Executed:select id FROM `ut` where city='Escalante' && SIC_code='7231'DB:business_master_new
loadtime:0.25487112998962 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.25494599342346 / seconds
Query Executed:select id FROM `ut` where city='Eureka' && SIC_code='7231'DB:business_master_new
loadtime:0.25579810142517 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.25587511062622 / seconds
Query Executed:select id FROM `ut` where city='Fairview' && SIC_code='7231'DB:business_master_new
loadtime:0.27283215522766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.2729229927063 / seconds
Query Executed:select id FROM `ut` where city='Farmington' && SIC_code='7231'DB:business_master_new
loadtime:0.28011012077332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.28021001815796 / seconds
Query Executed:select id FROM `ut` where city='Fayette' && SIC_code='7231'DB:business_master_new
loadtime:0.28072500228882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferron' limit 1
loadtime:0.28080415725708 / seconds
Query Executed:select id FROM `ut` where city='Ferron' && SIC_code='7231'DB:business_master_new
loadtime:0.2977991104126 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fielding' limit 1
loadtime:0.29787611961365 / seconds
Query Executed:select id FROM `ut` where city='Fielding' && SIC_code='7231'DB:business_master_new
loadtime:0.2985680103302 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fillmore' limit 1
loadtime:0.29863905906677 / seconds
Query Executed:select id FROM `ut` where city='Fillmore' && SIC_code='7231'DB:business_master_new
loadtime:0.30278897285461 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Duchesne' limit 1
loadtime:0.30287098884583 / seconds
Query Executed:select id FROM `ut` where city='Fort Duchesne' && SIC_code='7231'DB:business_master_new
loadtime:0.3039870262146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Green' limit 1
loadtime:0.30405497550964 / seconds
Query Executed:select id FROM `ut` where city='Fountain Green' && SIC_code='7231'DB:business_master_new
loadtime:0.30491304397583 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.30498600006104 / seconds
Query Executed:select id FROM `ut` where city='Fruitland' && SIC_code='7231'DB:business_master_new
loadtime:0.30564403533936 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.3057119846344 / seconds
Query Executed:select id FROM `ut` where city='Garden City' && SIC_code='7231'DB:business_master_new
loadtime:0.30708003044128 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.30715608596802 / seconds
Query Executed:select id FROM `ut` where city='Garland' && SIC_code='7231'DB:business_master_new
loadtime:0.32402610778809 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.32409811019897 / seconds
Query Executed:select id FROM `ut` where city='Garrison' && SIC_code='7231'DB:business_master_new
loadtime:0.32471394538879 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genola' limit 1
loadtime:0.32478904724121 / seconds
Query Executed:select id FROM `ut` where city='Genola' && SIC_code='7231'DB:business_master_new
loadtime:0.32525515556335 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.32531499862671 / seconds
Query Executed:select id FROM `ut` where city='Glendale' && SIC_code='7231'DB:business_master_new
loadtime:0.3259711265564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.32603597640991 / seconds
Query Executed:select id FROM `ut` where city='Glenwood' && SIC_code='7231'DB:business_master_new
loadtime:0.32662415504456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.3266921043396 / seconds
Query Executed:select id FROM `ut` where city='Goshen' && SIC_code='7231'DB:business_master_new
loadtime:0.32744216918945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsville' limit 1
loadtime:0.32750296592712 / seconds
Query Executed:select id FROM `ut` where city='Grantsville' && SIC_code='7231'DB:business_master_new
loadtime:0.33147597312927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green River' limit 1
loadtime:0.33156108856201 / seconds
Query Executed:select id FROM `ut` where city='Green River' && SIC_code='7231'DB:business_master_new
loadtime:0.34836912155151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.3484480381012 / seconds
Query Executed:select id FROM `ut` where city='Greenville' && SIC_code='7231'DB:business_master_new
loadtime:0.34896516799927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.34902715682983 / seconds
Query Executed:select id FROM `ut` where city='Greenwich' && SIC_code='7231'DB:business_master_new
loadtime:0.34953117370605 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grouse Creek' limit 1
loadtime:0.34959101676941 / seconds
Query Executed:select id FROM `ut` where city='Grouse Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.35012006759644 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunlock' limit 1
loadtime:0.35018610954285 / seconds
Query Executed:select id FROM `ut` where city='Gunlock' && SIC_code='7231'DB:business_master_new
loadtime:0.35070514678955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.35077595710754 / seconds
Query Executed:select id FROM `ut` where city='Gunnison' && SIC_code='7231'DB:business_master_new
loadtime:0.36759305000305 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gusher' limit 1
loadtime:0.36767911911011 / seconds
Query Executed:select id FROM `ut` where city='Gusher' && SIC_code='7231'DB:business_master_new
loadtime:0.36817002296448 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanksville' limit 1
loadtime:0.36823606491089 / seconds
Query Executed:select id FROM `ut` where city='Hanksville' && SIC_code='7231'DB:business_master_new
loadtime:0.36902213096619 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanna' limit 1
loadtime:0.36908316612244 / seconds
Query Executed:select id FROM `ut` where city='Hanna' && SIC_code='7231'DB:business_master_new
loadtime:0.36959910392761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.36967802047729 / seconds
Query Executed:select id FROM `ut` where city='Hatch' && SIC_code='7231'DB:business_master_new
loadtime:0.37034797668457 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber City' limit 1
loadtime:0.37041115760803 / seconds
Query Executed:select id FROM `ut` where city='Heber City' && SIC_code='7231'DB:business_master_new
loadtime:0.37780094146729 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helper' limit 1
loadtime:0.37789297103882 / seconds
Query Executed:select id FROM `ut` where city='Helper' && SIC_code='7231'DB:business_master_new
loadtime:0.38150310516357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henefer' limit 1
loadtime:0.38159108161926 / seconds
Query Executed:select id FROM `ut` where city='Henefer' && SIC_code='7231'DB:business_master_new
loadtime:0.38227295875549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrieville' limit 1
loadtime:0.38234114646912 / seconds
Query Executed:select id FROM `ut` where city='Henrieville' && SIC_code='7231'DB:business_master_new
loadtime:0.38287901878357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herriman' limit 1
loadtime:0.38294005393982 / seconds
Query Executed:select id FROM `ut` where city='Herriman' && SIC_code='7231'DB:business_master_new
loadtime:0.38693904876709 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.38702297210693 / seconds
Query Executed:select id FROM `ut` where city='Hiawatha' && SIC_code='7231'DB:business_master_new
loadtime:0.38751101493835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:0.3875789642334 / seconds
Query Executed:select id FROM `ut` where city='Highland' && SIC_code='7231'DB:business_master_new
loadtime:0.38814306259155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildale' limit 1
loadtime:0.38822197914124 / seconds
Query Executed:select id FROM `ut` where city='Hildale' && SIC_code='7231'DB:business_master_new
loadtime:0.38958406448364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Afb' limit 1
loadtime:0.38965606689453 / seconds
Query Executed:select id FROM `ut` where city='Hill Afb' && SIC_code='7231'DB:business_master_new
loadtime:0.3910059928894 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Air Force Base' limit 1
loadtime:0.3910801410675 / seconds
Query Executed:select id FROM `ut` where city='Hill Air Force Base' && SIC_code='7231'DB:business_master_new
loadtime:0.39164900779724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinckley' limit 1
loadtime:0.39171099662781 / seconds
Query Executed:select id FROM `ut` where city='Hinckley' && SIC_code='7231'DB:business_master_new
loadtime:0.39241313934326 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hite' limit 1
loadtime:0.39247798919678 / seconds
Query Executed:select id FROM `ut` where city='Hite' && SIC_code='7231'DB:business_master_new
loadtime:0.39291310310364 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.39297413825989 / seconds
Query Executed:select id FROM `ut` where city='Holden' && SIC_code='7231'DB:business_master_new
loadtime:0.39360809326172 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holladay' limit 1
loadtime:0.39367008209229 / seconds
Query Executed:select id FROM `ut` where city='Holladay' && SIC_code='7231'DB:business_master_new
loadtime:0.39453411102295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honeyville' limit 1
loadtime:0.39460206031799 / seconds
Query Executed:select id FROM `ut` where city='Honeyville' && SIC_code='7231'DB:business_master_new
loadtime:0.39540910720825 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.39546895027161 / seconds
Query Executed:select id FROM `ut` where city='Hooper' && SIC_code='7231'DB:business_master_new
loadtime:0.41252398490906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:0.412593126297 / seconds
Query Executed:select id FROM `ut` where city='Howell' && SIC_code='7231'DB:business_master_new
loadtime:0.41315317153931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.41321897506714 / seconds
Query Executed:select id FROM `ut` where city='Huntington' && SIC_code='7231'DB:business_master_new
loadtime:0.4301290512085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntsville' limit 1
loadtime:0.4302191734314 / seconds
Query Executed:select id FROM `ut` where city='Huntsville' && SIC_code='7231'DB:business_master_new
loadtime:0.43141102790833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurricane' limit 1
loadtime:0.43148994445801 / seconds
Query Executed:select id FROM `ut` where city='Hurricane' && SIC_code='7231'DB:business_master_new
loadtime:0.43682217597961 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.43690395355225 / seconds
Query Executed:select id FROM `ut` where city='Hyde Park' && SIC_code='7231'DB:business_master_new
loadtime:0.43864297866821 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyrum' limit 1
loadtime:0.43872499465942 / seconds
Query Executed:select id FROM `ut` where city='Hyrum' && SIC_code='7231'DB:business_master_new
loadtime:0.44270205497742 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ibapah' limit 1
loadtime:0.44279098510742 / seconds
Query Executed:select id FROM `ut` where city='Ibapah' && SIC_code='7231'DB:business_master_new
loadtime:0.44338512420654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivins' limit 1
loadtime:0.44344711303711 / seconds
Query Executed:select id FROM `ut` where city='Ivins' && SIC_code='7231'DB:business_master_new
loadtime:0.46037912368774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jensen' limit 1
loadtime:0.46045517921448 / seconds
Query Executed:select id FROM `ut` where city='Jensen' && SIC_code='7231'DB:business_master_new
loadtime:0.4612410068512 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph' limit 1
loadtime:0.46130204200745 / seconds
Query Executed:select id FROM `ut` where city='Joseph' && SIC_code='7231'DB:business_master_new
loadtime:0.46193909645081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction' limit 1
loadtime:0.46200013160706 / seconds
Query Executed:select id FROM `ut` where city='Junction' && SIC_code='7231'DB:business_master_new
loadtime:0.46272397041321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamas' limit 1
loadtime:0.46280097961426 / seconds
Query Executed:select id FROM `ut` where city='Kamas' && SIC_code='7231'DB:business_master_new
loadtime:0.46710014343262 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanab' limit 1
loadtime:0.46718215942383 / seconds
Query Executed:select id FROM `ut` where city='Kanab' && SIC_code='7231'DB:business_master_new
loadtime:0.47290396690369 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanarraville' limit 1
loadtime:0.47299098968506 / seconds
Query Executed:select id FROM `ut` where city='Kanarraville' && SIC_code='7231'DB:business_master_new
loadtime:0.47362208366394 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanosh' limit 1
loadtime:0.4736921787262 / seconds
Query Executed:select id FROM `ut` where city='Kanosh' && SIC_code='7231'DB:business_master_new
loadtime:0.47435808181763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaysville' limit 1
loadtime:0.47442007064819 / seconds
Query Executed:select id FROM `ut` where city='Kaysville' && SIC_code='7231'DB:business_master_new
loadtime:0.48691511154175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearns' limit 1
loadtime:0.48703217506409 / seconds
Query Executed:select id FROM `ut` where city='Kearns' && SIC_code='7231'DB:business_master_new
loadtime:0.49129009246826 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:0.49138307571411 / seconds
Query Executed:select id FROM `ut` where city='Kenilworth' && SIC_code='7231'DB:business_master_new
loadtime:0.49188804626465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.49195098876953 / seconds
Query Executed:select id FROM `ut` where city='Kingston' && SIC_code='7231'DB:business_master_new
loadtime:0.49249601364136 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koosharem' limit 1
loadtime:0.49255609512329 / seconds
Query Executed:select id FROM `ut` where city='Koosharem' && SIC_code='7231'DB:business_master_new
loadtime:0.49321317672729 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Sal' limit 1
loadtime:0.49327516555786 / seconds
Query Executed:select id FROM `ut` where city='La Sal' && SIC_code='7231'DB:business_master_new
loadtime:0.49393105506897 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Verkin' limit 1
loadtime:0.49399614334106 / seconds
Query Executed:select id FROM `ut` where city='La Verkin' && SIC_code='7231'DB:business_master_new
loadtime:0.49512815475464 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Powell' limit 1
loadtime:0.49520516395569 / seconds
Query Executed:select id FROM `ut` where city='Lake Powell' && SIC_code='7231'DB:business_master_new
loadtime:0.49592614173889 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laketown' limit 1
loadtime:0.49598908424377 / seconds
Query Executed:select id FROM `ut` where city='Laketown' && SIC_code='7231'DB:business_master_new
loadtime:0.49678111076355 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapoint' limit 1
loadtime:0.49685716629028 / seconds
Query Executed:select id FROM `ut` where city='Lapoint' && SIC_code='7231'DB:business_master_new
loadtime:0.49761414527893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:0.49768900871277 / seconds
Query Executed:select id FROM `ut` where city='Layton' && SIC_code='7231'DB:business_master_new
loadtime:0.52305912971497 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leamington' limit 1
loadtime:0.52322006225586 / seconds
Query Executed:select id FROM `ut` where city='Leamington' && SIC_code='7231'DB:business_master_new
loadtime:0.52382016181946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:0.5238881111145 / seconds
Query Executed:select id FROM `ut` where city='Leeds' && SIC_code='7231'DB:business_master_new
loadtime:0.52461695671082 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehi' limit 1
loadtime:0.52469301223755 / seconds
Query Executed:select id FROM `ut` where city='Lehi' && SIC_code='7231'DB:business_master_new
loadtime:0.53533315658569 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levan' limit 1
loadtime:0.5354311466217 / seconds
Query Executed:select id FROM `ut` where city='Levan' && SIC_code='7231'DB:business_master_new
loadtime:0.53605914115906 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:0.53613615036011 / seconds
Query Executed:select id FROM `ut` where city='Lewiston' && SIC_code='7231'DB:business_master_new
loadtime:0.55358815193176 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.55367112159729 / seconds
Query Executed:select id FROM `ut` where city='Lindon' && SIC_code='7231'DB:business_master_new
loadtime:0.56110215187073 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loa' limit 1
loadtime:0.56119799613953 / seconds
Query Executed:select id FROM `ut` where city='Loa' && SIC_code='7231'DB:business_master_new
loadtime:0.56220006942749 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.56227898597717 / seconds
Query Executed:select id FROM `ut` where city='Logan' && SIC_code='7231'DB:business_master_new
loadtime:0.59292507171631 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.59308695793152 / seconds
Query Executed:select id FROM `ut` where city='Lyman' && SIC_code='7231'DB:business_master_new
loadtime:0.59363412857056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynndyl' limit 1
loadtime:0.5937020778656 / seconds
Query Executed:select id FROM `ut` where city='Lynndyl' && SIC_code='7231'DB:business_master_new
loadtime:0.59438109397888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magna' limit 1
loadtime:0.59444117546082 / seconds
Query Executed:select id FROM `ut` where city='Magna' && SIC_code='7231'DB:business_master_new
loadtime:0.60061097145081 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manila' limit 1
loadtime:0.60069417953491 / seconds
Query Executed:select id FROM `ut` where city='Manila' && SIC_code='7231'DB:business_master_new
loadtime:0.60174202919006 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manti' limit 1
loadtime:0.60181498527527 / seconds
Query Executed:select id FROM `ut` where city='Manti' && SIC_code='7231'DB:business_master_new
loadtime:0.61936497688293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:0.61946296691895 / seconds
Query Executed:select id FROM `ut` where city='Mantua' && SIC_code='7231'DB:business_master_new
loadtime:0.62017512321472 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.62023901939392 / seconds
Query Executed:select id FROM `ut` where city='Mapleton' && SIC_code='7231'DB:business_master_new
loadtime:0.62448906898499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysvale' limit 1
loadtime:0.62457203865051 / seconds
Query Executed:select id FROM `ut` where city='Marysvale' && SIC_code='7231'DB:business_master_new
loadtime:0.62545800209045 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:0.62552094459534 / seconds
Query Executed:select id FROM `ut` where city='Mayfield' && SIC_code='7231'DB:business_master_new
loadtime:0.62611198425293 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.62617301940918 / seconds
Query Executed:select id FROM `ut` where city='Meadow' && SIC_code='7231'DB:business_master_new
loadtime:0.62672901153564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:0.62680006027222 / seconds
Query Executed:select id FROM `ut` where city='Mendon' && SIC_code='7231'DB:business_master_new
loadtime:0.62773299217224 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Hat' limit 1
loadtime:0.62780404090881 / seconds
Query Executed:select id FROM `ut` where city='Mexican Hat' && SIC_code='7231'DB:business_master_new
loadtime:0.62834715843201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midvale' limit 1
loadtime:0.62840795516968 / seconds
Query Executed:select id FROM `ut` where city='Midvale' && SIC_code='7231'DB:business_master_new
loadtime:0.64978003501892 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:0.64991402626038 / seconds
Query Executed:select id FROM `ut` where city='Midway' && SIC_code='7231'DB:business_master_new
loadtime:0.66719198226929 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.66727304458618 / seconds
Query Executed:select id FROM `ut` where city='Milford' && SIC_code='7231'DB:business_master_new
loadtime:0.66873717308044 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:0.66882514953613 / seconds
Query Executed:select id FROM `ut` where city='Millville' && SIC_code='7231'DB:business_master_new
loadtime:0.66970014572144 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minersville' limit 1
loadtime:0.66977310180664 / seconds
Query Executed:select id FROM `ut` where city='Minersville' && SIC_code='7231'DB:business_master_new
loadtime:0.67055511474609 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moab' limit 1
loadtime:0.67062211036682 / seconds
Query Executed:select id FROM `ut` where city='Moab' && SIC_code='7231'DB:business_master_new
loadtime:0.681321144104 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:0.68141508102417 / seconds
Query Executed:select id FROM `ut` where city='Modena' && SIC_code='7231'DB:business_master_new
loadtime:0.68190097808838 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mona' limit 1
loadtime:0.68196606636047 / seconds
Query Executed:select id FROM `ut` where city='Mona' && SIC_code='7231'DB:business_master_new
loadtime:0.68284296989441 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.68290305137634 / seconds
Query Executed:select id FROM `ut` where city='Monroe' && SIC_code='7231'DB:business_master_new
loadtime:0.68446207046509 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma Creek' limit 1
loadtime:0.68454098701477 / seconds
Query Executed:select id FROM `ut` where city='Montezuma Creek' && SIC_code='7231'DB:business_master_new
loadtime:0.68532705307007 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.68539714813232 / seconds
Query Executed:select id FROM `ut` where city='Monticello' && SIC_code='7231'DB:business_master_new
loadtime:0.70225715637207 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Valley' limit 1
loadtime:0.70233511924744 / seconds
Query Executed:select id FROM `ut` where city='Monument Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.70306515693665 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.70312714576721 / seconds
Query Executed:select id FROM `ut` where city='Morgan' && SIC_code='7231'DB:business_master_new
loadtime:0.70891404151917 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moroni' limit 1
loadtime:0.70900011062622 / seconds
Query Executed:select id FROM `ut` where city='Moroni' && SIC_code='7231'DB:business_master_new
loadtime:0.71008014678955 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.7101571559906 / seconds
Query Executed:select id FROM `ut` where city='Mount Carmel' && SIC_code='7231'DB:business_master_new
loadtime:0.71077513694763 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.7108371257782 / seconds
Query Executed:select id FROM `ut` where city='Mount Pleasant' && SIC_code='7231'DB:business_master_new
loadtime:0.71495914459229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:0.71504902839661 / seconds
Query Executed:select id FROM `ut` where city='Mountain Home' && SIC_code='7231'DB:business_master_new
loadtime:0.71568608283997 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.71574807167053 / seconds
Query Executed:select id FROM `ut` where city='Mt Carmel' && SIC_code='7231'DB:business_master_new
loadtime:0.71624517440796 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.71630597114563 / seconds
Query Executed:select id FROM `ut` where city='Mt Pleasant' && SIC_code='7231'DB:business_master_new
loadtime:0.71701002120972 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.71707105636597 / seconds
Query Executed:select id FROM `ut` where city='Murray' && SIC_code='7231'DB:business_master_new
loadtime:0.71871113777161 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myton' limit 1
loadtime:0.71879696846008 / seconds
Query Executed:select id FROM `ut` where city='Myton' && SIC_code='7231'DB:business_master_new
loadtime:0.71970510482788 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.71979403495789 / seconds
Query Executed:select id FROM `ut` where city='Neola' && SIC_code='7231'DB:business_master_new
loadtime:0.72047996520996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nephi' limit 1
loadtime:0.72054100036621 / seconds
Query Executed:select id FROM `ut` where city='Nephi' && SIC_code='7231'DB:business_master_new
loadtime:0.72567296028137 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Harmony' limit 1
loadtime:0.72576808929443 / seconds
Query Executed:select id FROM `ut` where city='New Harmony' && SIC_code='7231'DB:business_master_new
loadtime:0.72645497322083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:0.72653198242188 / seconds
Query Executed:select id FROM `ut` where city='Newcastle' && SIC_code='7231'DB:business_master_new
loadtime:0.72713994979858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.72720217704773 / seconds
Query Executed:select id FROM `ut` where city='Newton' && SIC_code='7231'DB:business_master_new
loadtime:0.72792315483093 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salt Lake' limit 1
loadtime:0.7279839515686 / seconds
Query Executed:select id FROM `ut` where city='North Salt Lake' && SIC_code='7231'DB:business_master_new
loadtime:0.73645710945129 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:0.73654913902283 / seconds
Query Executed:select id FROM `ut` where city='Oak City' && SIC_code='7231'DB:business_master_new
loadtime:0.73718595504761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:0.73726105690002 / seconds
Query Executed:select id FROM `ut` where city='Oakley' && SIC_code='7231'DB:business_master_new
loadtime:0.73837304115295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oasis' limit 1
loadtime:0.73844909667969 / seconds
Query Executed:select id FROM `ut` where city='Oasis' && SIC_code='7231'DB:business_master_new
loadtime:0.73892903327942 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.73899006843567 / seconds
Query Executed:select id FROM `ut` where city='Ogden' && SIC_code='7231'DB:business_master_new
loadtime:0.76607012748718 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeville' limit 1
loadtime:0.766282081604 / seconds
Query Executed:select id FROM `ut` where city='Orangeville' && SIC_code='7231'DB:business_master_new
loadtime:0.76715207099915 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orderville' limit 1
loadtime:0.76722407341003 / seconds
Query Executed:select id FROM `ut` where city='Orderville' && SIC_code='7231'DB:business_master_new
loadtime:0.76805806159973 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orem' limit 1
loadtime:0.76811814308167 / seconds
Query Executed:select id FROM `ut` where city='Orem' && SIC_code='7231'DB:business_master_new
loadtime:0.78694915771484 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panguitch' limit 1
loadtime:0.78713417053223 / seconds
Query Executed:select id FROM `ut` where city='Panguitch' && SIC_code='7231'DB:business_master_new
loadtime:0.79118394851685 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:0.79127502441406 / seconds
Query Executed:select id FROM `ut` where city='Paradise' && SIC_code='7231'DB:business_master_new
loadtime:0.79231905937195 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paragonah' limit 1
loadtime:0.79238104820251 / seconds
Query Executed:select id FROM `ut` where city='Paragonah' && SIC_code='7231'DB:business_master_new
loadtime:0.79304003715515 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park City' limit 1
loadtime:0.79310202598572 / seconds
Query Executed:select id FROM `ut` where city='Park City' && SIC_code='7231'DB:business_master_new
loadtime:0.82053709030151 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Valley' limit 1
loadtime:0.82067394256592 / seconds
Query Executed:select id FROM `ut` where city='Park Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.82119417190552 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parowan' limit 1
loadtime:0.82126116752625 / seconds
Query Executed:select id FROM `ut` where city='Parowan' && SIC_code='7231'DB:business_master_new
loadtime:0.83862709999084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.83870816230774 / seconds
Query Executed:select id FROM `ut` where city='Payson' && SIC_code='7231'DB:business_master_new
loadtime:0.84749007225037 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoa' limit 1
loadtime:0.84759497642517 / seconds
Query Executed:select id FROM `ut` where city='Peoa' && SIC_code='7231'DB:business_master_new
loadtime:0.84839510917664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Valley' limit 1
loadtime:0.84845995903015 / seconds
Query Executed:select id FROM `ut` where city='Pine Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.84898996353149 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Grove' limit 1
loadtime:0.84905195236206 / seconds
Query Executed:select id FROM `ut` where city='Pleasant Grove' && SIC_code='7231'DB:business_master_new
loadtime:0.86095809936523 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.86105704307556 / seconds
Query Executed:select id FROM `ut` where city='Plymouth' && SIC_code='7231'DB:business_master_new
loadtime:0.86170697212219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:0.86178302764893 / seconds
Query Executed:select id FROM `ut` where city='Portage' && SIC_code='7231'DB:business_master_new
loadtime:0.86230707168579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Price' limit 1
loadtime:0.86236810684204 / seconds
Query Executed:select id FROM `ut` where city='Price' && SIC_code='7231'DB:business_master_new
loadtime:0.87357902526855 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:0.87370109558105 / seconds
Query Executed:select id FROM `ut` where city='Providence' && SIC_code='7231'DB:business_master_new
loadtime:0.89113211631775 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provo' limit 1
loadtime:0.89121913909912 / seconds
Query Executed:select id FROM `ut` where city='Provo' && SIC_code='7231'DB:business_master_new
loadtime:0.93111300468445 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randlett' limit 1
loadtime:0.93130707740784 / seconds
Query Executed:select id FROM `ut` where city='Randlett' && SIC_code='7231'DB:business_master_new
loadtime:0.93197703361511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.93204712867737 / seconds
Query Executed:select id FROM `ut` where city='Randolph' && SIC_code='7231'DB:business_master_new
loadtime:0.9332640171051 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:0.93334007263184 / seconds
Query Executed:select id FROM `ut` where city='Redmond' && SIC_code='7231'DB:business_master_new
loadtime:0.9341299533844 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:0.93419194221497 / seconds
Query Executed:select id FROM `ut` where city='Richfield' && SIC_code='7231'DB:business_master_new
loadtime:0.94273400306702 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.94284105300903 / seconds
Query Executed:select id FROM `ut` where city='Richmond' && SIC_code='7231'DB:business_master_new
loadtime:0.94440817832947 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.94448494911194 / seconds
Query Executed:select id FROM `ut` where city='Riverside' && SIC_code='7231'DB:business_master_new
loadtime:0.94512796401978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.94519114494324 / seconds
Query Executed:select id FROM `ut` where city='Riverton' && SIC_code='7231'DB:business_master_new
loadtime:0.95926213264465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.95936799049377 / seconds
Query Executed:select id FROM `ut` where city='Rockville' && SIC_code='7231'DB:business_master_new
loadtime:0.95994305610657 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.96000814437866 / seconds
Query Executed:select id FROM `ut` where city='Roosevelt' && SIC_code='7231'DB:business_master_new
loadtime:0.96827101707458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.96836614608765 / seconds
Query Executed:select id FROM `ut` where city='Roy' && SIC_code='7231'DB:business_master_new
loadtime:0.97637009620667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush Valley' limit 1
loadtime:0.97648501396179 / seconds
Query Executed:select id FROM `ut` where city='Rush Valley' && SIC_code='7231'DB:business_master_new
loadtime:0.97710514068604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.97717094421387 / seconds
Query Executed:select id FROM `ut` where city='Saint George' && SIC_code='7231'DB:business_master_new
loadtime:1.005656003952 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:1.0057940483093 / seconds
Query Executed:select id FROM `ut` where city='Salem' && SIC_code='7231'DB:business_master_new
loadtime:1.0100131034851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salina' limit 1
loadtime:1.0101001262665 / seconds
Query Executed:select id FROM `ut` where city='Salina' && SIC_code='7231'DB:business_master_new
loadtime:1.0279049873352 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salt Lake City' limit 1
loadtime:1.0279901027679 / seconds
Query Executed:select id FROM `ut` where city='Salt Lake City' && SIC_code='7231'DB:business_master_new
loadtime:1.0472161769867 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy' limit 1
loadtime:1.0480380058289 / seconds
Query Executed:select id FROM `ut` where city='Sandy' && SIC_code='7231'DB:business_master_new
loadtime:1.0669050216675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:1.0671510696411 / seconds
Query Executed:select id FROM `ut` where city='Santa Clara' && SIC_code='7231'DB:business_master_new
loadtime:1.0840570926666 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santaquin' limit 1
loadtime:1.0841431617737 / seconds
Query Executed:select id FROM `ut` where city='Santaquin' && SIC_code='7231'DB:business_master_new
loadtime:1.0861821174622 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga Springs' limit 1
loadtime:1.0862631797791 / seconds
Query Executed:select id FROM `ut` where city='Saratoga Springs' && SIC_code='7231'DB:business_master_new
loadtime:1.0877771377563 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scipio' limit 1
loadtime:1.0878529548645 / seconds
Query Executed:select id FROM `ut` where city='Scipio' && SIC_code='7231'DB:business_master_new
loadtime:1.0884830951691 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sevier' limit 1
loadtime:1.0885441303253 / seconds
Query Executed:select id FROM `ut` where city='Sevier' && SIC_code='7231'DB:business_master_new
loadtime:1.0891160964966 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigurd' limit 1
loadtime:1.0891771316528 / seconds
Query Executed:select id FROM `ut` where city='Sigurd' && SIC_code='7231'DB:business_master_new
loadtime:1.0899131298065 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:1.0899741649628 / seconds
Query Executed:select id FROM `ut` where city='Smithfield' && SIC_code='7231'DB:business_master_new
loadtime:1.0955510139465 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowbird' limit 1
loadtime:1.0956439971924 / seconds
Query Executed:select id FROM `ut` where city='Snowbird' && SIC_code='7231'DB:business_master_new
loadtime:1.0962030887604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowville' limit 1
loadtime:1.0962660312653 / seconds
Query Executed:select id FROM `ut` where city='Snowville' && SIC_code='7231'DB:business_master_new
loadtime:1.0969729423523 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Jordan' limit 1
loadtime:1.0970339775085 / seconds
Query Executed:select id FROM `ut` where city='South Jordan' && SIC_code='7231'DB:business_master_new
loadtime:1.112193107605 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Salt Lake' limit 1
loadtime:1.112291097641 / seconds
Query Executed:select id FROM `ut` where city='South Salt Lake' && SIC_code='7231'DB:business_master_new
loadtime:1.1129431724548 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanish Fork' limit 1
loadtime:1.113007068634 / seconds
Query Executed:select id FROM `ut` where city='Spanish Fork' && SIC_code='7231'DB:business_master_new
loadtime:1.1254870891571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring City' limit 1
loadtime:1.1256170272827 / seconds
Query Executed:select id FROM `ut` where city='Spring City' && SIC_code='7231'DB:business_master_new
loadtime:1.1263830661774 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springdale' limit 1
loadtime:1.1264500617981 / seconds
Query Executed:select id FROM `ut` where city='Springdale' && SIC_code='7231'DB:business_master_new
loadtime:1.1437859535217 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:1.1438491344452 / seconds
Query Executed:select id FROM `ut` where city='Springville' && SIC_code='7231'DB:business_master_new
loadtime:1.1553671360016 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:1.1554691791534 / seconds
Query Executed:select id FROM `ut` where city='St George' && SIC_code='7231'DB:business_master_new
loadtime:1.1566669940948 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:1.1567471027374 / seconds
Query Executed:select id FROM `ut` where city='Sterling' && SIC_code='7231'DB:business_master_new
loadtime:1.1573910713196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:1.1574530601501 / seconds
Query Executed:select id FROM `ut` where city='Stockton' && SIC_code='7231'DB:business_master_new
loadtime:1.1582071781158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:1.1582679748535 / seconds
Query Executed:select id FROM `ut` where city='Summit' && SIC_code='7231'DB:business_master_new
loadtime:1.158851146698 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunnyside' limit 1
loadtime:1.1589109897614 / seconds
Query Executed:select id FROM `ut` where city='Sunnyside' && SIC_code='7231'DB:business_master_new
loadtime:1.1595330238342 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syracuse' limit 1
loadtime:1.1595931053162 / seconds
Query Executed:select id FROM `ut` where city='Syracuse' && SIC_code='7231'DB:business_master_new
loadtime:1.1645841598511 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabiona' limit 1
loadtime:1.164675951004 / seconds
Query Executed:select id FROM `ut` where city='Tabiona' && SIC_code='7231'DB:business_master_new
loadtime:1.1653270721436 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talmage' limit 1
loadtime:1.1653890609741 / seconds
Query Executed:select id FROM `ut` where city='Talmage' && SIC_code='7231'DB:business_master_new
loadtime:1.1660161018372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teasdale' limit 1
loadtime:1.1660759449005 / seconds
Query Executed:select id FROM `ut` where city='Teasdale' && SIC_code='7231'DB:business_master_new
loadtime:1.166718006134 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terra' limit 1
loadtime:1.1667881011963 / seconds
Query Executed:select id FROM `ut` where city='Terra' && SIC_code='7231'DB:business_master_new
loadtime:1.1672210693359 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:1.1672821044922 / seconds
Query Executed:select id FROM `ut` where city='Thompson' && SIC_code='7231'DB:business_master_new
loadtime:1.1677739620209 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tooele' limit 1
loadtime:1.1678440570831 / seconds
Query Executed:select id FROM `ut` where city='Tooele' && SIC_code='7231'DB:business_master_new
loadtime:1.1811320781708 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toquerville' limit 1
loadtime:1.1812450885773 / seconds
Query Executed:select id FROM `ut` where city='Toquerville' && SIC_code='7231'DB:business_master_new
loadtime:1.1819851398468 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrey' limit 1
loadtime:1.1820509433746 / seconds
Query Executed:select id FROM `ut` where city='Torrey' && SIC_code='7231'DB:business_master_new
loadtime:1.1829481124878 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremonton' limit 1
loadtime:1.1830260753632 / seconds
Query Executed:select id FROM `ut` where city='Tremonton' && SIC_code='7231'DB:business_master_new
loadtime:1.1895160675049 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:1.1896049976349 / seconds
Query Executed:select id FROM `ut` where city='Trenton' && SIC_code='7231'DB:business_master_new
loadtime:1.1902160644531 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tridell' limit 1
loadtime:1.1902780532837 / seconds
Query Executed:select id FROM `ut` where city='Tridell' && SIC_code='7231'DB:business_master_new
loadtime:1.1907949447632 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tropic' limit 1
loadtime:1.1908550262451 / seconds
Query Executed:select id FROM `ut` where city='Tropic' && SIC_code='7231'DB:business_master_new
loadtime:1.1918041706085 / seconds
Query loaded from cache:select * from geodata_geocity where city='Venice' limit 1
loadtime:1.1918649673462 / seconds
Query Executed:select id FROM `ut` where city='Venice' && SIC_code='7231'DB:business_master_new
loadtime:1.1923320293427 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernal' limit 1
loadtime:1.1923930644989 / seconds
Query Executed:select id FROM `ut` where city='Vernal' && SIC_code='7231'DB:business_master_new
loadtime:1.2083060741425 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:1.2084159851074 / seconds
Query Executed:select id FROM `ut` where city='Vernon' && SIC_code='7231'DB:business_master_new
loadtime:1.2089660167694 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veyo' limit 1
loadtime:1.2090320587158 / seconds
Query Executed:select id FROM `ut` where city='Veyo' && SIC_code='7231'DB:business_master_new
loadtime:1.2097339630127 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgin' limit 1
loadtime:1.2098240852356 / seconds
Query Executed:select id FROM `ut` where city='Virgin' && SIC_code='7231'DB:business_master_new
loadtime:1.2104151248932 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:1.2104761600494 / seconds
Query Executed:select id FROM `ut` where city='Wales' && SIC_code='7231'DB:business_master_new
loadtime:1.2110230922699 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallsburg' limit 1
loadtime:1.2110841274261 / seconds
Query Executed:select id FROM `ut` where city='Wallsburg' && SIC_code='7231'DB:business_master_new
loadtime:1.2117030620575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:1.2117731571198 / seconds
Query Executed:select id FROM `ut` where city='Washington' && SIC_code='7231'DB:business_master_new
loadtime:1.2166171073914 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:1.2167019844055 / seconds
Query Executed:select id FROM `ut` where city='Wellington' && SIC_code='7231'DB:business_master_new
loadtime:1.2181911468506 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsville' limit 1
loadtime:1.2182681560516 / seconds
Query Executed:select id FROM `ut` where city='Wellsville' && SIC_code='7231'DB:business_master_new
loadtime:1.2202820777893 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendover' limit 1
loadtime:1.220360994339 / seconds
Query Executed:select id FROM `ut` where city='Wendover' && SIC_code='7231'DB:business_master_new
loadtime:1.2219021320343 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:1.2219820022583 / seconds
Query Executed:select id FROM `ut` where city='West Haven' && SIC_code='7231'DB:business_master_new
loadtime:1.2224431037903 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jordan' limit 1
loadtime:1.2225050926208 / seconds
Query Executed:select id FROM `ut` where city='West Jordan' && SIC_code='7231'DB:business_master_new
loadtime:1.2504019737244 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Valley' limit 1
loadtime:1.2505700588226 / seconds
Query Executed:select id FROM `ut` where city='West Valley' && SIC_code='7231'DB:business_master_new
loadtime:1.2515859603882 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiterocks' limit 1
loadtime:1.2516729831696 / seconds
Query Executed:select id FROM `ut` where city='Whiterocks' && SIC_code='7231'DB:business_master_new
loadtime:1.2522649765015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:1.2523281574249 / seconds
Query Executed:select id FROM `ut` where city='Willard' && SIC_code='7231'DB:business_master_new
loadtime:1.2550981044769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Hills' limit 1
loadtime:1.255175113678 / seconds
Query Executed:select id FROM `ut` where city='Woodland Hills' && SIC_code='7231'DB:business_master_new
loadtime:1.2556099891663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:1.2556731700897 / seconds
Query Executed:select id FROM `ut` where city='Woodruff' && SIC_code='7231'DB:business_master_new
loadtime:1.2727911472321 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross' limit 1
loadtime:1.2728800773621 / seconds
Query Executed:select id FROM `ut` where city='Woods Cross' && SIC_code='7231'DB:business_master_new
loadtime:1.2918419837952 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:1.2920210361481 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:1.2924129962921 / seconds
Operation template executed (chunk cache operation)
loadtime:1.2925720214844 / seconds
template override:Default
loadtime:1.2926180362701 / 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.2939870357513 / seconds
Template Constructed, Array Rows:49
loadtime:1.2945230007172 / seconds
TOTAL EXECUTION TIME: 1.29408
loadtime:1.296070098877 / 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] => beauty-shops [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:1.2960810661316
TOTAL KEY ARRAYS: 69