GET https://adbs.spontaneit.fr/emplois

Response
200 OK
IP
18.222.161.245
Profiled on
Token
f320a3

Query Metrics

30 Database Queries
6 Different statements
35.40 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
28.64 ms
(80.91%) 		25 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM emploi_contrat_travail t0 INNER JOIN emploi_emploi_contrat_travail ON t0.id = emploi_emploi_contrat_travail.emploi_contrat_travail_id WHERE emploi_emploi_contrat_travail.emploi_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
2.38 ms
(6.72%) 		1 
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.commune AS commune_2, e0_.nombre_heures_hebdo AS nombre_heures_hebdo_3, e0_.date AS date_4, e0_.description AS description_5, e0_.profil_recherche AS profil_recherche_6, e0_.salaire AS salaire_7, e0_.employeur AS employeur_8, e0_.modalites_candidature AS modalites_candidature_9, e0_.coordonnees AS coordonnees_10, e0_.source AS source_11, e0_.alias AS alias_12, e0_.date_create AS date_create_13, e0_.date_update AS date_update_14, e0_.reference AS reference_15, e0_.published AS published_16, e0_.date_publication AS date_publication_17, e0_.filename AS filename_18, e0_.filelabel AS filelabel_19, e0_.diplome_id AS diplome_id_20, e0_.statut_id AS statut_id_21, e0_.user_update_id AS user_update_id_22, e0_.user_create_id AS user_create_id_23, e0_.pays_id AS pays_id_24, e0_.tempstravail_id AS tempstravail_id_25, e0_.responsabilite_id AS responsabilite_id_26 FROM emploi e0_ WHERE e0_.published = 1
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.19 ms
(3.35%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.alias AS alias_5 FROM emploi_niveau_qualification t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.11 ms
(3.12%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM metier t0 ORDER BY t0.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.08 ms
(3.04%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.date_create AS date_create_4, t0.date_update AS date_update_5, t0.alias AS alias_6 FROM emploi_contrat_travail t0
Parameters: 
[]
View formatted query    View runnable query    Explain query
1.01 ms
(2.86%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.date_create AS date_create_3, t0.date_update AS date_update_4, t0.alias AS alias_5 FROM emploi_region t0 ORDER BY t0.name 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\Emploi No errors.
App\Entity\EmploiDiplome No errors.
App\Entity\EmploiStatut No errors.
App\Entity\User No errors.
App\Entity\EmploiPays No errors.
App\Entity\EmploiTempsTravail No errors.
App\Entity\EmploiResponsabilite No errors.
App\Entity\Metier
  • The association App\Entity\Metier#formations refers to the owning side field App\Entity\Formation#metiers which does not exist.
App\Entity\Thematique No errors.
App\Entity\EmploiRegion No errors.
App\Entity\EmploiDepartement No errors.
App\Entity\EmploiContratTravail No errors.
App\Entity\EmploiNiveauQualification No errors.
App\Entity\Evenement No errors.
App\Entity\Formation No errors.