Query takes too much time in loading

i made a query for random product my query Looks like

SELECT * FROM product AS a ORDER BY RAND(CURDATE() + INTERVAL (SELECT MINUTE(NOW())) MINUTE - INTERVAL 1 MINUTE) LIMIT 15

issue is i have 150K data in my product table the query takes woo much time to load maximum 9 second What should i do for fast loading Please Help

Level 7

Have you tried "describing" the query to find out where is it falling short?

Level 1

no i did.nt tried

Please or to participate in this conversation.