default
2.58 ms (27 queries
including 25 similar
)
Query
Timeline
Time (ms)
Action
SELECTDISTINCT ON ("lego_badge"."code") "lego_badge"."code" FROM "lego_badge" ORDER BY "lego_badge"."code" ASCSELECT ••• FROM "lego_badge" ORDER BY "lego_badge"."code" ASC
0.22
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.12
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.10
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.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" = '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.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" = '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.10
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.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" = '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.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" = '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.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" = '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.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" = '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.08
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.08
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.08
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.08
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.08
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.10
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.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" = '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.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" = '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.08
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.08
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.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" = '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.08
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.08
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.08
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.08
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.08
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.14
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(252)
country = Country.objects.get(iso=country_code)
412
</a>
413
</li>
414
<li class="hidden-xs">
415
{% geo_currency request.user %}
416
</li>
417
{% comment %}
418
<li class="hidden-xs hidden-sm">
419
<a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>