treffPunkt - das jugendportal

Durchgeführt von

In Kooperation mit

Rotary Club Bamberg
Rotary Club Bamberg-Domreiter
Rotary Club Bamberg-Schloss Geyerswörth

Finanziert durch

kein Chat aktiv!

Fliegen können nicht von Regentropfen erwischt werden ...

(default) 20 queries took 15 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `page`	18	18	1
2	DESCRIBE `pageitem`	10	10	1
3	DESCRIBE `menu`	3	3	1
4	DESCRIBE `user`	34	34	1
5	DESCRIBE `site`	8	8	1
6	DESCRIBE `mail`	10	10	1
7	DESCRIBE `buddy`	5	5	1
8	DESCRIBE `comment`	7	7	1
9	DESCRIBE `user_site`	2	2	1
10	SELECT `Page`.`id`, `Page`.`position`, `Page`.`visible`, `Page`.`startpage`, `Page`.`title`, `Page`.`pagekey`, `Page`.`content`, `Page`.`menuid`, `Page`.`parentid`, `Page`.`type`, `Page`.`public`, `Page`.`loginpage`, `Page`.`siteid`, `Page`.`htmltitle`, `Page`.`newspage`, `Page`.`p_title`, `Page`.`p_content`, `Page`.`p_user` FROM `page` AS `Page` WHERE (id = 'traeger' or pagekey = 'traeger') and visible = 1 and `Page`.`public` = 1 LIMIT 1	1	1	0
11	SELECT `Pageitem`.`id`, `Pageitem`.`position`, `Pageitem`.`type`, `Pageitem`.`pageid`, `Pageitem`.`visible`, `Pageitem`.`fontcolor`, `Pageitem`.`content`, `Pageitem`.`menuid`, `Pageitem`.`plugin`, `Pageitem`.`options` FROM `pageitem` AS `Pageitem` WHERE `Pageitem`.`visible` = 1 AND `Pageitem`.`pageid` = (5) ORDER BY position ASC	0	0	0
12	DESCRIBE `chat`	4	4	1
13	DESCRIBE `chatlog`	4	4	1
14	SELECT `Chat`.`id`, `Chat`.`title`, `Chat`.`message`, `Chat`.`open` FROM `chat` AS `Chat` WHERE 1 = 1 LIMIT 1	1	1	0
15	DESCRIBE `question`	6	6	2
16	SELECT `Question`.`id`, `Question`.`visible`, `Question`.`headline`, `Question`.`content`, `Question`.`questiontypeid`, `Question`.`timestamp` FROM `question` AS `Question` WHERE visible=1 ORDER BY rand() ASC LIMIT 1	1	1	1
17	DESCRIBE `setting`	3	3	1
18	SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `setting` AS `Setting` WHERE 1 = 1	18	18	0
19	SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`menukey` FROM `menu` AS `Menu` WHERE 1 = 1	2	2	0
20	SELECT `Page`.`id`, `Page`.`position`, `Page`.`visible`, `Page`.`startpage`, `Page`.`title`, `Page`.`pagekey`, `Page`.`content`, `Page`.`menuid`, `Page`.`parentid`, `Page`.`type`, `Page`.`public`, `Page`.`loginpage`, `Page`.`siteid`, `Page`.`htmltitle`, `Page`.`newspage`, `Page`.`p_title`, `Page`.`p_content`, `Page`.`p_user` FROM `page` AS `Page` WHERE `Page`.`visible` = 1 and `Page`.`public` = 1 AND `Page`.`menuid` IN (1, 4) ORDER BY position ASC	18	18	0

(default) 20 queries took 15 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `page`

DESCRIBE `pageitem`

DESCRIBE `menu`

DESCRIBE `user`

DESCRIBE `site`

DESCRIBE `mail`

DESCRIBE `buddy`

DESCRIBE `comment`

DESCRIBE `user_site`

SELECT `Page`.`id`, `Page`.`position`, `Page`.`visible`, `Page`.`startpage`, `Page`.`title`, `Page`.`pagekey`, `Page`.`content`, `Page`.`menuid`, `Page`.`parentid`, `Page`.`type`, `Page`.`public`, `Page`.`loginpage`, `Page`.`siteid`, `Page`.`htmltitle`, `Page`.`newspage`, `Page`.`p_title`, `Page`.`p_content`, `Page`.`p_user` FROM `page` AS `Page` WHERE (id = 'traeger' or pagekey = 'traeger') and visible = 1 and `Page`.`public` = 1 LIMIT 1

SELECT `Pageitem`.`id`, `Pageitem`.`position`, `Pageitem`.`type`, `Pageitem`.`pageid`, `Pageitem`.`visible`, `Pageitem`.`fontcolor`, `Pageitem`.`content`, `Pageitem`.`menuid`, `Pageitem`.`plugin`, `Pageitem`.`options` FROM `pageitem` AS `Pageitem` WHERE `Pageitem`.`visible` = 1 AND `Pageitem`.`pageid` = (5) ORDER BY position ASC

DESCRIBE `chat`

DESCRIBE `chatlog`

SELECT `Chat`.`id`, `Chat`.`title`, `Chat`.`message`, `Chat`.`open` FROM `chat` AS `Chat` WHERE 1 = 1 LIMIT 1

DESCRIBE `question`

SELECT `Question`.`id`, `Question`.`visible`, `Question`.`headline`, `Question`.`content`, `Question`.`questiontypeid`, `Question`.`timestamp` FROM `question` AS `Question` WHERE visible=1 ORDER BY rand() ASC LIMIT 1

DESCRIBE `setting`

SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value` FROM `setting` AS `Setting` WHERE 1 = 1

SELECT `Menu`.`id`, `Menu`.`title`, `Menu`.`menukey` FROM `menu` AS `Menu` WHERE 1 = 1

SELECT `Page`.`id`, `Page`.`position`, `Page`.`visible`, `Page`.`startpage`, `Page`.`title`, `Page`.`pagekey`, `Page`.`content`, `Page`.`menuid`, `Page`.`parentid`, `Page`.`type`, `Page`.`public`, `Page`.`loginpage`, `Page`.`siteid`, `Page`.`htmltitle`, `Page`.`newspage`, `Page`.`p_title`, `Page`.`p_content`, `Page`.`p_user` FROM `page` AS `Page` WHERE `Page`.`visible` = 1 and `Page`.`public` = 1 AND `Page`.`menuid` IN (1, 4) ORDER BY position ASC