There are several types of errors that can show up in inventories when you are submitting a MOC. This guide will explain what they mean and how to resolve them.
Rebrickable also now regularly scans published MOCs that are alternate builds looking for inventory errors and will tell you in a banner on the homepage if your MOCs contain errors. These can be corrected in similar ways to MOCs in progress. If you do not correct these errors the MOC will stop being displayed as an alternate. To restore your MOC's alternate status, simply fix the errors and request a rescan,
These types of errors are usually caused by mold varients of parts in the source set. The set inventory may have been updated since your MOC was published to correct errors, or an extra version of the inventory could have been added. To specify a specific inventory version for your MOC, list the set number with inventory at the end like this 31109-1:v1. If no version is specified, the inventory will default to the most recent version which may change over time.
When you click investigate and resolve it will take you to https://rebrickable.com/users/username/mocs/errors/ which shows a list of the problematic MOCs and gives an option to rescan your MOCs. Note that MOCs are only scanned once a week and the table is not updated automatically when you fix them. Only MOCs submitted in the last two years are scanned.
Missing Parts
If your MOC is an alternate build of a LEGO Set, all the parts in the MOC must exist in the parent set you have specified. Rebrickable automatically does a Build calculation in this scenario and highlights parts that do not match.
During the submission phase, the highlighting of alternate builds is based on the parts existing in the parent set. Once the MOC is approved (or your MOC is not an alternate build) the highlighing of parts is based on the parts existing in your buildable LEGO collection.
Parts colored red do not exist in the source set, and parts colored orange do not have enough quantity in the source set. All parts colored orange or red will need editing to remove the error. Do so by clicking the part so you see the popup details page. If the MOC is in progress Rebrickable will attempt to show suggested parts based on similar parts in the parent set. Simply click on one of the suggested parts and Save. Clicking a suggested part will update the part number and color fields to that part. If no suggestions are shown, you will need to manually edit the part number, color and/or quantity.
Another way to identify parts that are missing is to use a build calculation or the compare sets tool. This is especially useful when fixing MOCs that are already published as the colour shading will be reflecting if you have the parts in your buildable collection, rather than if they exist in the source set. Any MOCs with inventory errors will prompt you to use a build calculation or the compare tool when viewing the inventory.
In the below example I have used the compare tool and found there is one part in my MOC which doesn't exist in the donor set, this is shown on the left hand side. You can see a similar part on the right which is a mold varient of the first, it is present in the donor set but not yet used in my MOC. So to solve the error I need to replace part 30350b with part 65886 in my MOC inventory.
Spare parts are not included by the compare sets tool. Using spare parts in a MOC inventory is not considered an inventory error, however any spares used will show up on the left hand side when using the compare tool.
Click on the left hand side part, go to the Edit this Inventory Part tab, and then amend the part number and click save. Continue to do this for all parts on the left hand side (which are not spare parts).
Alternatively, if you click show Build Results this will run a build calculation with special settings that will exclude all of your buildable collection, but add a copy of the source set. This will correctly include spare parts in the calculation, but will only show the missing parts, and you will need to check the set inventory for which version is needed as a replacement.
Unknown Colors
Parts with the Unknown color usually occur when importing from a 3D file such as LEGO Digital Designer. In some cases, the colors used in the program are not configured in Rebrickable and so the Unknown Color is used instead. If you encounter these, please submit them as a Bug in the Forums, preferrably with your 3D file attached. That way, we can add a mapping for that color and future imports will work correctly.
Fix these errors by simply editing the part and picking the correct color, then Save.
Part Errors
These errors occur on parts that have not been used in any official LEGO set inventories, according to the Rebrickable database. Often the reason is because there are several part numbers for the same physical part - perhaps with slight molding differences, or maybe just duplication. Sometimes it is because the part is normally inventoried as an assembled part with multiple sub-parts.
Fix these errors by editing the part and changing the part number to the correct one.
Color Errors
If the part is using a color that has not been used in any official LEGO set inventories, you will get the Color Error. It could be because the the color imported incorrectly, or because the part is actually the wrong one.
Fix these errors by editing the part and changing the color to a correct one.
default
20.00 ms (44 queries
including 36 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" = 'fixing-moc-inventories' LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'fixing-moc-inventories' LIMIT 21
0.54
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" = 45 LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."id" = 45 LIMIT 21
0.14
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" = 45) LIMIT 21SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-22'::date AND "help_helppagestatshistory"."page_id" = 45) LIMIT 21
8.42
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" = 45, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203092UPDATE "help_helppagestatshistory" SET "page_id" = 45, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203092
2.00
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.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/./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"."id" = 4 LIMIT 21SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 4 LIMIT 21
2 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_name_tree(24)
if self.parent_topic:
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.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)
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.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" = 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.33
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.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" = 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.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/./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.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" = 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.14
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.07
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.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(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.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" = 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.57
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.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" = 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.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/./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.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" = 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.65
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.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" = 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.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" = 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.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" = 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.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" = 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.83
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.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" = 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.30
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.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" = 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.50
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.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" = 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.16
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.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" = 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.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/./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.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" = 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.
0.95
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 %}