https://uropcm.coo.tg/index.html/get/liste/projet/public?public%2Findex.html%2Fget%2Fliste%2Fprojet%2Fpublic=

Query Metrics

5 Database Queries
4 Different statements
4.71 ms Query time
18 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.03 ms
(43.18%)
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.56 ms
(33.08%)
2
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.84 ms
(17.76%)
1
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
]
0.28 ms
(5.98%)
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
  • 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\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\asso\Domaine
  • The association App\Entity\asso\Domaine#projets refers to the owning side field App\Entity\asso\Projet#domaines which does not exist.
  • The association App\Entity\asso\Domaine#abonne refers to the inverse side field App\Entity\user\Abonne#domaines 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\asso\Suivi
  • The mappings App\Entity\asso\Suivi#bailleur and App\Entity\bailleur\Bailleur#suivis are inconsistent with each other.
  • The association App\Entity\asso\Suivi#etatProjet refers to the inverse side field App\Entity\asso\EtatProjet#suivis which does not exist.
App\Entity\asso\Concerne
  • The association App\Entity\asso\Concerne#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#concernes which does not exist.
  • The association App\Entity\asso\Concerne#medias refers to the owning side field App\Entity\cms\Media#concerne which does not exist.
App\Entity\asso\Participer No errors.
App\Entity\asso\Evaluation
  • The association App\Entity\asso\Evaluation#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#Evaluations which does not exist.
  • The association App\Entity\asso\Evaluation#beneficiaire refers to the inverse side field App\Entity\asso\Beneficiaire#Evaluations which does not exist.
  • The association App\Entity\asso\Evaluation#projet refers to the inverse side field App\Entity\asso\Projet#Evaluations which does not exist.
App\Entity\inspection\Inspection
  • The association App\Entity\inspection\Inspection#abonne refers to the inverse side field App\Entity\user\Abonne#inspections which does not exist.
App\Entity\asso\Activite
  • The mappings App\Entity\asso\Activite#activites and App\Entity\asso\Activite#activite are inconsistent with each other.
  • The association App\Entity\asso\Activite#activite refers to the inverse side field App\Entity\asso\Activite#articles which does not exist.
  • The association App\Entity\asso\Activite#projet refers to the inverse side field App\Entity\asso\Projet#articles which does not exist.
  • The association App\Entity\asso\Activite#saison refers to the inverse side field App\Entity\prod\AnneeCampagne#activites which does not exist.
  • The association App\Entity\asso\Activite#evenement refers to the inverse side field App\Entity\prod\Evenement#activites which does not exist.
  • The association App\Entity\asso\Activite#tacheproduitetapecroissance refers to the inverse side field App\Entity\prod\TacheProduitEtapeCroissance#activites which does not exist.
  • The association App\Entity\asso\Activite#producteur refers to the inverse side field App\Entity\prod\Producteur#activites which does not exist.
  • The association App\Entity\asso\Activite#utilisateur refers to the inverse side field App\Entity\user\Utilisateur#activites which does not exist.
  • The association App\Entity\asso\Activite#ville refers to the inverse side field App\Entity\stock\Ville#activites which does not exist.
  • The association App\Entity\asso\Activite#abonne refers to the inverse side field App\Entity\user\Abonne#activites which does not exist.
  • The association App\Entity\asso\Activite#surfaceannee refers to the inverse side field App\Entity\prod\SurfaceAnnee#activites which does not exist.
  • The association App\Entity\asso\Activite#plante refers to the inverse side field App\Entity\prod\Plante#activites which does not exist.