Build more. Buy fewer bricks.

Build something new with the LEGO® bricks you already own

Add your collection and Rebrickable will show you which fan-designed creations you can build today.

Explore MOCs Add my collection

Explore more than 204,000 MOCs, with new designs added every day.

Made by the community

Find a build that inspires you

Find MOCs to Build

How Rebrickable works

Turn your collection into your next build

Tell us which LEGO® sets and parts you own. We do the matching so you can spend more time building.

  1. Add your collection

    Quickly catalogue the sets and loose parts you already have.

  2. We match your bricks

    Rebrickable analyses your inventory against thousands of fan-designed creations.

  3. Choose your next build

    See what you can build now, or exactly which extra parts you need.

Add my LEGO collection

Your collection, made useful

Know what you own, and what you can build

Keep your sets, loose parts and minifigures in one place. Rebrickable calculates your inventory and finds creations that match it.

  • Track sets, parts, colours and quantities
  • Find MOCs you can build with what you own
  • Discover alternate builds for existing sets
Start my collection Browse alternate builds
Organised LEGO bricks ready to build with
A detailed fan-designed LEGO creation

For designers

Design, share and sell to millions of LEGO fans

Publish free instructions or sell Premium MOCs in the largest dedicated MOC marketplace. You set the price and keep control of your creations.

  • 2,203,988potential builders
  • simple publishing
  • sales and analytics
Learn about selling MOCs

From the Rebrickable blog

Reviews, News and Stories

View all articles
DJDT

Time

Resource usage

Resource Value
User CPU time 133.864 msec
System CPU time 0.000 msec
Total CPU time 133.864 msec
Elapsed time 186.413 msec
Context switches 85 voluntary, 6 involuntary

Browser timing

Timing attribute Timeline Milliseconds since navigation start (+length)

SQL queries from 1 connection

  • default 42.57 ms (19 queries including 12 similar )
Query Timeline Time (ms) Action
select moc_id as id,
       score
  from lego_popularmocs x
  join lego_baseset s
    on s.id=x.moc_id
 where s.is_active
 order by score desc, s.id desc
OFFSET 0
 LIMIT 6 select moc_id as id, score from lego_popularmocs x join lego_baseset s on s.id=x.moc_id where s.is_active order by score desc, s.id desc OFFSET 0 LIMIT 6
1.47

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(46)
  context['popular_mocs'] = Moc.get_popular_mocs(num_days=3, limit=6, hosted_only=True)

