Queries |
---|
0.000052 - SET SQL_BIG_SELECTS = 1 |
0.000688 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000167 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '19e427b62fd25c40e556cfdd5192f3a3' |
0.000216 - SELECT * FROM modules WHERE dirname = 'newbb' |
0.000864 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '44') |
0.000930 - SELECT * FROM config WHERE (`conf_modid` = '44') ORDER BY conf_order ASC |
0.000279 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP() |
0.019736 - SELECT COUNT(*) FROM protector_access WHERE ip='18.222.197.132' AND request_uri='/modules/newbb/viewforum.php?forum=76' |
0.018500 - SELECT COUNT(*) FROM protector_access WHERE ip='18.222.197.132' |
0.000236 - INSERT INTO protector_access SET ip='18.222.197.132', request_uri='/modules/newbb/viewforum.php?forum=76', expire=UNIX_TIMESTAMP()+'10' |
0.000244 - SELECT * FROM modules WHERE dirname = 'xoopspoll' |
0.000150 - SELECT * FROM bb_forums WHERE forum_id = '76' |
0.000692 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access') |
0.001539 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_access') |
0.000244 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000184 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.001900 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.000509 - SELECT b.* FROM newblocks b, block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,44) AND b.bid IN (9,82,6,1,12,11,10,8,7,5,4,86,3,219,2,44,175,177,178,45,80,79,78,85,84,83,81,97,98,92,93,90,91,64,65,66,67,169,170,168,136,143,151,180,181,182,183,227,179,210,204,205,206,207,208,209,197,198,199,200,201,202,203,196,190,191,192,193,194,195,211,176,223,226,230,231,232,233) ORDER BY b.weight, m.block_id |
0.000247 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC |
0.000735 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3') |
0.000340 - SELECT gperm_itemid FROM group_permission LEFT JOIN modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum' AND gperm_name='myalbum_global' AND (gperm_groupid=3) |
0.000298 - SELECT gperm_itemid FROM group_permission LEFT JOIN modules m ON gperm_modid=m.mid WHERE m.dirname='myalbum1' AND gperm_name='myalbum_global' AND (gperm_groupid=3) |
0.000140 - SELECT * FROM modules WHERE dirname = 'PDdownloads' |
0.000119 - SELECT * FROM modules WHERE dirname = 'PDlinks' |
0.000149 - SELECT count(*) FROM modules WHERE dirname = 'pcnews' AND isactive=1 |
0.000106 - SELECT * FROM modules WHERE dirname = 'pcnews' |
0.000347 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_submit') |
0.000139 - SELECT count(*) FROM modules WHERE dirname = 'pdnews' AND isactive=1 |
0.000114 - SELECT * FROM modules WHERE dirname = 'pdnews' |
0.000293 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_submit') |
0.000172 - SELECT count(*) FROM modules WHERE dirname = 'beosnews' AND isactive=1 |
0.000144 - SELECT * FROM modules WHERE dirname = 'beosnews' |
0.000460 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '48' AND (`gperm_groupid` = '3') AND `gperm_name` = 'beosnews_submit') |
0.000152 - SELECT count(*) FROM modules WHERE dirname = 'PDMembers' AND isactive=1 |
0.000522 - SELECT text, submitter FROM incblock_welcometext ORDER BY RAND() LIMIT 0,1 |
0.000132 - SELECT * FROM smiles |
0.000173 - DELETE FROM online WHERE online_updated < 1743879549 |
0.000156 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip='' |
0.000195 - UPDATE online SET online_updated = 1743879849, online_module = 44 WHERE online_uid = 0 AND online_ip='' |
0.000104 - SELECT online_uid, online_uname FROM online |
0.000519 - SELECT uid, uname, user_regdate FROM users WHERE user_regdate >= 1743717600 and level > 0 |
0.000166 - SELECT uid, uname from users where level > 0 order by uid DESC limit 1 |
0.000269 - SELECT COUNT(*) FROM users WHERE level > 0 |
0.000070 - SELECT COUNT(*) FROM session |
0.000390 - SELECT u.uid, u.uname, u.email, u.user_viewemail, u.user_avatar, g.name AS groupname FROM groups_users_link l LEFT JOIN users u ON l.uid=u.uid LEFT JOIN groups g ON l.groupid=g.groupid WHERE g.group_type='Admin' ORDER BY l.groupid, u.uid |
0.000198 - SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC |
0.000186 - SELECT id FROM partners Where status = 1 ORDER BY hits DESC |
0.000135 - SELECT id, url, image, title FROM partners WHERE id=9 |
0.000111 - SELECT id, url, image, title FROM partners WHERE id=6 |
0.000104 - SELECT id, url, image, title FROM partners WHERE id=3 |
0.000105 - SELECT id, url, image, title FROM partners WHERE id=5 |
0.000096 - SELECT id, url, image, title FROM partners WHERE id=4 |
0.000612 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access') |
0.002017 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_post') |
0.000679 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access') |
0.001107 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_addpoll') |
0.002143 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'forum_access') |
0.000446 - SELECT * FROM `bb_forums` WHERE (`parent_forum` = '76' AND `forum_id` IN (70, 16, 15, 78, 17, 77, 13, 12, 11, 67, 66, 65, 10, 23, 22, 68, 6, 5, 64, 8, 7, 63, 35, 19, 18, 69, 4, 38, 24, 76, 74, 73, 62, 41, 30, 40, 29, 28, 27, 32, 31, 72, 71)) ORDER BY forum_order ASC |
0.000131 - SELECT cat_title, cat_id FROM bb_categories WHERE cat_id = '17' |
0.001018 - SELECT t.*, p.post_time as last_post_time, p.poster_name as last_poster_name, p.icon, p.post_id, p.uid, p.post_karma, p.require_reply, pt.post_text FROM bb_topics t LEFT JOIN bb_posts p ON p.post_id = t.topic_last_post_id LEFT JOIN bb_posts_text pt ON pt.post_id = t.topic_last_post_id WHERE 1 = 1 AND t.forum_id = 76 AND t.approved = 1 ORDER BY t.topic_sticky DESC, t.topic_last_post_id DESC LIMIT 0, 20 |
0.000415 - SELECT o.type_id, o.type_name, o.type_color, l.type_order FROM bb_type_forum AS l LEFT JOIN bb_type AS o ON o.type_id = l.type_id WHERE l.forum_id IN (76) ORDER BY l.type_order ASC |
0.000366 - SELECT uid, uname, name FROM users WHERE level > 0 AND uid IN(514,241,1,255,5,15) |
0.000435 - SELECT DISTINCT topic_id FROM bb_posts WHERE attachment != '' AND topic_id IN (1220,565,517,494) |
0.000178 - SELECT o.type_id, o.type_name, o.type_color, l.type_order FROM bb_type_forum AS l LEFT JOIN bb_type AS o ON o.type_id = l.type_id WHERE l.forum_id IN (76) ORDER BY l.type_order ASC |
0.000702 - SELECT COUNT(*) as count FROM bb_topics t LEFT JOIN bb_posts p ON p.post_id = t.topic_last_post_id WHERE (p.post_time > 0 OR t.topic_sticky=1) AND t.forum_id = 76 AND t.approved = 1 |
0.000688 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_name` = 'category_access') |
0.000226 - SELECT `cat_id`, `cat_order`, `cat_title` FROM `bb_categories` WHERE `cat_id` IN (8, 9, 5, 4, 10, 17, 2) ORDER BY cat_order ASC |
0.000189 - SELECT forum_id, COUNT(*) AS count FROM bb_moderates WHERE (uid=0 OR ip IN('18','18.222','18.222.197','18.222.197.132')) AND (mod_end > 1743879849) GROUP BY forum_id |
0.002544 - SELECT * FROM group_permission WHERE (`gperm_modid` = '44' AND `gperm_groupid` IN (3) AND `gperm_itemid` = '76' AND `gperm_name` IN ('forum_access', 'forum_view', 'forum_post', 'forum_reply', 'forum_edit', 'forum_delete', 'forum_addpoll', 'forum_vote', 'forum_attach', 'forum_noapprove', 'forum_type', 'forum_html', 'forum_signature', 'forum_pdf', 'forum_print')) |