Queries locking up

[Thomas Kazarian]

The biggest performance hit on my site are these queries:

SELECT COUNT (*) FROM `item` WHERE item.item_type_id = ? AND item.has_photo = ?

SELECT item.* FROM `item` WHERE item.item_type_id = ? AND item.has_photo = ? ORDER BY normalized_time DESC LIMIT ?, ?

I'm wondering if a MySQL expert (like most of the people on these forums) were to see these queries do you instantly know they can be improved?

The queries are for Lionseek.com - I hate slow sites and I know the visitors do as well. Need some recommendations on getting the queries improved. Please help!

http://www.lionseek.com/locked.png



Edited 1 time(s). Last edit at 05/08/2013 09:21AM by Thomas Kazarian.