Query Metrics

6 Database Queries
6 Different statements
6.42 ms Query time
15 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.04 ms
(31.87%)
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.18 ms
(18.34%)
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:
[]
1.16 ms
(18.08%)
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:
[
  "52"
]
1.00 ms
(15.63%)
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.63 ms
(9.79%)
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
]
0.40 ms
(6.30%)
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
]

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
  • The mappings App\Entity\user\Utilisateur#producteurs and App\Entity\prod\Producteur#utilisateur are inconsistent with each other.
  • The mappings App\Entity\user\Utilisateur#inspectionremplis and App\Entity\inspection\InspectionRempli#utilisateur are inconsistent with each other.
  • The mappings App\Entity\user\Utilisateur#fournisseurs and App\Entity\stock\Fournisseur#utilisateur are inconsistent with each other.
  • The association App\Entity\user\Utilisateur#caisse refers to the inverse side field App\Entity\stock\Caisse#utilisateurs which does not exist.
  • The association App\Entity\user\Utilisateur#abonne refers to the inverse side field App\Entity\user\Abonne#utilisateurs which does not exist.
  • The mappings App\Entity\user\Utilisateur#evenements and App\Entity\prod\Evenement#utilisateur are inconsistent with each other.
App\Entity\user\Abonne
  • The association App\Entity\user\Abonne#template refers to the inverse side field App\Entity\cms\Template#abonnes which does not exist.
  • The association App\Entity\user\Abonne#partenaire refers to the inverse side field App\Entity\user\Partenaire#abonnes which does not exist.
  • The association App\Entity\user\Abonne#pays refers to the inverse side field App\Entity\stock\Pays#abonnes which does not exist.
App\Entity\stock\Produit
  • The mappings App\Entity\stock\Produit#melange and App\Entity\stock\Produit#produits are inconsistent with each other.
  • The mappings App\Entity\stock\Produit#produitsysteme and App\Entity\stock\Produit#produits are inconsistent with each other.
  • The association App\Entity\stock\Produit#carateristiqueproduit refers to the inverse side field App\Entity\stock\CarateristiqueProduit#produits which does not exist.
  • The association App\Entity\stock\Produit#abonne refers to the inverse side field App\Entity\user\Abonne#produits which does not exist.
  • The association App\Entity\stock\Produit#infotraitements refers to the owning side field App\Entity\stock\InfoTraitement#produit which does not exist.
App\Entity\stock\InfoLivrer
  • The association App\Entity\stock\InfoLivrer#etapeprocessuses refers to the owning side field App\Entity\stock\EtapeProcessus#infolivrer which does not exist.
  • The association App\Entity\stock\InfoLivrer#variete refers to the inverse side field App\Entity\stock\Produit#infolivrers which does not exist.
  • The association App\Entity\stock\InfoLivrer#commande refers to the inverse side field App\Entity\stock\Commande#infolivrers which does not exist.
  • The association App\Entity\stock\InfoLivrer#surfaceannee refers to the inverse side field App\Entity\prod\SurfaceAnnee#infolivrer which does not exist.
  • The association App\Entity\stock\InfoLivrer#surfaceabonne refers to the inverse side field App\Entity\prod\SurfaceAbonne#lignecommandes which does not exist.
  • The association App\Entity\stock\InfoLivrer#abonne refers to the inverse side field App\Entity\user\Abonne#infolivrers which does not exist.
  • The association App\Entity\stock\InfoLivrer#certification refers to the inverse side field App\Entity\prod\Certification#infolivrers which does not exist.
App\Entity\prod\SurfaceAnneeHistorique
  • The association App\Entity\prod\SurfaceAnneeHistorique#anneecampagne refers to the inverse side field App\Entity\prod\AnneeCampagne#surfaceanneehistoriques which does not exist.
  • The association App\Entity\prod\SurfaceAnneeHistorique#abonne refers to the inverse side field App\Entity\user\Abonne#surfaceanneehistoriques which does not exist.
App\Entity\cms\Menu
  • The association App\Entity\cms\Menu#abonne refers to the inverse side field App\Entity\user\Abonne#menus which does not exist.
  • The association App\Entity\cms\Menu#menu refers to the inverse side field App\Entity\cms\Menu#menus which does not exist.
App\Entity\prod\Groupement
  • The association App\Entity\prod\Groupement#abonne refers to the inverse side field App\Entity\user\Abonne#producteurs which does not exist.
  • The association App\Entity\prod\Groupement#groupement refers to the inverse side field App\Entity\prod\Groupement#producteurs which does not exist.
  • The association App\Entity\prod\Groupement#template refers to the inverse side field App\Entity\cms\Template#producteurs which does not exist.
App\Entity\cms\Template
  • The association App\Entity\cms\Template#abonne refers to the inverse side field App\Entity\user\Abonne#rubriques which does not exist.
App\Entity\cms\Page
  • The association App\Entity\cms\Page#abonne refers to the inverse side field App\Entity\user\Abonne#pages which does not exist.
  • The association App\Entity\cms\Page#groupement refers to the inverse side field App\Entity\prod\Groupement#pages which does not exist.
App\Entity\cms\Zone
  • The association App\Entity\cms\Zone#abonne refers to the inverse side field App\Entity\user\Abonne#zones which does not exist.
App\Entity\cms\Article
  • The association App\Entity\cms\Article#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#articles which does not exist.
  • The association App\Entity\cms\Article#abonne refers to the inverse side field App\Entity\user\Abonne#articles which does not exist.
  • The association App\Entity\cms\Article#groupement refers to the inverse side field App\Entity\prod\Groupement#surfaceannees which does not exist.
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
  • The association App\Entity\cms\Rubrique#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#rubriques which does not exist.
  • The association App\Entity\cms\Rubrique#abonne refers to the inverse side field App\Entity\user\Abonne#rubriques which does not exist.
  • The association App\Entity\cms\Rubrique#produit refers to the inverse side field App\Entity\stock\Produit#rubriques which does not exist.
  • The association App\Entity\cms\Rubrique#produitetapecroissance refers to the inverse side field App\Entity\prod\ProduitEtapeCroissance#rubriques which does not exist.
App\Entity\prod\Producteur
  • The association App\Entity\prod\Producteur#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#producteur which does not exist.
  • The association App\Entity\prod\Producteur#village refers to the inverse side field App\Entity\stock\Village#producteur which does not exist.
  • The association App\Entity\prod\Producteur#abonne refers to the inverse side field App\Entity\user\Abonne#producteurs which does not exist.
  • The association App\Entity\prod\Producteur#agent refers to the inverse side field App\Entity\user\Utilisateur#producteur which does not exist.
App\Entity\cms\Media
  • The mappings App\Entity\cms\Media#TypeMedia and App\Entity\cms\TypeMedia#medias are inconsistent with each other.
  • The association App\Entity\cms\Media#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#medias which does not exist.
  • The association App\Entity\cms\Media#abonne refers to the inverse side field App\Entity\user\Abonne#medias which does not exist.
App\Entity\prod\ProduitEtapeCroissance
  • The association App\Entity\prod\ProduitEtapeCroissance#produit refers to the inverse side field App\Entity\stock\Produit#produitetapecroissances which does not exist.
  • The association App\Entity\prod\ProduitEtapeCroissance#etapecroissance refers to the inverse side field App\Entity\prod\EtapeCroissance#produitetapecroissances which does not exist.
  • The association App\Entity\prod\ProduitEtapeCroissance#produitetapecroissance refers to the inverse side field App\Entity\prod\EtapeCroissance#produitetapecroissances which does not exist.