SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM xoops_session WHERE sess_id = '25396f69a88d7f95493ad3ca243a4f92'
SELECT * FROM xoops_users WHERE uid=1
SELECT * FROM xoops_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,-1) AND b.bid IN (57,19,18,17,16,15,14,13,12,11,10,9,7,8,5,6,3,4,98,2,97,96,49,47,43,39,91,38,79,74,56,55,37,36,35,32,77,94,89,78,27,28,1,40,42,99,103,117,116,115,114,113,44,45,46,48,50,51,112,111,110,109,108,104,102,101,100,95,93,88,85,84,83) ORDER BY b.weight,b.bid
SELECT * FROM xoops_modules WHERE (hasmain = '1' AND isactive = '1' AND weight > '0') ORDER BY weight ASC, mid ASC
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = '1' AND (gperm_groupid = '1' OR gperm_groupid = '2'))
SELECT * FROM xoops_modules WHERE dirname = 'PDdownloads'
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT COUNT(*) FROM xoops_online WHERE online_uid=1
UPDATE xoops_online SET online_updated=1129137078, online_module = 0 WHERE online_uid = 1
SELECT * FROM xoops_online
SELECT * FROM xoops_modules WHERE isactive = '1' ORDER BY weight ASC, mid ASC
SELECT COUNT(*) FROM xoops_users WHERE level > '0'
SELECT COUNT(*) FROM xoops_users WHERE user_regdate >= '1129100400'
SELECT COUNT(*) FROM xoops_users WHERE user_regdate >= '1129014000'
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 1
SELECT * FROM xoops_config WHERE (conf_modid = '28') ORDER BY conf_order ASC
SELECT lid, cid, title, date, hits FROM xoops_PDdownloads_downloads WHERE status > 0 AND offline = 0 ORDER BY date DESC LIMIT 0, 10
SELECT lid, cid, title, date, hits FROM xoops_PDdownloads_downloads WHERE status > 0 AND offline = 0 ORDER BY hits DESC LIMIT 0, 10
SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT * FROM xoops_modules WHERE dirname = 'xcgal'
SELECT count(*) from xoops_xcgal_pictures WHERE approved = 'YES'
SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime FROM xoops_xcgal_pictures WHERE approved = 'YES' ORDER BY RAND() LIMIT 5
SELECT * FROM xoops_config WHERE (conf_modid = '4') ORDER BY conf_order ASC
SELECT storyid, title, published, expired, counter FROM xoops_stories WHERE published < 1129137078 AND published > 0 AND (expired = 0 OR expired > 1129137078) ORDER BY published DESC LIMIT 0, 10
SELECT * FROM xoops_xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC
SELECT * FROM xoops_xoopspoll_option WHERE poll_id=10 ORDER BY option_id
SELECT * FROM xoops_users WHERE (level > '0') ORDER BY user_regdate DESC LIMIT 0, 5
SELECT * FROM xoops_modules WHERE dirname = 'newbb'
SELECT * FROM xoops_config WHERE (conf_modid = '3') ORDER BY conf_order ASC
SELECT * FROM xoops_bb_forums ORDER BY forum_order
SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_admin' AND gperm_itemid = '3' AND gperm_modid = '1')
SELECT uid FROM xoops_groups_users_link WHERE groupid=1
SELECT t.*, f.forum_name, f.allow_subject_prefix, p.post_id, p.icon, p.uid, p.poster_name, u.uname, u.name FROM xoops_bb_topics t, xoops_bb_forums f, xoops_bb_posts p LEFT JOIN xoops_users u ON u.uid = p.uid WHERE f.forum_id=t.forum_id AND t.forum_id IN (1,2,3,4,5,7,8,9,10,11,13,14,15,16,17,18,19,20,6) AND t.approved = 1 AND p.approved = 1 AND t.topic_last_post_id=p.post_id ORDER BY t.topic_time DESC LIMIT 0, 5
SELECT * FROM xoops_users WHERE (level > '0' AND rank <> '6' AND rank <> '7' AND rank <> '8' AND rank <> '9' AND rank <> '11' AND rank <> '12') ORDER BY posts DESC LIMIT 0, 5
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT mid FROM xoops_modules WHERE dirname='piCal'
SELECT conf_name,conf_value FROM xoops_config WHERE conf_modid=38
SELECT * FROM xoops_groups
SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM xoops_groups_users_link l LEFT JOIN xoops_users u ON l.uid=u.uid LEFT JOIN xoops_groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid
SELECT mid FROM xoops_modules WHERE dirname='piCal'
SELECT conf_name,conf_value FROM xoops_config WHERE conf_modid=38
SELECT * FROM xoops_groups
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT * FROM xoops_tplfile WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM xoops_tplfile f LEFT JOIN xoops_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'default' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
Total: 52 queries
This is what I got when I activated the MySQL Debug Mode.
