Redirect 302 redirect from POST @app_discord_connect (9b086e)

GET https://www.1ercorpscolonial.fr/discord/auth?code=Qi0itl8f1idBG1sU8IAnaydxicc6j8

Query Metrics

118 Database Queries
9 Different statements
116.62 ms Query time
0 Invalid entities
109 Managed entities

Grouped Statements

Show all queries

Time Count Info
79.49 ms
(68.16%)
103
SELECT t0.id AS id_1, t0.name AS name_2, t0.discord_id AS discord_id_3 FROM role t0 WHERE t0.discord_id = ? LIMIT 1
Parameters:
[
  "523426571541807117"
]
7.39 ms
(6.34%)
1
DELETE FROM user_role WHERE user_id = ?
Parameters:
[
  110
]
7.19 ms
(6.16%)
1
"COMMIT"
Parameters:
[]
6.30 ms
(5.41%)
1
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.discord_id AS discord_id_4, t0.avatar AS avatar_5, t6.id AS id_7, t6.status AS status_8, t6.last_promotion AS last_promotion_9, t6.date_entree AS date_entree_10, t6.json_entrer AS json_entrer_11, t6.promotion_send AS promotion_send_12, t6.user_id AS user_id_13, t6.grade_id AS grade_id_14, t6.pending_approval_id AS pending_approval_id_15 FROM user t0 LEFT JOIN rhmember t6 ON t6.user_id = t0.id WHERE t0.discord_id = ? LIMIT 1
Parameters:
[
  "470111600687185942"
]
5.91 ms
(5.07%)
6
INSERT INTO user_role (user_id, role_id) VALUES (?, ?)
Parameters:
[
  110
  66
]
4.93 ms
(4.22%)
1
SELECT t0.id AS id_1, t0.type_param AS type_param_2 FROM parameter_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
2.78 ms
(2.39%)
2
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.value_text AS value_text_2, p0_.value_type_id AS value_type_id_3, p0_.value_user_id AS value_user_id_4, p0_.value_channel_id AS value_channel_id_5 FROM parameter p0_ WHERE p0_.name = ?
Parameters:
[
  "ROLE_RH"
]
2.08 ms
(1.78%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.discord_id AS discord_id_3 FROM role t0 INNER JOIN parameter_role ON t0.id = parameter_role.role_id WHERE parameter_role.parameter_id = ?
Parameters:
[
  19
]
0.55 ms
(0.47%)
1
"START TRANSACTION"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Role 103
App\Entity\Parameter 2
App\Entity\User 1
App\Entity\RHMember 1
App\Entity\Rank 1
App\Entity\ParameterType 1

Entities Mapping