mariadb - EXPLAIN works but ANALYZE throws ERROR 1064 (42000) error in SQL syntax
EXPLAIN will get the execution plan for a query

ANALYZE TABLE recalculates the index statistics. So just run 

ANALYZE TABLE `pics`;


Give it a Try !!!