GET https://medem.snovibox.com/api/decision/stats

Query Metrics

6 Database Queries
2 Different statements
7.28 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.83 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "CIVILE"
]
2 0.44 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "SOCIALE"
]
3 0.29 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.designation AS designation_3 FROM nature t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "COMMERCIALE"
]
4 4.29 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE n3_.id = ? OR n3_.code = ?
Parameters:
[
  1
  1
]
5 0.83 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE n3_.id = ? OR n3_.code = ?
Parameters:
[
  4
  4
]
6 0.60 ms
SELECT COUNT(d0_.id) AS sclr_0 FROM decision d0_ LEFT JOIN cassation c1_ ON d0_.cassation_id = c1_.id LEFT JOIN solution s2_ ON d0_.solution_id = s2_.id LEFT JOIN nature n3_ ON d0_.nature_id = n3_.id LEFT JOIN statut s4_ ON d0_.statut_id = s4_.id LEFT JOIN decision_matiere d6_ ON d0_.id = d6_.decision_id LEFT JOIN matiere m5_ ON m5_.id = d6_.matiere_id WHERE n3_.id = ? OR n3_.code = ?
Parameters:
[
  2
  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.

Entities Mapping

Class Mapping errors
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken No errors.
App\Entity\RefreshToken No errors.
App\Entity\Nature No errors.
App\Entity\Decision
  • The mappings App\Entity\Decision#validateBy and App\Entity\Utilisateur#validatedDecisions are inconsistent with each other.
App\Entity\Draft No errors.
App\Entity\Cassation No errors.
App\Entity\Solution No errors.
App\Entity\Statut No errors.
App\Entity\Matiere No errors.