Query Metrics
5
Database Queries
4
Different statements
4.71 ms
Query time
18
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 2.03 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code_base_abonne AS code_base_abonne_3, t0.email_abonne AS email_abonne_4, t0.tel1_abonne AS tel1_abonne_5, t0.tel2_abonne AS tel2_abonne_6, t0.adresse_abonne AS adresse_abonne_7, t0.description_abonne AS description_abonne_8, t0.etat_abonne AS etat_abonne_9, t0.siExploitation AS siExploitation_10, t0.si_principale AS si_principale_11, t0.type_action_abonne AS type_action_abonne_12, t0.adresse_web AS adresse_web_13, t0.date_ajout_abonne AS date_ajout_abonne_14, t0.date_edit_abonne AS date_edit_abonne_15, t0.titre_image AS titre_image_16, t0.url_image AS url_image_17, t0.type_presentation AS type_presentation_18, t0.langue AS langue_19, t0.configuration AS configuration_20, t0.type_abonne_id AS type_abonne_id_21, t0.template_id AS template_id_22, t0.partenaire_id AS partenaire_id_23, t0.devise_id AS devise_id_24, t0.pays_id AS pays_id_25 FROM abonne t0 WHERE t0.adresse_web = ? LIMIT 1
Parameters:
[
"uropcm.coo.tg"
]
|
2 | 0.84 ms |
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.actif_projet AS actif_projet_2, p0_.titre_image AS titre_image_3, p0_.type_projet AS type_projet_4, p0_.date_debut AS date_debut_5, p0_.date_fin AS date_fin_6, p0_.budget_projet AS budget_projet_7, p0_.datePublication AS datePublication_8, p0_.contenuProjet AS contenuProjet_9, p0_.couleur_bailleur AS couleur_bailleur_10, p0_.abonne_id AS abonne_id_11, p0_.utilisateur_id AS utilisateur_id_12, p0_.domaine_id AS domaine_id_13 FROM projet p0_ INNER JOIN abonne a1_ ON p0_.abonne_id = a1_.id WHERE p0_.actif_projet <> 2 AND a1_.id = ?
Parameters:
[
22
]
|
3 | 0.83 ms |
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.datePublication AS datePublication_2, m0_.contenuMenu AS contenuMenu_3, m0_.type_menu AS type_menu_4, m0_.etat_menu AS etat_menu_5, m0_.classHtmlMenu AS classHtmlMenu_6, m0_.ordre AS ordre_7, m0_.abonne_id AS abonne_id_8, m0_.menu_id AS menu_id_9 FROM menu m0_ INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id WHERE m0_.etat_menu = 1 AND a1_.id = 22 ORDER BY m0_.ordre ASC
Parameters:
[] |
4 | 0.28 ms |
SELECT t0.id AS id_1, t0.titre_image AS titre_image_2, t0.titre_template AS titre_template_3, t0.nom_dossier_template AS nom_dossier_template_4, t0.description_template AS description_template_5, t0.etat_template AS etat_template_6, t0.date_ajout_template AS date_ajout_template_7, t0.abonne_id AS abonne_id_8 FROM template t0 WHERE t0.id = ?
Parameters:
[
2
]
|
5 | 0.73 ms |
SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.datePublication AS datePublication_2, m0_.contenuMenu AS contenuMenu_3, m0_.type_menu AS type_menu_4, m0_.etat_menu AS etat_menu_5, m0_.classHtmlMenu AS classHtmlMenu_6, m0_.ordre AS ordre_7, m0_.abonne_id AS abonne_id_8, m0_.menu_id AS menu_id_9 FROM menu m0_ INNER JOIN abonne a1_ ON m0_.abonne_id = a1_.id WHERE m0_.etat_menu = 1 AND a1_.id = 22 ORDER BY m0_.ordre ASC
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\param\Param | No errors. |
App\Entity\user\Utilisateur |
|
App\Entity\user\Abonne |
|
App\Entity\stock\Produit |
|
App\Entity\stock\InfoLivrer |
|
App\Entity\prod\SurfaceAnneeHistorique |
|
App\Entity\cms\Menu |
|
App\Entity\prod\Groupement |
|
App\Entity\cms\Template |
|
App\Entity\cms\Page |
|
App\Entity\cms\Zone |
|
App\Entity\asso\Projet |
|
App\Entity\user\TypeAbonne | No errors. |
App\Entity\user\Partenaire | No errors. |
App\Entity\stock\Devise | No errors. |
App\Entity\stock\Pays | No errors. |
App\Entity\asso\Domaine |
|
App\Entity\cms\Media |
|
App\Entity\asso\Suivi |
|
App\Entity\asso\Concerne |
|
App\Entity\asso\Participer | No errors. |
App\Entity\asso\Evaluation |
|
App\Entity\inspection\Inspection |
|
App\Entity\asso\Activite |
|