SHOW TABLES FROM `wonolelo`
0.0021 sec
CREATE TABLE IF NOT EXISTS `app_activity_reactions` (
`id` INT(11) NOT NULL AUTO_INCREMENT,
`activity_key` CHAR(40) NOT NULL,
`id_penduduk` INT(11) NOT NULL,
`id_pamong` INT(11) DEFAULT NULL,
`reaction` TINYINT(1) NOT NULL,
`created_at` DATETIME NOT NULL,
`updated_at` DATETIME NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `uniq_activity_user` (`activity_key`, `id_penduduk`),
KEY `idx_activity_key` (`activity_key`),
KEY `idx_id_penduduk` (`id_penduduk`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
0.0005 sec
SHOW COLUMNS FROM `tweb_desa_pamong_status`
0.0006 sec
SHOW COLUMNS FROM `tweb_desa_pamong_status`
0.0005 sec
SHOW COLUMNS FROM `tweb_desa_pamong_status`
0.0004 sec
SHOW COLUMNS FROM `surat_keluar`
0.0006 sec
SHOW COLUMNS FROM `surat_keluar`
0.0005 sec
SHOW COLUMNS FROM `surat_keluar`
0.0007 sec
SELECT pamong_id, nama, jabatan, foto FROM (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) AS p WHERE pamong_id = 24 LIMIT 1
0.0006 sec
SELECT *
FROM (
SELECT
CONVERT ( '1' USING utf8 ) AS `kode`,
CONVERT ( `v`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( `p`.`status` USING utf8 ) AS `status`,
CONVERT ( `p`.`gambar` USING utf8 ) AS `gambar`,
CONVERT ( `p`.`waktu` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`p`.`waktu`
) USING utf8 ) AS `lalu`
FROM (
(
SELECT
`s`.`telepon` AS `telepon`,
`s`.`status` AS `status`,
IFNULL (`p`.`status`, '') AS `gambar`,
`s`.`waktu` AS `waktu`
FROM
`tweb_desa_pamong_status` `s`
LEFT JOIN `tweb_desa_pamong_status_photo` `p`
ON `s`.`telepon` = `p`.`telepon`
AND s.`id` = p.`id_status`
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' GROUP BY `p`.`telepon`,
`p`.`waktu`
) as `p`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (CONVERT(`p`.`telepon` USING utf8) = `v`.`telepon`))
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '2' USING utf8 ) AS `kode`,
CONVERT ( `p`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `p`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `p`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `p`.`foto` USING utf8 ) AS `foto`,
CONVERT ( 'Presensi di Alat' USING utf8 ) AS `status`,
CONVERT ( `h`.`image` USING utf8 ) AS `gambar`,
CONVERT ( `h`.`checktime` USING utf8 ) AS `waktu`
,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`h`.`checktime`
) USING utf8 ) AS `lalu`
FROM ( (
SELECT
`c`.`userid` AS `userid`,
`c`.`checktime` AS `checktime`,
ifnull(`c`.`image`,'') as `image`
FROM `checkinout` `c`
WHERE 1
and DATE(`c`.`checktime`) BETWEEN '2026-09-26' AND '2026-10-02' ) as `h`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `p`
ON (`h`.`userid` = `p`.`kode` COLLATE utf8_unicode_ci))
union
SELECT
CONVERT ( '3' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_masuk` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_masuk` `s`
ON (`m`.`id_surat_masuk` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '4' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_keluar` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_keluar` `s`
ON (`m`.`id_surat_keluar` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1
and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '5' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_tugas` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_tugas` `s`
ON (`m`.`id_surat_tugas` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' order by waktu desc ) AS activity
WHERE 1 = 1 AND CAST(activity.pamong_id AS UNSIGNED) = 24
ORDER BY activity.waktu DESC
LIMIT 9 OFFSET 0
0.0348 sec
SELECT activity_key, SUM(CASE WHEN reaction = 1 THEN 1 ELSE 0 END) AS like_count, SUM(CASE WHEN reaction = -1 THEN 1 ELSE 0 END) AS dislike_count
FROM `app_activity_reactions`
WHERE `activity_key` IN('2bf41d04a0293249e681860bb9178e54e50900b6', '95262c7c873edf9ebb27de0bbacc9ebd4f09fbfe', 'a741a0874912d0697b991bd6fb6cb918d0962036', '46149137d9e0321e0b078b4b4e961c7de39091cd', '62b9582647c0d0a184911f17c706c7d376a46059', 'a3d911979f82a94d9e50fdcb3c944a3a114b1c4c', '3131959ec5333487039d7d41db71896bc32acb82')
GROUP BY `activity_key`
0.0008 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0003 sec
SELECT `s`.`id`
FROM `tweb_desa_pamong_status` `s`
INNER JOIN `tweb_desa_pamong` `p` ON `p`.`pamong_id` = 24
INNER JOIN `tweb_penduduk` `pen` ON `pen`.`id` = `p`.`id_pend` AND `pen`.`telepon` = `s`.`telepon`
WHERE `p`.`pamong_id` = 24
AND `s`.`waktu` = '2026-09-30 13:50:13'
ORDER BY `s`.`id` DESC
LIMIT 1
0.0005 sec
SELECT `s`.`id`, `s`.`id_poin`, `s`.`poin_set_role`, `s`.`poin_set_by`, `s`.`poin_set_at`, `k`.`nama` AS `poin_nama`, `k`.`poin`, `p`.`jabatan` AS `poin_set_jabatan`
FROM `tweb_desa_pamong_status` `s`
LEFT JOIN `klasifikasi_poin` `k` ON `k`.`id` = `s`.`id_poin`
LEFT JOIN `tweb_desa_pamong` `p` ON `p`.`pamong_id` = `s`.`poin_set_by`
WHERE `s`.`id` = 3611
0.0005 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0005 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0003 sec
SELECT `s`.`id`
FROM `tweb_desa_pamong_status` `s`
INNER JOIN `tweb_desa_pamong` `p` ON `p`.`pamong_id` = 24
INNER JOIN `tweb_penduduk` `pen` ON `pen`.`id` = `p`.`id_pend` AND `pen`.`telepon` = `s`.`telepon`
WHERE `p`.`pamong_id` = 24
AND `s`.`waktu` = '2026-09-28 08:42:41'
ORDER BY `s`.`id` DESC
LIMIT 1
0.0006 sec
SELECT `s`.`id`, `s`.`id_poin`, `s`.`poin_set_role`, `s`.`poin_set_by`, `s`.`poin_set_at`, `k`.`nama` AS `poin_nama`, `k`.`poin`, `p`.`jabatan` AS `poin_set_jabatan`
FROM `tweb_desa_pamong_status` `s`
LEFT JOIN `klasifikasi_poin` `k` ON `k`.`id` = `s`.`id_poin`
LEFT JOIN `tweb_desa_pamong` `p` ON `p`.`pamong_id` = `s`.`poin_set_by`
WHERE `s`.`id` = 3604
0.0004 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0005 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status_poin'
LIMIT 1
0.0003 sec
SELECT activity.kode, COUNT(*) AS total
FROM (
SELECT
CONVERT ( '1' USING utf8 ) AS `kode`,
CONVERT ( `v`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( `p`.`status` USING utf8 ) AS `status`,
CONVERT ( `p`.`gambar` USING utf8 ) AS `gambar`,
CONVERT ( `p`.`waktu` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`p`.`waktu`
) USING utf8 ) AS `lalu`
FROM (
(
SELECT
`s`.`telepon` AS `telepon`,
`s`.`status` AS `status`,
IFNULL (`p`.`status`, '') AS `gambar`,
`s`.`waktu` AS `waktu`
FROM
`tweb_desa_pamong_status` `s`
LEFT JOIN `tweb_desa_pamong_status_photo` `p`
ON `s`.`telepon` = `p`.`telepon`
AND s.`id` = p.`id_status`
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' GROUP BY `p`.`telepon`,
`p`.`waktu`
) as `p`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (CONVERT(`p`.`telepon` USING utf8) = `v`.`telepon`))
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '2' USING utf8 ) AS `kode`,
CONVERT ( `p`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `p`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `p`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `p`.`foto` USING utf8 ) AS `foto`,
CONVERT ( 'Presensi di Alat' USING utf8 ) AS `status`,
CONVERT ( `h`.`image` USING utf8 ) AS `gambar`,
CONVERT ( `h`.`checktime` USING utf8 ) AS `waktu`
,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`h`.`checktime`
) USING utf8 ) AS `lalu`
FROM ( (
SELECT
`c`.`userid` AS `userid`,
`c`.`checktime` AS `checktime`,
ifnull(`c`.`image`,'') as `image`
FROM `checkinout` `c`
WHERE 1
and DATE(`c`.`checktime`) BETWEEN '2026-09-26' AND '2026-10-02' ) as `h`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `p`
ON (`h`.`userid` = `p`.`kode` COLLATE utf8_unicode_ci))
union
SELECT
CONVERT ( '3' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_masuk` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_masuk` `s`
ON (`m`.`id_surat_masuk` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '4' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_keluar` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_keluar` `s`
ON (`m`.`id_surat_keluar` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1
and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '5' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_tugas` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_tugas` `s`
ON (`m`.`id_surat_tugas` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' order by waktu desc ) AS activity
WHERE 1 = 1 AND CAST(activity.pamong_id AS UNSIGNED) = 24
GROUP BY activity.kode
0.0335 sec
SELECT COUNT(DISTINCT activity.pamong_id) AS total
FROM (
SELECT
CONVERT ( '1' USING utf8 ) AS `kode`,
CONVERT ( `v`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( `p`.`status` USING utf8 ) AS `status`,
CONVERT ( `p`.`gambar` USING utf8 ) AS `gambar`,
CONVERT ( `p`.`waktu` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`p`.`waktu`
) USING utf8 ) AS `lalu`
FROM (
(
SELECT
`s`.`telepon` AS `telepon`,
`s`.`status` AS `status`,
IFNULL (`p`.`status`, '') AS `gambar`,
`s`.`waktu` AS `waktu`
FROM
`tweb_desa_pamong_status` `s`
LEFT JOIN `tweb_desa_pamong_status_photo` `p`
ON `s`.`telepon` = `p`.`telepon`
AND s.`id` = p.`id_status`
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' GROUP BY `p`.`telepon`,
`p`.`waktu`
) as `p`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (CONVERT(`p`.`telepon` USING utf8) = `v`.`telepon`))
WHERE 1 and DATE(p.`waktu`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '2' USING utf8 ) AS `kode`,
CONVERT ( `p`.`pamong_id` USING utf8 ) AS `pamong_id`,
CONVERT ( `p`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `p`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `p`.`foto` USING utf8 ) AS `foto`,
CONVERT ( 'Presensi di Alat' USING utf8 ) AS `status`,
CONVERT ( `h`.`image` USING utf8 ) AS `gambar`,
CONVERT ( `h`.`checktime` USING utf8 ) AS `waktu`
,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`h`.`checktime`
) USING utf8 ) AS `lalu`
FROM ( (
SELECT
`c`.`userid` AS `userid`,
`c`.`checktime` AS `checktime`,
ifnull(`c`.`image`,'') as `image`
FROM `checkinout` `c`
WHERE 1
and DATE(`c`.`checktime`) BETWEEN '2026-09-26' AND '2026-10-02' ) as `h`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `p`
ON (`h`.`userid` = `p`.`kode` COLLATE utf8_unicode_ci))
union
SELECT
CONVERT ( '3' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_masuk` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_masuk` `s`
ON (`m`.`id_surat_masuk` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '4' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_keluar` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_keluar` `s`
ON (`m`.`id_surat_keluar` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1
and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' union
SELECT
CONVERT ( '5' USING utf8 ) AS `kode`,
CONVERT ( `m`.`id_desa_pamong` USING utf8 ) AS `pamong_id`,
CONVERT ( `v`.`nama` USING utf8 ) AS `nama`,
CONVERT ( `v`.`jabatan` USING utf8 ) AS `jabatan`,
CONVERT ( `v`.`foto` USING utf8 ) AS `foto`,
CONVERT ( CONCAT(`s`.`isi_singkat`,'
',`t`.`status`) USING utf8 ) AS `status`,
CONVERT ( `m`.`link` USING utf8 ) AS `gambar`,
CONVERT ( `m`.`waktu_update` USING utf8 ) AS `waktu`,
CONVERT ( TIMEDIFF (
CURRENT_TIMESTAMP (),
`m`.`waktu_update`
) USING utf8 ) AS `lalu`
FROM (((`disposisi_surat_tugas` `m`
LEFT JOIN (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as `v`
ON (`m`.`id_desa_pamong` = `v`.`pamong_id`))
LEFT JOIN `surat_tugas` `s`
ON (`m`.`id_surat_tugas` = `s`.`id`))
LEFT JOIN `status_tugas` `t`
ON (`m`.`id_status` = `t`.`id`))
WHERE 1 and DATE(`m`.`waktu_update`) BETWEEN '2026-09-26' AND '2026-10-02' order by waktu desc ) AS activity
WHERE 1 = 1 AND CAST(activity.pamong_id AS UNSIGNED) = 24
AND activity.pamong_id IS NOT NULL
AND activity.pamong_id <> ''
0.0320 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tampil_tukin_rupiah'
LIMIT 1
0.0005 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'poin_presensi_masuk'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'poin_presensi_keluar'
LIMIT 1
0.0003 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'poin_presensi_terlambat'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'poin_terlambat_pulang_diperbolehkan'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_presensi'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja'
LIMIT 1
0.0002 sec
SELECT *
FROM `tukin_bulanan`
WHERE `pamong_id` = 24
AND `bulan` = 10
AND `tahun` = 2026
0.0006 sec
SELECT `tanggal`
FROM `kehadiran_harian`
WHERE `pamong_id` = 24
AND `tanggal` >= '2026-10-01'
AND `tanggal` <= '2026-10-02'
0.0005 sec
SELECT
CONCAT(REPLACE('2026-10-01', '-', ''), p.pamong_id) AS id,
p.pamong_id,
p.pamong_niap AS userid,
'2026-10-01' AS tanggal,
-- JADWAL UTAMA
COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
) AS jadwal_masuk,
COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) AS jadwal_keluar,
-- BOLEH ABSEN (Gunakan Matematika Detik agar tidak NULL)
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
)) - (COALESCE(NULLIF(jkp.boleh_absen, 0), NULLIF(jam.boleh_absen, 0), 60) * 60) ) AS boleh_masuk,
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
)) + (COALESCE(NULLIF(jkp.boleh_absen_pulang, 0), NULLIF(jam.boleh_absen_pulang, 0), 150) * 60) ) AS boleh_keluar,
IFNULL(jkp.lintas_hari, 0) AS lintas_hari,
-- REALITA ABSENSI
MIN(CASE WHEN TIME(h.checktime) <= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_masuk,
MAX(CASE WHEN TIME(h.checktime) >= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_keluar
FROM tweb_desa_pamong p
LEFT JOIN kehadiran_jam_kerja jam ON DAYOFWEEK('2026-10-01') = jam.id
LEFT JOIN kehadiran_periode kp ON '2026-10-01' BETWEEN kp.tanggal_mulai AND kp.tanggal_selesai AND kp.aktif = 1
LEFT JOIN kehadiran_jam_kerja_periode jkp ON jkp.periode_id = kp.id
AND jkp.jabatan_id = p.jabatan_id AND jkp.hari = DAYOFWEEK('2026-10-01')
LEFT JOIN checkinout h ON h.userid = p.pamong_niap
AND h.checktime >= '2026-10-01 00:00:00'
AND h.checktime < DATE_ADD('2026-10-01', INTERVAL 1 DAY)
WHERE p.pamong_id IS NOT NULL AND p.pamong_id = 24
GROUP BY p.pamong_id, p.pamong_niap
0.0009 sec
INSERT INTO kehadiran_harian (`pamong_id`,`userid`,`tanggal`,`jadwal_masuk`,`boleh_masuk`,`jadwal_keluar`,`boleh_keluar`,`jam_masuk`,`jam_keluar`,`lintas_hari`) VALUES (24,'24','2026-10-01','07:30:00','06:30:00','15:30:00','18:00:00',NULL,NULL,0)
ON DUPLICATE KEY UPDATE userid = VALUES(userid), jadwal_masuk = VALUES(jadwal_masuk), boleh_masuk = VALUES(boleh_masuk), jadwal_keluar = VALUES(jadwal_keluar), boleh_keluar = VALUES(boleh_keluar), jam_masuk = VALUES(jam_masuk), jam_keluar = VALUES(jam_keluar), lintas_hari = VALUES(lintas_hari)
0.0017 sec
SELECT
CONCAT(REPLACE('2026-10-02', '-', ''), p.pamong_id) AS id,
p.pamong_id,
p.pamong_niap AS userid,
'2026-10-02' AS tanggal,
-- JADWAL UTAMA
COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
) AS jadwal_masuk,
COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) AS jadwal_keluar,
-- BOLEH ABSEN (Gunakan Matematika Detik agar tidak NULL)
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
)) - (COALESCE(NULLIF(jkp.boleh_absen, 0), NULLIF(jam.boleh_absen, 0), 60) * 60) ) AS boleh_masuk,
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
)) + (COALESCE(NULLIF(jkp.boleh_absen_pulang, 0), NULLIF(jam.boleh_absen_pulang, 0), 150) * 60) ) AS boleh_keluar,
IFNULL(jkp.lintas_hari, 0) AS lintas_hari,
-- REALITA ABSENSI
MIN(CASE WHEN TIME(h.checktime) <= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_masuk,
MAX(CASE WHEN TIME(h.checktime) >= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_keluar
FROM tweb_desa_pamong p
LEFT JOIN kehadiran_jam_kerja jam ON DAYOFWEEK('2026-10-02') = jam.id
LEFT JOIN kehadiran_periode kp ON '2026-10-02' BETWEEN kp.tanggal_mulai AND kp.tanggal_selesai AND kp.aktif = 1
LEFT JOIN kehadiran_jam_kerja_periode jkp ON jkp.periode_id = kp.id
AND jkp.jabatan_id = p.jabatan_id AND jkp.hari = DAYOFWEEK('2026-10-02')
LEFT JOIN checkinout h ON h.userid = p.pamong_niap
AND h.checktime >= '2026-10-02 00:00:00'
AND h.checktime < DATE_ADD('2026-10-02', INTERVAL 1 DAY)
WHERE p.pamong_id IS NOT NULL AND p.pamong_id = 24
GROUP BY p.pamong_id, p.pamong_niap
0.0009 sec
INSERT INTO kehadiran_harian (`pamong_id`,`userid`,`tanggal`,`jadwal_masuk`,`boleh_masuk`,`jadwal_keluar`,`boleh_keluar`,`jam_masuk`,`jam_keluar`,`lintas_hari`) VALUES (24,'24','2026-10-02','07:30:00','06:30:00','15:30:00','18:00:00',NULL,NULL,0)
ON DUPLICATE KEY UPDATE userid = VALUES(userid), jadwal_masuk = VALUES(jadwal_masuk), boleh_masuk = VALUES(boleh_masuk), jadwal_keluar = VALUES(jadwal_keluar), boleh_keluar = VALUES(boleh_keluar), jam_masuk = VALUES(jam_masuk), jam_keluar = VALUES(jam_keluar), lintas_hari = VALUES(lintas_hari)
0.0012 sec
SELECT SUM(IF(l.tanggal IS NOT NULL, 0, IFNULL(k.status, 0))) AS total
FROM a_calendar AS c
LEFT JOIN kehadiran_jam_kerja AS k ON c.day_week = k.id
LEFT JOIN kehadiran_hari_libur AS l ON c.tanggal = l.tanggal
WHERE c.tanggal BETWEEN '2026-10-01' AND '2026-10-02'
0.0002 sec
SELECT tanggal, jam_masuk AS masuk, jam_keluar AS pulang, IF(jam_masuk IS NOT NULL AND jadwal_masuk IS NOT NULL AND jam_masuk > jadwal_masuk, 1, 0) AS terlambat
FROM `kehadiran_harian`
WHERE `pamong_id` = 24
AND `tanggal` >= '2026-10-01'
AND `tanggal` <= '2026-10-02'
AND (jam_masuk IS NOT NULL OR jam_keluar IS NOT NULL)
ORDER BY `tanggal` DESC
0.0005 sec
SELECT `j`.`poin`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `ref_jabatan` `j` ON `p`.`jabatan_id` = `j`.`id`
WHERE `p`.`pamong_id` = 24
0.0004 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_dispo'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_log_surat'
LIMIT 1
0.0004 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_activity'
LIMIT 1
0.0003 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_status'
LIMIT 1
0.0002 sec
SELECT `value`
FROM `setting_aplikasi`
WHERE `key` = 'tukin_kinerja_sub_berita'
LIMIT 1
0.0002 sec
SELECT *
FROM (
SELECT
`p`.`pamong_id` AS `pamong_id`, `p`.`pamong_ub`, `p`.`pamong_ttd`, `p`.`is_wilayah`, `p`.`is_absen_hp`, IFNULL(p.`pamong_masajab`, '-') AS `masajab`, `pen`.`nama` AS `nama`, `p`.`jabatan` AS `jabatan`, `p`.`id_pend` AS `id_pend`, `pen`.`nik` AS `nik`, `p`.`pamong_niap` AS `kode`, `pen`.`telepon` AS `telepon`, `p`.`urut` AS `urut`, IFNULL(`pen`.`telegram`, '-') AS `telegram`, IFNULL(`u`.`id`, '0') AS `id_user`, IFNULL(CONCAT('https://wonolelo.sides.id/', 'desa/upload/user_pict/kecil_', `p`.`foto`), CONCAT('https://wonolelo.sides.id/', 'desa/upload/user_pict/kecil_', `pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' and `p`.`pamong_id`='24' order by urut asc ) as p
0.0006 sec
SELECT `tanggal`
FROM `kehadiran_harian`
WHERE `pamong_id` = 24
AND `tanggal` >= '2026-10-01'
AND `tanggal` <= '2026-10-31'
0.0004 sec
SELECT
CONCAT(REPLACE('2026-10-01', '-', ''), p.pamong_id) AS id,
p.pamong_id,
p.pamong_niap AS userid,
'2026-10-01' AS tanggal,
-- JADWAL UTAMA
COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
) AS jadwal_masuk,
COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) AS jadwal_keluar,
-- BOLEH ABSEN (Gunakan Matematika Detik agar tidak NULL)
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
)) - (COALESCE(NULLIF(jkp.boleh_absen, 0), NULLIF(jam.boleh_absen, 0), 60) * 60) ) AS boleh_masuk,
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
)) + (COALESCE(NULLIF(jkp.boleh_absen_pulang, 0), NULLIF(jam.boleh_absen_pulang, 0), 150) * 60) ) AS boleh_keluar,
IFNULL(jkp.lintas_hari, 0) AS lintas_hari,
-- REALITA ABSENSI
MIN(CASE WHEN TIME(h.checktime) <= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_masuk,
MAX(CASE WHEN TIME(h.checktime) >= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_keluar
FROM tweb_desa_pamong p
LEFT JOIN kehadiran_jam_kerja jam ON DAYOFWEEK('2026-10-01') = jam.id
LEFT JOIN kehadiran_periode kp ON '2026-10-01' BETWEEN kp.tanggal_mulai AND kp.tanggal_selesai AND kp.aktif = 1
LEFT JOIN kehadiran_jam_kerja_periode jkp ON jkp.periode_id = kp.id
AND jkp.jabatan_id = p.jabatan_id AND jkp.hari = DAYOFWEEK('2026-10-01')
LEFT JOIN checkinout h ON h.userid = p.pamong_niap
AND h.checktime >= '2026-10-01 00:00:00'
AND h.checktime < DATE_ADD('2026-10-01', INTERVAL 1 DAY)
WHERE p.pamong_id IS NOT NULL AND p.pamong_id = 24
GROUP BY p.pamong_id, p.pamong_niap
0.0002 sec
INSERT INTO kehadiran_harian (`pamong_id`,`userid`,`tanggal`,`jadwal_masuk`,`boleh_masuk`,`jadwal_keluar`,`boleh_keluar`,`jam_masuk`,`jam_keluar`,`lintas_hari`) VALUES (24,'24','2026-10-01','07:30:00','06:30:00','15:30:00','18:00:00',NULL,NULL,0)
ON DUPLICATE KEY UPDATE userid = VALUES(userid), jadwal_masuk = VALUES(jadwal_masuk), boleh_masuk = VALUES(boleh_masuk), jadwal_keluar = VALUES(jadwal_keluar), boleh_keluar = VALUES(boleh_keluar), jam_masuk = VALUES(jam_masuk), jam_keluar = VALUES(jam_keluar), lintas_hari = VALUES(lintas_hari)
0.0014 sec
SELECT
CONCAT(REPLACE('2026-10-02', '-', ''), p.pamong_id) AS id,
p.pamong_id,
p.pamong_niap AS userid,
'2026-10-02' AS tanggal,
-- JADWAL UTAMA
COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
) AS jadwal_masuk,
COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) AS jadwal_keluar,
-- BOLEH ABSEN (Gunakan Matematika Detik agar tidak NULL)
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_masuk, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_masuk, jam.jam_masuk_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_masuk, '')
)) - (COALESCE(NULLIF(jkp.boleh_absen, 0), NULLIF(jam.boleh_absen, 0), 60) * 60) ) AS boleh_masuk,
SEC_TO_TIME( TIME_TO_SEC(COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
)) + (COALESCE(NULLIF(jkp.boleh_absen_pulang, 0), NULLIF(jam.boleh_absen_pulang, 0), 150) * 60) ) AS boleh_keluar,
IFNULL(jkp.lintas_hari, 0) AS lintas_hari,
-- REALITA ABSENSI
MIN(CASE WHEN TIME(h.checktime) <= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_masuk,
MAX(CASE WHEN TIME(h.checktime) >= COALESCE(
NULLIF(NULLIF(jkp.jam_keluar, ''), '00:00:00'),
NULLIF(NULLIF(IF(p.is_wilayah = 0, jam.jam_keluar, jam.jam_keluar_wilayah), ''), '00:00:00'),
NULLIF(jam.jam_keluar, '')
) THEN TIME(h.checktime) END) AS jam_keluar
FROM tweb_desa_pamong p
LEFT JOIN kehadiran_jam_kerja jam ON DAYOFWEEK('2026-10-02') = jam.id
LEFT JOIN kehadiran_periode kp ON '2026-10-02' BETWEEN kp.tanggal_mulai AND kp.tanggal_selesai AND kp.aktif = 1
LEFT JOIN kehadiran_jam_kerja_periode jkp ON jkp.periode_id = kp.id
AND jkp.jabatan_id = p.jabatan_id AND jkp.hari = DAYOFWEEK('2026-10-02')
LEFT JOIN checkinout h ON h.userid = p.pamong_niap
AND h.checktime >= '2026-10-02 00:00:00'
AND h.checktime < DATE_ADD('2026-10-02', INTERVAL 1 DAY)
WHERE p.pamong_id IS NOT NULL AND p.pamong_id = 24
GROUP BY p.pamong_id, p.pamong_niap
0.0003 sec
INSERT INTO kehadiran_harian (`pamong_id`,`userid`,`tanggal`,`jadwal_masuk`,`boleh_masuk`,`jadwal_keluar`,`boleh_keluar`,`jam_masuk`,`jam_keluar`,`lintas_hari`) VALUES (24,'24','2026-10-02','07:30:00','06:30:00','15:30:00','18:00:00',NULL,NULL,0)
ON DUPLICATE KEY UPDATE userid = VALUES(userid), jadwal_masuk = VALUES(jadwal_masuk), boleh_masuk = VALUES(boleh_masuk), jadwal_keluar = VALUES(jadwal_keluar), boleh_keluar = VALUES(boleh_keluar), jam_masuk = VALUES(jam_masuk), jam_keluar = VALUES(jam_keluar), lintas_hari = VALUES(lintas_hari)
0.0012 sec
SELECT tanggal, jam_masuk AS masuk, jam_keluar AS pulang
FROM `kehadiran_harian`
WHERE `pamong_id` = 24
AND `tanggal` >= '2026-10-01'
AND `tanggal` <= '2026-10-31'
0.0006 sec
SELECT DATE(waktu) AS tanggal, COUNT(*) AS total
FROM `tweb_desa_pamong_status`
WHERE `telepon` = '087838332945'
AND DATE(waktu) >= '2026-10-01'
AND DATE(waktu) <= '2026-10-31'
GROUP BY DATE(waktu)
0.0014 sec
SELECT DATE(checktime) AS tanggal, COUNT(*) AS total
FROM `checkinout_activity`
WHERE `pamong_id` = 24
AND DATE(checktime) >= '2026-10-01'
AND DATE(checktime) <= '2026-10-31'
GROUP BY DATE(checktime)
0.0099 sec
SELECT DATE(tanggal) AS tanggal, COUNT(*) AS total
FROM `log_surat`
WHERE `id_pamong` = 24
AND DATE(tanggal) >= '2026-10-01'
AND DATE(tanggal) <= '2026-10-31'
GROUP BY DATE(tanggal)
0.0014 sec
SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa
FROM `config` `c`
LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id`
LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id`
0.0006 sec
SELECT `a`.`id`, `a`.`judul`, `a`.`isi`, `a`.`gambar`, `a`.`tgl_upload`, `u`.`nama` AS `penulis`
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `u`.`id` = `a`.`id_user`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` <> 1000
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0003 sec
1.5950 sec
4.12MB
Request : app/aktivitas_pamong
Database
N/A
Libraries (16)
Helpers (17)
Views (5) 
Configuration 
Session 
Models (36)