couple of quick things1. You are using log.debug. Have you enabled the configuration to log the debug level ?? else use log.info or log.error2. How have you created your session ??
http://<host>:<port>/libs/granite/operations/content/diagnosis/tool.html/_granite_queryperformanceClick on 'Explain Query'. Add your query here and see the explanation. You also attach the same here