Token based voting Main Citizen proposal #4

Disapproved (2 years 6 months ago)

i4: Make a work shift plan
by Björn Swierczek
No votes (0)

Test ACA ACA Citizen proposal #3

All initiatives failed to reach the 2nd quorum (2 years 6 months ago)

i3: Renaming the ACA
by Björn Swierczek

Torino Parks and Recreation Citizen proposal #2

Disapproved (4 years 3 months ago)

i2: Choose next agenda meeting
by Claudio Schifanella
No votes (0)

Torino Parks and Recreation Citizen proposal #1

Disapproved (4 years 3 months ago)

i1: Build a park bench in the park
by Björn Swierczek
No votes (0)

What can I do here?

Login to participate

Login

I want to learn more about LiquidFeedback

Registered members (21)

marchs

Ape Unit

Claudio Schifanella

Björn Swierczek

Maximilian Mustermann

Alessandro Rosso

FernandoPt

Alberto Guffanti

Andreas

Vittorio

Pau

Pedro Etchegaray

IzziG

City Administration

liliana

GIORGINO

Diego

Ilia

John

Max

Max Mustermann

TRACE

System trace (for computer programmers purposes)

this: u=2.4, d=0.0, t=2.4 | children: u=0.0, d=0.0, t=0.0 | total: u=2.4, d=0.0, t=2.4 ms
Configuration "pt"
REQUESTED VIEW: index/index
this: u=2.8, d=4.7, t=7.2 | children: u=33.0, d=23.5, t=52.7 | total: u=35.8, d=28.2, t=59.8 ms
/main/_filter/20_session.lua
- INSERT INTO "session" ("ident", "additional_secret") VALUES ('nWrEg3uviiTcHzaeVKfuCmsS', 'bNB8cpCo8o7CG81T7qIteLcMRdsSnRyMTjpfBPYlyNkrsR0V') RETURNING "ident"; 4.7 ms
- this: u=0.4, d=0.0, t=0.4 | children: u=32.5, d=23.5, t=52.2 | total: u=33.0, d=23.5, t=52.7 ms
  /main/_filter/21_auth.lua
  - No authentication needed.
  - this: u=0.8, d=0.0, t=0.9 | children: u=31.7, d=23.5, t=51.4 | total: u=32.5, d=23.5, t=52.2 ms
    /main/_filter_view/30_navigation.lua
    - this: u=0.1, d=0.0, t=0.1 | children: u=31.6, d=23.5, t=51.3 | total: u=31.7, d=23.5, t=51.4 ms
      /main/_filter_view/34_stylesheet.lua
      - this: u=0.1, d=0.0, t=0.1 | children: u=31.4, d=23.5, t=51.1 | total: u=31.6, d=23.5, t=51.3 ms
        /main/_filter_view/36_html_title.lua
        this: u=0.9, d=0.0, t=0.9 | children: u=30.5, d=23.5, t=50.2 | total: u=31.4, d=23.5, t=51.1 ms
        EXECUTE VIEW: index/index
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: index/_sidebar_motd_public
        this: u=0.2, d=0.0, t=0.2 | children: u=0.0, d=0.0, t=0.0 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: index/_sidebar_motd_intern_top
        this: u=14.5, d=13.9, t=27.1 | children: u=6.6, d=7.1, t=12.1 | total: u=21.1, d=21.0, t=39.2 ms
        EXECUTE VIEW: issue/_list
        SELECT "unit".* FROM "unit" WHERE (id = NULL) LIMIT 1; 3.5 ms
        SELECT "unit".* FROM "unit" WHERE (attr->'hidden' ISNULL OR NOT (attr->'hidden' = 'true')) AND (active) ORDER BY name; 1.6 ms
        SELECT count(1) FROM (SELECT "issue".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_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.max_admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" LEFT OUTER JOIN issue_order_in_admission_state AS "filter_issue_order" ON filter_issue_order.id = issue.id ORDER BY issue.closed DESC NULLS FIRST, issue.accepted ISNULL, CASE WHEN issue.accepted ISNULL THEN NULL ELSE justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.max_admission_time) - now()) END, CASE WHEN issue.accepted ISNULL THEN filter_issue_order.order_in_unit ELSE NULL END, id) AS "subquery" LIMIT 1; 3.3 ms
        SELECT "issue".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_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.max_admission_time) - now()) AS "state_time_left", justify_interval(now() - issue.closed) AS "closed_ago" FROM "issue" LEFT OUTER JOIN issue_order_in_admission_state AS "filter_issue_order" ON filter_issue_order.id = issue.id ORDER BY issue.closed DESC NULLS FIRST, issue.accepted ISNULL, CASE WHEN issue.accepted ISNULL THEN NULL ELSE justify_interval(coalesce(issue.fully_frozen + issue.voting_time, issue.half_frozen + issue.verification_time, issue.accepted + issue.discussion_time, issue.created + issue.max_admission_time) - now()) END, CASE WHEN issue.accepted ISNULL THEN filter_issue_order.order_in_unit ELSE NULL END, id LIMIT 25 OFFSET 0; 1.2 ms
        SELECT "area".* FROM "area" WHERE ("area"."id" IN (6, 3, 1)); 1.2 ms
        SELECT "unit".* FROM "unit" WHERE ("unit"."id" IN (1, 11, 14)); 0.4 ms
        SELECT "policy".*, justify_interval(min_admission_time)::text AS "min_admission_time_text", justify_interval(max_admission_time)::text AS "max_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)); 1.0 ms
        SELECT "initiative".* FROM "initiative" WHERE ("initiative"."issue_id" IN (4, 3, 2, 1)) ORDER BY initiative.admitted DESC NULLS LAST, initiative.rank NULLS LAST, initiative.harmonic_weight DESC NULLS LAST, id; 1.8 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=2.5, d=3.7, t=5.5 | total: u=2.8, d=3.7, t=5.8 ms
        EXECUTE VIEW: initiative/_list
        this: u=2.5, d=3.7, t=5.5 | children: u=0.0, d=0.0, t=0.0 | total: u=2.5, d=3.7, t=5.5 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 4) ORDER BY "id" DESC LIMIT 1; 1.3 ms
        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; 2.5 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=1.6, d=1.3, t=2.5 | total: u=1.8, d=1.3, t=2.8 ms
        EXECUTE VIEW: initiative/_list
        this: u=1.1, d=1.3, t=2.1 | children: u=0.5, d=0.0, t=0.5 | total: u=1.6, d=1.3, t=2.5 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 3) ORDER BY "id" DESC LIMIT 1; 0.5 ms
        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 (3)) AND (initiator.accepted) ORDER BY member.name; 0.8 ms
        this: u=0.5, d=0.0, t=0.5 | children: u=0.0, d=0.0, t=0.0 | total: u=0.5, d=0.0, t=0.5 ms
        EXECUTE VIEW: initiative/_bargraph
        this: u=0.1, d=0.0, t=0.1 | children: u=0.8, d=1.1, t=1.7 | total: u=0.9, d=1.1, t=1.8 ms
        EXECUTE VIEW: initiative/_list
        this: u=0.8, d=1.1, t=1.7 | children: u=0.0, d=0.0, t=0.0 | total: u=0.8, d=1.1, t=1.7 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 2) ORDER BY "id" DESC LIMIT 1; 0.3 ms
        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 (2)) AND (initiator.accepted) ORDER BY member.name; 0.8 ms
        this: u=0.1, d=0.0, t=0.1 | children: u=0.9, d=0.9, t=1.6 | total: u=1.1, d=0.9, t=1.7 ms
        EXECUTE VIEW: initiative/_list
        this: u=0.9, d=0.9, t=1.6 | children: u=0.0, d=0.0, t=0.0 | total: u=0.9, d=0.9, t=1.6 ms
        EXECUTE VIEW: initiative/_list_element
        SELECT "draft".* FROM "draft" WHERE ("initiative_id" = 1) ORDER BY "id" DESC LIMIT 1; 0.3 ms
        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 (1)) AND (initiator.accepted) ORDER BY member.name; 0.6 ms
        this: u=0.3, d=0.0, t=0.3 | children: u=0.0, d=0.0, t=0.0 | total: u=0.3, d=0.0, t=0.3 ms
        EXECUTE VIEW: index/_head
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: index/_sidebar_motd
        this: u=0.6, d=0.0, t=0.6 | children: u=0.0, d=0.0, t=0.0 | total: u=0.6, d=0.0, t=0.6 ms
        EXECUTE VIEW: index/_sidebar_whatcanido
        this: u=0.5, d=1.1, t=1.4 | children: u=7.6, d=1.4, t=8.3 | total: u=8.1, d=2.5, t=9.7 ms
        EXECUTE VIEW: index/_sidebar_members
        SELECT count(1) FROM (SELECT "member".* FROM "member" WHERE (active) ORDER BY last_login DESC NULLS LAST, id DESC) AS "subquery" LIMIT 1; 1.1 ms
        this: u=4.0, d=1.4, t=4.6 | children: u=3.6, d=0.0, t=3.6 | total: u=7.6, d=1.4, t=8.3 ms
        EXECUTE VIEW: member/_list
        SELECT "member".* FROM "member" WHERE (active) AND (member.activated NOTNULL) ORDER BY last_login DESC NULLS LAST, id DESC LIMIT 50; 1.4 ms
        this: u=0.6, d=0.0, t=0.6 | children: u=0.3, d=0.0, t=0.3 | total: u=0.9, d=0.0, t=0.9 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.3, d=0.0, t=0.3 | children: u=0.0, d=0.0, t=0.0 | total: u=0.3, d=0.0, t=0.3 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.2, d=0.0, t=0.2 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.1, d=0.0, t=0.1 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member_image/_show
        this: u=0.1, d=0.0, t=0.1 | children: u=0.0, d=0.0, t=0.0 | total: u=0.1, d=0.0, t=0.1 ms
        EXECUTE VIEW: member/_show_thumb
        this: u=0.0, d=0.0, t=0.0 | children: u=0.0, d=0.0, t=0.0 | total: u=0.0, d=0.0, t=0.0 ms
        EXECUTE VIEW: member_image/_show
  - End of authentication filter.

close