2025-07-14 05:11:57 0.042853 175997 debug OUTPUT: 
2025-07-14 05:11:58 0.030698 175709 debug OUTPUT: 
2025-07-14 05:12:05 0.01739 175302 debug QUERY:SELECT a.* FROM sso_core_user a WHERE a.user_name='yuliyanto' AND a.user_password='5f4dcc3b5aa765d61d8327deb882cf99' ROWS:1
2025-07-14 05:12:06 -0.56049 175302 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'verify auth', 'success', 1) ROWS:1
2025-07-14 05:12:06 -0.55885 175302 debug QUERY:INSERT INTO tbl_login_location (username, location, create_date) VALUES('yuliyanto','Jakarta, Jakarta, Indonesia', NOW()) ROWS:1
2025-07-14 05:12:06 0.010447 175509 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:06 0.012373 175509 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2025-07-14 05:12:06 0.015384 175509 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:06 0.016203 175509 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard%' AND group_id=1 ROWS:2
2025-07-14 05:12:06 0.01637 175509 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2025-07-14 05:12:06 0.017149 175509 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view dashboard', 'success', 1) ROWS:1
2025-07-14 05:12:06 0.027202 175509 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=7) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:33
2025-07-14 05:12:06 0.050995 175509 debug QUERY:SELECT SUM(Pjh_BayarCash) as tot_bayar , SUM(Pjh_BayarTempo) as tot_sisa , SUM(Pjh_Total) as tot_total, COUNT(id) as total_order FROM tbltrans_penjualan_h WHERE YEAR(Pjh_Date) = '2025' AND MONTH(Pjh_Date) = '07' ROWS:[{"tot_bayar":null,"tot_sisa":null,"tot_total":null,"total_order":"0"}]
2025-07-14 05:12:06 0.098308 175509 debug OUTPUT: 
2025-07-14 05:12:06 0.008936 175480 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:06 0.009792 175480 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/favicon.ico%' AND group_id=1 ROWS:0
2025-07-14 05:12:06 0.008958 175294 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:06 0.009638 175294 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/getTopBarang%' AND group_id=1 ROWS:0
2025-07-14 05:12:06 0.012099 175294 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:06 0.012646 175294 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%dashboard/%' AND group_id=1 ROWS:1
2025-07-14 05:12:06 0.012764 175294 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2025-07-14 05:12:06 0.056734 175294 debug QUERY:SELECT b.brg_name , sum(d.Pjd_Qty) as total_qty FROM tbltrans_penjualan_d d LEFT JOIN tblmaster_barang b ON b.brg_id = d.Pjd_KdBarang WHERE YEAR(d.Pjd_Date) = '2025' AND MONTH(d.Pjd_Date) = '07' GROUP BY b.brg_name ORDER BY sum(d.Pjd_Qty) DESC LIMIT 5 ROWS:[]
2025-07-14 05:12:12 0.008566 175620 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%cms/activities%' AND a.user_id=7 ROWS:1
2025-07-14 05:12:12 0.011161 175620 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%cms/activities%' AND a.user_id=7 ROWS:1
2025-07-14 05:12:12 0.011879 175620 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view activities page', 'success', 1) ROWS:1
2025-07-14 05:12:12 0.018464 175620 debug GETMENU QUERY:SELECT a.* FROM sso_cms_menu a LEFT JOIN sso_group_access b ON a.id=b.menu_id LEFT JOIN sso_user_access c ON a.id=c.menu_id WHERE a.status=1 AND IF(b.action & 1, 1, 0)=1 AND (b.group_id=1 OR c.user_id=7) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:33
2025-07-14 05:12:12 0.051077 175620 debug OUTPUT: 
2025-07-14 05:12:12 0.008168 175742 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%cms/activities/datagrid%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:12 0.008945 175742 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%cms/activities/datagrid%' AND group_id=1 ROWS:0
2025-07-14 05:12:38 0.010722 175442 debug QUERY:SELECT a.menu_id, a.action FROM sso_user_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%account/logout%' AND a.user_id=7 ROWS:0
2025-07-14 05:12:38 0.011554 175442 debug QUERY:SELECT a.menu_id, a.action FROM sso_group_access a LEFT JOIN sso_cms_menu b ON a.menu_id=b.id WHERE b.uri like '%account/logout%' AND group_id=1 ROWS:0
2025-07-14 05:12:38 0.012853 175442 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'logout', 'success', 1) ROWS:1
2025-07-14 05:12:38 0.030213 175137 debug OUTPUT: 
2025-07-14 05:12:38 0.029584 175302 debug OUTPUT: