Alfresco ibatis and Solr debugging

http://smasue.github.io/alf-canned-queries

Above link has the code for creating custom service on top of Alfresco database

http://smasue.github.io/alf-debug-solr
Above link has the code to debug solr queries