https://uropcm.coo.tg/index.html/page/cart/info?public%2Findex.html%2Fpage%2Fcart%2Finfo=

Query Metrics

4 Database Queries
4 Different statements
4.44 ms Query time
10 Invalid entities

Queries

Group similar statements

# Time Info
1 2.40 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.68 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.id = ?
Parameters:
[
  62
]
3 0.93 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 = 62 ORDER BY m0_.ordre ASC
Parameters:
[]
4 0.42 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:
[
  3
]

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\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\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.
App\Entity\client\Client
  • The association App\Entity\client\Client#ville refers to the inverse side field App\Entity\stock\Ville#clients which does not exist.
  • The association App\Entity\client\Client#abonne refers to the inverse side field App\Entity\user\Abonne#clients which does not exist.
  • The association App\Entity\client\Client#caisse refers to the inverse side field App\Entity\stock\Caisse#clients which does not exist.
App\Entity\stock\PrixRigueur
  • The association App\Entity\stock\PrixRigueur#prixzones refers to the owning side field App\Entity\stock\PrixRigueur#prixrigueur which does not exist.
  • The association App\Entity\stock\PrixRigueur#abonne refers to the inverse side field App\Entity\user\Abonne#prixrigueurs which does not exist.
App\Entity\stock\LigneCommande
  • The mappings App\Entity\stock\LigneCommande#variete and App\Entity\stock\Produit#lignecommandes are inconsistent with each other.
  • The association App\Entity\stock\LigneCommande#abonne refers to the inverse side field App\Entity\user\Abonne#lignecommandes which does not exist.
App\Entity\client\EtatClient No errors.
App\Entity\user\TypeAbonne No errors.
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\user\Partenaire No errors.
App\Entity\stock\Devise No errors.
App\Entity\stock\Pays No errors.
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.