Query Metrics
10
Database Queries
9
Different statements
450.71 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
437.69 ms (97.11%) |
1 |
SELECT t0.id AS id_1, t0.date_actus AS date_actus_2, t0.image AS image_3, t0.date_creation AS date_creation_4, t0.date_modif AS date_modif_5, t0.desc_courte AS desc_courte_6, t0.desc_long AS desc_long_7, t0.html_content AS html_content_8, t0.is_actived AS is_actived_9, t0.libelle AS libelle_10, t0.user_edit_id AS user_edit_id_11 FROM actualites t0 WHERE t0.is_actived = ? ORDER BY t0.date_creation DESC
Parameters:
[
1
]
|
|
8.75 ms (1.94%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.date_debut AS date_debut_3, t0.date_fin AS date_fin_4, t0.libelle AS libelle_5, t0.adresse AS adresse_6, t0.desc_long AS desc_long_7, t0.tel1 AS tel1_8, t0.tel2 AS tel2_9, t0.date_creation AS date_creation_10, t0.date_modification AS date_modification_11, t0.is_actived AS is_actived_12, t0.image AS image_13, t0.adr AS adr_14 FROM urgence t0 WHERE t0.is_actived = ? ORDER BY t0.date_creation DESC
Parameters:
[
1
]
|
|
1.92 ms (0.43%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.libelle AS libelle_3, t0.image AS image_4, t0.desc_courte AS desc_courte_5, t0.desc_long AS desc_long_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.is_actived AS is_actived_9 FROM apropos t0 WHERE t0.is_actived = ?
Parameters:
[
1
]
|
|
0.56 ms (0.12%) |
2 |
SELECT t0.id AS id_1, t0.raison_social AS raison_social_2, t0.denomination AS denomination_3, t0.slogan AS slogan_4, t0.logo AS logo_5, t0.adresse AS adresse_6, t0.code_postal AS code_postal_7, t0.ville AS ville_8, t0.desc_courte AS desc_courte_9, t0.desc_long AS desc_long_10, t0.nif AS nif_11, t0.stat AS stat_12, t0.tel_fixe AS tel_fixe_13, t0.mobile1 AS mobile1_14, t0.mobile2 AS mobile2_15, t0.email AS email_16, t0.date_creation AS date_creation_17, t0.date_modif AS date_modif_18, t0.is_actived AS is_actived_19, t0.numero_commande AS numero_commande_20, t0.user_modif_id AS user_modif_id_21 FROM societe t0 WHERE t0.is_actived = ? LIMIT 1
Parameters:
[
1
]
|
|
0.43 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.libelle AS libelle_3, t0.image AS image_4, t0.desc_courte AS desc_courte_5, t0.desc_long AS desc_long_6, t0.date_creation AS date_creation_7, t0.date_modification AS date_modification_8, t0.is_actived AS is_actived_9, t0.user_modif_id AS user_modif_id_10 FROM metier t0 WHERE t0.is_actived = ?
Parameters:
[
1
]
|
|
0.42 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.img AS img_2, t0.is_actived AS is_actived_3, t0.libelle AS libelle_4, t0.site_web AS site_web_5, t0.description_courte AS description_courte_6, t0.ordre_affichage AS ordre_affichage_7 FROM partenaire t0 WHERE t0.is_actived = ? ORDER BY t0.ordre_affichage ASC
Parameters:
[
1
]
|
|
0.41 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.photo AS photo_3, t0.mot_du_jour AS mot_du_jour_4, t0.date_creation AS date_creation_5, t0.is_actived AS is_actived_6, t0.date_modif AS date_modif_7 FROM equipe t0 WHERE t0.is_actived = ?
Parameters:
[
1
]
|
|
0.36 ms (0.08%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom_contact AS nom_contact_3, t0.mobile1 AS mobile1_4, t0.mobile2 AS mobile2_5, t0.email AS email_6, t0.date_creation AS date_creation_7, t0.date_modif AS date_modif_8, t0.is_actived AS is_actived_9, t0.user_modif_id AS user_modif_id_10, t0.societe_id AS societe_id_11 FROM contact t0 WHERE t0.societe_id = ? AND t0.is_actived = ? ORDER BY t0.date_creation DESC
Parameters:
[ 1 1 ] |
|
0.17 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.libelle AS libelle_2, t0.nom_contact AS nom_contact_3, t0.mobile1 AS mobile1_4, t0.mobile2 AS mobile2_5, t0.email AS email_6, t0.date_creation AS date_creation_7, t0.date_modif AS date_modif_8, t0.is_actived AS is_actived_9, t0.user_modif_id AS user_modif_id_10, t0.societe_id AS societe_id_11 FROM contact t0 WHERE t0.societe_id = ? AND t0.is_actived = ? ORDER BY t0.date_creation ASC
Parameters:
[ 1 1 ] |
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\Apropos | No errors. |
| App\Entity\Metier | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Urgence | No errors. |
| App\Entity\Actualites | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Partenaire | No errors. |