Query Metrics
6
Database Queries
6
Different statements
5.57 ms
Query time
15
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.14 ms (38.34%) |
1 |
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"
]
|
1.10 ms (19.80%) |
1 |
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:
[] |
0.80 ms (14.31%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.actif_article AS actif_article_3, t0.titre_image AS titre_image_4, t0.type_article AS type_article_5, t0.datePublication AS datePublication_6, t0.contenuArticle AS contenuArticle_7, t0.resumeArticle AS resumeArticle_8, t0.classHtmlArticle AS classHtmlArticle_9, t0.rubrique_id AS rubrique_id_10, t0.utilisateur_id AS utilisateur_id_11, t0.abonne_id AS abonne_id_12, t0.producteur_id AS producteur_id_13, t0.groupement_id AS groupement_id_14 FROM article t0 WHERE t0.id = ?
Parameters:
[
"53"
]
|
0.72 ms (13.00%) |
1 |
SELECT t0.id AS id_1, t0.designationRubrique AS designationRubrique_2, t0.dateCreationRubrique AS dateCreationRubrique_3, t0.actifRubrique AS actifRubrique_4, t0.typeRubrique AS typeRubrique_5, t0.classHtmlRubrique AS classHtmlRubrique_6, t0.iconeRubrique AS iconeRubrique_7, t0.descriptionRubrique AS descriptionRubrique_8, t0.code_genere_parent AS code_genere_parent_9, t0.utilisateur_id AS utilisateur_id_10, t0.rubrique_id AS rubrique_id_11, t0.abonne_id AS abonne_id_12, t0.produit_id AS produit_id_13, t0.produitetapecroissance_id AS produitetapecroissance_id_14 FROM rubrique t0 WHERE t0.id = ?
Parameters:
[
36
]
|
0.44 ms (7.86%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.actif_article AS actif_article_3, t0.titre_image AS titre_image_4, t0.type_article AS type_article_5, t0.datePublication AS datePublication_6, t0.contenuArticle AS contenuArticle_7, t0.resumeArticle AS resumeArticle_8, t0.classHtmlArticle AS classHtmlArticle_9, t0.rubrique_id AS rubrique_id_10, t0.utilisateur_id AS utilisateur_id_11, t0.abonne_id AS abonne_id_12, t0.producteur_id AS producteur_id_13, t0.groupement_id AS groupement_id_14 FROM article t0 WHERE t0.rubrique_id = ?
Parameters:
[
36
]
|
0.37 ms (6.70%) |
1 |
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
]
|
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\cms\Article |
|
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\cms\Rubrique |
|
App\Entity\prod\Producteur |
|
App\Entity\cms\Media |
|
App\Entity\prod\ProduitEtapeCroissance |
|