Guide to LDD (LEGO Digital Designer)

Introduction
Installation
First Steps
Creating Instructions
Getting Help
Import/Export
Rendering
Tutorials
Video Guides
Conclusion
Useful Links
Tips & Tricks
Keyboard Shortcuts

Introduction

What is LDD?

LEGO Digital Designer (LDD) was a freeware computer program produced by the Lego Group as a part of LEGO Design byME, but has since been officially retired and replaced with BrickLink Studio. You are no longer able to download LDD from LEGO.com and will instead be redirected to download BrickLink Studio. 

BrickLink has a lengthy FAQ regarding the switch from LDD to Studio which you can read here.

What is this Guide to LDD?

With a bit over 7000 MOCs on Rebrickable having a LDD (.lxf) file as their primary instruction type, this guide will go through how you can still use these files. If you want to load the file into BrickLink Studio and generate instructions there, please see this guide on making instructions in Studio.

This guide also contains information on how to use LDD, which has been left in for those who might already have the sofware and wish to keep using it.

What do I do with this LXF file?

A .lxf file is a three-dimensional model or scene created by LDD. It is saved in a compressed .ZIP format and contains two files: IMAGE100.PNG (a .PNG design preview) and IMAGE100.LXFML (the .LXFML design specified in XML). The good news is .lxf files can be opened directly in BrickLink Studio. BrickLink mentions in their FAQ you might experience some issues when importing a LDD file:

"You might encounter missing parts, especially if they’re decorated (printed) parts. Some parts may be oriented incorrectly, or they could be out of place. This is because of differences in the origin and orientation between LDD and Studio parts. You may need to spend some time cleaning up your imported models.

If you see parts that appear as transparent outlines, it is because they are colliding with other parts. This might be because of small alignment issues that you can adjust. You can also turn off collision detection by pressing the Collision button in the top toolbar.

You might also get an “unavailable color” warning for some parts. This shows up in the Step List on the right-hand side as a yellow “!” next to the part name. To resolve this, use the Color Validator"

What if I already have LDD installed, can I keep using it?

You can continue to use LDD in offline mode if you already have it installed, at least until a future operating system update starts causing problems. The software is no longer being maintained, so will not be patched to work with newer versions of Windows or MacOS. No new parts will be added to the database. Using a modern file type will allow more people to be able to easily access your MOC, so I would recommend checking out Bricklink Studio and then making the switch.

The rest of this guide was mostly written before LDD was retired and has been left in for those who already have LDD and wish to keep using it (or at least to keep using it for files they have already created). 

Back to Top

Installation

The final version of LEGO Digital Designer, 4.3.12, was available at LEGO.com, but is no longer hosted by LEGO. You may still be able to find it on third party websites, but use extreme caution if downloading from these places as it has an increased risk of viruses or other malicious software. The program comes in two versions, one for MAC OSx and one for Microsoft Windows. The Windows version will run flawlessly on Linux under Wine. Click on the Download Now button to download the desired version.

Please note the disclaiming below the download buttons: "The LEGO Group of companies (LEGO) is providing LEGO® Digital Designer (the Software) at no charge. Any commercial use of the software is strictly prohibited." This prohibition is repeated in the License Agreement included with the software.

For Windows: save and run the installation program setupldd-pc-4_3_11.exe (326.6 MB). The program will then unzip and start the installer. After selecting your language you want make sure that the licence agreement is ticked and then click next. If needed, add a shortcut to the desktop and then click next. You can then select weather you would like to install for the current user or all users. After clicking Install the software will be extracted. Then click Finish to end the installer. You should now have a LEGO Company menu group with LEGO Digital Designer, Safe Mode and two Help options.

For Linux: open the installation program setupldd-pc-4_3_11.exe with the Wine Windows Program Loader. Make sure Wine is fully initialized before starting the installation (run Configure Wine at least once). Then follow the procedure above.

For MAC: save and double-click the installation archive SetupLDD-MAC-4_3_11.zip (323.8 MB). If you get an error message that says the program "can't be opened because it wasn't downloaded from the Mac App Store," right-click the downloaded file and select Open. The Mac installation file is named LDD.pkg. Once the installer starts, follow the procedure above.

