Milhouse's Rätselstatus

Erzeugt in 0.00588 Sekunden mit 21 Abfragen
Nettolaufzeit: 0.00588 Cps: 170
SELECT typ,item,value FROM system_sys_vars
SELECT released FROM riddle_questions WHERE released>'2025-04-28 13:06:26' AND ok=1 LIMIT 0,1
UPDATE system_users SET user_online=0 WHERE user_online=1 AND user_last_action < 1745837186
DELETE FROM system_sessions WHERE session_bot=1 OR session_time < 1745751986
SELECT count(*) FROM system_sessions WHERE uid=0 AND session_bot = 0 AND session_time > 1745837186
SELECT count(*) FROM system_users WHERE user_online=1
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('3e0ad681a9333ec02215cdc035493261',0,99,'03152344',1745838386,1)
SELECT * FROM system_sessions WHERE sid='3e0ad681a9333ec02215cdc035493261'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=21926
SELECT m.*,r.riddle_name,r.riddle_max_questions,r.riddle_has_hs,r.riddle_typ,r.riddle_categorie,r.riddle_sort,count(q.level) AS levelcount FROM riddle_user_riddle m,riddle_riddles r,riddle_questions q WHERE m.ur_uid=21926 AND r.rid=m.ur_rid AND q.riddle=m.ur_rid AND r.riddle_launched=1 AND q.ok=1 AND q.released<="2025-04-28 13:06:26" GROUP BY q.riddle ORDER BY r.riddle_categorie,r.riddle_sort
SELECT count(*) FROM riddle_user_solved WHERE us_uid=21926 AND us_rid=191 AND us_solves>0
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 13:06:26" 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 13:06:26" 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 13:06:26"
UPDATE system_sessions SET session_page = 'userrstate',session_time = 1745838386 ,session_data='b:0;' WHERE sid='3e0ad681a9333ec02215cdc035493261'
INSERT INTO stats_bot_ip SET date='2025-04-28',ip='03152344',agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',page='userrstate',count=1 ON DUPLICATE KEY UPDATE count=count+1
UPDATE system_sys_vars SET value='1745838446|0|0|-' WHERE typ='V' AND item='countdown'
UPDATE system_sys_vars SET value='1745838386' WHERE typ='V' AND item='session_auto_logout_lastcheck'
UPDATE system_sys_vars SET value='11' WHERE typ='V' AND item='system_count_online_guests'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userrstate','1','2025-04-28','13') ON DUPLICATE KEY UPDATE count_bot=count_bot+1