/home/nathan/rb/site/./lego/models/mocs.py in get_popular_mocs(1011)
  moc_scores = run_sql(f"""

/home/nathan/rb/site/./rb/utils.py in run_sql(793)
  cursor.execute(sql, params)
SELECT "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "lego_theme"."id",
       "lego_theme"."parent_id",
       "lego_theme"."name",
       "lego_theme"."slug",
       "lego_theme"."set_count",
       "lego_theme"."t1_id",
       "lego_theme"."t1_name",
       "lego_theme"."t2_name",
       "lego_theme"."t3_name",
       "lego_theme"."lego_blurb",
       "lego_theme"."banner_img",
       "lego_theme"."descr",
       T4."id",
       T4."parent_id",
       T4."name",
       T4."slug",
       T4."set_count",
       T4."t1_id",
       T4."t1_name",
       T4."t2_name",
       T4."t3_name",
       T4."lego_blurb",
       T4."banner_img",
       T4."descr",
       T5."id",
       T5."parent_id",
       T5."name",
       T5."slug",
       T5."set_count",
       T5."t1_id",
       T5."t1_name",
       T5."t2_name",
       T5."t3_name",
       T5."lego_blurb",
       T5."banner_img",
       T5."descr",
       "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",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       T10."id",
       T10."set_num",
       T10."name",
       T10."year",
       T10."theme_id",
       T10."set_type",
       T10."num_parts",
       T10."default_inventory_id",
       T10."is_active",
       T10."is_accessory",
       T10."added_dt",
       T10."added_by_id",
       T10."last_modified_dt",
       T10."last_modified_by_id",
       T10."active_change_dt",
       T10."active_change_by_id",
       T10."last_checked_for_bi",
       T10."descr",
       T10."primary_photo_id",
       T10."primary_moc_image_id",
       T10."is_gear",
       T10."is_book",
       T10."search_vector",
       T10."mfhash_vector",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 INNER JOIN "lego_theme"
    ON ("lego_baseset"."theme_id" = "lego_theme"."id")
  LEFT OUTER JOIN "lego_theme" T4
    ON ("lego_theme"."parent_id" = T4."id")
  LEFT OUTER JOIN "lego_theme" T5
    ON (T4."parent_id" = T5."id")
 INNER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
 INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
  LEFT OUTER JOIN "lego_baseset" T10
    ON ("lego_moc"."parent_set_1_id" = T10."id")
  LEFT OUTER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
 WHERE ("lego_baseset"."is_active" AND "lego_moc"."baseset_ptr_id" IN (361193, 361052, 361151, 361291, 358357, 361210))SELECT ••• FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_theme" ON ("lego_baseset"."theme_id" = "lego_theme"."id") LEFT OUTER JOIN "lego_theme" T4 ON ("lego_theme"."parent_id" = T4."id") LEFT OUTER JOIN "lego_theme" T5 ON (T4."parent_id" = T5."id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") LEFT OUTER JOIN "lego_baseset" T10 ON ("lego_moc"."parent_set_1_id" = T10."id") LEFT OUTER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."baseset_ptr_id" IN (361193, 361052, 361151, 361291, 358357, 361210))
 2.30

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(46)
  context['popular_mocs'] = Moc.get_popular_mocs(num_days=3, limit=6, hosted_only=True)

/home/nathan/rb/site/./lego/models/mocs.py in get_popular_mocs(1023)
  pop_mocs = list(cls.objects.filter(id__in=moc_ids))
SELECT DISTINCT ("taggit_taggeditem"."object_id") AS "_prefetch_related_val",
       "taggit_tag"."id",
       "taggit_tag"."name",
       "taggit_tag"."slug"
  FROM "taggit_tag"
 INNER JOIN "taggit_taggeditem"
    ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id")
 INNER JOIN "django_content_type"
    ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id")
 WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (361193, 361291, 358357, 361210, 361052, 361151))SELECT ••• FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ("taggit_tag"."id" = "taggit_taggeditem"."tag_id") INNER JOIN "django_content_type" ON ("taggit_taggeditem"."content_type_id" = "django_content_type"."id") WHERE ("django_content_type"."app_label" = 'lego' AND "django_content_type"."model" = 'moc' AND "taggit_taggeditem"."object_id" IN (361193, 361291, 358357, 361210, 361052, 361151))
 0.79

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(46)
  context['popular_mocs'] = Moc.get_popular_mocs(num_days=3, limit=6, hosted_only=True)

/home/nathan/rb/site/./lego/models/mocs.py in get_popular_mocs(1023)
  pop_mocs = list(cls.objects.filter(id__in=moc_ids))
SELECT (
        select coalesce(sum(impressions), 0)
          from lego_designerimpressions i
         where i.designer_id=lego_moc.designer_id
           and i.day=(now() at time zone 'UTC')::date
       ) AS "imps",
       "lego_baseset"."id",
       "lego_baseset"."set_num",
       "lego_baseset"."name",
       "lego_baseset"."year",
       "lego_baseset"."theme_id",
       "lego_baseset"."set_type",
       "lego_baseset"."num_parts",
       "lego_baseset"."default_inventory_id",
       "lego_baseset"."is_active",
       "lego_baseset"."is_accessory",
       "lego_baseset"."added_dt",
       "lego_baseset"."added_by_id",
       "lego_baseset"."last_modified_dt",
       "lego_baseset"."last_modified_by_id",
       "lego_baseset"."active_change_dt",
       "lego_baseset"."active_change_by_id",
       "lego_baseset"."last_checked_for_bi",
       "lego_baseset"."descr",
       "lego_baseset"."primary_photo_id",
       "lego_baseset"."primary_moc_image_id",
       "lego_baseset"."is_gear",
       "lego_baseset"."is_book",
       "lego_baseset"."search_vector",
       "lego_baseset"."mfhash_vector",
       "lego_moc"."baseset_ptr_id",
       "lego_moc"."designer_id",
       "lego_moc"."detail_url",
       "lego_moc"."gallery_url",
       "lego_moc"."bi_url",
       "lego_moc"."cad_url",
       "lego_moc"."video",
       "lego_moc"."bi_type",
       "lego_moc"."is_for_sale",
       "lego_moc"."is_hosted",
       "lego_moc"."cost",
       "lego_moc"."currency_id",
       "lego_moc"."parent_set_1_id",
       "lego_moc"."parent_set_2_id",
       "lego_moc"."parent_set_3_id",
       "lego_moc"."parent_set_4_id",
       "lego_moc"."parent_set_5_id",
       "lego_moc"."parent_inv_1_id",
       "lego_moc"."parent_inv_2_id",
       "lego_moc"."parent_inv_3_id",
       "lego_moc"."parent_inv_4_id",
       "lego_moc"."parent_inv_5_id",
       "lego_moc"."parent_type",
       "lego_moc"."is_allowed_premium",
       "lego_moc"."is_locked",
       "lego_moc"."last_social_post",
       "lego_moc"."is_review_requested",
       "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",
       "lego_designer"."user_ptr_id",
       "lego_designer"."auto_approve",
       "lego_designer"."num_auto_approved",
       "lego_designer"."last_checked_for_moc_errors",
       "accounts_userplan"."user_id",
       "accounts_userplan"."plan_id",
       "accounts_userplan"."expiry_date",
       "accounts_userplan"."last_paid_date",
       "accounts_userplan"."is_subscription_active",
       "accounts_userplan"."subscription_period",
       "accounts_userplan"."payment_source",
       "accounts_userplan"."stripe_customer_id",
       "accounts_userplan"."stripe_subscription_id",
       "accounts_userplan"."paypal_subscription_id",
       "accounts_userplan"."base_free_plan_id",
       "accounts_userplan"."is_reminder_sent",
       "plans_plan"."id",
       "plans_plan"."type",
       "plans_plan"."version",
       "plans_plan"."stripe_id",
       "plans_plan"."paypal_id",
       "plans_plan"."cost_single",
       "plans_plan"."cost_monthly",
       "plans_plan"."cost_yearly",
       "lego_setstatstotal"."set_id",
       "lego_setstatstotal"."hits",
       "lego_setstatstotal"."builds",
       "lego_setstatstotal"."likes",
       "lego_setstatstotal"."bi_downloads",
       "lego_setstatstotal"."featured_hits",
       "lego_setstatstotal"."user_hits"
  FROM "lego_moc"
 INNER JOIN "lego_baseset"
    ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id")
 INNER JOIN "lego_setstatstotal"
    ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id")
 INNER JOIN "lego_designer"
    ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id")
 INNER JOIN "auth_user"
    ON ("lego_designer"."user_ptr_id" = "auth_user"."id")
  LEFT OUTER JOIN "accounts_userplan"
    ON ("auth_user"."id" = "accounts_userplan"."user_id")
  LEFT OUTER JOIN "plans_plan"
    ON ("accounts_userplan"."plan_id" = "plans_plan"."id")
 WHERE ("lego_baseset"."is_active" AND "lego_moc"."baseset_ptr_id" IN (SELECT U0."moc_id" AS "moc_id" FROM "lego_featuredmoccandidates" U0) AND "lego_setstatstotal"."likes" > 500)
 ORDER BY 1 ASC, RANDOM() ASC
 LIMIT 20SELECT (select coalesce(sum(impressions), 0) from lego_designerimpressions i where i.designer_id=lego_moc.designer_id and i.day=(now() at time zone 'UTC')::date) AS "imps", "lego_baseset"."id", "lego_baseset"."set_num", "lego_baseset"."name", "lego_baseset"."year", "lego_baseset"."theme_id", "lego_baseset"."set_type", "lego_baseset"."num_parts", "lego_baseset"."default_inventory_id", "lego_baseset"."is_active", "lego_baseset"."is_accessory", "lego_baseset"."added_dt", "lego_baseset"."added_by_id", "lego_baseset"."last_modified_dt", "lego_baseset"."last_modified_by_id", "lego_baseset"."active_change_dt", "lego_baseset"."active_change_by_id", "lego_baseset"."last_checked_for_bi", "lego_baseset"."descr", "lego_baseset"."primary_photo_id", "lego_baseset"."primary_moc_image_id", "lego_baseset"."is_gear", "lego_baseset"."is_book", "lego_baseset"."search_vector", "lego_baseset"."mfhash_vector", "lego_moc"."baseset_ptr_id", "lego_moc"."designer_id", "lego_moc"."detail_url", "lego_moc"."gallery_url", "lego_moc"."bi_url", "lego_moc"."cad_url", "lego_moc"."video", "lego_moc"."bi_type", "lego_moc"."is_for_sale", "lego_moc"."is_hosted", "lego_moc"."cost", "lego_moc"."currency_id", "lego_moc"."parent_set_1_id", "lego_moc"."parent_set_2_id", "lego_moc"."parent_set_3_id", "lego_moc"."parent_set_4_id", "lego_moc"."parent_set_5_id", "lego_moc"."parent_inv_1_id", "lego_moc"."parent_inv_2_id", "lego_moc"."parent_inv_3_id", "lego_moc"."parent_inv_4_id", "lego_moc"."parent_inv_5_id", "lego_moc"."parent_type", "lego_moc"."is_allowed_premium", "lego_moc"."is_locked", "lego_moc"."last_social_post", "lego_moc"."is_review_requested", "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", "lego_designer"."user_ptr_id", "lego_designer"."auto_approve", "lego_designer"."num_auto_approved", "lego_designer"."last_checked_for_moc_errors", "accounts_userplan"."user_id", "accounts_userplan"."plan_id", "accounts_userplan"."expiry_date", "accounts_userplan"."last_paid_date", "accounts_userplan"."is_subscription_active", "accounts_userplan"."subscription_period", "accounts_userplan"."payment_source", "accounts_userplan"."stripe_customer_id", "accounts_userplan"."stripe_subscription_id", "accounts_userplan"."paypal_subscription_id", "accounts_userplan"."base_free_plan_id", "accounts_userplan"."is_reminder_sent", "plans_plan"."id", "plans_plan"."type", "plans_plan"."version", "plans_plan"."stripe_id", "plans_plan"."paypal_id", "plans_plan"."cost_single", "plans_plan"."cost_monthly", "plans_plan"."cost_yearly", "lego_setstatstotal"."set_id", "lego_setstatstotal"."hits", "lego_setstatstotal"."builds", "lego_setstatstotal"."likes", "lego_setstatstotal"."bi_downloads", "lego_setstatstotal"."featured_hits", "lego_setstatstotal"."user_hits" FROM "lego_moc" INNER JOIN "lego_baseset" ON ("lego_moc"."baseset_ptr_id" = "lego_baseset"."id") INNER JOIN "lego_setstatstotal" ON ("lego_baseset"."id" = "lego_setstatstotal"."set_id") INNER JOIN "lego_designer" ON ("lego_moc"."designer_id" = "lego_designer"."user_ptr_id") INNER JOIN "auth_user" ON ("lego_designer"."user_ptr_id" = "auth_user"."id") LEFT OUTER JOIN "accounts_userplan" ON ("auth_user"."id" = "accounts_userplan"."user_id") LEFT OUTER JOIN "plans_plan" ON ("accounts_userplan"."plan_id" = "plans_plan"."id") WHERE ("lego_baseset"."is_active" AND "lego_moc"."baseset_ptr_id" IN (SELECT ••• FROM "lego_featuredmoccandidates" U0) AND "lego_setstatstotal"."likes" > 500) ORDER BY 1 ASC, RANDOM() ASC LIMIT 20
 33.71

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(57)
  context['featured_mocs'] = Moc.get_featured_mocs(limit=6, high_quality_only=True)

/home/nathan/rb/site/./lego/models/mocs.py in get_featured_mocs(1298)
  mocs = get_featured_mocs_cached(1, high_quality_only=high_quality_only, location=location)

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

/home/nathan/rb/site/./lego/models/mocs.py in get_featured_mocs_cached(1276)
  if len(mocs) == 0:
SELECT "rb_sitesettings"."id",
       "rb_sitesettings"."name",
       "rb_sitesettings"."value"
  FROM "rb_sitesettings"
 WHERE "rb_sitesettings"."name" = 'site_message'
 LIMIT 21SELECT ••• FROM "rb_sitesettings" WHERE "rb_sitesettings"."name" = 'site_message' LIMIT 21
 0.11

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./rb/templatetags/rb_settings.py in site_message(147)
  message = SiteSettings.get_site_message()

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

/home/nathan/rb/site/./rb/models/site.py in get_site_message(24)
  setting = cls.objects.get(name=SiteSettings.SITE_MESSAGE)
346
347 <body class="{% block body-class %}{{ request.user.get_body_classes }}{% endblock body-class %}">
348
349 {% site_message %}
350 <div id="wrapper" class="{% block wrapper_class %}{% endblock wrapper_class %} {% if request.user.is_anonymous %}{% else %}{{ request.user.get_personalisation_options.max_width }}{% endif %}">
351
352 {% include 'rb/includes/topbar.html' %}
353 {% include 'rb/includes/header.html' %}

/home/nathan/rb/site/rb/templates/rb/base_root.html
SELECT "countries_plus_country"."iso",
       "countries_plus_country"."iso3",
       "countries_plus_country"."iso_numeric",
       "countries_plus_country"."fips",
       "countries_plus_country"."name",
       "countries_plus_country"."capital",
       "countries_plus_country"."area",
       "countries_plus_country"."population",
       "countries_plus_country"."continent",
       "countries_plus_country"."tld",
       "countries_plus_country"."currency_code",
       "countries_plus_country"."currency_symbol",
       "countries_plus_country"."currency_name",
       "countries_plus_country"."phone",
       "countries_plus_country"."postal_code_format",
       "countries_plus_country"."postal_code_regex",
       "countries_plus_country"."languages",
       "countries_plus_country"."geonameid",
       "countries_plus_country"."neighbours",
       "countries_plus_country"."equivalent_fips_code"
  FROM "countries_plus_country"
 WHERE "countries_plus_country"."iso" = 'US'
 LIMIT 21SELECT ••• FROM "countries_plus_country" WHERE "countries_plus_country"."iso" = 'US' LIMIT 21
 0.13

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.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(253)
  country = Country.objects.get(iso=country_code)
74 </a>
75 </li>
76 <li>
77 {% geo_currency request.user %}
78 </li>
79 {% comment %}
80 <li class="hidden-xs hidden-sm">
81 <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/includes/topbar.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1064805
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1064805 LIMIT 21
12 similar queries. 		0.09

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1063980
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1063980 LIMIT 21
12 similar queries. 		0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1064881
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1064881 LIMIT 21
12 similar queries. 		0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1065209
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1065209 LIMIT 21
12 similar queries. 		0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1048509
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1048509 LIMIT 21
12 similar queries. 		0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 1065459
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 1065459 LIMIT 21
12 similar queries. 		0.10

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
746 {% if forloop.counter <= 6 %}
747 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
748 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
749 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
750 </a>
751 <div class="landing-moc-card__body">
752 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
753 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 251247
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 251247 LIMIT 21
12 similar queries. 		0.30

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 145920
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 145920 LIMIT 21
12 similar queries. 		0.26

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 147881
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 147881 LIMIT 21
12 similar queries. 		0.23

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 308645
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 308645 LIMIT 21
12 similar queries. 		0.07

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 95291
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 95291 LIMIT 21
12 similar queries. 		0.32

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "lego_mocimage"."id",
       "lego_mocimage"."moc_id",
       "lego_mocimage"."is_primary",
       "lego_mocimage"."file_extension"
  FROM "lego_mocimage"
 WHERE "lego_mocimage"."id" = 522613
 LIMIT 21SELECT ••• FROM "lego_mocimage" WHERE "lego_mocimage"."id" = 522613 LIMIT 21
12 similar queries. 		0.26

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)

/home/nathan/rb/site/./lego/models/sets.py in img_dir(771)
  img = self.primary_moc_image
773 {% if forloop.counter <= 6 %}
774 <article class="rb-card {% if forloop.counter > 4 %}hidden-sm{% endif %} {% if forloop.counter > 4 %}hidden-xs{% endif %}">
775 <a href="{{ moc.get_absolute_url }}" class="rb-card__image">
776 {% include 'lego/includes/render_set_img.html' with img_file=moc.img_dir title=moc.name img_class='bg-dark' %}
777 </a>
778 <div class="landing-moc-card__body">
779 <h3><a href="{{ moc.get_absolute_url }}">{{ moc.name }}</a></h3>
780 <div class="landing-moc-card__byline">by <a href="{% url 'user_mocs' moc.designer.username %}">{{ moc.designer.username }}</a></div>

/home/nathan/rb/site/rb/templates/rb/index.html
SELECT "blog_article"."id",
       "blog_article"."title",
       "blog_article"."author_id",
       "blog_article"."published_date",
       "blog_article"."is_active",
       "blog_article"."body",
       "blog_article"."meta_description",
       "blog_article"."meta_img",
       "blog_article"."slug",
       "blog_article"."category_id",
       "blog_article"."ads",
       "blog_article"."show_ads_for_set_num",
       "blog_article"."review_for_set_num",
       "blog_article"."status",
       "blog_article"."scheduled_net",
       "blog_article"."ready_for_review_date",
       "blog_article"."is_sensitive",
       "blog_article"."search_vector",
       "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",
       "blog_articlecategory"."id",
       "blog_articlecategory"."name",
       "blog_articlestats"."article_id",
       "blog_articlestats"."hits"
  FROM "blog_article"
  LEFT OUTER JOIN "auth_user"
    ON ("blog_article"."author_id" = "auth_user"."id")
  LEFT OUTER JOIN "blog_articlecategory"
    ON ("blog_article"."category_id" = "blog_articlecategory"."id")
  LEFT OUTER JOIN "blog_articlestats"
    ON ("blog_article"."id" = "blog_articlestats"."article_id")
 WHERE "blog_article"."is_active"
 ORDER BY "blog_article"."published_date" DESC
 LIMIT 4SELECT ••• FROM "blog_article" LEFT OUTER JOIN "auth_user" ON ("blog_article"."author_id" = "auth_user"."id") LEFT OUTER JOIN "blog_articlecategory" ON ("blog_article"."category_id" = "blog_articlecategory"."id") LEFT OUTER JOIN "blog_articlestats" ON ("blog_article"."id" = "blog_articlestats"."article_id") WHERE "blog_article"."is_active" ORDER BY "blog_article"."published_date" DESC LIMIT 4
 1.91

Connection: default

Transaction status: Idle

/home/nathan/rb/site/./rb/views/views.py in main_page(87)
  return render(request, 'rb/index.html', context)
910 <a href="{% url 'blog_index' %}" class="landing-text-link">View all articles <i class="fa fa-arrow-right" aria-hidden="true"></i></a>
911 </div>
912 <div class="landing-article-grid">
913 {% for article in recent_articles %}
914 {% if forloop.counter <= 3 %}
915 <article class="xlanding-article-card">
916 {% include 'blog/includes/render_posts_preview.html' %}
917 </article>

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

Log messages

No messages logged.