Query Metrics
2
Database Queries
2
Different statements
1.36 ms
Query time
10
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.87 ms (64.17%) |
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.49 ms (35.83%) |
1 |
SELECT t0.id AS id_1, t0.categorie AS categorie_2, t0.titre AS titre_3, t0.auteur AS auteur_4, t0.description AS description_5, t0.is_public AS is_public_6, t0.date_debut AS date_debut_7, t0.date_expiration AS date_expiration_8, t0.image AS image_9, t0.ressource AS ressource_10, t0.status AS status_11, t0.user_id AS user_id_12 FROM ressources t0 WHERE t0.id = ?
Parameters:
[
"63"
]
|
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\Ressources | 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\DocDemandeService | No errors. |
| App\Entity\InscriptionSessionFormation | No errors. |
| App\Entity\ForumReponse | No errors. |
| App\Entity\Sujetforum | 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. |