GET https://dev.manalti.com/liste-des-emplois/detail-emploie/ASSISTANT-TRESORERIE-H-F

Query Metrics

10 Database Queries
10 Different statements
8.59 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.72 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.description AS description_3, t0.date_limite_candidature AS date_limite_candidature_4, t0.voie_application AS voie_application_5, t0.type_voie_application AS type_voie_application_6, t0.genre AS genre_7, t0.fichier AS fichier_8, t0.etat AS etat_9, t0.code_postal AS code_postal_10, t0.adresse AS adresse_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.zoom AS zoom_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.slug AS slug_17, t0.reference AS reference_18, t0.competence AS competence_19, t0.is_valid AS is_valid_20, t0.is_urgent AS is_urgent_21, t0.is_vedette AS is_vedette_22, t0.type_emploie_id AS type_emploie_id_23, t0.experience_id AS experience_id_24, t0.metier_id AS metier_id_25, t0.niveau_id AS niveau_id_26, t0.secteur_id AS secteur_id_27, t0.expertise_id AS expertise_id_28, t0.user_id AS user_id_29 FROM emploie t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "ASSISTANT-TRESORERIE-H-F"
]
2 0.35 ms
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM manage_cv t0 WHERE t0.user_id IS NULL
Parameters:
[]
3 0.33 ms
SELECT t0.id AS id_1, t0.fichier AS fichier_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.user_id AS user_id_6 FROM lettre_motivation t0 WHERE t0.user_id IS NULL
Parameters:
[]
4 0.47 ms
SELECT m0_.id AS id_0, m0_.description AS description_1 FROM metier m0_
Parameters:
[]
5 0.38 ms
SELECT s0_.id AS id_0, s0_.descripption AS descripption_1 FROM secteur_entreprise s0_
Parameters:
[]
6 0.65 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.username AS username_7, t0.telephone AS telephone_8, t0.organisation AS organisation_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.description AS description_12, t0.avatar AS avatar_13, t0.logo AS logo_14, t0.age AS age_15, t0.date_naissance AS date_naissance_16, t0.is_approuved AS is_approuved_17, t0.titre_emploie AS titre_emploie_18, t0.other_metier AS other_metier_19, t0.facebook AS facebook_20, t0.twitter AS twitter_21, t0.linkedin AS linkedin_22, t0.etat AS etat_23, t0.code_postal AS code_postal_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.zoom AS zoom_27, t0.image_couverture AS image_couverture_28, t0.slug AS slug_29, t0.website AS website_30, t0.date_creation AS date_creation_31, t0.adresse AS adresse_32, t0.tags AS tags_33, t0.is_valid AS is_valid_34, t0.is_urgent AS is_urgent_35, t0.google_id AS google_id_36, t0.is_notification AS is_notification_37, t0.is_hidden_email AS is_hidden_email_38, t0.metier_id AS metier_id_39, t0.expertise_id AS expertise_id_40, t0.niveau_id AS niveau_id_41, t0.secteur_id AS secteur_id_42, t0.genre_id AS genre_id_43 FROM user t0 WHERE t0.id = ?
Parameters:
[
  239
]
7 0.91 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM expertise t0 WHERE t0.id = ?
Parameters:
[
  2
]
8 2.79 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM genre t0 INNER JOIN emploie_genre ON t0.id = emploie_genre.genre_id WHERE emploie_genre.emploie_id = ?
Parameters:
[
  49
]
9 1.72 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM niveau t0 WHERE t0.id = ?
Parameters:
[
  3
]
10 0.28 ms
SELECT t0.id AS id_1, t0.description AS description_2 FROM type_emploie t0 WHERE t0.id = ?
Parameters:
[
  5
]

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\Emploie
  • The association App\Entity\Emploie#users refers to the owning side field App\Entity\User#emploie which does not exist.
App\Entity\TypeEmploie No errors.
App\Entity\Experience No errors.
App\Entity\Metier No errors.
App\Entity\Niveau No errors.
App\Entity\Secteur No errors.
App\Entity\Expertise No errors.
App\Entity\User No errors.
App\Entity\Genre No errors.
App\Entity\Candidature No errors.
App\Entity\ManageCv No errors.
App\Entity\LettreMotivation No errors.
App\Entity\SecteurEntreprise No errors.
App\Entity\Education No errors.
App\Entity\Portofolio No errors.
App\Entity\Competence No errors.
App\Entity\Langue No errors.
App\Entity\Formation No errors.
App\Entity\Reviews No errors.