This site is generously supported by AnglicanHousePublishers.org,
publisher of the 2019 Book of Common Prayer, the English Standard Version: Anglican Edition, and many other
excellent books.
Consider purchasing paper copy of the Book of Common Prayer or
the ESV Anglican
Edition to complement this site.
Praying in a group? Want to share your settings?
Share this link to open this screen using your currently configured settings. This can also be used
to share your settings between different computers, tablets, or phones.
Receive a very occasional email when a new feature is launched. We send an email only once every few
months and will never share your information with anyone.
SELECT "churchcal_calendar"."uuid", "churchcal_calendar"."created", "churchcal_calendar"."updated", "churchcal_calendar"."name", "churchcal_calendar"."denomination_id", "churchcal_calendar"."year", "churchcal_calendar"."abbreviation", "churchcal_calendar"."google_sheet_id" FROM "churchcal_calendar" WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019' ORDER BY "churchcal_calendar"."uuid" ASC LIMIT 1SELECT ••• FROM "churchcal_calendar" WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019' ORDER BY "churchcal_calendar"."uuid" ASCLIMIT 1
5.09
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(305)
self.calendar = Calendar.objects.filter(abbreviation=calendar).first()
SELECT "churchcal_calendar"."uuid", "churchcal_calendar"."created", "churchcal_calendar"."updated", "churchcal_calendar"."name", "churchcal_calendar"."denomination_id", "churchcal_calendar"."year", "churchcal_calendar"."abbreviation", "churchcal_calendar"."google_sheet_id" FROM "churchcal_calendar" WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019' LIMIT 21SELECT ••• FROM "churchcal_calendar" WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019' LIMIT 21
2 similar queries.
Duplicated 2 times.
0.59
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(373)
Season.objects.filter(calendar=Calendar.objects.filter(abbreviation=self.calendar.abbreviation).get())
SELECT "churchcal_season"."uuid", "churchcal_season"."created", "churchcal_season"."updated", "churchcal_season"."order", "churchcal_season"."name", "churchcal_season"."start_commemoration_id", "churchcal_season"."color", "churchcal_season"."alternate_color", "churchcal_season"."rank_id", "churchcal_season"."calendar_id" FROM "churchcal_season" WHERE "churchcal_season"."calendar_id" = '13004a35-ef85-4acf-9ac3-645b0c243404'::uuid ORDER BY "churchcal_season"."order" ASCSELECT ••• FROM "churchcal_season" WHERE "churchcal_season"."calendar_id" = '13004a35-ef85-4acf-9ac3-645b0c243404'::uuidORDER BY "churchcal_season"."order" ASC
2 similar queries.
Duplicated 2 times.
1.20
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(378)
for season in seasons:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '6d3f5e1b-2ac3-45c6-911c-049bf89e1dea'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '6d3f5e1b-2ac3-45c6-911c-049bf89e1dea'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
1.19
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '26d1cb83-f80e-455e-be5a-64eeb29d71ad'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '26d1cb83-f80e-455e-be5a-64eeb29d71ad'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.71
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '68786fb2-a592-434c-952e-13cf6900b2e9'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '68786fb2-a592-434c-952e-13cf6900b2e9'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.61
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = 'e8de5501-3ded-4c6d-b6e5-45fbad6c5f17'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = 'e8de5501-3ded-4c6d-b6e5-45fbad6c5f17'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.59
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = 'caeed5b8-9e6b-4952-b471-3b0778c0f038'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = 'caeed5b8-9e6b-4952-b471-3b0778c0f038'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.62
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '4ee5ac20-e69a-40a6-801b-3bab301391e6'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '4ee5ac20-e69a-40a6-801b-3bab301391e6'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.60
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3" FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '7b109e58-e5d5-41fc-b9fb-a028d96ffa0f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" WHERE "churchcal_commemoration"."uuid" = '7b109e58-e5d5-41fc-b9fb-a028d96ffa0f'::uuidLIMIT 21
14 similar queries.
Duplicated 2 times.
0.70
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(318)
self.seasons = self._get_seasons()/var/www/dailyoffice2019/site/churchcal/calculations.py in _get_seasons(379)
season_mapping[season.start_commemoration.name] = season
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_commemorationrank"."uuid", "churchcal_commemorationrank"."created", "churchcal_commemorationrank"."updated", "churchcal_commemorationrank"."name", "churchcal_commemorationrank"."formatted_name", "churchcal_commemorationrank"."precedence_rank", "churchcal_commemorationrank"."required", "churchcal_commemorationrank"."calendar_id", T4."uuid", T4."created", T4."updated", T4."name", T4."rank_id", T4."cannot_occur_after_id", T4."color", T4."additional_color", T4."alternate_color", T4."alternate_color_2", T4."collect", T4."alternate_collect", T4."eve_collect", T4."color_notes", T4."calendar_id", T4."link_1", T4."link_2", T4."link_3", T5."uuid", T5."created", T5."updated", T5."name", T5."formatted_name", T5."precedence_rank", T5."required", T5."calendar_id", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" INNER JOIN "churchcal_calendar" ON ("churchcal_commemoration"."calendar_id" = "churchcal_calendar"."uuid") LEFT OUTER JOIN "churchcal_commemorationrank" ON ("churchcal_commemoration"."rank_id" = "churchcal_commemorationrank"."uuid") LEFT OUTER JOIN "churchcal_commemoration" T4 ON ("churchcal_commemoration"."cannot_occur_after_id" = T4."uuid") LEFT OUTER JOIN "churchcal_commemorationrank" T5 ON (T4."rank_id" = T5."uuid") LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019'SELECT ••• FROM "churchcal_commemoration" INNER JOIN "churchcal_calendar" ON ("churchcal_commemoration"."calendar_id" = "churchcal_calendar"."uuid") LEFT OUTER JOIN "churchcal_commemorationrank" ON ("churchcal_commemoration"."rank_id" = "churchcal_commemorationrank"."uuid") LEFT OUTER JOIN "churchcal_commemoration" T4 ON ("churchcal_commemoration"."cannot_occur_after_id" = T4."uuid") LEFT OUTER JOIN "churchcal_commemorationrank" T5 ON (T4."rank_id" = T5."uuid") LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_calendar"."abbreviation" = 'ACNA_BCP2019'
9.45
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(332)
for commemoration in commemorations:/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '68786fb2-a592-434c-952e-13cf6900b2e9'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '68786fb2-a592-434c-952e-13cf6900b2e9'::uuidLIMIT 21
16 similar queries.
Duplicated 2 times.
1.12
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
0.93
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
0.95
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
0.91
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
0.96
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
1.22
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
0.93
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
1.04
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = '5e02666b-4567-494f-9da7-06379c2cf88f'::uuidLIMIT 21
16 similar queries.
Duplicated 8 times.
1.09
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(186)
result = super().can_occur_in_year(advent_year)/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuidLIMIT 21
16 similar queries.
Duplicated 6 times.
1.33
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuidLIMIT 21
16 similar queries.
Duplicated 6 times.
1.05
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
SELECT "churchcal_commemoration"."uuid", "churchcal_commemoration"."created", "churchcal_commemoration"."updated", "churchcal_commemoration"."name", "churchcal_commemoration"."rank_id", "churchcal_commemoration"."cannot_occur_after_id", "churchcal_commemoration"."color", "churchcal_commemoration"."additional_color", "churchcal_commemoration"."alternate_color", "churchcal_commemoration"."alternate_color_2", "churchcal_commemoration"."collect", "churchcal_commemoration"."alternate_collect", "churchcal_commemoration"."eve_collect", "churchcal_commemoration"."color_notes", "churchcal_commemoration"."calendar_id", "churchcal_commemoration"."link_1", "churchcal_commemoration"."link_2", "churchcal_commemoration"."link_3", "churchcal_sanctoralecommemoration"."commemoration_ptr_id", "churchcal_sanctoralecommemoration"."month", "churchcal_sanctoralecommemoration"."day", "churchcal_sanctoralecommemoration"."saint_name", "churchcal_sanctoralecommemoration"."saint_type", "churchcal_sanctoralecommemoration"."saint_gender", "churchcal_sanctoralecommemoration"."saint_fill_in_the_blank", "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id", "churchcal_sanctoralebasedcommemoration"."weekday", "churchcal_sanctoralebasedcommemoration"."number_after", "churchcal_sanctoralebasedcommemoration"."month_after", "churchcal_sanctoralebasedcommemoration"."day_after", "churchcal_temporalecommemoration"."commemoration_ptr_id", "churchcal_temporalecommemoration"."days_after_easter" FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuid LIMIT 21SELECT ••• FROM "churchcal_commemoration" LEFT OUTER JOIN "churchcal_sanctoralecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralecommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_sanctoralebasedcommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_sanctoralebasedcommemoration"."commemoration_ptr_id") LEFT OUTER JOIN "churchcal_temporalecommemoration" ON ("churchcal_commemoration"."uuid" = "churchcal_temporalecommemoration"."commemoration_ptr_id") WHERE "churchcal_commemoration"."uuid" = 'b7c66fef-752e-4c3a-915f-cca9fc7e1350'::uuidLIMIT 21
16 similar queries.
Duplicated 6 times.
1.07
Connection: default
/var/www/dailyoffice2019/env/lib/python3.8/site-packages/whitenoise/middleware.py in __call__(59)
response = self.get_response(request)/var/www/dailyoffice2019/site/office/views.py in church_year(200)
church_year = ChurchYear(start_year)/var/www/dailyoffice2019/site/churchcal/calculations.py in __init__(334)
if not commemoration.can_occur_in_year(self.start_year):/var/www/dailyoffice2019/site/churchcal/models.py in can_occur_in_year(103)
if self.initial_date(advent_year=advent_year) >= self.cannot_occur_after_subtype.initial_date(/var/www/dailyoffice2019/site/churchcal/models.py in cannot_occur_after_subtype(93)
return Commemoration.objects.get(pk=self.cannot_occur_after.pk)/var/www/dailyoffice2019/env/lib/python3.8/site-packages/model_utils/managers.py in __iter__(21)
for obj in iter:
