Query Metrics
13
Database Queries
13
Different statements
31.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
4.46 ms (14.05%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.etat AS etat_4 FROM env_intervention t0 INNER JOIN projet_env_intervention ON t0.id = projet_env_intervention.env_intervention_id WHERE projet_env_intervention.projet_id = ?
Parameters:
[
58
]
|
|
3.98 ms (12.55%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.description_fr AS description_fr_4, t0.description_ar AS description_ar_5, t0.date_debut AS date_debut_6, t0.date_fin AS date_fin_7, t0.budget_devise AS budget_devise_8, t0.budget_tnd AS budget_tnd_9, t0.perc_avancement AS perc_avancement_10, t0.image_ala_une AS image_ala_une_11, t0.is_ala_une AS is_ala_une_12, t0.is_projet_national AS is_projet_national_13, t0.etat AS etat_14, t0.mode_projet AS mode_projet_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.devise_id AS devise_id_18, t0.status_id AS status_id_19, t0.mod_execution_id AS mod_execution_id_20, t0.sous_secteur_id AS sous_secteur_id_21, t0.sous_domaine_id AS sous_domaine_id_22, t0.user_id AS user_id_23, t0.type_projet_id AS type_projet_id_24 FROM projet t0 WHERE t0.id = ?
Parameters:
[
"58"
]
|
|
3.54 ms (11.15%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.nom_en AS nom_en_4, t0.president_fr AS president_fr_5, t0.president_ar AS president_ar_6, t0.secretaire_generale_ar AS secretaire_generale_ar_7, t0.secretaire_generale_fr AS secretaire_generale_fr_8, t0.description_fr AS description_fr_9, t0.description_ar AS description_ar_10, t0.longitude AS longitude_11, t0.latitude AS latitude_12, t0.date_creation AS date_creation_13, t0.date_update AS date_update_14, t0.logo AS logo_15, t0.image_pub AS image_pub_16, t0.superficie AS superficie_17, t0.nbr_habitant AS nbr_habitant_18, t0.email_commune AS email_commune_19, t0.tel_commune AS tel_commune_20, t0.fax_commune AS fax_commune_21, t0.url_commune AS url_commune_22, t0.adresse_commune_ar AS adresse_commune_ar_23, t0.adresse_commune_fr AS adresse_commune_fr_24, t0.page_fb AS page_fb_25, t0.nb_sieges_conseil AS nb_sieges_conseil_26, t0.lib_liste_election_ar AS lib_liste_election_ar_27, t0.lib_liste_election_fr AS lib_liste_election_fr_28, t0.id_domaine AS id_domaine_29, t0.gouvernorat_id AS gouvernorat_id_30 FROM commune t0 INNER JOIN projet_commune ON t0.id = projet_commune.commune_id WHERE projet_commune.projet_id = ?
Parameters:
[
58
]
|
|
2.85 ms (8.98%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.description_fr AS description_fr_4, t0.description_ar AS description_ar_5, t0.budget_tnd AS budget_tnd_6, t0.budget_devise AS budget_devise_7, t0.date_debut AS date_debut_8, t0.date_fin AS date_fin_9, t0.partenaire_id_id AS partenaire_id_id_10, t0.devise_id AS devise_id_11 FROM programme t0 INNER JOIN projet_programme ON t0.id = projet_programme.programme_id WHERE projet_programme.projet_id = ?
Parameters:
[
58
]
|
|
2.60 ms (8.21%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.description_fr AS description_fr_3, t0.type AS type_4, t0.etat AS etat_5, t0.projet_id AS projet_id_6 FROM photo t0 WHERE t0.projet_id = ?
Parameters:
[
58
]
|
|
2.40 ms (7.57%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.description_fr AS description_fr_3, t0.type AS type_4, t0.etat AS etat_5, t0.projet_id AS projet_id_6 FROM piece_jointe t0 WHERE t0.projet_id = ?
Parameters:
[
58
]
|
|
2.34 ms (7.39%) |
1 |
SELECT t0.id AS id_1, t0.entity_externe_id AS entity_externe_id_2, t0.projet_id AS projet_id_3 FROM autre_partenaire t0 WHERE t0.projet_id = ?
Parameters:
[
58
]
|
|
2.09 ms (6.59%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.etat AS etat_4, t0.secteur_id AS secteur_id_5 FROM sous_secteur t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
2.05 ms (6.47%) |
1 |
SELECT t0.id AS id_1, t0.entity_externe_id AS entity_externe_id_2, t0.projet_id AS projet_id_3 FROM autre_beneficiare t0 WHERE t0.projet_id = ?
Parameters:
[
58
]
|
|
1.87 ms (5.89%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.etat AS etat_4, t0.domaine_id AS domaine_id_5 FROM sous_domaine t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
1.49 ms (4.71%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.etat AS etat_4 FROM mod_execution t0 WHERE t0.id = ?
Parameters:
[
6
]
|
|
1.43 ms (4.50%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.etat AS etat_4 FROM status t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.61 ms (1.93%) |
1 |
SELECT t0.id AS id_1, t0.nom_fr AS nom_fr_2, t0.nom_ar AS nom_ar_3, t0.prefixe AS prefixe_4, t0.etat AS etat_5 FROM devise t0 WHERE t0.id = ?
Parameters:
[
3
]
|
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\Projet | No errors. |
| App\Entity\Devise | No errors. |
| App\Entity\Status | No errors. |
| App\Entity\ModExecution | No errors. |
| App\Entity\SousSecteur | No errors. |
| App\Entity\SousDomaine | No errors. |
| App\Entity\User | No errors. |
| App\Entity\TypeProjet | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\PieceJointe | No errors. |
| App\Entity\AutrePartenaire | No errors. |
| App\Entity\AutreBeneficiare | No errors. |
| App\Entity\Programme | No errors. |
| App\Entity\EnvIntervention | No errors. |
| App\Entity\Gouvernorat | No errors. |
| App\Entity\Secteur | No errors. |
| App\Entity\Domaine | No errors. |
| App\Entity\Partenaire | No errors. |
| App\Entity\EntityExterne | No errors. |