Poll - Weekend Poll: Who like doing these polls?

NOT IN SCHEDULED TIMEFRAME

Weekend Poll: Who like doing these polls?

Yes, I love them!

83%

424

Absolutely not, I'd never vote in something so frivolous

What's a poll?

11%

This Poll ran from May 17, 2024, midnight to May 21, 2024, midnight. 29 Comments 508 votes

29 COMMENTS

to your account to add or reply to comments.

10 months, 2 weeks ago Your average lego builder Level 11 MOC Designer

Cool just don’t know how to vote
- 10 months, 1 week ago yqc Level 18 MOC Designer
  
  It is only possible for some time, so you can only vote on new posts.
  - 10 months, 1 week ago Your average lego builder Level 11 MOC Designer
    
    Thanks

11 months ago BuyingBricks4Us Level 12

I plan to start voting; I was waiting for an active poll to come, and now that I have an account AND polls are being posted again I voted today in the active poll involving modulars.

1 year, 2 months ago Vamo Customs Level 18 MOC Designer DESIGNER

Ok, i'd never vote, but im gonna vote that i dont vote. jk i love polls

1 year, 8 months ago 2in1 Level 26 MOC Designer PRO

(Credit: https://xkcd.com/2618/ )
- 1 year, 8 months ago OrchardBuilds Level 33 MOC Designer PRO
  
  Haha!
- 10 months, 2 weeks ago Your average lego builder Level 11 MOC Designer
  
  Haha!

1 year, 8 months ago Shermantanker32 Level 17

voting Absolutely not, I'd never vote in something so frivolous while voting
- 1 year, 8 months ago youngandunknown Level 19 MOC Designer
  
  how ironic! XD
- 1 year, 2 months ago Vamo Customs Level 18 MOC Designer DESIGNER
  
  smart!

1 year, 8 months ago yqc Level 18 MOC Designer

I really like them, and would be happy about them more often. Maybe also do these polls for features instead of the voting system at the forum? And a email notification for them would be great.

1 year, 8 months ago DrPhil Level 17 MOC Designer

This poll is like: How to make sure to get biased results 101 :D
- 1 year, 8 months ago OrchardBuilds Level 33 MOC Designer PRO
  
  Step one: Have answers that are confusing and meaningless.
  
  Step two: only have one reasonable answer.
- 1 year, 8 months ago jaredhinton Level 41 Inventory Admin ADMIN
  
  Haha, honestly I forgot to make one this week and threw it together last minute. The idea of polls are to encourage discussion in the community so unless we’re gauging opinion on site changes content doesn’t really matter.
  I admit though, I did amuse myself writing these choices.

1 year, 8 months ago Zongo-the-Jedi Level 14

Honestly i love to see each week a new poll

1 year, 8 months ago the_Immortal Level 16 MOC Designer

What's a poll?
- 1 year, 8 months ago Zongo-the-Jedi Level 14
  
  That’s what you just voted for
  - 1 year, 8 months ago the_Immortal Level 16 MOC Designer
    
    Yep
    Ok

1 year, 8 months ago OrchardBuilds Level 33 MOC Designer PRO

For those that voted "Absolutely not, I'd never vote in something so frivolous" You just did.
- 1 year, 8 months ago raguidel Level 22 MOC Designer DESIGNER
  
  🤣 True though
- 1 year, 8 months ago 𝒯𝐻𝐹 𝒮𝓉𝓊𝒹𝒾𝑜™ Level 18 MOC Designer
  
  That statement could not get any more true.
- 1 year, 8 months ago LeTourbeux Level 21
  
  LOL !
  I personally like it, and the possible subjects are countless !
  Some, on very specific technical points, were very interesting.

1 year, 8 months ago allthenamesaretaken Level 17 MOC Designer

I didn't realize there were polls happening until just now. I'm in favor of them
- 1 year, 8 months ago BossBuilder Level 16 MOC Designer
  
  same! I like them though.

1 year, 8 months ago OrchardBuilds Level 33 MOC Designer PRO

I think they are enjoyable, and I am happy to see what other people's opinions are even if I disagree with them.

1 year, 8 months ago Physior Level 13 MOC Designer

Ah yes, the poll is made out of votes. Very interesting.
- 1 year, 8 months ago BossBuilder Level 16 MOC Designer
  
  yup. That's kinda the way a poll works.

1 year, 8 months ago 𝒯𝐻𝐹 𝒮𝓉𝓊𝒹𝒾𝑜™ Level 18 MOC Designer

Yes! These poles are very enjoyable, and a great way to interact with the community.

DJDT

Time

Resource usage

Resource	Value
User CPU time	420.961 msec
System CPU time	2.464 msec
Total CPU time	423.425 msec
Elapsed time	457.674 msec
Context switches	400 voluntary, 2 involuntary

Browser timing

Timing attribute	Timeline	Milliseconds since navigation start (+length)

SQL queries from 1 connection

default 34.52 ms (149 queries including 141 similar and 113 duplicates )

Query Timeline Time (ms) Action

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"."id" = 54 AND "polls_poll"."start_date" <= '2026-01-31T13:52:48.680843+00:00'::timestamptz)
LIMIT 21SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."id" = 54 AND "polls_poll"."start_date" <= '2026-01-31T13:52:48.680843+00:00'::timestamptz) LIMIT 21

