DELETE /v1/advertiser/account

cache +1.0 ms 3.0 ms

miss rec:session:7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88

query +5.0 ms 1.0 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` = '7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88'

Parameters

[
  "7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88"
]

1 rows

cache +5.8 ms 1.2 ms

set rec:session:7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88

cache +7.7 ms 0.3 ms

miss rec:subject:advertiser:01a116eb-2419-71d5-b9fb-2b674b37a1a9

query +8.0 ms 1.5 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` = '01a116eb-2419-71d5-b9fb-2b674b37a1a9' and `advertisers`.`deleted_at` is null)

Parameters

[
  "01a116eb-2419-71d5-b9fb-2b674b37a1a9"
]

1 rows

cache +9.6 ms 1.4 ms

set rec:subject:advertiser:01a116eb-2419-71d5-b9fb-2b674b37a1a9

query +13.0 ms 11.1 ms

update `advertisers` set `mobile` = NULL, `last_sign_in_at` = NULL, `updated_at` = '2026-10-07 15:11:14.567', `deleted_at` = '2026-10-07 15:11:14.567', `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` = '01a116eb-2419-71d5-b9fb-2b674b37a1a9' and `advertisers`.`deleted_at` is null)

Parameters

[
  null,
  null,
  "2026-10-07 15:11:14.567",
  "2026-10-07 15:11:14.567",
  "",
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  null,
  "01a116eb-2419-71d5-b9fb-2b674b37a1a9"
]

1 rows

cache +24.1 ms 1.9 ms

update rec:subject:advertiser:01a116eb-2419-71d5-b9fb-2b674b37a1a9

cache +26.1 ms 0.9 ms

invalidate rec:subject:advertiser:01a116eb-2419-71d5-b9fb-2b674b37a1a9

query +28.0 ms 1.1 ms

select `id` from `sessions` where ((`sessions`.`subject_type` = 'advertiser' and `sessions`.`subject_id` = '01a116eb-2419-71d5-b9fb-2b674b37a1a9') and `sessions`.`revoked_at` is null)

Parameters

[
  "advertiser",
  "01a116eb-2419-71d5-b9fb-2b674b37a1a9"
]

1 rows

query +29.0 ms 0.7 ms

begin

0 rows

query +30.0 ms 0.8 ms

select `id`, `token_hash` from `sessions` where (`sessions`.`id` in ('01a116eb-2424-7736-9964-9c4ea692f081') and `sessions`.`revoked_at` is null) for update

Parameters

[
  "01a116eb-2424-7736-9964-9c4ea692f081"
]

1 rows

query +31.0 ms 1.9 ms

update `sessions` set `revoked_at` = '2026-10-07 15:11:14.582', `revoked_reason` = 'account_deleted' where `sessions`.`id` in ('01a116eb-2424-7736-9964-9c4ea692f081')

Parameters

[
  "2026-10-07 15:11:14.582",
  "account_deleted",
  "01a116eb-2424-7736-9964-9c4ea692f081"
]

1 rows

query +33.0 ms 6.2 ms

commit

0 rows

cache +39.6 ms 0.4 ms

update rec:session:7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88

cache +39.7 ms 0.3 ms

invalidate rec:session:7dadbe4d1cb42f43f9c3395ad6c6a4ee148682df8b4f00aa1dd6706fe1254b88

query +41.0 ms 1.7 ms

select `id`, `storage_key` from `files` where (`files`.`owner_type` = 'advertiser' and `files`.`owner_id` = '01a116eb-2419-71d5-b9fb-2b674b37a1a9')

Parameters

[
  "advertiser",
  "01a116eb-2419-71d5-b9fb-2b674b37a1a9"
]

1 rows

query +43.0 ms 4.9 ms

delete from `files` where `files`.`id` in ('01a116eb-19d1-7759-a924-ea6ee8750216')

Parameters

[
  "01a116eb-19d1-7759-a924-ea6ee8750216"
]

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"
}

{}