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

Yes
27%
No
73%
Login to vote!
36 Comments 465 votes

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

Yes
77%
No
23%
Login to vote!
28 Comments 1085 votes

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

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

Excited for the new Sonic Theme?

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

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

Login to vote!
66 Comments 977 votes

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

Login to vote!
35 Comments 946 votes

Stickers or Printed Parts?

I prefer stickers over printed parts because I can choose to use them or not
17%
I prefer printed parts over stickers because stickers suck
76%
I'd rather have neither
6%
Login to vote!
45 Comments 1217 votes

Do you think we should separate the Friends Theme?

Yes, Friends G1 and Friends G2
28%
Yes, Friends Original and Friends New
13%
Yes, Friends Old and Friends New
5%
No, Keep all the sets together
53%
Yes, But a different name (write in comments)
1%
Login to vote!
16 Comments 948 votes

Which color from 21335-1 Lighthouse do you like the most? (Check the review)

Black
6%
Blue
5%
Chrome Gold
9%
Dark Azure
4%
Dark Blue
18%
Dark Bluish Grey
2%
Dark Brown
0%
Dark Green
8%
Dark Purple
2%
Dark Red
7%
Dark Tan
2%
Dark Turquoise
4%
Flat Silver
0%
Green
1%
Light Bluish Grey
2%
Lime
2%
Medium Nougat
1%
Olive Green
5%
Orange
1%
Pearl Gold
1%
Red
2%
Reddish Brown
1%
Sand Green
7%
Tan
1%
Trans-Clear
1%
Trans-Blue
1%
Trans-Green
1%
Trans-Orange
1%
Trans-Red
1%
Trans Yellow
1%
White
4%
Yellow
1%
Yellowish Green
1%
Login to vote!
25 Comments 809 votes

How did we do with our 2022 Top 10 LEGO sets list?

So Wrong You're Mayor of Wrongtown
19%
You Are the Burger with a Donut for the Bun, Wrong but Oh So Right
17%
I Agree with Most of it, But You have a Black Sheep or Two in There
58%
Spot On, Couldn't Agree More
5%
Login to vote!
19 Comments 986 votes
DJDT

Time

Resource usage

Resource Value
User CPU time 140.200 msec
System CPU time 5.252 msec
Total CPU time 145.452 msec
Elapsed time 177.199 msec
Context switches 45 voluntary, 2 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 38.36 ms (35 queries including 32 similar and 4 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:30.210165+00:00'::timestamptz)
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:01:30.210165+00:00'::timestamptz)
0.30

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:30.210165+00:00'::timestamptz)
 ORDER BY
"polls_poll"."start_date" DESC
 LIMIT
10
OFFSET
40
SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."start_date" <= '2026-11-16T00:01:30.210165+00:00'::timestamptz) ORDER BY "polls_poll"."start_date" DESC LIMIT 10 OFFSET 40
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})

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" = 36)
 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" = 36) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
9.58

Connection: default

Transaction status: Idle

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

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

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" = 34)
 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" = 34) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.58

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_num_votes(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" = 33)
 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" = 33) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.30

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_num_votes(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" = 31)
 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" = 31) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.91

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_results(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" = 30)
 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" = 30) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 similar queries. Duplicated 2 times.
0.71

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

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./polls/models.py in get_results(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" = 29)
 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" = 29) GROUP BY 1, 2, 3 ORDER BY 4 DESC
4 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" = '29' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '29' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.88

Connection: default

Transaction status: Idle

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

/home/nathan/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" = 29)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 29)
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" = 28)
 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" = 28) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.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/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" = '28' 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" = '28' 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" = 28)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 28)
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" = 27)
 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" = 27) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
1.07

Connection: default

Transaction status: Idle

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

/home/nathan/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" = '27' 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" = '27' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
10 similar queries.
1.37

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 27)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 27)
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",
       "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" = 25)
 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" = 25) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.78

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT COUNT("polls_pollvote"."id") AS "id__count"
  FROM
"polls_pollvote"
 WHERE
("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 25)
SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 25)
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",
       "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" = 26)
 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" = 26) GROUP BY 1, 2, 3, 4 ORDER BY 3 ASC
8 similar queries.
0.53

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

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

Log messages

No messages logged.