Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.attempted AS attempted_2,
  t0.is_logged AS is_logged_3,
  t0.attempted_at AS attempted_at_4,
  t0.password_changed_at AS password_changed_at_5,
  t0.password_changed AS password_changed_6,
  t0.nic_password AS nic_password_7,
  t0.gu_id AS gu_id_8,
  t0.username AS username_9,
  t0.password AS password_10,
  t0.salt AS salt_11,
  t0.roles AS roles_12,
  t0.login_check_token AS login_check_token_13
FROM
  public.nicsl_users t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.attempted AS attempted_2, t0.is_logged AS is_logged_3, t0.attempted_at AS attempted_at_4, t0.password_changed_at AS password_changed_at_5, t0.password_changed AS password_changed_6, t0.nic_password AS nic_password_7, t0.gu_id AS gu_id_8, t0.username AS username_9, t0.password AS password_10, t0.salt AS salt_11, t0.roles AS roles_12, t0.login_check_token AS login_check_token_13 FROM public.nicsl_users t0 WHERE t0.id = 72729;

SELECT
  g0_.menu_id AS menu_id_0,
  g0_.menu_desc AS menu_desc_1,
  g0_.menu_level_1 AS menu_level_1_2,
  g0_.menu_level_2 AS menu_level_2_3,
  g0_.menu_level_3 AS menu_level_3_4,
  g0_.route AS route_5,
  g0_.route_name AS route_name_6,
  g0_.updated_by AS updated_by_7,
  g0_.update_time AS update_time_8,
  g0_.menu_type AS menu_type_9,
  g0_.menu_hierarchy AS menu_hierarchy_10,
  g0_.pao_id AS pao_id_11,
  g0_.role AS role_12,
  g0_.menu_appearance AS menu_appearance_13,
  g0_.inst_based AS inst_based_14
FROM
  gainpf_menu_master g0_
WHERE
  g0_.route IN (?, ?, ?)

SELECT g0_.menu_id AS menu_id_0, g0_.menu_desc AS menu_desc_1, g0_.menu_level_1 AS menu_level_1_2, g0_.menu_level_2 AS menu_level_2_3, g0_.menu_level_3 AS menu_level_3_4, g0_.route AS route_5, g0_.route_name AS route_name_6, g0_.updated_by AS updated_by_7, g0_.update_time AS update_time_8, g0_.menu_type AS menu_type_9, g0_.menu_hierarchy AS menu_hierarchy_10, g0_.pao_id AS pao_id_11, g0_.role AS role_12, g0_.menu_appearance AS menu_appearance_13, g0_.inst_based AS inst_based_14 FROM gainpf_menu_master g0_ WHERE g0_.route IN ('new_ob', 'new_ob/', '//new_ob');

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.username_canonical AS username_canonical_3,
  t0.email AS email_4,
  t0.email_canonical AS email_canonical_5,
  t0.enabled AS enabled_6,
  t0.salt AS salt_7,
  t0.password AS password_8,
  t0.last_login AS last_login_9,
  t0.locked AS locked_10,
  t0.expired AS expired_11,
  t0.expires_at AS expires_at_12,
  t0.confirmation_token AS confirmation_token_13,
  t0.password_requested_at AS password_requested_at_14,
  t0.roles AS roles_15,
  t0.credentials_expired AS credentials_expired_16,
  t0.credentials_expire_at AS credentials_expire_at_17,
  t0.attempted AS attempted_18,
  t0.is_logged AS is_logged_19,
  t0.attempted_at AS attempted_at_20,
  t0.gu_id AS gu_id_21,
  t0.password_changed_at AS password_changed_at_22,
  t0.password_changed AS password_changed_23,
  t0.nic_password AS nic_password_24,
  t0.login_message_count AS login_message_count_25,
  t0.login_check_token AS login_check_token_26
FROM
  public.nicsl_users t0
WHERE
  t0.username = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.username_canonical AS username_canonical_3, t0.email AS email_4, t0.email_canonical AS email_canonical_5, t0.enabled AS enabled_6, t0.salt AS salt_7, t0.password AS password_8, t0.last_login AS last_login_9, t0.locked AS locked_10, t0.expired AS expired_11, t0.expires_at AS expires_at_12, t0.confirmation_token AS confirmation_token_13, t0.password_requested_at AS password_requested_at_14, t0.roles AS roles_15, t0.credentials_expired AS credentials_expired_16, t0.credentials_expire_at AS credentials_expire_at_17, t0.attempted AS attempted_18, t0.is_logged AS is_logged_19, t0.attempted_at AS attempted_at_20, t0.gu_id AS gu_id_21, t0.password_changed_at AS password_changed_at_22, t0.password_changed AS password_changed_23, t0.nic_password AS nic_password_24, t0.login_message_count AS login_message_count_25, t0.login_check_token AS login_check_token_26 FROM public.nicsl_users t0 WHERE t0.username = '536474';

