US
Show Advanced Options
Showing 100 of 234 unique parts/colors
( total quantity)
| Resource | Value |
|---|---|
| User CPU time | 419.946 msec |
| System CPU time | 15.106 msec |
| Total CPU time | 435.052 msec |
| Elapsed time | 472.519 msec |
| Context switches | 484 voluntary, 1 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" = 'baseplates' 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" = 'baseplates' LIMIT 21 |
0.59 | ||||||||||||||||||||
|
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(605) 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" = 'baseplates' LIMIT 21SELECT ••• FROM "lego_partcategory" WHERE "lego_partcategory"."slug" = 'baseplates' LIMIT 21 |
0.13 | ||||||||||||||||||||
|
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(605) return manager.get(**kwargs) |
|||||||||||||||||||||
|
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" 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 (1)) LIMIT 1000SELECT ••• 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 (1)) LIMIT 1000 |
14.24 | ||||||||||||||||||||
|
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(179) results = sort_user_parts(request, results) /home/nathan/rb/site/./lego/filters.py in sort_user_parts(1588) 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(29) if len(parts.select_related(None).prefetch_related(None)) <= 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 (1)) 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 (1)) LIMIT 1000 |
4.52 | ||||||||||||||||||||
|
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(179) results = sort_user_parts(request, results) /home/nathan/rb/site/./lego/filters.py in sort_user_parts(1588) 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(53) 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 (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637)) 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 (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC |
1.09 | ||||||||||||||||||||
|
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 (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637) |
1.21 | ||||||||||||||||||||
|
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 (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637) |
1.05 | ||||||||||||||||||||
|
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 (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637))SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (3000, 68122, 3156, 14624, 55916, 18158, 22663, 55915, 21255, 17936, 22785, 16301, 21584, 18855, 20412, 10234, 18894, 21264, 22350, 21038, 4406, 10978, 23807, 18032, 11903, 7872, 11500, 20766, 15631, 16690, 1259, 4607, 21039, 4283, 20589, 11361, 10961, 30359, 14317, 12411, 22193, 5474, 35218, 22314, 14310, 10189, 3160, 5205, 4296, 7745, 3343, 13173, 20258, 18882, 16236, 10985, 17264, 20949, 21309, 1932, 11516, 8665, 16378, 18408, 4020, 24111, 16007, 6550, 19864, 18624, 14662, 8878, 11495, 12530, 21885, 16013, 6731, 3538, 17613, 17666, 13527, 22477, 5986, 11856, 6654, 17725, 10071, 8971, 6408, 12839, 15737, 15562, 17860, 15149, 17239, 7276, 9588, 12814, 22112, 11637)) |
0.88 | ||||||||||||||||||||
|
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 (3000,68122,3156,14624,55916,18158,22663,55915,21255,17936,22785,16301,21584,18855,20412,10234,18894,21264,22350,21038,4406,10978,23807,18032,11903,7872,11500,20766,15631,16690,1259,4607,21039,4283,20589,11361,10961,30359,14317,12411,22193,5474,35218,22314,14310,10189,3160,5205,4296,7745,3343,13173,20258,18882,16236,10985,17264,20949,21309,1932,11516,8665,16378,18408,4020,24111,16007,6550,19864,18624,14662,8878,11495,12530,21885,16013,6731,3538,17613,17666,13527,22477,5986,11856,6654,17725,10071,8971,6408,12839,15737,15562,17860,15149,17239,7276,9588,12814,22112,11637) 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 (3000,68122,3156,14624,55916,18158,22663,55915,21255,17936,22785,16301,21584,18855,20412,10234,18894,21264,22350,21038,4406,10978,23807,18032,11903,7872,11500,20766,15631,16690,1259,4607,21039,4283,20589,11361,10961,30359,14317,12411,22193,5474,35218,22314,14310,10189,3160,5205,4296,7745,3343,13173,20258,18882,16236,10985,17264,20949,21309,1932,11516,8665,16378,18408,4020,24111,16007,6550,19864,18624,14662,8878,11495,12530,21885,16013,6731,3538,17613,17666,13527,22477,5986,11856,6654,17725,10071,8971,6408,12839,15737,15562,17860,15149,17239,7276,9588,12814,22112,11637) |
1.34 | ||||||||||||||||||||
|
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(341) 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.58 | ||||||||||||||||||||
|
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(110) 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.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/./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)
/home/nathan/rb/site/rb/templates/rb/base_root.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
5 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" = 68122 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 68122 AND "lego_partrelationship"."rel_type" = 'S') |
0.16 | ||||||||||||||||||||
|
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(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
5 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" = 68122)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 68122) |
0.16 | ||||||||||||||||||||
|
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(663) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(506) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
5 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" = 55916 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 55916 AND "lego_partrelationship"."rel_type" = 'S') |
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(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
5 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" = 55916)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 55916) |
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(663) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(506) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
5 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" = 22785 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 22785 AND "lego_partrelationship"."rel_type" = 'S') |
0.14 | ||||||||||||||||||||
|
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(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
5 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" = 22785)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 22785) |
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(663) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(506) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
5 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" = 30359 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 30359 AND "lego_partrelationship"."rel_type" = 'S') |
0.12 | ||||||||||||||||||||
|
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(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
5 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" = 30359)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 30359) |
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(663) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(506) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partrelationship"."id",
5 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" = 14317 AND "lego_partrelationship"."rel_type" = 'S')SELECT ••• FROM "lego_partrelationship" WHERE ("lego_partrelationship"."part_child_id" = 14317 AND "lego_partrelationship"."rel_type" = 'S') |
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(607) similar_part = self.get_similar_part() /home/nathan/rb/site/./lego/models/parts.py in get_similar_part(352) if parent_rel:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
|
SELECT "lego_partphoto"."id",
5 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" = 14317)SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."is_primary" AND "lego_partphoto"."part_id" = 14317) |
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(663) photo = self.get_photo(color=None) /home/nathan/rb/site/./lego/models/parts.py in get_photo(506) if photos:
/home/nathan/rb/site/lego/templates/parts/render_parts_list.html |
|||||||||||||||||||||
No messages logged.
