http://cnfcpp1.abshore.com/show/forum/detail/35

Query Metrics

3 Database Queries
3 Different statements
2.33 ms Query time
10 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.97 ms
(41.70%)
1
SELECT t0.id AS id_8, t0.email AS email_9, t0.username AS username_10, t0.password AS password_11, t0.roles AS roles_12, t0.is_verified AS is_verified_13, t0.token_reset AS token_reset_14, t0.is_deleted AS is_deleted_15, t0.type, t1.nom AS nom_16, t1.prenom AS prenom_17, t1.tel AS tel_18, t1.fonction AS fonction_19, t1.autre AS autre_20, t1.fonctions AS fonctions_21, t1.gouvernorat_id AS gouvernorat_id_22, t2.type_partenaire AS type_partenaire_23, t2.nombre_entreprise AS nombre_entreprise_24, t2.cnsscnrps AS cnsscnrps_25, t2.code_cnss AS code_cnss_26, t2.secteur AS secteur_27, t2.branche AS branche_28, t2.fax AS fax_29, t2.tel AS tel_30, t2.nom_prenom_president AS nom_prenom_president_31, t2.nom_prenom_secretaire_general AS nom_prenom_secretaire_general_32, t2.nom_prenom_responsable_uaf AS nom_prenom_responsable_uaf_33, t2.nom AS nom_34, t2.file_name AS file_name_35, t2.original_file_name AS original_file_name_36, t2.gouvernorat_id AS gouvernorat_id_37, t2.delegation_id AS delegation_id_38, t3.matricule_fiscal AS matricule_fiscal_39, t3.nom_commercial AS nom_commercial_40, t3.fax AS fax_41, t3.code_cnss AS code_cnss_42, t3.cnsscnrps AS cnsscnrps_43, t3.secteur AS secteur_44, t3.branche AS branche_45, t3.produits_services_rendus AS produits_services_rendus_46, t3.statut AS statut_47, t3.exportatrice AS exportatrice_48, t3.off_shore AS off_shore_49, t3.taux_tfp AS taux_tfp_50, t3.regime_travail AS regime_travail_51, t3.tel AS tel_52, t3.nom_prenom_premier_responsable AS nom_prenom_premier_responsable_53, t3.raison_sociale AS raison_sociale_54, t3.montant AS montant_55, t3.adresse_siege_social AS adresse_siege_social_56, t3.adresse_site_production AS adresse_site_production_57, t3.gouvernorat_id AS gouvernorat_id_58, t3.delegation_id AS delegation_id_59, t4.tel AS tel_60, t4.nom AS nom_61, t4.prenom AS prenom_62, t4.ministere AS ministere_63, t4.direction AS direction_64, t4.gouvernorat_id AS gouvernorat_id_65, t5.nom AS nom_66, t5.prenom AS prenom_67, t5.tel AS tel_68, t5.unite_regional_id AS unite_regional_id_69, t6.nom AS nom_70, t6.prenom AS prenom_71, t6.tel AS tel_72, t6.nom_administration AS nom_administration_73, t6.regional AS regional_74, t6.unite AS unite_75, t6.fonction AS fonction_76, t7.nom AS nom_77, t7.prenom AS prenom_78, t7.tel AS tel_79, t7.gouvernorat_id AS gouvernorat_id_80 FROM user t0 LEFT JOIN particulier t1 ON t0.id = t1.id LEFT JOIN partenaire t2 ON t0.id = t2.id LEFT JOIN entreprise t3 ON t0.id = t3.id LEFT JOIN dae t4 ON t0.id = t4.id LEFT JOIN charge_assistance t5 ON t0.id = t5.id LEFT JOIN agent_interne t6 ON t0.id = t6.id LEFT JOIN autres t7 ON t0.id = t7.id WHERE t0.id = ?
Parameters:
[
  18
]
0.88 ms
(37.91%)
1
SELECT f0_.id AS id_0, f0_.reponse AS reponse_1, f0_.date AS date_2, f0_.etat AS etat_3, f0_.user_id AS user_id_4, f0_.sujetforum_id AS sujetforum_id_5, f0_.parent_id AS parent_id_6 FROM forum_reponse f0_ WHERE ((f0_.etat = ? AND f0_.sujetforum_id = ? AND f0_.parent_id IS NULL) OR f0_.user_id = ?) AND f0_.sujetforum_id = ? AND f0_.parent_id IS NULL ORDER BY f0_.id DESC LIMIT 1
Parameters:
[
  1
  35
  null
  35
]
0.47 ms
(20.39%)
1
SELECT t0.id AS id_1, t0.sujet AS sujet_2, t0.description AS description_3, t0.is_public AS is_public_4, t0.date AS date_5, t0.date_public AS date_public_6, t0.user_id AS user_id_7 FROM sujetforum t0 WHERE t0.id = ?
Parameters:
[
  "35"
]

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\Sujetforum No errors.
App\Entity\User
  • The field App\Entity\User#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\User#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Particulier
  • The field App\Entity\Particulier#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\Particulier#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Partenaire
  • The field App\Entity\Partenaire#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\Partenaire#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Entreprise
  • The field App\Entity\Entreprise#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\Entreprise#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Dae
  • The field App\Entity\Dae#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\Dae#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\ChargeAssistance
  • The field App\Entity\ChargeAssistance#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\ChargeAssistance#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\AgentInterne
  • The field App\Entity\AgentInterne#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\AgentInterne#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Autres
  • The field App\Entity\Autres#forumResponses is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ForumReponse#user does not contain the required 'inversedBy="forumResponses"' attribute.
  • The field App\Entity\Autres#sujetForums is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Sujetforum#user does not contain the required 'inversedBy="sujetForums"' attribute.
App\Entity\Gouvernorat No errors.
App\Entity\Delegation No errors.
App\Entity\UniteRegional No errors.
App\Entity\GroupePermission No errors.
App\Entity\Adresse No errors.
App\Entity\Commande
  • The association App\Entity\Commande#gouvernorat refers to the inverse side field App\Entity\Gouvernorat#commande which does not exist.
App\Entity\QuizReponse No errors.
App\Entity\Ressources No errors.
App\Entity\DocDemandeService No errors.
App\Entity\InscriptionSessionFormation No errors.
App\Entity\ForumReponse No errors.
App\Entity\UserFicheSatisfaction
  • The mappings App\Entity\UserFicheSatisfaction#demandeAffectation and App\Entity\DemandeAffectation#userFicheSatisfactions are inconsistent with each other.
App\Entity\Notification No errors.
App\Entity\DemandeService No errors.
App\Entity\ChargeFormation No errors.
App\Entity\RapportEvaluation No errors.