select levelcp from gate.sc_role where idrole = 'assvm' and 1=1
(6.36 KB)
0.0011
select idjenjang as key,idjenjang||' - '||namajenjang as value from (select * from ref.lv_jenjangpendidikan where 1=1 order by urutan) x where ispt = '1'
(6.48 KB)
0.0023
select u.*, pu.namaunit as namafakultas, p.nama as ketua_prodi, pu.namaunit as namaparentunit, pu.jenisunit as jenisparentunit
from ref.ms_unit u
left join ref.ms_unit pu on pu.idunit = u.parentunit
left join akademik.ak_pegawai p ON p.nip = u.nipketua where 1=1 order by infoleft
(8.69 KB)
0.0007
select * from master.templateword_v2 where idtemplate = '185' and 1=1
(7.04 KB)
0.0007
select idtarget, namafile from gate.sc_target
where idmodul = 'siakad' and namafile is not null
and (softdelete = '0') and namafile in ('rep_krsmahasiswa', 'rep_kartuujian', 'rep_khsmahasiswa', 'rep_transkripsmt', 'rep_transkrip', 'rep_ijazah') order by namafile
(6.6 KB)
0.0003
select idtarget, namafile from gate.sc_target
where idmodul = 'siakad' and namafile is not null
and (softdelete = '0') and namafile in ('rep_krsmahasiswa', 'rep_kartuujian', 'rep_khsmahasiswa', 'rep_transkripsmt', 'rep_transkrip', 'rep_ijazah') order by namafile
(6.6 KB)
0.0001
SELECT namafile FROM gate.sc_target WHERE idtarget = '546' LIMIT 1
(6.38 KB)
0.0001
SELECT namafile FROM gate.sc_target WHERE idtarget = '546' LIMIT 1
(6.38 KB)
0.0005
select idperiode as key,namaperiode as value from (select *, substr(idperiode,5,1) as idsemester from ref.ms_periode where 1=1 order by idperiode desc) x
(6.48 KB)
siakadcloud.data.key.siakadv1-product.a1a5659f76f229e13db40eb18d13194b cache failure: Item with such key doesn't exist on the memcache server. (this is a notice and not an error)
0.0007
select r.canread, r.caninsert, r.canupdate, r.candelete, r.canvalidate, r.canother, t.idtarget, t.namatarget
from gate.sc_targetrole r
join gate.sc_target t on r.idtarget = t.idtarget
left join gate.sc_submodul s on t.idsubmodul = s.idsubmodul and (s.softdelete = '0')
where t.idmodul = 'admin' and r.idrole = 'assvm'
and t.namafile = 'list_kustomisasiwordv2' and (s.idsubmodul is null or s.isaktif = '1')
and (r.softdelete = '0' and t.softdelete = '0')
(6.81 KB)
Failed to save data at the memcache server!
Cache write error
0.0001
select 1 from (select * from master.templateword_v2 where idtemplate = '185' and 1=1) x
(6.38 KB)
0.0001
select * from master.templateword_v2 where idtemplate = '185' and 1=1
(7.04 KB)
