Query Metrics
30
Database Queries
6
Different statements
31.01 ms
Query time
1
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.62 ms |
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:
[] |
2 | 1.08 ms |
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:
[] |
3 | 1.18 ms |
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:
[] |
4 | 0.99 ms |
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:
[] |
5 | 1.30 ms |
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:
[] |
6 | 1.64 ms |
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
]
|
7 | 0.92 ms |
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:
[
2
]
|
8 | 1.02 ms |
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:
[
4
]
|
9 | 0.85 ms |
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:
[
5
]
|
10 | 0.81 ms |
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:
[
6
]
|
11 | 0.81 ms |
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:
[
7
]
|
12 | 0.76 ms |
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:
[
8
]
|
13 | 1.02 ms |
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:
[
9
]
|
14 | 1.25 ms |
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:
[
10
]
|
15 | 0.95 ms |
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:
[
11
]
|
16 | 0.81 ms |
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:
[
12
]
|
17 | 1.07 ms |
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:
[
13
]
|
18 | 0.81 ms |
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:
[
14
]
|
19 | 0.89 ms |
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:
[
15
]
|
20 | 0.67 ms |
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:
[
16
]
|
21 | 0.65 ms |
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:
[
17
]
|
22 | 0.70 ms |
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:
[
18
]
|
23 | 0.95 ms |
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:
[
19
]
|
24 | 1.10 ms |
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:
[
20
]
|
25 | 1.12 ms |
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:
[
21
]
|
26 | 1.00 ms |
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:
[
22
]
|
27 | 0.88 ms |
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:
[
23
]
|
28 | 1.04 ms |
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:
[
24
]
|
29 | 1.02 ms |
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:
[
25
]
|
30 | 1.13 ms |
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:
[
26
]
|
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 |
|
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. |