1) upload insert.showstat.php file to your /class/smarty/plugins directory from your Xoops root folder.

2) Go into your Xoops control panel, and goto System Admin->Preferences Main->General Settings and set the "Update module template .html files from themes/your theme/templates directory?" to yes.

3) Insert the "<{insert name='showstat'}>" minus the "" into your theme.html file and view your homepage (you should see something like "0.432 Seconds | 46 Queries" printed at the base of your page).

4) Go into your Xoops control panel, and goto System Admin->Preferences Main->General Settings and set the "Update module template .html files from themes/your theme/templates directory?" to no.

5) Set all your block and caching options to suit your site, and this smarty plugin should now display the execution time and MySQL query count generated for producing every page.