POST https://devformations.masolutionit.com/fr/employee/239/delete

Query Metrics

10 Database Queries
9 Different statements
6.44 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.39 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.active AS active_7, t0.roles AS roles_8, t0.totp_secret AS totp_secret_9, t0.totp_enable AS totp_enable_10, t11.id AS id_12, t11.user_id AS user_id_13, t11.company_id AS company_id_14 FROM user t0 LEFT JOIN employee t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  178
]
2 0.26 ms
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.company_id AS company_id_3 FROM employee t0 WHERE t0.id = ?
Parameters:
[
  "239"
]
3 0.29 ms
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.success AS success_4, t0.success_rate AS success_rate_5, t0.progress AS progress_6, t0.tries AS tries_7, t0.employee_id AS employee_id_8, t0.questionnaire_id AS questionnaire_id_9 FROM employee_questionnaire t0 WHERE t0.employee_id = ?
Parameters:
[
  239
]
4 0.27 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.last_name AS last_name_5, t0.first_name AS first_name_6, t0.active AS active_7, t0.roles AS roles_8, t0.totp_secret AS totp_secret_9, t0.totp_enable AS totp_enable_10, t11.id AS id_12, t11.user_id AS user_id_13, t11.company_id AS company_id_14 FROM user t0 LEFT JOIN employee t11 ON t11.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  293
]
5 0.34 ms
SELECT t0.id AS id_1, t0.employee_questionnaire_id AS employee_questionnaire_id_2, t0.answer_id AS answer_id_3 FROM answer_employee t0 WHERE t0.employee_questionnaire_id = ?
Parameters:
[
  3309
]
6 0.61 ms
"START TRANSACTION"
Parameters:
[]
7 0.32 ms
DELETE FROM employee_questionnaire WHERE id = ?
Parameters:
[
  3309
]
8 0.24 ms
DELETE FROM employee WHERE id = ?
Parameters:
[
  239
]
9 0.27 ms
DELETE FROM user WHERE id = ?
Parameters:
[
  293
]
10 3.44 ms
"COMMIT"
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Employee No errors.
App\Entity\Company No errors.
App\Entity\EmployeeQuestionnaire No errors.
App\Entity\Questionnaire No errors.
App\Entity\AnswerEmployee No errors.
App\Entity\Answer No errors.