Roach72's Beiträge

Erzeugt in 0.17747 Sekunden mit 10 Abfragen
Nettolaufzeit: 0.17747 Cps: 6
SELECT typ,item,value FROM system_sys_vars
SELECT * FROM system_sessions WHERE sid='fcc5ad49324c1ee15b9a0c8c79ef0c42'
SELECT * FROM system_users WHERE uid=0
SELECT * FROM system_users WHERE uid=11243
SELECT count(*) FROM forum_categories c,forum_posts p WHERE p.post_deleted=0 AND p.post_poster=11243 AND c.cid=p.cid AND c.categorie_auth>=99
SELECT pid FROM forum_categories c,forum_posts p WHERE p.post_deleted=0 AND p.post_poster=11243 AND c.cid=p.cid AND c.categorie_auth>=99 ORDER BY post_time desc LIMIT 90,15
SELECT p.pid,p.tid,p.fid,p.fid_parent,p.cid, p.post_time,p.post_subject,p.post_uid,p.post_text,t.thread_title,f.forum_title,f1.forum_title AS parentforum_title,c.categorie_count_foren+c.categorie_count_subforen AS categorie_count_allforen,c.categorie_title,count(p2.pid) AS post_page FROM forum_categories c,forum_foren f1,forum_foren f, forum_threads t,forum_posts p,forum_posts p2 WHERE p.pid in (230728,230718,230713,230711,230708,230706,230704,230702,230695,230693,230691,230688,230686,230676,230673) AND t.tid=p.tid AND f.fid=p.fid AND f1.fid=p.fid_parent AND c.cid=p.cid AND p2.post_deleted=0 AND p2.tid=p.tid AND p2.pid<=p.pid GROUP BY p.pid,t.tid,f.fid,f1.fid,c.cid ORDER BY post_time desc
UPDATE system_sessions SET session_page = 'userposts',session_time = 1745853883 WHERE sid='fcc5ad49324c1ee15b9a0c8c79ef0c42'
INSERT INTO stats_bot_ip SET date='2025-04-28',ip='038b5680',agent='Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',page='userposts',count=1 ON DUPLICATE KEY UPDATE count=count+1
INSERT INTO stats_counter_pi (id,count_bot,date,hour) VALUES ('userposts','1','2025-04-28','17') ON DUPLICATE KEY UPDATE count_bot=count_bot+1