GET https://ecobattle.jaouahir.com/api/dashboard

Query Metrics

6 Database Queries
6 Different statements
0.96 ms Query time
0 Invalid entities
37 Managed entities

Grouped Statements

Show all queries

Time Count Info
0.20 ms
(20.34%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.id = ?
Parameters:
[
  31
]
0.18 ms
(19.07%)
1
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = ? ORDER BY t0.date_envoi DESC
Parameters:
[
  31
]
0.15 ms
(15.78%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.point AS point_4, t0.economie_co2 AS economie_co2_5, t0.created_at AS created_at_6, t0.categorie_id AS categorie_id_7, t0.difficulte_id AS difficulte_id_8 FROM defi t0
Parameters:
[]
0.15 ms
(15.76%)
1
SELECT t0.id AS id_1, t0.url_image AS url_image_2, t0.date_envoi AS date_envoi_3, t0.status AS status_4, t0.defi_id AS defi_id_5, t0.user_id AS user_id_6 FROM preuve t0 WHERE t0.user_id = ? AND t0.status = ? ORDER BY t0.date_envoi DESC LIMIT 5
Parameters:
[
  31
  "VALIDE"
]
0.14 ms
(15.04%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.role AS role_6, t0.score_total AS score_total_7, t0.total_co2 AS total_co2_8, t0.created_at AS created_at_9, t0.equipe_id AS equipe_id_10 FROM user t0 WHERE t0.equipe_id = ?
Parameters:
[
  3
]
0.13 ms
(14.00%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.score_equipe AS score_equipe_3, t0.code_invitation AS code_invitation_4, t0.created_at AS created_at_5 FROM equipe t0 WHERE t0.id = ?
Parameters:
[
  3
]

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\Defi 18
App\Entity\DefiCategorie 9
App\Entity\User 5
App\Entity\DefiDifficulte 4
App\Entity\Equipe 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Equipe No errors.
App\Entity\Preuve No errors.
App\Entity\Message No errors.
App\Entity\Conversation No errors.
App\Entity\Score No errors.
App\Entity\Defi No errors.
App\Entity\DefiCategorie No errors.
App\Entity\DefiDifficulte No errors.
App\Entity\Competition No errors.