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

Bionicle
10%
Classic Space
39%
Pirates
14%
Castle
38%
Login to vote!
68 Comments 1118 votes

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

Login to vote!
74 Comments 1528 votes

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

Login to vote!
73 Comments 1852 votes

How do you open the Advent Calendar daily models?

Login to vote!
41 Comments 1135 votes

How do you organise your LEGO parts?

Login to vote!
153 Comments 1846 votes

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

Login to vote!
59 Comments 698 votes

Have you ever bought a LEGO Set for the main purpose of creating/building an Alternate Build MOC?

No
41%
Yes
59%
Login to vote!
32 Comments 1824 votes

Which of the LEGO Ideas qualifying sets do you think should be picked for the 2nd round of 2020?

Login to vote!
89 Comments 838 votes

Will you be buying (or already bought) a Super Mario set?

Yes
12%
No
76%
Undecided
12%
Login to vote!
41 Comments 2405 votes

Of the 42115 Lamborghini Sián test colors shown, which one would you have preferred to see the car made in?

Green
10%
Lime
16%
Br Light Orange
12%
Dark Pink
7%
Orange
10%
White
13%
Tan
6%
Medium Azure
26%
Login to vote!
50 Comments 1608 votes
DJDT

Time

Resource usage

Resource Value
User CPU time 137.393 msec
System CPU time 2.650 msec
Total CPU time 140.043 msec
Elapsed time 190.814 msec
Context switches 46 voluntary, 0 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 52.23 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-11-16T00:01:06.197463+00:00'::timestamptz)
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:01:06.197463+00:00'::timestamptz)
0.24

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM
"countries_plus_country"
 WHERE
"countries_plus_country"."iso" = 'US'
 LIMIT
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.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-16T00:01:06.197463+00:00'::timestamptz)
 ORDER BY
"polls_poll"."start_date" DESC
 LIMIT
10
OFFSET
60
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:01:06.197463+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 60
0.14

Connection: default

Transaction status: Idle

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

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

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

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

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" = '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.
3.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()

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" = 13)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 13)
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(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" = 12)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 12) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
1.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_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" = 12)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 12) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 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)

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.
3.25

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" = 12)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 12)
10 similar queries.
0.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_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" = 11)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 11) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
1.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(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" = 11)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 11) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.61

Connection: default

Transaction status: Idle

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

/home/nathan/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" = '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.
2.83

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_num_votes(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" = 10)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 10) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.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(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" = 10)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 10) GROUP BY 1, 2, 3 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(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" = '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.
1.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()

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" = 10)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 10)
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" = 9)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 9) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
2.05

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" = 9)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 9) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 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)

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.
5.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/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" = 9)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 9)
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",
       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
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 8) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.43

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" = 8)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 8) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 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" = '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.
2.31

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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">
4 <div class="col-sm-3 col-md-2">
5 {% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}
6 {{ vote.option__text }}

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

SELECT COUNT(*) AS "__count"
  FROM
"threadedcomments_comment"
 INNER JOIN
"django_comments"
    ON
("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
 WHERE
("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '7' 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" = '7' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.96

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 7)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 7)
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",
       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" = 5)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 5) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.59

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 5)
 GROUP BY
1,
       2,
       3
 ORDER BY
4 DESC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 5) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 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" = '5' 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" = '5' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
2.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()

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" = 5)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 5)
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" = 4)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 4) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
4 similar queries.
1.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/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" = '4' 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" = '4' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.40

Connection: default

Transaction status: Idle

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

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

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

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" = 4)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 4)
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" = 3)
 GROUP BY
1,
       2,
       3,
       4
 ORDER BY
3 ASC
SELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 3) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
4 similar queries.
0.87

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_num_votes(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.