Queries |
---|
0.000102 - SET SQL_BIG_SELECTS = 1 |
0.001433 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '1') ORDER BY conf_order ASC |
0.000428 - SELECT sess_data, sess_ip FROM session WHERE sess_id = '4d43a1f3d5d38a786a94872af40f3650' |
0.000479 - SELECT * FROM modules WHERE dirname = 'pdnews' |
0.001275 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'module_read' AND `gperm_itemid` = '47') |
0.001027 - SELECT * FROM config WHERE (`conf_modid` = '47') ORDER BY conf_order ASC |
0.000607 - DELETE FROM protector_access WHERE expire < UNIX_TIMESTAMP() |
0.038453 - SELECT COUNT(*) FROM protector_access WHERE ip='18.191.229.157' AND request_uri='/modules/pdnews/article.php?storyid=78' |
0.032733 - SELECT COUNT(*) FROM protector_access WHERE ip='18.191.229.157' |
0.000379 - INSERT INTO protector_access SET ip='18.191.229.157', request_uri='/modules/pdnews/article.php?storyid=78', expire=UNIX_TIMESTAMP()+'10' |
0.035122 - SELECT s.*, t.* FROM pdnews_stories s, pdnews_topics t WHERE (storyid=78) AND (s.topicid=t.topic_id) |
0.001340 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_view' AND `gperm_itemid` = '3') |
0.000449 - UPDATE pdnews_stories SET counter = counter+1 WHERE storyid = 78 |
0.000634 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '5') ORDER BY conf_order ASC |
0.000733 - SELECT * FROM config WHERE (`conf_modid` = '0' AND `conf_catid` = '3') ORDER BY conf_order ASC |
0.005960 - SELECT DISTINCT gperm_itemid FROM group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (3) |
0.001421 - 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,47) 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.000853 - SELECT * FROM modules WHERE (`hasmain` = '1' AND `isactive` = '1' AND `weight` > '0') ORDER BY weight ASC, mid ASC |
0.002268 - SELECT * FROM group_permission WHERE (`gperm_name` = 'module_read' AND `gperm_modid` = '1' AND `gperm_groupid` = '3') |
0.001106 - 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.000877 - 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.000319 - SELECT * FROM modules WHERE dirname = 'PDdownloads' |
0.000278 - SELECT * FROM modules WHERE dirname = 'PDlinks' |
0.000539 - SELECT count(*) FROM modules WHERE dirname = 'pcnews' AND isactive=1 |
0.000308 - SELECT * FROM modules WHERE dirname = 'pcnews' |
0.000983 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '46' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pcnews_submit') |
0.000882 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '47' AND (`gperm_groupid` = '3') AND `gperm_name` = 'pdnews_submit') |
0.000256 - SELECT COUNT(*) as cpt FROM pdnews_topics WHERE menu=1 |
0.000286 - SELECT * FROM modules WHERE dirname = 'beosnews' |
0.001048 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '48' AND (`gperm_groupid` = '3') AND `gperm_name` = 'beosnews_submit') |
0.001466 - SELECT text, submitter FROM incblock_welcometext ORDER BY RAND() LIMIT 0,1 |
0.000389 - SELECT * FROM smiles |
0.000263 - DELETE FROM online WHERE online_updated < 1744771880 |
0.000316 - SELECT COUNT(*) FROM online WHERE online_uid=0 AND online_ip='' |
0.000360 - UPDATE online SET online_updated = 1744772180, online_module = 47 WHERE online_uid = 0 AND online_ip='' |
0.000196 - SELECT online_uid, online_uname FROM online |
0.001090 - SELECT uid, uname, user_regdate FROM users WHERE user_regdate >= 1744668000 and level > 0 |
0.000303 - SELECT uid, uname from users where level > 0 order by uid DESC limit 1 |
0.000432 - SELECT COUNT(*) FROM users WHERE level > 0 |
0.000143 - SELECT COUNT(*) FROM session |
0.000694 - 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.000356 - SELECT * FROM xoopspoll_desc WHERE display=1 ORDER BY weight ASC, end_time DESC |
0.000345 - SELECT id FROM partners Where status = 1 ORDER BY hits DESC |
0.000215 - SELECT id, url, image, title FROM partners WHERE id=9 |
0.000174 - SELECT id, url, image, title FROM partners WHERE id=6 |
0.000166 - SELECT id, url, image, title FROM partners WHERE id=3 |
0.000161 - SELECT id, url, image, title FROM partners WHERE id=5 |
0.000159 - SELECT id, url, image, title FROM partners WHERE id=4 |
0.000312 - SELECT * FROM users WHERE uid = '1' |
0.001318 - SELECT * FROM pdnews_stories_files WHERE storyid=78 |
0.000281 - SELECT topic_pid, topic_title FROM pdnews_topics WHERE topic_id=3 |
0.000184 - SELECT topic_pid, topic_title FROM pdnews_topics WHERE topic_id=6 |
0.044371 - SELECT s.*, t.* FROM pdnews_stories s, pdnews_topics t WHERE (published > 0 AND published <= 1744772181) AND (expired = 0 OR expired > 1744772181) AND (s.topicid=t.topic_id) AND ihome=0 ORDER BY s.published DESC LIMIT 0, 5 |
0.001075 - SELECT storyid FROM pdnews_stories WHERE (published > 0 AND published <= 1744772181) AND (expired = 0 OR expired > 1744772181) AND topicid=3 |
0.001869 - SELECT COUNT(*) FROM group_permission WHERE (`gperm_modid` = '1' AND (`gperm_groupid` = '3') AND `gperm_name` = 'system_admin' AND `gperm_itemid` = '14') |
0.025607 - SELECT * FROM xoopscomments WHERE (`com_modid` = '47' AND `com_itemid` = '78') ORDER BY com_id DESC |