LEGO Database

The database behind Rebrickable contains a catalog of LEGO Sets, Parts, Colors and various relationships. This LEGO catalog has been put together over many years with the help of an amazing volunteer admin team, with submissions from thousands of Rebrickable members.

A simplified version of this database is periodically extracted and is freely available for download as separate CSV files at the Downloads page. This is a valuable source of information for research purposes or to kick-start your own personal LEGO project.

Schema

If you are familiar with databases, I think the above schema is fairly self-explanatory. However, one point of confusion can be how the inventories work. A LEGO Set can consist of one or more Inventories (e.g. 8088-1) We might have multiple Inventories if the Parts in the Set were changed during it's production period, or perhaps to cater for different geographic regions.

Each Inventory can contain Parts and/or Sets. Most Inventories contain just Parts, but some consist solely of Sets (e.g. 5004559-1) or a combination of Parts and Sets (e.g. 9509-1).

Rebrickable API

You are also able to access the database through the Rebrickable API for more fine-grained access or user-specific LEGO collection data. Please refer to the documentation here.

Last modified Feb. 17, 2024 by icedragonj
DJDT

Time

Resource usage

Resource Value
User CPU time 89.336 msec
System CPU time 1.578 msec
Total CPU time 90.914 msec
Elapsed time 120.176 msec
Context switches 185 voluntary, 51 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 22.17 ms (43 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" = 'lego-database'
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'lego-database' LIMIT 21
0.47

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

Connection: default

Transaction status: Idle

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

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

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

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

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" = 57,
       "day" = '2026-01-22'::date,
       "hits" = 1
 WHERE
"help_helppagestatshistory"."id" = 203069
UPDATE "help_helppagestatshistory" SET "page_id" = 57, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203069
1.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(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.25

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

Connection: default

Transaction status: Idle

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 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.13

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 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.23

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 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.12

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 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.41

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 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.29

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 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.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" = 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.58

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

Connection: default

Transaction status: Idle

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./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.85

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.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/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 28
 ORDER BY
"help_helptopic"."order" ASC, "help_helppage"."order" ASC
SELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 28 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.29

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 10
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 10 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.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" = 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.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" = 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.11

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 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.97

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.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" = 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.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" = 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.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(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.75

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./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.27

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 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.13

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(35)
  for topic in topics:

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 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.37

Connection: default

Transaction status: Idle

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

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

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

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

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

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.