Weekend Poll: Brickheadz?

No more please, I've had enough
68%
Bring 'em on, lots more characters need Headz-ifying
32%
Login to vote!
24 Comments 511 votes

Weekend Poll: Who like doing these polls?

Yes, I love them!
83%
Absolutely not, I'd never vote in something so frivolous
6%
What's a poll?
11%
Login to vote!
29 Comments 508 votes

Should we rename Trans-Opal colors to group them together?

Yes, to Trans-opal [COLOR]
60%
Yes, to Opal-trans [COLOR]
7%
No, leave them as they are - Trans-[COLOR] Opal
34%
Login to vote!
28 Comments 1003 votes

Weekend Poll: What is best, Old Grays or New Bluish Grays?

Login to vote!
37 Comments 360 votes

Weekend Poll: Which theme is having a better 2024 so far?

Animal Crossing
3%
City
9%
Classic
1%
Collectible Minifigs
3%
Creator 3-in-1
11%
Disney
2%
Dreamzzz
2%
Friends
3%
Harry Potter
3%
Icons
6%
Ideas
5%
Minecraft
1%
Monkie Kid
0%
Ninjago
2%
Speed Champions
13%
Star Wars
19%
Super Heroes Marvel
1%
Super Mario
0%
Technic
16%
Login to vote!
70 Comments 1250 votes

What bird would you like to see in a future Icons set?

Flamingo
12%
Bald Eagle
31%
Crane
9%
Humming Bird
14%
Bird of Paradise
7%
Pelican
9%
Pigeon
12%
Other - tell us in comments
6%
Login to vote!
121 Comments 868 votes

Weekend Poll: What food are you missing in LEGO minifig scale most? (As a molded part not a print)

Pineapple
16%
Strawberry
8%
Cheese
10%
Broccoli
9%
Taco
26%
Donut
12%
None, the Hot Dog is all I need
15%
Other (leave a comment)
3%
Login to vote!
47 Comments 699 votes

Weekend Poll: What CMF License would you want to see most?

Star Wars
34%
Super Mario (Minifig Scale)
8%
Lord of the Rings / Hobbit
20%
Minecraft
3%
Star Trek
11%
Studio Ghibli
10%
Doctor Who
7%
Other (leave a comment)
8%
Login to vote!
116 Comments 865 votes

Should Brick-Built figures be added to the database?

Login to vote!
19 Comments 437 votes

Weekend Poll: What's better?

Studded Technic (Old-school - Bricks)
32%
Studless Technic (Modern - Beams)
68%
Login to vote!
34 Comments 454 votes
DJDT

Time

Resource usage

Resource Value
User CPU time 139.336 msec
System CPU time 0.936 msec
Total CPU time 140.272 msec
Elapsed time 172.868 msec
Context switches 43 voluntary, 4 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 33.90 ms (36 queries including 32 similar and 4 duplicates )
Query Timeline Time (ms) Action
SELECT COUNT(*) AS "__count"
  FROM
"polls_poll"
 WHERE
("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz)
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz)
0.27

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(30)
  polls = paginator.get_page(request.GET.get('page', 1))

/home/nathan/rb/site/./digg_paginator/utils.py in get_page(274)
  return self.page(page)

/home/nathan/rb/site/./digg_paginator/utils.py in page(199)
  page = super(DiggPaginator, self).page(number, *args, **kwargs)

/home/nathan/rb/site/./digg_paginator/utils.py in page(47)
  return super(ExPaginator, self).page(number)

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM
"countries_plus_country"
 WHERE
"countries_plus_country"."iso" = 'US'
 LIMIT
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(253)
  country = Country.objects.get(iso=country_code)

74 </a>
75 </li>
76 <li>
77 {% geo_currency request.user %}
78 </li>
79 {% comment %}
80 <li class="hidden-xs hidden-sm">
81 <a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>

/home/nathan/rb/site/rb/templates/rb/includes/topbar.html

SELECT "polls_poll"."id",
       "polls_poll"."start_date",
       "polls_poll"."end_date",
       "polls_poll"."description",
       "polls_poll"."poll_type",
       "polls_poll"."is_active"
  FROM
"polls_poll"
 WHERE
