DELETE /v1/advertiser/account

cache +0.6 ms 0.4 ms

miss rec:session:436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8

query +2.0 ms 0.8 ms

select `id`, `subject_type`, `subject_id`, `token_hash`, `device_name`, `ip`, `user_agent`, `created_at`, `last_used_at`, `expires_at`, `revoked_at`, `revoked_reason` from `sessions` where `sessions`.`token_hash` = '436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8'

Parameters

[
  "436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8"
]

1 rows

cache +2.4 ms 0.6 ms

set rec:session:436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8

cache +3.7 ms 0.3 ms

miss rec:subject:advertiser:01a116ea-d16d-763c-943e-4e284825492d

query +5.0 ms 1.0 ms

select `id`, `mobile`, `status`, `language`, `last_sign_in_at`, `disabled_reason`, `created_at`, `updated_at`, `deleted_at`, `account_type`, `name`, `email`, `city_id`, `avatar_file_id`, `logo_file_id`, `establishment_name`, `cr_number`, `cr_file_id`, `address`, `tax_number`, `terms_accepted_at` from `advertisers` where (`advertisers`.`id` = '01a116ea-d16d-763c-943e-4e284825492d' and `advertisers`.`deleted_at` is null)

Parameters

[
  "01a116ea-d16d-763c-943e-4e284825492d"
]

1 rows

cache +5.5 ms 0.5 ms

set rec:subject:advertiser:01a116ea-d16d-763c-943e-4e284825492d

query +7.0 ms 5.2 ms

update `advertisers` set `mobile` = NULL, `last_sign_in_at` = NULL, `updated_at` = '2026-10-07 15:10:51.527', `deleted_at` = '2026-10-07 15:10:51.527', `name` = '', `email` = NULL, `avatar_file_id` = NULL, `logo_file_id` = NULL, `establishment_name` = NULL, `cr_number` = NULL, `cr_file_id` = NULL, `address` = NULL, `tax_number` = NULL where (`advertisers`.`id` = '01a116ea-d16d-763c-943e-4e284825492d' and `advertisers`.`deleted_at` is null)

Parameters

[
  null,
  null,
  "2026-10-07 15:10:51.527",
  "2026-10-07 15:10:51.527",
  "",
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  "01a116ea-d16d-763c-943e-4e284825492d"
]

1 rows

cache +12.3 ms 0.7 ms

update rec:subject:advertiser:01a116ea-d16d-763c-943e-4e284825492d

cache +13.6 ms 0.4 ms

invalidate rec:subject:advertiser:01a116ea-d16d-763c-943e-4e284825492d

query +14.0 ms 1.0 ms

select `id` from `sessions` where ((`sessions`.`subject_type` = 'advertiser' and `sessions`.`subject_id` = '01a116ea-d16d-763c-943e-4e284825492d') and `sessions`.`revoked_at` is null)

Parameters

[
  "advertiser",
  "01a116ea-d16d-763c-943e-4e284825492d"
]

1 rows

query +15.0 ms 0.2 ms

begin

0 rows

query +16.0 ms 0.5 ms

select `id`, `token_hash` from `sessions` where (`sessions`.`id` in ('01a116ea-d18a-7206-af95-0c201617b6d1') and `sessions`.`revoked_at` is null) for update

Parameters

[
  "01a116ea-d18a-7206-af95-0c201617b6d1"
]

1 rows

query +17.0 ms 0.9 ms

update `sessions` set `revoked_at` = '2026-10-07 15:10:51.534', `revoked_reason` = 'account_deleted' where `sessions`.`id` in ('01a116ea-d18a-7206-af95-0c201617b6d1')

Parameters

[
  "2026-10-07 15:10:51.534",
  "account_deleted",
  "01a116ea-d18a-7206-af95-0c201617b6d1"
]

1 rows

query +18.0 ms 4.3 ms

commit

0 rows

cache +21.5 ms 0.5 ms

update rec:session:436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8

cache +22.4 ms 0.6 ms

invalidate rec:session:436b287b160cd48a67702f7e9ae8ec61451e9a0e4cb98ac64cabd9a3529b6ff8

query +23.0 ms 0.6 ms

select `id`, `storage_key` from `files` where (`files`.`owner_type` = 'advertiser' and `files`.`owner_id` = '01a116ea-d16d-763c-943e-4e284825492d')

Parameters

[
  "advertiser",
  "01a116ea-d16d-763c-943e-4e284825492d"
]

1 rows

query +25.0 ms 5.5 ms

delete from `files` where `files`.`id` in ('01a116ea-c847-7655-b9bb-0c782c7cbede')

Parameters

[
  "01a116ea-c847-7655-b9bb-0c782c7cbede"
]

1 rows

{
  "host": "maqsed-api.dev-moltaqa.cloud",
  "user-agent": "curl/8.7.1",
  "accept": "*/*",
  "authorization": "********",
  "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"
}

{}