Memory Usage: 159,14 KB | Memory Peak Usage: 1 MB
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', '1328573355')
9 SELECT id, user, gruppe, birthday FROM benutzer WHERE birthday LIKE '____-02-07' 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:27:{s:13:"95.108.248.29";i:1328483582;s:14:"119.63.196.124";i:1328484975;s:14:"188.143.234.19";i:1328488763;s:13:"61.135.249.56";i:1328489769;s:13:"119.63.196.32";i:1328496129;s:14:
"61.135.249.191";i:1328499445;s:13:"66.249.72.209";i:1328552419;s:14:"220.181.125.43";i:1328509371;s:14:"220.161.150.70";i:1328504351;s:13:"66.249.66.241";i:1328551490;s:13:"123.125.71.40";i:132850845
4;s:12:"66.249.66.55";i:1328551395;s:12:"180.76.5.140";i:1328522867;s:13:"119.63.196.93";i:1328523131;s:14:"61.135.248.210";i:1328527485;s:11:"124.115.1.7";i:1328529855;s:11:"180.76.5.98";i:1328531377
;s:14:"61.135.249.133";i:1328537521;s:11:"180.76.5.53";i:1328538716;s:13:"61.135.249.42";i:1328546505;s:12:"92.78.234.58";i:1328549677;s:12:"46.17.96.131";i:1328550998;s:12:"79.251.149.7";i:1328551595
;s:13:"61.135.249.23";i:1328557102;s:12:"69.58.178.59";i:1328563888;s:13:"61.135.249.38";i:1328565185;s:14:"38.107.179.226";i:1328573355;}}')
12 REPLACE INTO datastore (title, data) VALUES ('todayrecord',
'a:2:{s:5:"today";i:1328569200;s:14:"todaymaxonline";a:26:{i:1223330400;s:1:"0";i:1223416800;i:3;i:1223503200;i:1;i:1223676000;i:3;i:1223762400;i:1;i:1223848800;i:2;i:1223935200;i:2;i:1224021600;i:1;i
:1224194400;i:1;i:1224540000;i:2;i:1225407600;i:2;i:1225494000;i:2;i:1232060400;i:8;i:1236207600;i:1;i:1236294000;i:1;i:1237590000;i:1;i:1237935600;i:1;i:1238882400;i:1;i:1239141600;i:1;i:1239400800;i
:1;i:1239573600;i:2;i:1250719200;i:9;i:1250978400;i:6;i:1251583200;i:3;i:1255557600;i:10;i:1263682800;i:18;}}')
13 REPLACE INTO datastore (title, data) VALUES ('todayuser', 'a:1:{s:4:"GAST";a:1:{s:14:"38.107.179.226";i:1328573355;}}')
14 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
15 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
16 SELECT FOUND_ROWS() as countrows

1328569200