http://astem.projets-la-sentinelle.fr/info.php

Query Metrics

14 Database Queries
9 Different statements
6.75 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.36 ms
(34.88%)
5
SELECT o0_.id AS id_0, o1_.name AS name_1 FROM oci_intervention_module o0_ LEFT JOIN oci_intervention_module_translation o1_ ON o0_.id = o1_.translatable_id WHERE o0_.workflow_configuration_name = ?
Parameters:
[
  "dental_common_workflow"
]
0.96 ms
(14.24%)
1
SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_kn3d_intervention_transfer_deadline t0 LIMIT 1
Parameters:
[]
0.94 ms
(13.96%)
2
SELECT t0.id AS id_1, t0.primary_color AS primary_color_2, t0.secondary_color AS secondary_color_3, t0.text_color_btn AS text_color_btn_4, t0.text_color_title AS text_color_title_5, t0.primary_color_report AS primary_color_report_6, t0.text_color_report AS text_color_report_7, t0.production_labels_color AS production_labels_color_8, t0.production_labels_text_color AS production_labels_text_color_9, t0.kn3d_primary_color AS kn3d_primary_color_10, t0.kn3d_primary_text_color AS kn3d_primary_text_color_11, t0.kn3d_secondary_color AS kn3d_secondary_color_12, t0.kn3d_secondary_text_color AS kn3d_secondary_text_color_13, t0.kn3d_tertiary_color AS kn3d_tertiary_color_14, t0.kn3d_tertiary_text_color AS kn3d_tertiary_text_color_15 FROM app_theme t0 LIMIT 1
Parameters:
[]
0.50 ms
(7.34%)
1
SELECT o0_.name AS name_0, o0_.hostname AS hostname_1 FROM oo_users_company o0_ WHERE o0_.activated = 1
Parameters:
[]
0.42 ms
(6.26%)
1
SELECT count(o0_.id) AS sclr_0 FROM oo_users_company o0_ WHERE o0_.activated = 1
Parameters:
[]
0.41 ms
(6.11%)
1
SELECT o0_.id AS id_0, o0_.name AS name_1, o0_.address AS address_2, o0_.country_code AS country_code_3, o0_.hostname AS hostname_4, o0_.activated AS activated_5, o0_.pre_planning_validation_activated AS pre_planning_validation_activated_6, o0_.rights AS rights_7, o0_.country_id AS country_id_8 FROM oo_users_company o0_ WHERE o0_.activated = 1 LIMIT 1
Parameters:
[]
0.40 ms
(5.95%)
1
SELECT t0.id AS id_1, t0.code AS code_2 FROM oo_users_locale t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  ""
]
0.39 ms
(5.80%)
1
SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_hi3d_intervention_transfer_deadline t0 LIMIT 1
Parameters:
[]
0.37 ms
(5.45%)
1
SELECT t0.id AS id_1, t0.days_gap AS days_gap_2 FROM oci_sh3d_intervention_transfer_deadline t0 LIMIT 1
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
OneOrtho\Module3DKneeBundle\Entity\Settings\TransferDeadline No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\TransferDeadline No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\TransferDeadline No errors.
OneOrtho\UserBundle\RegionalSettings\Entity\Locale No errors.
OneOrtho\UserBundle\Api\Entity\ApiUser No errors.
OneOrtho\UserBundle\Company\Entity\Company No errors.
OneOrtho\UserBundle\Eula\Entity\Eula No errors.
OneOrtho\UserBundle\Establishment\Entity\Address No errors.
OneOrtho\UserBundle\Establishment\Entity\Establishment No errors.
OneOrtho\UserBundle\Mailer\Entity\Broadcast No errors.
OneOrtho\UserBundle\Mailer\Entity\Email No errors.
OneOrtho\UserBundle\Mailer\Entity\Mail No errors.
OneOrtho\UserBundle\Mailer\Entity\MailSignature No errors.
OneOrtho\UserBundle\Translation\Entity\AbstractTranslation No errors.
OneOrtho\UserBundle\Mailer\Entity\MailTranslation No errors.
OneOrtho\UserBundle\Module\Entity\Link No errors.
OneOrtho\UserBundle\Module\Entity\Module No errors.
OneOrtho\UserBundle\Module\Entity\ModuleTranslation No errors.
OneOrtho\UserBundle\News\Entity\News No errors.
OneOrtho\UserBundle\PasswordPolicy\Entity\RoleUserPasswordPolicy No errors.
OneOrtho\UserBundle\RegionalSettings\Entity\Country No errors.
OneOrtho\UserBundle\RegionalSettings\Entity\Currency No errors.
OneOrtho\UserBundle\Security\Entity\Settings No errors.
OneOrtho\UserBundle\Translation\Entity\Translation No errors.
OneOrtho\UserBundle\UserManagement\Entity\User No errors.
OneOrtho\UserBundle\UserManagement\Entity\Invitation No errors.
OneOrtho\UserBundle\UserManagement\Entity\UserData No errors.
OneOrtho\UserBundle\UserManagement\Entity\UserPasswordHistory No errors.
OneOrtho\UserBundle\UserManagement\Entity\UserRecoveryCode No errors.
OneOrtho\UserBundle\UserManagement\Entity\UserSessionInformations No errors.
OneOrtho\UserBundle\UserNotif\Entity\UserNotif No errors.
App\Entity\ArtificialIntelligence\Execution No errors.
App\Entity\Documentation No errors.
App\Entity\Image No errors.
OneOrtho\KneeWorkflowBundle\Entity\Intervention\Intervention No errors.
App\Entity\Knee\Intervention\Intervention No errors.
App\Entity\Preferences No errors.
App\Entity\Theme No errors.
App\Entity\User\Address No errors.
App\Entity\User\Establishment No errors.
App\Entity\User\User
  • The field App\Entity\User\User#userInterventionModulePreferences is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity OneOrtho\CommonInterventionBundle\Entity\UserInterventionModulePreference#user does not contain the required 'inversedBy="userInterventionModulePreferences"' attribute.