First Steps

Each time the program is started, it would previously connect to the Internet to download newly added bricks, however this feature is no longer supported. You will get a popup saying internet access has failed. To proceed you will need to run LDD in offline mode. The Menu > Help > About box shows the version number of the latest brick download (Brick Version: 2670).

The opening dialog shows a selection panel on the right with recently used models, an "Open another file" icon and a "Free build" icon. LDD models have an .lxf extension. To load an existing model click Open existing file and select the model. The top of the opening dialog contains three tabs, named "Digital Designer", "Mindstorms" and "Digital Designer Extended". These are themes that determine the contents of the parts library. At any moment, the theme can be changed using Menu > View > New Themes. The default theme, Digital Designer, contains a part library with available colors for each part. More about themes in Tips & Tricks

LDD follows the common "left-click is select" convention, while right-click & drag is used to alter the angle of the 3D view. The mouse scroll-wheel is used to zoom in and out. The large arrows against the sides of the 3D view also change the view angle. Besides the bottom arrow there are three smaller icons:

  • to the left, curled arrow: show all with highest zoom
  • to the right, plus: zoom in (bricks get bigger)
  • to the right, minus: zoom out (bricks get smaller)

The left of the screen contains the parts library, consisting of 37 part categories. When clicked the category unfolds to show all its parts. Click again to collapse the category and hide its parts. Right-click to select and drag the part to its place. Parts will automatically snap to the grid and connect to other parts.

The menu bar contains common options such as File, Edit, View and Help, as well as a Toolbox menu to select a tools. The default toolset (also available as icons below the menu bar) consists of:

  • Single Selection tool (V) - to select single bricks in the scene
  • Clone tool (C) - to make duplicates of bricks in the scene
  • Hinge tool (H) - to rotate bricks that are connected with a hinge or a single-stud connection
  • Hinge Align tool (shift-H) - to automatically connect two separate connection points
  • Flex tool - to bend and twist flexible elements
  • Paint tool (B) - to change the color or material of bricks in the scene.
  • Hide tool (L) - to hide bricks or models
  • Delete tool (D) - to remove bricks from scene

For a more detailed description of camera control, the icon and menu bar, and building tools and palette, see Getting Help.

Creating Instructions

If you have downloaded an LDD .lxf file for a Rebrickable MOC, and you wish to generate instructions, follow this procedure:

  • Start LEGO Digital Designer
  • Select Open another file
  • Locate the model and select Open
  • Press Building guide mode icon (top/right) or press F7
  • Use the Next brick (right arrow) to browse the pages
  • Press Create HTML building guide (top/left) or ctrl-H
  • Select the folder where you want to save your building guide and press OK

In LDD you can browse through the building proces and actually see where each individual part is placed, as the proces is animated and the parts literally fall down into the model. When generated as a HTML building guide the build is divided into pages, which each page containing upto four parts, which are placed simultaniously. Usually the proces is much easier to follow in LDD itself. If you have a choice, use the model in LDD instead of a generated HTML building guide.

There is also an Android App for viewing .lxf files: BricksViewer, a .lxf scene viewer (free).

Getting Help

The LEGO Digital Designer 4.3 User Manual is included with the software and stored in Program Files (x86)/LEGO Company/LEGO Digital Designer/Help/en-manual/en-manual.html. The Readme file contains system requirements and the latest information about the software release. It is stored in Program Files (x86)/LEGO Company/LEGO Digital Designer/Help/en-manual/engReadMe.html. Both files are available in German and English, can be displayed by any browser, and can be accessed externally (main menu) and internally (program help menu)

The User Manual is also available as a PDF at lego.com

If you encounter any problems, refer to the Readme first. If needed, check the Eurobricks Forum in the Useful Links below. If the problem remains, post a question in our Help Forum.

Import/Export

The Import function in LDD has two different form of usage: adding and converting. If you want to add two or more models into a scene, you can't use Open, for that will clear the 3D work area before adding the new model. So after opening the first model, the only way to add a second model is to import it using Menu > File > Import > LXF-Files. The scene, now containing two models, can be saved as usual as a single .lxf file.

