Query Metrics
4
Database Queries
4
Different statements
3.23 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
1.20 ms (37.20%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3 FROM business_unit t0
Parameters:
[] |
1.04 ms (32.19%) |
1 |
SELECT j0_.id AS id_0, j0_.titre_fr AS titre_fr_1, j0_.titre_en AS titre_en_2, j0_.texte_fr AS texte_fr_3, j0_.texte_en AS texte_en_4, j0_.image AS image_5, j0_.reference AS reference_6, j0_.lieu AS lieu_7, j0_.mission AS mission_8, j0_.mission_en AS mission_en_9, j0_.profil_fr AS profil_fr_10, j0_.profil_en AS profil_en_11, j0_.proposition_fr AS proposition_fr_12, j0_.proposition_en AS proposition_en_13, j0_.afficher AS afficher_14, j0_.business_unit_id AS business_unit_id_15, j0_.lieux_jobs_id AS lieux_jobs_id_16 FROM jobs j0_ WHERE j0_.business_unit_id = ? AND j0_.titre_fr = ?
Parameters:
[ "8" "ERP Application Consultant CPI" ] |
0.62 ms (19.24%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3 FROM lieux_jobs t0
Parameters:
[] |
0.37 ms (11.37%) |
1 |
SELECT t0.id AS id_1, t0.titre_fr AS titre_fr_2, t0.titre_en AS titre_en_3, t0.texte_fr AS texte_fr_4, t0.texte_en AS texte_en_5, t0.image AS image_6, t0.reference AS reference_7, t0.lieu AS lieu_8, t0.mission AS mission_9, t0.mission_en AS mission_en_10, t0.profil_fr AS profil_fr_11, t0.profil_en AS profil_en_12, t0.proposition_fr AS proposition_fr_13, t0.proposition_en AS proposition_en_14, t0.afficher AS afficher_15, t0.business_unit_id AS business_unit_id_16, t0.lieux_jobs_id AS lieux_jobs_id_17 FROM jobs 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\Jobs | No errors. |
App\Entity\BusinessUnit | No errors. |
App\Entity\LieuxJobs | No errors. |
App\Entity\Sections | No errors. |