SELECT
  g0_.menu_id AS menu_id_0,
  g0_.menu_desc AS menu_desc_1,
  g0_.menu_level_1 AS menu_level_1_2,
  g0_.menu_level_2 AS menu_level_2_3,
  g0_.menu_level_3 AS menu_level_3_4,
  g0_.route AS route_5,
  g0_.route_name AS route_name_6,
  g0_.updated_by AS updated_by_7,
  g0_.update_time AS update_time_8,
  g0_.menu_type AS menu_type_9,
  g0_.menu_hierarchy AS menu_hierarchy_10,
  g0_.pao_id AS pao_id_11,
  g0_.role AS role_12,
  g0_.menu_appearance AS menu_appearance_13,
  g0_.inst_based AS inst_based_14
FROM
  gainpf_menu_suburl_master g1_
  INNER JOIN gainpf_menu_master g0_ ON (g0_.menu_id = g1_.menu_id)
WHERE
  g1_.sub_url IN (?, ?, ?)

SELECT g0_.menu_id AS menu_id_0, g0_.menu_desc AS menu_desc_1, g0_.menu_level_1 AS menu_level_1_2, g0_.menu_level_2 AS menu_level_2_3, g0_.menu_level_3 AS menu_level_3_4, g0_.route AS route_5, g0_.route_name AS route_name_6, g0_.updated_by AS updated_by_7, g0_.update_time AS update_time_8, g0_.menu_type AS menu_type_9, g0_.menu_hierarchy AS menu_hierarchy_10, g0_.pao_id AS pao_id_11, g0_.role AS role_12, g0_.menu_appearance AS menu_appearance_13, g0_.inst_based AS inst_based_14 FROM gainpf_menu_suburl_master g1_ INNER JOIN gainpf_menu_master g0_ ON (g0_.menu_id = g1_.menu_id) WHERE g1_.sub_url IN ('new_ob', 'new_ob/', '//new_ob');

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

SELECT
  t0.id AS id_1,
  t0.gu_id AS gu_id_2,
  t0.emp_pen AS emp_pen_3,
  t0.emp_name AS emp_name_4,
  t0.emp_pf_accno AS emp_pf_accno_5,
  t0.emp_dob AS emp_dob_6,
  t0.emp_doj_in_parent_dept AS emp_doj_in_parent_dept_7,
  t0.emp_doj_in_present_dept AS emp_doj_in_present_dept_8,
  t0.emp_dor AS emp_dor_9,
  t0.emp_doj_in_govt AS emp_doj_in_govt_10,
  t0.emp_pan AS emp_pan_11,
  t0.emp_email AS emp_email_12,
  t0.emp_mob AS emp_mob_13,
  t0.confirmed AS confirmed_14,
  t0.actual_desig_eff_dt AS actual_desig_eff_dt_15,
  t0.present_desig_eff_dt AS present_desig_eff_dt_16,
  t0.parent_office_eff_dt AS parent_office_eff_dt_17,
  t0.present_office_eff_dt AS present_office_eff_dt_18,
  t0.emp_available AS emp_available_19,
  t0.reason AS reason_20,
  t0.employee_type AS employee_type_21,
  t0.spark_locked_pfno AS spark_locked_pfno_22,
  t0.cc_active_accounts AS cc_active_accounts_23,
  t0.ledger_folio AS ledger_folio_24,
  t0.freeze_update_profile AS freeze_update_profile_25,
  t0.deputation_status AS deputation_status_26,
  t0.paocd_without_pfno AS paocd_without_pfno_27,
  t0.temp AS temp_28,
  t0.seeding_locked_status AS seeding_locked_status_29,
  t0.data_source AS data_source_30,
  t0.g_pen AS g_pen_31,
  t0.login_id AS login_id_32,
  t0.state_cd AS state_cd_33,
  t0.parent_state_dept_id AS parent_state_dept_id_34,
  t0.present_state_dept_id AS present_state_dept_id_35,
  t0.parent_state_office_id AS parent_state_office_id_36,
  t0.present_state_office_id AS present_state_office_id_37,
  t0.parent_office_state_district_id AS parent_office_state_district_id_38,
  t0.present_office_state_district_id AS present_office_state_district_id_39,
  t0.actual_state_desig_id AS actual_state_desig_id_40,
  t0.present_state_desig_id AS present_state_desig_id_41,
  t0.emp_state_pao_id AS emp_state_pao_id_42,
  t0.deputation_parent_office_id AS deputation_parent_office_id_43,
  t0.deputation_state_desig_id AS deputation_state_desig_id_44
