DEVELOPER MODE ENABLED
OPERATIONS DATA/LOADTIME


cache not set compiling
loadtime:0.0001070499420166 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.00075602531433105 / seconds
host not found setting manual db connection
loadtime:0.0013000965118408 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0017261505126953 / seconds
Query Executed:select * from general_settings where id=1DB:ezrox_toadli
loadtime:0.0020020008087158 / seconds
Query loaded from cache:select * from image_settings where id=1
loadtime:0.0020971298217773 / seconds
zipcode:
loadtime:0.0021159648895264 / seconds
Query Executed:select * from search_referrer where page_hash='04932f4a4d3d92a1394a1e520d0e7cc3' limit 10 DB:ezrox_toadli
loadtime:0.0023610591888428 / seconds
Operation header executed (non global)
loadtime:0.0023901462554932 / seconds
Operation leaderboard executed (non global)
loadtime:0.0024480819702148 / seconds
Operation square executed (non global)
loadtime:0.0024721622467041 / seconds
Operation square_bottom executed (non global)
loadtime:0.002493143081665 / seconds
Operation smallsquare executed (non global)
loadtime:0.0025119781494141 / seconds
Operation headeradright executed (non global)
loadtime:0.0025300979614258 / seconds
Operation google_analytics executed (non global)
loadtime:0.0025479793548584 / seconds
Operation topstories executed (non global)
loadtime:0.0025680065155029 / seconds
Operation businessnearyou executed (non global)
loadtime:0.0025870800018311 / seconds
Operation memberbuscount executed (non global)
loadtime:0.0026040077209473 / seconds
DB connected to localhost ezrox_toadli
loadtime:0.0029780864715576 / seconds
Query Executed:select * from users_profiles where userid=''DB:ezrox_toadli
loadtime:0.0031900405883789 / seconds
Operation categories executed (global stored into APC)
loadtime:0.0032291412353516 / seconds
Operation categories_menu executed (global stored into APC)
loadtime:0.003291130065918 / seconds
Operation archive_menu using avail. global APC cache
loadtime:0.0033431053161621 / seconds
Template key: archive_menu pushed
loadtime:0.003352165222168 / seconds
Operation get_gravatar using avail. global APC cache
loadtime:0.0033621788024902 / seconds
Template key: get_gravatar pushed
loadtime:0.0033681392669678 / seconds
Operation directorystate executed (chunk cache operation)
loadtime:0.0033750534057617 / seconds
*10)-10)+1 | start:0
loadtime:0.0034129619598389 / seconds
Query loaded from cache:select * from categories where cat_URLid='laundry-and-garment-services-nec'
loadtime:0.0034651756286621 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.003507137298584 / seconds
DB connected to localhost business_master_new
loadtime:0.0038981437683105 / seconds
Query Executed:select * from `ut_catmap` where sic='7219' order by city ascDB:business_master_new
loadtime:0.18108415603638 / seconds
Query stored in cache : _QUERY_www.toadli.comb022a05d5b08ae0f9ee1818530f36d2b
loadtime:0.1818790435791 / seconds
Query loaded from cache:select * from geodata_usstates where url_id='utah'
loadtime:0.18192911148071 / seconds
Query Executed:select sum(totalcount) as totalsum from `ut_catmap` where sic='7219'DB:business_master_new
loadtime:0.18455505371094 / seconds
Query stored in cache : _QUERY_www.toadli.comad611665363e7e3ba85c48a2adc3f235
loadtime:0.1846079826355 / seconds
279 / 11
loadtime:0.18466305732727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alpine' limit 1
loadtime:0.18477201461792 / seconds
Query Executed:select id FROM `ut` where city='Alpine' && SIC_code='7219'DB:business_master_new
loadtime:0.23230600357056 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alta' limit 1
loadtime:0.23235511779785 / seconds
Query Executed:select id FROM `ut` where city='Alta' && SIC_code='7219'DB:business_master_new
loadtime:0.2377781867981 / seconds
Query loaded from cache:select * from geodata_geocity where city='Altamont' limit 1
loadtime:0.23791718482971 / seconds
Query Executed:select id FROM `ut` where city='Altamont' && SIC_code='7219'DB:business_master_new
loadtime:0.23856711387634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Alton' limit 1
loadtime:0.23861598968506 / seconds
Query Executed:select id FROM `ut` where city='Alton' && SIC_code='7219'DB:business_master_new
loadtime:0.25051808357239 / seconds
Query Executed:select * from geodata_geocity where city='Altonah' limit 1DB:business_master_new
loadtime:0.25088715553284 / seconds
Query stored in cache : _QUERY_www.toadli.com96ab0664d20eeadc68186c82c0d49ef6
loadtime:0.25092911720276 / seconds
Query Executed:select id FROM `ut` where city='Altonah' && SIC_code='7219'DB:business_master_new
loadtime:0.26605796813965 / seconds
Query Executed:select * from geodata_geocity where city='American Fork' limit 1DB:business_master_new
loadtime:0.26646304130554 / seconds
Query stored in cache : _QUERY_www.toadli.comb152b2d30c3b68e7c725a946851baa8b
loadtime:0.26653504371643 / seconds
Query Executed:select id FROM `ut` where city='American Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.26746106147766 / seconds
Query Executed:select * from geodata_geocity where city='Aneth' limit 1DB:business_master_new
loadtime:0.26791000366211 / seconds
Query stored in cache : _QUERY_www.toadli.com49f5f4636276eebe1a6d52c303efc844
loadtime:0.2679660320282 / seconds
Query Executed:select id FROM `ut` where city='Aneth' && SIC_code='7219'DB:business_master_new
loadtime:0.26932501792908 / seconds
Query Executed:select * from geodata_geocity where city='Annabella' limit 1DB:business_master_new
loadtime:0.26972818374634 / seconds
Query stored in cache : _QUERY_www.toadli.comfef031a8a8756ef612fc5f819e24444d
loadtime:0.26977801322937 / seconds
Query Executed:select id FROM `ut` where city='Annabella' && SIC_code='7219'DB:business_master_new
loadtime:0.27817702293396 / seconds
Query Executed:select * from geodata_geocity where city='Antimony' limit 1DB:business_master_new
loadtime:0.27868509292603 / seconds
Query stored in cache : _QUERY_www.toadli.com937b74e509626cfec8247e71dbaf4860
loadtime:0.27877497673035 / seconds
Query Executed:select id FROM `ut` where city='Antimony' && SIC_code='7219'DB:business_master_new
loadtime:0.30045008659363 / seconds
Query loaded from cache:select * from geodata_geocity where city='Aurora' limit 1
loadtime:0.30053997039795 / seconds
Query Executed:select id FROM `ut` where city='Aurora' && SIC_code='7219'DB:business_master_new
loadtime:0.30118918418884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Axtell' limit 1
loadtime:0.30125904083252 / seconds
Query Executed:select id FROM `ut` where city='Axtell' && SIC_code='7219'DB:business_master_new
loadtime:0.30445909500122 / seconds
Query Executed:select * from geodata_geocity where city='Bear River City' limit 1DB:business_master_new
loadtime:0.30508899688721 / seconds
Query stored in cache : _QUERY_www.toadli.comd65812e8734ec23414473f2bc291d9e4
loadtime:0.30517816543579 / seconds
Query Executed:select id FROM `ut` where city='Bear River City' && SIC_code='7219'DB:business_master_new
loadtime:0.30579805374146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Beaver' limit 1
loadtime:0.30592799186707 / seconds
Query Executed:select id FROM `ut` where city='Beaver' && SIC_code='7219'DB:business_master_new
loadtime:0.30690002441406 / seconds
Query Executed:select * from geodata_geocity where city='Beryl' limit 1DB:business_master_new
loadtime:0.30751609802246 / seconds
Query stored in cache : _QUERY_www.toadli.com077ffa730e00fc3728811c59f0d0a5ff
loadtime:0.30767512321472 / seconds
Query Executed:select id FROM `ut` where city='Beryl' && SIC_code='7219'DB:business_master_new
loadtime:0.30826711654663 / seconds
Query loaded from cache:select * from geodata_geocity where city='Bicknell' limit 1
loadtime:0.30834197998047 / seconds
Query Executed:select id FROM `ut` where city='Bicknell' && SIC_code='7219'DB:business_master_new
loadtime:0.30887603759766 / seconds
Query Executed:select * from geodata_geocity where city='Big Water' limit 1DB:business_master_new
loadtime:0.3094961643219 / seconds
Query stored in cache : _QUERY_www.toadli.comc689a8379428fc41218ddc12a4d2c700
loadtime:0.30958795547485 / seconds
Query Executed:select id FROM `ut` where city='Big Water' && SIC_code='7219'DB:business_master_new
loadtime:0.31342816352844 / seconds
Query Executed:select * from geodata_geocity where city='Bingham Canyon' limit 1DB:business_master_new
loadtime:0.31373500823975 / seconds
Query stored in cache : _QUERY_www.toadli.com89913b34b83ca4e7e906ecfd67a36705
loadtime:0.31376910209656 / seconds
Query Executed:select id FROM `ut` where city='Bingham Canyon' && SIC_code='7219'DB:business_master_new
loadtime:0.31451511383057 / seconds
Query Executed:select * from geodata_geocity where city='Blanding' limit 1DB:business_master_new
loadtime:0.31500697135925 / seconds
Query stored in cache : _QUERY_www.toadli.com14043ba2ba6ebcc90c124095c6d1d897
loadtime:0.31507515907288 / seconds
Query Executed:select id FROM `ut` where city='Blanding' && SIC_code='7219'DB:business_master_new
loadtime:0.31592202186584 / seconds
Query Executed:select * from geodata_geocity where city='Bluebell' limit 1DB:business_master_new
loadtime:0.31643199920654 / seconds
Query stored in cache : _QUERY_www.toadli.comf7902febe25544e31fbe77b7f9a84422
loadtime:0.31646800041199 / seconds
Query Executed:select id FROM `ut` where city='Bluebell' && SIC_code='7219'DB:business_master_new
loadtime:0.32457304000854 / seconds
Query Executed:select * from geodata_geocity where city='Bluff' limit 1DB:business_master_new
loadtime:0.3251039981842 / seconds
Query stored in cache : _QUERY_www.toadli.come16df2b328c8f4f96cb2d70e86b891d8
loadtime:0.32518911361694 / seconds
Query Executed:select id FROM `ut` where city='Bluff' && SIC_code='7219'DB:business_master_new
loadtime:0.32581114768982 / seconds
Query Executed:select * from geodata_geocity where city='Bonanza' limit 1DB:business_master_new
loadtime:0.32637405395508 / seconds
Query stored in cache : _QUERY_www.toadli.comd5aff4579117526b2e83e78aebb70d06
loadtime:0.32642412185669 / seconds
Query Executed:select id FROM `ut` where city='Bonanza' && SIC_code='7219'DB:business_master_new
loadtime:0.3269670009613 / seconds
Query loaded from cache:select * from geodata_geocity where city='Boulder' limit 1
loadtime:0.32701706886292 / seconds
Query Executed:select id FROM `ut` where city='Boulder' && SIC_code='7219'DB:business_master_new
loadtime:0.32740998268127 / seconds
Query Executed:select * from geodata_geocity where city='Bountiful' limit 1DB:business_master_new
loadtime:0.3276960849762 / seconds
Query stored in cache : _QUERY_www.toadli.com90f06aafaa5622fc0b315cbfb1c212ce
loadtime:0.32774209976196 / seconds
Query Executed:select id FROM `ut` where city='Bountiful' && SIC_code='7219'DB:business_master_new
loadtime:0.32863998413086 / seconds
Query Executed:select * from geodata_geocity where city='Brian Head' limit 1DB:business_master_new
loadtime:0.32892918586731 / seconds
Query stored in cache : _QUERY_www.toadli.com2d07d5ae32587ae7cbe6615e2bb3673e
loadtime:0.32897400856018 / seconds
Query Executed:select id FROM `ut` where city='Brian Head' && SIC_code='7219'DB:business_master_new
loadtime:0.3293571472168 / seconds
Query Executed:select * from geodata_geocity where city='Bridgeland' limit 1DB:business_master_new
loadtime:0.32964301109314 / seconds
Query stored in cache : _QUERY_www.toadli.com13f2cb99e681ed7ea7056e1f48ae0d59
loadtime:0.32968401908875 / seconds
Query Executed:select id FROM `ut` where city='Bridgeland' && SIC_code='7219'DB:business_master_new
loadtime:0.34581017494202 / seconds
Query Executed:select * from geodata_geocity where city='Brigham City' limit 1DB:business_master_new
loadtime:0.34630417823792 / seconds
Query stored in cache : _QUERY_www.toadli.comb7e269f44c3dd7b99dc4940c5eaf0108
loadtime:0.34638118743896 / seconds
Query Executed:select id FROM `ut` where city='Brigham City' && SIC_code='7219'DB:business_master_new
loadtime:0.34745812416077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Brighton' limit 1
loadtime:0.34753704071045 / seconds
Query Executed:select id FROM `ut` where city='Brighton' && SIC_code='7219'DB:business_master_new
loadtime:0.34928512573242 / seconds
Query Executed:select * from geodata_geocity where city='Bryce' limit 1DB:business_master_new
loadtime:0.34968614578247 / seconds
Query stored in cache : _QUERY_www.toadli.com48426b2e47e0564a4fe9b474e3c91e30
loadtime:0.34973096847534 / seconds
Query Executed:select id FROM `ut` where city='Bryce' && SIC_code='7219'DB:business_master_new
loadtime:0.37288117408752 / seconds
Query Executed:select * from geodata_geocity where city='Bryce Canyon' limit 1DB:business_master_new
loadtime:0.37329602241516 / seconds
Query stored in cache : _QUERY_www.toadli.com9a941c37cd9a4bf0afe14852de1a1224
loadtime:0.37337398529053 / seconds
Query Executed:select id FROM `ut` where city='Bryce Canyon' && SIC_code='7219'DB:business_master_new
loadtime:0.37824106216431 / seconds
Query Executed:select * from geodata_geocity where city='Cache Junction' limit 1DB:business_master_new
loadtime:0.37883305549622 / seconds
Query stored in cache : _QUERY_www.toadli.comef83079c05b1daa3cef23f43e259853c
loadtime:0.37893509864807 / seconds
Query Executed:select id FROM `ut` where city='Cache Junction' && SIC_code='7219'DB:business_master_new
loadtime:0.3804919719696 / seconds
Query Executed:select * from geodata_geocity where city='Cannonville' limit 1DB:business_master_new
loadtime:0.3809289932251 / seconds
Query stored in cache : _QUERY_www.toadli.com77eed64d51b78f29b31d8a1b0422ba9f
loadtime:0.38100504875183 / seconds
Query Executed:select id FROM `ut` where city='Cannonville' && SIC_code='7219'DB:business_master_new
loadtime:0.41296815872192 / seconds
Query Executed:select * from geodata_geocity where city='Castle Dale' limit 1DB:business_master_new
loadtime:0.41336917877197 / seconds
Query stored in cache : _QUERY_www.toadli.com36c2f254cb412b7f55b9ddca9459bb69
loadtime:0.41340613365173 / seconds
Query Executed:select id FROM `ut` where city='Castle Dale' && SIC_code='7219'DB:business_master_new
loadtime:0.41426205635071 / seconds
Query Executed:select * from geodata_geocity where city='Cedar City' limit 1DB:business_master_new
loadtime:0.41472697257996 / seconds
Query stored in cache : _QUERY_www.toadli.com37c2c574813e6f945b8ebb55b06b2cc7
loadtime:0.41477203369141 / seconds
Query Executed:select id FROM `ut` where city='Cedar City' && SIC_code='7219'DB:business_master_new
loadtime:0.41588497161865 / seconds
Query Executed:select * from geodata_geocity where city='Cedar Valley' limit 1DB:business_master_new
loadtime:0.4162859916687 / seconds
Query stored in cache : _QUERY_www.toadli.com6a4030daad83f5c06989fd0e8a2a7a7c
loadtime:0.41634798049927 / seconds
Query Executed:select id FROM `ut` where city='Cedar Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.41698312759399 / seconds
Query Executed:select * from geodata_geocity where city='Centerfield' limit 1DB:business_master_new
loadtime:0.41749405860901 / seconds
Query stored in cache : _QUERY_www.toadli.com35967666d132de5fc748da438fc3233a
loadtime:0.41754603385925 / seconds
Query Executed:select id FROM `ut` where city='Centerfield' && SIC_code='7219'DB:business_master_new
loadtime:0.41812896728516 / seconds
Query loaded from cache:select * from geodata_geocity where city='Centerville' limit 1
loadtime:0.41820001602173 / seconds
Query Executed:select id FROM `ut` where city='Centerville' && SIC_code='7219'DB:business_master_new
loadtime:0.41949105262756 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central' limit 1
loadtime:0.4195830821991 / seconds
Query Executed:select id FROM `ut` where city='Central' && SIC_code='7219'DB:business_master_new
loadtime:0.4233980178833 / seconds
Query loaded from cache:select * from geodata_geocity where city='Central Valley' limit 1
loadtime:0.42345404624939 / seconds
Query Executed:select id FROM `ut` where city='Central Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.42481207847595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Chester' limit 1
loadtime:0.42486119270325 / seconds
Query Executed:select id FROM `ut` where city='Chester' && SIC_code='7219'DB:business_master_new
loadtime:0.42931818962097 / seconds
Query loaded from cache:select * from geodata_geocity where city='Circleville' limit 1
loadtime:0.429368019104 / seconds
Query Executed:select id FROM `ut` where city='Circleville' && SIC_code='7219'DB:business_master_new
loadtime:0.42997717857361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cisco' limit 1
loadtime:0.43003606796265 / seconds
Query Executed:select id FROM `ut` where city='Cisco' && SIC_code='7219'DB:business_master_new
loadtime:0.43098902702332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clarkston' limit 1
loadtime:0.43105506896973 / seconds
Query Executed:select id FROM `ut` where city='Clarkston' && SIC_code='7219'DB:business_master_new
loadtime:0.43868613243103 / seconds
Query Executed:select * from geodata_geocity where city='Clawson' limit 1DB:business_master_new
loadtime:0.43909811973572 / seconds
Query stored in cache : _QUERY_www.toadli.comc85bbd585233fd30fc1ba70aa26fe81f
loadtime:0.43914413452148 / seconds
Query Executed:select id FROM `ut` where city='Clawson' && SIC_code='7219'DB:business_master_new
loadtime:0.46471905708313 / seconds
Query loaded from cache:select * from geodata_geocity where city='Clearfield' limit 1
loadtime:0.46476912498474 / seconds
Query Executed:select id FROM `ut` where city='Clearfield' && SIC_code='7219'DB:business_master_new
loadtime:0.46559596061707 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cleveland' limit 1
loadtime:0.46568703651428 / seconds
Query Executed:select id FROM `ut` where city='Cleveland' && SIC_code='7219'DB:business_master_new
loadtime:0.46609210968018 / seconds
Query Executed:select * from geodata_geocity where city='Coalville' limit 1DB:business_master_new
loadtime:0.46651816368103 / seconds
Query stored in cache : _QUERY_www.toadli.com42d23d4a45cc5b43dc687a83812bf746
loadtime:0.46659302711487 / seconds
Query Executed:select id FROM `ut` where city='Coalville' && SIC_code='7219'DB:business_master_new
loadtime:0.46710705757141 / seconds
Query Executed:select * from geodata_geocity where city='Collinston' limit 1DB:business_master_new
loadtime:0.46738219261169 / seconds
Query stored in cache : _QUERY_www.toadli.com3af8fb99394388c2f6783db77e619aee
loadtime:0.46742701530457 / seconds
Query Executed:select id FROM `ut` where city='Collinston' && SIC_code='7219'DB:business_master_new
loadtime:0.47320604324341 / seconds
Query Executed:select * from geodata_geocity where city='Corinne' limit 1DB:business_master_new
loadtime:0.47350907325745 / seconds
Query stored in cache : _QUERY_www.toadli.com3cc751e4bf2aff0305ad7c9ce56f5429
loadtime:0.47354316711426 / seconds
Query Executed:select id FROM `ut` where city='Corinne' && SIC_code='7219'DB:business_master_new
loadtime:0.47392702102661 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cornish' limit 1
loadtime:0.47397208213806 / seconds
Query Executed:select id FROM `ut` where city='Cornish' && SIC_code='7219'DB:business_master_new
loadtime:0.47702598571777 / seconds
Query loaded from cache:select * from geodata_geocity where city='Cottonwood' limit 1
loadtime:0.47708511352539 / seconds
Query Executed:select id FROM `ut` where city='Cottonwood' && SIC_code='7219'DB:business_master_new
loadtime:0.47778296470642 / seconds
Query loaded from cache:select * from geodata_geocity where city='Croydon' limit 1
loadtime:0.47782897949219 / seconds
Query Executed:select id FROM `ut` where city='Croydon' && SIC_code='7219'DB:business_master_new
loadtime:0.48023104667664 / seconds
Query Executed:select * from geodata_geocity where city='Dammeron Valley' limit 1DB:business_master_new
loadtime:0.48085999488831 / seconds
Query stored in cache : _QUERY_www.toadli.com014f6734461ba1928038369ce2744ed7
loadtime:0.48093605041504 / seconds
Query Executed:select id FROM `ut` where city='Dammeron Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.48144817352295 / seconds
Query loaded from cache:select * from geodata_geocity where city='Delta' limit 1
loadtime:0.48153114318848 / seconds
Query Executed:select id FROM `ut` where city='Delta' && SIC_code='7219'DB:business_master_new
loadtime:0.48235702514648 / seconds
Query Executed:select * from geodata_geocity where city='Deweyville' limit 1DB:business_master_new
loadtime:0.48290300369263 / seconds
Query stored in cache : _QUERY_www.toadli.comb17e8357af292acbfa57be5cceb690bf
loadtime:0.48296809196472 / seconds
Query Executed:select id FROM `ut` where city='Deweyville' && SIC_code='7219'DB:business_master_new
loadtime:0.48885798454285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Draper' limit 1
loadtime:0.48890805244446 / seconds
Query Executed:select id FROM `ut` where city='Draper' && SIC_code='7219'DB:business_master_new
loadtime:0.48971009254456 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duchesne' limit 1
loadtime:0.48984313011169 / seconds
Query Executed:select id FROM `ut` where city='Duchesne' && SIC_code='7219'DB:business_master_new
loadtime:0.49070405960083 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village' limit 1
loadtime:0.49079918861389 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village' && SIC_code='7219'DB:business_master_new
loadtime:0.49151706695557 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Village Cpu' limit 1
loadtime:0.49163603782654 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Village Cpu' && SIC_code='7219'DB:business_master_new
loadtime:0.4919331073761 / seconds
Query loaded from cache:select * from geodata_geocity where city='Duck Creek Vlg' limit 1
loadtime:0.49197816848755 / seconds
Query Executed:select id FROM `ut` where city='Duck Creek Vlg' && SIC_code='7219'DB:business_master_new
loadtime:0.49318218231201 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dugway' limit 1
loadtime:0.49322915077209 / seconds
Query Executed:select id FROM `ut` where city='Dugway' && SIC_code='7219'DB:business_master_new
loadtime:0.49383902549744 / seconds
Query loaded from cache:select * from geodata_geocity where city='Dutch John' limit 1
loadtime:0.49397397041321 / seconds
Query Executed:select id FROM `ut` where city='Dutch John' && SIC_code='7219'DB:business_master_new
loadtime:0.49433898925781 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eagle Mountain' limit 1
loadtime:0.49437308311462 / seconds
Query Executed:select id FROM `ut` where city='Eagle Mountain' && SIC_code='7219'DB:business_master_new
loadtime:0.4951810836792 / seconds
Query loaded from cache:select * from geodata_geocity where city='East Carbon' limit 1
loadtime:0.49526119232178 / seconds
Query Executed:select id FROM `ut` where city='East Carbon' && SIC_code='7219'DB:business_master_new
loadtime:0.49572396278381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Echo' limit 1
loadtime:0.49575901031494 / seconds
Query Executed:select id FROM `ut` where city='Echo' && SIC_code='7219'DB:business_master_new
loadtime:0.49803113937378 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eden' limit 1
loadtime:0.4980890750885 / seconds
Query Executed:select id FROM `ut` where city='Eden' && SIC_code='7219'DB:business_master_new
loadtime:0.49883317947388 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elberta' limit 1
loadtime:0.49892807006836 / seconds
Query Executed:select id FROM `ut` where city='Elberta' && SIC_code='7219'DB:business_master_new
loadtime:0.49958109855652 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elmo' limit 1
loadtime:0.4996280670166 / seconds
Query Executed:select id FROM `ut` where city='Elmo' && SIC_code='7219'DB:business_master_new
loadtime:0.50009107589722 / seconds
Query loaded from cache:select * from geodata_geocity where city='Elsinore' limit 1
loadtime:0.5001380443573 / seconds
Query Executed:select id FROM `ut` where city='Elsinore' && SIC_code='7219'DB:business_master_new
loadtime:0.50078415870667 / seconds
Query loaded from cache:select * from geodata_geocity where city='Emery' limit 1
loadtime:0.50083303451538 / seconds
Query Executed:select id FROM `ut` where city='Emery' && SIC_code='7219'DB:business_master_new
loadtime:0.50128698348999 / seconds
Query loaded from cache:select * from geodata_geocity where city='Enterprise' limit 1
loadtime:0.5013530254364 / seconds
Query Executed:select id FROM `ut` where city='Enterprise' && SIC_code='7219'DB:business_master_new
loadtime:0.50193214416504 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ephraim' limit 1
loadtime:0.50199198722839 / seconds
Query Executed:select id FROM `ut` where city='Ephraim' && SIC_code='7219'DB:business_master_new
loadtime:0.50275301933289 / seconds
Query loaded from cache:select * from geodata_geocity where city='Escalante' limit 1
loadtime:0.50288414955139 / seconds
Query Executed:select id FROM `ut` where city='Escalante' && SIC_code='7219'DB:business_master_new
loadtime:0.50369906425476 / seconds
Query loaded from cache:select * from geodata_geocity where city='Eureka' limit 1
loadtime:0.50375199317932 / seconds
Query Executed:select id FROM `ut` where city='Eureka' && SIC_code='7219'DB:business_master_new
loadtime:0.50424909591675 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fairview' limit 1
loadtime:0.50428915023804 / seconds
Query Executed:select id FROM `ut` where city='Fairview' && SIC_code='7219'DB:business_master_new
loadtime:0.50502705574036 / seconds
Query loaded from cache:select * from geodata_geocity where city='Farmington' limit 1
loadtime:0.50507497787476 / seconds
Query Executed:select id FROM `ut` where city='Farmington' && SIC_code='7219'DB:business_master_new
loadtime:0.5059289932251 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fayette' limit 1
loadtime:0.50601315498352 / seconds
Query Executed:select id FROM `ut` where city='Fayette' && SIC_code='7219'DB:business_master_new
loadtime:0.51054310798645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ferron' limit 1
loadtime:0.51057815551758 / seconds
Query Executed:select id FROM `ut` where city='Ferron' && SIC_code='7219'DB:business_master_new
loadtime:0.51141810417175 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fielding' limit 1
loadtime:0.51149797439575 / seconds
Query Executed:select id FROM `ut` where city='Fielding' && SIC_code='7219'DB:business_master_new
loadtime:0.51206707954407 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fillmore' limit 1
loadtime:0.51212906837463 / seconds
Query Executed:select id FROM `ut` where city='Fillmore' && SIC_code='7219'DB:business_master_new
loadtime:0.51298499107361 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fort Duchesne' limit 1
loadtime:0.51307702064514 / seconds
Query Executed:select id FROM `ut` where city='Fort Duchesne' && SIC_code='7219'DB:business_master_new
loadtime:0.51391196250916 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fountain Green' limit 1
loadtime:0.51399302482605 / seconds
Query Executed:select id FROM `ut` where city='Fountain Green' && SIC_code='7219'DB:business_master_new
loadtime:0.51442003250122 / seconds
Query loaded from cache:select * from geodata_geocity where city='Fruitland' limit 1
loadtime:0.51445603370667 / seconds
Query Executed:select id FROM `ut` where city='Fruitland' && SIC_code='7219'DB:business_master_new
loadtime:0.51479196548462 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garden City' limit 1
loadtime:0.51483798027039 / seconds
Query Executed:select id FROM `ut` where city='Garden City' && SIC_code='7219'DB:business_master_new
loadtime:0.51534605026245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garland' limit 1
loadtime:0.5153820514679 / seconds
Query Executed:select id FROM `ut` where city='Garland' && SIC_code='7219'DB:business_master_new
loadtime:0.51587605476379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Garrison' limit 1
loadtime:0.51592111587524 / seconds
Query Executed:select id FROM `ut` where city='Garrison' && SIC_code='7219'DB:business_master_new
loadtime:0.52243208885193 / seconds
Query loaded from cache:select * from geodata_geocity where city='Genola' limit 1
loadtime:0.52246618270874 / seconds
Query Executed:select id FROM `ut` where city='Genola' && SIC_code='7219'DB:business_master_new
loadtime:0.52314400672913 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glendale' limit 1
loadtime:0.52319002151489 / seconds
Query Executed:select id FROM `ut` where city='Glendale' && SIC_code='7219'DB:business_master_new
loadtime:0.5235550403595 / seconds
Query loaded from cache:select * from geodata_geocity where city='Glenwood' limit 1
loadtime:0.52359700202942 / seconds
Query Executed:select id FROM `ut` where city='Glenwood' && SIC_code='7219'DB:business_master_new
loadtime:0.5286591053009 / seconds
Query loaded from cache:select * from geodata_geocity where city='Goshen' limit 1
loadtime:0.52869415283203 / seconds
Query Executed:select id FROM `ut` where city='Goshen' && SIC_code='7219'DB:business_master_new
loadtime:0.52905917167664 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grantsville' limit 1
loadtime:0.5290961265564 / seconds
Query Executed:select id FROM `ut` where city='Grantsville' && SIC_code='7219'DB:business_master_new
loadtime:0.52958917617798 / seconds
Query loaded from cache:select * from geodata_geocity where city='Green River' limit 1
loadtime:0.52962303161621 / seconds
Query Executed:select id FROM `ut` where city='Green River' && SIC_code='7219'DB:business_master_new
loadtime:0.53009510040283 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenville' limit 1
loadtime:0.53013396263123 / seconds
Query Executed:select id FROM `ut` where city='Greenville' && SIC_code='7219'DB:business_master_new
loadtime:0.53069400787354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Greenwich' limit 1
loadtime:0.53073000907898 / seconds
Query Executed:select id FROM `ut` where city='Greenwich' && SIC_code='7219'DB:business_master_new
loadtime:0.53152799606323 / seconds
Query loaded from cache:select * from geodata_geocity where city='Grouse Creek' limit 1
loadtime:0.53157615661621 / seconds
Query Executed:select id FROM `ut` where city='Grouse Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.53284597396851 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunlock' limit 1
loadtime:0.53288102149963 / seconds
Query Executed:select id FROM `ut` where city='Gunlock' && SIC_code='7219'DB:business_master_new
loadtime:0.53408813476562 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gunnison' limit 1
loadtime:0.53413510322571 / seconds
Query Executed:select id FROM `ut` where city='Gunnison' && SIC_code='7219'DB:business_master_new
loadtime:0.53463006019592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Gusher' limit 1
loadtime:0.53467512130737 / seconds
Query Executed:select id FROM `ut` where city='Gusher' && SIC_code='7219'DB:business_master_new
loadtime:0.53519701957703 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanksville' limit 1
loadtime:0.53522515296936 / seconds
Query Executed:select id FROM `ut` where city='Hanksville' && SIC_code='7219'DB:business_master_new
loadtime:0.53558611869812 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hanna' limit 1
loadtime:0.53563404083252 / seconds
Query Executed:select id FROM `ut` where city='Hanna' && SIC_code='7219'DB:business_master_new
loadtime:0.53958916664124 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hatch' limit 1
loadtime:0.53962516784668 / seconds
Query Executed:select id FROM `ut` where city='Hatch' && SIC_code='7219'DB:business_master_new
loadtime:0.53995299339294 / seconds
Query loaded from cache:select * from geodata_geocity where city='Heber City' limit 1
loadtime:0.53999304771423 / seconds
Query Executed:select id FROM `ut` where city='Heber City' && SIC_code='7219'DB:business_master_new
loadtime:0.54051399230957 / seconds
Query loaded from cache:select * from geodata_geocity where city='Helper' limit 1
loadtime:0.5405490398407 / seconds
Query Executed:select id FROM `ut` where city='Helper' && SIC_code='7219'DB:business_master_new
loadtime:0.54103112220764 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henefer' limit 1
loadtime:0.54108309745789 / seconds
Query Executed:select id FROM `ut` where city='Henefer' && SIC_code='7219'DB:business_master_new
loadtime:0.541424036026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Henrieville' limit 1
loadtime:0.54146909713745 / seconds
Query Executed:select id FROM `ut` where city='Henrieville' && SIC_code='7219'DB:business_master_new
loadtime:0.54421710968018 / seconds
Query loaded from cache:select * from geodata_geocity where city='Herriman' limit 1
loadtime:0.5442521572113 / seconds
Query Executed:select id FROM `ut` where city='Herriman' && SIC_code='7219'DB:business_master_new
loadtime:0.54476618766785 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hiawatha' limit 1
loadtime:0.54481196403503 / seconds
Query Executed:select id FROM `ut` where city='Hiawatha' && SIC_code='7219'DB:business_master_new
loadtime:0.54535818099976 / seconds
Query loaded from cache:select * from geodata_geocity where city='Highland' limit 1
loadtime:0.5453929901123 / seconds
Query Executed:select id FROM `ut` where city='Highland' && SIC_code='7219'DB:business_master_new
loadtime:0.54888701438904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hildale' limit 1
loadtime:0.54893398284912 / seconds
Query Executed:select id FROM `ut` where city='Hildale' && SIC_code='7219'DB:business_master_new
loadtime:0.54945802688599 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Afb' limit 1
loadtime:0.54949307441711 / seconds
Query Executed:select id FROM `ut` where city='Hill Afb' && SIC_code='7219'DB:business_master_new
loadtime:0.54998207092285 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hill Air Force Base' limit 1
loadtime:0.55002903938293 / seconds
Query Executed:select id FROM `ut` where city='Hill Air Force Base' && SIC_code='7219'DB:business_master_new
loadtime:0.55214214324951 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hinckley' limit 1
loadtime:0.55217814445496 / seconds
Query Executed:select id FROM `ut` where city='Hinckley' && SIC_code='7219'DB:business_master_new
loadtime:0.5525381565094 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hite' limit 1
loadtime:0.5525860786438 / seconds
Query Executed:select id FROM `ut` where city='Hite' && SIC_code='7219'DB:business_master_new
loadtime:0.55282306671143 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holden' limit 1
loadtime:0.55285811424255 / seconds
Query Executed:select id FROM `ut` where city='Holden' && SIC_code='7219'DB:business_master_new
loadtime:0.55317807197571 / seconds
Query loaded from cache:select * from geodata_geocity where city='Holladay' limit 1
loadtime:0.55320310592651 / seconds
Query Executed:select id FROM `ut` where city='Holladay' && SIC_code='7219'DB:business_master_new
loadtime:0.55354309082031 / seconds
Query loaded from cache:select * from geodata_geocity where city='Honeyville' limit 1
loadtime:0.55359196662903 / seconds
Query Executed:select id FROM `ut` where city='Honeyville' && SIC_code='7219'DB:business_master_new
loadtime:0.55392599105835 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hooper' limit 1
loadtime:0.55395197868347 / seconds
Query Executed:select id FROM `ut` where city='Hooper' && SIC_code='7219'DB:business_master_new
loadtime:0.55446004867554 / seconds
Query loaded from cache:select * from geodata_geocity where city='Howell' limit 1
loadtime:0.55450916290283 / seconds
Query Executed:select id FROM `ut` where city='Howell' && SIC_code='7219'DB:business_master_new
loadtime:0.55823802947998 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntington' limit 1
loadtime:0.55827307701111 / seconds
Query Executed:select id FROM `ut` where city='Huntington' && SIC_code='7219'DB:business_master_new
loadtime:0.5587739944458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Huntsville' limit 1
loadtime:0.55882215499878 / seconds
Query Executed:select id FROM `ut` where city='Huntsville' && SIC_code='7219'DB:business_master_new
loadtime:0.55933499336243 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hurricane' limit 1
loadtime:0.55937004089355 / seconds
Query Executed:select id FROM `ut` where city='Hurricane' && SIC_code='7219'DB:business_master_new
loadtime:0.5598680973053 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyde Park' limit 1
loadtime:0.55991697311401 / seconds
Query Executed:select id FROM `ut` where city='Hyde Park' && SIC_code='7219'DB:business_master_new
loadtime:0.56043815612793 / seconds
Query loaded from cache:select * from geodata_geocity where city='Hyrum' limit 1
loadtime:0.56048607826233 / seconds
Query Executed:select id FROM `ut` where city='Hyrum' && SIC_code='7219'DB:business_master_new
loadtime:0.5609769821167 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ibapah' limit 1
loadtime:0.56100416183472 / seconds
Query Executed:select id FROM `ut` where city='Ibapah' && SIC_code='7219'DB:business_master_new
loadtime:0.56655311584473 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ivins' limit 1
loadtime:0.56659913063049 / seconds
Query Executed:select id FROM `ut` where city='Ivins' && SIC_code='7219'DB:business_master_new
loadtime:0.56708908081055 / seconds
Query loaded from cache:select * from geodata_geocity where city='Jensen' limit 1
loadtime:0.5671169757843 / seconds
Query Executed:select id FROM `ut` where city='Jensen' && SIC_code='7219'DB:business_master_new
loadtime:0.56747317314148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Joseph' limit 1
loadtime:0.56752109527588 / seconds
Query Executed:select id FROM `ut` where city='Joseph' && SIC_code='7219'DB:business_master_new
loadtime:0.57323813438416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Junction' limit 1
loadtime:0.57327318191528 / seconds
Query Executed:select id FROM `ut` where city='Junction' && SIC_code='7219'DB:business_master_new
loadtime:0.57365012168884 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kamas' limit 1
loadtime:0.57369804382324 / seconds
Query Executed:select id FROM `ut` where city='Kamas' && SIC_code='7219'DB:business_master_new
loadtime:0.5741810798645 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanab' limit 1
loadtime:0.57421803474426 / seconds
Query Executed:select id FROM `ut` where city='Kanab' && SIC_code='7219'DB:business_master_new
loadtime:0.57471609115601 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanarraville' limit 1
loadtime:0.57475113868713 / seconds
Query Executed:select id FROM `ut` where city='Kanarraville' && SIC_code='7219'DB:business_master_new
loadtime:0.57508897781372 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kanosh' limit 1
loadtime:0.57513117790222 / seconds
Query Executed:select id FROM `ut` where city='Kanosh' && SIC_code='7219'DB:business_master_new
loadtime:0.57548308372498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kaysville' limit 1
loadtime:0.57551908493042 / seconds
Query Executed:select id FROM `ut` where city='Kaysville' && SIC_code='7219'DB:business_master_new
loadtime:0.57601118087769 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kearns' limit 1
loadtime:0.57606911659241 / seconds
Query Executed:select id FROM `ut` where city='Kearns' && SIC_code='7219'DB:business_master_new
loadtime:0.5765700340271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kenilworth' limit 1
loadtime:0.57660603523254 / seconds
Query Executed:select id FROM `ut` where city='Kenilworth' && SIC_code='7219'DB:business_master_new
loadtime:0.57721710205078 / seconds
Query loaded from cache:select * from geodata_geocity where city='Kingston' limit 1
loadtime:0.57725715637207 / seconds
Query Executed:select id FROM `ut` where city='Kingston' && SIC_code='7219'DB:business_master_new
loadtime:0.58069205284119 / seconds
Query loaded from cache:select * from geodata_geocity where city='Koosharem' limit 1
loadtime:0.58072710037231 / seconds
Query Executed:select id FROM `ut` where city='Koosharem' && SIC_code='7219'DB:business_master_new
loadtime:0.58102703094482 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Sal' limit 1
loadtime:0.58107614517212 / seconds
Query Executed:select id FROM `ut` where city='La Sal' && SIC_code='7219'DB:business_master_new
loadtime:0.58141398429871 / seconds
Query loaded from cache:select * from geodata_geocity where city='La Verkin' limit 1
loadtime:0.58145904541016 / seconds
Query Executed:select id FROM `ut` where city='La Verkin' && SIC_code='7219'DB:business_master_new
loadtime:0.58193898200989 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lake Powell' limit 1
loadtime:0.58196496963501 / seconds
Query Executed:select id FROM `ut` where city='Lake Powell' && SIC_code='7219'DB:business_master_new
loadtime:0.58232808113098 / seconds
Query loaded from cache:select * from geodata_geocity where city='Laketown' limit 1
loadtime:0.58237600326538 / seconds
Query Executed:select id FROM `ut` where city='Laketown' && SIC_code='7219'DB:business_master_new
loadtime:0.58274602890015 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lapoint' limit 1
loadtime:0.58278107643127 / seconds
Query Executed:select id FROM `ut` where city='Lapoint' && SIC_code='7219'DB:business_master_new
loadtime:0.58309698104858 / seconds
Query loaded from cache:select * from geodata_geocity where city='Layton' limit 1
loadtime:0.58313608169556 / seconds
Query Executed:select id FROM `ut` where city='Layton' && SIC_code='7219'DB:business_master_new
loadtime:0.58363008499146 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leamington' limit 1
loadtime:0.58367300033569 / seconds
Query Executed:select id FROM `ut` where city='Leamington' && SIC_code='7219'DB:business_master_new
loadtime:0.58785009384155 / seconds
Query loaded from cache:select * from geodata_geocity where city='Leeds' limit 1
loadtime:0.58789706230164 / seconds
Query Executed:select id FROM `ut` where city='Leeds' && SIC_code='7219'DB:business_master_new
loadtime:0.58822798728943 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lehi' limit 1
loadtime:0.58825516700745 / seconds
Query Executed:select id FROM `ut` where city='Lehi' && SIC_code='7219'DB:business_master_new
loadtime:0.58875513076782 / seconds
Query loaded from cache:select * from geodata_geocity where city='Levan' limit 1
loadtime:0.58880209922791 / seconds
Query Executed:select id FROM `ut` where city='Levan' && SIC_code='7219'DB:business_master_new
loadtime:0.58912110328674 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lewiston' limit 1
loadtime:0.5891580581665 / seconds
Query Executed:select id FROM `ut` where city='Lewiston' && SIC_code='7219'DB:business_master_new
loadtime:0.58964896202087 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lindon' limit 1
loadtime:0.58968496322632 / seconds
Query Executed:select id FROM `ut` where city='Lindon' && SIC_code='7219'DB:business_master_new
loadtime:0.59015798568726 / seconds
Query loaded from cache:select * from geodata_geocity where city='Loa' limit 1
loadtime:0.59019708633423 / seconds
Query Executed:select id FROM `ut` where city='Loa' && SIC_code='7219'DB:business_master_new
loadtime:0.59052896499634 / seconds
Query loaded from cache:select * from geodata_geocity where city='Logan' limit 1
loadtime:0.59056401252747 / seconds
Query Executed:select id FROM `ut` where city='Logan' && SIC_code='7219'DB:business_master_new
loadtime:0.59105396270752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lyman' limit 1
loadtime:0.59110307693481 / seconds
Query Executed:select id FROM `ut` where city='Lyman' && SIC_code='7219'DB:business_master_new
loadtime:0.59475612640381 / seconds
Query loaded from cache:select * from geodata_geocity where city='Lynndyl' limit 1
loadtime:0.59479117393494 / seconds
Query Executed:select id FROM `ut` where city='Lynndyl' && SIC_code='7219'DB:business_master_new
loadtime:0.59803509712219 / seconds
Query loaded from cache:select * from geodata_geocity where city='Magna' limit 1
loadtime:0.59809613227844 / seconds
Query Executed:select id FROM `ut` where city='Magna' && SIC_code='7219'DB:business_master_new
loadtime:0.59879207611084 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manila' limit 1
loadtime:0.59889817237854 / seconds
Query Executed:select id FROM `ut` where city='Manila' && SIC_code='7219'DB:business_master_new
loadtime:0.59955811500549 / seconds
Query loaded from cache:select * from geodata_geocity where city='Manti' limit 1
loadtime:0.59963798522949 / seconds
Query Executed:select id FROM `ut` where city='Manti' && SIC_code='7219'DB:business_master_new
loadtime:0.60043597221375 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mantua' limit 1
loadtime:0.60050106048584 / seconds
Query Executed:select id FROM `ut` where city='Mantua' && SIC_code='7219'DB:business_master_new
loadtime:0.60108613967896 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mapleton' limit 1
loadtime:0.60113310813904 / seconds
Query Executed:select id FROM `ut` where city='Mapleton' && SIC_code='7219'DB:business_master_new
loadtime:0.60185503959656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Marysvale' limit 1
loadtime:0.60193705558777 / seconds
Query Executed:select id FROM `ut` where city='Marysvale' && SIC_code='7219'DB:business_master_new
loadtime:0.60254001617432 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mayfield' limit 1
loadtime:0.60260009765625 / seconds
Query Executed:select id FROM `ut` where city='Mayfield' && SIC_code='7219'DB:business_master_new
loadtime:0.60934209823608 / seconds
Query loaded from cache:select * from geodata_geocity where city='Meadow' limit 1
loadtime:0.6093909740448 / seconds
Query Executed:select id FROM `ut` where city='Meadow' && SIC_code='7219'DB:business_master_new
loadtime:0.61532711982727 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mendon' limit 1
loadtime:0.61536717414856 / seconds
Query Executed:select id FROM `ut` where city='Mendon' && SIC_code='7219'DB:business_master_new
loadtime:0.61591506004333 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mexican Hat' limit 1
loadtime:0.61596608161926 / seconds
Query Executed:select id FROM `ut` where city='Mexican Hat' && SIC_code='7219'DB:business_master_new
loadtime:0.62188100814819 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midvale' limit 1
loadtime:0.62192296981812 / seconds
Query Executed:select id FROM `ut` where city='Midvale' && SIC_code='7219'DB:business_master_new
loadtime:0.62246417999268 / seconds
Query loaded from cache:select * from geodata_geocity where city='Midway' limit 1
loadtime:0.62252497673035 / seconds
Query Executed:select id FROM `ut` where city='Midway' && SIC_code='7219'DB:business_master_new
loadtime:0.62303018569946 / seconds
Query loaded from cache:select * from geodata_geocity where city='Milford' limit 1
loadtime:0.62309217453003 / seconds
Query Executed:select id FROM `ut` where city='Milford' && SIC_code='7219'DB:business_master_new
loadtime:0.62388896942139 / seconds
Query loaded from cache:select * from geodata_geocity where city='Millville' limit 1
loadtime:0.62392497062683 / seconds
Query Executed:select id FROM `ut` where city='Millville' && SIC_code='7219'DB:business_master_new
loadtime:0.6244900226593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Minersville' limit 1
loadtime:0.6245391368866 / seconds
Query Executed:select id FROM `ut` where city='Minersville' && SIC_code='7219'DB:business_master_new
loadtime:0.62511610984802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moab' limit 1
loadtime:0.62517714500427 / seconds
Query Executed:select id FROM `ut` where city='Moab' && SIC_code='7219'DB:business_master_new
loadtime:0.62592196464539 / seconds
Query loaded from cache:select * from geodata_geocity where city='Modena' limit 1
loadtime:0.62600207328796 / seconds
Query Executed:select id FROM `ut` where city='Modena' && SIC_code='7219'DB:business_master_new
loadtime:0.62802004814148 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mona' limit 1
loadtime:0.62806701660156 / seconds
Query Executed:select id FROM `ut` where city='Mona' && SIC_code='7219'DB:business_master_new
loadtime:0.62859416007996 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monroe' limit 1
loadtime:0.62867116928101 / seconds
Query Executed:select id FROM `ut` where city='Monroe' && SIC_code='7219'DB:business_master_new
loadtime:0.62948703765869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Montezuma Creek' limit 1
loadtime:0.62953495979309 / seconds
Query Executed:select id FROM `ut` where city='Montezuma Creek' && SIC_code='7219'DB:business_master_new
loadtime:0.63011503219604 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monticello' limit 1
loadtime:0.63017702102661 / seconds
Query Executed:select id FROM `ut` where city='Monticello' && SIC_code='7219'DB:business_master_new
loadtime:0.63091516494751 / seconds
Query loaded from cache:select * from geodata_geocity where city='Monument Valley' limit 1
loadtime:0.63098311424255 / seconds
Query Executed:select id FROM `ut` where city='Monument Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.6315701007843 / seconds
Query loaded from cache:select * from geodata_geocity where city='Morgan' limit 1
loadtime:0.63163208961487 / seconds
Query Executed:select id FROM `ut` where city='Morgan' && SIC_code='7219'DB:business_master_new
loadtime:0.63232016563416 / seconds
Query loaded from cache:select * from geodata_geocity where city='Moroni' limit 1
loadtime:0.63240504264832 / seconds
Query Executed:select id FROM `ut` where city='Moroni' && SIC_code='7219'DB:business_master_new
loadtime:0.63311004638672 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Carmel' limit 1
loadtime:0.63317012786865 / seconds
Query Executed:select id FROM `ut` where city='Mount Carmel' && SIC_code='7219'DB:business_master_new
loadtime:0.63910603523254 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mount Pleasant' limit 1
loadtime:0.63915514945984 / seconds
Query Executed:select id FROM `ut` where city='Mount Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.63965606689453 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mountain Home' limit 1
loadtime:0.63969111442566 / seconds
Query Executed:select id FROM `ut` where city='Mountain Home' && SIC_code='7219'DB:business_master_new
loadtime:0.64514303207397 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Carmel' limit 1
loadtime:0.64519214630127 / seconds
Query Executed:select id FROM `ut` where city='Mt Carmel' && SIC_code='7219'DB:business_master_new
loadtime:0.64544296264648 / seconds
Query loaded from cache:select * from geodata_geocity where city='Mt Pleasant' limit 1
loadtime:0.64547610282898 / seconds
Query Executed:select id FROM `ut` where city='Mt Pleasant' && SIC_code='7219'DB:business_master_new
loadtime:0.65231800079346 / seconds
Query loaded from cache:select * from geodata_geocity where city='Murray' limit 1
loadtime:0.6523540019989 / seconds
Query Executed:select id FROM `ut` where city='Murray' && SIC_code='7219'DB:business_master_new
loadtime:0.65286803245544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Myton' limit 1
loadtime:0.65291714668274 / seconds
Query Executed:select id FROM `ut` where city='Myton' && SIC_code='7219'DB:business_master_new
loadtime:0.65326499938965 / seconds
Query loaded from cache:select * from geodata_geocity where city='Neola' limit 1
loadtime:0.65329217910767 / seconds
Query Executed:select id FROM `ut` where city='Neola' && SIC_code='7219'DB:business_master_new
loadtime:0.65363907814026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Nephi' limit 1
loadtime:0.65368819236755 / seconds
Query Executed:select id FROM `ut` where city='Nephi' && SIC_code='7219'DB:business_master_new
loadtime:0.65417504310608 / seconds
Query loaded from cache:select * from geodata_geocity where city='New Harmony' limit 1
loadtime:0.65420198440552 / seconds
Query Executed:select id FROM `ut` where city='New Harmony' && SIC_code='7219'DB:business_master_new
loadtime:0.65454816818237 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newcastle' limit 1
loadtime:0.65459609031677 / seconds
Query Executed:select id FROM `ut` where city='Newcastle' && SIC_code='7219'DB:business_master_new
loadtime:0.66052103042603 / seconds
Query loaded from cache:select * from geodata_geocity where city='Newton' limit 1
loadtime:0.66055798530579 / seconds
Query Executed:select id FROM `ut` where city='Newton' && SIC_code='7219'DB:business_master_new
loadtime:0.66092705726624 / seconds
Query loaded from cache:select * from geodata_geocity where city='North Salt Lake' limit 1
loadtime:0.66096806526184 / seconds
Query Executed:select id FROM `ut` where city='North Salt Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.66149806976318 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oak City' limit 1
loadtime:0.66154599189758 / seconds
Query Executed:select id FROM `ut` where city='Oak City' && SIC_code='7219'DB:business_master_new
loadtime:0.668781042099 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oakley' limit 1
loadtime:0.66881608963013 / seconds
Query Executed:select id FROM `ut` where city='Oakley' && SIC_code='7219'DB:business_master_new
loadtime:0.66933798789978 / seconds
Query loaded from cache:select * from geodata_geocity where city='Oasis' limit 1
loadtime:0.66938614845276 / seconds
Query Executed:select id FROM `ut` where city='Oasis' && SIC_code='7219'DB:business_master_new
loadtime:0.66962003707886 / seconds
Query loaded from cache:select * from geodata_geocity where city='Ogden' limit 1
loadtime:0.66964602470398 / seconds
Query Executed:select id FROM `ut` where city='Ogden' && SIC_code='7219'DB:business_master_new
loadtime:0.67011904716492 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orangeville' limit 1
loadtime:0.67016410827637 / seconds
Query Executed:select id FROM `ut` where city='Orangeville' && SIC_code='7219'DB:business_master_new
loadtime:0.67051815986633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orderville' limit 1
loadtime:0.67055296897888 / seconds
Query Executed:select id FROM `ut` where city='Orderville' && SIC_code='7219'DB:business_master_new
loadtime:0.67089414596558 / seconds
Query loaded from cache:select * from geodata_geocity where city='Orem' limit 1
loadtime:0.67092895507812 / seconds
Query Executed:select id FROM `ut` where city='Orem' && SIC_code='7219'DB:business_master_new
loadtime:0.6714551448822 / seconds
Query loaded from cache:select * from geodata_geocity where city='Panguitch' limit 1
loadtime:0.6715030670166 / seconds
Query Executed:select id FROM `ut` where city='Panguitch' && SIC_code='7219'DB:business_master_new
loadtime:0.67198300361633 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paradise' limit 1
loadtime:0.67202115058899 / seconds
Query Executed:select id FROM `ut` where city='Paradise' && SIC_code='7219'DB:business_master_new
loadtime:0.67236804962158 / seconds
Query loaded from cache:select * from geodata_geocity where city='Paragonah' limit 1
loadtime:0.6724259853363 / seconds
Query Executed:select id FROM `ut` where city='Paragonah' && SIC_code='7219'DB:business_master_new
loadtime:0.67867708206177 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park City' limit 1
loadtime:0.67871308326721 / seconds
Query Executed:select id FROM `ut` where city='Park City' && SIC_code='7219'DB:business_master_new
loadtime:0.67920804023743 / seconds
Query loaded from cache:select * from geodata_geocity where city='Park Valley' limit 1
loadtime:0.67925596237183 / seconds
Query Executed:select id FROM `ut` where city='Park Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.68125605583191 / seconds
Query loaded from cache:select * from geodata_geocity where city='Parowan' limit 1
loadtime:0.68129205703735 / seconds
Query Executed:select id FROM `ut` where city='Parowan' && SIC_code='7219'DB:business_master_new
loadtime:0.68179607391357 / seconds
Query loaded from cache:select * from geodata_geocity where city='Payson' limit 1
loadtime:0.68184399604797 / seconds
Query Executed:select id FROM `ut` where city='Payson' && SIC_code='7219'DB:business_master_new
loadtime:0.68235611915588 / seconds
Query loaded from cache:select * from geodata_geocity where city='Peoa' limit 1
loadtime:0.68239116668701 / seconds
Query Executed:select id FROM `ut` where city='Peoa' && SIC_code='7219'DB:business_master_new
loadtime:0.68274116516113 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pine Valley' limit 1
loadtime:0.68279004096985 / seconds
Query Executed:select id FROM `ut` where city='Pine Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.68450713157654 / seconds
Query loaded from cache:select * from geodata_geocity where city='Pleasant Grove' limit 1
loadtime:0.68455505371094 / seconds
Query Executed:select id FROM `ut` where city='Pleasant Grove' && SIC_code='7219'DB:business_master_new
loadtime:0.68506217002869 / seconds
Query loaded from cache:select * from geodata_geocity where city='Plymouth' limit 1
loadtime:0.68509817123413 / seconds
Query Executed:select id FROM `ut` where city='Plymouth' && SIC_code='7219'DB:business_master_new
loadtime:0.69389605522156 / seconds
Query loaded from cache:select * from geodata_geocity where city='Portage' limit 1
loadtime:0.69394302368164 / seconds
Query Executed:select id FROM `ut` where city='Portage' && SIC_code='7219'DB:business_master_new
loadtime:0.69771599769592 / seconds
Query loaded from cache:select * from geodata_geocity where city='Price' limit 1
loadtime:0.69775009155273 / seconds
Query Executed:select id FROM `ut` where city='Price' && SIC_code='7219'DB:business_master_new
loadtime:0.69823718070984 / seconds
Query loaded from cache:select * from geodata_geocity where city='Providence' limit 1
loadtime:0.69827699661255 / seconds
Query Executed:select id FROM `ut` where city='Providence' && SIC_code='7219'DB:business_master_new
loadtime:0.69877815246582 / seconds
Query loaded from cache:select * from geodata_geocity where city='Provo' limit 1
loadtime:0.69882106781006 / seconds
Query Executed:select id FROM `ut` where city='Provo' && SIC_code='7219'DB:business_master_new
loadtime:0.69936013221741 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randlett' limit 1
loadtime:0.69941711425781 / seconds
Query Executed:select id FROM `ut` where city='Randlett' && SIC_code='7219'DB:business_master_new
loadtime:0.70598411560059 / seconds
Query loaded from cache:select * from geodata_geocity where city='Randolph' limit 1
loadtime:0.70601916313171 / seconds
Query Executed:select id FROM `ut` where city='Randolph' && SIC_code='7219'DB:business_master_new
loadtime:0.70651698112488 / seconds
Query loaded from cache:select * from geodata_geocity where city='Redmond' limit 1
loadtime:0.70656418800354 / seconds
Query Executed:select id FROM `ut` where city='Redmond' && SIC_code='7219'DB:business_master_new
loadtime:0.70691418647766 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richfield' limit 1
loadtime:0.70694708824158 / seconds
Query Executed:select id FROM `ut` where city='Richfield' && SIC_code='7219'DB:business_master_new
loadtime:0.70746898651123 / seconds
Query loaded from cache:select * from geodata_geocity where city='Richmond' limit 1
loadtime:0.70750403404236 / seconds
Query Executed:select id FROM `ut` where city='Richmond' && SIC_code='7219'DB:business_master_new
loadtime:0.70798516273499 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverside' limit 1
loadtime:0.70802307128906 / seconds
Query Executed:select id FROM `ut` where city='Riverside' && SIC_code='7219'DB:business_master_new
loadtime:0.71486496925354 / seconds
Query loaded from cache:select * from geodata_geocity where city='Riverton' limit 1
loadtime:0.71490001678467 / seconds
Query Executed:select id FROM `ut` where city='Riverton' && SIC_code='7219'DB:business_master_new
loadtime:0.71541619300842 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rockville' limit 1
loadtime:0.71546196937561 / seconds
Query Executed:select id FROM `ut` where city='Rockville' && SIC_code='7219'DB:business_master_new
loadtime:0.71827101707458 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roosevelt' limit 1
loadtime:0.71830797195435 / seconds
Query Executed:select id FROM `ut` where city='Roosevelt' && SIC_code='7219'DB:business_master_new
loadtime:0.71880197525024 / seconds
Query loaded from cache:select * from geodata_geocity where city='Roy' limit 1
loadtime:0.71885108947754 / seconds
Query Executed:select id FROM `ut` where city='Roy' && SIC_code='7219'DB:business_master_new
loadtime:0.7193591594696 / seconds
Query loaded from cache:select * from geodata_geocity where city='Rush Valley' limit 1
loadtime:0.71939396858215 / seconds
Query Executed:select id FROM `ut` where city='Rush Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.72318506240845 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saint George' limit 1
loadtime:0.72323298454285 / seconds
Query Executed:select id FROM `ut` where city='Saint George' && SIC_code='7219'DB:business_master_new
loadtime:0.72373199462891 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salem' limit 1
loadtime:0.72378301620483 / seconds
Query Executed:select id FROM `ut` where city='Salem' && SIC_code='7219'DB:business_master_new
loadtime:0.72426104545593 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salina' limit 1
loadtime:0.72429704666138 / seconds
Query Executed:select id FROM `ut` where city='Salina' && SIC_code='7219'DB:business_master_new
loadtime:0.72479796409607 / seconds
Query loaded from cache:select * from geodata_geocity where city='Salt Lake City' limit 1
loadtime:0.72484612464905 / seconds
Query Executed:select id FROM `ut` where city='Salt Lake City' && SIC_code='7219'DB:business_master_new
loadtime:0.7253851890564 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sandy' limit 1
loadtime:0.72543215751648 / seconds
Query Executed:select id FROM `ut` where city='Sandy' && SIC_code='7219'DB:business_master_new
loadtime:0.72594809532166 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santa Clara' limit 1
loadtime:0.72600698471069 / seconds
Query Executed:select id FROM `ut` where city='Santa Clara' && SIC_code='7219'DB:business_master_new
loadtime:0.72652411460876 / seconds
Query loaded from cache:select * from geodata_geocity where city='Santaquin' limit 1
loadtime:0.72656011581421 / seconds
Query Executed:select id FROM `ut` where city='Santaquin' && SIC_code='7219'DB:business_master_new
loadtime:0.7270610332489 / seconds
Query loaded from cache:select * from geodata_geocity where city='Saratoga Springs' limit 1
loadtime:0.72709918022156 / seconds
Query Executed:select id FROM `ut` where city='Saratoga Springs' && SIC_code='7219'DB:business_master_new
loadtime:0.72759819030762 / seconds
Query loaded from cache:select * from geodata_geocity where city='Scipio' limit 1
loadtime:0.72763204574585 / seconds
Query Executed:select id FROM `ut` where city='Scipio' && SIC_code='7219'DB:business_master_new
loadtime:0.73269200325012 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sevier' limit 1
loadtime:0.73274111747742 / seconds
Query Executed:select id FROM `ut` where city='Sevier' && SIC_code='7219'DB:business_master_new
loadtime:0.73438811302185 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sigurd' limit 1
loadtime:0.73443412780762 / seconds
Query Executed:select id FROM `ut` where city='Sigurd' && SIC_code='7219'DB:business_master_new
loadtime:0.74150109291077 / seconds
Query loaded from cache:select * from geodata_geocity where city='Smithfield' limit 1
loadtime:0.74153614044189 / seconds
Query Executed:select id FROM `ut` where city='Smithfield' && SIC_code='7219'DB:business_master_new
loadtime:0.74201798439026 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowbird' limit 1
loadtime:0.74206805229187 / seconds
Query Executed:select id FROM `ut` where city='Snowbird' && SIC_code='7219'DB:business_master_new
loadtime:0.74642610549927 / seconds
Query loaded from cache:select * from geodata_geocity where city='Snowville' limit 1
loadtime:0.7464599609375 / seconds
Query Executed:select id FROM `ut` where city='Snowville' && SIC_code='7219'DB:business_master_new
loadtime:0.74680018424988 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Jordan' limit 1
loadtime:0.74683904647827 / seconds
Query Executed:select id FROM `ut` where city='South Jordan' && SIC_code='7219'DB:business_master_new
loadtime:0.74731111526489 / seconds
Query loaded from cache:select * from geodata_geocity where city='South Salt Lake' limit 1
loadtime:0.74733710289001 / seconds
Query Executed:select id FROM `ut` where city='South Salt Lake' && SIC_code='7219'DB:business_master_new
loadtime:0.75319719314575 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spanish Fork' limit 1
loadtime:0.75323796272278 / seconds
Query Executed:select id FROM `ut` where city='Spanish Fork' && SIC_code='7219'DB:business_master_new
loadtime:0.75372505187988 / seconds
Query loaded from cache:select * from geodata_geocity where city='Spring City' limit 1
loadtime:0.75375819206238 / seconds
Query Executed:select id FROM `ut` where city='Spring City' && SIC_code='7219'DB:business_master_new
loadtime:0.75411105155945 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springdale' limit 1
loadtime:0.75413703918457 / seconds
Query Executed:select id FROM `ut` where city='Springdale' && SIC_code='7219'DB:business_master_new
loadtime:0.75460815429688 / seconds
Query loaded from cache:select * from geodata_geocity where city='Springville' limit 1
loadtime:0.75464200973511 / seconds
Query Executed:select id FROM `ut` where city='Springville' && SIC_code='7219'DB:business_master_new
loadtime:0.75512599945068 / seconds
Query loaded from cache:select * from geodata_geocity where city='St George' limit 1
loadtime:0.75515103340149 / seconds
Query Executed:select id FROM `ut` where city='St George' && SIC_code='7219'DB:business_master_new
loadtime:0.75562214851379 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sterling' limit 1
loadtime:0.75565600395203 / seconds
Query Executed:select id FROM `ut` where city='Sterling' && SIC_code='7219'DB:business_master_new
loadtime:0.76318597793579 / seconds
Query loaded from cache:select * from geodata_geocity where city='Stockton' limit 1
loadtime:0.76322197914124 / seconds
Query Executed:select id FROM `ut` where city='Stockton' && SIC_code='7219'DB:business_master_new
loadtime:0.76356101036072 / seconds
Query loaded from cache:select * from geodata_geocity where city='Summit' limit 1
loadtime:0.76360106468201 / seconds
Query Executed:select id FROM `ut` where city='Summit' && SIC_code='7219'DB:business_master_new
loadtime:0.7668571472168 / seconds
Query loaded from cache:select * from geodata_geocity where city='Sunnyside' limit 1
loadtime:0.76688504219055 / seconds
Query Executed:select id FROM `ut` where city='Sunnyside' && SIC_code='7219'DB:business_master_new
loadtime:0.77117204666138 / seconds
Query loaded from cache:select * from geodata_geocity where city='Syracuse' limit 1
loadtime:0.77121305465698 / seconds
Query Executed:select id FROM `ut` where city='Syracuse' && SIC_code='7219'DB:business_master_new
loadtime:0.7717170715332 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tabiona' limit 1
loadtime:0.77175116539001 / seconds
Query Executed:select id FROM `ut` where city='Tabiona' && SIC_code='7219'DB:business_master_new
loadtime:0.77642607688904 / seconds
Query loaded from cache:select * from geodata_geocity where city='Talmage' limit 1
loadtime:0.77645397186279 / seconds
Query Executed:select id FROM `ut` where city='Talmage' && SIC_code='7219'DB:business_master_new
loadtime:0.78095698356628 / seconds
Query loaded from cache:select * from geodata_geocity where city='Teasdale' limit 1
loadtime:0.78110313415527 / seconds
Query Executed:select id FROM `ut` where city='Teasdale' && SIC_code='7219'DB:business_master_new
loadtime:0.78599309921265 / seconds
Query loaded from cache:select * from geodata_geocity where city='Terra' limit 1
loadtime:0.7860209941864 / seconds
Query Executed:select id FROM `ut` where city='Terra' && SIC_code='7219'DB:business_master_new
loadtime:0.78665709495544 / seconds
Query loaded from cache:select * from geodata_geocity where city='Thompson' limit 1
loadtime:0.78669404983521 / seconds
Query Executed:select id FROM `ut` where city='Thompson' && SIC_code='7219'DB:business_master_new
loadtime:0.78810095787048 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tooele' limit 1
loadtime:0.78812718391418 / seconds
Query Executed:select id FROM `ut` where city='Tooele' && SIC_code='7219'DB:business_master_new
loadtime:0.78862810134888 / seconds
Query loaded from cache:select * from geodata_geocity where city='Toquerville' limit 1
loadtime:0.78867197036743 / seconds
Query Executed:select id FROM `ut` where city='Toquerville' && SIC_code='7219'DB:business_master_new
loadtime:0.78902101516724 / seconds
Query loaded from cache:select * from geodata_geocity where city='Torrey' limit 1
loadtime:0.789057970047 / seconds
Query Executed:select id FROM `ut` where city='Torrey' && SIC_code='7219'DB:business_master_new
loadtime:0.78938508033752 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tremonton' limit 1
loadtime:0.78941917419434 / seconds
Query Executed:select id FROM `ut` where city='Tremonton' && SIC_code='7219'DB:business_master_new
loadtime:0.78989315032959 / seconds
Query loaded from cache:select * from geodata_geocity where city='Trenton' limit 1
loadtime:0.78993201255798 / seconds
Query Executed:select id FROM `ut` where city='Trenton' && SIC_code='7219'DB:business_master_new
loadtime:0.79650211334229 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tridell' limit 1
loadtime:0.79653000831604 / seconds
Query Executed:select id FROM `ut` where city='Tridell' && SIC_code='7219'DB:business_master_new
loadtime:0.79938197135925 / seconds
Query loaded from cache:select * from geodata_geocity where city='Tropic' limit 1
loadtime:0.79944705963135 / seconds
Query Executed:select id FROM `ut` where city='Tropic' && SIC_code='7219'DB:business_master_new
loadtime:0.80001401901245 / seconds
Query loaded from cache:select * from geodata_geocity where city='Venice' limit 1
loadtime:0.80007815361023 / seconds
Query Executed:select id FROM `ut` where city='Venice' && SIC_code='7219'DB:business_master_new
loadtime:0.80201601982117 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernal' limit 1
loadtime:0.80209612846375 / seconds
Query Executed:select id FROM `ut` where city='Vernal' && SIC_code='7219'DB:business_master_new
loadtime:0.80288505554199 / seconds
Query loaded from cache:select * from geodata_geocity where city='Vernon' limit 1
loadtime:0.80292701721191 / seconds
Query Executed:select id FROM `ut` where city='Vernon' && SIC_code='7219'DB:business_master_new
loadtime:0.806969165802 / seconds
Query loaded from cache:select * from geodata_geocity where city='Veyo' limit 1
loadtime:0.80700612068176 / seconds
Query Executed:select id FROM `ut` where city='Veyo' && SIC_code='7219'DB:business_master_new
loadtime:0.80735802650452 / seconds
Query loaded from cache:select * from geodata_geocity where city='Virgin' limit 1
loadtime:0.80739402770996 / seconds
Query Executed:select id FROM `ut` where city='Virgin' && SIC_code='7219'DB:business_master_new
loadtime:0.81238603591919 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wales' limit 1
loadtime:0.81242918968201 / seconds
Query Executed:select id FROM `ut` where city='Wales' && SIC_code='7219'DB:business_master_new
loadtime:0.8162670135498 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wallsburg' limit 1
loadtime:0.81630706787109 / seconds
Query Executed:select id FROM `ut` where city='Wallsburg' && SIC_code='7219'DB:business_master_new
loadtime:0.81667304039001 / seconds
Query loaded from cache:select * from geodata_geocity where city='Washington' limit 1
loadtime:0.81669902801514 / seconds
Query Executed:select id FROM `ut` where city='Washington' && SIC_code='7219'DB:business_master_new
loadtime:0.81718707084656 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellington' limit 1
loadtime:0.81722402572632 / seconds
Query Executed:select id FROM `ut` where city='Wellington' && SIC_code='7219'DB:business_master_new
loadtime:0.81771302223206 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wellsville' limit 1
loadtime:0.81773805618286 / seconds
Query Executed:select id FROM `ut` where city='Wellsville' && SIC_code='7219'DB:business_master_new
loadtime:0.81821513175964 / seconds
Query loaded from cache:select * from geodata_geocity where city='Wendover' limit 1
loadtime:0.81824898719788 / seconds
Query Executed:select id FROM `ut` where city='Wendover' && SIC_code='7219'DB:business_master_new
loadtime:0.81872415542603 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Haven' limit 1
loadtime:0.81874918937683 / seconds
Query Executed:select id FROM `ut` where city='West Haven' && SIC_code='7219'DB:business_master_new
loadtime:0.81926417350769 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Jordan' limit 1
loadtime:0.81932497024536 / seconds
Query Executed:select id FROM `ut` where city='West Jordan' && SIC_code='7219'DB:business_master_new
loadtime:0.82015109062195 / seconds
Query loaded from cache:select * from geodata_geocity where city='West Valley' limit 1
loadtime:0.82024598121643 / seconds
Query Executed:select id FROM `ut` where city='West Valley' && SIC_code='7219'DB:business_master_new
loadtime:0.82086801528931 / seconds
Query loaded from cache:select * from geodata_geocity where city='Whiterocks' limit 1
loadtime:0.82093000411987 / seconds
Query Executed:select id FROM `ut` where city='Whiterocks' && SIC_code='7219'DB:business_master_new
loadtime:0.82499003410339 / seconds
Query loaded from cache:select * from geodata_geocity where city='Willard' limit 1
loadtime:0.82509303092957 / seconds
Query Executed:select id FROM `ut` where city='Willard' && SIC_code='7219'DB:business_master_new
loadtime:0.82578897476196 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodland Hills' limit 1
loadtime:0.82586717605591 / seconds
Query Executed:select id FROM `ut` where city='Woodland Hills' && SIC_code='7219'DB:business_master_new
loadtime:0.82661104202271 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woodruff' limit 1
loadtime:0.82664918899536 / seconds
Query Executed:select id FROM `ut` where city='Woodruff' && SIC_code='7219'DB:business_master_new
loadtime:0.82742714881897 / seconds
Query loaded from cache:select * from geodata_geocity where city='Woods Cross' limit 1
loadtime:0.82748699188232 / seconds
Query Executed:select id FROM `ut` where city='Woods Cross' && SIC_code='7219'DB:business_master_new
loadtime:0.82827711105347 / seconds
Query loaded from cache:select * from geodata_usstates order by statetitle asc
loadtime:0.82842016220093 / seconds
Operation directorystatepages executed (chunk cache operation)
loadtime:0.82881498336792 / seconds
Operation template executed (chunk cache operation)
loadtime:0.82900309562683 / seconds
template override:Default
loadtime:0.829097032547 / 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.83030700683594 / seconds
Template Constructed, Array Rows:49
loadtime:0.83072304725647 / seconds
TOTAL EXECUTION TIME: 0.83035
loadtime:0.83090901374817 / seconds

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


PAGE OBJECT DATA


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



_GET


Array ( [cat_URLid] => laundry-and-garment-services-nec [stateURLid] => 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.83091711997986
TOTAL KEY ARRAYS: 69