[info] GET /
[debug] Processing with CauseBeaconWeb.HomeLive.nil/2
  Parameters: %{}
  Pipelines: [:browser]
[info] Sent 302 in 495µs
[info] GET /sign-in
[debug] Processing with CauseBeaconWeb.SignInLive.sign_in/2
  Parameters: %{}
  Pipelines: [:browser]
[info] Sent 200 in 1ms
[info] CONNECTED TO Phoenix.LiveView.Socket in 14µs
  Transport: :websocket
  Serializer: Phoenix.Socket.V2.JSONSerializer
  Parameters: %{"_csrf_token" => "GBY-GXdYChsINS5nMSEidXUCC19WMyB1UtmSN2XuiWiUGFcGLpb2gVw7", "_live_referer" => "undefined", "_mount_attempts" => "0", "_mounts" => "0", "_track_static" => %{"0" => "http://localhost:4000/assets/app.css", "1" => "http://localhost:4000/assets/app.js"}, "timezone" => "Asia/Hong_Kong", "vsn" => "2.0.0"}
[debug] MOUNT CauseBeaconWeb.SignInLive
  Parameters: %{}
  Session: %{"_csrf_token" => "MbSJ9jRnabG2vgA29rim1eWB", "auth_routes_prefix" => "/auth", "cldr_locale" => "en-US", "context" => nil, "current_tenant" => "ca57e103-ada2-4226-ac48-7d3760b6c4d5", "gettext_fn" => nil, "otp_app" => nil, "overrides" => [CauseBeaconWeb.AuthOverrides, AshAuthentication.Phoenix.Overrides.Default], "path" => "/sign-in", "register_path" => nil, "reset_path" => "/reset", "resources" => nil, "tenant" => nil, "user" => "user?id=aabc6dc0-d876-4cf9-9c3d-1e1594126aa8"}
[debug] QUERY OK source="users" db=0.6ms idle=1834.2ms
SELECT u0."id", u0."email", u0."locale", u0."inserted_at", u0."updated_at", u0."confirmed_at", u0."date_of_birth", u0."first_name", u0."gender", u0."hashed_password", u0."last_name", u0."national_id_number", u0."nationality", u0."nickname", u0."passport_number", u0."permanent_resident", u0."phone_country_code", u0."phone_number", u0."photo_url", u0."preferred_language", u0."super_admin", u0."translations", (CASE WHEN ash_elixir_and(coalesce(coalesce(NOT (u0."locale"::varchar IS NULL)::boolean AND NULL::text IN ('zh','zh_HK')::boolean, FALSE)::boolean AND NOT (u0."translations"::jsonb IS NULL)::boolean, FALSE), ash_elixir_or(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL), NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL))) AND NOT (u0."nickname"::text IS NULL) THEN (CASE WHEN coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN (u0."nickname"::text || ($1::text || (((u0."translations"::jsonb->'zh'->>'last_name'))::text || ((u0."translations"::jsonb->'zh'->>'first_name'))::text)::text)::text) WHEN coalesce((((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN (u0."nickname"::text || ($2::text || ((u0."translations"::jsonb->'zh'->>'last_name'))::text)::text) WHEN coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN (u0."nickname"::text || ($3::text || ((u0."translations"::jsonb->'zh'->>'first_name'))::text)::text) ELSE NULL END) WHEN coalesce(coalesce(coalesce(NOT (u0."locale"::varchar IS NULL)::boolean AND NULL::text IN ('zh','zh_HK')::boolean, FALSE)::boolean AND NOT (u0."translations"::jsonb IS NULL)::boolean, FALSE)::boolean AND coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean OR NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE)::boolean, FALSE) THEN (CASE WHEN coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN (((u0."translations"::jsonb->'zh'->>'last_name'))::text || ((u0."translations"::jsonb->'zh'->>'first_name'))::text) WHEN coalesce((((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN ((u0."translations"::jsonb->'zh'->>'last_name'))::text WHEN coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN ((u0."translations"::jsonb->'zh'->>'first_name'))::text ELSE NULL END) WHEN coalesce(NOT (u0."first_name"::text IS NULL)::boolean AND NOT (u0."last_name"::text IS NULL)::boolean, FALSE) AND NOT (u0."nickname"::text IS NULL) THEN (u0."nickname"::text || ($4::text || (u0."first_name"::text || ($5::text || u0."last_name"::text)::text)::text)::text) WHEN coalesce(NOT (u0."first_name"::text IS NULL)::boolean AND NOT (u0."last_name"::text IS NULL)::boolean, FALSE) THEN (u0."first_name"::text || ($6::text || u0."last_name"::text)::text) WHEN coalesce(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN (((u0."translations"::jsonb->'zh'->>'last_name'))::text || ((u0."translations"::jsonb->'zh'->>'first_name'))::text) WHEN coalesce((((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL)::boolean AND NOT (((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL)::boolean, FALSE) THEN ((u0."translations"::jsonb->'zh'->>'last_name'))::text WHEN ash_elixir_and(NOT (((u0."translations"::jsonb->'zh'->>'first_name'))::text IS NULL), ((u0."translations"::jsonb->'zh'->>'last_name'))::text IS NULL) THEN ((u0."translations"::jsonb->'zh'->>'first_name'))::text ELSE u0."email"::citext END)::text FROM "users" AS u0 WHERE (u0."id"::uuid = $7::uuid) [", ", ", ", ", ", ", ", " ", " ", "aabc6dc0-d876-4cf9-9c3d-1e1594126aa8"]
↳ anonymous fn/3 in AshPostgres.DataLayer.run_query/2, at: lib/data_layer.ex:788
[debug] Replied in 6ms