Have some issues with slow queries. How to fix the problem. (4.5.0.h/IIS6/MYsql)

Roman



# Time: 070307 11:19:43
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 12 Lock_time: 0 Rows_sent: 31 Rows_examined: 135880
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('1') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 11:20:02
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30204
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:45:18
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30222
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:48:10
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30219
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:49:58
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 4 Lock_time: 0 Rows_sent: 31 Rows_examined: 30216
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:51:42
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30213
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:53:52
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30210
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;
# Time: 070307 13:55:43
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 3 Lock_time: 0 Rows_sent: 31 Rows_examined: 30207
SELECT leads.id , leads_cstm.*, leads.phone_work , CONCAT(IFNULL(leads.first_name,''),' ',IFNULL(leads.last_name,'')) as name, leads.first_name , leads.last_name , leads.salutation , leads.status , leads.account_name , leads.primary_address_city , jt0.user_name assigned_user_name , jt0.created_by assigned_user_name_owner , 'Users' assigned_user_name_mod, leads.assigned_user_id FROM leads LEFT JOIN leads_cstm ON leads.id = leads_cstm.id_c LEFT JOIN users jt0 ON
jt0.id= leads.assigned_user_id AND jt0.deleted=0
AND jt0.deleted=0 where (leads.assigned_user_id in ('9c54a724-bdc2-6a55-82cf-45cb1edb2c0f') and leads.status like 'New%') AND leads.deleted=0 ORDER BY terminwv_c ASC LIMIT 0,31;