All LEGO Polls

NOT IN SCHEDULED TIMEFRAME

What color would you prefer the exterior of 10325-1 - Alpine Lodge to be?

I like it as it is (Dark Orange)
39%
Dark Brown
10%
Dark Tan
3%
Medium Nougat
13%
Reddish Brown
18%
Medium Brown
11%
Warm Tan
5%
Something Else (Leave in Comments)
1%
Login to vote!
21 Comments 1438 votes
NOT IN SCHEDULED TIMEFRAME

Do you want weight information added to parts? (Note that this info is not available from LEGO so will be 100% reliant on Users)

Yes
51%
No
49%
Login to vote!
137 Comments 1439 votes
NOT IN SCHEDULED TIMEFRAME

What set should Jared build on the next Live Stream Build on Aug 24th?

Login to vote!
3 Comments 356 votes
NOT IN SCHEDULED TIMEFRAME

Who's getting a Sonic the Hedgehog set?

Yes, how could anyone resist!
13%
Not my thing
87%
Login to vote!
18 Comments 624 votes
NOT IN SCHEDULED TIMEFRAME

Jaredhinton will be hosting Rebrickables first Live Build stream on Youtube on Thursday June 29th at 5pm UTC. Will you be watching?

Yes
27%
No
73%
Login to vote!
36 Comments 465 votes
NOT IN SCHEDULED TIMEFRAME

Do you want to be able to manage instruction manuals in your Rebrickable collection?

Yes
77%
No
23%
Login to vote!
28 Comments 1085 votes
NOT IN SCHEDULED TIMEFRAME

With the introduction of the new transparent color in Set 75346-1, what should we do?

Keep Trans-Black as is. Add a new color with a new name (decided in a poll later if this wins).
33%
Follow other sites and change Trans-Black to Trans-Brown. Then add a new color called Trans-Black
67%
Login to vote!
60 Comments 1198 votes
NOT IN SCHEDULED TIMEFRAME

Excited for the new Sonic Theme?

Yes, looks great
18%
Yes, but I was hoping for more
9%
No, I'm super disappointed
4%
No, Sonic is not my thing
70%
Login to vote!
14 Comments 1033 votes
NOT IN SCHEDULED TIMEFRAME

How often do you buy (and use) multiple copies of the same set?

Login to vote!
66 Comments 977 votes
NOT IN SCHEDULED TIMEFRAME

You get to bring back 1 retired color, which one? (I have limited the very long list to the most common retired colors)

Login to vote!
35 Comments 946 votes
DJDT

Time

Resource usage

Resource Value
User CPU time 218.671 msec
System CPU time 2.232 msec
Total CPU time 220.903 msec
Elapsed time 247.460 msec
Context switches 68 voluntary, 9 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 19.43 ms (36 queries including 33 similar and 6 duplicates )
Query Timeline Time (ms) Action
SELECT COUNT(*) AS "__count"
  FROM "polls_poll"
 WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-01-22T05:05:12.321735+00:00'::timestamptz)SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-01-22T05:05:12.321735+00:00'::timestamptz)
 0.35

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 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
 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/./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(252)
  country = Country.objects.get(iso=country_code)
412 </a>
413 </li>
414 <li class="hidden-xs">
415 {% geo_currency request.user %}
416 </li>
417 {% comment %}
418 <li class="hidden-xs hidden-sm">
419 <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/base_root.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-01-22T05:05:12.321735+00:00'::timestamptz)
 ORDER BY "polls_poll"."start_date" DESC
 LIMIT 10
OFFSET 30SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-01-22T05:05:12.321735+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 30
 0.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})
1 {% load rb_settings %}
2 {% if items %}
3 <div class="text-right">
4 <ul class="pagination-btns">
5 {% if items.has_previous %}
6 <li><a href="?{% url_replace 'page' items.previous_page_number %}{{ anchor|default_if_none:'' }}"><button class="btn btn-default btn-sm">&lt; <span class="hidden-xs">Prev</span></button></a></li>

/home/nathan/rb/site/digg_paginator/templates/rb/render_paginator.html
SELECT "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 39)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 39) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		1.96

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(77)
  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" = '39' 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" = '39' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.65

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 39)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 39)
10 similar queries. 		0.22

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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 35)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 35) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		1.33

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(77)
  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">
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_binary.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" = '35' 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" = '35' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.85

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 35)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 35)
10 similar queries. 		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/./polls/models.py in get_num_votes(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 38)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 38) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.56

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(85)
  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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 38)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 38) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.26

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(85)
  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" = '38' 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" = '38' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.33

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 38)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 38)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 37)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 37) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		0.65

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(77)
  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">
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_binary.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" = '37' 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" = '37' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.37

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 37)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 37)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 36)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 36) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		0.88

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(77)
  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">
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_binary.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" = '36' 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" = '36' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.72

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 36)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 36)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 34)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 34) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		0.84

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(77)
  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">
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_binary.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" = '34' 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" = '34' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.61

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 34)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 34)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 33)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 33) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		1.20

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(77)
  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" = '33' 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" = '33' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.58

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 33)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 33)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."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" = 31)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
 ORDER BY "polls_polloptions"."value" ASCSELECT ••• 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" = 31) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC
7 similar queries. 		0.88

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(77)
  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" = '31' 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" = '31' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.37

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 31)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 31)
10 similar queries. 		0.30

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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 30)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 30) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.79

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(85)
  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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 30)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 30) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.62

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(85)
  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" = '30' 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" = '30' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.79

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 30)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 30)
10 similar queries. 		0.21

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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 29)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 29) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.78

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(85)
  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",
       "polls_polloptions"."text",
       "polls_polloptions"."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" = 29)
 GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value"
 ORDER BY 4 DESCSELECT ••• 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" = 29) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC
6 similar queries. Duplicated 2 times. 		0.38

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(85)
  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" = '29' 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" = '29' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		0.40

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()
42 {% else %}
43 <span class="hidden-xs">This Poll is running from {{ poll.start_date }} to {{ poll.end_date }}.</span></i>
44 {% endif %}
45 {% get_comment_count for poll as num_comments %}
46 <span class="pull-right">
47 <a href="{{ poll.get_absolute_url }}">
48 <i class="fa fa-comment-o"></i> {{ num_comments }} Comment{{ num_comments|pluralize }}
49 </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" = 29)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 29)
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(92)
  return PollVote.objects.filter(poll=self, option__isnull=False).aggregate(Count('id'))['id__count'] or 0
50 </span>
51 {% if poll.user_vote or poll.is_past %}
52 <span class="pull-right mr-30">
53 <i class="fa fa-check-square-o"></i> {{ poll.get_num_votes }} votes
54 </span>
55 {% endif %}
56 {% if request.user.is_poll_manager %}
57 <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.