Query Metrics
13
Database Queries
3
Different statements
2.67 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 0.77 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.created_at AS created_at_5, t0.edit_at AS edit_at_6, t0.max_player AS max_player_7, t0.status AS status_8, t0.recrutement AS recrutement_9, t0.owner_id AS owner_id_10 FROM groupe_jdr t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||||||
2 | 0.37 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
3
]
|
||||||||||||||||||||||||||||||||||||
3 | 0.19 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
5
]
|
||||||||||||||||||||||||||||||||||||
4 | 0.15 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
8
]
|
||||||||||||||||||||||||||||||||||||
5 | 0.15 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||||||
6 | 0.14 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
14
]
|
||||||||||||||||||||||||||||||||||||
7 | 0.17 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
15
]
|
||||||||||||||||||||||||||||||||||||
8 | 0.13 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
16
]
|
||||||||||||||||||||||||||||||||||||
9 | 0.13 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
17
]
|
||||||||||||||||||||||||||||||||||||
10 | 0.14 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
18
]
|
||||||||||||||||||||||||||||||||||||
11 | 0.12 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
19
]
|
||||||||||||||||||||||||||||||||||||
12 | 0.12 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.first_name AS first_name_6, t0.last_name AS last_name_7, t0.birth_date AS birth_date_8, t0.phone_number AS phone_number_9, t0.gender AS gender_10, t0.bio AS bio_11, t0.avatar AS avatar_12, t0.username AS username_13, t0.discord_pseudo AS discord_pseudo_14, t0.twitter_pseudo AS twitter_pseudo_15, t0.roll20_pseudo AS roll20_pseudo_16, t0.youtube_channel_link AS youtube_channel_link_17, t0.twitch_channel_link AS twitch_channel_link_18, t0.competence AS competence_19 FROM `user` t0 INNER JOIN groupejdr_players ON t0.id = groupejdr_players.user_id WHERE groupejdr_players.groupe_jdr_id = ?
Parameters:
[
20
]
|
||||||||||||||||||||||||||||||||||||
13 | 0.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0
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\GroupeJDR | No errors. |
App\Entity\User |
|
App\Entity\Invitation | No errors. |
App\Entity\NotificationHistory | No errors. |
App\Entity\Category | No errors. |
App\Entity\Event | No errors. |
App\Entity\PlayerMembership | No errors. |