FROM
  gainpf_emp t0
WHERE
  t0.login_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.gu_id AS gu_id_2, t0.emp_pen AS emp_pen_3, t0.emp_name AS emp_name_4, t0.emp_pf_accno AS emp_pf_accno_5, t0.emp_dob AS emp_dob_6, t0.emp_doj_in_parent_dept AS emp_doj_in_parent_dept_7, t0.emp_doj_in_present_dept AS emp_doj_in_present_dept_8, t0.emp_dor AS emp_dor_9, t0.emp_doj_in_govt AS emp_doj_in_govt_10, t0.emp_pan AS emp_pan_11, t0.emp_email AS emp_email_12, t0.emp_mob AS emp_mob_13, t0.confirmed AS confirmed_14, t0.actual_desig_eff_dt AS actual_desig_eff_dt_15, t0.present_desig_eff_dt AS present_desig_eff_dt_16, t0.parent_office_eff_dt AS parent_office_eff_dt_17, t0.present_office_eff_dt AS present_office_eff_dt_18, t0.emp_available AS emp_available_19, t0.reason AS reason_20, t0.employee_type AS employee_type_21, t0.spark_locked_pfno AS spark_locked_pfno_22, t0.cc_active_accounts AS cc_active_accounts_23, t0.ledger_folio AS ledger_folio_24, t0.freeze_update_profile AS freeze_update_profile_25, t0.deputation_status AS deputation_status_26, t0.paocd_without_pfno AS paocd_without_pfno_27, t0.temp AS temp_28, t0.seeding_locked_status AS seeding_locked_status_29, t0.data_source AS data_source_30, t0.g_pen AS g_pen_31, t0.login_id AS login_id_32, t0.state_cd AS state_cd_33, t0.parent_state_dept_id AS parent_state_dept_id_34, t0.present_state_dept_id AS present_state_dept_id_35, t0.parent_state_office_id AS parent_state_office_id_36, t0.present_state_office_id AS present_state_office_id_37, t0.parent_office_state_district_id AS parent_office_state_district_id_38, t0.present_office_state_district_id AS present_office_state_district_id_39, t0.actual_state_desig_id AS actual_state_desig_id_40, t0.present_state_desig_id AS present_state_desig_id_41, t0.emp_state_pao_id AS emp_state_pao_id_42, t0.deputation_parent_office_id AS deputation_parent_office_id_43, t0.deputation_state_desig_id AS deputation_state_desig_id_44 FROM gainpf_emp t0 WHERE t0.login_id = 72729 LIMIT 1;

SELECT
  NEXTVAL('query_logs_id_seq')