8.82

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(125)
  poll =  get_object_or_404(Poll, id=poll_id, start_date__lte=timezone.now())

SELECT "rb_sitesettings"."id",
       "rb_sitesettings"."name",
       "rb_sitesettings"."value"
  FROM "rb_sitesettings"
WHERE "rb_sitesettings"."name" = 'site_message'
LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./rb/templatetags/rb_settings.py in site_message(147)
  message = SiteSettings.get_site_message()

/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
  result = method(instance, *args, **kwargs)

/home/nathan/rb/site/./rb/models/site.py in get_site_message(24)
  setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)

340
341	`<body class="{% block body-class %}{{ request.user.get_body_classes }}{% endblock body-class %}">`
342
343	`{% site_message %}`
344	`<div id="wrapper" class="{% block wrapper_class %}{% endblock wrapper_class %} {% if request.user.is_anonymous %}{% else %}{{ request.user.get_personalisation_options.max_width }}{% endif %}">`
345
346
347	`<div id="topBar" class="hidden-sm hidden-xs">`

/home/nathan/rb/site/rb/templates/rb/base_root.html

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
WHERE "countries_plus_country"."iso" = 'US'
LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(252)
  country = Country.objects.get(iso=country_code)

412	`</a>`
413	`</li>`
414	`<li class="hidden-xs">`
415	`{% geo_currency request.user %}`
416	`</li>`
417	`{% comment %}`
418	`<li class="hidden-xs hidden-sm">`
419	`<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>`

/home/nathan/rb/site/rb/templates/rb/base_root.html

SELECT "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color",
       COUNT("polls_pollvote"."id") AS "num"
  FROM "polls_pollvote"
INNER JOIN "polls_polloptions"
    ON ("polls_pollvote"."option_id" = "polls_polloptions"."id")
WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)
GROUP BY "polls_pollvote"."option_id",
       "polls_polloptions"."text",
       "polls_polloptions"."value",
       "polls_polloptions"."color"
ORDER BY "polls_polloptions"."value" ASCSELECT ••• FROM "polls_pollvote" INNER JOIN "polls_polloptions" ON ("polls_pollvote"."option_id" = "polls_polloptions"."id") WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC

0.97

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

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

1	`{% if poll.user_vote or request.user.is_anonymous or poll.is_past %}`
2	`{% for vote in poll.get_results %}`
3	`<div class="row pb-6">`
4	`<div class="col-sm-3 col-md-2">`
5	`{% if poll.user_vote.option_id == vote.option__id %}(voted){% endif %}`
6	`{{ vote.option__text }}`

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

SELECT "django_content_type"."id",
       "django_content_type"."app_label",
       "django_content_type"."model"
  FROM "django_content_type"
WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll')
LIMIT 21SELECT ••• FROM "django_content_type" WHERE ("django_content_type"."app_label" = 'polls' AND "django_content_type"."model" = 'poll') LIMIT 21

2 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(88)
  qs = super().get_queryset(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/threadedcomments/templatetags/threadedcomments_tags.py in get_queryset(17)
  ctype, object_pk = self.get_target_ctype_pk(context)

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in get_target_ctype_pk(111)
  return ContentType.objects.get_for_model(obj), obj.pk

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

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

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

2 similar queries. Duplicated 2 times.

0.62

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

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

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

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

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

SELECT COUNT("polls_pollvote"."id") AS "id__count"
FROM "polls_pollvote"
WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 54)

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

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

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

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

