When posting normal or modification MOCs these often contain internal parts where the shape is important, but the colour is not. Rebrickable has a feature called no color/any color which will clearly show your builders which parts are safe to substitute, and which ones need to be left as per the inventory. It also allows any colour part to be substituted when running build calculations, allowing you to get more matches with users, and allowing builders to see a more accurate percentage of the number of parts they will likely need to buy.
Using this feature is relatively easy to set up, once you know how to do it.
1. Mark any colour parts in your model
Most modelling software such as Studio doesn't allow you to choose "any color" for a part. Pick a colour that is not used elsewehere in your model, and that is preferabbly a nice contrast to other colours being used. My favourites are retired colours as I am less likely to use them, such as light purple, fabuland lime, etc. Change the colour of all internal parts to your chosen colour and check you can't see them from the outside of your model.
To help users understand your instructions, make sure to add a note to your description and/or instruction file. e.g: Purple parts in the instructions can be substituted with any color.
2. Import your inventory
Use the import function on the Inventory tab of your MOC submission to load in your model file. Don't panic if you have a bunch of inventory errors at this stage.
3. Use bulk edit to correct the colour
While on the inventory tab of your MOC, click Bulk Edit to create tick boxes to appear under your part list. (NOTE this is different to checklist mode, which also makes boxes appear). Scroll to where your internal colour is and tick the box under each part that is internal.
Scroll back to the top and click Bulk Edit Actions: Edit . This will make a pop up appear where you can change the colour of all selected parts. You will need to scroll to the bottom to find no color/any color. Once you have selected no color/any color click Update Parts.
All done! The any color parts will show up as a darkish blue, unless we don't have a render, then it will bick a different color.
default
20.90 ms (45 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" = 'any-color' LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'any-color' LIMIT 21
0.31
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" = 167 LIMIT 21SELECT ••• FROM "help_helppage" WHERE "help_helppage"."id" = 167 LIMIT 21
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(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" = 167) LIMIT 21SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-22'::date AND "help_helppagestatshistory"."page_id" = 167) LIMIT 21
8.61
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" = 167, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203061UPDATE "help_helppagestatshistory" SET "page_id" = 167, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203061
1.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(23)
help_page.inc_hits()/home/nathan/rb/site/./help/models.py in inc_hits(75)
stat.save()
SELECT "rb_sitesettings"."id", "rb_sitesettings"."name", "rb_sitesettings"."value" FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21
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/./rb/templatetags/rb_settings.py in site_message(147)
message = SiteSettings.get_site_message()/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
result = method(instance, *args, **kwargs)/home/nathan/rb/site/./rb/models/site.py in get_site_message(24)
setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
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.18
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.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_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.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)
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.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" = 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.54
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.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" = 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.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" = 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.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" = 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.18
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.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" = 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.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)/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.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" = 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.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" = 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.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" = 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.63
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.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" = 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.55
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.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(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.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" = 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.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" = 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.70
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.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(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.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(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.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" = 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.90
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.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(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.39
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.51
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.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" = 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.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" = 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.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" = 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.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" = 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.02
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 %}