Queries |
---|
0.000101 - SET SQL_BIG_SELECTS = 1 |
0.001234 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000322 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '9434cfb9e59eeadd19efdab113dbf0f4' |
0.000343 - SELECT * FROM modules WHERE dirname = 'pcnews' |
0.001185 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '46') |
0.001019 - SELECT * FROM config WHERE (`conf_modid` = '46') ORDER BY conf_order ASC |
0.000221 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP() |
0.000325 - SELECT COUNT(*) FROM protector_access WHERE ip='52.14.114.234' AND request_uri='/modules/pcnews/article.php?storyid=5' |
0.000220 - SELECT COUNT(*) FROM protector_access WHERE ip='52.14.114.234' |
0.000324 - INSERT INTO protector_access SET ip='52.14.114.234', request_uri='/modules/pcnews/article.php?storyid=5', expire=UNIX_TIMESTAMP()+'10' |
0.010958 - SELECT s.*, t.* FROM pcnews_stories s, pcnews_topics t WHERE (storyid=5) AND (s.topicid=t.topic_id) |
0.001391 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_view' AND `gperm_itemid` = '8') |
0.000342 - UPDATE pcnews_stories SET counter = counter+1 WHERE storyid = 5 |
0.000441 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000675 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.006427 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001292 - 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,46) 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.000682 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC |
0.002083 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3') |
0.000853 - 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.000802 - 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.000294 - SELECT * FROM modules WHERE dirname = 'PDdownloads' |
0.000262 - SELECT * FROM modules WHERE dirname = 'PDlinks' |
0.000510 - SELECT count(*) FROM modules WHERE dirname = 'pcnews' AND isactive=1 |
0.000987 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_submit') |
0.000249 - SELECT COUNT(*) as cpt FROM pcnews_topics WHERE menu=1 |
0.000284 - SELECT * FROM modules WHERE dirname = 'pdnews' |
0.000828 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_submit') |
0.000342 - SELECT * FROM modules WHERE dirname = 'beosnews' |
0.001734 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '48' AND (`gperm_groupid` = '3') AND `gperm_name` = 'beosnews_submit') |
0.001288 - SELECT text, submitter FROM incblock_welcometext ORDER BY RAND() LIMIT 0,1 |
0.000369 - SELECT * FROM smiles |
0.000246 - DELETE FROM online WHERE online_updated < 1744898843 |
0.000276 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip='' |
0.000295 - UPDATE online SET online_updated = 1744899143, online_module = 46 WHERE online_uid = 0 AND online_ip='' |
0.000176 - SELECT online_uid, online_uname FROM online |
0.000779 - SELECT uid, uname, user_regdate FROM users WHERE user_regdate >= 1744754400 and level > 0 |
0.000250 - SELECT uid, uname from users where level > 0 order by uid DESC limit 1 |
0.000431 - SELECT COUNT(*) FROM users WHERE level > 0 |
0.000122 - SELECT COUNT(*) FROM session |
0.001049 - 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.000436 - SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC |
0.000411 - SELECT id FROM partners Where status = 1 ORDER BY hits DESC |
0.000264 - SELECT id, url, image, title FROM partners WHERE id=9 |
0.000226 - SELECT id, url, image, title FROM partners WHERE id=6 |
0.000281 - SELECT id, url, image, title FROM partners WHERE id=3 |
0.000243 - SELECT id, url, image, title FROM partners WHERE id=5 |
0.000243 - SELECT id, url, image, title FROM partners WHERE id=4 |
0.000486 - SELECT * FROM users WHERE uid = '1' |
0.001345 - SELECT * FROM pcnews_stories_files WHERE storyid=5 |
0.000312 - SELECT topic_pid, topic_title FROM pcnews_topics WHERE topic_id=8 |
0.000230 - SELECT topic_pid, topic_title FROM pcnews_topics WHERE topic_id=3 |
0.001076 - SELECT s.*, t.* FROM pcnews_stories s, pcnews_topics t WHERE (published > 0 AND published <= 1744899143) AND (expired = 0 OR expired > 1744899143) AND (s.topicid=t.topic_id) AND ihome=0 ORDER BY s.published DESC LIMIT 0, 5 |
0.000608 - SELECT storyid FROM pcnews_stories WHERE (published > 0 AND published <= 1744899143) AND (expired = 0 OR expired > 1744899143) AND topicid=8 |
0.001282 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'system_admin' AND `gperm_itemid` = '14') |
0.000806 - SELECT * FROM xoopscomments WHERE (`com_modid` = '46' AND `com_itemid` = '5') ORDER BY com_id DESC |
0.000358 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 9 |
0.000206 - SELECT COUNT(*) FROM online WHERE `online_uid` = '1' |
0.000323 - SELECT * FROM users WHERE uid = '9' |
0.000192 - SELECT rank_title AS title, rank_image AS image FROM ranks WHERE rank_id = 10 |
0.000166 - SELECT COUNT(*) FROM online WHERE `online_uid` = '9' |