2025-09-01 15:05:08 0.015537 175281 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(0, NOW() ,'view dashboard', 'auth failed', 0) ROWS:1
2025-09-01 15:05:08 0.024916 175281 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 '%%' AND a.user_id=0 ROWS:0
2025-09-01 15:05:08 0.026581 175281 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 '%%' AND group_id=0 ROWS:0
2025-09-01 15:05:08 0.02684 175281 debug RESULT GROUP AUTH:Array ( [CREATE] => 0 [READ] => 0 [UPDATE] => 0 [DELETE] => 0 ) 
2025-09-01 15:05:08 0.027769 175281 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(0, NOW() ,'view dashboard', 'success', 1) ROWS:1
2025-09-01 15:05:08 0.03036 175281 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= OR c.user_id=) GROUP BY a.id ORDER BY parent_id ASC, rank ASC ROWS:-1 ERROR:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'OR c.user_id=) GROUP BY a.id ORDER BY parent_id ASC, rank ASC' at line 9
2025-09-01 15:05:08 0.051084 175281 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) = '09' ROWS:[{"tot_bayar":null,"tot_sisa":null,"tot_total":null,"total_order":"0"}]
2025-09-01 15:05:08 0.132726 175281 debug OUTPUT: 
2025-09-01 15:05:08 0.03541 175636 debug OUTPUT: 
2025-09-01 15:05:09 0.031282 175791 debug OUTPUT: 
2025-09-01 15:05:15 0.028283 175823 debug QUERY:SELECT a.* FROM sso_core_user a WHERE a.user_name='yuliyanto' AND a.user_password='5f4dcc3b5aa765d61d8327deb882cf99' ROWS:1
2025-09-01 15:05:15 0.433331 175823 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'verify auth', 'success', 1) ROWS:1
2025-09-01 15:05:15 0.435691 175823 debug QUERY:INSERT INTO tbl_login_location (username, location, create_date) VALUES('yuliyanto','', NOW()) ROWS:1
2025-09-01 15:05:15 0.012268 175958 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-09-01 15:05:15 0.013342 175958 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-09-01 15:05:15 0.016313 175958 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-09-01 15:05:15 0.017415 175958 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-09-01 15:05:15 0.017687 175958 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2025-09-01 15:05:15 0.018406 175958 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view dashboard', 'success', 1) ROWS:1
2025-09-01 15:05:15 0.027052 175958 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-09-01 15:05:15 0.047236 175958 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) = '09' ROWS:[{"tot_bayar":null,"tot_sisa":null,"tot_total":null,"total_order":"0"}]
2025-09-01 15:05:15 0.11473 175958 debug OUTPUT: 
2025-09-01 15:05:16 0.009663 175796 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-09-01 15:05:16 0.010532 175796 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-09-01 15:05:16 0.013306 175796 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-09-01 15:05:16 0.01406 175796 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-09-01 15:05:16 0.014263 175796 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2025-09-01 15:05:16 0.066481 175796 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) = '09' GROUP BY b.brg_name ORDER BY sum(d.Pjd_Qty) DESC LIMIT 5 ROWS:[]
2025-09-01 15:05:16 0.012622 175215 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-09-01 15:05:16 0.013637 175215 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-09-01 15:05:20 0.012514 175522 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-09-01 15:05:20 0.015382 175522 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-09-01 15:05:20 0.016178 175522 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-09-01 15:05:20 0.026265 175522 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-09-01 15:05:20 0.067017 175522 debug OUTPUT: 
2025-09-01 15:05:20 0.010101 175608 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-09-01 15:05:20 0.01094 175608 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-09-01 15:05:37 0.012011 175754 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 '%master/barang%' AND a.user_id=7 ROWS:1
2025-09-01 15:05:37 0.015419 175754 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 '%master/barang%' AND a.user_id=7 ROWS:1
2025-09-01 15:05:37 0.01613 175754 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view master barang page', 'success', 1) ROWS:1
2025-09-01 15:05:37 0.024119 175754 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-09-01 15:05:37 0.028738 175754 debug QUERY Get All Satuan:SELECT * FROM tblmaster_unit WHERE status = 1 ROWS:2
2025-09-01 15:05:37 0.082821 175754 debug OUTPUT: 
2025-09-01 15:05:37 0.009177 175598 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 '%master/barang/datagrid%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:37 0.009902 175598 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 '%master/barang/datagrid%' AND group_id=1 ROWS:0
2025-09-01 15:05:37 0.015468 175598 debug QUERY:SELECT a.brg_id,a.brg_name,c.unit_name,a.hpp,a.stok,a.status,a.create_date FROM tblmaster_barang a JOIN tblmaster_unit c ON a.satuan = c.code WHERE 1=1 ORDER BY a.brg_id desc LIMIT 0,50 ROWS:50
2025-09-01 15:05:37 0.016603 175598 debug QUERY:SELECT count(a.brg_id) totRecord,sum(a.hpp*a.stok) total_barang FROM tblmaster_barang a JOIN tblmaster_unit c ON a.satuan = c.code WHERE 1=1 ROWS:1
2025-09-01 15:05:44 0.016459 175835 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 '%master/customer%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:44 0.01768 175835 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 '%master/customer%' AND group_id=1 ROWS:1
2025-09-01 15:05:44 0.021177 175835 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 '%master/customer%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:44 0.0222 175835 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 '%master/customer%' AND group_id=1 ROWS:1
2025-09-01 15:05:44 0.022449 175835 debug RESULT GROUP AUTH:Array ( [CREATE] => 1 [READ] => 1 [UPDATE] => 1 [DELETE] => 1 ) 
2025-09-01 15:05:44 0.023362 175835 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view master customer page', 'success', 1) ROWS:1
2025-09-01 15:05:44 0.036911 175835 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-09-01 15:05:44 0.099474 175835 debug OUTPUT: 
2025-09-01 15:05:44 0.010013 175328 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 '%master/customer/favicon.ico%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:44 0.010859 175328 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 '%master/customer/favicon.ico%' AND group_id=1 ROWS:0
2025-09-01 15:05:44 0.008206 175554 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 '%master/customer/datagrid%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:44 0.008940 175554 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 '%master/customer/datagrid%' AND group_id=1 ROWS:0
2025-09-01 15:05:44 0.029827 175554 debug QUERY:SELECT a.id,a.code,a.name,a.address,a.phone,a.email,IFNULL(hutang.tempo,0),a.status,a.create_user,a.create_date FROM tblmaster_customer a LEFT JOIN (SELECT DISTINCT(Pjh_KdCustomer) cust, SUM(Pjh_BayarTempo) tempo FROM tbltrans_penjualan_h) AS hutang ON a.code=hutang.cust WHERE 1=1 ORDER BY a.id desc LIMIT 0,10 ROWS:10
2025-09-01 15:05:44 0.038213 175554 debug QUERY:SELECT count(a.id) totRecord FROM tblmaster_customer a INNER JOIN tblmaster_city b ON a.city=b.code WHERE 1=1 ROWS:1
2025-09-01 15:05:48 0.010415 175220 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 '%master/hargacustomer%' AND a.user_id=7 ROWS:1
2025-09-01 15:05:48 0.013395 175220 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 '%master/hargacustomer%' AND a.user_id=7 ROWS:1
2025-09-01 15:05:48 0.014279 175220 debug QUERY:INSERT INTO tbl_cms_activities (user_id, datetime, action, result, result_status) VALUES(7, NOW() ,'view master harga customer page', 'success', 1) ROWS:1
2025-09-01 15:05:48 0.023171 175220 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-09-01 15:05:48 0.027005 175220 debug QUERY:SELECT code , name FROM tblmaster_customer WHERE status = 1 ROWS:349
2025-09-01 15:05:48 0.029212 175220 debug QUERY:SELECT brg_id , brg_name FROM tblmaster_barang WHERE status = 1 ROWS:173
2025-09-01 15:05:48 0.075543 175220 debug OUTPUT: 
2025-09-01 15:05:48 0.014609 175805 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 '%master/hargacustomer/datagridv2%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:48 0.015631 175805 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 '%master/hargacustomer/datagridv2%' AND group_id=1 ROWS:0
2025-09-01 15:05:52 -0.21161 175805 debug QUERY:SELECT a.id,b.name as cust_name,a.brg_id,c.brg_name,d.unit_name,c.stok,c.hpp,a.harga_jual FROM tblbarang_customer a LEFT JOIN tblmaster_customer b ON b.code = a.cust_id LEFT JOIN tblmaster_barang c ON c.brg_id = a.brg_id LEFT JOIN tblmaster_unit d ON d.code = c.satuan WHERE 1=1 ORDER BY a.cust_id , a.brg_id ASC LIMIT 0,50 ROWS:50
2025-09-01 15:05:52 -0.17409 175805 debug QUERY:SELECT count(a.id) totRecord FROM tblbarang_customer a LEFT JOIN tblmaster_barang c ON c.brg_id = a.brg_id WHERE 1=1 ROWS:1
2025-09-01 15:05:52 0.010387 175526 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 '%master/hargacustomer/datagridv2%' AND a.user_id=7 ROWS:0
2025-09-01 15:05:52 0.011163 175526 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 '%master/hargacustomer/datagridv2%' AND group_id=1 ROWS:0
2025-09-01 15:05:52 0.032954 175526 debug QUERY:SELECT a.id,b.name as cust_name,a.brg_id,c.brg_name,d.unit_name,c.stok,c.hpp,a.harga_jual FROM tblbarang_customer a LEFT JOIN tblmaster_customer b ON b.code = a.cust_id LEFT JOIN tblmaster_barang c ON c.brg_id = a.brg_id LEFT JOIN tblmaster_unit d ON d.code = c.satuan WHERE 1=1 AND a.cust_id='CST001' ORDER BY a.cust_id , a.brg_id ASC LIMIT 0,50 ROWS:50
2025-09-01 15:05:52 0.051469 175526 debug QUERY:SELECT count(a.id) totRecord FROM tblbarang_customer a LEFT JOIN tblmaster_barang c ON c.brg_id = a.brg_id WHERE 1=1 AND a.cust_id='CST001' ROWS:1