Status Indeks Desa Membangun (IDM)
Tidak dapat mengambil data IDM.
Menu Kategori
Kec. Brang Ene, Kab. Sumbawa Barat, Provinsi Nusa Tenggara Barat
CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
6.6510 secLoading Time: Base Classes : 0.0154 sec
Controller Execution Time ( Idm / Index ) : 5.8812 sec
19.21MB
Request : idm/indexMethod : GET
DatabaseSHOW TABLES FROM `opensid8001` 0.0092 sec
SHOW DATABASES 0.0031 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'opensid8001' AND table_name = 'user' 0.0012 sec
SHOW COLUMNS FROM `anjungan` 0.0019 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.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `link` = 'status-idm/2023' AND `enabled` = 1 0.0024 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0002 sec
SHOW COLUMNS FROM `widget` 0.0012 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0003 sec
SHOW COLUMNS FROM `sys_traffic` 0.0016 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-05' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 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\",\"10.91.52.2\",\"10.91.52.2\",\"10.91.52.2\"]}', `Jumlah` = 13 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-05' 0.0112 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-05' 0.0005 sec
SHOW COLUMNS FROM `sys_traffic` 0.0021 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2026-04-04' AND ( `config_id` = 1 ) 0.0008 sec
SHOW COLUMNS FROM `sys_traffic` 0.0046 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0014 sec
SHOW COLUMNS FROM `menu` 0.0022 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.0008 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '1' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0012 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.0003 sec
SHOW COLUMNS FROM `artikel` 0.0013 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.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` = '3' 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` = '11' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '4' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '5' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0011 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.0009 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '2' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` = '7' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '8' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '3' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '9' 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0008 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `menu` 0.0011 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '18' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0008 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '10' AND `enabled` = 1 ORDER BY `urut` 0.0003 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` = '12' 0.0002 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` = '13' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0010 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.0020 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.0002 sec
SHOW COLUMNS FROM `menu` 0.0008 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '19' AND `enabled` = 1 ORDER BY `urut` 0.0004 sec
SHOW COLUMNS FROM `menu` 0.0009 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '28' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0010 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'berita' OR `slug` = 'berita' ) 0.0011 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.0002 sec
SHOW COLUMNS FROM `kategori` 0.0007 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.0002 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0010 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.0003 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-04-05 11:04:53' 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-05 11:04:53' 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-05 11:04:53') 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-05 11:04:53')ORDER BY RAND() LIMIT 10 0.0053 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-05 11:04:53'ORDER BY tgl_upload DESC LIMIT 10 0.0010 sec
SHOW COLUMNS FROM `widget` 0.0320 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `config` 0.0010 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0008 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0009 sec
SHOW COLUMNS FROM `agenda` 0.0009 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.0011 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.0005 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' 0.0005 sec
SHOW COLUMNS FROM `komentar` 0.0010 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.0003 sec
SHOW COLUMNS FROM `media_sosial` 0.0009 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0012 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-05 11:04:53' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0009 sec
SHOW COLUMNS FROM `artikel` 0.0007 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-05 11:04:53' ORDER BY `a`.`hit` DESC LIMIT 7 0.0016 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-05 11:04:53' ORDER BY rand() LIMIT 7 0.0017 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0010 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.0003 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.0003 sec
SHOW COLUMNS FROM `widget` 0.0007 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0009 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0003 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 `sys_traffic` 0.0011 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-04-05' 0.0033 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2026-04-04' AND ( `config_id` = 1 ) 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0011 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0022 sec
SHOW COLUMNS FROM `menu` 0.0009 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '1' AND `enabled` = 1 ORDER BY `urut` 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` = '1' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '2' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '3' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '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.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` = '5' 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` = '6' 0.0001 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.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` = '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.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` = '9' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0006 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.0006 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.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '12' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '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.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` = '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.0007 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND ( `id` = 'berita' OR `slug` = 'berita' ) 0.0010 sec
SHOW COLUMNS FROM `menu` 0.0006 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '44' AND `enabled` = 1 ORDER BY `urut` 0.0285 sec
SHOW COLUMNS FROM `kategori` 0.0024 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0003 sec
SHOW COLUMNS FROM `kategori` 0.0020 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.0008 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.0002 sec
SHOW COLUMNS FROM `artikel` 0.0009 sec
SHOW COLUMNS FROM `artikel` 0.0008 sec
SHOW COLUMNS FROM `artikel` 0.0008 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-05 11:04:58' 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-05 11:04:58' 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-05 11:04:58') 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-05 11:04:58')ORDER BY RAND() LIMIT 10 0.0022 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-05 11:04:58'ORDER BY tgl_upload DESC LIMIT 10 0.0006 sec
SHOW COLUMNS FROM `widget` 0.0067 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `config` 0.0008 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0006 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.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' 0.0005 sec
SHOW COLUMNS FROM `agenda` 0.0006 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) > CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' ORDER BY `g`.`tgl_agenda` 0.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.0004 sec
SHOW COLUMNS FROM `komentar` 0.0009 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.0006 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-04-05 11:04:58' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0071 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-05 11:04:58' ORDER BY `a`.`hit` DESC LIMIT 7 0.0685 sec
SHOW COLUMNS FROM `artikel` 0.0040 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-05 11:04:58' ORDER BY rand() LIMIT 7 0.0042 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0008 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.0008 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 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 `keuangan_master` 0.0006 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
Total Execution Time 0.3146 sec
Host:mysql-server-opensid_ORM/opensid8001select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 16.4500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 1.0500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.7500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.9600 sec
select * from `config` limit 1 0.4100 sec
select count(*) as aggregate from `config` 0.3300 sec
select count(*) as aggregate from `config` 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'setting_aplikasi' 2.7200 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 1.4000 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 2.5800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 1.2800 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.3100 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan' 0.9300 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.2300 sec
select count(*) as aggregate from `config` 0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.0000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2800 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists` 0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan' 1.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan' 0.7700 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 1.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 1.4100 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Minggu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.8600 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` = 'Minggu' and (time(`jam_masuk`) > '11:04' or date_add(jam_keluar, interval 10 minute) < '11:04') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 4.6300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa' 3.2700 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.3000 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.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.8800 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' 3.7000 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.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.8800 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.7200 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.9000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.0600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.1400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7800 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.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2100 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.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 1.0700 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 = 'config' 0.8700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2200 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.1400 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.8500 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.7100 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' 1.9100 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.7000 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.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.8400 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.8800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.7800 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.7400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9800 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.6300 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.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' 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' 1.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa' 0.9200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 1 and `tanggal` = '2026-04-05' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config' 0.9800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1 0.1400 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.7100 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong' 1.5200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa' 0.6800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 1 and `tanggal` = '2026-04-05' 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.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' 0.6300 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1600 sec
Total Execution Time 89.5600 sec
89.8746 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 (13) /public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/meta.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/source_css.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/loading_screen.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/category_menu.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/main_menu.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/mobile_menu.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/header.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/partials/idm/index.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/back_to_top.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/footer.php
/public_html/opensid8001/donjo-app/views/head_tags_front.php
/public_html/opensid8001/donjo-app/views/../../vendor/themes/esensi/commons/source_js.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:1775361892
artikel:Array ( )
pengunjungOnline:2026-04-05
Models (32)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_model
statistik_pengunjung_model
first_menu_m
teks_berjalan_model
first_artikel_m
web_sosmed_model
shortcode_model
keuangan_grafik_model
keuangan_model
keuangan_grafik_manual_model
keuangan_manual_model
laporan_penduduk_model
program_bantuan_model
penduduk_model
keluarga_model
web_dokumen_model
referensi_model
penduduk_log_model
rtm_model
kelompok_model
wilayah_model
pamong_model
keuangan_grafik_dd_model
web_widget_model
first_gallery_m
pengaduan_model
statistik_penduduk_model