Gagolga Forum

Erzeugt in 0.01584 Sekunden mit 24 Abfragen
Nettolaufzeit: 0.01584 Cps: 63
SELECT typ,item,value FROM system_sys_vars
SELECT released FROM riddle_questions WHERE released>'2025-04-28 14:39:32' AND ok=1 LIMIT 0,1
UPDATE system_users SET user_online=0 WHERE user_online=1 AND user_last_action < 1745842772
DELETE FROM system_sessions WHERE session_bot=1 OR session_time < 1745757572
SELECT count(*) FROM system_sessions WHERE uid=0 AND session_bot = 0 AND session_time > 1745842772
SELECT count(*) FROM system_users WHERE user_online=1
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('5c0c15e26684245b075429b3652ed281',0,99,'0394c891',1745843972,1)
SELECT * FROM system_sessions WHERE sid='5c0c15e26684245b075429b3652ed281'
SELECT * FROM system_users WHERE uid=0
SELECT *,categorie_count_foren+categorie_count_subforen AS categorie_count_allforen FROM forum_categories WHERE categorie_auth>=99 ORDER BY parent,categorie_sort
SELECT t.thread_title, t.thread_count_posts, t.first_post AS thread_first_post, t.last_post AS thread_last_post, t.last_post_poster AS thread_last_post_poster, t.thread_auth_post, t.thread_type, t.thread_status, t.thread_vote, f2.forum_title, f1.forum_title AS parentforum_title, f1.forum_riddle, c.categorie_title, c.categorie_count_foren+c.categorie_count_subforen AS categorie_count_allforen FROM forum_foren f1,forum_foren f2,forum_threads t, forum_categories c WHERE f1.cid=2 AND f1.fid=52 AND f1.parent=0 AND f2.cid=2 AND f2.fid=98 AND f2.parent=52 AND t.cid=2 AND t.fid=98 AND t.fid_parent=52 AND t.tid=2240 AND c.cid=2 AND c.categorie_auth>=99
SELECT SQL_CALC_FOUND_ROWS p.*, u.gid, u.user_avatar, u.user_posts, u.user_sig, u.user_sig_uid, u.user_rank, u.user_state, u.user_show_online, u.user_last_action FROM forum_posts p,system_users u WHERE p.post_deleted=0 AND p.tid=2240 AND u.uid=p.post_poster ORDER BY p.pid asc LIMIT 15,15
SELECT FOUND_ROWS() AS count
SELECT r.ur_uid,r.ur_max_level,s.us_first_solve FROM riddle_user_riddle r,riddle_user_solved s WHERE ur_uid in (9431,1687,5680,6318,6324,9328,6429,3584,4231,4201,3651,14904,2721,4791) AND us_uid=ur_uid AND ur_rid=2 AND us_rid=ur_rid AND us_lid=ur_max_level
SELECT us_uid,us_solves FROM riddle_user_solved WHERE us_uid IN (9431,1687,5680,6318,6324,9328,6429,3584,4231,4201,3651,14904,2721,4791) AND us_rid=2 AND us_lid=174
UPDATE forum_threads SET thread_views=thread_views+1 WHERE tid=2240
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2025-04-28 14:39:32" ORDER BY released LIMIT 0,1
SELECT r.rid,r.riddle_name,q.level,q.released FROM riddle_riddles r,riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released>="2025-04-28 14:39:32" ORDER BY released LIMIT 0,1
SELECT count(*) FROM riddle_riddles r, riddle_questions q WHERE r.riddle_launched=1 AND q.riddle=r.rid AND q.ok=1 AND q.released < "2025-04-28 14:39:32"
UPDATE system_sessions SET session_page = 'fposts',session_time = 1745843972 ,session_forum_cid='2',session_forum_fid='98',session_forum_tid='2240',session_forum_time=1745843972 ,session_data='b:0;' WHERE sid='5c0c15e26684245b075429b3652ed281'
INSERT INTO stats_bot_ip SET date='2025-04-28',ip='0394c891',agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',page='fposts',count=1 ON DUPLICATE KEY UPDATE count=count+1
UPDATE system_sys_vars SET value='1745844032|0|0|-' WHERE typ='V' AND item='countdown'
UPDATE system_sys_vars SET value='1745843972' WHERE typ='V' AND item='session_auto_logout_lastcheck'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('fposts','1','2025-04-28','14') ON DUPLICATE KEY UPDATE count_bot=count_bot+1