GET https://quin.riskplaza.nl/api/public/audit_plus_accounts/get/

Query Metrics

12 Database Queries
9 Different statements
82.22 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 7.89 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.first_name = ? AND t0.last_name = ? LIMIT 1
Parameters:
[
  "API"
  "API"
]
2 8.42 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "api_78376ghd3@ktba.com"
]
3 1.35 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.roles AS roles_5, t0.password AS password_6, t0.active AS active_7, t0.last_login AS last_login_8, t0.first_name AS first_name_9, t0.middle_name AS middle_name_10, t0.last_name AS last_name_11, t0.phone_number AS phone_number_12, t0.newsletter AS newsletter_13, t0.token AS token_14, t0.token_created AS token_created_15, t0.verification_cookie AS verification_cookie_16, t0.expiration_date AS expiration_date_17, t0.start_date AS start_date_18, t0.system_expert AS system_expert_19, t0.sparkpost_mail_confidence AS sparkpost_mail_confidence_20, t0.password_reset_required AS password_reset_required_21, t0.soft_delete AS soft_delete_22 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
  "api_78376ghd3@ktba.com"
]
4 2.80 ms
"START TRANSACTION"
Parameters:
[]
5 2.57 ms
UPDATE user SET last_login = ?, updated_at = ? WHERE id = ?
Parameters:
[
  "2026-06-02 21:00:05"
  "2026-06-02 21:00:05"
  3453
]
6 18.61 ms
"COMMIT"
Parameters:
[]
7 0.65 ms
"START TRANSACTION"
Parameters:
[]
8 26.85 ms
INSERT INTO log_action (user_id, account_id, action, content, created_at) VALUES (?, ?, ?, ?, ?)
Parameters:
[
  3453
  null
  "login_succes"
  "{"userId":3453}"
  "2026-06-02 21:00:05"
]
9 3.19 ms
"COMMIT"
Parameters:
[]
10 1.15 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.account_id AS account_id_3 FROM account_user t0 WHERE t0.user_id = ? AND t0.account_id = ? LIMIT 1
Parameters:
[
  3453
  302
]
11 3.23 ms
SELECT t0.id AS id_1, t0.account_id AS account_id_2, t0.module_id AS module_id_3, t0.is_demo AS is_demo_4, t0.module_expiration_date AS module_expiration_date_5, t0.start_date AS start_date_6, t0.is_active AS is_active_7, t0.ordered AS ordered_8 FROM account_module t0 WHERE t0.account_id IS NULL AND t0.is_active = ?
Parameters:
[
  1
]
12 5.51 ms
SELECT t0.id AS id_1, t0.module_id AS module_id_2, t0.release_date AS release_date_3, t0.status AS status_4, t0.version AS version_5 FROM published_release t0 WHERE t0.status = ? ORDER BY t0.release_date DESC LIMIT 1
Parameters:
[
  100
]

Database Connections

Name Service
default doctrine.dbal.default_connection
legacy doctrine.dbal.legacy_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
legacy doctrine.orm.legacy_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Main\User 1
App\Entity\Main\LogAction 1
App\Entity\Main\AccountUser 1
App\Entity\Main\PublishedRelease 1

legacy entity manager

Class Amount of managed objects

Entities Mapping

default entity manager

Class Mapping errors
App\Entity\Main\AbstractBaseEntity No errors.
App\Entity\Main\User No errors.
App\Entity\Main\Permission No errors.
App\Entity\Main\LogAction No errors.
App\Entity\Main\AccountUser No errors.
App\Entity\Main\Account No errors.
App\Entity\Main\AccountModule No errors.
App\Entity\Main\PublishedRelease No errors.

legacy entity manager

No loaded entities.