|
CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
0.5389 secLoading Time: Base Classes : 0.0006 sec
Controller Execution Time ( First / Index ) : 0.1810 sec
5.35MB
Request : first/indexMethod : GET
DatabaseSHOW TABLES FROM `db_bungamekar` 0.0007 sec
SHOW DATABASES 0.0002 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'db_bungamekar' AND table_name = 'user' 0.0001 sec
SHOW COLUMNS FROM `anjungan` 0.0004 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.216.48' OR `id_pengunjung` IS NULL AND ( `config_id` = 1 ) ) AND `status` = 1 ORDER BY `tipe` ASC 0.0002 sec
SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0001 sec
SHOW COLUMNS FROM `analisis_master` 0.0004 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`id` IS NULL 0.0002 sec
SELECT * FROM `analisis_periode` WHERE `aktif` = 1 AND `id_master` IS NULL 0.0001 sec
SHOW COLUMNS FROM `analisis_master` 0.0004 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE ( `u`.`config_id` = 1 ) AND `u`.`id` IS NULL 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT COUNT(a.id) AS jml FROM `artikel` `a` LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id` LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND (`a`.`headline` != 1) AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-03-16 15:30:14' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` `a` LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id` LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND (`a`.`headline` != 1) AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-03-16 15:30:14' ORDER BY `a`.`tgl_upload` DESC LIMIT 8 0.0005 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `a`.*, `u`.`nama` AS `owner`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` `a` LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `headline` = 1 AND `a`.`tgl_upload` < '2026-03-16 15:30:14' ORDER BY `tgl_upload` DESC 0.0003 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
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.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.0005 sec
SHOW COLUMNS FROM `widget` 0.0003 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-03-16' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.216.48\",\"64.89.163.113\",\"85.208.96.195\",\"216.73.216.48\",\"216.73.216.48\",\"216.73.216.48\",\"129.226.174.80\",\"48.192.92.29\",\"43.130.47.33\",\"43.164.196.57\",\"66.249.68.34\",\"43.157.95.239\",\"170.106.140.110\",\"35.185.241.202\",\"43.166.1.243\",\"123.25.142.85\",\"47.128.119.159\",\"40.77.167.13\",\"201.71.62.75\",\"66.249.68.33\",\"66.249.68.34\",\"43.173.182.4\",\"43.173.179.142\",\"49.51.39.209\",\"170.106.180.153\",\"170.106.72.93\",\"43.165.189.110\",\"43.157.147.3\",\"66.249.68.32\",\"116.179.37.157\",\"49.51.196.42\",\"34.206.76.135\",\"175.141.177.53\",\"168.228.37.173\",\"103.152.7.250\",\"47.128.45.87\",\"43.163.23.202\",\"43.152.72.244\",\"85.208.96.201\",\"43.130.101.151\",\"103.152.7.250\",\"103.152.7.250\",\"103.152.7.250\",\"43.166.242.189\",\"192.36.109.104\",\"192.36.109.89\",\"192.36.109.125\",\"192.36.109.90\"]}', `Jumlah` = 48 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-03-16' 0.0005 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2026-03-16' 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2026-03-15' AND ( `config_id` = 1 ) 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0010 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '32' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '98' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '7' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '85' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '93' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '92' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '37' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '38' 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '19' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '62' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '64' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '63' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '97' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '127' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '128' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '99' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '130' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '1' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '22' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '23' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0003 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '24' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0003 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0003 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.0004 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-03-16 15:30:15' 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-03-16 15:30:15' 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-03-16 15:30:15') 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-03-16 15:30:15')ORDER BY RAND() LIMIT 10 0.0007 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `slider` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-03-16 15:30:15'ORDER BY tgl_upload DESC LIMIT 10 0.0004 sec
SHOW COLUMNS FROM `widget` 0.0003 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `config` 0.0004 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0003 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0002 sec
SHOW COLUMNS FROM `agenda` 0.0003 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) = CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0002 sec
SHOW COLUMNS FROM `agenda` 0.0003 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.0002 sec
SHOW COLUMNS FROM `agenda` 0.0003 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) < CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0002 sec
SHOW COLUMNS FROM `komentar` 0.0003 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.* FROM `komentar` `k` JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id` WHERE ( `k`.`config_id` = 1 ) AND `k`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0002 sec
SHOW COLUMNS FROM `media_sosial` 0.0003 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-03-16 15:30:15' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-03-16 15:30:15' ORDER BY `a`.`hit` DESC LIMIT 7 0.0004 sec
SHOW COLUMNS FROM `artikel` 0.0004 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-03-16 15:30:15' ORDER BY rand() LIMIT 7 0.0009 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0004 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama FROM `tweb_desa_pamong` `dp` LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend` LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id` WHERE ( `dp`.`config_id` = 1 ) AND `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0002 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1 LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0005 sec
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE ( `b`.`config_id` = 1 ) 0.0004 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0002 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `log_surat` 0.0004 sec
SELECT * FROM komentar WHERE id_artikel = '166' 0.0002 sec
SELECT * FROM komentar WHERE id_artikel = '167' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '165' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '164' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '163' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '162' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '161' 0.0001 sec
SELECT * FROM komentar WHERE id_artikel = '160' 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0003 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'aparatur_desa.php' 0.0001 sec
Total Execution Time 0.0417 sec
Host:127.0.0.1_ORM/db_bungamekarselect column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 1.1100 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.4200 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.2100 sec
select * from `config` limit 1 0.1500 sec
select count(*) as aggregate from `config` 0.1200 sec
select count(*) as aggregate from `config` 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'setting_aplikasi' 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 0.6700 sec
select * from information_schema.tables where table_schema = 'db_bungamekar' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'ref_jabatan' 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.1900 sec
select * from information_schema.tables where table_schema = 'db_bungamekar' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'ref_jabatan' 0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 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.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select exists(select * from `migrasi` where `versi_database` = 2024050101) as `exists` 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'anjungan' 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'anjungan' 0.3200 sec
select * from information_schema.tables where table_schema = 'db_bungamekar' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'kehadiran_jam_kerja' 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Senin' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'kehadiran_jam_kerja' 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 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`) > '15:30' or date_add(jam_keluar, interval 10 minute) < '15:30') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'kehadiran_perangkat_desa' 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.4000 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.4300 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.4000 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'tweb_desa_pamong' 0.4400 sec
select * from information_schema.tables where table_schema = 'db_bungamekar' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'kehadiran_jam_kerja' 0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3600 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1800 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3800 sec
select exists(select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=') as `exists` 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'db_bungamekar' and table_name = 'config' 0.3700 sec
select * from `config` where `app_key` = 'base64:wgjfijnVf8XW7qgvUpmCwgQ1+DNbt09+Q44yZP5tS9c=' limit 1 0.1700 sec
Total Execution Time 43.8300 sec
43.8717 sec
N/A
Libraries (20)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
Output
Paging
Router
Security
Security_header
Security_trusted_host
Session
Spreadsheet_Excel_Reader
URI
Upload
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 (25) /var/www/bungamekar/donjo-app/views/global/validasi_form.php
/var/www/bungamekar/donjo-app/views/head_tags_front.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/commons/meta.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/header.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/menu_head.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/layouts/teks_berjalan.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/layouts/slider.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/commons/page.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/bottom_content_left.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/statistik.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/sinergi_program.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/aparatur_desa.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/media_sosial.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/menu_kategori.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/arsip_artikel.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/agenda.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/galeri.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/statistik_pengunjung.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/komentar.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/widgets/keuangan.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/bottom_content_right.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/footer_top.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/partials/footer_bottom.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/commons/meta_footer.php
/var/www/bungamekar/donjo-app/views/../../vendor/themes/natra/template.php
Configuration trusted_hosts:Array ( )
base_url:https://bungamekar.desa.id/
index_page:
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:/var/www/bungamekar/desa/cache/
cache_query_string:
encryption_key:lumbungkomunitas
sess_driver:memcached
sess_cookie_name:ci_session
sess_expiration:7200
sess_save_path:localhost:11211
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
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
file_manager:werw333*%^%&%1
user_admin:1
desa:Array ( [desa/anjungan/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/arsip/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/cache/] => Array ( [0] => 509 ) [desa/config/] => Array ( [0] => 509 ) [desa/logo/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/pengaturan/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/images/] => Array ( [0] => 509 ) [desa/template-surat/] => Array ( [0] => 509 ) [desa/template-surat/lampiran/] => Array ( [0] => 509 ) [desa/themes/] => Array ( [0] => 509 ) [desa/upload/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/buku_tamu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dokumen/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/upload/galeri/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/area/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/garis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/point/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/produk/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/sinkronisasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/thumbs/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/user_pict/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/vaksin/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/widgets/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dtks/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )
lainnya:Array ( [storage/framework/] => Array ( [0] => 509 [1] => htaccess3 ) [storage/logs/] => Array ( [0] => 509 [1] => htaccess3 ) [backup_inkremental/] => Array ( [0] => 509 [1] => htaccess3 ) [assets/] => Array ( [0] => 493 [1] => htaccess3 ) [assets/filemanager/] => Array ( [0] => 493 [1] => htaccess4 ) [assets/filemanager/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'] = 'umum'; $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 ( ) ) )
security/headers:Array ( [Strict-Transport-Security] => max-age=31536000; includeSubDomains [X-Content-Type-Options] => nosniff [X-Permitted-Cross-Domain-Policies] => none [Permissions-Policy] => accelerometer=(),ambient-light-sensor=(),autoplay=(),battery=(),camera=(),display-capture=(),document-domain=(),encrypted-media=(),fullscreen=(),gamepad=(),geolocation=(),gyroscope=(),layout-animations=(self),legacy-image-formats=(self),magnetometer=(),microphone=(),midi=(),oversized-images=(self),payment=(),picture-in-picture=(),publickey-credentials-get=(),speaker-selection=(),sync-xhr=(self),unoptimized-images=(self),unsized-media=(self),usb=(),screen-wake-lock=(),web-share=(),xr-spatial-tracking=() [Cross-Origin-Embedder-Policy] => same-origin [Cross-Origin-Resource-Policy] => same-origin [Cross-Origin-Opener-Policy] => same-origin )
Session __ci_last_regenerate:1773649814
artikel:Array ( )
pengunjungOnline:2026-03-16
balik_ke:first
Models (45)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_model
first_artikel_m
web_sosmed_model
shortcode_model
keuangan_grafik_model
keuangan_model
keuangan_grafik_manual_model
keuangan_manual_model
laporan_penduduk_model
program_bantuan_model
penduduk_model
keluarga_model
web_dokumen_model
referensi_model
penduduk_log_model
rtm_model
kelompok_model
wilayah_model
pamong_model
first_penduduk_m
surat_model
penomoran_surat_model
url_shortener_model
track_model
keluar_model
plan_lokasi_model
plan_area_model
plan_garis_model
analisis_import_model
analisis_indikator_model
analisis_master_model
analisis_periode_model
analisis_respon_model
statistik_penduduk_model
statistik_pengunjung_model
first_menu_m
teks_berjalan_model
web_widget_model
first_gallery_m
pengaduan_model
.jpeg)
.jpeg)
.jpeg)
.jpeg)
Pemerintah Desa
Desa Membangun Indonesia
Ketahanan Masyarakat Desa
Penyelenggaraan Pemerintahan Desa
ANGGARAN BELANJA DESA BUNGA MEKAR TAHUN 2025
LAPORAN REALISASI APB DESA PEMERINTAH DESA BUNGA MEKAR TAHUN ANGGARAN 2023
BULAN BAHASA BALI V WARSA 2023
ABPDES BUNGA MEKAR TAHUN 2023
.jpeg)
BULAN BAHASA BALI VI WARSA 2024
PELAKSANAAN BULAN BUNG KARNO VII TAHUN 2025