https://www.pre.coo.tg/?rest_route=%2Fwp%2Fv2%2Fusers%2F

Query Metrics

4 Database Queries
4 Different statements
4.07 ms Query time
17 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.50 ms
(61.35%)
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:
[
  "www.pre.coo.tg"
]
0.99 ms
(24.25%)
1
SELECT t0.id AS id_1, t0.nom_groupement AS nom_groupement_2, t0.url_image AS url_image_3, t0.titre_image AS titre_image_4, t0.etat_groupement AS etat_groupement_5, t0.date_publication AS date_publication_6, t0.type_groupement AS type_groupement_7, t0.annee_creation AS annee_creation_8, t0.adresse_web AS adresse_web_9, t0.adresse_abonne AS adresse_abonne_10, t0.description_abonne AS description_abonne_11, t0.tel1_abonne AS tel1_abonne_12, t0.code_genere AS code_genere_13, t0.ville_id AS ville_id_14, t0.abonne_id AS abonne_id_15, t0.groupement_id AS groupement_id_16, t0.template_id AS template_id_17 FROM groupement t0 WHERE t0.adresse_web = ? LIMIT 1
Parameters:
[
  "www.pre.coo.tg"
]
0.32 ms
(7.83%)
1
SELECT t0.id AS id_1, t0.titre_image AS titre_image_2, t0.titre_page AS titre_page_3, t0.twig_page AS twig_page_4, t0.description_page AS description_page_5, t0.etat_page AS etat_page_6, t0.type_page AS type_page_7, t0.si_page_accueil AS si_page_accueil_8, t0.date_ajout_page AS date_ajout_page_9, t0.template_id AS template_id_10, t0.abonne_id AS abonne_id_11, t0.groupement_id AS groupement_id_12 FROM page t0 WHERE t0.template_id IS NULL AND t0.abonne_id IS NULL AND t0.si_page_accueil = ? LIMIT 1
Parameters:
[
  1
]
0.27 ms
(6.58%)
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:
[
  20
]

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\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\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\stock\CategorieProduit
  • The association App\Entity\stock\CategorieProduit#abonne refers to the inverse side field App\Entity\user\Abonne#categories which does not exist.
  • The association App\Entity\stock\CategorieProduit#categorieproduit refers to the inverse side field App\Entity\stock\CategorieProduit#categories which does not exist.
  • The association App\Entity\stock\CategorieProduit#typeAbonne refers to the inverse side field App\Entity\user\TypeAbonne#categories 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\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\SurfaceAnnee
  • The association App\Entity\prod\SurfaceAnnee#surfaceannee refers to the inverse side field App\Entity\prod\SurfaceAnnee#surfaceannees which does not exist.
  • The association App\Entity\prod\SurfaceAnnee#abonne refers to the inverse side field App\Entity\user\Abonne#surfaceannees which does not exist.
  • The mappings App\Entity\prod\SurfaceAnnee#infolivrers and App\Entity\stock\InfoLivrer#surfaceannee are inconsistent with each other.
App\Entity\asso\Projet
  • The association App\Entity\asso\Projet#abonne refers to the inverse side field App\Entity\user\Abonne#projets which does not exist.
  • The association App\Entity\asso\Projet#medias refers to the owning side field App\Entity\cms\Media#projet which does not exist.
  • The association App\Entity\asso\Projet#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#projets which does not exist.
  • The mappings App\Entity\asso\Projet#evaluations and App\Entity\asso\Evaluation#projet are inconsistent with each other.
  • The association App\Entity\asso\Projet#inspections refers to the owning side field App\Entity\inspection\Inspection#projet which does not exist.
  • The mappings App\Entity\asso\Projet#domaine and App\Entity\asso\Domaine#projets are inconsistent with each other.
  • The mappings App\Entity\asso\Projet#activites and App\Entity\asso\Activite#projet are inconsistent with each other.
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\stock\Ville
  • The mappings App\Entity\stock\Ville#zoneabonnes and App\Entity\stock\ZoneAbonne#ville are inconsistent with each other.
  • The mappings App\Entity\stock\Ville#fichier and App\Entity\stock\Fichier#ville are inconsistent with each other.