Desa Pandansari
Kec. Kejobong
Kab. Purbalingga - Jawa Tengah
Belum ada agenda terdata
20 November 2025
PENILAIAN DESA ANTI KORUPSI TINGKAT KABUPATEN PURBALINGGA TAHUN 2025...
18 November 2025
APEL PAGI APARATUR PEMERINTAH DESA PANDANSARI...
14 November 2025
SOSIALISASI TENTANG UPAYA PENCEGAHAN TERJADINYA TINDAK PIDANA KORUPSI...
14 November 2025
WARGA DESA PANDANSARI LAKSANAKAN KERJA BHAKTI ...
11 November 2025
SOSIALISASI SEMBILAN NILAI INTEGRITAS ANTI KORUPSI...
Transparansi Anggaran
APBDes 2025 Pelaksanaan
Pendapatan
| Anggaran | Realisasi |
| Rp 2.449.707.000,00 | Rp 1.938.980.159,00 |
Belanja
| Anggaran | Realisasi |
| Rp 2.111.600.209,00 | Rp 1.185.901.099,00 |
Pembiayaan
| Anggaran | Realisasi |
| Rp 583.244.994,00 | Rp 583.244.994,00 |
APBDes 2025 Pendapatan
Hasil Usaha Desa
| Anggaran | Realisasi |
| Rp 10.000.000,00 | Rp 0,00 |
Dana Desa
| Anggaran | Realisasi |
| Rp 1.002.443.000,00 | Rp 1.002.443.000,00 |
Bagi Hasil Pajak Dan Retribusi
| Anggaran | Realisasi |
| Rp 41.786.000,00 | Rp 25.071.600,00 |
Alokasi Dana Desa
| Anggaran | Realisasi |
| Rp 688.578.000,00 | Rp 678.311.020,00 |
Bantuan Keuangan Provinsi
| Anggaran | Realisasi |
| Rp 500.000.000,00 | Rp 100.000.000,00 |
Bantuan Keuangan Kabupaten/kota
| Anggaran | Realisasi |
| Rp 200.000.000,00 | Rp 130.000.000,00 |
Penerimaan Dari Hasil Kerjasama Antar Desa
| Anggaran | Realisasi |
| Rp 6.650.000,00 | Rp 3.151.546,00 |
Bunga Bank
| Anggaran | Realisasi |
| Rp 250.000,00 | Rp 2.993,00 |
APBDes 2025 Pembelanjaan
Bidang Penyelenggaran Pemerintahan Desa
| Anggaran | Realisasi |
| Rp 762.983.499,00 | Rp 618.628.099,00 |
Bidang Pelaksanaan Pembangunan Desa
| Anggaran | Realisasi |
| Rp 1.187.472.510,00 | Rp 457.043.000,00 |
Bidang Pembinaan Kemasyarakatan Desa
| Anggaran | Realisasi |
| Rp 87.695.000,00 | Rp 53.830.000,00 |
Bidang Pemberdayaan Masyarakat Desa
| Anggaran | Realisasi |
| Rp 6.900.000,00 | Rp 2.400.000,00 |
Bidang Penanggulangan Bencana, Darurat Dan Mendesak Desa
| Anggaran | Realisasi |
| Rp 66.549.200,00 | Rp 54.000.000,00 |
Lokasi Kantor Desa
| Latitude | : | -7.4115482 |
| Longitude | : | 109.4830406 |
Desa Pandansari , Kecamatan Kejobong , Kabupaten Purbalingga - Jawa Tengah
Wilayah Desa
CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
1.5181 secLoading Time: Base Classes : 0.0032 sec
Controller Execution Time ( Idm / Index ) : 1.3343 sec
11.63MB
Request : idm/indexMethod : GET
DatabaseHost:localhost/pans5277_pandansari
SHOW TABLES FROM `pans5277_pandansari` 0.0021 sec
SHOW DATABASES 0.0157 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'pans5277_pandansari' AND table_name = 'user' 0.0003 sec
SHOW COLUMNS FROM `anjungan` 0.0008 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.216.26' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'status-idm/2023' AND `enabled` = 1 0.0004 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0003 sec
SHOW COLUMNS FROM `widget` 0.0009 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0004 sec
SHOW COLUMNS FROM `sys_traffic` 0.0008 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-11-29' 0.0003 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-11-28' AND ( `config_id` = 1 ) 0.0005 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0018 sec
SHOW COLUMNS FROM `menu` 0.0007 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '32' 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '101' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '85' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0005 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '93' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '92' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '37' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '62' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '65' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '64' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '97' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '120' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '124' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'drppa' OR `slug` = 'drppa' ) 0.0004 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '128' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'perdes-tentang-drppa' OR `slug` = 'perdes-tentang-drppa' ) 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'anti-korupsi' OR `slug` = 'anti-korupsi' ) 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '129' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'tata-laksana' OR `slug` = 'tata-laksana' ) 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'pengawasan' OR `slug` = 'pengawasan' ) 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'kualitas-pelayanan-publik' OR `slug` = 'kualitas-pelayanan-publik' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'partisipasi-masyarakat' OR `slug` = 'partisipasi-masyarakat' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'kearifan-lokal' OR `slug` = 'kearifan-lokal' ) 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '135' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '23' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '24' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0004 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0004 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload` FROM `teks_berjalan` `t` LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id` WHERE ( `t`.`config_id` = 1 ) AND `tipe` = 1 AND `status` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2025-11-29 20:50:46' UNION SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar1` != '' AND `tgl_upload` < '2025-11-29 20:50:46' UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar2` != '' AND `tgl_upload` < '2025-11-29 20:50:46') UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar3` != '' AND `tgl_upload` < '2025-11-29 20:50:46')ORDER BY RAND() LIMIT 10 0.0019 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0005 sec
SELECT `id` FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `slider` = 1 LIMIT 1 0.0003 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0004 sec
SELECT `id`, `nama` as `judul`, `gambar` FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `parrent` = '55' AND `tipe` = 2 AND `enabled` = 1 0.0002 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `config` 0.0007 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0005 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0004 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) = CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) > CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' ORDER BY `g`.`tgl_agenda` 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) < CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0008 sec
SHOW COLUMNS FROM `komentar` 0.0007 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.* FROM `komentar` `k` JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id` WHERE ( `k`.`config_id` = 1 ) AND `k`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0007 sec
SHOW COLUMNS FROM `media_sosial` 0.0009 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0010 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:46' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0037 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:46' ORDER BY `a`.`hit` DESC LIMIT 7 0.0031 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:46' ORDER BY rand() LIMIT 7 0.0043 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0005 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama FROM `tweb_desa_pamong` `dp` LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend` LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id` WHERE ( `dp`.`config_id` = 1 ) AND `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0005 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1 LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0087 sec
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE ( `b`.`config_id` = 1 ) 0.0047 sec
SHOW COLUMNS FROM `widget` 0.0008 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0005 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT `Tahun` FROM `keuangan_manual_rinci` WHERE ( `config_id` = 1 ) GROUP BY `Tahun` ORDER BY `Tahun` DESC 0.0002 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_manual_ref_rek1` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `keuangan_manual_rinci`.`Tahun` = '2025' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0003 sec
SELECT `keuangan_manual_ref_rek3`.`Jenis`, `keuangan_manual_ref_rek3`.`Nama_Jenis` FROM `keuangan_manual_ref_rek3` WHERE `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' ORDER BY `keuangan_manual_ref_rek3`.`Jenis` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0003 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_manual_ref_bidang` WHERE `Kd_Bid` NOT LIKE '01%' ORDER BY `Kd_Bid` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0004 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0003 sec
SHOW COLUMNS FROM `sys_traffic` 0.0005 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-11-29' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-11-28' AND ( `config_id` = 1 ) 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0014 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '32' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '101' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '85' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '93' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '92' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '37' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '62' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '65' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '64' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '97' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '120' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '124' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'drppa' OR `slug` = 'drppa' ) 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '128' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'perdes-tentang-drppa' OR `slug` = 'perdes-tentang-drppa' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'anti-korupsi' OR `slug` = 'anti-korupsi' ) 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0005 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '129' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'tata-laksana' OR `slug` = 'tata-laksana' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'pengawasan' OR `slug` = 'pengawasan' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'kualitas-pelayanan-publik' OR `slug` = 'kualitas-pelayanan-publik' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'partisipasi-masyarakat' OR `slug` = 'partisipasi-masyarakat' ) 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'kearifan-lokal' OR `slug` = 'kearifan-lokal' ) 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '135' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0004 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '23' ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0005 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '24' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0005 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0006 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload` FROM `teks_berjalan` `t` LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id` WHERE ( `t`.`config_id` = 1 ) AND `tipe` = 1 AND `status` = 1 ORDER BY `urut` 0.0005 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2025-11-29 20:50:47' UNION SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar1` != '' AND `tgl_upload` < '2025-11-29 20:50:47' UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar2` != '' AND `tgl_upload` < '2025-11-29 20:50:47') UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar3` != '' AND `tgl_upload` < '2025-11-29 20:50:47')ORDER BY RAND() LIMIT 10 0.0036 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0006 sec
SELECT `id` FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `slider` = 1 LIMIT 1 0.0003 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0007 sec
SELECT `id`, `nama` as `judul`, `gambar` FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `parrent` = '55' AND `tipe` = 2 AND `enabled` = 1 0.0004 sec
SHOW COLUMNS FROM `widget` 0.0007 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0005 sec
SHOW COLUMNS FROM `config` 0.0006 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0006 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) = CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) > CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' ORDER BY `g`.`tgl_agenda` 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) < CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0006 sec
SHOW COLUMNS FROM `komentar` 0.0005 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.* FROM `komentar` `k` JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id` WHERE ( `k`.`config_id` = 1 ) AND `k`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0005 sec
SHOW COLUMNS FROM `media_sosial` 0.0007 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0006 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:47' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0036 sec
SHOW COLUMNS FROM `artikel` 0.0009 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:47' ORDER BY `a`.`hit` DESC LIMIT 7 0.0019 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-11-29 20:50:47' ORDER BY rand() LIMIT 7 0.0053 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0006 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama FROM `tweb_desa_pamong` `dp` LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend` LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id` WHERE ( `dp`.`config_id` = 1 ) AND `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0005 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1 LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0114 sec
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE ( `b`.`config_id` = 1 ) 0.0055 sec
SHOW COLUMNS FROM `widget` 0.0006 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0004 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0006 sec
SELECT `Tahun` FROM `keuangan_manual_rinci` WHERE ( `config_id` = 1 ) GROUP BY `Tahun` ORDER BY `Tahun` DESC 0.0003 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_manual_ref_rek1` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `keuangan_manual_rinci`.`Tahun` = '2025' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SELECT `keuangan_manual_ref_rek3`.`Jenis`, `keuangan_manual_ref_rek3`.`Nama_Jenis` FROM `keuangan_manual_ref_rek3` WHERE `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' ORDER BY `keuangan_manual_ref_rek3`.`Jenis` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0004 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_manual_ref_bidang` WHERE `Kd_Bid` NOT LIKE '01%' ORDER BY `Kd_Bid` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0005 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Anggaran) AS pagu FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci` 0.0007 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Realisasi) AS realisasi FROM `keuangan_manual_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2025' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0005 sec
Total Execution Time 0.1909 sec
Host:localhost_ORM/pans5277_pandansari
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 2.2600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.5800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 1.4800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.5200 sec
select * from `config` limit 1 0.4000 sec
select count(*) as aggregate from `config` 0.3100 sec
select count(*) as aggregate from `config` 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'setting_aplikasi' 0.9900 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 1.8900 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.9300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' 0.8600 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.2600 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' 0.5000 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.3400 sec
select count(*) as aggregate from `config` 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.4900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3000 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists` 0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan' 0.8400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan' 0.7100 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.5500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' 0.7300 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Sabtu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.3800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' 0.8300 sec
select id, nama_hari, jam_masuk, status, keterangan, date_add(jam_keluar, interval 10 minute) as jam_keluar from `kehadiran_jam_kerja` where `nama_hari` = 'Sabtu' and (time(`jam_masuk`) > '20:50' or date_add(jam_keluar, interval 10 minute) < '20:50') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.8000 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 1.1100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 1.2100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.7200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 1.0400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.9500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.4800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.4500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.5500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.5900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.5000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.5200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.4900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.8500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.6500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'tweb_desa_pamong' 1.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 1.0200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.5900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.9600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 20 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.5900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.8800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 40 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 41 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 43 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config' 0.7600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1 0.3100 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.5300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' 0.4700 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'tweb_desa_pamong' 1.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 1.0800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.7200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 20 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.7300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.6100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 40 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 41 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa' 0.5600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 43 and `tanggal` = '2025-11-29' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3400 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.5000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' 0.5200 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.2700 sec
Total Execution Time 83.9300 sec
84.1209 sec
N/A-
Libraries (16)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
MY_Upload
Output
Router
Security
Session
URI
User_agent
Utf8
Helpers (14)Cek_helper
Database_helper
Date_helper
Donjolib_helper
File_helper
Form_helper
General_helper
Language_helper
Opensid_helper
Pict_helper
Surat_helper
Text_helper
Url_helper
Utility_helper
Views (45) /home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/color.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/style.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/commons/meta.php
/home/pans5277/public_html/donjo-app/views/global/validasi_form.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/fbappid.php
/home/pans5277/public_html/donjo-app/views/head_tags_front.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/head_tags_front.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/preloader.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/headertop_right.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/icon.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/menu_mobile.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/change_color.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/identitas.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/aparatur_pop.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/lapor.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/partials/header_top.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/menu_v.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/sidemenu.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/leftpage.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/running.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/partials/idm/index.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/statistik.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/aparatur_desa.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/galeri.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/layanan_mandiri.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/commons/page_layout.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/event/infohari.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/menu_kategori.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/agenda.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/komentar.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/media_sosial.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/widgets/arsip_artikel.php
/home/pans5277/public_html/donjo-app/views/../../vendor/themes/natra/widgets/jam_kerja.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/partials/widgets.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/anggaran.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/map_bottom.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/commons/bottom_layout.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/commons/footer_isi.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/commons/footer.php
/home/pans5277/public_html/donjo-app/views/../../desa/themes/batuah_24_05/plus/print/print_set.php
Configuration trusted_hosts:Array ( )
base_url:https://mail.pandansari-purbalingga.desa.id/
index_page:index.php/
uri_protocol:REQUEST_URI
url_suffix:
language:indonesia
charset:UTF-8
enable_hooks:1
subclass_prefix:MY_
composer_autoload:vendor/autoload.php
permitted_uri_chars:a-z 0-9~%.:_\-
enable_query_strings:
controller_trigger:c
function_trigger:m
directory_trigger:d
allow_get_array:1
log_threshold:Array ( [0] => 1 [1] => 5 )
log_path:storage//logs/
clv_log_file_pattern:log-*.php
log_file_extension:
log_file_permissions:420
log_date_format:Y-m-d H:i:s
error_views_path:
cache_path:/home/pans5277/public_html/desa/cache/
cache_query_string:
encryption_key:lumbungkomunitas
sess_driver:files
sess_cookie_name:ci_session
sess_expiration:7200
sess_save_path:/tmp
sess_match_ip:
sess_time_to_update:300
sess_regenerate_destroy:
cookie_prefix:
cookie_domain:
cookie_path:/
cookie_secure:
cookie_httponly:
standardize_newlines:
global_xss_filtering:
csrf_protection:1
csrf_token_name:sidcsrf
csrf_cookie_name:sidcsrf
csrf_expire:7200
csrf_regenerate:1
csrf_exclude_uris:Array ( [0] => api.*+ )
compress_output:
time_reference:local
rewrite_short_tags:
proxy_ips:
nama_aplikasi:OpenSID
nama_lembaga:OpenDesa
fb_opendesa:https://www.facebook.com/groups/komunitasopendesa
tg_opendesa:https://t.me/komunitasopensidstop
tg_kontributor:https://t.me/+mi5ydVtVfmw0YWY1
github:https://github.com/OpenSID/OpenSID
website:https://opendesa.id
forum:https://forum.opendesa.id
youtube:https://www.youtube.com/KomunitasOpenSID-OpenDesa
server_pantau:https://pantau.opensid.my.id
token_pantau:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw
server_layanan:https://layanan.opendesa.id
rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest
api_idm:https://idm.kemendesa.go.id/open/api/desa/rumusan
api_sdgs:https://sid.kemendesa.go.id/sdgs/searching/score-sdgs?location_code=
api_hari_libur:https://raw.githubusercontent.com/guangrei/APIHariLibur_V2/main/holidays.json
api_google_recaptcha:https://google.com/recaptcha/api/
views_blade:resources/views/
cache_blade:storage/framework/views/
maximum_login_attempts:3
lockout_time:300
useDatabaseConfig:1
demo_mode:
demo_akun:Array ( [1] => 123456 [2] => 234561 [3] => 345612 )
demo_user:Array ( [username] => admin [password] => sid304 )
rentang_kirim_pesan:60
user_admin:1
07:1
kode_kota:1420
desa:Array ( [desa/anjungan/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/arsip/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/cache/] => Array ( [0] => 509 ) [desa/config/] => Array ( [0] => 509 ) [desa/logo/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/pengaturan/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/images/] => Array ( [0] => 509 ) [desa/template-surat/] => Array ( [0] => 509 ) [desa/template-surat/lampiran/] => Array ( [0] => 509 ) [desa/themes/] => Array ( [0] => 509 ) [desa/upload/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/fonts/] => Array ( [0] => 509 [1] => htaccess1 [2] => Array ( [0] => vendor/tecnickcom/tcpdf/fonts/helvetica.php ) ) [desa/upload/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/buku_tamu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dokumen/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/upload/galeri/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/area/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/garis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/point/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/produk/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/sinkronisasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/thumbs/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/user_pict/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/vaksin/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/widgets/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dtks/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )
lainnya:Array ( [storage/framework/] => Array ( [0] => 509 [1] => htaccess3 ) [storage/logs/] => Array ( [0] => 509 [1] => htaccess3 ) [backup_inkremental/] => Array ( [0] => 509 [1] => htaccess3 ) [assets/] => Array ( [0] => 493 [1] => htaccess3 ) [assets/kelola_file/] => Array ( [0] => 493 [1] => htaccess4 ) [assets/kelola_file/config/] => Array ( [0] => 493 [1] => htaccess4 ) )
config:<?php // ---------------------------------------------------------------------------- // Konfigurasi aplikasi dalam berkas ini merupakan setting konfigurasi tambahan // SID. Letakkan setting konfigurasi ini di desa/config/config.php. // ---------------------------------------------------------------------------- // Uncomment jika situs ini untuk demo. Pada demo, user admin tidak bisa dihapus // dan username/password tidak bisa diubah // $config['demo_mode'] = true; // Setting ini untuk menentukan user yang dipercaya. User dengan id di setting ini // dapat membuat artikel berisi video yang aktif ditampilkan di Web. // Misalnya, ganti dengan id = 1 jika ingin membuat pengguna admin sebagai pengguna terpecaya. $config['user_admin'] = 0; // Untuk menghindari masalah keamanan, Anda mungkin ingin mengonfigurasi daftar "host tepercaya". // Contoh: ['localhost', 'my-development.com', 'my-production.com', 'subdomain.domain.com'] $config['trusted_hosts'] = [];
database:<?php // ------------------------------------------------------------------------- // // Letakkan username, password dan database sebetulnya di file ini. // File ini JANGAN di-commit ke GIT. TAMBAHKAN di .gitignore // ------------------------------------------------------------------------- // Data Konfigurasi MySQL yang disesuaikan $db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'root'; $db['default']['password'] = ''; $db['default']['port'] = 3306; $db['default']['database'] = 'premium'; $db['default']['dbcollat'] = 'utf8_general_ci'; /* | Untuk setting koneksi database 'Strict Mode' | Sesuaikan dengan ketentuan hosting */ $db['default']['stricton'] = TRUE;
index_html:<html> <head> <title>403 Forbidden</title> </head> <body> <p>Directory access is forbidden.</p> </body> </html>
htaccess1:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess2:<FilesMatch "\.(rtf|pdf|jpe?g|png|php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess3:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg|pl|py|jsp|asp|htm|shtml|sh|cgi)$"> order allow,deny deny from all </FilesMatch>
htaccess4:<FilesMatch "\.(php)$"> order allow,deny allow from all </FilesMatch>
offline_mode:<!DOCTYPE html> <html> <head> <title>Offline Mode - <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?></title> <link rel="shortcut icon" href="<?= favico_desa() ?>"/> </head> <body> <br/><br/><br/> <div align="center"> <img class="profile-user-img img-responsive img-circle" src="<?= gambar_desa($main['logo']); ?>" alt="Logo"> <p> Selamat datang di Halaman Situs Resmi <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?><br/> Kami mohon maaf untuk sementara halaman tidak dapat di akses, dikarenakan sedang adanya perbaikan oleh tim terkait. </p> <p> Jika ada keperluan yang mendesak silakan langsung datang ke Kantor <?= ucwords($this->setting->sebutan_desa)?>.<br> Alamat : <?= $main['alamat_kantor'] ?><br> Email : <?= $main['email_desa'] ?><br> Telepon : <?= $main['telepon'] ?> </p> <p> <?= ucwords($pamong_kades['jabatan']).' '.$main['nama_desa'] ?> <br> <br> <br> <u><b><?= $main['nama_kepala_desa'] ?></b></u><br> NIP. <?= $main['nip_kepala_desa'] ?> </p> </div> </body> </html>
siteman_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
siteman_mandiri_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
folders:Array ( [storage.framework] => Array ( [name] => storage/framework [check] => Closure Object ( ) ) [storage.logs] => Array ( [name] => storage/logs [check] => Closure Object ( ) ) [backup_inkremental] => Array ( [name] => backup_inkremental/ [check] => Closure Object ( ) ) )
server:Array ( [php] => Array ( [name] => PHP Version [version] => >= 7.4.0 | < 8.0.0 [check] => Closure Object ( ) ) [pdo] => Array ( [name] => PDO [check] => Closure Object ( ) ) [curl] => Array ( [name] => Curl extention [check] => Closure Object ( ) ) [fileinfo] => Array ( [name] => Fileinfo extension [check] => Closure Object ( ) ) [gd] => Array ( [name] => GD extension [check] => Closure Object ( ) ) [iconv] => Array ( [name] => Iconv extension [check] => Closure Object ( ) ) [json] => Array ( [name] => Json extension [check] => Closure Object ( ) ) [mbstring] => Array ( [name] => Mbstring extension [check] => Closure Object ( ) ) [mysqli] => Array ( [name] => Mysqli extension [check] => Closure Object ( ) ) [mysqlnd] => Array ( [name] => Mysqlnd extension [check] => Closure Object ( ) ) [tidy] => Array ( [name] => Tidy extension [check] => Closure Object ( ) ) [zip] => Array ( [name] => Zip extension [check] => Closure Object ( ) ) [exif] => Array ( [name] => Exif extension [check] => Closure Object ( ) ) )
Session __ci_last_regenerate:1764424238
artikel:Array ( )
pengunjungOnline:2025-11-29
Models (33)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_model
statistik_pengunjung_model
first_menu_m
teks_berjalan_model
first_artikel_m
web_sosmed_model
shortcode_model
keuangan_grafik_model
keuangan_model
keuangan_grafik_manual_model
keuangan_manual_model
laporan_penduduk_model
program_bantuan_model
penduduk_model
keluarga_model
web_dokumen_model
referensi_model
penduduk_log_model
rtm_model
kelompok_model
wilayah_model
pamong_model
keuangan_grafik_dd_model
web_widget_model
first_gallery_m
pengaduan_model
web_gallery_model
statistik_penduduk_model
27 Juni 2024 10:20:33
Proses pengisian dan mekanisme pengisian perangkat desa menunggu instruksi serta peraturan dari Pemerintah...