Use SELECT * only if you need all columns from table LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
SELECT p.*, u.name, u.rol FROM pagina p INNERJOIN usuario u ON u.id = p.id_usuario WHERE tipo='noticia'ANDdate(p.fecha_noticia) = CURDATE() ORDERBY p.fecha_noticia DESC LIMIT 1650μsline_web
Params
hints
Use SELECT * only if you need all columns from table