What Disney building needs a mini version next?

Login to vote!
28 Comments 355 votes

Weekend Poll: Do you buy polybag sets?

Yes, I collect them all
4%
Sometimes, depends on the set
54%
Sometimes, they're too hard to find in stores
24%
Never, I don't like them
17%
Login to vote!
20 Comments 648 votes

Weekend Poll: Time to settle it: who's the strongest Ninja?

Login to vote!
32 Comments 167 votes

Weekend Poll: Who'd win an Ironman Triathlon?

Login to vote!
15 Comments 247 votes

Weekend Poll: What do you think of the new color Reddish Orange?

Login to vote!
28 Comments 300 votes

Rebrickables Top 10 of 2023 is out. How do you think we did?

Login to vote!
38 Comments 842 votes

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

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

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

Yes
51%
No
49%
Login to vote!
137 Comments 1439 votes

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

Login to vote!
3 Comments 356 votes

Who's getting a Sonic the Hedgehog set?

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

Time

Resource usage

Resource Value
User CPU time 142.730 msec
System CPU time 0.000 msec
Total CPU time 142.730 msec
Elapsed time 178.463 msec
Context switches 46 voluntary, 6 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

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

Connection: default

Transaction status: Idle

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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",
       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" = 42)
 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" = 42) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
8.98

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

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

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       "polls_polloptions"."color" AS "option__color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 46)
 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" = 46) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
4 similar queries.
0.92

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

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 44)
 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" = 44) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.34

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       COUNT("polls_pollvote"."id") AS "num"
  FROM
"polls_pollvote"
 INNER JOIN
"polls_polloptions"
    ON
("polls_pollvote"."option_id" = "polls_polloptions"."id")
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 44)
 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" = 44) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.23

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "polls_pollvote"."option_id" AS "option__id",
       "polls_polloptions"."text" AS "option__text",
       "polls_polloptions"."value" AS "option__value",
       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" = 43)
 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" = 43) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.63

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

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" = 41)
 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" = 41) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.33

Connection: default

Transaction status: Idle

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

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

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

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

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" = 40)
 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" = 40) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.90

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 40)
 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" = 40) 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" = '40' 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" = '40' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.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" = 40)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 40)
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" = 39)
 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" = 39) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
4 similar queries.
1.10

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

Connection: default

Transaction status: Idle

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

/home/nathan/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" = '35' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '35' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
6.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/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" = 35)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 35)
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(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" = 38)
 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" = 38) 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" = 38)
 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" = 38) GROUP BY 1, 2, 3 ORDER BY 4 DESC
12 similar queries. Duplicated 2 times.
0.27

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_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" = '38' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '38' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
0.62

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 37)
 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" = 37) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
4 similar queries.
0.66

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

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

Connection: default

Transaction status: Idle

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

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