("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz)
 ORDER BY
"polls_poll"."start_date" DESC
 LIMIT
10
OFFSET
20
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:00:54.195356+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 20
0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

1 {% load rb_settings %}
2 {% if items %}
3 <nav class="rb-pager rb-pager--right" aria-label="Pagination">
4 <ul class="rb-pager__list">
5 {% if items.has_previous %}
6 <li class="rb-pager__item">

/home/nathan/rb/site/digg_paginator/templates/rb/render_paginator_new.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.29

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT "django_content_type"."id",
       "django_content_type"."app_label",
       "django_content_type"."model"
  FROM
"django_content_type"
 WHERE
("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll')
 LIMIT
21
SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll') LIMIT 21
0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(88)
  qs = super().get_queryset(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(17)
  ctype, object_pk = self.get_target_ctype_pk(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in get_target_ctype_pk(111)
  return ContentType.objects.get_for_model(obj), obj.pk

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '55' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '55' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.59

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 55)
10 similar queries.
0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.67

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.82

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)
10 similar queries.
0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '53' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '53' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.71

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 53)
10 similar queries.
0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 similar queries. Duplicated 2 times.
0.31

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(90)
  total = sum(v['num'] for v in votes)

2
3 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
4 <div id="poll_pie_{{ poll.id }}"></div>
5 {% for vote in poll.get_results %}
6 {% empty %}
7 <p class="text-center">No results to be displayed yet</p>
8 {% endfor %}
9

/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 similar queries. Duplicated 2 times.
0.29

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(90)
  total = sum(v['num'] for v in votes)

29 <script type="text/javascript">
30 var chart_data = [
31 {# escapejs required to render quotes in option text #}
32 {% for vote in poll.get_results %}
33 { name: '{{ vote.option__text|escapejs }}', y: {{ vote.pct }} },
34 {% endfor %}
35 ];
36 Highcharts.chart('poll_pie_{{ poll.id }}', {

/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '52' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '52' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
2.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 52)
10 similar queries.
0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '51' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '51' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
2.87

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 51)
10 similar queries.
0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '49' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '49' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
4.00

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 49)
10 similar queries.
0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.41

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '50' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '50' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.70

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 50)
10 similar queries.
0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.53

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '48' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '48' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
3.90

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 48)
10 similar queries.
0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 similar queries. Duplicated 2 times.
0.83

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(90)
  total = sum(v['num'] for v in votes)

2
3 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
4 <div id="poll_pie_{{ poll.id }}"></div>
5 {% for vote in poll.get_results %}
6 {% empty %}
7 <p class="text-center">No results to be displayed yet</p>
8 {% endfor %}
9

/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 similar queries. Duplicated 2 times.
0.28

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(90)
  total = sum(v['num'] for v in votes)

29 <script type="text/javascript">
30 var chart_data = [
31 {# escapejs required to render quotes in option text #}
32 {% for vote in poll.get_results %}
33 { name: '{{ vote.option__text|escapejs }}', y: {{ vote.pct }} },
34 {% endfor %}
35 ];
36 Highcharts.chart('poll_pie_{{ poll.id }}', {

/home/nathan/rb/site/polls/templates/polls/poll_options_selection.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '45' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '45' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.46

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 45)
10 similar queries.
0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.42

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_results(82)
  total = sum(v['num'] for v in votes)

1 {% if poll.user_vote or request.user.is_anonymous or poll.is_past %}
2 {% for vote in poll.get_results %}
3 <div class="row pb-6">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

/home/nathan/rb/site/polls/templates/polls/poll_options_list.html

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '47' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '47' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.86

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(72)
  context[self.as_varname] = self.get_context_value_from_queryset(context, qs)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_context_value_from_queryset(116)
  return qs.count()

45 {% else %}
46 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
47 {% endif %}
48 {% get_comment_count for poll as num_comments %}
49 <span class="pull-right">
50 <a href="{{ poll.get_absolute_url }}">
51 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
52 </a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 47)
10 similar queries.
0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in all_polls(36)
  return render(request, 'polls/all_polls.html', {'polls': polls})

/home/nathan/rb/site/./polls/models.py in get_num_votes(97)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0

53 </span>
54 {% if poll.user_vote or poll.is_past %}
55 <span class="pull-right mr-30">
56 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
57 </span>
58 {% endif %}
59 {% if request.user.is_poll_manager %}
60 <a href="{% url 'edit_poll' poll.id %}"><span class="pull-right text-danger mr-30"><i class="fa fa-edit"></i> Edit {{ poll.id }}</span></a>

/home/nathan/rb/site/polls/templates/polls/render_poll.html

Log messages

No messages logged.