CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
0.8539 secLoading Time: Base Classes : 0.0089 sec
Controller Execution Time ( Peta / Index ) : 0.5897 sec
20.13MB
Request : peta/indexMethod : GET
DatabaseHost:mysql-server-opensid/opensid8001
SHOW TABLES FROM `opensid8001` 0.0024 sec
SHOW DATABASES 0.0023 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'opensid8001' AND table_name = 'user' 0.0004 sec
SHOW COLUMNS FROM `anjungan` 0.0016 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '10.91.52.2' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'peta' AND `enabled` = 1 0.0003 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0001 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `rt` = '0' AND `rw` = '0' ORDER BY `urut` ASC 0.0002 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `zoom` > '0' 0.0001 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `rt` = '0' AND `rw` <> '0' ORDER BY `urut` ASC 0.0001 sec
SELECT * FROM `tweb_wil_clusterdesa` WHERE ( `config_id` = 1 ) AND `rt` <> '0' ORDER BY `urut` ASC 0.0001 sec
SELECT `u`.*, COUNT(k.id) as jumlah, COUNT(CASE WHEN k.status_covid = u.id AND p.sex = 1 THEN k.id_terdata END) AS laki, COUNT(CASE WHEN k.status_covid = u.id AND p.sex = 2 THEN k.id_terdata END) AS perempuan FROM `ref_status_covid` `u` LEFT JOIN `covid19_pemudik` `k` ON `k`.`status_covid` = `u`.`id` and `k`.`config_id` = 1 LEFT JOIN `tweb_penduduk` `p` ON `p`.`id`=`k`.`id_terdata` GROUP BY `u`.`id` 0.0002 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.0001 sec
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol` FROM `lokasi` `l` LEFT JOIN `point` `p` ON `l`.`ref_point` = `p`.`id` LEFT JOIN `point` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1 AND ( `l`.`config_id` = 1 ) AND `l`.`ref_point` != 0 0.0002 sec
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol`, `p`.`color` AS `color`, `p`.`tebal` AS `tebal`, `p`.`jenis` AS `jenis_garis` FROM `garis` `l` LEFT JOIN `line` `p` ON `l`.`ref_line` = `p`.`id` LEFT JOIN `line` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1 AND ( `l`.`config_id` = 1 ) AND `l`.`ref_line` != 0 0.0002 sec
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol`, `p`.`color` AS `color` FROM `area` `l` LEFT JOIN `polygon` `p` ON `l`.`ref_polygon` = `p`.`id` LEFT JOIN `polygon` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1 AND ( `l`.`config_id` = 1 ) AND `l`.`ref_polygon` != 0 0.0002 sec
SELECT (CASE WHEN p.id_lokasi = w.id THEN CONCAT( (CASE WHEN w.rt != '0' THEN CONCAT('RT ', `w`.`rt`, ' / ') ELSE '' END), (CASE WHEN w.rw != '0' THEN CONCAT('RW ', `w`.`rw`, ' - ') ELSE '' END), w.dusun ) ELSE CASE WHEN p.lokasi IS NOT NULL THEN p.lokasi ELSE '=== Lokasi Tidak Ditemukan ===' END END) AS alamat, `p`.* FROM `pembangunan` `p` LEFT JOIN `tweb_wil_clusterdesa` `w` ON `p`.`id_lokasi` = `w`.`id` WHERE ( `p`.`config_id` = 1 ) AND `p`.`status` = 1 0.0002 sec
SELECT (CASE WHEN p.id_wilayah = w.id THEN CONCAT( (CASE WHEN w.rt != '0' THEN CONCAT('RT ', `w`.`rt`, ' / ') ELSE '' END), (CASE WHEN w.rw != '0' THEN CONCAT('RW ', `w`.`rw`, ' - ') ELSE '' END), w.dusun ) ELSE CASE WHEN p.lokasi IS NOT NULL THEN p.lokasi ELSE '=== Lokasi Tidak Ditemukan ===' END END) AS alamat, `p`.*, `k`.`kode`, count(m.id_persil) as jml_bidang, `c`.`nomor` as `nomor_cdesa_awal`, `c`.`nama_kepemilikan` FROM `persil` `p` LEFT JOIN `ref_persil_kelas` `k` ON `k`.`id` = `p`.`kelas` LEFT JOIN `tweb_wil_clusterdesa` `w` ON `w`.`id` = `p`.`id_wilayah` LEFT JOIN `mutasi_cdesa` `m` ON `p`.`id` = `m`.`id_persil` LEFT JOIN `cdesa` `c` ON `c`.`id` = `p`.`cdesa_awal` WHERE ( `p`.`config_id` = 1 ) GROUP BY `p`.`id`, `nomor_urut_bidang` ORDER BY `nomor`, `nomor_urut_bidang` 0.0002 sec
SELECT CONCAT('50', p.id) as lap, `p`.`id`, `p`.`nama`, `p`.`sasaran`, `p`.`ndesc`, `p`.`sdate`, `p`.`edate`, `p`.`userid`, `p`.`status` FROM `program` `p` WHERE ( `p`.`config_id` = 1 OR `p`.`config_id` IS NULL ) 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0007 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-06' 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0010 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\"]}', `Jumlah` = 10 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-06' 0.0032 sec
SHOW COLUMNS FROM `sys_traffic` 0.0006 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-06' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0006 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2026-04-05' AND ( `config_id` = 1 ) 0.0003 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0027 sec
SHOW COLUMNS FROM `menu` 0.0012 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.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '1' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0009 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` = '1' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '2' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '3' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '11' 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` = '4' 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` = '5' 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` = '6' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '2' 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` = '7' 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` = '8' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0007 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '3' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0087 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` = '9' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0019 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0007 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '18' 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` = '10' 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` = '12' 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` = '13' 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` = '14' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '10' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '19' 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` = '28' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0006 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'berita' OR `slug` = 'berita' ) 0.0004 sec
SHOW COLUMNS FROM `menu` 0.0007 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '44' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0006 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.0007 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '3' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0006 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0007 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.0007 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SHOW COLUMNS FROM `artikel` 0.0009 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-04-06 04:12:52' UNION SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar1` != '' AND `tgl_upload` < '2026-04-06 04:12:52' UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar2` != '' AND `tgl_upload` < '2026-04-06 04:12:52') UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar3` != '' AND `tgl_upload` < '2026-04-06 04:12:52')ORDER BY RAND() LIMIT 10 0.0009 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-04-06 04:12:52'ORDER BY tgl_upload DESC LIMIT 10 0.0278 sec
SHOW COLUMNS FROM `widget` 0.0012 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `config` 0.0006 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0007 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0004 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) = CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0003 sec
SHOW COLUMNS FROM `agenda` 0.0007 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.0003 sec
SHOW COLUMNS FROM `agenda` 0.0008 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 `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.0006 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0009 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-06 04:12:52' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0005 sec
SHOW COLUMNS FROM `artikel` 0.0010 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-06 04:12:52' ORDER BY `a`.`hit` DESC LIMIT 7 0.0013 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-06 04:12:52' ORDER BY rand() LIMIT 7 0.0010 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0007 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.0001 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.0001 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.0001 sec
SHOW COLUMNS FROM `widget` 0.0006 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0006 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.0007 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0012 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0008 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0008 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0007 sec
Total Execution Time 0.1036 sec
Host:mysql-server-opensid_ORM/opensid8001
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 3.8100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 66.5500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2000 sec
select * from `config` limit 1 0.1400 sec
select count(*) as aggregate from `config` 0.1200 sec
select count(*) as aggregate from `config` 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'setting_aplikasi' 0.7200 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 0.4600 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.6500 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.2700 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.6000 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.1600 sec
select count(*) as aggregate from `config` 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.1100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.5300 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists` 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan' 0.6300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan' 0.6300 sec
select * from information_schema.tables where table_schema = 'opensid8001' 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 = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.6800 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Senin' 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 = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.5600 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` = 'Senin' and (time(`jam_masuk`) > '04:12' or date_add(jam_keluar, interval 10 minute) < '04:12') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa' 0.6000 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.5800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.8200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.8700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 8.5700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.4900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.6700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.8000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 0.8000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa' 0.8100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 1 and `tanggal` = '2026-04-06' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.1300 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.5400 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 17.6600 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 0.8800 sec
select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.3700 sec
select * from `tweb_penduduk` where `tweb_penduduk`.`id` in ('') 0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.7800 sec
select * from `ref_jabatan` where `ref_jabatan`.`id` in (3) and `ref_jabatan`.`config_id` = 1 0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.6500 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 0.8100 sec
select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.1700 sec
select * from `tweb_penduduk` where `tweb_penduduk`.`id` in ('') 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.6700 sec
select * from `ref_jabatan` where `ref_jabatan`.`id` in (3) and `ref_jabatan`.`config_id` = 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.7000 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 0.6800 sec
select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.1700 sec
select * from `tweb_penduduk` where `tweb_penduduk`.`id` in ('') 0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.7300 sec
select * from `ref_jabatan` where `ref_jabatan`.`id` in (3) and `ref_jabatan`.`config_id` = 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.6000 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 0.6300 sec
select `pamong_id`, `pamong_nama`, `jabatan_id`, `ref_jabatan`.`nama` as `pamong_jabatan`, `ref_jabatan`.`jenis`, `pamong_nip`, `pamong_niap`, `pamong_ttd`, `pamong_ub`, `pamong_status`, `pamong_nik`, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nama, tweb_penduduk.nama) AS pamong_nama, IF(tweb_desa_pamong.id_pend IS NULL, tweb_desa_pamong.pamong_nik, tweb_penduduk.nik) AS pamong_nik, gelar_depan, gelar_belakang from `tweb_desa_pamong` left join `tweb_penduduk` on `tweb_penduduk`.`id` = `tweb_desa_pamong`.`id_pend` left join `ref_jabatan` on `ref_jabatan`.`id` = `tweb_desa_pamong`.`jabatan_id` where `jabatan_id` = 3 and `pamong_status` = 1 and `tweb_desa_pamong`.`config_id` = 1 limit 1 0.1600 sec
select * from `tweb_penduduk` where `tweb_penduduk`.`id` in ('') 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.8400 sec
select * from `ref_jabatan` where `ref_jabatan`.`id` in (3) and `ref_jabatan`.`config_id` = 1 0.1500 sec
Total Execution Time 151.6100 sec
151.7136 sec
N/A-
Libraries (16)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
MY_Upload
Output
Router
Security
Session
URI
User_agent
Utf8
Helpers (14)Cek_helper
Database_helper
Date_helper
Donjolib_helper
File_helper
Form_helper
General_helper
Language_helper
Opensid_helper
Pict_helper
Surat_helper
Text_helper
Url_helper
Utility_helper
Views (10) /public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/meta.php
/public_html/opensid8001/donjo-app/views/global/validasi_form.php
/public_html/opensid8001/donjo-app/views/gis/cetak_peta.php
/public_html/opensid8001/donjo-app/views/gis/content_desa_web.php
/public_html/opensid8001/donjo-app/views/gis/content_dusun_web.php
/public_html/opensid8001/donjo-app/views/gis/content_rw_web.php
/public_html/opensid8001/donjo-app/views/gis/content_rt_web.php
/public_html/opensid8001/donjo-app/views/web/halaman_statis/peta.php
/public_html/opensid8001/donjo-app/views/head_tags_front.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/layouts/peta_statis.tpl.php
Configuration trusted_hosts:Array ( )
base_url:https://dev.desa.sumbawabaratkab.go.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:/public_html/opensid8001/desa/cache/
cache_query_string:
encryption_key:lumbungkomunitas
sess_driver:files
sess_cookie_name:ci_session
sess_expiration:7200
sess_save_path:/tmp
sess_match_ip:
sess_time_to_update:300
sess_regenerate_destroy:
cookie_prefix:
cookie_domain:
cookie_path:/
cookie_secure:
cookie_httponly:
standardize_newlines:
global_xss_filtering:
csrf_protection:1
csrf_token_name:sidcsrf
csrf_cookie_name:sidcsrf
csrf_expire:7200
csrf_regenerate:1
csrf_exclude_uris:Array ( [0] => api.*+ )
compress_output:
time_reference:local
rewrite_short_tags:
proxy_ips:
nama_aplikasi:OpenSID
nama_lembaga:OpenDesa
fb_opendesa:https://www.facebook.com/groups/komunitasopendesa
tg_opendesa:https://t.me/komunitasopensidstop
tg_kontributor:https://t.me/+mi5ydVtVfmw0YWY1
github:https://github.com/OpenSID/OpenSID
website:https://opendesa.id
forum:https://forum.opendesa.id
youtube:https://www.youtube.com/KomunitasOpenSID-OpenDesa
server_pantau:https://pantau.opensid.my.id
token_pantau:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw
server_layanan:https://layanan.opendesa.id
rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest
api_idm:https://idm.kemendesa.go.id/open/api/desa/rumusan
api_sdgs:https://sid.kemendesa.go.id/sdgs/searching/score-sdgs?location_code=
api_hari_libur:https://raw.githubusercontent.com/guangrei/APIHariLibur_V2/main/holidays.json
api_google_recaptcha:https://google.com/recaptcha/api/
views_blade:resources/views/
cache_blade:storage/framework/views/
maximum_login_attempts:3
lockout_time:300
useDatabaseConfig:1
demo_mode:
demo_akun:Array ( [1] => 123456 [2] => 234561 [3] => 345612 )
demo_user:Array ( [username] => admin [password] => sid304 )
rentang_kirim_pesan:60
user_admin:0
DeNava:C5A544F5E3B8
desa:Array ( [desa/anjungan/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/arsip/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/cache/] => Array ( [0] => 509 ) [desa/config/] => Array ( [0] => 509 ) [desa/logo/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/pengaturan/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/images/] => Array ( [0] => 509 ) [desa/template-surat/] => Array ( [0] => 509 ) [desa/template-surat/lampiran/] => Array ( [0] => 509 ) [desa/themes/] => Array ( [0] => 509 ) [desa/upload/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/fonts/] => Array ( [0] => 509 [1] => htaccess1 [2] => Array ( [0] => vendor/tecnickcom/tcpdf/fonts/helvetica.php ) ) [desa/upload/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/buku_tamu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dokumen/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/upload/galeri/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/area/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/garis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/point/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/produk/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/sinkronisasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/thumbs/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/user_pict/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/vaksin/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/widgets/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dtks/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )
lainnya:Array ( [storage/framework/] => Array ( [0] => 509 [1] => htaccess3 ) [storage/logs/] => Array ( [0] => 509 [1] => htaccess3 ) [backup_inkremental/] => Array ( [0] => 509 [1] => htaccess3 ) [assets/] => Array ( [0] => 493 [1] => htaccess3 ) [assets/kelola_file/] => Array ( [0] => 493 [1] => htaccess4 ) [assets/kelola_file/config/] => Array ( [0] => 493 [1] => htaccess4 ) )
config:<?php // ---------------------------------------------------------------------------- // Konfigurasi aplikasi dalam berkas ini merupakan setting konfigurasi tambahan // SID. Letakkan setting konfigurasi ini di desa/config/config.php. // ---------------------------------------------------------------------------- // Uncomment jika situs ini untuk demo. Pada demo, user admin tidak bisa dihapus // dan username/password tidak bisa diubah // $config['demo_mode'] = true; // Setting ini untuk menentukan user yang dipercaya. User dengan id di setting ini // dapat membuat artikel berisi video yang aktif ditampilkan di Web. // Misalnya, ganti dengan id = 1 jika ingin membuat pengguna admin sebagai pengguna terpecaya. $config['user_admin'] = 0; // Untuk menghindari masalah keamanan, Anda mungkin ingin mengonfigurasi daftar "host tepercaya". // Contoh: ['localhost', 'my-development.com', 'my-production.com', 'subdomain.domain.com'] $config['trusted_hosts'] = [];
database:<?php // ------------------------------------------------------------------------- // // Letakkan username, password dan database sebetulnya di file ini. // File ini JANGAN di-commit ke GIT. TAMBAHKAN di .gitignore // ------------------------------------------------------------------------- // Data Konfigurasi MySQL yang disesuaikan $db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'root'; $db['default']['password'] = ''; $db['default']['port'] = 3306; $db['default']['database'] = 'premium'; $db['default']['dbcollat'] = 'utf8_general_ci'; /* | Untuk setting koneksi database 'Strict Mode' | Sesuaikan dengan ketentuan hosting */ $db['default']['stricton'] = TRUE;
index_html:<html> <head> <title>403 Forbidden</title> </head> <body> <p>Directory access is forbidden.</p> </body> </html>
htaccess1:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess2:<FilesMatch "\.(rtf|pdf|jpe?g|png|php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess3:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg|pl|py|jsp|asp|htm|shtml|sh|cgi)$"> order allow,deny deny from all </FilesMatch>
htaccess4:<FilesMatch "\.(php)$"> order allow,deny allow from all </FilesMatch>
offline_mode:<!DOCTYPE html> <html> <head> <title>Offline Mode - <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?></title> <link rel="shortcut icon" href="<?= favico_desa() ?>"/> </head> <body> <br/><br/><br/> <div align="center"> <img class="profile-user-img img-responsive img-circle" src="<?= gambar_desa($main['logo']); ?>" alt="Logo"> <p> Selamat datang di Halaman Situs Resmi <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?><br/> Kami mohon maaf untuk sementara halaman tidak dapat di akses, dikarenakan sedang adanya perbaikan oleh tim terkait. </p> <p> Jika ada keperluan yang mendesak silakan langsung datang ke Kantor <?= ucwords($this->setting->sebutan_desa)?>.<br> Alamat : <?= $main['alamat_kantor'] ?><br> Email : <?= $main['email_desa'] ?><br> Telepon : <?= $main['telepon'] ?> </p> <p> <?= ucwords($pamong_kades['jabatan']).' '.$main['nama_desa'] ?> <br> <br> <br> <u><b><?= $main['nama_kepala_desa'] ?></b></u><br> NIP. <?= $main['nip_kepala_desa'] ?> </p> </div> </body> </html>
siteman_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
siteman_mandiri_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
folders:Array ( [storage.framework] => Array ( [name] => storage/framework [check] => Closure Object ( ) ) [storage.logs] => Array ( [name] => storage/logs [check] => Closure Object ( ) ) [backup_inkremental] => Array ( [name] => backup_inkremental/ [check] => Closure Object ( ) ) )
server:Array ( [php] => Array ( [name] => PHP Version [version] => >= 7.4.0 | < 8.0.0 [check] => Closure Object ( ) ) [pdo] => Array ( [name] => PDO [check] => Closure Object ( ) ) [curl] => Array ( [name] => Curl extention [check] => Closure Object ( ) ) [fileinfo] => Array ( [name] => Fileinfo extension [check] => Closure Object ( ) ) [gd] => Array ( [name] => GD extension [check] => Closure Object ( ) ) [iconv] => Array ( [name] => Iconv extension [check] => Closure Object ( ) ) [json] => Array ( [name] => Json extension [check] => Closure Object ( ) ) [mbstring] => Array ( [name] => Mbstring extension [check] => Closure Object ( ) ) [mysqli] => Array ( [name] => Mysqli extension [check] => Closure Object ( ) ) [mysqlnd] => Array ( [name] => Mysqlnd extension [check] => Closure Object ( ) ) [tidy] => Array ( [name] => Tidy extension [check] => Closure Object ( ) ) [zip] => Array ( [name] => Zip extension [check] => Closure Object ( ) ) [exif] => Array ( [name] => Exif extension [check] => Closure Object ( ) ) )
Session __ci_last_regenerate:1775423571
artikel:Array ( )
pengunjungOnline:2026-04-06
Models (37)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_model
wilayah_model
referensi_model
laporan_penduduk_model
program_bantuan_model
penduduk_model
keluarga_model
web_dokumen_model
penduduk_log_model
rtm_model
kelompok_model
plan_garis_model
plan_lokasi_model
data_persil_model
plan_area_model
pembangunan_model
statistik_penduduk_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
pamong_model
keuangan_grafik_dd_model
web_widget_model
first_gallery_m
pengaduan_model