Joining the bigint pageId on the string sakaiId can be very bad on MySQL

findItemsInSite has custom SQL (not Hibernate) that performs a join from the lesson_builder_pages pageId (bigint) on lesson_builder_items sakaiId (varchar(250).

An explain is attached showing the terrible MySQL performance.