Build Engine

One of the unique features of Rebrickable is the Build Engine. Basically - you tell Rebrickable what LEGO sets and parts you own and it will tell you what other LEGO models you can build with them.

Build Source

Your LEGO collection is the main input to the Build Engine. Rebrickable calculates your total list of owned parts based on your:

You can indicate which Set Lists/Part Lists can be used in the builds, as there may be some parts you want to keep intact and not used to build other things.

Build Target

You can choose to Build a Set or MOC or a Custom List.

Settings

There are many settings you can change to impact the behaviour of the build. 

Color Sensitivity - there are three options for this setting (Exact, Similar, Ignore). They determine how close the color of the source and target parts need to be to consider them a match. If you are on the Pro Plan you can also customise in detail how the colors are matched.

Part Relationships - you can ignore part differences such as Printed/Patterned parts, Mold variations, or Alternate parts which can usually be used as replacements but are not always functionally compatible.

Ignored Parts - you can exclude certain part categories from the build calculations such as Minifig/Minifig Accessories, and non-LEGO parts such as stickers, books, etc.

For more details see Build Settings.

Results

Once the Build Engine finishes its calculations, it will display the parts you need to complete the build.

In addition to the Missing Parts tab, there is a Suggested Sets tab that displays a list of LEGO Sets you can buy that contain the parts you are missing.

Special Cases

There are some parts you may come across in MOCs or Custom Lists that use [No Color/Any Color] as their color. This is a special color used to indicate that it doesn't matter what color the part is. It is meant to be used for parts inside MOCs that can't be seen. The Build Engine takes these into consideration and will match the part accordingly.

LEGO Set inventories have Normal and Spare parts. If you are building a Set, only the Normal parts are required for the build and the Spare parts are ignored. However, spare parts from the sets in your LEGO Collection are included (unless you have specifically excluded them).

Last modified Feb. 17, 2024 by icedragonj
DJDT

Time

Resource usage

Resource Value
User CPU time 168.526 msec
System CPU time 6.090 msec
Total CPU time 174.616 msec
Elapsed time 201.153 msec
Context switches 267 voluntary, 11 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 26.68 ms (45 queries including 34 similar )
Query Timeline Time (ms) Action
SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 WHERE
"help_helppage"."slug" = 'build-engine'
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'build-engine' LIMIT 21
10.46

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" = 73
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."id" = 73 LIMIT 21
0.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(19)
  help_page = get_object_or_404(HelpPage, id=help_page_id)

SELECT "help_helppagestatshistory"."id",
       "help_helppagestatshistory"."page_id",
       "help_helppagestatshistory"."day",
       "help_helppagestatshistory"."hits"
  FROM
"help_helppagestatshistory"
 WHERE
("help_helppagestatshistory"."day" = '2026-01-31'::date AND "help_helppagestatshistory"."page_id" = 73)
 LIMIT
21
SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-31'::date AND "help_helppagestatshistory"."page_id" = 73) LIMIT 21
0.71

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
(73, '2026-01-31'::date, 0) RETURNING "help_helppagestatshistory"."id"
INSERT INTO "help_helppagestatshistory" ("page_id", "day", "hits") VALUES (73, '2026-01-31'::date, 0) RETURNING "help_helppagestatshistory"."id"
0.80

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" = 73,
       "day" = '2026-01-31'::date,
       "hits" = 1
 WHERE
"help_helppagestatshistory"."id" = 203129
UPDATE "help_helppagestatshistory" SET "page_id" = 73, "day" = '2026-01-31'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203129
1.36

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.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_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.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./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" = 10
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 10 LIMIT 21
0.57

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

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.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)

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.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" = 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.
1.26

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.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" = 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.68

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.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" = 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.24

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.38

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.56

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.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" = 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.
1.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" = 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.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" = 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.65

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.31

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.95

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.24

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.19

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.99

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.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" = 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.28

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.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" = 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.45

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.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" = 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.14

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(37)
  for page in pages:

17 {% include 'help/includes/render_help_page_item.html' %}
18 {% endfor %}
19 {% endcomment %}
20 {% for sub in topic.get_sub_pages_and_topics %}
21 {% if sub.type == 'topic' %}
22 {% include 'help/includes/render_help_topic_item.html' with topic=sub.item %}
23 {% else %}
24 {% include 'help/includes/render_help_page_item.html' with page=sub.item %}

/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.21

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./help/views.py in view_page(52)
  return view_page_by_id(request, help_page.id)

/home/nathan/rb/site/./help/views.py in view_page_by_id(45)
  return render(request, 'help/help_page.html', context)

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(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.71

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.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)

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

SELECT "rb_globalstats"."id",
       "rb_globalstats"."num_sets",
       "rb_globalstats"."num_mocs",
       "rb_globalstats"."num_parts",
       "rb_globalstats"."num_users",
       "rb_globalstats"."num_figs",
       "rb_globalstats"."num_designers"
  FROM
"rb_globalstats"
 LIMIT
1
SELECT ••• FROM "rb_globalstats" LIMIT 1
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_settings.py in get_stats(32)
  return GlobalStats.get_stats()

/home/nathan/rb/site/./cache/utils.py in cache_wrapper(98)
  result = method(instance, *args, **kwargs)

/home/nathan/rb/site/./rb/models/stats.py in get_stats(46)
  return stats[0]

49
50 <div class="col-lg-3 col-md-3 col-sm-3 hidden-xs">
51 <ul class="list-unstyled">
52 {% get_stats as stats %}
53 <li><i class="fa fa-fw fa-cube"></i> <a href="{% url 'find_sets' %}">Sets</a> x {{ stats.num_sets|intcomma }}</li>
54 <li><i class="fa fa-fw icon-lego-brick"></i> <a href="{% url 'find_parts' %}">Parts</a> x {{ stats.num_parts|intcomma }}</li>
55 <li><i class="fa fa-fw fa-user-secret"></i> <a href="{% url 'find_minifigs' %}">Minifigs</a> x {{ stats.num_figs|intcomma }}</li>
56 <li><i class="fa fa-fw fa-rocket"></i> <a href="{% url 'browse_mocs' %}">MOCs</a> x {{ stats.num_mocs|intcomma }}</li>

/home/nathan/rb/site/rb/templates/rb/includes/footer.html

Log messages

No messages logged.