test - Initiative i4 - Pirate Feedback - Pirate Feedback Bastelinstanz/noch nicht die erste Kammer der SME der Piraten NDS

Abgeschlossen (ohne Gewinner) · vor 7 Jahren 6 Monaten 28 Tagen

i4: test

Initiative i4: test

Ja: 2 (1+1) / 100% (50%+50%) · Enthaltung: 0 (0+0) · Nein: 0 (0+0) / 0% (0%+0%) · Nicht angenommen (Rang 1)

Letzter Entwurf vom 25.06.2017 um 20:35 Uhr · Quelltext

test

Anregungen

Keine Anregungen

Pro-Argumente

Keine Argumente

Kontra-Argumente

Keine Argumente

TRACE

Configuration "myconfig"
- Configuration "init"
REQUESTED VIEW: initiative/show
/main/_filter/20_session.lua
- INSERT INTO "session" ("additional_secret", "ident") VALUES ('pJUrAcxZnS4wEafuIkq7KtUv8oTGfilb', 'qWXC7ggkQQk8sHM65U2rujVSbIe1DTKn') RETURNING ("ident");
- /main/_filter/21_auth.lua
  - No authentication needed.
  - /main/_filter_view/30_navigation.lua
    - EXECUTE VIEW: index/_menu
    - /main/_filter_view/32_searchbox.lua
      - /main/_filter_view/33_help_hidden.lua
        /main/_filter_view/34_stylesheet.lua
        /main/_filter_view/36_html_title.lua
        /main/_filter_view/38_motd.lua
        EXECUTE VIEW: initiative/show
        SELECT "initiative".* FROM "initiative" WHERE (id = 4) LIMIT 1;
        EXECUTE VIEW: initiative/_show
        SELECT "issue".*, justify_interval(admission_time)::text AS "admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text", justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" WHERE ("issue"."id" IN (3));
        EXECUTE VIEW: issue/_head
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (1));
        EXECUTE VIEW: area/_head
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1));
        EXECUTE VIEW: unit/_head
        EXECUTE VIEW: delegation/_info
        EXECUTE VIEW: delegation/_info
        SELECT "member".*, "initiator"."initiative_id" AS "mm_ref_", initiator.accepted AS "accepted" FROM "member" INNER JOIN "initiator" ON "initiator"."member_id" = "member"."id" WHERE ("initiator"."initiative_id" IN (4)) AND (initiator.accepted) ORDER BY member.name;
        EXECUTE VIEW: issue/_show
        EXECUTE VIEW: delegation/_info
        SELECT "policy".*, justify_interval(admission_time)::text AS "admission_time_text", justify_interval(discussion_time)::text AS "discussion_time_text", justify_interval(verification_time)::text AS "verification_time_text", justify_interval(voting_time)::text AS "voting_time_text" FROM "policy" WHERE ("policy"."id" IN (1));
        EXECUTE VIEW: initiative/_list
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (3)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id;
        EXECUTE VIEW: initiative/_list_element
        EXECUTE VIEW: initiative/_battles
        SELECT "initiative".*, winning_battle.count AS "winning_count", losing_battle.count AS "losing_count", winning_battle.direct_count AS "winning_direct_count", losing_battle.direct_count AS "losing_direct_count" FROM "initiative" INNER JOIN battle AS "winning_battle" ON winning_battle.winning_initiative_id = 4 AND winning_battle.losing_initiative_id = initiative.id INNER JOIN battle AS "losing_battle" ON losing_battle.losing_initiative_id = 4 AND losing_battle.winning_initiative_id = initiative.id ORDER BY rank;
        SELECT count(1) FROM (SELECT "initiative".* FROM "initiative" WHERE (issue_id = 3) AND (admitted)) AS "subquery" LIMIT 1;
        SELECT count(1) FROM (SELECT "draft".* FROM "draft" WHERE ("draft"."initiative_id" IN (4)) ORDER BY "id" DESC) AS "subquery" LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 4) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 4) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 4) ORDER BY "id" DESC LIMIT 1;
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 4) ORDER BY "id" DESC LIMIT 1;
        SELECT "rendered_draft".* FROM "rendered_draft" WHERE (draft_id = 4) AND (format = 'html') LIMIT 1;
        EXECUTE VIEW: suggestion/_list
        SELECT count(1) FROM (SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (4)) ORDER BY proportional_order NULLS LAST, plus2_unfulfilled_count + plus1_unfulfilled_count DESC, plus2_unfulfilled_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "suggestion".* FROM "suggestion" WHERE ("suggestion"."initiative_id" IN (4)) ORDER BY proportional_order NULLS LAST, plus2_unfulfilled_count + plus1_unfulfilled_count DESC, plus2_unfulfilled_count DESC, id LIMIT 20 OFFSET 0;
        EXECUTE VIEW: argument/_list
        SELECT count(1) FROM (SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (4)) AND (side = 'pro') ORDER BY plus_count - minus_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (4)) AND (side = 'pro') ORDER BY plus_count - minus_count DESC, id LIMIT 10 OFFSET 0;
        EXECUTE VIEW: argument/_list
        SELECT count(1) FROM (SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (4)) AND (side = 'contra') ORDER BY plus_count - minus_count DESC, id) AS "subquery" LIMIT 1;
        SELECT "argument".* FROM "argument" WHERE ("argument"."initiative_id" IN (4)) AND (side = 'contra') ORDER BY plus_count - minus_count DESC, id LIMIT 10 OFFSET 0;
  - End of authentication filter.
Finished after 107.4 ms (78.5 ms CPU)