mySQL queries to be made more efficient (host has shut down account.....)

My host has shut down my shared hosting account because of excessive load on the server. The following queries are blamed - but have been running for 18 months without previous incident. I set out what they sent me - the stats around the queries don't mean much to me.

Is there something I can do to improve matters? There is no indexing on the tables but is that the issue or are these queries inherently inefficient in which case how can they be improved?

Or has the host got something wrong - after all has worked for 18 months and 3 tables have no more than approx 6000 entries (images) 600 (submissions) 200 (photogs)

QUERY 1 - locates a single image and retrieves related info from 3 tables

# Time: 070718 13:33:47
# User@Host: photoconnectimag[photoconnectimag] @ localhost [] # Query_time: 54  Lock_time: 0  Rows_sent: 5934
Rows_examined: 5934
use photoconnectimag;
SELECT photoconnectSubmissions.submitRef,
photoconnectSubmissions.loginName,
photoconnectImages.imageRef, photoconnectImages.loginName, photoconnectImages.submitRef, photoconnectImages.imgfileName, photoconnectImages.imageDesc1, photoconnectImages.imageDesc2, photoconnectImages.modelRelease, photoconnectImages.propRelease, photoconnectImages.maxSize, photoconnectImages.sellLicense, photoconnectImages.sellRF, photoconnectImages.sellFA, photoconnectImages.buyerDecides, photoconnectImages.sellRestrict, photoconnectImages.refAlamy, photoconnectImages.pageType,
photoconnectImages.urlAlamy, PhotoconnectPhotogs.loginName, PhotoconnectPhotogs.agencyName, PhotoconnectPhotogs.payPageURL, PhotoconnectPhotogs.eMail, PhotoconnectPhotogs.websiteURL, PhotoconnectPhotogs.firstName, PhotoconnectPhotogs.lastName FROM photoconnectImages, photoconnectSubmissions, photoconnectusers, PhotoconnectPhotogs WHERE imageRef = 1003567 AND photoconnectImages.submitRef = photoconnectSubmissions.submitRef AND photoconnectImages.loginName = PhotoconnectPhotogs.loginName;

QUERY 2 - searches 2 tables for a keyword

# Time: 070718 13:34:13
# User@Host: photoconnectimag[photoconnectimag] @ localhost [] # Query_time: 121  Lock_time: 0  Rows_sent: 16
Rows_examined: 11822
use photoconnectimag;
SELECT photoconnectImages.submitRef, photoconnectImages.imageRef, photoconnectSubmissions.submitRef,
photoconnectSubmissions.Valid,
photoconnectImages.imgfileName,
photoconnectImages.imageDesc1,
photoconnectImages.imageDesc2,
photoconnectImages.modelRelease, photoconnectImages.sellLicense, photoconnectImages.sellRF, photoconnectImages.sellFA, photoconnectImages.urlAlamy,
photoconnectImages.refAlamy,
photoconnectSubmissions.pageTitle FROM photoconnectImages
LEFT JOIN photoconnectSubmissions ON photoconnectImages.submitRef = photoconnectSubmissions.submitRef WHERE photoconnectSubmissions.Valid = 'yes'  AND ((imageDesc1 LIKE
'%teenager%') OR (imageDesc2 LIKE '%teenager%') OR
(pageTitle LIKE '%teenager%')) AND (Valid = 'yes') ORDER BY photoconnectImages.imageRef DESC LIMIT 32, 16;

Thanks

Scott