Query Metrics
638
Database Queries
10
Different statements
249.12 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
72.06 ms (28.92%) |
135 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN character_fiche_role ON t0.id = character_fiche_role.role_id WHERE character_fiche_role.character_fiche_id = ?
Parameters:
[
1
]
|
48.40 ms (19.43%) |
135 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rarity AS rarity_3, t0.description AS description_4, t0.image AS image_5, t0.passive AS passive_6, t0.fiche AS fiche_7, t0.weapon_type_id AS weapon_type_id_8 FROM weapon t0 INNER JOIN character_fiche_weapon ON t0.id = character_fiche_weapon.weapon_id WHERE character_fiche_weapon.character_fiche_id = ?
Parameters:
[
1
]
|
44.53 ms (17.88%) |
135 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.fiche AS fiche_3, t0.image AS image_4 FROM artifact_set t0 INNER JOIN character_fiche_artifact_set ON t0.id = character_fiche_artifact_set.artifact_set_id WHERE character_fiche_artifact_set.character_fiche_id = ?
Parameters:
[
1
]
|
32.81 ms (13.17%) |
107 |
SELECT t0.display_weapons AS display_weapons_1, t0.id AS id_2, t0.name AS name_3, t0.image AS image_4, t0.genshin_character_id AS genshin_character_id_5, t0.version_id AS version_id_6 FROM character_fiche t0 WHERE t0.genshin_character_id = ?
Parameters:
[
2
]
|
32.50 ms (13.05%) |
107 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rarity AS rarity_3, t0.image_icon AS image_icon_4, t0.weapon_type_id AS weapon_type_id_5, t0.character_element_id AS character_element_id_6 FROM `character` t0 WHERE t0.id = ?
Parameters:
[
2
]
|
5.98 ms (2.40%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.rarity AS rarity_3, t0.description AS description_4, t0.image AS image_5, t0.passive AS passive_6, t0.fiche AS fiche_7, t0.weapon_type_id AS weapon_type_id_8 FROM weapon t0 WHERE t0.weapon_type_id = ?
Parameters:
[
5
]
|
3.70 ms (1.48%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.color AS color_4 FROM elements t0 WHERE t0.id = ?
Parameters:
[
2
]
|
3.55 ms (1.43%) |
1 |
SELECT t0.display_weapons AS display_weapons_1, t0.id AS id_2, t0.name AS name_3, t0.image AS image_4, t0.genshin_character_id AS genshin_character_id_5, t0.version_id AS version_id_6 FROM character_fiche t0
Parameters:
[] |
3.51 ms (1.41%) |
5 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3 FROM weapon_type t0 WHERE t0.id = ?
Parameters:
[
5
]
|
2.09 ms (0.84%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.password AS password_4, t0.creation_date AS creation_date_5, t0.roles AS roles_6, t0.last_connection_date AS last_connection_date_7, t8.id AS id_9, t8.access_token AS access_token_10, t8.refresh_token AS refresh_token_11, t8.user_id AS user_id_12, t0.team_id AS team_id_13 FROM user t0 LEFT JOIN discord_credentials t8 ON t8.user_id = t0.id WHERE t0.email = ? LIMIT 1
Parameters:
[
"kibo@guda.club"
]
|
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\Discord\DiscordCredentials | No errors. |
App\Entity\Team | No errors. |
App\Entity\Discord\DiscordEmbedMessage | No errors. |
App\Entity\Discord\DiscordGroupedMessages | No errors. |
App\Entity\Discord\DiscordWebhook | No errors. |
App\Entity\Hoyolab\HoyolabPostUser | No errors. |
App\Entity\Logs | No errors. |
App\Entity\FicheGazette | No errors. |
App\Entity\CharacterFiche | No errors. |
App\Entity\Genshin\Character | No errors. |
App\Entity\Genshin\Version | No errors. |
App\Entity\Genshin\Weapon | No errors. |
App\Entity\Genshin\Role | No errors. |
App\Entity\Genshin\ArtifactSet | No errors. |
App\Entity\Genshin\WeaponType | No errors. |
App\Entity\Genshin\Elements | No errors. |