Sue's Rätselstatus

Erzeugt in 0.01483 Sekunden mit 20 Abfragen
Nettolaufzeit: 0.01483 Cps: 67
SELECT typ,item,value FROM system_sys_vars
SELECT released FROM riddle_questions WHERE released>'2025-08-06 10:24:35' AND ok=1 LIMIT 0,1
UPDATE system_users SET user_online=0 WHERE user_online=1 AND user_last_action < 1754467475
DELETE FROM system_sessions WHERE session_bot=1 OR session_time < 1754382275
SELECT count(*) FROM system_sessions WHERE uid=0 AND session_bot = 0 AND session_time > 1754467475
SELECT count(*) FROM system_users WHERE user_online=1
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('e019878fb170535dd9ac67d7d8d40353',0,99,'d849d83c',1754468675,1)
SELECT * FROM system_sessions WHERE sid='e019878fb170535dd9ac67d7d8d40353'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=23075
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=23075 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-08-06 10:24:35" GROUP BY q.riddle ORDER BY r.riddle_categorie,r.riddle_sort
SELECT count(*) FROM riddle_user_solved WHERE us_uid=23075 AND us_rid=212 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-08-06 10:24:35" 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-08-06 10:24:35" 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-08-06 10:24:35"
UPDATE system_sessions SET session_page = 'userrstate',session_time = 1754468675 ,session_data='b:0;' WHERE sid='e019878fb170535dd9ac67d7d8d40353'
INSERT INTO stats_bot_ip SET date='2025-08-06',ip='d849d83c',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='1754468735|0|0|-' WHERE typ='V' AND item='countdown'
UPDATE system_sys_vars SET value='1754468675' WHERE typ='V' AND item='session_auto_logout_lastcheck'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userrstate','1','2025-08-06','10') ON DUPLICATE KEY UPDATE count_bot=count_bot+1