treffPunkt - das jugendportal

Was ist treffPunkt?treffPunkt ist das regionale Jugendportal für den Landkreis Bamberg.

lerne die anderen Jugendtreffs aus der Region kennen
bleibe mit Deinen Freunden aus anderen Treffs in Kontakt
erfahre alles über die Aktionen und Events in den anderen Treffs
schau nach ob die Bilder von den letzten Veranstaltungen schon hochgeladen sind
informiere Dich über das aktuelle Programm und die Öffnungszeiten bei Dir vor Ort
helfe mit das Portal weiter zu entwickeln
lerne neue Leute mit ähnlichen Interessen aus anderen Treffs kennen

Noch nicht angemeldet ? Einen Zugang bekommst Du bei Deinem Jugendtreff vor Ort!

kein Chat aktiv!

Zwei plus Zwei ist?

(default) 26 queries took 34 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `page`	18	18	3
2	DESCRIBE `pageitem`	10	10	2
3	DESCRIBE `menu`	3	3	2
4	DESCRIBE `user`	34	34	2
5	DESCRIBE `site`	8	8	2
6	DESCRIBE `mail`	10	10	2
7	DESCRIBE `buddy`	5	5	2
8	DESCRIBE `comment`	7	7	2
9	DESCRIBE `user_site`	2	2	2
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 startpage = 1 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` = (1) ORDER BY position ASC	3	3	0
12	DESCRIBE `chat`	4	4	2
13	DESCRIBE `chatlog`	4	4	2
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	3
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	2
17	DESCRIBE `setting`	3	3	2
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
21	DESCRIBE `news`	12	12	2
22	DESCRIBE `newstype`	3	3	2
23	SELECT COUNT(*) AS `count` FROM `news` AS `News` LEFT JOIN `site` AS `Site` ON (`News`.`siteid` = `Site`.`id`) LEFT JOIN `newstype` AS `Newstype` ON (`News`.`newstypeid` = `Newstype`.`id`) WHERE `News`.`visible` = 1 and (`News`.`siteid` > -1 or `Newstype`.`newskey` in ('public') or (`News`.`siteid` = -1 and `News`.`newstypeid` = -1 and ticker = 1))	1	1	0
24	SELECT `News`.`id`, `News`.`visible`, `News`.`ticker`, `News`.`list`, `News`.`headline`, `News`.`message`, `News`.`timestamp`, `News`.`newstypeid`, `News`.`siteid`, `News`.`p_headline`, `News`.`p_message`, `News`.`p_user`, `Site`.`id`, `Site`.`name`, `Site`.`visible`, `Site`.`url`, `Site`.`root`, `Site`.`active`, `Site`.`list`, `Site`.`gmap`, `Newstype`.`id`, `Newstype`.`title`, `Newstype`.`newskey` FROM `news` AS `News` LEFT JOIN `site` AS `Site` ON (`News`.`siteid` = `Site`.`id`) LEFT JOIN `newstype` AS `Newstype` ON (`News`.`newstypeid` = `Newstype`.`id`) WHERE `News`.`visible` = 1 and (`News`.`siteid` > -1 or `Newstype`.`newskey` in ('public') or (`News`.`siteid` = -1 and `News`.`newstypeid` = -1 and ticker = 1)) ORDER BY `timestamp` desc LIMIT 10	6	6	0
25	SELECT `CheckPage`.`id`, `CheckPage`.`visible`, `CheckPage`.`siteid` FROM `page` AS `CheckPage` WHERE siteid > - 1	63	63	0
26	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` IN (58, 62, 64, 73, 78, 79, 81, 82, 83, 88, 87, 92, 93, 94, 95, 96, 99, 100, 98, 129, 109, 110, 113, 112, 101, 107, 147, 148, 103, 104, 105, 106, 114, 115, 116, 117, 118, 119, 120, 121, 126, 122, 123, 124, 132, 133, 134, 135, 136, 137, 138, 139, 143, 144, 145, 146, 149, 150, 151, 154, 153, 155, 156) ORDER BY position ASC	0	0	0

(default) 26 queries took 34 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 startpage = 1 and visible = 1 and `Page`.`public` = 1 LIMIT 1

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

DESCRIBE `news`

DESCRIBE `newstype`

SELECT COUNT(*) AS `count` FROM `news` AS `News` LEFT JOIN `site` AS `Site` ON (`News`.`siteid` = `Site`.`id`) LEFT JOIN `newstype` AS `Newstype` ON (`News`.`newstypeid` = `Newstype`.`id`) WHERE `News`.`visible` = 1 and (`News`.`siteid` > -1 or `Newstype`.`newskey` in ('public') or (`News`.`siteid` = -1 and `News`.`newstypeid` = -1 and ticker = 1))

SELECT `News`.`id`, `News`.`visible`, `News`.`ticker`, `News`.`list`, `News`.`headline`, `News`.`message`, `News`.`timestamp`, `News`.`newstypeid`, `News`.`siteid`, `News`.`p_headline`, `News`.`p_message`, `News`.`p_user`, `Site`.`id`, `Site`.`name`, `Site`.`visible`, `Site`.`url`, `Site`.`root`, `Site`.`active`, `Site`.`list`, `Site`.`gmap`, `Newstype`.`id`, `Newstype`.`title`, `Newstype`.`newskey` FROM `news` AS `News` LEFT JOIN `site` AS `Site` ON (`News`.`siteid` = `Site`.`id`) LEFT JOIN `newstype` AS `Newstype` ON (`News`.`newstypeid` = `Newstype`.`id`) WHERE `News`.`visible` = 1 and (`News`.`siteid` > -1 or `Newstype`.`newskey` in ('public') or (`News`.`siteid` = -1 and `News`.`newstypeid` = -1 and ticker = 1)) ORDER BY `timestamp` desc LIMIT 10

SELECT `CheckPage`.`id`, `CheckPage`.`visible`, `CheckPage`.`siteid` FROM `page` AS `CheckPage` WHERE siteid > - 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` IN (58, 62, 64, 73, 78, 79, 81, 82, 83, 88, 87, 92, 93, 94, 95, 96, 99, 100, 98, 129, 109, 110, 113, 112, 101, 107, 147, 148, 103, 104, 105, 106, 114, 115, 116, 117, 118, 119, 120, 121, 126, 122, 123, 124, 132, 133, 134, 135, 136, 137, 138, 139, 143, 144, 145, 146, 149, 150, 151, 154, 153, 155, 156) ORDER BY position ASC