default
1.97 ms (27 queries
including 25 similar
)
Query
Timeline
Time (ms)
Action
SELECTDISTINCT ON ("lego_badge"."code") "lego_badge"."code" AS "code" FROM "lego_badge" ORDER BY 1 ASCSELECT ••• FROM "lego_badge" ORDER BY 1 ASC
0.24
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(19)
for badge_code in badge_codes:
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'AGE' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'AGE' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'CHRM' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'CHRM' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'COMM' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'COMM' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'CR' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'CR' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'FIRST' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'FIRST' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'FOL' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'FOL' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'FOLD' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'FOLD' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'HEAD' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'HEAD' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'LIKD' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'LIKD' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'LIKE' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'LIKE' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'LNKBO' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'LNKBO' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'LNKBS' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'LNKBS' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.05
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'MB' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'MB' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'MOC' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'MOC' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'MS' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'MS' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'PART' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'PART' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.07
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'PHOTO' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'PHOTO' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'POP' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'POP' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'RFOL' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'RFOL' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'SETS' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'SETS' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'SUBPT' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'SUBPT' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'SUBS' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'SUBS' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'SW' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'SW' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.06
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'TECH' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'TECH' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.05
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
SELECT "lego_badge"."id", "lego_badge"."code", "lego_badge"."level", "lego_badge"."name", "lego_badge"."descr", "lego_badge"."num_users" FROM "lego_badge" WHERE "lego_badge"."code" = 'WATCH' ORDER BY "lego_badge"."level" ASCSELECT ••• FROM "lego_badge" WHERE "lego_badge"."code" = 'WATCH' ORDER BY "lego_badge"."level" ASC
25 similar queries.
0.05
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(23)
for i, badge in enumerate(badge_levels):
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.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./lego/views/badges.py in badges(38)
return render(request, 'badges/badges.html', {'badges': badges})/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
geo_data = user.geo.get_user_currency()/home/nathan/rb/site/./geo/geo.py in get_user_currency(253)
country = Country.objects.get(iso=country_code)
74
</a>
75
</li>
76
<li>
77
{% geo_currency request.user %}
78
</li>
79
{% comment %}
80
<li class="hidden-xs hidden-sm">
81
<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>