in reply to Slow query with Apache::Session

It's asking to lock a session. It probably showed up in the slow queries because this session was already locked and it had to wait. That could mean you have a scoping bug in your code which causes Apache::Session to not release locks.