SELECT NEXTVAL('query_logs_id_seq');

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO zlogs_audit_trail (
  id, log_time, ip_address, session_id,
  user_name, bundle_name, controller_name,
  action_name, route
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (144151961, '2026-02-05 07:08:01', '[\"103.151.188.144\"]', '2v85as4te3epqjpait3lipqtbi', '536474', 'Controller', 'Default', 'newOb', '/new_ob');

INSERT INTO query_logs (
  id, query_text, executed_by, created_at,
  affected_count, ip_address
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO query_logs (id, query_text, executed_by, created_at, affected_count, ip_address) VALUES (3223115, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', 382973, '2026-02-05 07:08:01', 1, '103.151.188.144');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.gu_id AS gu_id_2,
  t0.emp_pen AS emp_pen_3,
  t0.emp_name AS emp_name_4,
  t0.emp_pf_accno AS emp_pf_accno_5,
  t0.emp_dob AS emp_dob_6,
  t0.emp_doj_in_parent_dept AS emp_doj_in_parent_dept_7,
  t0.emp_doj_in_present_dept AS emp_doj_in_present_dept_8,
  t0.emp_dor AS emp_dor_9,
  t0.emp_doj_in_govt AS emp_doj_in_govt_10,
  t0.emp_pan AS emp_pan_11,
  t0.emp_email AS emp_email_12,
  t0.emp_mob AS emp_mob_13,
  t0.confirmed AS confirmed_14,
  t0.actual_desig_eff_dt AS actual_desig_eff_dt_15,
  t0.present_desig_eff_dt AS present_desig_eff_dt_16,
  t0.parent_office_eff_dt AS parent_office_eff_dt_17,
  t0.present_office_eff_dt AS present_office_eff_dt_18,
  t0.emp_available AS emp_available_19,
  t0.reason AS reason_20,
  t0.employee_type AS employee_type_21,
  t0.spark_locked_pfno AS spark_locked_pfno_22,
  t0.cc_active_accounts AS cc_active_accounts_23,
  t0.ledger_folio AS ledger_folio_24,
  t0.freeze_update_profile AS freeze_update_profile_25,
  t0.deputation_status AS deputation_status_26,
  t0.paocd_without_pfno AS paocd_without_pfno_27,
  t0.temp AS temp_28,
  t0.seeding_locked_status AS seeding_locked_status_29,
  t0.data_source AS data_source_30,
  t0.g_pen AS g_pen_31,
  t0.login_id AS login_id_32,
  t0.state_cd AS state_cd_33,
  t0.parent_state_dept_id AS parent_state_dept_id_34,
  t0.present_state_dept_id AS present_state_dept_id_35,
  t0.parent_state_office_id AS parent_state_office_id_36,
  t0.present_state_office_id AS present_state_office_id_37,
  t0.parent_office_state_district_id AS parent_office_state_district_id_38,
  t0.present_office_state_district_id AS present_office_state_district_id_39,
  t0.actual_state_desig_id AS actual_state_desig_id_40,
  t0.present_state_desig_id AS present_state_desig_id_41,
  t0.emp_state_pao_id AS emp_state_pao_id_42,
  t0.deputation_parent_office_id AS deputation_parent_office_id_43,
  t0.deputation_state_desig_id AS deputation_state_desig_id_44
FROM
  gainpf_emp t0
WHERE
  t0.login_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.gu_id AS gu_id_2, t0.emp_pen AS emp_pen_3, t0.emp_name AS emp_name_4, t0.emp_pf_accno AS emp_pf_accno_5, t0.emp_dob AS emp_dob_6, t0.emp_doj_in_parent_dept AS emp_doj_in_parent_dept_7, t0.emp_doj_in_present_dept AS emp_doj_in_present_dept_8, t0.emp_dor AS emp_dor_9, t0.emp_doj_in_govt AS emp_doj_in_govt_10, t0.emp_pan AS emp_pan_11, t0.emp_email AS emp_email_12, t0.emp_mob AS emp_mob_13, t0.confirmed AS confirmed_14, t0.actual_desig_eff_dt AS actual_desig_eff_dt_15, t0.present_desig_eff_dt AS present_desig_eff_dt_16, t0.parent_office_eff_dt AS parent_office_eff_dt_17, t0.present_office_eff_dt AS present_office_eff_dt_18, t0.emp_available AS emp_available_19, t0.reason AS reason_20, t0.employee_type AS employee_type_21, t0.spark_locked_pfno AS spark_locked_pfno_22, t0.cc_active_accounts AS cc_active_accounts_23, t0.ledger_folio AS ledger_folio_24, t0.freeze_update_profile AS freeze_update_profile_25, t0.deputation_status AS deputation_status_26, t0.paocd_without_pfno AS paocd_without_pfno_27, t0.temp AS temp_28, t0.seeding_locked_status AS seeding_locked_status_29, t0.data_source AS data_source_30, t0.g_pen AS g_pen_31, t0.login_id AS login_id_32, t0.state_cd AS state_cd_33, t0.parent_state_dept_id AS parent_state_dept_id_34, t0.present_state_dept_id AS present_state_dept_id_35, t0.parent_state_office_id AS parent_state_office_id_36, t0.present_state_office_id AS present_state_office_id_37, t0.parent_office_state_district_id AS parent_office_state_district_id_38, t0.present_office_state_district_id AS present_office_state_district_id_39, t0.actual_state_desig_id AS actual_state_desig_id_40, t0.present_state_desig_id AS present_state_desig_id_41, t0.emp_state_pao_id AS emp_state_pao_id_42, t0.deputation_parent_office_id AS deputation_parent_office_id_43, t0.deputation_state_desig_id AS deputation_state_desig_id_44 FROM gainpf_emp t0 WHERE t0.login_id = 72729 LIMIT 1;