Queries form index.php:
SELECT * FROM prefix_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM prefix_session WHERE sess_id = '795f14f40b21af3ded1c89e1d992f914'
SELECT * FROM prefix_users WHERE uid=1
DELETE FROM prefix_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM prefix_protector_access WHERE ip='82.160.2.94' AND request_uri='/index.php'
SELECT COUNT(*) FROM prefix_protector_access WHERE ip='82.160.2.94'
INSERT INTO prefix_protector_access SET ip='82.160.2.94',request_uri='/index.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM prefix_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM prefix_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM prefix_newblocks b, prefix_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 (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM prefix_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT news, auto, image, auto_image FROM prefix_spotlight LIMIT 0, 1
SELECT storyid, uid, title, hometext, comments, topicid, published, counter FROM prefix_stories WHERE storyid=716 LIMIT 0, 1
SELECT uname, uid FROM prefix_users WHERE uid=1 LIMIT 0, 1
SELECT topicid FROM prefix_stories WHERE topicid=29 LIMIT 0, 1
SELECT topic_imgurl FROM prefix_topics WHERE topic_id=29 LIMIT 0, 1
SELECT storyid, title, published, expired, counter, hometext FROM prefix_stories WHERE published < 1157990511 AND published > 0 AND (expired = 0 OR expired > 1157990511) AND storyid != 716 ORDER BY published DESC LIMIT 0, 10
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_spotlight.html') ORDER BY tpl_refid
SELECT * FROM prefix_modules WHERE dirname = 'news'
SELECT * FROM prefix_config WHERE (conf_modid = '6') ORDER BY conf_order ASC
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (published > 0 AND published <= 1157990511) AND (expired = 0 OR expired > 1157990511) AND (s.topicid=t.topic_id) ORDER BY s.counter DESC LIMIT 0, 10
SELECT * FROM prefix_smiles
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_top.html') ORDER BY tpl_refid
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (published > 0 AND published <= 1157990512) AND (expired = 0 OR expired > 1157990512) AND (s.topicid=t.topic_id) ORDER BY s.published DESC LIMIT 0, 10
SELECT storyid FROM prefix_stories WHERE (published > 0 AND published <= 1157990512) AND (expired = 0 OR expired > 1157990512) ORDER BY published DESC
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=677) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=542) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=502) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=499) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=423) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=358) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=345) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=230) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=173) AND (s.topicid=t.topic_id)
SELECT s.*, t.* FROM prefix_stories s, prefix_topics t WHERE (storyid=38) AND (s.topicid=t.topic_id)
SELECT f.*, s.tpl_source FROM prefix_tplfile f LEFT JOIN prefix_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_randomnews.html') ORDER BY tpl_refid
SELECT theme, title, subtitle, metakey, metadesc FROM prefix_ctem_pagelink WHERE pid='1'
Total: 40 queries
I use cache for some blocks and those are queries on index.php if XOOPS send me cached data:
SELECT * FROM wide_config WHERE (conf_modid = '0' AND conf_catid = '1') ORDER BY conf_order ASC
SELECT sess_data FROM wide_session WHERE sess_id = '795f14f40b21af3ded1c89e1d992f914'
SELECT * FROM wide_users WHERE uid=1
DELETE FROM wide_protector_access WHERE expire < UNIX_TIMESTAMP()
SELECT COUNT(*) FROM wide_protector_access WHERE ip='82.160.2.94' AND request_uri='/index.php'
SELECT COUNT(*) FROM wide_protector_access WHERE ip='82.160.2.94'
INSERT INTO wide_protector_access SET ip='82.160.2.94',request_uri='/index.php',expire=UNIX_TIMESTAMP()+'60'
SELECT * FROM wide_config WHERE (conf_modid = '0' AND conf_catid = '3') ORDER BY conf_order ASC
SELECT DISTINCT gperm_itemid FROM wide_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2)
SELECT b.* FROM wide_newblocks b, wide_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 (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22) ORDER BY b.weight,b.bid
SELECT COUNT(*) FROM wide_priv_msgs WHERE (read_msg = '0' AND to_userid = '1')
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_user.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_search.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'system_block_dummy.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_spotlight.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_top.html') ORDER BY tpl_refid
SELECT f.*, s.tpl_source FROM wide_tplfile f LEFT JOIN wide_tplsource s ON s.tpl_id=f.tpl_id WHERE (tpl_tplset = 'wide' AND tpl_file = 'news_block_randomnews.html') ORDER BY tpl_refid
SELECT theme, title, subtitle, metakey, metadesc FROM wide_ctem_pagelink WHERE pid='1'
Total: 18 queries
