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.0334 secLoading Time: Base Classes : 0.0022 sec
Controller Execution Time ( First / Wilayah ) : 0.3998 sec
9.99MB
Request : first/wilayahMethod : GET
DatabaseHost:localhost/kh13puding_sid
SHOW TABLES FROM `kh13puding_sid` 0.0004 sec
SHOW DATABASES 0.0007 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'kh13puding_sid' AND table_name = 'user' 0.0001 sec
SHOW COLUMNS FROM `anjungan` 0.0003 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '18.216.227.61' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0001 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0026 sec
SHOW COLUMNS FROM `analisis_master` 0.0011 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`id` IS NULL 0.0001 sec
SELECT * FROM `analisis_periode` WHERE `aktif` = 1 AND `id_master` IS NULL 0.0000 sec
SHOW COLUMNS FROM `analisis_master` 0.0010 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`id` IS NULL 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'data-wilayah' AND `enabled` = 1 0.0001 sec
SELECT u.*, a.nama AS nama_kadus, a.nik AS nik_kadus, (SELECT COUNT(rw.id) FROM tweb_wil_clusterdesa rw WHERE rw.config_id = u.config_id AND rw.dusun = u.dusun AND rw <> '-' AND rt = '-') AS jumlah_rw, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rt <> '0' AND rt.rt <> '-') AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala = p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun) AND p.kk_level = 1) AS jumlah_kk FROM tweb_wil_clusterdesa u LEFT JOIN penduduk_hidup a ON u.id_kepala = a.id WHERE u.config_id = '1' AND u.rt = '0' AND u.rw = '0' ORDER BY`u`.`urut` ASC LIMIT 0,500 0.0216 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `id` = '32' 0.0002 sec
SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'I' ORDER BY `u`.`urut` ASC 0.0034 sec
SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'I' ORDER BY `u`.`urut` ASC 0.0026 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `id` = '35' 0.0001 sec
SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'II' ORDER BY `u`.`urut` ASC 0.0020 sec
SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.rw AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'II' ORDER BY `u`.`urut` ASC 0.0039 sec
SELECT (SELECT COUNT(w.id) FROM tweb_wil_clusterdesa w WHERE w.config_id = u.config_id AND w.rw <> '-' AND w.rt = '-') AS total_rw, (SELECT COUNT(v.id) FROM tweb_wil_clusterdesa v WHERE v.config_id = u.config_id AND v.rt <> '0' AND v.rt <> '-') AS total_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id)) AS total_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id) AND p.sex = 1) AS total_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id) AND p.sex = 2) AS total_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id) AND p.kk_level = 1) AS total_kk FROM tweb_wil_clusterdesa u LEFT JOIN penduduk_hidup a ON u.id_kepala = a.id WHERE u.rt = '0' AND u.rw = '0' AND u.config_id = '1' limit 1 0.0025 sec
SHOW COLUMNS FROM `widget` 0.0005 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0019 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0021 sec
SHOW COLUMNS FROM `sys_traffic` 0.0032 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"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` = 14 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0064 sec
SHOW COLUMNS FROM `sys_traffic` 0.0004 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0062 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-03-31' AND ( `config_id` = 1 ) 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0068 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0006 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.0002 sec
SHOW COLUMNS FROM `menu` 0.0029 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 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.0030 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.0031 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.0036 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.0003 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.0018 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.0001 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.0036 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.0024 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.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0002 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 (`headline` = 2 or `headline` = 3) AND `gambar` != '' AND `tgl_upload` < '2025-04-01 03:20:06' 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 03:20:06' 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 03:20:06') 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 03:20:06')ORDER BY RAND() LIMIT 10 0.0019 sec
SHOW COLUMNS FROM `artikel` 0.0003 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 03:20:06' AND (`headline` = 2 or `headline` = 3) ORDER BY `tgl_upload` DESC LIMIT 10 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0003 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `config` 0.0031 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.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' 0.0003 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.0018 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.0029 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.0002 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.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 03:20:06' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0002 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 03:20:06' ORDER BY `a`.`hit` DESC LIMIT 7 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0048 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 03:20:06' ORDER BY rand() LIMIT 7 0.0005 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0003 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.0019 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.0005 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 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.0029 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.0004 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0027 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.0036 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0005 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.0002 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.0037 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.0023 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.0022 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.0030 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.0032 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0005 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.0025 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.0009 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0031 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.0007 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0053 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.0004 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0049 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.0038 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.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 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.0010 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.0007 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.0002 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.0002 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.0004 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.0002 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.0003 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.0010 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.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.0024 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.0002 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.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.0060 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.0003 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0003 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.0027 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.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.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 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.0060 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.0028 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.0023 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.0002 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.0004 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='18.216.227.61' AND tanggal='2025-04-01' 0.0019 sec
INSERT INTO pengunjung (ip, tanggal, hits, online) VALUES('18.216.227.61','2025-04-01','1','1743452407') 0.0043 sec
SELECT * FROM pengunjung WHERE online > '1743451807' 0.0020 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/13' AND `enabled` = 1 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/15' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/0' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/14' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/1' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/2' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/3' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/4' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/hubungan_kk' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/5' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/6' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/7' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/9' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/10' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/16' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/17' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/18' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/19' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/covid' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/suku' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/bpjs-tenagakerja' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/kelas_sosial' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/bantuan_penduduk' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/bantuan_keluarga' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/501' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/502' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/503' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/504' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'statistik/505' AND `enabled` = 1 0.0001 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'dpt' AND `enabled` = 1 0.0000 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'data-wilayah' AND `enabled` = 1 0.0000 sec
Total Execution Time 0.2205 sec
Host:localhost_ORM/kh13puding_sid
select * from `config` limit 1 0.7600 sec
select count(*) as aggregate from `config` 0.4100 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' 0.7500 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.4600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'setting_aplikasi' 0.3400 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 0.6600 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 0.5100 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.1200 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 3.2100 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.1500 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' 0.2700 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.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 0.8900 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.3200 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Selasa' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.3100 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`) > '03:20' or date_add(jam_keluar, interval 10 minute) < '03:20') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1200 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 `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 1.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2500 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.0000 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' 2.7300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2300 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.2500 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.3600 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.5100 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.9300 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.2500 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' 2.1300 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.2400 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.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.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' 1.3200 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' 2.5400 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.2500 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.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.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' 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' 1.0400 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.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 6.1400 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.2800 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.2400 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.4800 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.3200 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.4200 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.4000 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.2400 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.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' 1.4700 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' 1.1100 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.4100 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.2300 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.6800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.8600 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' 3.2600 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.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' 1.8700 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' 3.4700 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.2200 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.2900 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 = 'tweb_desa_pamong' 0.5800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2500 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.5200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.8500 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.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 5.4600 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.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 2.2800 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.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` = 31 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.2300 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.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 1.3300 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.3900 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' 1.7200 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.3800 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` = 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' 0.2100 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.2000 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.3700 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.1500 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.3100 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1400 sec
Total Execution Time 89.3800 sec
89.6005 sec
N/A-
Libraries (20)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
Output
Router
Security
Security_header
Security_trusted_host
Session
Spreadsheet_Excel_Reader
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 (19)
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 ( ) ) )
security/headers:Array ( [Strict-Transport-Security] => max-age=31536000; includeSubDomains [X-Content-Type-Options] => nosniff [X-Permitted-Cross-Domain-Policies] => none [Permissions-Policy] => accelerometer=(),ambient-light-sensor=(),autoplay=(),battery=(),camera=(),display-capture=(),document-domain=(),encrypted-media=(),fullscreen=(),gamepad=(),geolocation=(),gyroscope=(),layout-animations=(self),legacy-image-formats=(self),magnetometer=(),microphone=(),midi=(),oversized-images=(self),payment=(),picture-in-picture=(),publickey-credentials-get=(),speaker-selection=(),sync-xhr=(self),unoptimized-images=(self),unsized-media=(self),usb=(),screen-wake-lock=(),web-share=(),xr-spatial-tracking=() [Cross-Origin-Embedder-Policy] => same-origin [Cross-Origin-Resource-Policy] => same-origin [Cross-Origin-Opener-Policy] => same-origin )
Session __ci_last_regenerate:1743452406
artikel:Array ( )
pengunjungOnline:2025-04-01
Models (45)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_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
first_penduduk_m
surat_model
penomoran_surat_model
url_shortener_model
track_model
keluar_model
plan_lokasi_model
plan_area_model
plan_garis_model
analisis_import_model
analisis_indikator_model
analisis_master_model
analisis_periode_model
analisis_respon_model
statistik_pengunjung_model
first_menu_m
teks_berjalan_model
web_widget_model
first_gallery_m
pengaduan_model
statistik_penduduk_model