GET https://temporaire.daip.ci/metiers

Response
200 OK
IP
216.73.216.58
Profiled on
Token
a3e8f7

Query Metrics

3 Database Queries
3 Different statements
5.22 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.21 ms 
SELECT m0_.id AS id_0 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id ORDER BY m0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 2.73 ms 
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.creation AS creation_2, m0_.modification AS modification_3, s1_.id AS id_4, s1_.nom AS nom_5, s1_.creation AS creation_6, s1_.modification AS modification_7, e2_.id AS id_8, e2_.nbrplace AS nbrplace_9, e2_.niveau_requis AS niveau_requis_10, e2_.duree_formation AS duree_formation_11, e3_.id AS id_12, e3_.nom AS nom_13, e3_.definition AS definition_14, e3_.creation AS creation_15, e3_.modification AS modification_16, m0_.secteur_id AS secteur_id_17, m0_.user_id AS user_id_18, s1_.user_id AS user_id_19, e2_.etablissement_id AS etablissement_id_20, e2_.metier_id AS metier_id_21, e3_.localite_id AS localite_id_22, e3_.direction_regionale_id AS direction_regionale_id_23, e3_.user_id AS user_id_24 FROM metier m0_ LEFT JOIN secteur s1_ ON m0_.secteur_id = s1_.id LEFT JOIN etablissement_metier e2_ ON m0_.id = e2_.metier_id LEFT JOIN etablissement e3_ ON e2_.etablissement_id = e3_.id WHERE m0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY m0_.nom ASC
Parameters: 
[
  64
  65
  32
  74
  16
  7
  61
  73
  82
  67
  15
  34
  57
  30
  58
  6
  47
  77
  56
  22
  41
  69
  70
  71
  11
  76
  79
  25
  62
  46
  3
  19
  12
  54
  42
  28
  53
  8
  50
  51
  63
  83
  55
  81
  14
  21
  4
  1
  85
  20
  44
  13
  45
  48
  78
  9
  5
  60
  75
  17
  80
  72
  29
  2
  10
  38
  39
  43
  33
  36
  37
  35
  26
  52
  24
  31
  27
  23
  66
  84
  68
  18
  59
  40
  49
  86
]
View formatted query    View runnable query    Explain query
3 0.28 ms 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.creation AS creation_3, t0.modification AS modification_4, t0.user_id AS user_id_5 FROM secteur t0 ORDER BY t0.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query

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\Metier No errors.
App\Entity\Secteur No errors.
App\Entity\EtablissementMetier No errors.
App\Entity\Etablissement No errors.
App\Entity\User No errors.
App\Entity\Localite No errors.
App\Entity\DirectionRegionale No errors.
App\Entity\Candidature
  • The field App\Entity\Candidature#admis is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Admis#candidature does not contain the required 'inversedBy="admis"' attribute.