Symfony Profiler

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

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 = '6596' LIMIT 1;

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.current = ? 
ORDER BY 
  t0.created_at DESC

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 (1, 2) AND t0.current = 1 ORDER BY t0.created_at DESC;

SELECT 
  t0.position_id AS position_id_1, 
  t0.position_name AS position_name_2, 
  t0.company_id AS company_id_3, 
  t0.department_id AS department_id_4, 
  t0.parent_position_id AS parent_position_id_5, 
  t0.level AS level_6, 
  t0.status AS status_7, 
  t0.last_edit_login_id AS last_edit_login_id_8, 
  t0.last_mongolog_id AS last_mongolog_id_9, 
  t0.created_at AS created_at_10, 
  t0.updated_at AS updated_at_11, 
  t0.doc_booked_flag AS doc_booked_flag_12, 
  t0.time_stamp_of_form AS time_stamp_of_form_13 
FROM 
  sys_department_position t0 
WHERE 
  t0.status = ? 
  AND t0.position_id = ? 
LIMIT 
  1

SELECT t0.position_id AS position_id_1, t0.position_name AS position_name_2, t0.company_id AS company_id_3, t0.department_id AS department_id_4, t0.parent_position_id AS parent_position_id_5, t0.level AS level_6, t0.status AS status_7, t0.last_edit_login_id AS last_edit_login_id_8, t0.last_mongolog_id AS last_mongolog_id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.doc_booked_flag AS doc_booked_flag_12, t0.time_stamp_of_form AS time_stamp_of_form_13 FROM sys_department_position t0 WHERE t0.status = 1 AND t0.position_id = '49' LIMIT 1;

SELECT 
  t0.department_id AS department_id_1, 
  t0.department_name AS department_name_2, 
  t0.company_id AS company_id_3, 
  t0.level AS level_4, 
  t0.status AS status_5, 
  t0.last_edit_login_id AS last_edit_login_id_6, 
  t0.last_mongolog_id AS last_mongolog_id_7, 
  t0.created_at AS created_at_8, 
  t0.updated_at AS updated_at_9, 
  t0.doc_booked_flag AS doc_booked_flag_10, 
  t0.time_stamp_of_form AS time_stamp_of_form_11 
FROM 
  sys_department t0 
WHERE 
  t0.status = ? 
  AND t0.department_id = ? 
LIMIT 
  1

SELECT t0.department_id AS department_id_1, t0.department_name AS department_name_2, t0.company_id AS company_id_3, t0.level AS level_4, t0.status AS status_5, t0.last_edit_login_id AS last_edit_login_id_6, t0.last_mongolog_id AS last_mongolog_id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.doc_booked_flag AS doc_booked_flag_10, t0.time_stamp_of_form AS time_stamp_of_form_11 FROM sys_department t0 WHERE t0.status = 1 AND t0.department_id = 10 LIMIT 1;

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

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 = 27 LIMIT 1;

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

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 (0) AND t0.action IN (3) AND t0.current = 1 ORDER BY t0.created_at DESC;

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 = ?

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 = 2 AND t0.action = 3;