Redirect 302 redirect from POST @app_discord_connect (b3e511)

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

Query Metrics

121 Database Queries
10 Different statements
54.15 ms Query time
0 Invalid entities
109 Managed entities

Grouped Statements

Show all queries

Time Count Info
27.26 ms
(50.34%)
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"
]
8.14 ms
(15.03%)
2
"COMMIT"
Parameters:
[]
7.70 ms
(14.22%)
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"
]
3.36 ms
(6.21%)
6
INSERT INTO user_role (user_id, role_id) VALUES (?, ?)
Parameters:
[
  110
  66
]
2.70 ms
(4.99%)
1
UPDATE user SET avatar = ? WHERE id = ?
Parameters:
[
  "fed72e6a5d28138ee3d4113c873c2a70"
  110
]
2.18 ms
(4.02%)
1
DELETE FROM user_role WHERE user_id = ?
Parameters:
[
  110
]
1.43 ms
(2.65%)
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"
]
0.84 ms
(1.56%)
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.31 ms
(0.57%)
2
"START TRANSACTION"
Parameters:
[]
0.23 ms
(0.43%)
1
SELECT t0.id AS id_1, t0.type_param AS type_param_2 FROM parameter_type t0 WHERE t0.id = ?
Parameters:
[
  2
]

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