Melisendre's Rätselstatus

Erzeugt in 0.01819 Sekunden mit 21 Abfragen
Nettolaufzeit: 0.01819 Cps: 55
SELECT typ,item,value FROM system_sys_vars
SELECT released FROM riddle_questions WHERE released>'2026-07-18 01:42:24' AND ok=1 LIMIT 0,1
UPDATE system_users SET user_online=0 WHERE user_online=1 AND user_last_action < 1784330544
DELETE FROM system_sessions WHERE session_bot=1 OR session_time < 1784245344
SELECT count(*) FROM system_sessions WHERE uid=0 AND session_bot = 0 AND session_time > 1784330544
SELECT count(*) FROM system_users WHERE user_online=1
INSERT INTO system_sessions (sid,uid,gid,session_ip,session_time,session_bot) VALUES ('3bb3d05dcb0fb36dda1adab2148916ca',0,99,'d849d8f3',1784331744,1)
SELECT * FROM system_sessions WHERE sid='3bb3d05dcb0fb36dda1adab2148916ca'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=9258
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=9258 AND r.rid=m.ur_rid AND q.riddle=m.ur_rid AND r.riddle_launched=1 AND q.ok=1 AND q.released<="2026-07-18 01:42:24" GROUP BY q.riddle ORDER BY r.riddle_categorie,r.riddle_sort
SELECT count(*) FROM riddle_user_solved WHERE us_uid=9258 AND us_rid=20 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>="2026-07-18 01:42:24" 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>="2026-07-18 01:42:24" 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 < "2026-07-18 01:42:24"
UPDATE system_sessions SET session_page = 'userrstate',session_time = 1784331744 ,session_data='b:0;' WHERE sid='3bb3d05dcb0fb36dda1adab2148916ca'
INSERT INTO stats_bot_ip SET date='2026-07-18',ip='d849d8f3',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='1784331804|0|0|-' WHERE typ='V' AND item='countdown'
UPDATE system_sys_vars SET value='1784331744' WHERE typ='V' AND item='session_auto_logout_lastcheck'
UPDATE system_sys_vars SET value='15' WHERE typ='V' AND item='system_count_online_guests'
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userrstate','1','2026-07-18','01') ON DUPLICATE KEY UPDATE count_bot=count_bot+1