Query Metrics
7
Database Queries
6
Different statements
2.48 ms
Query time
0
Invalid entities
91
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.38 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_hmac AS email_hmac_3, t0.phone AS phone_4, t0.roles AS roles_5, t0.functional_roles AS functional_roles_6, t0.password AS password_7, t0.password_history AS password_history_8, t0.password_changed_at AS password_changed_at_9, t0.firstname AS firstname_10, t0.name AS name_11, t0.username AS username_12, t0.stopdate AS stopdate_13, t0.lastlogin AS lastlogin_14, t0.access_token AS access_token_15, t0.access_token_hmac AS access_token_hmac_16, t0.token_expires_at AS token_expires_at_17, t0.is_emergency_account AS is_emergency_account_18, t0.totp_secret AS totp_secret_19, t0.is_mfa_enabled AS is_mfa_enabled_20, t0.allowed_ips AS allowed_ips_21, t0.trusted_token_version AS trusted_token_version_22, t0.failed_login_attempts AS failed_login_attempts_23, t0.locked_until AS locked_until_24, t0.mobile_session_token_hash AS mobile_session_token_hash_25, t0.mobile_session_last_activity AS mobile_session_last_activity_26, t0.mobile_session_created_at AS mobile_session_created_at_27, t0.mobile_session_trusted_version AS mobile_session_trusted_version_28, t0.mobile_session_password_changed_at AS mobile_session_password_changed_at_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.created_by_account_id AS created_by_account_id_32, t0.updated_by_account_id AS updated_by_account_id_33, t0.created_by_user_id AS created_by_user_id_34, t0.updated_by_user_id AS updated_by_user_id_35, t0.linked_user_id AS linked_user_id_36 FROM account t0 WHERE t0.id = ?
Parameters:
[
26
]
|
| 2 | 0.38 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_hmac AS email_hmac_3, t0.phone AS phone_4, t0.roles AS roles_5, t0.functional_roles AS functional_roles_6, t0.password AS password_7, t0.password_history AS password_history_8, t0.password_changed_at AS password_changed_at_9, t0.firstname AS firstname_10, t0.name AS name_11, t0.username AS username_12, t0.stopdate AS stopdate_13, t0.lastlogin AS lastlogin_14, t0.access_token AS access_token_15, t0.access_token_hmac AS access_token_hmac_16, t0.token_expires_at AS token_expires_at_17, t0.is_emergency_account AS is_emergency_account_18, t0.totp_secret AS totp_secret_19, t0.is_mfa_enabled AS is_mfa_enabled_20, t0.allowed_ips AS allowed_ips_21, t0.trusted_token_version AS trusted_token_version_22, t0.failed_login_attempts AS failed_login_attempts_23, t0.locked_until AS locked_until_24, t0.mobile_session_token_hash AS mobile_session_token_hash_25, t0.mobile_session_last_activity AS mobile_session_last_activity_26, t0.mobile_session_created_at AS mobile_session_created_at_27, t0.mobile_session_trusted_version AS mobile_session_trusted_version_28, t0.mobile_session_password_changed_at AS mobile_session_password_changed_at_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.created_by_account_id AS created_by_account_id_32, t0.updated_by_account_id AS updated_by_account_id_33, t0.created_by_user_id AS created_by_user_id_34, t0.updated_by_user_id AS updated_by_user_id_35, t0.linked_user_id AS linked_user_id_36 FROM account t0 WHERE t0.id = ?
Parameters:
[
3
]
|
| 3 | 0.41 ms |
SELECT t0.id AS id_1, t0.id_ext AS id_ext_2, t0.name AS name_3, t0.city AS city_4, t0.address AS address_5, t0.zipCode AS zipCode_6, t0.zipcode_hmac AS zipcode_hmac_7, t0.owner AS owner_8, t0.isWithFtpSupport AS isWithFtpSupport_9, t0.ftpPassword AS ftpPassword_10, t0.netsoinsServer AS netsoinsServer_11, t0.netsoinsApiKey AS netsoinsApiKey_12, t0.netsoinsKeyRequiresQueryParam AS netsoinsKeyRequiresQueryParam_13, t0.netsoins_apikey_issued_at AS netsoins_apikey_issued_at_14, t0.isNetsoinsWithSubSectors AS isNetsoinsWithSubSectors_15, t0.netsoinsFilterOption AS netsoinsFilterOption_16, t0.netsoinsNbWeek AS netsoinsNbWeek_17, t0.nb_lit AS nb_lit_18, t0.ogirysApiKey AS ogirysApiKey_19, t0.ftp_password_hash AS ftp_password_hash_20, t0.ftp_password_hash_previous AS ftp_password_hash_previous_21, t0.ftp_password_previous_expires_at AS ftp_password_previous_expires_at_22, t0.ftp_password_issued_at AS ftp_password_issued_at_23, t0.netsoins_apikey_hmac AS netsoins_apikey_hmac_24, t0.ogirys_apikey_hmac AS ogirys_apikey_hmac_25, t0.ogirysapikey_issued_at AS ogirysapikey_issued_at_26, t0.language AS language_27, t0.isBddUnique AS isBddUnique_28, t0.isRoomDispatched AS isRoomDispatched_29, t0.isPhotoPatientOnSticker AS isPhotoPatientOnSticker_30, t0.isDataCodeOnSticker AS isDataCodeOnSticker_31, t0.printOptionPillBox AS printOptionPillBox_32, t0.distributionOptionPillbox AS distributionOptionPillbox_33, t0.stopDate AS stopDate_34, t0.comment AS comment_35, t0.lastFPEServerDate AS lastFPEServerDate_36, t0.phone AS phone_37, t0.teamviewer AS teamviewer_38, t0.data_sending_mode AS data_sending_mode_39, t0.petit_module_login AS petit_module_login_40, t0.netsoins_feedbacks AS netsoins_feedbacks_41, t0.sort_patient_by AS sort_patient_by_42, t0.is_upside_down_sticker AS is_upside_down_sticker_43, t0.is_one_compartment_fitall AS is_one_compartment_fitall_44, t0.color_display_format AS color_display_format_45, t0.is_one_drug_type_by_compartiment AS is_one_drug_type_by_compartiment_46, t0.overflow_naming_preset AS overflow_naming_preset_47, t0.overflow_naming_style AS overflow_naming_style_48, t0.is_default_pl_long_term AS is_default_pl_long_term_49, t0.is_with_trace AS is_with_trace_50, t0.is_without_if_needed AS is_without_if_needed_51, t0.is_without_hp AS is_without_hp_52, t0.is_with_auto_fill_photo AS is_with_auto_fill_photo_53, t0.is_demo_purpose AS is_demo_purpose_54, t0.last_tls_version AS last_tls_version_55, t0.last_tls_checked_at AS last_tls_checked_at_56, t0.ssh_public_key AS ssh_public_key_57, t0.ssh_public_key_issued_at AS ssh_public_key_issued_at_58, t0.contact_email AS contact_email_59, t0.contact_email_hmac AS contact_email_hmac_60, t0.color_days AS color_days_61, t0.color_days_print_mode AS color_days_print_mode_62, t0.created_at AS created_at_63, t0.updated_at AS updated_at_64, t0.created_by_account_id AS created_by_account_id_65, t0.updated_by_account_id AS updated_by_account_id_66, t0.created_by_user_id AS created_by_user_id_67, t0.updated_by_user_id AS updated_by_user_id_68, t0.mode_type_id AS mode_type_id_69, t0.id_account AS id_account_70, t0.deploymentgroup_id AS deploymentgroup_id_71 FROM ehpads t0 WHERE t0.id = ?
Parameters:
[
"285"
]
|
| 4 | 0.29 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.automatic AS automatic_4, t0.show_fields AS show_fields_5, t0.nb_correspondance AS nb_correspondance_6, t0.format AS format_7 FROM mode_type t0 ORDER BY t0.id DESC
Parameters:
[] |
| 5 | 0.36 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.email_hmac AS email_hmac_3, t0.phone AS phone_4, t0.roles AS roles_5, t0.functional_roles AS functional_roles_6, t0.password AS password_7, t0.password_history AS password_history_8, t0.password_changed_at AS password_changed_at_9, t0.firstname AS firstname_10, t0.name AS name_11, t0.username AS username_12, t0.stopdate AS stopdate_13, t0.lastlogin AS lastlogin_14, t0.access_token AS access_token_15, t0.access_token_hmac AS access_token_hmac_16, t0.token_expires_at AS token_expires_at_17, t0.is_emergency_account AS is_emergency_account_18, t0.totp_secret AS totp_secret_19, t0.is_mfa_enabled AS is_mfa_enabled_20, t0.allowed_ips AS allowed_ips_21, t0.trusted_token_version AS trusted_token_version_22, t0.failed_login_attempts AS failed_login_attempts_23, t0.locked_until AS locked_until_24, t0.mobile_session_token_hash AS mobile_session_token_hash_25, t0.mobile_session_last_activity AS mobile_session_last_activity_26, t0.mobile_session_created_at AS mobile_session_created_at_27, t0.mobile_session_trusted_version AS mobile_session_trusted_version_28, t0.mobile_session_password_changed_at AS mobile_session_password_changed_at_29, t0.created_at AS created_at_30, t0.updated_at AS updated_at_31, t0.created_by_account_id AS created_by_account_id_32, t0.updated_by_account_id AS updated_by_account_id_33, t0.created_by_user_id AS created_by_user_id_34, t0.updated_by_user_id AS updated_by_user_id_35, t0.linked_user_id AS linked_user_id_36 FROM account t0
Parameters:
[] |
| 6 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.comments AS comments_3, t0.isDefaultGroup AS isDefaultGroup_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_account_id AS created_by_account_id_7, t0.updated_by_account_id AS updated_by_account_id_8, t0.created_by_user_id AS created_by_user_id_9, t0.updated_by_user_id AS updated_by_user_id_10, t0.id_drugsRawData AS id_drugsRawData_11, t0.id_flashInfo AS id_flashInfo_12, t0.id_petitModuleExe AS id_petitModuleExe_13, t0.id_silverpillExe AS id_silverpillExe_14 FROM deploymentgroups t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 7 | 0.31 ms |
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.comments AS comments_2, d0_.isDefaultGroup AS isDefaultGroup_3, d0_.created_at AS created_at_4, d0_.updated_at AS updated_at_5, d0_.created_by_account_id AS created_by_account_id_6, d0_.updated_by_account_id AS updated_by_account_id_7, d0_.created_by_user_id AS created_by_user_id_8, d0_.updated_by_user_id AS updated_by_user_id_9, d0_.id_drugsRawData AS id_drugsRawData_10, d0_.id_flashInfo AS id_flashInfo_11, d0_.id_petitModuleExe AS id_petitModuleExe_12, d0_.id_silverpillExe AS id_silverpillExe_13 FROM deploymentgroups d0_
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Account | 25 |
| App\Entity\ModeType | 22 |
| App\Entity\Deploymentgroup | 22 |
| App\Entity\User | 9 |
| App\Entity\Silverpillexe | 5 |
| App\Entity\Drugsrawdata | 3 |
| App\Entity\Petitmoduleexe | 3 |
| App\Entity\Ehpad | 1 |
| App\Entity\FlashInfo | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Account | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Pharmacie | No errors. |
| App\Entity\Ehpad | No errors. |
| App\Entity\ModeType | No errors. |
| App\Entity\Deploymentgroup | No errors. |
| App\Entity\PharmaciesEhpads | No errors. |
| App\Entity\Sector | No errors. |
| App\Entity\Drugview | No errors. |
| App\Entity\Station | No errors. |
| App\Entity\Idextpharmacies | No errors. |
| App\Entity\Settingtime | No errors. |
| App\Entity\Correspondence | No errors. |
| App\Entity\SettingTableCorrespondance | No errors. |
| App\Entity\Drugsrawdata | No errors. |
| App\Entity\FlashInfo | No errors. |
| App\Entity\Petitmoduleexe | No errors. |
| App\Entity\Silverpillexe | No errors. |