How to use Any Color for Internal Parts

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.

back to top

 

Last modified Oct. 5, 2025 by icedragonj
DJDT

Time

Resource usage

Resource Value
User CPU time 199.247 msec
System CPU time 0.907 msec
Total CPU time 200.154 msec
Elapsed time 219.623 msec
Context switches 203 voluntary, 50 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • 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
21
SELECT ••• 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
21
SELECT ••• 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
21
SELECT ••• 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())

INSERT INTO "help_helppagestatshistory" ("page_id", "day", "hits")
VALUES
(167, '2026-01-22'::date, 0) RETURNING "help_helppagestatshistory"."id"
INSERT INTO "help_helppagestatshistory" ("page_id", "day", "hits") VALUES (167, '2026-01-22'::date, 0) RETURNING "help_helppagestatshistory"."id"
0.31

Connection: default

Transaction status: In transaction

/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" = 203061
UPDATE "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
21
SELECT ••• 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)

340
341 <body class="{% block body-class %}{{ request.user.get_body_classes }}{% endblock body-class %}">
342
343 {% site_message %}
344 <div id="wrapper" class="{% block wrapper_class %}{% endblock wrapper_class %} {% if request.user.is_anonymous %}{% else %}{{ request.user.get_personalisation_options.max_width }}{% endif %}">
345
346
347 <div id="topBar" class="hidden-sm hidden-xs">

/home/nathan/rb/site/rb/templates/rb/base_root.html

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
21
SELECT ••• 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>

/home/nathan/rb/site/rb/templates/rb/base_root.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"."id" = 9
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 9 LIMIT 21
2 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)

13
14 {% block breadcrumbs %}
15 {% breadcrumb "Help" "help_index" %}
16 {% for topic in help_page.topic.get_name_tree %}
17 {% breadcrumb topic "/help/" %}
18 {% endfor %}
19 {% breadcrumb help_page.name "view_topic" help_page.id %}
20 {% endblock %}

/home/nathan/rb/site/help/templates/help/help_page.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"."id" = 4
 LIMIT
21
SELECT ••• 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:

13
14 {% block breadcrumbs %}
15 {% breadcrumb "Help" "help_index" %}
16 {% for topic in help_page.topic.get_name_tree %}
17 {% breadcrumb topic "/help/" %}
18 {% endfor %}
19 {% breadcrumb help_page.name "view_topic" help_page.id %}
20 {% endblock %}

/home/nathan/rb/site/help/templates/help/help_page.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" IS NULL
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" IS NULL ORDER 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' %}
20 {% endfor %}
21 </ul>
22 </div>

/home/nathan/rb/site/help/templates/help/includes/render_help_nav.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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 22
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 16
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 2
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 4
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 9
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 8
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 30
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 20
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 28
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 10
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 17
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 3
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 5
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 11
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 18
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/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" = 6
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

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" ASC
SELECT ••• 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 %}

/home/nathan/rb/site/help/templates/help/includes/render_help_topic_item.html

SELECT "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined"
  FROM
"auth_user"
 WHERE
"auth_user"."id" = 159879
 LIMIT
21
SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 159879 LIMIT 21
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)

49 <div id="help_body" class="mt-30">{{ help_page.body|safe }}</div>
50 <div class="clearfix">
51 <div class="text-muted pull-right">
52 <small><i>Last modified {{ help_page.last_modified_dt|date }} by {{ help_page.last_modified_by.get_username }}</i></small>
53 </div>
54 </div>
55 </div>
56 </div>

/home/nathan/rb/site/help/templates/help/help_page.html

Log messages

No messages logged.