IDM
0.6827
SKOR IDM SAAT INI
BERKEMBANG
STATUS IDM
0.7073
SKOR IDM MINIMAL
MAJU
TARGET STATUS
| PROVINSI | : | JAMBI |
| KABUPATEN | : | MUARO JAMBI |
| KECAMATAN | : | KUMPEH |
| DESA | : | PUDING |
| NO | INDIKATOR IDM | SKOR | KETERANGAN | KEGIATAN YANG DAPAT DILAKUKAN | +NILAI | YANG DAPAT MELAKSANAKAN KEGIATAN | |||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| PUSAT | PROVINSI | KABUPATEN | DESA | CSR | LAINNYA | ||||||
| 1 | Skor Akses Sarkes | 5 | Waktu tempuh dari ≤ 30 Menit | - | 0 | Dinkes, PU | |||||
| 2 | Skor Dokter | 5 | Jumlah dokter ≥ 1 orang | - | 0 | DINKES | |||||
| 3 | Skor Bidan | 5 | Jumlah bidan ≥ 1 orang | - | 0 | DINKES | |||||
| 4 | Skor Nakes Lain | 5 | Jumlah tenaga kesehatan lainnya ≥ 5 orang | - | 0 | DINKES | |||||
| 5 | Skor Tingkat Kepesertaan BPJS | 4 | Jumlah peserta BPJS/jumlah penduduk antara 0,6 s.d 0,75 | Fasilitasi kepesertaan BPJS warga Desa hingga > 75% | 0.00190476 | DINKES | |||||
| 6 | Skor Akses Poskesdes | 5 | Jarak tempuh menuju Poskesdes = 500 Meter | - | 0 | DINKES | |||||
| 7 | Skor Aktivitas Posyandu | 5 | Jumlah Posyandu aktif 1 bulan sekali/ Jumlah Posyandu > 0,75 | - | 0 | DPMD | DPMD, DINKES | DD | |||
| 8 | Skor Akses SD/MI | 5 | Jarak tempuh menuju SD atau MI = 3000 Meter | - | 0 | DISDIK, PU | |||||
| 9 | Skor Akses SMP/MTS | 1 | Jarak tempuh menuju SMP atau MTs > 12000 Meter | Pembangunan SMP | 0.00761905 | DISDIK, PU | |||||
| 10 | Skor Akses SMA/SMK | 5 | Jarak tempuh menuju SMU atau SMK ≤ 6000 Meter | - | 0 | DISDIK | PU | ||||
| 11 | Skor Ketersediaan PAUD | 5 | Jumlah PAUD ≥ 1 | - | 0 | DISDIK | DISDIK | DD | |||
| 12 | Skor Ketersediaan PKBM/ Paket ABC | 5 | Jumlah PKBM atau Paket ABC ≥ 1 | - | 0 | DISDIK | |||||
| 13 | Skor Ketersediaan Kursus | 5 | Jumlah Pusat Keterampilan atau Kursus ≥ 1 | - | 0 | CSR | |||||
| 14 | Skor Ketersediaan Taman Baca/ Perpus Desa | 5 | Taman Bacaan Masyarakat atau perpustakaan Desa tersedia | - | 0 | Kemenperpus Arsip | Dinas Perpus | Dinas Perpus | DD | CSR | |
| 15 | Skor Kebiasaan Goryong | 5 | Terdapat Kebiasaan Gotong Royong | - | 0 | Desa | |||||
| 16 | Skor Frekuensi Goryong | 5 | Frekuensi Gotong Royong > 2 | - | 0 | Desa | |||||
| 17 | Skor Ketersediaan Ruang Publik | 5 | Ruang Publik terdapat didesa | - | 0 | PU | DD | ||||
| 18 | Skor Kelompok OR | 4 | Jumlah kelompok kegiatan olahraga antara 6 s.d 7 | Penambahan Min 2 Kelp Olahraga | 0.00190476 | DISPORA | DISPORA | Karang Taruna | |||
| 19 | Skor Kegiatan OR | 4 | Jumlah kegiatan olahraga antara 6 s.d 7 | Pembangunan Min 2 Lap Olahraga | 0.00190476 | Kemepora/ Kemendes | DISPORA | DISPORA | DD | CSR | |
| 20 | Skor Keragaman Agama | 5 | Jumlah Jenis Agama di Desa > 1 | - | 0 | Desa | |||||
| 21 | Skor Keragaman Bahasa | 5 | Jumlah Bahasa yang digunakan sehari-hari > 1 | - | 0 | Desa | |||||
| 22 | Skor Keragaman Komunikasi | 5 | Warga Desa terdiri dari Suku > 1 | - | 0 | Desa | |||||
| 23 | Skor Poskamling | 5 | Terdapat Pos Keamanan di Desa | - | 0 | DD | |||||
| 24 | Skor Siskamling | 5 | Terdapat Sistem Keamanan Lingkungan warga di Desa | - | 0 | Desa | |||||
| 25 | Skor Konflik | 1 | Terdapat atau ada Konflik di Desa | Identifikasi dan Penanganan Konflik | 0.00761905 | Kesbangpol | |||||
| 26 | Skor PMKS | 5 | Jumlah PMKS tidak ada atau 0 | - | 0 | Dinsos | |||||
| 27 | Skor SLB | 5 | Jumlah Skor SLB = 0 | - | 0 | DIKNAS | |||||
| 28 | Skor Akses Listrik | 5 | (Jumlah Keluarga Memakai listrik + non Listrik/Jumlah keluarga memakai listrik) ≥ 0,9 ) | - | 0 | ESDM | ESDM | DD | CSR | ||
| 29 | Skor Sinyal Tlp | 5 | Sinyal telepon seluler di Desa Kuat | - | 0 | Kominfo | Diskominfo | Diskominfo | |||
| 30 | Skor Internet Kantor Desa | 5 | Terdapat fasilitas internet di kantor Desa | - | 0 | Kominfo/ Kemendes | Desa | CSR | |||
| 31 | Skor Akses Internet Warga | 5 | Terdapat Akses internet warga di Desa | - | 0 | Kominfo | Diskominfo | Diskominfo | |||
| 32 | Skor Akses Jamban | 5 | Warga Desa BAB di Jamban Sendiri | - | 0 | DINSOS,DINKES | CSR | ||||
| 33 | Skor Sampah | 4 | Warga desa membuang sampah di Lubang atau di Bakar | Pembangunan TPS danTPA Sampah | 0.00190476 | DLH | DLH, DKPP | DD | CSR | ||
| 34 | Skor Air Minum | 5 | Sumber air minum berasal dari PAM, Air Ledeng tanpa Meteran | - | 0 | PAMSIMAS, PU | PU | DD | CSR | ||
| 35 | Skor Air Mandi & Cuci | 5 | Sumber air mandi dan cuci berasal dari PAM, Air Ledeng tanpa Meteran | - | 0 | PAMSIMAS, PU | PU | DD | CSR | ||
| IKS 2022 | 0.93142857142857 | ||||||||||
| 1 | Skor Keragaman Produksi | 5 | Jumlah Industri Mikro/ Jumlah KK ≥ 0,004 | - | 0 | DISPERINDAKOP UKM | DISPERINDAKOP UKM | DD | CSR | ||
| 2 | Skor Pertokoan | 1 | Jarak ke kelompok pertokoan terdekat > 25 KM | Pembangunan Pusat pertokoan melalui kerjasama antar desa/melayani beberapa desa | 0.02222222 | DISPERINDAKOP UKM | |||||
| 3 | Skor Pasar | 1 | (Total KK/jumlah pasar(permanen)) = 0 | Pembangunan Pasar Permanen | 0.02222222 | Kemenperind, Kemendes | DISPERINDAKOP UKM | DISPERINDAKOP UKM | |||
| 4 | Skor Toko/ Warung Kelontong | 5 | Jumlah Toko dan warung kelontong > 3 | - | 0 | DD | |||||
| 5 | Skor Kedai & Penginapan | 3 | Jumlah Kedai dan Penginapan = 1 | Pembangunan 1 Unit Penginapan | 0.01111111 | Dinas Pariwisata | Dinas Pariwisata | DD | |||
| 6 | Skor POS & Logistik | 5 | Jumlah pos dan jasa logistik > 1 | - | 0 | BUMDES | |||||
| 7 | Skor Bank & BPR | 0 | Jumlah bank dan BPR = 0 | Fasilitasi Pembangunan Bank Pemerintah, Swasta &/ BPR | 0.02777778 | ||||||
| 8 | Skor Kredit | 3 | Jumlah fasilitas kredit = 2 | Penambahan 2 jenis Fasilitas Kredit (KUR/KKPE/KUK/Kredit lainnya)(Identifikasi kekurangan akses kredit) | 0.01111111 | DISPERINDAKOP UKM | BUMDES/ Koperasi | ||||
| 9 | Skor Lembaga Ekonomi | 5 | Jumlah koperasi aktif dan BUMDESA > 1 | - | 0 | DISPERINDAKOP UKM | Desa | CSR | |||
| 10 | Skor Moda Transportasi Umum | 3 | Transportasi Umum ada tanpa trayek tetap | Fasilitasi Transportasi Umum dengan Trayek Tetap | 0.01111111 | DISHUB | |||||
| 11 | Skor Keterbukaan Wilayah | 3 | Jalan di Desa dilalui oleh kendaraan bermotor roda empat atau lebih Sepanjang tahun kecuali saat tertentu | Perbaikan dan Peningkatan Kualitas jalan desa | 0.01111111 | PU | DD | CSR | |||
| 12 | Skor Kualitas Jalan | 5 | Jenis permukaan jalan desa Aspal atau beton | - | 0 | PU | DD | CSR | |||
| IKE 2022 | 0.65 | ||||||||||
| 1 | Skor Kualitas Lingkungan | 3 | Pencemaran (air, udara, tanah, limbah disungai) di desa [jumlah pencemaran/4] = 0,5 | Identifikasi dan Penanganan 2 Jenis Pencemaran (air, udara, tanah, limbah disungai) di desa | 0.04444444 | DLH | DLH, DINKES | ||||
| 2 | Skor Rawan Bencana | 4 | Jenis bencana (longsor, banjir, kebakaran hutan) jenis bencana di desa = 1 | Identifikasi 1 Jenis bencana (longsor, banjir, kebakaran hutan) untuk penanganan pencegahan | 0.02222222 | DISHUT/KPH, BPDB | BPBD | ||||
| 3 | Skor Tanggap Bencana | 0 | Fasilitas mitigasi/tanggap bencana (peringatan dini bencana alam, peringatan dini tsunami, perlengkapan keselamatan, jalur evakuasi) jumlah fasilitas mitigasi / tanggap bencana = 0 | Pembangunan/Pengadaan 3 Fasilitas Mitigasi Bencana Sesuai karakteristik wilayah (Kebutuhan sesuai hasil identifikasi kerawanan/potensi bencana) | 0.11111111 | BNPB, Kemendes | DISHUT/KPH, BPDB, DINSOS | DPBD, DINSOS | DD | CSR | |
| IKL 2022 | 0.46666666666667 | ||||||||||
| IDM 2022 | 0.68269841269841 | ||||||||||
| STATUS IDM 2022 | Berkembang | B | |||||||||
Desa Puding
Hubungi Perangkat Desa untuk mendapatkan PIN
Video
Desa Puding
Sistem Informasi Desa Puding Kecamatan Kumpeh, Kabupaten Muaro Jambi
Jl. Jambi -Suak Kandis KM. 41 Desa Puding Kecamatan Kumpeh, Kabupaten Muaro Jambi
OpenSID 2309.0.1-premium || Tema KumpehEquality v22.11
CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
1.1430 secLoading Time: Base Classes : 0.0068 sec
Controller Execution Time ( Idm / Index ) : 0.4507 sec
8.86MB
Request : idm/indexMethod : GET
DatabaseHost:localhost/kh13puding_sid
SHOW TABLES FROM `kh13puding_sid` 0.0004 sec
SHOW DATABASES 0.0015 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'kh13puding_sid' AND table_name = 'user' 0.0002 sec
SHOW COLUMNS FROM `anjungan` 0.0006 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '3.148.109.137' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'status-idm/2022' AND `enabled` = 1 0.0003 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0008 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"3.148.109.137\",\"57.141.2.29\",\"3.19.70.25\",\"3.19.70.25\",\"18.218.2.200\",\"3.137.188.40\",\"3.141.46.189\",\"18.224.20.254\",\"3.21.122.130\",\"3.21.122.130\",\"3.21.122.130\",\"3.144.29.148\",\"3.144.29.148\",\"3.144.29.148\",\"57.141.2.4\",\"18.217.168.117\",\"18.118.254.77\",\"18.118.254.77\",\"57.141.2.1\",\"3.129.52.253\",\"18.226.163.178\",\"18.226.163.178\",\"57.141.2.12\",\"18.216.227.61\",\"194.163.182.227\",\"57.141.2.26\",\"57.141.2.15\",\"57.141.2.8\",\"209.97.174.181\",\"57.141.2.26\",\"66.249.71.199\",\"66.249.66.32\",\"57.141.2.2\",\"57.141.2.3\",\"66.249.66.4\",\"66.249.66.20\",\"57.141.2.24\"]}', `Jumlah` = 37 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0063 sec
SHOW COLUMNS FROM `sys_traffic` 0.0006 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-03-31' AND ( `config_id` = 1 ) 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0005 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.0001 sec
SHOW COLUMNS FROM `menu` 0.0007 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0006 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.0008 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.0001 sec
SHOW COLUMNS FROM `artikel` 0.0002 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.0001 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0017 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '122' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '109' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '119' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0003 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.0002 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0002 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0028 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0007 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0002 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.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0010 sec
SHOW COLUMNS FROM `artikel` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0020 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 (`headline` = 2 or `headline` = 3) AND `gambar` != '' AND `tgl_upload` < '2025-04-01 04:07:09' 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 (`headline` = 2 or `headline` = 3) AND `gambar1` != '' AND `tgl_upload` < '2025-04-01 04:07:09' 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 (`headline` = 2 or `headline` = 3) AND `gambar2` != '' AND `tgl_upload` < '2025-04-01 04:07:09') 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 (`headline` = 2 or `headline` = 3) AND `gambar3` != '' AND `tgl_upload` < '2025-04-01 04:07:09')ORDER BY RAND() LIMIT 10 0.0099 sec
SHOW COLUMNS FROM `artikel` 0.0026 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 `gambar` != '' AND `tgl_upload` < '2025-04-01 04:07:09' AND (`headline` = 2 or `headline` = 3) ORDER BY `tgl_upload` DESC LIMIT 10 0.0002 sec
SHOW COLUMNS FROM `widget` 0.0032 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `config` 0.0035 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.0002 sec
SHOW COLUMNS FROM `agenda` 0.0004 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.0002 sec
SHOW COLUMNS FROM `agenda` 0.0002 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.0001 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.0001 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.0001 sec
SHOW COLUMNS FROM `media_sosial` 0.0003 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 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-04-01 04:07:09' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0033 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-04-01 04:07:09' ORDER BY `a`.`hit` DESC LIMIT 7 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0085 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-04-01 04:07:09' ORDER BY rand() LIMIT 7 0.0063 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.0003 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.0012 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.0005 sec
SHOW COLUMNS FROM `widget` 0.0003 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0020 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek1` ON `keuangan_ref_rek1`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0035 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0006 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0026 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0004 sec
SELECT `keuangan_ref_rek3`.`Jenis`, `keuangan_ref_rek3`.`Nama_Jenis` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek2` ON `keuangan_ref_rek2`.`id_keuangan_master` = `keuangan_master`.`id` LEFT JOIN `keuangan_ref_rek3` ON `keuangan_ref_rek3`.`Kelompok` = `keuangan_ref_rek2`.`Kelompok` WHERE `keuangan_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0021 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0004 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0035 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_master` LEFT JOIN `keuangan_ta_bidang` ON `keuangan_ta_bidang`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Kd_Bid` NOT LIKE '01%' AND `Tahun` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0006 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0037 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0006 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0004 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0006 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0022 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(keuangan_ta_jurnal_umum_rinci.Debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_jurnal_umum_rinci`.`Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 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.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0020 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek1` ON `keuangan_ref_rek1`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0030 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0039 sec
SELECT `keuangan_ref_rek3`.`Jenis`, `keuangan_ref_rek3`.`Nama_Jenis` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek2` ON `keuangan_ref_rek2`.`id_keuangan_master` = `keuangan_master`.`id` LEFT JOIN `keuangan_ref_rek3` ON `keuangan_ref_rek3`.`Kelompok` = `keuangan_ref_rek2`.`Kelompok` WHERE `keuangan_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0006 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0021 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_master` LEFT JOIN `keuangan_ta_bidang` ON `keuangan_ta_bidang`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Kd_Bid` NOT LIKE '01%' AND `Tahun` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0005 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0034 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0005 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0005 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0029 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(keuangan_ta_jurnal_umum_rinci.Debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_jurnal_umum_rinci`.`Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-03-31' AND ( `config_id` = 1 ) 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0004 sec
SHOW COLUMNS FROM `menu` 0.0028 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0001 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.0001 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` = '93' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 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.0001 sec
SHOW COLUMNS FROM `menu` 0.0037 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' 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` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '122' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '109' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '119' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0027 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0060 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0002 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0029 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0025 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.0002 sec
SHOW COLUMNS FROM `artikel` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0003 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 (`headline` = 2 or `headline` = 3) AND `gambar` != '' AND `tgl_upload` < '2025-04-01 04:07:09' 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 (`headline` = 2 or `headline` = 3) AND `gambar1` != '' AND `tgl_upload` < '2025-04-01 04:07:09' 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 (`headline` = 2 or `headline` = 3) AND `gambar2` != '' AND `tgl_upload` < '2025-04-01 04:07:09') 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 (`headline` = 2 or `headline` = 3) AND `gambar3` != '' AND `tgl_upload` < '2025-04-01 04:07:09')ORDER BY RAND() LIMIT 10 0.0039 sec
SHOW COLUMNS FROM `artikel` 0.0002 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 `gambar` != '' AND `tgl_upload` < '2025-04-01 04:07:09' AND (`headline` = 2 or `headline` = 3) ORDER BY `tgl_upload` DESC LIMIT 10 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `config` 0.0003 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0003 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0001 sec
SHOW COLUMNS FROM `agenda` 0.0028 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.0001 sec
SHOW COLUMNS FROM `agenda` 0.0004 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.0001 sec
SHOW COLUMNS FROM `agenda` 0.0002 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.0001 sec
SHOW COLUMNS FROM `komentar` 0.0003 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.0001 sec
SHOW COLUMNS FROM `media_sosial` 0.0002 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 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-04-01 04:07:09' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0026 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-04-01 04:07:09' ORDER BY `a`.`hit` DESC LIMIT 7 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 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-04-01 04:07:09' ORDER BY rand() LIMIT 7 0.0005 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0033 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.0002 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.0038 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.0004 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0001 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.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0034 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek1` ON `keuangan_ref_rek1`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0022 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `keuangan_ref_rek3`.`Jenis`, `keuangan_ref_rek3`.`Nama_Jenis` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek2` ON `keuangan_ref_rek2`.`id_keuangan_master` = `keuangan_master`.`id` LEFT JOIN `keuangan_ref_rek3` ON `keuangan_ref_rek3`.`Kelompok` = `keuangan_ref_rek2`.`Kelompok` WHERE `keuangan_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0024 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0024 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_master` LEFT JOIN `keuangan_ta_bidang` ON `keuangan_ta_bidang`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Kd_Bid` NOT LIKE '01%' AND `Tahun` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0063 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0005 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0071 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0055 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0008 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(keuangan_ta_jurnal_umum_rinci.Debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_jurnal_umum_rinci`.`Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0053 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0054 sec
SELECT `Akun`, `Nama_Akun` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek1` ON `keuangan_ref_rek1`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Akun` NOT LIKE '1.%' AND `Akun` NOT LIKE '7.%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0032 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0061 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0014 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0085 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `keuangan_ref_rek3`.`Jenis`, `keuangan_ref_rek3`.`Nama_Jenis` FROM `keuangan_master` LEFT JOIN `keuangan_ref_rek2` ON `keuangan_ref_rek2`.`id_keuangan_master` = `keuangan_master`.`id` LEFT JOIN `keuangan_ref_rek3` ON `keuangan_ref_rek3`.`Kelompok` = `keuangan_ref_rek2`.`Kelompok` WHERE `keuangan_ref_rek3`.`Jenis` NOT LIKE '1.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '5.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '6.%' AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '7.%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%' AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%' AND `tahun_anggaran` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0021 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0035 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0029 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0026 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `Kd_Bid`, `Nama_Bidang` FROM `keuangan_master` LEFT JOIN `keuangan_ta_bidang` ON `keuangan_ta_bidang`.`id_keuangan_master` = `keuangan_master`.`id` WHERE `Kd_Bid` NOT LIKE '01%' AND `Tahun` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0115 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0005 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0021 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spp_rinci` LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_spp_rinci`.`Tahun` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0024 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(keuangan_ta_jurnal_umum_rinci.Debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND `keuangan_ta_jurnal_umum_rinci`.`Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SELECT * FROM pengunjung WHERE ip='3.148.109.137' AND tanggal='2025-04-01' 0.0020 sec
INSERT INTO pengunjung (ip, tanggal, hits, online) VALUES('3.148.109.137','2025-04-01','1','1743455230') 0.0063 sec
SELECT * FROM pengunjung WHERE online > '1743454630' 0.0018 sec
Total Execution Time 0.2960 sec
Host:localhost_ORM/kh13puding_sid
select * from `config` limit 1 0.5900 sec
select count(*) as aggregate from `config` 0.1100 sec
select count(*) as aggregate from `config` 0.0500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.6100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'setting_aplikasi' 3.3100 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 0.5100 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 2.6800 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.1400 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 0.2700 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.1000 sec
select count(*) as aggregate from `config` 0.0700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.5400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 1.6000 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.3000 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Selasa' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 3.0200 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` = 'Selasa' and (time(`jam_masuk`) > '04:07' or date_add(jam_keluar, interval 10 minute) < '04:07') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.5500 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 3.4400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.7400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 3.2100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2700 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.3800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2700 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.9100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.7200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.9000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.8300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.4000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.3100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.5800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.7500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2900 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'tweb_desa_pamong' 0.9300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 27 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 1.8800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 28 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.5400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 30 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 36 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 37 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.4600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 38 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 1.4700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 39 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.7700 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'tweb_desa_pamong' 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 2.9500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 27 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 28 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.4500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 30 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.6000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 36 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.1900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 37 and `tanggal` = '2025-04-01' 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 3.0100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 38 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 39 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.2900 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.2400 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.0900 sec
Total Execution Time 77.0900 sec
77.3860 sec
N/A-
Libraries (17)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
Output
Router
Security
Session
URI
Upload
User_agent
Utf8
Validasi
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 (18)
Configuration trusted_hosts:Array ( )
base_url:https://puding.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/kh13puding/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
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
rilis_premium:https://api.github.com/repos/opensid/rilis-premium/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/calendar.min.json
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
kode_kota:603
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/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/filemanager/] => 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'] = false; // 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; // Ijinkan agar bisa melakukan impor data penduduk dari OpenKAB $config['impor_massal'] = false; // 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'] = []; // config email $config['protocol'] = 'smtp'; // mail mail, sendmail, or smtp The mail sending protocol. $config['smtp_host'] = ''; // SMTP Server Address. $config['smtp_user'] = ''; // SMTP Username. $config['smtp_pass'] = ''; // SMTP Password. $config['smtp_port'] = ''; // SMTP Port."
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'; /* | 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:1743455229
artikel:Array ( )
pengunjungOnline:2025-04-01
Models (31)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
web_widget_model
first_gallery_m
pengaduan_model
statistik_penduduk_model