All LEGO Polls

With most Pokemon coming from Gen I so far, what generation do you want to see more of?

Generation I (1996–1999) (Red, Blue, Green, Yellow)
35%
Generation II (1999–2002) (Gold, Silver, Crystal)
10%
Generation III (2002–2006) (Ruby, Sapphire, Emerald)
13%
Generation IV (2006–2010) (Diamond, Pearl, Platinum)
10%
Generation V (2010–2013) (Black (2), White (2))
7%
Generation VI (2013–2015) (X, Y)
6%
Generation VII (2016–2019) (Sun, Moon)
8%
Generation VIII (2019–2022) (Sword, Shield)
6%
Generation IX (2022–Present) (Scarlet, Violet)
7%
Login to vote!
129 Comments 1652 votes

What color Spaceman is needed next?

Blue-Violet
7%
Bright Light Orange
2%
Bright Light Yellow
2%
Bright Pink
2%
Coral
5%
Dark Azure
6%
Dark Blue (All Parts)
6%
Dark Bluish Gray
2%
Dark Brown
1%
Dark Green
4%
Dark Orange
2%
Dark Red
8%
Dark Tan
1%
Flat Silver
3%
Light Aqua
1%
Light Bluish Gray (All Parts)
3%
Light Nougat
1%
Lime
16%
Magenta
2%
Medium Azure
3%
Medium Lavender
3%
Olive Green
2%
Pearl Titanium
4%
Reddish Orange
3%
Sand Blue
3%
Sand Green
3%
Tan
2%
Vibrant Yellow
1%
Warm Pink
1%
Yellowish Green
2%
Login to vote!
115 Comments 2667 votes

If you were to purchase 72153-1 - Venusaur, Charizard and Blastoise, would you want it with or without the base?

Set is perfect as is! The scenery elevates the display.
42%
I want the Pokemon only with a 30% discount.
58%
Login to vote!
65 Comments 913 votes

SMART Play?

Login to vote!
175 Comments 613 votes

With the introduction of Paper Bags, should we continue including photos of them in reviews?

Login to vote!
92 Comments 866 votes

Weekend Poll: The term C-model, what does that mean to you?

Login to vote!
75 Comments 622 votes

How did the Admin Team do on the Top 10 of 2025?

Login to vote!
88 Comments 737 votes

If LEGO makes the Game Boy Color, what color should it be?

Berry (red)
14%
Grape (purple)
12%
Kiwi (lime)
16%
Dandelion (yellow)
10%
Teal (dark azure)
15%
Atomic Purple (trans-purple)
32%
Login to vote!
50 Comments 2265 votes

Be honest, who keeps their boxes and how?

Yes, pristine in original shape
31%
Yes, flattened because I don’t own a house the size of Wayne Manor
24%
Yes, only partially, cutting them up for crafts or to frame.
4%
No, but I wish I could
17%
No, that’s crazy
24%
Login to vote!
186 Comments 6081 votes

Seeing all the different holidays and traditions across the world, what is your preferred time to start publishing Advent Calendar reviews?

Early September
6%
End of September
4%
Early October
5%
End of October
5%
Early November
16%
End of November
13%
Open a door each day in December
50%
Login to vote!
52 Comments 812 votes
DJDT

Time

Resource usage

Resource Value
User CPU time 141.765 msec
System CPU time 0.000 msec
Total CPU time 141.765 msec
Elapsed time 224.828 msec
Context switches 45 voluntary, 1 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 84.49 ms (38 queries including 34 similar and 8 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-15T23:48:55.506206+00:00'::timestamptz)SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-15T23:48:55.506206+00:00'::timestamptz)
 0.37

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.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/./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-15T23:48:55.506206+00:00'::timestamptz)
 ORDER BY "polls_poll"."start_date" DESC
 LIMIT 10SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-15T23:48:55.506206+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10
 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})
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" = 75)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 75) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		11.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 "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 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll') LIMIT 21
 0.11

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" = '75' 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" = '75' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		6.95

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" = 75)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 75)
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(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" = 74)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 74) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		1.68

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" = '74' 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" = '74' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		6.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" = 74)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 74)
10 similar queries. 		0.27

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" = 73)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 73) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		0.52

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" = '73' 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" = '73' 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" = 73)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 73)
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" = 72)
 GROUP BY 1,
       2,
       3
 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" = 72) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		0.76

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" = 72)
 GROUP BY 1,
       2,
       3
 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" = 72) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		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/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" = '72' 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" = '72' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		7.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()
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" = 72)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 72)
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",
       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" = 70)
 GROUP BY 1,
       2,
       3
 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" = 70) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		0.57

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" = 70)
 GROUP BY 1,
       2,
       3
 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" = 70) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		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(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" = '70' 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" = '70' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		5.95

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" = 70)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 70)
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",
       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" = 71)
 GROUP BY 1,
       2,
       3
 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" = 71) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		0.34

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" = 71)
 GROUP BY 1,
       2,
       3
 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" = 71) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		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/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" = '71' 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" = '71' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		5.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/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" = 71)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 71)
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" = 69)
 GROUP BY 1,
       2,
       3
 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" = 69) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		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(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" = 69)
 GROUP BY 1,
       2,
       3
 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" = 69) GROUP BY 1, 2, 3 ORDER BY 4 DESC
8 similar queries. Duplicated 2 times. 		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/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" = '69' 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" = '69' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		5.76

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" = 69)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 69)
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" = 67)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 67) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		1.55

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" = '67' 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" = '67' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		3.35

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" = 67)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 67)
10 similar queries. 		0.24

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" = 68)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 68) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		2.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(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" = '68' 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" = '68' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		10.07

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" = 68)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 68)
10 similar queries. 		0.47

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" = 66)
 GROUP BY 1,
       2,
       3,
       4
 ORDER BY 3 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" = 66) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
6 similar queries. 		0.99

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" = '66' 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" = '66' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries. 		3.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()
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" = 66)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 66)
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

Log messages

No messages logged.