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
select `created_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
]
0 rows
select count(*), min(`created_at`) from `otp_codes` where (`otp_codes`.`mobile` = '+966590909806' and `otp_codes`.`created_at` > '2026-10-07 14:10:41.063')
Parameters
[
"+966590909806",
"2026-10-07 14:10:41.063"
]
1 rows
select count(*), min(`created_at`) from `otp_codes` where (`otp_codes`.`ip` = '37.19.196.100' and `otp_codes`.`created_at` > '2026-10-07 14:10:41.063')
Parameters
[
"37.19.196.100",
"2026-10-07 14:10:41.063"
]
1 rows
update `otp_codes` set `consumed_at` = '2026-10-07 15:10:41.063' where ((`otp_codes`.`namespace` = 'customer' and `otp_codes`.`purpose` = 'login' and `otp_codes`.`mobile` = '+966590909806') and `otp_codes`.`consumed_at` is null)
Parameters
[
"2026-10-07 15:10:41.063",
"customer",
"login",
"+966590909806"
]
0 rows
insert into `otp_codes` (`id`, `namespace`, `purpose`, `mobile`, `code_hash`, `attempts`, `ip`, `created_at`, `expires_at`, `consumed_at`) values ('01a116ea-adc3-73e4-8671-e5489760d061', 'customer', 'login', '+966590909806', 'ae9c9b171eb2d473a191abd30080a3cebc08274c0b099f134f41c5d9d86298ee', default, '37.19.196.100', '2026-10-07 15:10:41.063', '2026-10-07 15:11:41.063', default)Parameters
[
"01a116ea-adc3-73e4-8671-e5489760d061",
"customer",
"login",
"+966590909806",
"ae9c9b171eb2d473a191abd30080a3cebc08274c0b099f134f41c5d9d86298ee",
"37.19.196.100",
"2026-10-07 15:10:41.063",
"2026-10-07 15:11:41.063"
]
1 rows
Headers
{
"host": "maqsed-api.dev-moltaqa.cloud",
"user-agent": "curl/8.7.1",
"content-length": "23",
"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"
}