jorge_kai
Alfa
Verificado por Whatsapp
¡Usuario con pocos negocios! ¡Utiliza siempre saldo de Forobeta!
- Desde
- 26 Jul 2005
- Mensajes
- 17
Buenas colegas! para los expertos en mysql, a ver si alguno me sabe decir a qué corresponden estas consultas
# Time: 111213 23:27:39
# User@Host: htcmania[htcmania] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 3330021
SELECT COUNT(*) AS count
FROM post AS post
WHERE dateline >= 1314268860
AND visible = 1;
# Time: 111213 23:21:16
# User@Host: htcmania[htcmania] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 656899
SELECT
SUM(IF(lastvisit >= 1308262868, 1, 0)) AS active,
COUNT(*) AS users,
MAX(userid) AS maxid
FROM user;
no consigo dar con ellas y constantemente están ejecutándose...
GRACIAS!
# Time: 111213 23:27:39
# User@Host: htcmania[htcmania] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 3330021
SELECT COUNT(*) AS count
FROM post AS post
WHERE dateline >= 1314268860
AND visible = 1;
# Time: 111213 23:21:16
# User@Host: htcmania[htcmania] @ localhost []
# Query_time: 5 Lock_time: 0 Rows_sent: 1 Rows_examined: 656899
SELECT
SUM(IF(lastvisit >= 1308262868, 1, 0)) AS active,
COUNT(*) AS users,
MAX(userid) AS maxid
FROM user;
no consigo dar con ellas y constantemente están ejecutándose...
GRACIAS!