2 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(78)
  content_type = ContentType.objects.get(app_label=page_content_type.split('.')[0], model=page_content_type.split('.')[1])

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT 1 AS "a"
FROM "rb_comments_pagelocked"
WHERE ("rb_comments_pagelocked"."content_type_id" = 196 AND "rb_comments_pagelocked"."object_id" = 54)
LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 196 AND "rb_comments_pagelocked"."object_id" = 54) LIMIT 1

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_page_locked_status(79)
  is_locked = PageLocked.objects.filter(content_type=content_type, object_id=page_id).exists()

4	`{% load rb_comments_filters %}`
5
6	`<div id="comments-{{ page.id }}">`
7	`{% get_page_locked_status content_type page.id as is_page_locked %}`
8
9	`{% comment %}`
10	`Not using render_comment_list as it uses styles in ul/li that I can't seem to get working well with Smarty.`
11	`Using fluent-comments to hide unused fields and do ajax add/reply comment.`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       "accounts_userprofile"."user_id",
       "accounts_userprofile"."last_mod_inv",
       "accounts_userprofile"."last_activity",
       "accounts_userprofile"."last_ip",
       "accounts_userprofile"."last_country_id",
       "accounts_userprofile"."last_agent",
       "accounts_userprofile"."is_email_verified",
       "accounts_userprofile"."is_email_idle",
       "accounts_userprofile"."email_last_clicked",
       "accounts_userprofile"."api_token",
       "accounts_userprofile"."real_name",
       "accounts_userprofile"."location",
       "accounts_userprofile"."brickset_url",
       "accounts_userprofile"."mocpages_url",
       "accounts_userprofile"."flickr_url",
       "accounts_userprofile"."eurobricks_url",
       "accounts_userprofile"."youtube_url",
       "accounts_userprofile"."bricklink_url",
       "accounts_userprofile"."brickowl_url",
       "accounts_userprofile"."bricksafe_url",
       "accounts_userprofile"."website_url",
       "accounts_userprofile"."facebook_url",
       "accounts_userprofile"."twitter_url",
       "accounts_userprofile"."karma",
       "accounts_userprofile"."trophy_badge_id",
       "accounts_userprofile"."comments",
       "accounts_userprofile"."mfhash_vector",
       "accounts_userprofile"."is_muted",
       "accounts_userprofile"."is_banned",
       "accounts_userprofile"."is_suspected_pirate",
       "accounts_userprofile"."muted_until",
       "accounts_userprofile"."blocked_operations",
       "accounts_userprofile"."is_guest",
       "accounts_userprofile"."guest_token"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
  LEFT OUTER JOIN "auth_user"
    ON ("django_comments"."user_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "accounts_userprofile"
    ON ("auth_user"."id" = "accounts_userprofile"."user_id")
WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASCSELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC

2.59

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_queryset(45)
  return qs[:50], len(qs)

14	`{% endcomment %}`
15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
       "auth_group"."id",
       "auth_group"."name"
  FROM "auth_group"
INNER JOIN "auth_user_groups"
    ON ("auth_group"."id" = "auth_user_groups"."group_id")
WHERE "auth_user_groups"."user_id" IN (1138277, 997905, 1161254, 674942, 408385, 929129, 1038319, 1045219, 382953, 83025, 1014733, 933305, 974054, 925617, 84273, 54774, 737844, 193562)SELECT ••• FROM "auth_group" INNER JOIN "auth_user_groups" ON ("auth_group"."id" = "auth_user_groups"."group_id") WHERE "auth_user_groups"."user_id" IN (1138277, 997905, 1161254, 674942, 408385, 929129, 1038319, 1045219, 382953, 83025, 1014733, 933305, 974054, 925617, 84273, 54774, 737844, 193562)

2 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/venv_rb310/lib/python3.10/site-packages/django_comments/templatetags/comments.py in render(71)
  qs = self.get_queryset(context)

/home/nathan/rb/site/./rb_comments/templatetags/rb_comments_filters.py in get_queryset(45)
  return qs[:50], len(qs)

14	`{% endcomment %}`
15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

2 similar queries. Duplicated 2 times.

0.33

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/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()

15	`{% if not comment_list %}`
16	`{# Get comments for a page #}`
17	`{% get_rb_comment_list for page as comment_list %}`
18	`{% get_comment_count for page as num_comments %}`
19
20	`{% if show_comment_count %}`
21	`<div class="clearfix">`
22	`<div class="heading-title heading-border-bottom heading-color">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT (SUBSTRING(tree_path, 1, 10)) AS "tree_path_root",
       "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity",
       "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       "accounts_userprofile"."user_id",
       "accounts_userprofile"."last_mod_inv",
       "accounts_userprofile"."last_activity",
       "accounts_userprofile"."last_ip",
       "accounts_userprofile"."last_country_id",
       "accounts_userprofile"."last_agent",
       "accounts_userprofile"."is_email_verified",
       "accounts_userprofile"."is_email_idle",
       "accounts_userprofile"."email_last_clicked",
       "accounts_userprofile"."api_token",
       "accounts_userprofile"."real_name",
       "accounts_userprofile"."location",
       "accounts_userprofile"."brickset_url",
       "accounts_userprofile"."mocpages_url",
       "accounts_userprofile"."flickr_url",
       "accounts_userprofile"."eurobricks_url",
       "accounts_userprofile"."youtube_url",
       "accounts_userprofile"."bricklink_url",
       "accounts_userprofile"."brickowl_url",
       "accounts_userprofile"."bricksafe_url",
       "accounts_userprofile"."website_url",
       "accounts_userprofile"."facebook_url",
       "accounts_userprofile"."twitter_url",
       "accounts_userprofile"."karma",
       "accounts_userprofile"."trophy_badge_id",
       "accounts_userprofile"."comments",
       "accounts_userprofile"."mfhash_vector",
       "accounts_userprofile"."is_muted",
       "accounts_userprofile"."is_banned",
       "accounts_userprofile"."is_suspected_pirate",
       "accounts_userprofile"."muted_until",
       "accounts_userprofile"."blocked_operations",
       "accounts_userprofile"."is_guest",
       "accounts_userprofile"."guest_token"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
  LEFT OUTER JOIN "auth_user"
    ON ("django_comments"."user_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "accounts_userprofile"
    ON ("auth_user"."id" = "accounts_userprofile"."user_id")
WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")
ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC
LIMIT 50SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") LEFT OUTER JOIN "auth_user" ON ("django_comments"."user_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "accounts_userprofile" ON ("auth_user"."id" = "accounts_userprofile"."user_id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '54' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") ORDER BY 1 DESC, "threadedcomments_comment"."tree_path" ASC LIMIT 50

1.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

89	`{% with cache_timeout=user.is_authenticated\|yesno:"0,300" %}`
90	`{% cache cache_timeout 'comments_list_v2' request.user.is_authenticated page.id request.GET.page request.GET.showmore num_comments %}`
91
92	`<div class="comments {% if not comment_list.0 %} empty{% endif %} mb-30">`
93	`{% if use_context %}`
94	`{# Flat list of comments #}`
95	`{% for comment in comment_list.0\|make_proxy_users %}`
96	`<ul class="comment list-unstyled comment-list-wrapper">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

2 similar queries. Duplicated 2 times.

0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

89	`{% with cache_timeout=user.is_authenticated\|yesno:"0,300" %}`
90	`{% cache cache_timeout 'comments_list_v2' request.user.is_authenticated page.id request.GET.page request.GET.showmore num_comments %}`
91
92	`<div class="comments {% if not comment_list.0 %} empty{% endif %} mb-30">`
93	`{% if use_context %}`
94	`{# Flat list of comments #}`
95	`{% for comment in comment_list.0\|make_proxy_users %}`
96	`<ul class="comment list-unstyled comment-list-wrapper">`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1138277
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1138277 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 3 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1138277
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1138277 LIMIT 21

28 similar queries. Duplicated 3 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1138277)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1138277) LIMIT 1

54 similar queries. Duplicated 6 times.

0.20

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

54 similar queries. Duplicated 6 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 798898
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 798898 LIMIT 21

15 similar queries.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 997905
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 997905 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 997905
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 997905 LIMIT 21

28 similar queries. Duplicated 2 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905) LIMIT 1

54 similar queries. Duplicated 4 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905) LIMIT 1

54 similar queries. Duplicated 4 times.

0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 804183
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 804183 LIMIT 21

15 similar queries.

0.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

29 similar queries. Duplicated 3 times.

0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

28 similar queries. Duplicated 3 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

54 similar queries. Duplicated 6 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

54 similar queries. Duplicated 6 times.

0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1161254
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1161254 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1161254
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1161254 LIMIT 21

28 similar queries.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 674942
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 674942 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 674942
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 674942 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942) LIMIT 1

54 similar queries. Duplicated 4 times.

0.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 674942)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 674942) LIMIT 21

9 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 408385
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 408385 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 408385
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 408385 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 408385)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 408385) LIMIT 1

54 similar queries. Duplicated 2 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 408385)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 408385) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 408385)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 408385) LIMIT 21

9 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 594940
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 594940 LIMIT 21

15 similar queries. Duplicated 2 times.

0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 929129
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 929129 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 929129
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 929129 LIMIT 21

28 similar queries. Duplicated 4 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129) LIMIT 21

9 similar queries. Duplicated 4 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 594940
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 594940 LIMIT 21

15 similar queries. Duplicated 2 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

29 similar queries. Duplicated 3 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

28 similar queries. Duplicated 3 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

