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` = '+966572345441'
Parameters
[
"+966572345441"
]
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` = '+966572345441') order by `otp_codes`.`created_at` desc limit 1
Parameters
[
"customer",
"register",
"+966572345441",
1
]
0 rows
select count(*), min(`created_at`) from `otp_codes` where (`otp_codes`.`mobile` = '+966572345441' and `otp_codes`.`created_at` > '2026-10-07 14:10:29.945')
Parameters
[
"+966572345441",
"2026-10-07 14:10:29.945"
]
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:29.945')
Parameters
[
"37.19.196.100",
"2026-10-07 14:10:29.945"
]
1 rows
update `otp_codes` set `consumed_at` = '2026-10-07 15:10:29.945' where ((`otp_codes`.`namespace` = 'customer' and `otp_codes`.`purpose` = 'register' and `otp_codes`.`mobile` = '+966572345441') and `otp_codes`.`consumed_at` is null)
Parameters
[
"2026-10-07 15:10:29.945",
"customer",
"register",
"+966572345441"
]
0 rows
insert into `otp_codes` (`id`, `namespace`, `purpose`, `mobile`, `code_hash`, `attempts`, `ip`, `created_at`, `expires_at`, `consumed_at`) values ('01a116ea-8257-7700-aaf7-385f3b5b3f5e', 'customer', 'register', '+966572345441', '5940224dfbab541bccd12b76b1805bd2ae41702299a47b166f03b27bb96f286c', default, '37.19.196.100', '2026-10-07 15:10:29.945', '2026-10-07 15:11:29.945', default)Parameters
[
"01a116ea-8257-7700-aaf7-385f3b5b3f5e",
"customer",
"register",
"+966572345441",
"5940224dfbab541bccd12b76b1805bd2ae41702299a47b166f03b27bb96f286c",
"37.19.196.100",
"2026-10-07 15:10:29.945",
"2026-10-07 15:11:29.945"
]
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"
}