POST /v1/customer/auth/login

query +6.0 ms 5.2 ms

select `id`, `mobile`, `status`, `language`, `last_sign_in_at`, `disabled_reason`, `created_at`, `updated_at`, `deleted_at`, `name`, `email`, `avatar_file_id`, `gender`, `date_of_birth`, `terms_accepted_at` from `customers` where `customers`.`mobile` = '+966590909806'

Parameters

[
  "+966590909806"
]

1 rows

query +11.0 ms 1.0 ms

select `id`, `namespace`, `purpose`, `mobile`, `code_hash`, `attempts`, `ip`, `created_at`, `expires_at`, `consumed_at` from `otp_codes` where (`otp_codes`.`namespace` = 'customer' and `otp_codes`.`purpose` = 'login' and `otp_codes`.`mobile` = '+966590909806') order by `otp_codes`.`created_at` desc limit 1

Parameters

[
  "customer",
  "login",
  "+966590909806",
  1
]

1 rows

query +13.0 ms 5.7 ms

update `otp_codes` set `consumed_at` = '2026-10-07 15:10:42.381' where (`otp_codes`.`id` = '01a116ea-adc3-73e4-8671-e5489760d061' and `otp_codes`.`consumed_at` is null)

Parameters

[
  "2026-10-07 15:10:42.381",
  "01a116ea-adc3-73e4-8671-e5489760d061"
]

1 rows

query +19.0 ms 0.3 ms

begin

0 rows

query +20.0 ms 0.6 ms

select `id`, `mobile`, `status`, `language`, `last_sign_in_at`, `disabled_reason`, `created_at`, `updated_at`, `deleted_at`, `name`, `email`, `avatar_file_id`, `gender`, `date_of_birth`, `terms_accepted_at` from `customers` where `customers`.`mobile` = '+966590909806'

Parameters

[
  "+966590909806"
]

1 rows

query +21.0 ms 0.7 ms

update `customers` set `last_sign_in_at` = '2026-10-07 15:10:42.390', `updated_at` = '2026-10-07 15:10:42.391' where (`customers`.`id` = '01a116ea-86a0-72d2-b7a5-8fc8297c73d0' and `customers`.`deleted_at` is null)

Parameters

[
  "2026-10-07 15:10:42.390",
  "2026-10-07 15:10:42.391",
  "01a116ea-86a0-72d2-b7a5-8fc8297c73d0"
]

1 rows

query +22.0 ms 0.4 ms

select `id`, `mobile`, `status`, `language`, `last_sign_in_at`, `disabled_reason`, `created_at`, `updated_at`, `deleted_at`, `name`, `email`, `avatar_file_id`, `gender`, `date_of_birth`, `terms_accepted_at` from `customers` where (`customers`.`id` = '01a116ea-86a0-72d2-b7a5-8fc8297c73d0' and `customers`.`deleted_at` is null)

Parameters

[
  "01a116ea-86a0-72d2-b7a5-8fc8297c73d0"
]

1 rows

query +23.0 ms 1.2 ms

insert into `sessions` (`id`, `subject_type`, `subject_id`, `token_hash`, `device_name`, `ip`, `user_agent`, `created_at`, `last_used_at`, `expires_at`, `revoked_at`, `revoked_reason`) values ('01a116ea-b2d8-726b-8735-6b2624720322', 'customer', '01a116ea-86a0-72d2-b7a5-8fc8297c73d0', '932359faececc22b97930083f93e5cd77527242a4162fd5ae7135fc767a9ec63', NULL, '37.19.196.100', 'curl/8.7.1', '2026-10-07 15:10:42.392', '2026-10-07 15:10:42.392', '2027-10-07 15:10:42.392', NULL, NULL)

Parameters

[
  "01a116ea-b2d8-726b-8735-6b2624720322",
  "customer",
  "01a116ea-86a0-72d2-b7a5-8fc8297c73d0",
  "932359faececc22b97930083f93e5cd77527242a4162fd5ae7135fc767a9ec63",
  null,
  "37.19.196.100",
  "curl/8.7.1",
  "2026-10-07 15:10:42.392",
  "2026-10-07 15:10:42.392",
  "2027-10-07 15:10:42.392",
  null,
  null
]

1 rows

query +24.0 ms 0.5 ms

select `id` from `sessions` where ((`sessions`.`subject_type` = 'customer' and `sessions`.`subject_id` = '01a116ea-86a0-72d2-b7a5-8fc8297c73d0') and `sessions`.`revoked_at` is null and `sessions`.`expires_at` > '2026-10-07 15:10:42.394' and `sessions`.`id` <> '01a116ea-b2d8-726b-8735-6b2624720322') order by `sessions`.`last_used_at` desc

Parameters

[
  "customer",
  "01a116ea-86a0-72d2-b7a5-8fc8297c73d0",
  "2026-10-07 15:10:42.394",
  "01a116ea-b2d8-726b-8735-6b2624720322"
]

0 rows

query +25.0 ms 4.5 ms

commit

0 rows

{
  "host": "maqsed-api.dev-moltaqa.cloud",
  "user-agent": "curl/8.7.1",
  "content-length": "37",
  "accept": "*/*",
  "content-type": "application/json",
  "x-forwarded-for": "37.19.196.100",
  "x-forwarded-host": "maqsed-api.dev-moltaqa.cloud",
  "x-forwarded-port": "443",
  "x-forwarded-proto": "https",
  "x-forwarded-server": "2608fbae9cc2",
  "x-real-ip": "37.19.196.100",
  "accept-encoding": "gzip"
}

{}

{
  "mobile": "0590909806",
  "code": "********"
}

{
  "accessToken": "********",
  "customer": {
    "id": "01a116ea-86a0-72d2-b7a5-8fc8297c73d0",
    "name": "Sara",
    "mobile": "+966590909806",
    "email": "acct17119@example.com",
    "avatarUrl": null,
    "gender": null,
    "dateOfBirth": null,
    "language": "en",
    "createdAt": "2026-10-07T15:10:31.072Z"
  }
}