The database behind Rebrickable contains a catalog of LEGO Sets, Parts, Colors and various relationships. This LEGO catalog has been put together over many years with the help of an amazing volunteer admin team, with submissions from thousands of Rebrickable members.
A simplified version of this database is periodically extracted and is freely available for download as separate CSV files at the Downloads page. This is a valuable source of information for research purposes or to kick-start your own personal LEGO project.
Schema
If you are familiar with databases, I think the above schema is fairly self-explanatory. However, one point of confusion can be how the inventories work. A LEGO Set can consist of one or more Inventories (e.g. 8088-1) We might have multiple Inventories if the Parts in the Set were changed during it's production period, or perhaps to cater for different geographic regions.
Each Inventory can contain Parts and/or Sets. Most Inventories contain just Parts, but some consist solely of Sets (e.g. 5004559-1) or a combination of Parts and Sets (e.g. 9509-1).
Rebrickable API
You are also able to access the database through the Rebrickable API for more fine-grained access or user-specific LEGO collection data. Please refer to the documentation here.
default
22.17 ms (43 queries
including 34 similar
)
Query
Timeline
Time (ms)
Action
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" WHERE "help_helppage"."slug" = 'lego-database' LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'lego-database' LIMIT 21
0.47
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(49)
help_page = get_object_or_404(HelpPage, slug=slug)
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" WHERE "help_helppage"."id" = 57 LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."id" = 57 LIMIT 21
0.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(19)
help_page = get_object_or_404(HelpPage, id=help_page_id)
SELECT "help_helppagestatshistory"."id", "help_helppagestatshistory"."page_id", "help_helppagestatshistory"."day", "help_helppagestatshistory"."hits" FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-22'::date AND "help_helppagestatshistory"."page_id" = 57) LIMIT 21SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-22'::date AND "help_helppagestatshistory"."page_id" = 57) LIMIT 21
8.58
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(23)
help_page.inc_hits()/home/nathan/rb/site/./help/models.py in inc_hits(73)
stat, created = HelpPageStatsHistory.objects.get_or_create(page=self, day=datetime.today())
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(23)
help_page.inc_hits()/home/nathan/rb/site/./help/models.py in inc_hits(73)
stat, created = HelpPageStatsHistory.objects.get_or_create(page=self, day=datetime.today())
UPDATE "help_helppagestatshistory" SET "page_id" = 57, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203069UPDATE "help_helppagestatshistory" SET "page_id" = 57, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203069
1.20
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(23)
help_page.inc_hits()/home/nathan/rb/site/./help/models.py in inc_hits(75)
stat.save()
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.25
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/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>
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" ISNULL ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" ISNULLORDER BY "help_helptopic"."order" ASC
0.22
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)
15
{% include 'help/includes/render_help_search.html' %}
16
<div class="sidebar side-nav">
17
<ul class="list-group mb-60">
18
{% for topic in help_topics %}
19
{% include 'help/includes/render_help_topic_item.html' %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 1 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 1 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 1 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 1 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.31
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 22 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 22 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.19
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 22 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 22 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.32
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 16 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 16 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 16 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 16 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.23
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 2 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 2 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.12
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 2 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 2 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.41
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 4 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 4 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 4 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 4 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 9 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 9 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 9 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 9 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.58
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 8 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 8 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 8 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 8 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.37
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 30 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 30 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.08
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 30 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 30 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.28
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 20 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 20 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.17
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 20 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 20 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.85
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 28 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 28 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 28 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 28 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.29
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 10 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 10 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.09
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 10 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 10 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.24
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 17 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 17 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.11
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 17 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 17 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.97
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 3 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 3 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.10
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 3 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 3 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.35
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 5 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 5 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.21
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 5 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 5 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.75
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 11 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 11 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.17
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 11 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 11 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.27
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 18 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 18 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.13
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 18 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 18 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.37
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helptopic"."id", "help_helptopic"."name", "help_helptopic"."order", "help_helptopic"."is_admin", "help_helptopic"."parent_topic_id" FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 6 ORDER BY "help_helptopic"."order" ASCSELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 6 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.15
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
for topic in topics:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}
SELECT "help_helppage"."id", "help_helppage"."topic_id", "help_helppage"."name", "help_helppage"."title", "help_helppage"."order", "help_helppage"."is_active", "help_helppage"."is_fixed", "help_helppage"."slug", "help_helppage"."body", "help_helppage"."last_modified_dt", "help_helppage"."last_modified_by_id", "help_helppage"."search_vector" FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 6 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASCSELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 6 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
1.31
Connection: default
Transaction status: Idle
/home/nathan/rb/site/./help/views.py in view_page(52)
return view_page_by_id(request, help_page.id)/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
return render(request, 'help/help_page.html', context)/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
for page in pages:
17
{% include 'help/includes/render_help_page_item.html' %}
18
{% endfor %}
19
{% endcomment %}
20
{% for sub in topic.get_sub_pages_and_topics %}
21
{% if sub.type == 'topic' %}
22
{% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23
{% else %}
24
{% include 'help/includes/render_help_page_item.html' with page=sub.item %}