Astem\Entity\AstemPatientProfile No errors.
Astem\Entity\AstemUserProfile No errors.
OneOrtho\InterventionFeedBundle\Entity\InterventionComment No errors.
OneOrtho\InterventionFeedBundle\Entity\InterventionFile No errors.
OneOrtho\KneeWorkflowBundle\Entity\Intervention\Deadline No errors.
OneOrtho\KneeWorkflowBundle\Entity\Intervention\Document No errors.
OneOrtho\KneeWorkflowBundle\Entity\Patient\Patient No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\EntryData No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\EntryDataFile No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\EntryDataFiles\Dicom No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\EntryDataFiles\OtherFile No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\EntryDataFiles\Radio No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\KneePreferences No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\MailReminder No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\Planning No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PlanningDataModel No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PlanningData No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PlanningUpload No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PostPlanningData No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\Preplanning No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PreplanningData No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PreplanningUpload No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\PSI No errors.
OneOrtho\KneeWorkflowBundle\Entity\Workflow\Workflow No errors.
OneOrtho\CommonInterventionBundle\Entity\CompanyInterventionModulePreference No errors.
OneOrtho\CommonInterventionBundle\Entity\Intervention No errors.
OneOrtho\CommonInterventionBundle\Entity\InterventionModule No errors.
OneOrtho\CommonInterventionBundle\Entity\InterventionModuleTranslation No errors.
OneOrtho\CommonInterventionBundle\Entity\ModuleJs No errors.
OneOrtho\CommonInterventionBundle\Entity\Patient No errors.
OneOrtho\CommonInterventionBundle\Entity\UserInterventionModulePreference No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\Deadline No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\Document No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\Kit No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\KitTranslation No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\MailReminder No errors.
OneOrtho\Module3DKneeBundle\Entity\Settings\PSI
  • The field 'OneOrtho\Module3DKneeBundle\Entity\Settings\PSI#bladeThickness' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'OneOrtho\Module3DKneeBundle\Entity\Settings\PSI#pinDiameter' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
OneOrtho\Module3DKneeBundle\Entity\Settings\PSITranslation No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\Deadline No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\Document No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\Kit No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\KitTranslation No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\MailReminder No errors.
OneOrtho\Module3DHipBundle\Entity\Settings\PSI
  • The field 'OneOrtho\Module3DHipBundle\Entity\Settings\PSI#bladeThickness' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'OneOrtho\Module3DHipBundle\Entity\Settings\PSI#pinDiameter' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
OneOrtho\Module3DHipBundle\Entity\Settings\PSITranslation No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Collar No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Implant No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Cup No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Range No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\CupRange No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\ImplantSize No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\CupSize No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\ImplantTranslation No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\CupTranslation No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Head No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\HeadSize No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\HeadTranslation No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Liner No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\LinerTranslation No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Neck No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\Stem No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\StemCollar No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\StemRange No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\StemRangeHead No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\StemSize No errors.
OneOrtho\Module2DHipBundle\Entity\Implants\StemTranslation No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\Deadline No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\Document No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\Kit No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\KitTranslation No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\MailReminder No errors.
OneOrtho\Module3DShoulderBundle\Entity\Settings\PSI
  • The field 'OneOrtho\Module3DShoulderBundle\Entity\Settings\PSI#bladeThickness' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'OneOrtho\Module3DShoulderBundle\Entity\Settings\PSI#pinDiameter' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
OneOrtho\Module3DShoulderBundle\Entity\Settings\PSITranslation No errors.
Vich\UploaderBundle\Entity\File No errors.