I made a deep debuging and found that many of my queries are executed many times.
Even auth in login_required:
SELECT "structure_person"."id",
"structure_person"."password",
"structure_person"."last_login",
"structure_person"."is_superuser",
"structure_person"."username",
"structure_person"."comment",
"structure_person"."validity_range",
"structure_person"."is_staff",
"structure_person"."is_active",
"structure_person"."date_joined"
FROM "structure_person"
WHERE "structure_person"."id" = 16879
LIMIT 21 4 similar queries. Duplicated 4 times.
/home/partytest/env/lib/python3.11/site-packages/whitenoise/middleware.py in __call__(124)
return self.get_response(request)
/home/partytest/env/lib/python3.11/site-packages/easyaudit/middleware/easyaudit.py in __call__(53)
response = response or self.get_response(request)
/home/partytest/env/lib/python3.11/site-packages/allauth/account/middleware.py in middleware(29)
response = get_response(request)
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/decorators.py in _wrapper_view(22)
if test_func(request.user):
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/decorators.py in <lambda>(51)
lambda u: u.is_authenticated,
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/middleware.py in <lambda>(33)
request.user = SimpleLazyObject(lambda: get_user(request))
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/middleware.py in get_user(13)
request._cached_user = auth.get_user(request)
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/__init__.py in get_user(216)
user = backend.get_user(user_id)
/home/partytest/env/lib/python3.11/site-packages/django/contrib/auth/backends.py in get_user(157)
user = UserModel._default_manager.get(pk=user_id)
This is excuted query after query -
2024-05-08 10:21:07.913 CEST [3987190] party@partytest LOG: statement: SELECT "structure_persondata"."id", "structure_persondata"."created_at", "structure_persondata"."updated_at", "structure_persondata"."person_id", "structure_persondata"."first_name", "structure_persondata"."middle_name", "structure_persondata"."last_name", "structure_persondata"."pesel", "structure_persondata"."validity_range" FROM "structure_persondata" WHERE ("structure_persondata"."person_id" = 16879 AND "structure_persondata"."validity_range" @> ('2024-05-08T08:21:05.002321+00:00'::timestamptz)::timestamp with time zone) ORDER BY "structure_persondata"."id" ASC LIMIT 1
2024-05-08 10:21:07.927 CEST [3987190] party@partytest LOG: statement: SELECT "structure_persondata"."id", "structure_persondata"."created_at", "structure_persondata"."updated_at", "structure_persondata"."person_id", "structure_persondata"."first_name", "structure_persondata"."middle_name", "structure_persondata"."last_name", "structure_persondata"."pesel", "structure_persondata"."validity_range" FROM "structure_persondata" WHERE ("structure_persondata"."person_id" = 16879 AND "structure_persondata"."validity_range" @> ('2024-05-08T08:21:05.002321+00:00'::timestamptz)::timestamp with time zone) ORDER BY "structure_persondata"."id" ASC LIMIT 1
2024-05-08 10:21:07.937 CEST [3987190] party@partytest LOG: statement: SELECT "structure_persondata"."id", "structure_persondata"."created_at", "structure_persondata"."updated_at", "structure_persondata"."person_id", "structure_persondata"."first_name", "structure_persondata"."middle_name", "structure_persondata"."last_name", "structure_persondata"."pesel", "structure_persondata"."validity_range" FROM "structure_persondata" WHERE ("structure_persondata"."person_id" = 16879 AND "structure_persondata"."validity_range" @> ('2024-05-08T08:21:05.002321+00:00'::timestamptz)::timestamp with time zone) ORDER BY "structure_persondata"."id" ASC LIMIT 1
2024-05-08 10:21:07.946 CEST [3987190] party@partytest LOG: statement: SELECT "structure_persondata"."id", "structure_persondata"."created_at", "structure_persondata"."updated_at", "structure_persondata"."person_id", "structure_persondata"."first_name", "structure_persondata"."middle_name", "structure_persondata"."last_name", "structure_persondata"."pesel", "structure_persondata"."validity_range" FROM "structure_persondata" WHERE ("structure_persondata"."person_id" = 16879 AND "structure_persondata"."validity_range" @> ('2024-05-08T08:21:05.002321+00:00'::timestamptz)::timestamp with time zone) ORDER BY "structure_persondata"."id" ASC LIMIT 1
I commented out all methods in Person Class (inherited from AbstractBaseUser) - so now query is simplier, but still 4 times…
I turned out ajax…
any ideas why???
It is not a loop - I put debug in line before execution and prints to log one time…