| Resource | Value |
|---|---|
| User CPU time | 523.486 msec |
| System CPU time | 0.000 msec |
| Total CPU time | 523.486 msec |
| Elapsed time | 557.465 msec |
| Context switches | 267 voluntary, 154 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| 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" = 25 AND "polls_poll"."start_date" <= '2026-01-22T11:19:20.268763+00:00'::timestamptz) LIMIT 21SELECT ••• FROM "polls_poll" WHERE ("polls_poll"."is_active" AND "polls_poll"."id" = 25 AND "polls_poll"."start_date" <= '2026-01-22T11:19:20.268763+00:00'::timestamptz) LIMIT 21 |
0.27 | ||||||||||||||||||||
|
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 "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.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/./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)
/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" = 25) 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" = 25) GROUP BY "polls_pollvote"."option_id", "polls_polloptions"."text", "polls_polloptions"."value", "polls_polloptions"."color" ORDER BY "polls_polloptions"."value" ASC |
9.69 | ||||||||||||||||||||
|
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)
/home/nathan/rb/site/polls/templates/polls/poll_options_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '25' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '25' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
1.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/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()
/home/nathan/rb/site/polls/templates/polls/render_poll.html |
|||||||||||||||||||||
|
SELECT COUNT("polls_pollvote"."id") AS "id__count"
FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 25)SELECT ••• FROM "polls_pollvote" WHERE ("polls_pollvote"."option_id" IS NOT NULL AND "polls_pollvote"."poll_id" = 25) |
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/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
/home/nathan/rb/site/polls/templates/polls/render_poll.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 |
0.25 | ||||||||||||||||||||
|
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])
/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" = 25) LIMIT 1SELECT ••• FROM "rb_comments_pagelocked" WHERE ("rb_comments_pagelocked"."content_type_id" = 196 AND "rb_comments_pagelocked"."object_id" = 25) LIMIT 1 |
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]}) /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()
/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" = '25' 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" = '25' 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 |
3.30 | ||||||||||||||||||||
|
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)
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"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 (102998, 401487, 324066, 162134, 159879, 431552, 381872, 706571, 193562, 489820, 272405, 742028, 146583, 17788, 342919)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 (102998, 401487, 324066, 162134, 159879, 431552, 381872, 706571, 193562, 489820, 272405, 742028, 146583, 17788, 342919) |
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]}) /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)
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT COUNT(*) AS "__count"
2 similar queries.
Duplicated 2 times.
FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '25' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed")SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE ("django_comments"."content_type_id" = 196 AND "django_comments"."object_pk" = '25' AND "django_comments"."site_id" = 1 AND "django_comments"."is_public" AND NOT "django_comments"."is_removed") |
0.37 | ||||||||||||||||||||
|
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()
/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" = '25' 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" = '25' 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.29 | ||||||||||||||||||||
|
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/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT ("auth_user_groups"."user_id") AS "_prefetch_related_val_user_id",
2 similar queries.
Duplicated 2 times.
"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 (102998, 401487, 324066, 162134, 159879, 431552, 381872, 706571, 193562, 489820, 272405, 742028, 146583, 17788, 342919)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 (102998, 401487, 324066, 162134, 159879, 431552, 381872, 706571, 193562, 489820, 272405, 742028, 146583, 17788, 342919) |
0.27 | ||||||||||||||||||||
|
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/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 102998 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 102998 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 102998 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 102998 LIMIT 21 |
0.26 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 102998) 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" = 102998) LIMIT 1 |
0.72 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 102998) 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" = 102998) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 401487 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 401487 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 401487 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 401487 LIMIT 21 |
0.38 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 2 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 401487) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 401487) LIMIT 21 |
0.38 | ||||||||||||||||||||
|
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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357176 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357176 LIMIT 21 |
0.24 | ||||||||||||||||||||
|
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/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 3 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]}) /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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 3 times.
"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" = 324066 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 324066 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) LIMIT 21 |
0.31 | ||||||||||||||||||||
|
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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357462 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357462 LIMIT 21 |
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]})
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 401487 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 401487 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 401487 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 401487 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 2 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 401487) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 401487) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357770 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357770 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 162134 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 162134 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC 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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 162134 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 162134 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/./accounts/models/user_extras.py in get_rolename(618) elif hasattr(self, 'designer') and Moc.objects.filter(designer=self.designer).exists():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 162134) 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" = 162134) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 162134) 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" = 162134) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 162134) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 162134) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 4 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21 |
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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 431552 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 431552 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 431552 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 431552 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 431552) 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" = 431552) LIMIT 1 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 431552) 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" = 431552) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 381872 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 381872 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 381872 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 381872 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 381872) 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" = 381872) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 381872) 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" = 381872) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 381872) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 381872) LIMIT 21 |
0.25 | ||||||||||||||||||||
|
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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357016 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357016 LIMIT 21 |
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]})
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 706571 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 706571 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 706571 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 706571 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 706571) 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" = 706571) LIMIT 1 |
0.28 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 706571) 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" = 706571) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357046 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357046 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"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 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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 |
0.27 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 3 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 3 times.
"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" = 324066 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 324066 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 356996 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356996 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 4 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21 |
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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 489820 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 489820 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 489820 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 489820 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 489820) 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" = 489820) LIMIT 1 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 489820) 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" = 489820) LIMIT 1 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 356971 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356971 LIMIT 21 |
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]})
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 489820 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 489820 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 489820 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 489820 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 489820) 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" = 489820) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 489820) 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" = 489820) LIMIT 1 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 272405 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 272405 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 272405 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 272405 LIMIT 21 |
0.27 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 742028 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 742028 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 742028 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 742028 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
Duplicated 3 times.
"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" = 356957 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356957 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 742028 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 742028 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 742028 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 742028 LIMIT 21 |
0.24 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
Duplicated 2 times.
"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" = 356960 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356960 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 146583 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 146583 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 146583 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 146583 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 146583) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 146583) LIMIT 21 |
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]}) /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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 357000 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 357000 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 4 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
Duplicated 2 times.
"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" = 356960 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356960 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_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 4 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 159879 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC 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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 4 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 159879) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
Duplicated 3 times.
"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" = 356957 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356957 LIMIT 21 |
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/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 3 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 324066 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 3 times.
"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" = 324066 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 324066 LIMIT 21 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 6 times.
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" = 324066) 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" = 324066) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 3 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 324066) LIMIT 21 |
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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
Duplicated 3 times.
"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" = 356957 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356957 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_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 17788 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 17788 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC 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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 2 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 17788) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 17788) 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/./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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 342919 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 342919 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
"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" = 342919 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 342919 LIMIT 21 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 342919) 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" = 342919) LIMIT 1 |
0.27 | ||||||||||||||||||||
|
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 2 times.
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" = 342919) 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" = 342919) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 706571 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 706571 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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/./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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "auth_user"."id",
19 similar queries.
Duplicated 2 times.
"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" = 706571 LIMIT 21SELECT ••• FROM "lego_designer" INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") WHERE "lego_designer"."user_ptr_id" = 706571 LIMIT 21 |
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]}) /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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 706571) 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" = 706571) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT 1 AS "a"
26 similar queries.
Duplicated 4 times.
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" = 706571) 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" = 706571) LIMIT 1 |
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():
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "django_comments"."id",
14 similar queries.
"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" = 356927 LIMIT 21SELECT ••• FROM "threadedcomments_comment" INNER JOIN "django_comments" ON ("threadedcomments_comment"."comment_ptr_id" = "django_comments"."id") WHERE "threadedcomments_comment"."comment_ptr_id" = 356927 LIMIT 21 |
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]})
/home/nathan/rb/site/rb_comments/templates/comments/render_comment_list.html |
|||||||||||||||||||||
|
SELECT "avatar_avatar"."id",
25 similar queries.
Duplicated 2 times.
"avatar_avatar"."user_id", "avatar_avatar"."primary", "avatar_avatar"."avatar", "avatar_avatar"."date_uploaded" FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 17788 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1SELECT ••• FROM "avatar_avatar" WHERE "avatar_avatar"."user_id" = 17788 ORDER BY "avatar_avatar"."primary" DESC, "avatar_avatar"."date_uploaded" DESC LIMIT 1 |
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]
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
|
SELECT "accounts_usersetting"."id",
14 similar queries.
Duplicated 2 times.
"accounts_usersetting"."user_id", "accounts_usersetting"."name", "accounts_usersetting"."value" FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 17788) LIMIT 21SELECT ••• FROM "accounts_usersetting" WHERE ("accounts_usersetting"."name" = 'privacy' AND "accounts_usersetting"."user_id" = 17788) LIMIT 21 |
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 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)
/home/nathan/rb/site/rb_comments/templates/comments/comment.html |
|||||||||||||||||||||
No messages logged.
25 COMMENTS