GET https://www.temporaire.daip.ci/etablissements

Response
200 OK
IP
216.73.216.255
Profiled on
Token
770248

Query Metrics

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

Grouped Statements

Show all queries

Time▼ Count Info
3.41 ms
(68.10%) 		1 
SELECT e0_.id AS id_0, e0_.nom AS nom_1, e0_.definition AS definition_2, e0_.creation AS creation_3, e0_.modification AS modification_4, l1_.id AS id_5, l1_.nom AS nom_6, l1_.type AS type_7, l1_.creation AS creation_8, l1_.modification AS modification_9, d2_.id AS id_10, d2_.nom AS nom_11, d2_.chef_lieu AS chef_lieu_12, d2_.creation AS creation_13, d2_.modification AS modification_14, e3_.id AS id_15, e3_.nbrplace AS nbrplace_16, e3_.niveau_requis AS niveau_requis_17, e3_.duree_formation AS duree_formation_18, m4_.id AS id_19, m4_.nom AS nom_20, m4_.creation AS creation_21, m4_.modification AS modification_22, e0_.localite_id AS localite_id_23, e0_.direction_regionale_id AS direction_regionale_id_24, e0_.user_id AS user_id_25, l1_.parent_id AS parent_id_26, l1_.direction_regionale_id AS direction_regionale_id_27, l1_.user_id AS user_id_28, d2_.user_id AS user_id_29, e3_.etablissement_id AS etablissement_id_30, e3_.metier_id AS metier_id_31, m4_.secteur_id AS secteur_id_32, m4_.user_id AS user_id_33 FROM etablissement e0_ LEFT JOIN localite l1_ ON e0_.localite_id = l1_.id LEFT JOIN direction_regionale d2_ ON l1_.direction_regionale_id = d2_.id LEFT JOIN etablissement_metier e3_ ON e0_.id = e3_.etablissement_id LEFT JOIN metier m4_ ON e3_.metier_id = m4_.id WHERE e0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY e0_.nom ASC
Parameters: 
[
  12
  13
  3
  7
  102
  100
  9
  104
  10
  14
  11
  16
  1
  18
  19
  17
  20
  21
  22
  23
  24
  15
  25
  75
  74
  77
  78
  76
  27
  28
  112
  111
  26
  114
  113
  103
  29
  101
  4
  31
  33
  34
  35
  36
  37
  38
  39
  40
  41
  42
  43
  44
  45
  46
  47
  48
  50
  51
  52
  53
  54
  49
  115
  58
  59
  60
  61
  62
  63
  57
  64
  65
  32
  55
  66
  56
  68
  67
  69
  70
  71
  72
  2
  73
  8
  105
  5
  80
  79
  81
  82
  83
  84
  85
  86
  87
  88
  89
  90
  95
  91
  97
  92
  93
  94
  96
  98
  99
  6
  106
  107
  108
  109
  110
]
View formatted query    View runnable query    Explain query
1.37 ms
(27.32%) 		1 
SELECT e0_.id AS id_0 FROM etablissement e0_ ORDER BY e0_.nom ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.23 ms
(4.58%) 		1 
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.chef_lieu AS chef_lieu_3, t0.creation AS creation_4, t0.modification AS modification_5, t0.user_id AS user_id_6 FROM direction_regionale 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\Etablissement No errors.
App\Entity\Localite No errors.
App\Entity\DirectionRegionale No errors.
App\Entity\EtablissementMetier No errors.
App\Entity\Metier No errors.
App\Entity\User No errors.
App\Entity\Secteur 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.