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"
]
0 rows
select `id` from `customers` where `customers`.`email` = 'acct17119@example.com'
Parameters
[
"acct17119@example.com"
]
0 rows
select `created_at` from `otp_codes` where (`otp_codes`.`namespace` = 'customer' and `otp_codes`.`purpose` = 'register' and `otp_codes`.`mobile` = '+966590909806') order by `otp_codes`.`created_at` desc limit 1
Parameters
[
"customer",
"register",
"+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:45.710')
Parameters
[
"+966590909806",
"2026-10-07 14:10:45.710"
]
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:45.710')
Parameters
[
"37.19.196.100",
"2026-10-07 14:10:45.710"
]
1 rows
update `otp_codes` set `consumed_at` = '2026-10-07 15:10:45.710' where ((`otp_codes`.`namespace` = 'customer' and `otp_codes`.`purpose` = 'register' and `otp_codes`.`mobile` = '+966590909806') and `otp_codes`.`consumed_at` is null)
Parameters
[
"2026-10-07 15:10:45.710",
"customer",
"register",
"+966590909806"
]
0 rows
insert into `otp_codes` (`id`, `namespace`, `purpose`, `mobile`, `code_hash`, `attempts`, `ip`, `created_at`, `expires_at`, `consumed_at`) values ('01a116ea-bfd4-7202-a1e1-5e0e5acd05cd', 'customer', 'register', '+966590909806', '1ce951f36b34a4177f1b14e6e60f45a05eddbc896f7c05c56d0639a9cb618d3e', default, '37.19.196.100', '2026-10-07 15:10:45.710', '2026-10-07 15:11:45.710', default)Parameters
[
"01a116ea-bfd4-7202-a1e1-5e0e5acd05cd",
"customer",
"register",
"+966590909806",
"1ce951f36b34a4177f1b14e6e60f45a05eddbc896f7c05c56d0639a9cb618d3e",
"37.19.196.100",
"2026-10-07 15:10:45.710",
"2026-10-07 15:11:45.710"
]
1 rows
Headers
{
"host": "maqsed-api.dev-moltaqa.cloud",
"user-agent": "curl/8.7.1",
"content-length": "88",
"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"
}