Queries form index.php:
le="color: #000000"><?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:
le="color: #000000"><?php 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
