Memory Usage: 156,68 KB | Memory Peak Usage: 768 KB
1 SET charset UTF8
2 SELECT title, data FROM datastore
3 SELECT COUNT(p_id) AS allposts FROM posts
4 SELECT COUNT(t_id) AS alltopics FROM threads
5 SELECT COUNT(id) AS total FROM benutzer WHERE aktiv = '1'
6 SELECT id, user FROM benutzer WHERE aktiv = '1' ORDER BY id DESC LIMIT 1
7 REPLACE INTO datastore (title, data) VALUES ('userstats',
'a:5:{s:10:"postscount";s:2:"31";s:10:"topiccount";s:2:"23";s:13:"numbermembers";s:1:"2";s:11:"newusername";s:5:"Wolle";s:7:"user_id";s:1:"2";}')
8 REPLACE INTO datastore (title, data) VALUES ('cron', '1329966939')
9 SELECT id, user, gruppe, birthday FROM benutzer WHERE birthday LIKE '____-02-23' AND aktiv = '1' ORDER BY lower(user) ASC
10 REPLACE INTO datastore (title, data) VALUES ('birthdaycache', 'LEER')
11 REPLACE INTO datastore (title, data) VALUES ('todayuser',
'a:1:{s:4:"GAST";a:4:{s:12:"66.249.66.55";i:1329964211;s:14:"61.135.249.149";i:1329954274;s:13:"61.135.249.32";i:1329961892;s:14:"38.107.179.229";i:1329966939;}}')
12 SELECT k_id, k_show, k_name, k_description, k_threadcount, k_postcount, k_lastthread, k_lastthreadid, k_password, t_sticky, t_open, t_lastposttime FROM kategorie LEFT JOIN threads on (t_id =
k_lastthreadid AND t_cat = k_id) WHERE k_show = 'ALL' ORDER BY k_position ASC
13 SELECT SQL_CALC_FOUND_ROWS t_id, t_time, t_betreff, t_replaycount, t_userid, t_cat, t_sticky, t_open, t_lastposttime, t_lastpostid, t_lastpostname, user, id, k_show, k_name, k_description FROM
threads LEFT JOIN benutzer on (id = t_userid) LEFT JOIN kategorie on (k_id = t_cat) WHERE t_cat IN(1, 7, 2, 3, 4, 5, 6, 8) ORDER BY t_lastposttime DESC, t_time DESC LIMIT 0,5
14 SELECT FOUND_ROWS() as countrows

1329951600