GET https://dev.kayre.fr/admin/session

Query Metrics

23 Database Queries
5 Different statements
24.70 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 1.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 5.52 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.created_at AS created_at_3, t0.in_progress AS in_progress_4, t0.close AS close_5, t0.all_registered AS all_registered_6, t0.company_id AS company_id_7, t0.learning_id AS learning_id_8, t0.kine_id AS kine_id_9, t0.rf_id AS rf_id_10, t0.created_by_id AS created_by_id_11 FROM SESSION t0
Parameters:
[]
3 2.87 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.type AS type_5, t0.created_by_id AS created_by_id_6 FROM learning t0 WHERE t0.id = ?
Parameters:
[
  2
]
4 2.21 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adress AS adress_3, t0.adress2 AS adress2_4, t0.cp AS cp_5, t0.town AS town_6, t0.created_by_id AS created_by_id_7 FROM company t0 WHERE t0.id = ?
Parameters:
[
  1
]
5 0.80 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  5
]
6 0.56 ms
SELECT t0.id AS id_1, t0.email_sent AS email_sent_2, t0.session_id AS session_id_3, t0.user_id AS user_id_4 FROM session_user t0 WHERE t0.session_id = ?
Parameters:
[
  1
]
7 0.69 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 0.92 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adress AS adress_3, t0.adress2 AS adress2_4, t0.cp AS cp_5, t0.town AS town_6, t0.created_by_id AS created_by_id_7 FROM company t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.68 ms
SELECT t0.id AS id_1, t0.email_sent AS email_sent_2, t0.session_id AS session_id_3, t0.user_id AS user_id_4 FROM session_user t0 WHERE t0.session_id = ?
Parameters:
[
  2
]
10 0.80 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.type AS type_5, t0.created_by_id AS created_by_id_6 FROM learning t0 WHERE t0.id = ?
Parameters:
[
  3
]
11 0.67 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adress AS adress_3, t0.adress2 AS adress2_4, t0.cp AS cp_5, t0.town AS town_6, t0.created_by_id AS created_by_id_7 FROM company t0 WHERE t0.id = ?
Parameters:
[
  5
]
12 0.72 ms
SELECT t0.id AS id_1, t0.email_sent AS email_sent_2, t0.session_id AS session_id_3, t0.user_id AS user_id_4 FROM session_user t0 WHERE t0.session_id = ?
Parameters:
[
  5
]
13 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  23
]
14 0.63 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  24
]
15 0.61 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  26
]
16 0.62 ms
SELECT t0.id AS id_1, t0.email_sent AS email_sent_2, t0.session_id AS session_id_3, t0.user_id AS user_id_4 FROM session_user t0 WHERE t0.session_id = ?
Parameters:
[
  6
]
17 0.69 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.adress AS adress_3, t0.adress2 AS adress2_4, t0.cp AS cp_5, t0.town AS town_6, t0.created_by_id AS created_by_id_7 FROM company t0 WHERE t0.id = ?
Parameters:
[
  6
]
18 0.79 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  27
]
19 0.66 ms
SELECT t0.id AS id_1, t0.email_sent AS email_sent_2, t0.session_id AS session_id_3, t0.user_id AS user_id_4 FROM session_user t0 WHERE t0.session_id = ?
Parameters:
[
  7
]
20 0.71 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  28
]
21 0.51 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  29
]
22 0.43 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  30
]
23 0.38 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.first_name AS first_name_6, t0.born_date AS born_date_7, t0.company_function AS company_function_8, t0.phone AS phone_9, t0.cu AS cu_10, t0.healthcar_pro AS healthcar_pro_11, t0.company_id AS company_id_12 FROM user t0 WHERE t0.id = ?
Parameters:
[
  31
]

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
  • The field App\Entity\User#sessions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Session#kine does not contain the required 'inversedBy="sessions"' attribute.
  • The field App\Entity\User#sessionUsers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\SessionUser#user does not contain the required 'inversedBy="sessionUsers"' attribute.
App\Entity\Company No errors.
App\Entity\Media No errors.
App\Entity\CareTarget No errors.
App\Entity\Learning No errors.
App\Entity\Mail No errors.
App\Entity\QuestionQVT No errors.
App\Entity\Session No errors.
App\Entity\SessionUser No errors.
App\Entity\ResponseQvt No errors.
App\Entity\QuizDo No errors.
App\Entity\HealtDatas No errors.
App\Entity\TrainingSessionUser No errors.
App\Entity\WeekTrainingDone No errors.
App\Entity\LoginRecord No errors.
App\Entity\Quiz No errors.