What This slow Query ?

[Draving]

Hi, sorry my bad english

There is a very slow query in my database:

Matar el proceso 	68882 	DB 	localhost 	DB 	Query 	1627 	Sending data 	SELECT user . * , usertextfield . * , userfield . * , user.userid, options, IF( displaygroupid =0, user.usergr
Matar el proceso 	69228 	DB 	localhost 	DB 	Query 	1604 	Sending data 	SELECT user . * , usertextfield . * , userfield . * , user.userid, options, IF( displaygroupid =0, user.usergr
Matar el proceso 	69618 	DB 	localhost 	DB 	Query 	1577 	Sending data 	SELECT user . * , usertextfield . * , userfield . * , user.userid, options, IF( displaygroupid =0, user.usergr
Matar el proceso 	69979 	DB 	localhost 	DB 	Query 	1552 	Sending data 	SELECT user . * , usertextfield . * , userfield . * , user.userid, options, IF( displaygroupid =0, user.usergr
Matar el proceso 	71301 	DB 	localhost 	DB 	Query 	1319 	Sending data 	SELECT user . * , usertextfield . * , userfield . * , user.userid, options, IF( displaygroupid =0, user.usergr
Matar el proceso 	73978 	DB 	localhost 	DB 	Query 	885 	Sending data 	SELECT SUM( IF( lastvisit >=1251665384, 1, 0 ) ) AS active, COUNT( * ) AS users, MAX( userid ) AS max
Matar el proceso 	74715 	DB 	localhost 	DB 	Query 	755 	Sending data 	SELECT SUM( IF( lastvisit >=1251665427, 1, 0 ) ) AS active, COUNT( * ) AS users, MAX( userid ) AS max
Matar el proceso 	74976 	DB 	localhost 	DB 	Query 	727 	Sending data 	SELECT SUM( IF( lastvisit >=1251665441, 1, 0 ) ) AS active, COUNT( * ) AS users, MAX( userid ) AS max
Matar el proceso 	75078 	DB 	localhost 	DB 	Query 	718 	Sending data 	SELECT SUM( IF( lastvisit >=1251665448, 1, 0 ) ) AS active, COUNT( * ) AS users, MAX( userid ) AS max

How can I optimize or eliminate this Query?

Thanks