US
Show Advanced Options
Showing 99 of 99 unique parts/colors
( total quantity)
| Resource | Value |
|---|---|
| User CPU time | 473.934 msec |
| System CPU time | 18.960 msec |
| Total CPU time | 492.894 msec |
| Elapsed time | 559.211 msec |
| Context switches | 529 voluntary, 337 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" = 'technic-gears' 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" = 'technic-gears' LIMIT 21 |
0.67 | ||||||||||||||||||||
|
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" = 'technic-gears' LIMIT 21SELECT ••• FROM "lego_partcategory" WHERE "lego_partcategory"."slug" = 'technic-gears' LIMIT 21 |
0.12 | ||||||||||||||||||||
|
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 (52)) 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 (52)) LIMIT 1000 |
10.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(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 (52)) 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 (52)) LIMIT 1000 |
1.38 | ||||||||||||||||||||
|
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 (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701)) 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 (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701)) ORDER BY "lego_color"."name" ASC, "lego_element"."element_id" ASC |
13.75 | ||||||||||||||||||||
|
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 (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701)SELECT ••• FROM "lego_partcolorstats" WHERE "lego_partcolorstats"."part_id" IN (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701) |
2.38 | ||||||||||||||||||||
|
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 (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701)SELECT ••• FROM "lego_partcost" WHERE "lego_partcost"."part_id" IN (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701) |
12.96 | ||||||||||||||||||||
|
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 (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701))SELECT ••• FROM "lego_partphoto" WHERE ("lego_partphoto"."is_active" AND "lego_partphoto"."part_id" IN (56118, 39211, 39212, 9882, 8554, 17114, 7703, 31941, 61823, 61822, 65875, 5499, 23065, 14574, 6414, 9703, 23276, 61820, 23585, 24050, 31940, 24223, 24176, 54633, 65876, 13438, 56119, 21862, 24083, 23867, 21900, 23337, 24496, 23345, 23584, 23277, 5851, 31927, 54632, 57218, 15468, 21019, 23540, 5790, 22229, 15849, 23470, 17839, 61819, 36801, 23109, 24013, 24064, 23338, 24052, 19687, 4280, 9981, 52490, 10228, 1983, 22088, 19783, 22489, 23845, 4243, 2937, 13632, 23847, 24148, 22426, 2156, 52570, 20274, 61821, 23810, 22540, 63242, 18832, 17764, 35972, 18045, 10649, 23820, 22330, 12907, 6842, 20959, 8029, 10151, 57213, 24784, 11065, 780, 6034, 59176, 2039, 2498, 5701)) |
1.32 | ||||||||||||||||||||
|
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 (56118,39211,39212,9882,8554,17114,7703,31941,61823,61822,65875,5499,23065,14574,6414,9703,23276,61820,23585,24050,31940,24223,24176,54633,65876,13438,56119,21862,24083,23867,21900,23337,24496,23345,23584,23277,5851,31927,54632,57218,15468,21019,23540,5790,22229,15849,23470,17839,61819,36801,23109,24013,24064,23338,24052,19687,4280,9981,52490,10228,1983,22088,19783,22489,23845,4243,2937,13632,23847,24148,22426,2156,52570,20274,61821,23810,22540,63242,18832,17764,35972,18045,10649,23820,22330,12907,6842,20959,8029,10151,57213,24784,11065,780,6034,59176,2039,2498,5701) 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 (56118,39211,39212,9882,8554,17114,7703,31941,61823,61822,65875,5499,23065,14574,6414,9703,23276,61820,23585,24050,31940,24223,24176,54633,65876,13438,56119,21862,24083,23867,21900,23337,24496,23345,23584,23277,5851,31927,54632,57218,15468,21019,23540,5790,22229,15849,23470,17839,61819,36801,23109,24013,24064,23338,24052,19687,4280,9981,52490,10228,1983,22088,19783,22489,23845,4243,2937,13632,23847,24148,22426,2156,52570,20274,61821,23810,22540,63242,18832,17764,35972,18045,10649,23820,22330,12907,6842,20959,8029,10151,57213,24784,11065,780,6034,59176,2039,2498,5701) |
2.20 | ||||||||||||||||||||
|
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 DISTINCT
ON ("lego_partcolorstats"."color_id") "lego_partcolorstats"."color_id" FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."y2" >= 2021)SELECT ••• FROM "lego_partcolorstats" WHERE ("lego_partcolorstats"."num_sets" > 0 AND "lego_partcolorstats"."y2" >= 2021) |
9.84 | ||||||||||||||||||||
|
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(105) current = cls.get_current_colors() /home/nathan/rb/site/./cache/utils.py in cache_wrapper(104) caches[cache_key].set(method_key, result) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in set(344) return self._run_cmd("set", key, False, *args, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in _run_cmd(322) return self._safely_run_func(client, func, default_val, *args, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/hash.py in _safely_run_func(211) result = func(*args, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in set(1424) return client.set(key, value, expire=expire, noreply=noreply, flags=flags) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in set(475) return self._store_cmd(b"set", {key: value}, expire, noreply, flags=flags)[key] /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/client/base.py in _store_cmd(1196) data, data_flags = self.serde.serialize(key, data) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/serde.py in serialize(119) return self._serialize_func(key, value) /home/nathan/venv_rb310/lib/python3.10/site-packages/pymemcache/serde.py in _python_memcache_serializer(58) pickler.dump(value) |
|||||||||||||||||||||
|
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.38 | ||||||||||||||||||||
|
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.24 | ||||||||||||||||||||
|
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_partcategory"."id",
"lego_partcategory"."name", "lego_partcategory"."part_count", "lego_partcategory"."img", "lego_partcategory"."slug" FROM "lego_partcategory" ORDER BY "lego_partcategory"."name" ASCSELECT ••• FROM "lego_partcategory" ORDER BY "lego_partcategory"."name" ASC |
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/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in render(204) c = self.get_render(context).flatten() /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templatetags/crispy_forms_tags.py in get_render(120) actual_form.form_html = helper.render_layout( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/helper.py in render_layout(301) html = self.layout.render(form, self.form_style, context, template_pack=template_pack) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(135) return self.get_rendered_fields(form, form_style, context, template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96) return "".join( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97) render_field(field, form, form_style, context, template_pack=template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66) return field.render(form, form_style, context, template_pack=template_pack) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367) fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96) return "".join( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97) render_field(field, form, form_style, context, template_pack=template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66) return field.render(form, form_style, context, template_pack=template_pack) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(367) fields = self.get_rendered_fields(form, form_style, context, template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96) return "".join( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97) render_field(field, form, form_style, context, template_pack=template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(66) return field.render(form, form_style, context, template_pack=template_pack) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in render(457) return self.get_rendered_fields( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in get_rendered_fields(96) return "".join( /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/layout.py in <genexpr>(97) render_field(field, form, form_style, context, template_pack=template_pack, **kwargs) /home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/utils.py in render_field(139) html = template.render(context) /home/nathan/rb/site/./cache/utils.py in cache_wrapper(98) result = method(instance, *args, **kwargs) /home/nathan/rb/site/./lego/models/parts.py in get_all_sorted_choices(156) return [('', 'Category')] + [(x.id, x.name) for x in cats]
/home/nathan/venv_rb310/lib/python3.10/site-packages/crispy_forms/templates/bootstrap3/field.html |
|||||||||||||||||||||
No messages logged.
