https://isor.persol-online.com/eval/job/saveCrticite Return to referer URL

Query Metrics

12 Database Queries
12 Different statements
3.87 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.77 ms
(45.72%)
1
"COMMIT"
Parameters:
[]
0.31 ms
(7.99%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.fonction AS fonction_7, t0.tel AS tel_8, t0.mobile AS mobile_9, t0.fax AS fax_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.modules AS modules_13, t0.photo AS photo_14, t0.gender AS gender_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.upper_hierarchy_id AS upper_hierarchy_id_18, t0.entity_id AS entity_id_19, t0.entite_attache AS entite_attache_20 FROM user t0 WHERE t0.id = ?
Parameters:
[
  35
]
0.26 ms
(6.60%)
1
SELECT t0.id AS id_1, t0.ref AS ref_2, t0.title AS title_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.type AS type_6, t0.description AS description_7, t0.finality AS finality_8, t0.is_outsourced AS is_outsourced_9, t0.external_company AS external_company_10, t0.contact_person AS contact_person_11, t0.pilote AS pilote_12, t0.created_by AS created_by_13, t0.updated_by AS updated_by_14, t0.comment_dashboard_id AS comment_dashboard_id_15 FROM processus t0 INNER JOIN user_processus ON t0.id = user_processus.processus_id WHERE user_processus.user_id = ?
Parameters:
[
  35
]
0.25 ms
(6.41%)
1
UPDATE situation_risque SET mog_id = ? WHERE id = ?
Parameters:
[
  2
  600
]
0.22 ms
(5.74%)
1
SELECT t0.id AS id_1, t0.commentaire AS commentaire_2, t0.comment_cr AS comment_cr_3, t0.comment_rr AS comment_rr_4, t0.risque_id AS risque_id_5, t0.frequence_id AS frequence_id_6, t0.gravite_id AS gravite_id_7, t0.situation_id AS situation_id_8, t9.id AS id_10, t9.title AS title_11, t9.created_at AS created_at_12, t9.updated_at AS updated_at_13, t9.created_by AS created_by_14, t9.updated_by AS updated_by_15, t9.task_id AS task_id_16, t0.mop_id AS mop_id_17, t0.mog_id AS mog_id_18, t0.action_id AS action_id_19, t0.company_entity_id AS company_entity_id_20 FROM situation_risque t0 LEFT JOIN situation t9 ON t0.situation_id = t9.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  "600"
]
0.21 ms
(5.46%)
1
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.adresse AS adresse_3, t0.complements AS complements_4, t0.ville AS ville_5, t0.code_postal AS code_postal_6, t0.pays AS pays_7, t0.telephone AS telephone_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM company_entity t0 WHERE t0.id = ?
Parameters:
[
  "3"
]
0.19 ms
(4.78%)
1
SELECT t0.id AS id_1, t0.legende AS legende_2, t0.operation AS operation_3, t0.valeur AS valeur_4, t0.couleur AS couleur_5, t0.type AS type_6 FROM criticite t0 WHERE t0.type = ? ORDER BY t0.valeur ASC
Parameters:
[
  "prevention"
]
0.18 ms
(4.70%)
1
SELECT t0.id AS id_1, t0.note AS note_2, t0.statut AS statut_3, t0.description AS description_4 FROM frequence t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.15 ms
(4.01%)
1
SELECT t0.id AS id_1, t0.note AS note_2, t0.statut AS statut_3, t0.description AS description_4 FROM mog t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  "2"
]
0.15 ms
(3.85%)
1
SELECT t0.id AS id_1, t0.note AS note_2, t0.statut AS statut_3, t0.description AS description_4 FROM gravite t0 WHERE t0.id = ?
Parameters:
[
  9
]
0.10 ms
(2.61%)
1
SET @row_number = 0
Parameters:
[]
0.08 ms
(2.12%)
1
"START TRANSACTION"
Parameters:
[]

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\User No errors.
App\Entity\Configuration\CompanyEntity No errors.
App\Entity\Group No errors.
App\Entity\ReunionAvis No errors.
App\Entity\Processus No errors.
App\Entity\Comments No errors.
App\Entity\Action No errors.
App\Entity\Data No errors.
App\Entity\Indicator No errors.
App\Entity\Reunion No errors.
App\Entity\ConformityText No errors.
App\Entity\bilan\Job No errors.
App\Entity\Configuration\Autorisation No errors.
App\Entity\bilan\Gravite No errors.
App\Entity\bilan\Frequence No errors.
App\Entity\bilan\MOP No errors.
App\Entity\bilan\MOG No errors.
App\Entity\bilan\Task No errors.
App\Entity\bilan\SituationRisque No errors.
App\Entity\bilan\Risque No errors.
App\Entity\bilan\Situation No errors.
App\Entity\bilan\Criticite No errors.
App\Entity\ActionPlan No errors.
App\Entity\ConformityArticle No errors.
App\Entity\Source No errors.
App\Entity\Type No errors.
App\Entity\ReunionSubject No errors.
App\Entity\Subject No errors.
App\Entity\ReunionTitle No errors.
App\Entity\Periodicity No errors.
App\Entity\Dysfonctionnement\Constat No errors.
App\Entity\bilan\Entity No errors.
App\Entity\Domain No errors.
App\Entity\Dysfonctionnement\CategoryConstat No errors.
App\Entity\Activity
  • The field App\Entity\Activity#indicators is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Indicator#activity does not contain the required 'inversedBy="indicators"' attribute.
  • The field App\Entity\Activity#datas is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Data#activity does not contain the required 'inversedBy="datas"' attribute.
App\Entity\bilan\Mission No errors.
App\Entity\bilan\Zone No errors.
App\Entity\bilan\Location No errors.