54 similar queries. Duplicated 6 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

54 similar queries. Duplicated 6 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1038319
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1038319 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1038319
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1038319 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1038319)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1038319) LIMIT 1

54 similar queries. Duplicated 2 times.

0.35

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1038319)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1038319) LIMIT 1

54 similar queries. Duplicated 2 times.

0.20

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 594817
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 594817 LIMIT 21

15 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1045219
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1045219 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1045219
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1045219 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1045219)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1045219) LIMIT 1

54 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1045219)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1045219) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 594817
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 594817 LIMIT 21

15 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 674942
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 674942 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 674942
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 674942 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 674942) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

9 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 997905
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 997905 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 997905
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 997905 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 997905) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 382953
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 382953 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 382953
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 382953 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 382953)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 382953) LIMIT 1

54 similar queries. Duplicated 2 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 382953)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 382953) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593813
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593813 LIMIT 21

15 similar queries. Duplicated 2 times.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 929129
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 929129 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 929129
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 929129 LIMIT 21

28 similar queries. Duplicated 4 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129) LIMIT 21

9 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593813
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593813 LIMIT 21

15 similar queries. Duplicated 2 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 83025
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 83025 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 83025)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 83025) LIMIT 21

9 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1014733
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1014733 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1014733
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1014733 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 933305
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 933305 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 933305
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 933305 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305) LIMIT 1

54 similar queries. Duplicated 4 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593101
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593101 LIMIT 21

15 similar queries.

0.22

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 1014733
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 1014733 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 1014733
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 1014733 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 1014733) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593111
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593111 LIMIT 21

15 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 933305
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 933305 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 933305
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 933305 LIMIT 21

28 similar queries. Duplicated 2 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 933305) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 929129
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 929129 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 929129
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 929129 LIMIT 21

28 similar queries. Duplicated 4 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129) LIMIT 21

9 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593023
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593023 LIMIT 21

15 similar queries. Duplicated 3 times.

0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 974054
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 974054 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 974054
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 974054 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 974054)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 974054) LIMIT 1

54 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 974054)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 974054) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 974054)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 974054) LIMIT 21

9 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593023
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593023 LIMIT 21

15 similar queries. Duplicated 3 times.

0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 925617
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 925617 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 925617
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 925617 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617) LIMIT 1

54 similar queries. Duplicated 4 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 593023
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 593023 LIMIT 21

15 similar queries. Duplicated 3 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 84273
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 84273 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 84273
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 84273 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 84273)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 84273) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 84273)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 84273) LIMIT 1

54 similar queries. Duplicated 2 times.

0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 54774
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 54774 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 54774
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 54774 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 54774)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 54774) LIMIT 1

54 similar queries. Duplicated 2 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 54774)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 54774) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 592981
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 592981 LIMIT 21

15 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 737844
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 737844 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 737844
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 737844 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844) LIMIT 1

54 similar queries. Duplicated 4 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 929129
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 929129 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 929129
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 929129 LIMIT 21

28 similar queries. Duplicated 4 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 929129) LIMIT 1

54 similar queries. Duplicated 8 times.

0.17

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "accounts_usersetting"."id",
       "accounts_usersetting"."user_id",
       "accounts_usersetting"."name",
       "accounts_usersetting"."value"
  FROM "accounts_usersetting"
WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129)
LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 929129) LIMIT 21

9 similar queries. Duplicated 4 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in is_public_plan(654)
  return self.get_privacy_option('is_public_plan')

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_option(269)
  options = self.get_privacy_options()

/home/nathan/rb/site/./accounts/models/user_extras.py in get_privacy_options(263)
  options = UserSetting.objects.get(user=self, name=UserSetting.USER_SETTING_PRIVACY_OPTIONS)

60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`
65	`{% endif %}`
66	`{% endif %}`
67	`{% if page.is_moc %}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 193562
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 193562 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries.

0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 193562
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 193562 LIMIT 21

28 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 193562)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 193562) LIMIT 1

54 similar queries. Duplicated 2 times.

