Query Metrics
6
Database Queries
4
Different statements
4.65 ms
Query time
10
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.24 ms (48.19%) |
3 |
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:
[
99
]
|
|
0.99 ms (21.33%) |
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 37 null 37 ] |
|
0.91 ms (19.67%) |
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:
[
"37"
]
|
|
0.50 ms (10.80%) |
1 |
SELECT t0.id AS id_1, t0.reponse AS reponse_2, t0.date AS date_3, t0.etat AS etat_4, t0.user_id AS user_id_5, t0.sujetforum_id AS sujetforum_id_6, t0.parent_id AS parent_id_7 FROM forum_reponse t0 WHERE t0.parent_id = ?
Parameters:
[
69
]
|
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 |
|
| App\Entity\Particulier |
|
| App\Entity\Partenaire |
|
| App\Entity\Entreprise |
|
| App\Entity\Dae |
|
| App\Entity\ChargeAssistance |
|
| App\Entity\AgentInterne |
|
| App\Entity\Autres |
|
| 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 |
|
| 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 |
|
| App\Entity\Notification | No errors. |
| App\Entity\DemandeService | No errors. |
| App\Entity\ChargeFormation | No errors. |
| App\Entity\RapportEvaluation | No errors. |