Set Variants

Most Sets have a variant number which appears after the hyphen in the set number eg 8043-1 or 8858-2 or 71023-20. Most Sets will only have a single variant and appear as eg 8043-1. Those that have two are usually caused by regional releases of the same Set with different packaging or instructions, etc.

In some cases there are multiple variants simply because LEGO reused the main set number for completely different Sets - eg 421-1 and 421-2.

We also use different variants in the Collectible Minifigs theme where the set number is used to identify the box with all the figs and a different variant to identify each individual minifig.

Inventories

Each Set can also have one or more inventories.

A new inventory is created when LEGO change the contents of a Set over time. For example, to replace a part that has been causing problems or some other unknown reason. For example 31015-1 has been seen to come with either part 3731 or 15456 so there is one inventory for each.

We can also have multiple inventories when a Set can come with different or random parts sugh as 421-2 which came in five different colors.

Each inventory has a version number, and you can select which version of a Set you own when you are adding it to your LEGO Collection. If you do not care which version of a Set you want to work with, the latest version is usually the most common and is the one shown by default.

Last modified Feb. 18, 2024 by icedragonj
DJDT

Time

Resource usage

Resource Value
User CPU time 64.049 msec
System CPU time 0.926 msec
Total CPU time 64.975 msec
Elapsed time 83.164 msec
Context switches 193 voluntary, 1 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 19.46 ms (44 queries including 36 similar )
Query Timeline Time (ms) Action
SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 WHERE
"help_helppage"."slug" = 'set-variants-and-inventories'
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'set-variants-and-inventories' LIMIT 21
0.29

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" = 96
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."id" = 96 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(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" = 96)
 LIMIT
21
SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-31'::date AND "help_helppagestatshistory"."page_id" = 96) LIMIT 21
8.53

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

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" = 96,
       "day" = '2026-01-31'::date,
       "hits" = 1
 WHERE
"help_helppagestatshistory"."id" = 203199
UPDATE "help_helppagestatshistory" SET "page_id" = 96, "day" = '2026-01-31'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203199
1.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(23)
  help_page.inc_hits()

/home/nathan/rb/site/./help/models.py in inc_hits(75)
  stat.save()

SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM
"countries_plus_country"
 WHERE
"countries_plus_country"."iso" = 'US'
 LIMIT
21
SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
0.15

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./rb/templatetags/rb_geo.py in geo_currency(20)
  geo_data = user.geo.get_user_currency()

/home/nathan/rb/site/./geo/geo.py in get_user_currency(252)
  country = Country.objects.get(iso=country_code)

412 </a>
413 </li>
414 <li class="hidden-xs">
415 {% geo_currency request.user %}
416 </li>
417 {% comment %}
418 <li class="hidden-xs hidden-sm">
419 <a href={% if request.user.is_authenticated %}"{% url 'user_profile_settings' request.user.get_username %}#personalisation"{% else %}"#" onclick="return false;"{% endif %} title="All date/times are being converted to this timezone">{% get_user_timezone request.user %}</a>

/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" = 3
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 3 LIMIT 21
2 similar queries.
0.08

Connection: default

Transaction status: Idle

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

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

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" = 17
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 17 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.08

Connection: default

Transaction status: Idle

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

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

15 {% include 'help/includes/render_help_search.html' %}
16 <div class="sidebar side-nav">
17 <ul class="list-group mb-60">
18 {% for topic in help_topics %}
19 {% include 'help/includes/render_help_topic_item.html' %}
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.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" = 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.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" = 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.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" = 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.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" = 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.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" = 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.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" = 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.20

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./help/views.py in view_page_by_id(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.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" = 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.46

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./help/views.py in view_page_by_id(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.69

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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.