https://www.ourhoneybee.xyz/get_pending_approval_list_for_user Return to referer URL

Query Metrics

5 Database Queries
4 Different statements
401.36 ms Query time
0 Invalid entities

Queries

Group similar statements

default connection

# Time Info
1 398.44 ms
SELECT t0.login_id AS login_id_1, t0.user_id AS user_id_2, t0.position_id AS position_id_3, t0.login_ip AS login_ip_4, t0.log_time AS log_time_5, t0.log_status AS log_status_6, t0.device_id AS device_id_7, t0.o_auth_token AS o_auth_token_8, t0.o_auth_type AS o_auth_type_9, t0.firebase_token AS firebase_token_10, t0.locale AS locale_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.doc_booked_flag AS doc_booked_flag_14, t0.time_stamp_of_form AS time_stamp_of_form_15 FROM sys_login_log t0 WHERE t0.login_id = ? LIMIT 1
Parameters:
[
  "21"
]
2 0.94 ms
SELECT t0.user_id AS user_id_1, t0.global_id AS global_id_2, t0.sync_flag AS sync_flag_3, t0.name AS name_4, t0.module_ids AS module_ids_5, t0.widget_ids AS widget_ids_6, t0.home_screen_widget_ids AS home_screen_widget_ids_7, t0.email AS email_8, t0.user_name AS user_name_9, t0.password AS password_10, t0.temp_password AS temp_password_11, t0.image AS image_12, t0.salt AS salt_13, t0.user_type AS user_type_14, t0.position_ids AS position_ids_15, t0.supervisor_id AS supervisor_id_16, t0.company_id AS company_id_17, t0.user_company_id_list AS user_company_id_list_18, t0.app_id AS app_id_19, t0.user_app_id_list AS user_app_id_list_20, t0.branch_id AS branch_id_21, t0.user_branch_id_list AS user_branch_id_list_22, t0.tagged_party_type AS tagged_party_type_23, t0.tagged_party_id AS tagged_party_id_24, t0.manual_department AS manual_department_25, t0.device_id AS device_id_26, t0.device_id_locked_flag AS device_id_locked_flag_27, t0.lock_device_id_on_next_login_flag AS lock_device_id_on_next_login_flag_28, t0.o_auth_unique_id AS o_auth_unique_id_29, t0.o_auth_image AS o_auth_image_30, t0.o_auth_token AS o_auth_token_31, t0.o_auth_email_verified AS o_auth_email_verified_32, t0.o_auth_type AS o_auth_type_33, t0.o_auth_email AS o_auth_email_34, t0.email_verification_hash AS email_verification_hash_35, t0.phone_number AS phone_number_36, t0.phone_verification_hash AS phone_verification_hash_37, t0.otp_action_id AS otp_action_id_38, t0.otp AS otp_39, t0.otp_expire_ts AS otp_expire_ts_40, t0.trigger_reset_password AS trigger_reset_password_41, t0.forgot_password_token AS forgot_password_token_42, t0.forgot_password_token_expire_ts AS forgot_password_token_expire_ts_43, t0.is_email_verified AS is_email_verified_44, t0.is_phone_verified AS is_phone_verified_45, t0.is_banned AS is_banned_46, t0.ban_expires AS ban_expires_47, t0.strike_count AS strike_count_48, t0.strike_threshold AS strike_threshold_49, t0.account_status AS account_status_50, t0.default_route AS default_route_51, t0.all_module_access_flag AS all_module_access_flag_52, t0.status AS status_53, t0.last_edit_login_id AS last_edit_login_id_54, t0.last_mongolog_id AS last_mongolog_id_55, t0.last_settings_updated_ts AS last_settings_updated_ts_56, t0.created_at AS created_at_57, t0.updated_at AS updated_at_58, t0.doc_booked_flag AS doc_booked_flag_59, t0.time_stamp_of_form AS time_stamp_of_form_60 FROM sys_user t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  2
]
3 1.47 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.user_assign_type AS user_assign_type_3, t0.position_id AS position_id_4, t0.login_id AS login_id_5, t0.user_ids AS user_ids_6, t0.company_id AS company_id_7, t0.action AS action_8, t0.role_type AS role_type_9, t0.required AS required_10, t0.acknowledgment_type AS acknowledgment_type_11, t0.acknowledgment_entity_id AS acknowledgment_entity_id_12, t0.acknowledgment_user_id AS acknowledgment_user_id_13, t0.acknowledgement_name AS acknowledgement_name_14, t0.acknowledgement_pos AS acknowledgement_pos_15, t0.acknowledgement_company_name AS acknowledgement_company_name_16, t0.sig_data AS sig_data_17, t0.skip_print_flag AS skip_print_flag_18, t0.sig_id AS sig_id_19, t0.entity AS entity_20, t0.entity_id AS entity_id_21, t0.succession AS succession_22, t0.current AS current_23, t0.succession_timeout AS succession_timeout_24, t0.document_hash AS document_hash_25, t0.note AS note_26, t0.succession_expire AS succession_expire_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM approval t0 WHERE t0.required IN (?) AND t0.action IN (?) AND t0.current = ? ORDER BY t0.created_at DESC
Parameters:
[
  [
    1
  ]
  [
    3
  ]
  1
]
4 0.29 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.user_assign_type AS user_assign_type_3, t0.position_id AS position_id_4, t0.login_id AS login_id_5, t0.user_ids AS user_ids_6, t0.company_id AS company_id_7, t0.action AS action_8, t0.role_type AS role_type_9, t0.required AS required_10, t0.acknowledgment_type AS acknowledgment_type_11, t0.acknowledgment_entity_id AS acknowledgment_entity_id_12, t0.acknowledgment_user_id AS acknowledgment_user_id_13, t0.acknowledgement_name AS acknowledgement_name_14, t0.acknowledgement_pos AS acknowledgement_pos_15, t0.acknowledgement_company_name AS acknowledgement_company_name_16, t0.sig_data AS sig_data_17, t0.skip_print_flag AS skip_print_flag_18, t0.sig_id AS sig_id_19, t0.entity AS entity_20, t0.entity_id AS entity_id_21, t0.succession AS succession_22, t0.current AS current_23, t0.succession_timeout AS succession_timeout_24, t0.document_hash AS document_hash_25, t0.note AS note_26, t0.succession_expire AS succession_expire_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM approval t0 WHERE t0.required IN (?) AND t0.action IN (?) AND t0.current = ? ORDER BY t0.created_at DESC
Parameters:
[
  [
    0
  ]
  [
    3
  ]
  1
]
5 0.22 ms
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.user_assign_type AS user_assign_type_3, t0.position_id AS position_id_4, t0.login_id AS login_id_5, t0.user_ids AS user_ids_6, t0.company_id AS company_id_7, t0.action AS action_8, t0.role_type AS role_type_9, t0.required AS required_10, t0.acknowledgment_type AS acknowledgment_type_11, t0.acknowledgment_entity_id AS acknowledgment_entity_id_12, t0.acknowledgment_user_id AS acknowledgment_user_id_13, t0.acknowledgement_name AS acknowledgement_name_14, t0.acknowledgement_pos AS acknowledgement_pos_15, t0.acknowledgement_company_name AS acknowledgement_company_name_16, t0.sig_data AS sig_data_17, t0.skip_print_flag AS skip_print_flag_18, t0.sig_id AS sig_id_19, t0.entity AS entity_20, t0.entity_id AS entity_id_21, t0.succession AS succession_22, t0.current AS current_23, t0.succession_timeout AS succession_timeout_24, t0.document_hash AS document_hash_25, t0.note AS note_26, t0.succession_expire AS succession_expire_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.doc_booked_flag AS doc_booked_flag_30, t0.time_stamp_of_form AS time_stamp_of_form_31 FROM approval t0 WHERE t0.required = ? AND t0.action = ?
Parameters:
[
  2
  3
]

company_group connection

No database queries were performed.

Database Connections

Name Service
default doctrine.dbal.default_connection
company_group doctrine.dbal.company_group_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager
company_group doctrine.orm.company_group_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class Mapping errors
ApplicationBundle\Entity\SysLoginLog No errors.
ApplicationBundle\Entity\SysUser No errors.
ApplicationBundle\Entity\Approval No errors.

company_group entity manager

No loaded entities.