https://easyjob.tn/offres

Query Metrics

2 Database Queries
2 Different statements
10.42 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
6.95 ms
(0.00%)
1
SELECT o0_.id AS id_0, o0_.description AS description_1, o0_.created_at AS created_at_2, o0_.salaire AS salaire_3, o0_.etat AS etat_4, o0_.publier AS publier_5, o0_.type AS type_6, o0_.epingle AS epingle_7, o0_.titre AS titre_8, s1_.id AS id_9, s1_.title AS title_10, o0_.user_id AS user_id_11, o0_.souscategorie_id AS souscategorie_id_12, s1_.categorie_id AS categorie_id_13 FROM offre o0_ INNER JOIN sous_categorie s1_ ON o0_.souscategorie_id = s1_.id INNER JOIN user u2_ ON o0_.user_id = u2_.id WHERE o0_.publier = 1 AND o0_.etat = ? ORDER BY o0_.created_at DESC
Parameters:
[
  "DISPONIBLE"
]
3.47 ms
(0.00%)
1
SELECT s0_.id AS id_0, s0_.title AS title_1, s0_.categorie_id AS categorie_id_2 FROM sous_categorie s0_ ORDER BY s0_.title ASC
Parameters:
[]

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\Offre
  • The mappings App\Entity\Offre#candidatures and App\Entity\User#offres are inconsistent with each other.
  • If association App\Entity\Offre#candidatures is many-to-many, then the inversed side App\Entity\User#offres has to be many-to-many as well.
App\Entity\SousCategorie No errors.
App\Entity\Categorie No errors.
App\Entity\Demande No errors.
App\Entity\User No errors.