0.18

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 193562)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 193562) LIMIT 1

54 similar queries. Duplicated 2 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "django_comments"."id",
       "django_comments"."content_type_id",
       "django_comments"."object_pk",
       "django_comments"."site_id",
       "django_comments"."user_id",
       "django_comments"."user_name",
       "django_comments"."user_email",
       "django_comments"."user_url",
       "django_comments"."comment",
       "django_comments"."submit_date",
       "django_comments"."ip_address",
       "django_comments"."is_public",
       "django_comments"."is_removed",
       "threadedcomments_comment"."comment_ptr_id",
       "threadedcomments_comment"."title",
       "threadedcomments_comment"."parent_id",
       "threadedcomments_comment"."last_child_id",
       "threadedcomments_comment"."tree_path",
       "threadedcomments_comment"."newest_activity"
  FROM "threadedcomments_comment"
INNER JOIN "django_comments"
    ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id")
WHERE "threadedcomments_comment"."comment_ptr_id" = 592945
LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 592945 LIMIT 21

15 similar queries.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

105	`{% if not comment.open and not comment.close %}</li>{% endif %}`
106	`{% if comment.open %}`
107	`<ul class="comment list-unstyled comment-list-wrapper">{% endif %}`
108	`<li class="comment {% if comment.parent and comment.depth < 7 %}comment-reply{% endif %} comment-wrapper">`
109	`{% include "comments/comment.html" %}`
110	`{% for close in comment.close %}`
111	`</li>`
112	`</ul>`

/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 737844
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 737844 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 737844
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 737844 LIMIT 21

28 similar queries. Duplicated 2 times.

0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 737844) LIMIT 1

54 similar queries. Duplicated 4 times.

0.15

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "avatar_avatar"."id",
       "avatar_avatar"."user_id",
       "avatar_avatar"."primary",
       "avatar_avatar"."avatar",
       "avatar_avatar"."date_uploaded"
  FROM "avatar_avatar"
WHERE "avatar_avatar"."user_id" = 925617
ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC
LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 925617 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1

29 similar queries. Duplicated 2 times.

0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./avatar/templatetags/avatar_tags.py in avatar_url(33)
  avatar_url = provider.get_avatar_url(user, size)

/home/nathan/rb/site/./avatar/providers.py in get_avatar_url(48)
  avatar = get_primary_avatar(user, size)

/home/nathan/rb/site/./avatar/utils.py in get_primary_avatar(120)
  avatar = user.avatar_set.order_by("-primary", "-date_uploaded")[0]

36	`{% if is_blocked %}`
37	`<img data-src="{% static settings.AVATAR_DEFAULT_URL %}" class="comment-avatar" width="75px" height="75px">`
38	`{% else %}`
39	`<img data-src="{% avatar_url comment.user 75 %}" class="comment-avatar" width="75px" height="75px" alt="Avatar image for Rebrickable user {{ comment.user }}">`
40	`{% endif %}`
41	`{# collapse/expand child comments #}`
42	`<div class="text-center pointer pt-10 js-collapse-comments" data-comment-id="{{ comment.id }}">`
43	`<i class="fa fa-minus-square-o fa-lg"></i>`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors"
  FROM "lego_designer"
INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
WHERE "lego_designer"."user_ptr_id" = 925617
LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 925617 LIMIT 21

28 similar queries. Duplicated 2 times.

0.12

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

SELECT 1 AS "a"
FROM "lego_moc"
INNER JOIN "lego_baseset"
ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617)
LIMIT 1SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."designer_id" = 925617) LIMIT 1

54 similar queries. Duplicated 4 times.

0.16

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./polls/views.py in discuss_poll(146)
  return render(request, 'polls/discuss_poll.html', {'poll': poll, 'qscharts': [daily_votes_chart]})

/home/nathan/rb/site/./accounts/models/user_extras.py in get_rolename(618)
  elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():

57	`{% elif page.is_moc and page.designer_id == comment.user_id %}`
58	`<span class="label label-dark-blue" title="This user designed this MOC">Designed this MOC</span>`
59	`{% else %}`
60	`<span class="label label-info" title="{{ comment.user.get_rolename.1 }}">{{ comment.user.get_rolename.0 }}</span>`
61	`{% endif %}`
62	`{% if not comment.user.plan.is_free %}`
63	`{% if comment.user.is_public_plan %}`
64	`{{ comment.user.get_plan_html }}`

/home/nathan/rb/site/rb_comments/templates/comments/comment.html

Log messages

No messages logged.