https://easyjob.tn/

Query Metrics

5 Database Queries
5 Different statements
11.64 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.14 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.created_at AS created_at_5, t0.username AS username_6, t0.token AS token_7, t0.lastname AS lastname_8, t0.phone AS phone_9, t0.address AS address_10, t0.ville AS ville_11, t0.reset_token AS reset_token_12, t0.naissance AS naissance_13, t0.experience AS experience_14, t0.sociale AS sociale_15, t0.bancaire AS bancaire_16, t0.cv AS cv_17, t0.identite AS identite_18, t0.logo AS logo_19, t0.etablissement AS etablissement_20, t0.a_propos AS a_propos_21, t0.matricule AS matricule_22, t0.is_blocked AS is_blocked_23, t0.enabled AS enabled_24, t25.id AS id_26, t25.image_name AS image_name_27, t25.updated_at AS updated_at_28, t25.user_images_id AS user_images_id_29 FROM user t0 LEFT JOIN user_image t25 ON t25.user_images_id = t0.id
Parameters:
[]
3.10 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.description AS description_2, t0.salaire AS salaire_3, t0.bloque AS bloque_4, t0.epingle AS epingle_5, t0.etat AS etat_6, t0.created_at AS created_at_7, t0.titre AS titre_8, t0.part AS part_9, t0.tax AS tax_10, t0.total AS total_11, t0.type AS type_12, t0.start_time AS start_time_13, t0.end_time AS end_time_14, t0.end_date_cdi AS end_date_cdi_15, t0.start_period AS start_period_16, t0.end_period AS end_period_17, t0.user_id AS user_id_18, t0.souscategorie_id AS souscategorie_id_19 FROM demande t0
Parameters:
[]
2.53 ms
(0.00%)
1
SELECT d0_.id AS id_0, d0_.description AS description_1, d0_.salaire AS salaire_2, d0_.bloque AS bloque_3, d0_.epingle AS epingle_4, d0_.etat AS etat_5, d0_.created_at AS created_at_6, d0_.titre AS titre_7, d0_.part AS part_8, d0_.tax AS tax_9, d0_.total AS total_10, d0_.type AS type_11, d0_.start_time AS start_time_12, d0_.end_time AS end_time_13, d0_.end_date_cdi AS end_date_cdi_14, d0_.start_period AS start_period_15, d0_.end_period AS end_period_16, s1_.id AS id_17, s1_.title AS title_18, d0_.user_id AS user_id_19, d0_.souscategorie_id AS souscategorie_id_20, s1_.categorie_id AS categorie_id_21 FROM demande d0_ INNER JOIN sous_categorie s1_ ON d0_.souscategorie_id = s1_.id WHERE d0_.etat = ? AND d0_.epingle = ? AND (d0_.start_period >= ? OR d0_.end_date_cdi >= ?) ORDER BY d0_.created_at DESC
Parameters:
[
  "DISPONIBLE"
  1
  "2024-12-25 23:16:45"
  "2024-12-25 23:16:45"
]
1.18 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categorie t0
Parameters:
[]
0.69 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.categorie_id AS categorie_id_3 FROM sous_categorie t0
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\Demande No errors.
App\Entity\Categorie No errors.
App\Entity\User No 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\Comments No errors.
App\Entity\Candidature No errors.
App\Entity\UserImage No errors.
App\Entity\CommentOffre No errors.