Neu Diskussion Eingefroren Abstimmung Abgeschlossen Abgebrochen
TRACE
Configuration "piraten-lsa"
Configuration "default"
REQUESTED VIEW: index/index
/main/_filter/20_session.lua
INSERT INTO "session" ("additional_secret", "ident") VALUES ('q1k7TOr7RQhHTAM8qv6BE9JXfvX2jbsa', 'VFLEp0IzNSTvCab4wdo7drIwPoUwNIS5') RETURNING ("ident");
/main/_filter/21_auth.lua
303 REDIRECT TO VIEW: area/list
Finished after 21.9 ms (0.0 ms CPU)
Configuration "piraten-lsa"
Configuration "default"
REQUESTED VIEW: area/list
/main/_filter/20_session.lua
SELECT "session".* FROM "session" WHERE (ident = 'VFLEp0IzNSTvCab4wdo7drIwPoUwNIS5') LIMIT 1;
/main/_filter/21_auth.lua
No authentication needed.
/main/_filter_view/30_navigation.lua
SELECT "member".* FROM "member" ORDER BY member.name;
/main/_filter_view/31_logout_button.lua
/main/_filter_view/32_searchbox.lua
/main/_filter_view/33_help_hidden.lua
/main/_filter_view/34_stylesheet.lua
/main/_filter_view/35_openid.lua
/main/_filter_view/36_html_title.lua
EXECUTE VIEW: area/list
EXECUTE VIEW: area/_list
SELECT area.id, area.name, member_weight, direct_member_count, (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted ISNULL AND issue.closed ISNULL) AS "issues_new_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.accepted NOTNULL AND issue.half_frozen ISNULL AND issue.closed ISNULL) AS "issues_discussion_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.half_frozen NOTNULL AND issue.fully_frozen ISNULL AND issue.closed ISNULL) AS "issues_frozen_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed ISNULL) AS "issues_voting_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen NOTNULL AND issue.closed NOTNULL) AS "issues_finished_count", (SELECT COUNT(*) FROM issue WHERE issue.area_id = area.id AND issue.fully_frozen ISNULL AND issue.closed NOTNULL) AS "issues_cancelled_count", 0 AS "issues_to_vote_count" FROM "area" WHERE (active = TRUE) GROUP BY area.id, area.name, member_weight, direct_member_count ORDER BY area.member_weight DESC;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;
SELECT "member_count".* FROM "member_count" LIMIT 1;