All LEGO Polls | Rebrickable

NOT IN SCHEDULED TIMEFRAME

What brought you out of your dark ages?

Having kids

16%

201

Boredom

COVID-19

11%

138

A specific set

19%

247

What Dark Age?

30%

377

Other

18%

224

This Poll ran from Oct. 6, 2021, midnight to Oct. 20, 2021, midnight. 78 Comments 1270 votes

NOT IN SCHEDULED TIMEFRAME

Where do you prefer to buy your individual/loose LEGO parts?

LEGO Bricks n Pieces

17%

199

BrickLink

67%

767

BrickOwl

eBay

Facebook Groups

Yard/Garage Sale

Other (please describe in comments!)

This Poll ran from Aug. 11, 2021, midnight to Aug. 25, 2021, midnight. 72 Comments 1146 votes

NOT IN SCHEDULED TIMEFRAME

What do you think of the new 1x5 plate as seen in Vidyio Boombox?

Awesome!

55%

497

Don't care

34%

305

OMG! LEGO ARE DOOMED!

12%

107

This Poll ran from May 1, 2021, midnight to May 14, 2021, midnight. 182 Comments 909 votes

NOT IN SCHEDULED TIMEFRAME

Which of the BrickLink Designer Program sets would you like to see made the most?

This Poll ran from March 19, 2021, midnight to April 9, 2021, midnight. 36 Comments 817 votes

NOT IN SCHEDULED TIMEFRAME

Which of the final 4 themes for the LEGO 90th Anniversary Contest do you think should win?

Bionicle

10%

108

Classic Space

39%

434

Pirates

14%

152

Castle

38%

424

This Poll ran from Feb. 7, 2021, midnight to Feb. 14, 2021, midnight. 68 Comments 1118 votes

NOT IN SCHEDULED TIMEFRAME

Which of the 25 LEGO Ideas qualifying sets do you think should be picked for the 3rd round of 2020?

This Poll ran from Jan. 6, 2021, midnight to Jan. 31, 2021, midnight. 74 Comments 1528 votes

NOT IN SCHEDULED TIMEFRAME

Of these top 10 most viewed LEGO Sets from 2020, which one is your favourite?

This Poll ran from Dec. 23, 2020, midnight to Jan. 16, 2021, midnight. 73 Comments 1852 votes

NOT IN SCHEDULED TIMEFRAME

How do you open the Advent Calendar daily models?

This Poll ran from Dec. 1, 2020, midnight to Dec. 24, 2020, midnight. 41 Comments 1135 votes

NOT IN SCHEDULED TIMEFRAME

How do you organise your LEGO parts?

This Poll ran from Nov. 8, 2020, midnight to Nov. 30, 2020, midnight. 144 Comments 1846 votes

NOT IN SCHEDULED TIMEFRAME

Are you excited about the new LEGO Mindstorms 51515 Robot Inventor set?

This Poll ran from Oct. 16, 2020, midnight to Oct. 31, 2020, midnight. 59 Comments 698 votes

DJDT

Time

Resource usage

Resource	Value
User CPU time	150.371 msec
System CPU time	0.788 msec
Total CPU time	151.159 msec
Elapsed time	223.052 msec
Context switches	81 voluntary, 1 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 73.72 ms (39 queries including 36 similar and 12 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-31T08:09:06.786969+00:00'::timestamptz)SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-01-31T08:09:06.786969+00:00'::timestamptz)

0.23

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(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-31T08:09:06.786969+00:00'::timestamptz)
ORDER BY "polls_poll"."start_date" DESC
LIMIT 10
OFFSET 50SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-01-31T08:09:06.786969+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 50

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	`<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">< <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" = 17)
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" = 17) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC

4 similar queries.

10.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/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" = '17' 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" = '17' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

5.67

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 17)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 17)

10 similar queries.

0.19

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" = 16)
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" = 16) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC

4 similar queries.

0.91

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" = '16' 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" = '16' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

5.81

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

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",
       "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" = 15)
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" = 15) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC

4 similar queries.

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(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" = '15' 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" = '15' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

8.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" = 15)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 15)

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",
       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" = 14)
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" = 14) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 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

12 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" = '14' 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" = '14' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

3.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/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" = 14)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 14)

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(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" = 13)
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" = 13) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC

4 similar queries.

1.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_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" = '13' 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" = '13' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

4.94

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

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",
       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" = 12)
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" = 12) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

1.09

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" = 12)
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" = 12) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.53

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_results(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" = '12' 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" = '12' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

4.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/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" = 12)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 12)

10 similar queries.

0.19

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" = 11)
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" = 11) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

1.39

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" = 11)
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" = 11) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

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/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" = '11' 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" = '11' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

4.00

Connection: default

Transaction status: Idle

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

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

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

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

10 similar queries.

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})

/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" = 10)
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" = 10) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.60

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" = 10)
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" = 10) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.45

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

10 similar queries.

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

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" = 9)
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" = 9) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

1.89

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" = 9)
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" = 9) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.81

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" = '9' 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" = '9' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

6.45

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

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(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" = 8)
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" = 8) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.39

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" = 8)
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" = 8) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value" ORDER BY 4 DESC

12 similar queries. Duplicated 2 times.

0.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/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" = '8' 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" = '8' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")

10 similar queries.

3.06

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

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.