Symfony Profiler

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 ('logingf', 'logingf/', '//logingf');

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

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 (144148224, '2026-02-04 23:30:39', '[\"216.73.216.130\"]', 'jn3pgedml33s5i60hjseiii8kr', 'anon.', 'Controller', 'Logingf', 'home', '/logingf');

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 (3218946, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', NULL, '2026-02-04 23:30:39', 1, '216.73.216.130');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

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.username IS NULL
LIMIT
  1

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.username IS NULL LIMIT 1;

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

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 (144148225, '2026-02-04 23:30:39', '[\"216.73.216.130\"]', 'jn3pgedml33s5i60hjseiii8kr', 'anon.', 'Controller', 'Logingf', 'landingPageAbout', '/_fragment');

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 (3218947, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', NULL, '2026-02-04 23:30:39', 1, '216.73.216.130');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

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 (144148226, '2026-02-04 23:30:39', '[\"216.73.216.130\"]', 'jn3pgedml33s5i60hjseiii8kr', 'anon.', 'Controller', 'Logingf', 'landingPageCharts', '/_fragment');

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 (3218948, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', NULL, '2026-02-04 23:30:39', 1, '216.73.216.130');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  l0_.id AS id_0,
  l0_.loan_details AS loan_details_1,
  l0_.total_employees AS total_employees_2,
  l0_.total_closures AS total_closures_3,
  l0_.total_admission AS total_admission_4,
  l0_.entered_date AS entered_date_5,
  l0_.total_offices AS total_offices_6,
  l0_.depart_emp_count AS depart_emp_count_7
FROM
  public.loginstatistics l0_
ORDER BY
  l0_.id DESC
LIMIT
  1

SELECT l0_.id AS id_0, l0_.loan_details AS loan_details_1, l0_.total_employees AS total_employees_2, l0_.total_closures AS total_closures_3, l0_.total_admission AS total_admission_4, l0_.entered_date AS entered_date_5, l0_.total_offices AS total_offices_6, l0_.depart_emp_count AS depart_emp_count_7 FROM public.loginstatistics l0_ ORDER BY l0_.id DESC LIMIT 1;

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

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 (144148227, '2026-02-04 23:30:39', '[\"216.73.216.130\"]', 'jn3pgedml33s5i60hjseiii8kr', 'anon.', 'Controller', 'Logingf', 'landingPageDeptChart', '/_fragment');

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 (3218949, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', NULL, '2026-02-04 23:30:39', 1, '216.73.216.130');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  s0_.id AS id_0,
  s0_.pao_total_sanctioned_loans AS pao_total_sanctioned_loans_1,
  s0_.pao_completed_under10 AS pao_completed_under10_2,
  s0_.pao_completed_upto20 AS pao_completed_upto20_3,
  s0_.pao_completed_greater20 AS pao_completed_greater20_4,
  s0_.percent10 AS percent10_5,
  s0_.percent20 AS percent20_6,
  s0_.percent30 AS percent30_7,
  s0_.entered_date AS entered_date_8
FROM
  sanctioned_statistics s0_

SELECT s0_.id AS id_0, s0_.pao_total_sanctioned_loans AS pao_total_sanctioned_loans_1, s0_.pao_completed_under10 AS pao_completed_under10_2, s0_.pao_completed_upto20 AS pao_completed_upto20_3, s0_.pao_completed_greater20 AS pao_completed_greater20_4, s0_.percent10 AS percent10_5, s0_.percent20 AS percent20_6, s0_.percent30 AS percent30_7, s0_.entered_date AS entered_date_8 FROM sanctioned_statistics s0_;

SELECT
  NEXTVAL('zlogs_audit_trail_id_seq')

SELECT NEXTVAL('zlogs_audit_trail_id_seq');

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 (144148228, '2026-02-04 23:30:39', '[\"216.73.216.130\"]', 'jn3pgedml33s5i60hjseiii8kr', 'anon.', 'Controller', 'Logingf', 'landingPageFaq', '/_fragment');

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 (3218950, 'INSERT INTO zlogs_audit_trail (id, log_time, ip_address, session_id, user_name, bundle_name, controller_name, action_name, route) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)

', NULL, '2026-02-04 23:30:39', 1, '216.73.216.130');

"COMMIT"

"COMMIT";

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";