| Resource | Value |
|---|---|
| User CPU time | 377.059 msec |
| System CPU time | 14.984 msec |
| Total CPU time | 392.043 msec |
| Elapsed time | 454.903 msec |
| Context switches | 602 voluntary, 14 involuntary |
| Timing attribute | Timeline | Milliseconds since navigation start (+length) |
|---|
| Query | Timeline | Time (ms) | Action | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
SELECT "lego_part"."id",
"lego_part"."part_num", "lego_part"."name", "lego_part"."part_cat_id", "lego_part"."notes", "lego_part"."is_active", "lego_part"."search_vector", "lego_part"."ldraw_part_id", "lego_part"."bricklink_part_id", "lego_part"."ignore_color_errors", "lego_part"."part_material_id", "lego_part"."is_bricklink_minifig", "lego_part"."is_bricklink_book", "lego_part"."is_bricklink_gear", "lego_part"."show_generic_part_msg", "lego_partcategory"."id", "lego_partcategory"."name", "lego_partcategory"."part_count", "lego_partcategory"."img", "lego_partcategory"."slug", "lego_partmaterial"."id", "lego_partmaterial"."name", "lego_partoverlay"."part_id", "lego_partoverlay"."length", "lego_partstats"."part_id", "lego_partstats"."num_sets", "lego_partstats"."num_mocs", "lego_partstats"."num_set_parts", "lego_partstats"."num_moc_parts", "lego_partstats"."y1", "lego_partstats"."y2", "lego_partstats"."is_dirty" FROM "lego_part" INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE "lego_part"."part_num" = 'electronics' LIMIT 21SELECT ••• FROM "lego_part" INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") LEFT OUTER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE "lego_part"."part_num" = 'electronics' LIMIT 21 |
9.29 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(122) part = get_or_none(Part.all_objects, part_num=slug1) /home/nathan/rb/site/./rb/utils.py in get_or_none(734) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT "lego_partcategory"."id",
"lego_partcategory"."name", "lego_partcategory"."part_count", "lego_partcategory"."img", "lego_partcategory"."slug" FROM "lego_partcategory" WHERE "lego_partcategory"."slug" = 'electronics' LIMIT 21SELECT ••• FROM "lego_partcategory" WHERE "lego_partcategory"."slug" = 'electronics' LIMIT 21 |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(131) part_cat = get_or_none(PartCategory.objects, slug=slug) /home/nathan/rb/site/./rb/utils.py in get_or_none(734) return manager.get(**kwargs) |
|||||||||||||||||||||
|
SELECT COUNT(*)
FROM ( SELECT "lego_part"."id" AS "col1" FROM "lego_part" INNER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE ("lego_part"."is_active" AND "lego_partstats"."num_sets" > 0 AND "lego_part"."part_cat_id" IN (45)) LIMIT 1000 ) subquerySELECT ••• FROM "lego_part" INNER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") WHERE ("lego_part"."is_active" AND "lego_partstats"."num_sets" > 0 AND "lego_part"."part_cat_id" IN (45)) LIMIT 1000) subquery |
6.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(146) search_results = get_part_search(request, params) /home/nathan/rb/site/./lego/views/search.py in get_part_search(197) results = sort_user_parts(request, results) /home/nathan/rb/site/./lego/filters.py in sort_user_parts(1606) return PartSorter.sort_user_parts(user_parts, sort_by, sort_dir, prefix=prefix, group_by=group_by, group_by_db=group_by_db) /home/nathan/rb/site/./lego/constants/parts.py in sort_user_parts(31) if parts.count() <= 1: |
|||||||||||||||||||||
|
SELECT "lego_part"."id",
"lego_part"."part_num", "lego_part"."name", "lego_part"."part_cat_id", "lego_part"."notes", "lego_part"."is_active", "lego_part"."search_vector", "lego_part"."ldraw_part_id", "lego_part"."bricklink_part_id", "lego_part"."ignore_color_errors", "lego_part"."part_material_id", "lego_part"."is_bricklink_minifig", "lego_part"."is_bricklink_book", "lego_part"."is_bricklink_gear", "lego_part"."show_generic_part_msg", "lego_partcategory"."id", "lego_partcategory"."name", "lego_partcategory"."part_count", "lego_partcategory"."img", "lego_partcategory"."slug", "lego_partmaterial"."id", "lego_partmaterial"."name", "lego_partoverlay"."part_id", "lego_partoverlay"."length", "lego_partstats"."part_id", "lego_partstats"."num_sets", "lego_partstats"."num_mocs", "lego_partstats"."num_set_parts", "lego_partstats"."num_moc_parts", "lego_partstats"."y1", "lego_partstats"."y2", "lego_partstats"."is_dirty" FROM "lego_part" INNER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") WHERE ("lego_part"."is_active" AND "lego_partstats"."num_sets" > 0 AND "lego_part"."part_cat_id" IN (45)) LIMIT 1000SELECT ••• FROM "lego_part" INNER JOIN "lego_partstats" ON ("lego_part"."id" = "lego_partstats"."part_id") INNER JOIN "lego_partcategory" ON ("lego_part"."part_cat_id" = "lego_partcategory"."id") INNER JOIN "lego_partmaterial" ON ("lego_part"."part_material_id" = "lego_partmaterial"."id") LEFT OUTER JOIN "lego_partoverlay" ON ("lego_part"."id" = "lego_partoverlay"."part_id") WHERE ("lego_part"."is_active" AND "lego_partstats"."num_sets" > 0 AND "lego_part"."part_cat_id" IN (45)) LIMIT 1000 |
5.64 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(146) search_results = get_part_search(request, params) /home/nathan/rb/site/./lego/views/search.py in get_part_search(197) results = sort_user_parts(request, results) /home/nathan/rb/site/./lego/filters.py in sort_user_parts(1606) return PartSorter.sort_user_parts(user_parts, sort_by, sort_dir, prefix=prefix, group_by=group_by, group_by_db=group_by_db) /home/nathan/rb/site/./lego/constants/parts.py in sort_user_parts(55) return sorted(parts, key=lambda x: x.sort_by_part_color(group_by=group_by), reverse=reverse) |
|||||||||||||||||||||
|
SELECT "lego_element"."id",
"lego_element"."part_id", "lego_element"."color_id", "lego_element"."element_id", "lego_element"."design_id", "lego_element"."descr", "lego_element"."color_descr", "lego_element"."last_download_attempt", "lego_element"."num_download_attempts", "lego_element"."is_export_id", "lego_element"."is_active" FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASCSELECT ••• FROM "lego_element" INNER JOIN "lego_color" ON ("lego_element"."color_id" = "lego_color"."id") WHERE ("lego_element"."is_active" AND "lego_element"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC |
3.76 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(202) prefetch_related_objects(search_results, *Part.pr) |
|||||||||||||||||||||
|
SELECT "lego_partcolorstats"."id",
"lego_partcolorstats"."part_id", "lego_partcolorstats"."color_id", "lego_partcolorstats"."num_sets", "lego_partcolorstats"."num_mocs", "lego_partcolorstats"."num_set_parts", "lego_partcolorstats"."num_moc_parts", "lego_partcolorstats"."y1", "lego_partcolorstats"."y2", "lego_partcolorstats"."is_dirty", "lego_partcolorstats"."ignore_color_errors" FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015) |
1.66 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(202) prefetch_related_objects(search_results, *Part.pr) |
|||||||||||||||||||||
|
SELECT "lego_partcost"."id",
"lego_partcost"."part_id", "lego_partcost"."color_id", "lego_partcost"."is_used", "lego_partcost"."cost_avg", "lego_partcost"."cost_min", "lego_partcost"."cost_max", "lego_partcost"."cost_count" FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015) |
2.67 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(202) prefetch_related_objects(search_results, *Part.pr) |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015))SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (18554, 5465, 23469, 18522, 9956, 10901, 11329, 20261, 4200, 23583, 20667, 22425, 11999, 17459, 31772, 23374, 13110, 17051, 19637, 16642, 821, 1117, 20980, 24056, 7328, 15382, 10588, 4650, 14237, 19094, 49926, 15271, 62688, 21475, 9055, 66077, 70351, 23437, 14254, 13937, 11367, 43027, 40977, 51286, 2691, 17169, 12007, 12414, 73232, 2545, 18965, 19175, 20304, 21091, 61534, 4254, 6689, 66075, 15510, 8223, 16102, 19032, 66076, 75812, 70283, 73238, 19276, 16208, 10604, 21924, 24102, 37721, 8724, 11661, 38123, 73237, 22466, 70750, 10915, 10735, 4579, 16511, 22140, 7173, 3126, 7104, 8798, 12584, 32634, 24014, 4464, 23036, 19595, 12254, 20018, 18244, 11735, 10837, 24270, 17015)) |
4.90 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(202) prefetch_related_objects(search_results, *Part.pr) |
|||||||||||||||||||||
|
select 0 as id,
part_id, color_id from lego_partcolorstats a where num_set_parts = ( select max(num_set_parts) from lego_partcolorstats b where a.part_id=b.part_id and num_sets>0 ) and num_sets>0 and part_id in (18554,5465,23469,18522,9956,10901,11329,20261,4200,23583,20667,22425,11999,17459,31772,23374,13110,17051,19637,16642,821,1117,20980,24056,7328,15382,10588,4650,14237,19094,49926,15271,62688,21475,9055,66077,70351,23437,14254,13937,11367,43027,40977,51286,2691,17169,12007,12414,73232,2545,18965,19175,20304,21091,61534,4254,6689,66075,15510,8223,16102,19032,66076,75812,70283,73238,19276,16208,10604,21924,24102,37721,8724,11661,38123,73237,22466,70750,10915,10735,4579,16511,22140,7173,3126,7104,8798,12584,32634,24014,4464,23036,19595,12254,20018,18244,11735,10837,24270,17015) select 0 as id, part_id, color_id from lego_partcolorstats a where num_set_parts = (select max(num_set_parts) from lego_partcolorstats b where a.part_id=b.part_id and num_sets>0) and num_sets>0 and part_id in (18554,5465,23469,18522,9956,10901,11329,20261,4200,23583,20667,22425,11999,17459,31772,23374,13110,17051,19637,16642,821,1117,20980,24056,7328,15382,10588,4650,14237,19094,49926,15271,62688,21475,9055,66077,70351,23437,14254,13937,11367,43027,40977,51286,2691,17169,12007,12414,73232,2545,18965,19175,20304,21091,61534,4254,6689,66075,15510,8223,16102,19032,66076,75812,70283,73238,19276,16208,10604,21924,24102,37721,8724,11661,38123,73237,22466,70750,10915,10735,4579,16511,22140,7173,3126,7104,8798,12584,32634,24014,4464,23036,19595,12254,20018,18244,11735,10837,24270,17015) |
3.69 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(207) Part.attach_most_common_color_to_parts(search_results) /home/nathan/rb/site/./lego/models/parts.py in attach_most_common_color_to_parts(361) pcs_map = {p.part_id:p.color_id for p in pcs} |
|||||||||||||||||||||
|
SELECT "lego_color"."id",
"lego_color"."name", "lego_color"."rgb", "lego_color"."is_trans", "lego_color"."fuzzy_color_id", "lego_color"."is_active" FROM "lego_color" WHERE "lego_color"."is_active" ORDER BY "lego_color"."name" ASCSELECT ••• FROM "lego_color" WHERE "lego_color"."is_active" ORDER BY "lego_color"."name" ASC |
0.44 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(330) context['adv_form'] = AdvancedSearchPartsForm(params.copy(), user=request.user) /home/nathan/rb/site/./lego/forms/parts.py in __init__(672) self.fields['exists_in_color'].choices = Color.get_color_options(True) /home/nathan/rb/site/./lego/models/colors.py in get_color_options(111) for color in colors: |
|||||||||||||||||||||
|
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.30 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.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)
/home/nathan/rb/site/rb/templates/rb/includes/topbar.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 5465 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 5465 AND "lego_partrelationship"."rel_type" = 'S') |
0.22 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 5465)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 5465) |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 23469 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 23469 AND "lego_partrelationship"."rel_type" = 'S') |
0.21 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 23469)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 23469) |
0.08 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 31772 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 31772 AND "lego_partrelationship"."rel_type" = 'S') |
0.44 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 31772)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 31772) |
0.15 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 61534 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 61534 AND "lego_partrelationship"."rel_type" = 'S') |
0.20 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 61534)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 61534) |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 10604 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 10604 AND "lego_partrelationship"."rel_type" = 'S') |
0.10 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 10604)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 10604) |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 38123 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 38123 AND "lego_partrelationship"."rel_type" = 'S') |
0.19 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 38123)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 38123) |
0.09 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
7 similar queries.
"lego_partrelationship"."part_parent_id", "lego_partrelationship"."part_child_id", "lego_partrelationship"."rel_type" FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 11735 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 11735 AND "lego_partrelationship"."rel_type" = 'S') |
0.33 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(631) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(372) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
7 similar queries.
"lego_partphoto"."part_id", "lego_partphoto"."color_id", "lego_partphoto"."submitted_by_id", "lego_partphoto"."image", "lego_partphoto"."timestamp", "lego_partphoto"."is_active", "lego_partphoto"."is_primary" FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 11735)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 11735) |
0.11 | ||||||||||||||||||||
|
Connection: default Transaction status: Idle /home/nathan/rb/site/./lego/views/parts.py in find_parts(333) return render(request, 'parts/find_parts.html', context) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part(134) return mark_safe(render_part_wrapper(part, sub_text, request=context['request'])) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in render_part_wrapper(133) return _render_part_in_color(part, sub_text=sub_text, request=request) /home/nathan/rb/site/./lego/templatetags/parts/drawing.py in _render_part_in_color(51) part_img = part.get_img_dir() /home/nathan/rb/site/./lego/models/parts.py in get_img_dir(687) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(530) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
No messages logged.