If you try to open an .lxf file created by an earlier version of LDD, you might get an error beep and some parts might not be displayed. In that case, try importing the model, which will perform the necessary changes.

The available export formats in Menu > File > Export are:

  • LXF-Files
  • LXFML-Files
  • LDraw-Files
  • LXFML4-Files .lxfml

LXF / LXFML / LXFML4-Files

An .lxf file is a compressed .zip file that contains two other files: a .png image (the design preview, used to display the model in LDD's opening dialog) and a .lxfml text file, which describes the models or scene. LXFML stands for LEGO eXchange Format Markup Language, and it was developed in 2005 by LEGO System A/S. The latest version, 5.0 is used when exporting LXFML files, while LXFML4 uses the previous version 4.0. The LXFML files contain a textual description of a model or a scene in a highly structured and hierarchical format, known as XML. As these files can be opened by any text editor, they can be used to change, for example, the brick colors or camera position.

LDraw-Files

LDraw is not a single program, but a parts library based upon the LDraw file-format, and a collection of programs that can use that part-library in some way (see Virtual Building). By using a list that maps LEGO element ids (or LEGO part numbers) to LDraw part numbers, LDD can create an LDraw file that can be read by other programs. The translation table for this mapping is a file called ldraw.xml, in the LEGO Digital Designer folder (see Tips & Tricks).

Export Part List (BOM - Bill of Materials)

A final export is available under Menu > File > Export BOM, which allows exporting a list of used parts in either an Office Open XML Workbook (.xls) or a ZIP-File. A similar list of parts (though much better looking) is added to the generated building guide (see Creating Instructions).

Rendering

LDD can not generate photo-realistic images of models or scenes, but there are several programs available that can render (create a photo-realistic image) a .lxf file. More about these programs in our Guide to Rendering.

However, LDD can generate images similar to what is shown on the screen while building. There are two ways to create such images:

  • In Build mode, you can take a Screenshot by using Menu > Tool Box > Take a screenshot or pressing ctrl-K. In the Save screenshot dialog you can enter a name for your image, which is saved as a .png file with a transparent background. Using a graphics editor you can add any background to that image.
  • In View mode (Menu > View > View Mode or F6) the model is displayed against a default desert/dunes background. You can chnage the background using Menu > Edit > Change background or ctrl-F. Besides the desert/dunes background LDD contains a jungle/mountains, clouds/ocean and stars/space background. Using Menu > Tool Box > Take a screenshot or ctrl-K you can create an image of your model with that particular background.

Tutorials

I have not been able to find any good general text tutorials on LEGO Digital Designer, because nowadays, tutorials are mostly done in video. Below you will find some links to video tutorials that provide a decent amount of good information. When it comes to specific problems with LDD, such as creating custom decorations, a little searching on the internet usually gets you an answer. Here are some of the special tutorials I found most interesting.

  • Adding Custom Decals into LEGO Digital Designer - This tutorial will show you how to mod in custom textures to LDD so that you can use them in your models, and includes a little section at the end on setting these models up for rendering in POV-Ray.

Video Guides

  • Lego Digital Designer - Basic Tutorial, published on Mar 13, 2014, by Joseph Depalma. A beginners tutorial that looks to help users figure out some of the more basic functions of LDD.
  • LEGO Digital Designer Tools Explained, published on Jul 24, 2015, by Virtual Robotics. A look at the tools that make up LEGO Digital Designer and a demo of their use.
  • How to Get Building Instructions and BOM from an LDD Model, published on Jan 19, 2017, by Builderdude35. How to create printable building instructions and a parts list/bill of materials for a model that you have created in Lego Digital Designer.
  • Lego Digital Designer Tips and Tricks - 1/2, published on Oct 19, 2014, by Isaac Lloyd.
  • Lego Digital Designer Tips and Tricks - 2/2, published on Oct 19, 2014, by Isaac Lloyd.

Conclusion

LEGO Digital Designer was a wonderful program for its time. It looks great, it is easy to understand, intuitive to control, it had a massive amount of LEGO parts, lots of great features, and it was fun to work with. It definately lives up to Ole Kirk Kristiansen's motto for the LEGO company, "Det bedste er ikke for godt" (Only the best is good enough). Now that it is officially retired it will continue to grow more obsolete as LEGO releases more new parts and colors that won't be supported. Thankfully it has a well deserved sucessor in BrickLink Studio.

Back to Top

  • Secrets of LDD - 10 useful tips for LEGO Digital Designer
  • Eurobricks - LEGO Digital Designer and other digital tools (Forum Index)

Tips & Tricks

Theme

LEGO Digital Designer has three themes, that influence the building palette (parts library) and the available tools.

  • Digital Designer (Default) - 37 part categories, all colors.
  • Mindstorms - 26 part categories, only available colors.
  • Digital Designer Extended - 37 part categories, all colors.

In the Default theme, the building palette contains each available for each part. For some parts this means 50 of 60 different colors. In the Extended theme, the building palette is simplified , as each type of brick appears only once, in red. After adding the parts to the 2D work area, you can change the color to any color using the Paint tool, and you can use colors that are not available for the real part. There are also more parts available in Extended mode.

ldraw.xml

The version of ldraw.xml that is installed by default is LDD 4.3.6 Brick ver 1033. The latest version, LDD 4.3.11 Brick ver 2670, is available here.

Keyboard Shortcuts

Viewpoint controller: PC MAC
Rotate view left 4 Key (NumLock: ON) 4 Key (NumLock: ON)
Rotate view right 6 Key (NumLock: ON) 6 Key (NumLock: ON)
Rotate view up 8 Key (NumLock: ON) 8 Key (NumLock: ON)
Rotate view down 2 Key (NumLock: ON) 2 Key (NumLock: ON)
Reset view 5 Key (NumLock: ON) 5 Key (NumLock: ON)
Zoom in + Key (NumLock: ON) + Key (NumLock: ON)
Zoom out - Key(NumLock: ON) - Key (NumLock: ON)

Building tools:
Select tool V-Key V-Key
Toggle Select tools Shft+V Shft+V
Hinge tool H-Key H-Key
Hinge Align tool Shft+H Shft+H
Clone tool C-Key C-Key
Paint tool B-Key B-Key
Hide tool L-Key L-Key
Delete tool D-Key D-Key

Grouping tool:
Create groups Ctrl+G Cmd+G

Templates:
Create a template Ctrl+Alt+G Cmd+Alt+G

Icon bar:
Open Ctrl+O Cmd+O
Save Ctrl+S Cmd+S
Print Ctrl+P Cmd+P
Undo Ctrl+Z Cmd+Z
Redo Shft+Ctrl+Z Shft+Cmd+Z
Upload to Gallery Shft+Ctrl+B Shft+Cmd+B

Building Guide controller:
Next brick Right arrow Right arrow
Previous brick Left arrow Left arrow
Repeat Last Step Space Space
Next step PageDn PageDn
Previous step PageUp PageUp
Output as HTML Ctrl+H Cmd+T

Menu items:
Import model Ctrl+I Cmd+I
Export model Ctrl+E Cmd+E
Save as Shft+Ctrl+S Shft+Cmd+S
Exit Ctrl+Q or Alt+F4 Cmd+Q
Cut Ctrl+X Cmd+X
Copy Ctrl+C Cmd+C
Paste Ctrl+V Cmd+V
Delete Delete Key Delete Key
Select All Ctrl+A Cmd+A
Help F1 Key F1 Key
What is this? F2 Key F2 Key
About F3 Key F3 Key
Preferences Ctrl+6 Cmd+,
Show/Hide Brick Palette Ctrl+1 Cmd+1
Show/Hide Tool Palette Ctrl+2 Cmd+2
Show/Hide Web Browser Ctrl+3 Cmd+3

Note: Mac shortcuts can vary depending on your country.

Last modified Feb. 17, 2024 by icedragonj
DJDT

Time

Resource usage

Resource Value
User CPU time 164.029 msec
System CPU time 0.000 msec
Total CPU time 164.029 msec
Elapsed time 181.572 msec
Context switches 208 voluntary, 7 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 18.52 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" = 'guide-to-lego-digital-designer'
 LIMIT
21
SELECT ••• FROM "help_helppage" WHERE "help_helppage"."slug" = 'guide-to-lego-digital-designer' LIMIT 21
0.39

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

Connection: default

Transaction status: Idle

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

/home/nathan/rb/site/./help/views.py in view_page_by_id(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" = 42)
 LIMIT
21
SELECT ••• FROM "help_helppagestatshistory" WHERE ("help_helppagestatshistory"."day" = '2026-01-22'::date AND "help_helppagestatshistory"."page_id" = 42) LIMIT 21
8.48

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

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" = 42,
       "day" = '2026-01-22'::date,
       "hits" = 1
 WHERE
"help_helppagestatshistory"."id" = 203100
UPDATE "help_helppagestatshistory" SET "page_id" = 42, "day" = '2026-01-22'::date, "hits" = 1 WHERE "help_helppagestatshistory"."id" = 203100
1.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(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.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/./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" = 20
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 20 LIMIT 21
2 similar queries.
0.13

Connection: default

Transaction status: Idle

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."id" = 4
 LIMIT
21
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."id" = 4 LIMIT 21
2 similar queries.
0.07

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_name_tree(24)
  if self.parent_topic:

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" IS NULL
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" IS NULL ORDER BY "help_helptopic"."order" ASC
0.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.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" = 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.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" = 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.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" = 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.14

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

/home/nathan/rb/site/./help/models.py in get_sub_pages_and_topics(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.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" = 20
 ORDER BY
"help_helptopic"."order" ASC, "help_helppage"."order" ASC
SELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 20 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.70

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 17
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 17 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.09

Connection: default

Transaction status: Idle

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

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 5
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 5 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.07

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 11
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 11 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.07

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 11
 ORDER BY
"help_helptopic"."order" ASC, "help_helppage"."order" ASC
SELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 11 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
0.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(37)
  for page in pages:

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 18
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 18 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.07

Connection: default

Transaction status: Idle

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

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

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

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

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

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

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helptopic"."id",
       "help_helptopic"."name",
       "help_helptopic"."order",
       "help_helptopic"."is_admin",
       "help_helptopic"."parent_topic_id"
  FROM
"help_helptopic"
 WHERE
"help_helptopic"."parent_topic_id" = 6
 ORDER BY
"help_helptopic"."order" ASC
SELECT ••• FROM "help_helptopic" WHERE "help_helptopic"."parent_topic_id" = 6 ORDER BY "help_helptopic"."order" ASC
17 similar queries.
0.07

Connection: default

Transaction status: Idle

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

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

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

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

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

SELECT "help_helppage"."id",
       "help_helppage"."topic_id",
       "help_helppage"."name",
       "help_helppage"."title",
       "help_helppage"."order",
       "help_helppage"."is_active",
       "help_helppage"."is_fixed",
       "help_helppage"."slug",
       "help_helppage"."body",
       "help_helppage"."last_modified_dt",
       "help_helppage"."last_modified_by_id",
       "help_helppage"."search_vector"
  FROM
"help_helppage"
 INNER JOIN
"help_helptopic"
    ON
("help_helppage"."topic_id" = "help_helptopic"."id")
 WHERE
"help_helppage"."topic_id" = 6
 ORDER BY
"help_helptopic"."order" ASC, "help_helppage"."order" ASC
SELECT ••• FROM "help_helppage" INNER JOIN "help_helptopic" ON ("help_helppage"."topic_id" = "help_helptopic"."id") WHERE "help_helppage"."topic_id" = 6 ORDER BY "help_helptopic"."order" ASC, "help_helppage"."order" ASC
17 similar queries.
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 "auth_user"."id",
       "auth_user"."password",
       "auth_user"."last_login",
       "auth_user"."is_superuser",
       "auth_user"."username",
       "auth_user"."first_name",
       "auth_user"."last_name",
       "auth_user"."email",
       "auth_user"."is_staff",
       "auth_user"."is_active",
       "auth_user"."date_joined"
  FROM
"auth_user"
 WHERE
"auth_user"."id" = 159879
 LIMIT
21
SELECT ••• FROM "auth_user" WHERE "auth_user"."id" = 159879 LIMIT 21
0.12

Connection: default

Transaction status: Idle

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

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

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

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

Log messages

No messages logged.