GET https://guda.club/api/gudapi/character-fiche/get-characters

Query Metrics

638 Database Queries
10 Different statements
249.12 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.