Menu Kategori

Layanan Mandiri Login Admin

Desa Sangkan Gunung

Kec. Sidemen, Kab. Karangasem, Provinsi Bali

SELAMAT DATANG DI WEBSITE RESMI DESA SANGKAN GUNUNG, KEC. SIDEMEN, KAB. KARANGASEM

Wilayah Administratif

Data Penduduk Menurut Umur (Rentang)

Grafik Umur (Rentang)

Tabel Umur (Rentang)

No	Kelompok	Jumlah		Laki-laki		Perempuan
No	Kelompok	n	%	n	%	n	%
1	0 S/D 1 TAHUN	1	0,01%	0	0,00%	1	0,01%
2	2 s/d 4 Tahun	5	0,06%	2	0,02%	3	0,03%
3	5 s/d 9 Tahun	150	1,74%	71	0,82%	79	0,92%
4	10 s/d 14 Tahun	558	6,47%	295	3,42%	263	3,05%
5	15 s/d 19 Tahun	677	7,85%	354	4,11%	323	3,75%
6	20 s/d 24 Tahun	789	9,15%	390	4,52%	399	4,63%
7	25 s/d 29 Tahun	702	8,14%	381	4,42%	321	3,72%
8	30 s/d 34 Tahun	580	6,73%	296	3,43%	284	3,29%
9	35 s/d 39 Tahun	691	8,02%	350	4,06%	341	3,96%
10	40 s/d 44 Tahun	709	8,23%	360	4,18%	349	4,05%
11	45 s/d 49 Tahun	736	8,54%	373	4,33%	363	4,21%
12	50 s/d 54 Tahun	704	8,17%	373	4,33%	331	3,84%
13	55 s/d 59 Tahun	542	6,29%	271	3,14%	271	3,14%
14	60 s/d 64 Tahun	436	5,06%	209	2,42%	227	2,63%
15	65 s/d 69 Tahun	429	4,98%	204	2,37%	225	2,61%
16	70 s/d 74 Tahun	285	3,31%	137	1,59%	148	1,72%
17	Di atas 60 Tahun	1776	20,60%	864	10,02%	912	10,58%
	JUMLAH	9770	113,34%	4930	57,19%	4840	56,15%
	BELUM MENGISI	-1150	-13,34%	-550	-6,38%	-600	-6,96%
	TOTAL	8620	100,00%	4380	50,81%	4240	49,19%

CodeIgniter version : 3.1.13

CodeIgniter documentation

DevelBar version : 1.2.2

PHP version : 7.4.33

Default language : Indonesia
0.5232 sec

Loading Time: Base Classes : 0.0024 sec

Controller Execution Time ( First / Statistik ) : 0.3764 sec
5.41MB
Request : first/statistik

Method : GET
Database

Host:localhost/u534618643_websgunung

SHOW TABLES FROM `u534618643_websgunung` 0.0008 sec

SELECT * FROM `setting_aplikasi` ORDER BY `key` 0.0003 sec

SHOW DATABASES 0.0911 sec

SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'u534618643_websgunung' AND table_name = 'user' 0.0002 sec

SELECT * FROM `migrasi` WHERE `versi_database` = '2022120107' 0.0001 sec

INSERT INTO `setting_modul` (`id`, `modul`, `url`, `aktif`, `ikon`, `urut`, `level`, `parent`, `hidden`, `ikon_kecil`) VALUES ('313', 'Layanan Pelanggan', 'pelanggan', '1', 'fa-credit-card', '5', '0', '200', '0', 'fa-credit-card') ON DUPLICATE KEY UPDATE modul = VALUES(modul), url = VALUES(url), ikon = VALUES(ikon), hidden = VALUES(hidden), urut = VALUES(urut), parent = VALUES(parent) 0.0001 sec

INSERT INTO `grup_akses` (`id_grup`, `id_modul`, `akses`) VALUES (2, '313', 3) 0.0001 sec

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('api_key_opensid', '', 'Opensid API Key untuk Pelanggan OpenDesa', '') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0001 sec

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_server', 'https://layanan.opendesa.id', 'Alamat Server Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0001 sec

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_dev_server', '', 'Alamat Server Dev Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0002 sec

INSERT INTO `setting_aplikasi` (`key`, `value`, `jenis`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_token', '', 'textarea', 'Token pelanggan Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0002 sec

DELETE FROM `setting_aplikasi` WHERE `key` = 'api_key_opensid' 0.0001 sec

UPDATE `setting_aplikasi` SET `kategori` = 'pelanggan' WHERE `key` IN('layanan_opendesa_server', 'layanan_opendesa_dev_server', 'layanan_opendesa_token') 0.0001 sec

DELETE FROM `setting_aplikasi` WHERE `key` IN('layanan_opendesa_server', 'layanan_opendesa_dev_server', 'dev_tracker') 0.0002 sec

INSERT INTO `setting_modul` (`id`, `modul`, `url`, `aktif`, `ikon`, `urut`, `level`, `hidden`, `ikon_kecil`, `parent`) VALUES (331, 'Pendaftaran Kerjasama', 'pendaftaran_kerjasama', 1, 'fa-list', 6, 2, 0, 'fa-list', 200) ON DUPLICATE KEY UPDATE modul = VALUES(modul), url = VALUES(url), ikon = VALUES(ikon), hidden = VALUES(hidden), urut = VALUES(urut), parent = VALUES(parent) 0.0001 sec

INSERT INTO `grup_akses` (`id_grup`, `id_modul`, `akses`) VALUES (2, 331, 3) 0.0001 sec

SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa FROM `config` `c` LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id` LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id` 0.0002 sec

SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0001 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`.`id` IS NULL 0.0001 sec

SELECT * FROM `analisis_periode` WHERE `aktif` = 1 AND `id_master` IS NULL 0.0001 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`.`id` IS NULL 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/13' AND `enabled` = 1 0.0001 sec

SELECT (SELECT COUNT(b.id) FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai`) as jumlah, (SELECT COUNT(b.id) FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE `b`.`sex` = '1' AND (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai`) as laki, (SELECT COUNT(b.id) FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` WHERE `b`.`sex` = '2' AND (DATE_FORMAT(FROM_DAYS(TO_DAYS( NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) >= `u`.`dari` AND (DATE_FORMAT(FROM_DAYS( TO_DAYS(NOW()) - TO_DAYS(tanggallahir)), '%Y')+0) <= `u`.`sampai`) as perempuan, `u`.* FROM `tweb_penduduk_umur` `u` WHERE `u`.`status` = '1' 0.2230 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` 0.0026 sec

SELECT * FROM `widget` WHERE `jenis_widget` <> 3 AND `enabled` = 1 0.0001 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2026-05-04' 0.0001 sec

UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.217.9\",\"216.73.217.9\",\"216.73.217.9\",\"216.73.217.9\",\"216.73.217.9\",\"216.73.217.9\",\"216.73.217.9\",\"181.40.48.160\",\"2a02:4780:6:c0de::8\",\"82.152.73.18\",\"52.167.144.182\",\"82.24.133.199\",\"175.27.171.245\",\"206.189.175.218\",\"76.35.86.97\",\"192.71.126.151\",\"192.71.142.146\",\"192.71.126.151\",\"192.71.142.40\",\"52.167.144.218\",\"200.115.98.5\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"177.7.52.111\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"2a02:4780:75:45b5::1\",\"213.55.247.147\",\"79.33.115.125\",\"14.230.65.147\",\"14.255.59.161\",\"91.218.162.201\",\"37.61.121.131\",\"70.191.86.194\",\"14.245.121.200\",\"180.148.211.49\",\"82.39.156.191\",\"82.41.70.155\",\"82.38.237.151\",\"82.24.168.248\",\"200.50.152.6\"]}', `Jumlah` = 63 WHERE `Tanggal` = '2026-05-04' 0.0002 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2026-05-04' 0.0001 sec

SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2026-05-03' 0.0001 sec

SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` 0.0003 sec

SELECT * FROM `menu` WHERE `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '32' 0.0002 sec

SELECT * FROM `menu` WHERE `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '32' 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '99' 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '85' 0.0001 sec

SELECT * FROM `menu` WHERE `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '93' 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '92' 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`id` = '97' 0.0001 sec

SELECT * FROM `menu` WHERE `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec

SELECT * FROM `menu` WHERE `parrent` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec

SELECT * FROM `menu` WHERE `parrent` = '116' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0001 sec

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0001 sec

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0001 sec

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0001 sec

SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload` FROM `teks_berjalan` `t` LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id` WHERE `status` = 1 ORDER BY `urut` 0.0001 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`.`enabled` = 1 AND `a`.`tgl_upload` < '2026-05-04 11:18:45' AND `a`.`slug` = '' 0.0002 sec

SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar` != '' AND `tgl_upload` < '2026-05-04 11:18:45' UNION SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar1` != '' AND `tgl_upload` < '2026-05-04 11:18:45' UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar2` != '' AND `tgl_upload` < '2026-05-04 11:18:45') UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar3` != '' AND `tgl_upload` < '2026-05-04 11:18:45')ORDER BY RAND() LIMIT 10 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 `enabled` = 1 AND `gambar` != '' AND `tgl_upload` < '2026-05-04 11:18:45' ORDER BY `tgl_upload` DESC LIMIT 10 0.0001 sec

SELECT * FROM `widget` WHERE `enabled` = 1 ORDER BY `urut` 0.0001 sec

SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.217.9' ) AND `status` = 1 0.0001 sec

SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4 0.0001 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 `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) = CURDATE() 0.0001 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 `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) > CURDATE() ORDER BY `g`.`tgl_agenda` 0.0001 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 `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) < CURDATE() 0.0001 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`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0001 sec

SELECT * FROM `media_sosial` WHERE `enabled` = 1 0.0001 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-05-04 11:18:45' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0002 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-05-04 11:18:45' ORDER BY `a`.`hit` DESC LIMIT 7 0.0001 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2026-05-04 11:18:45' ORDER BY rand() LIMIT 7 0.0008 sec

SELECT dp.jabatan, dp.pamong_niap, k.status_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 `kehadiran_perangkat_desa` `k` ON `k`.`pamong_id` = `dp`.`pamong_id` WHERE `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0007 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` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0045 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` 0.0025 sec

SELECT `setting` FROM `widget` WHERE `isi` = 'sinergi_program.php' 0.0001 sec

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0001 sec

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/13' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/15' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/0' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/14' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/1' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/2' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/3' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/4' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/hubungan_kk' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/5' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/6' AND `enabled` = 1 0.0000 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/7' AND `enabled` = 1 0.0000 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/9' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/10' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/16' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/17' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/18' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/19' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/covid' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/suku' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/bpjs-tenagakerja' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/kelas_sosial' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/bantuan_penduduk' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/bantuan_keluarga' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/501' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/502' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/503' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/504' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'statistik/505' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'dpt' AND `enabled` = 1 0.0001 sec

SELECT * FROM `menu` WHERE `link` = 'data-wilayah' AND `enabled` = 1 0.0001 sec

Total Execution Time 0.3349 sec

0.3349 sec
N/A
Method Status URL Time Profiler
Libraries (18)

Benchmark

Cache

Config

Hooks

Input

Lang

Loader

Log

Output

Router

Security

Session

Spreadsheet_Excel_Reader

Statistik_pengunjung

URI

Upload

User_agent

Utf8
Helpers (13)

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 (14)

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/meta.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/source_css.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/loading_screen.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/category_menu.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/main_menu.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/mobile_menu.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/header.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/partials/statistics/sidenav.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/partials/statistics/default.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/back_to_top.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/footer.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/head_tags_front.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/commons/source_js.php

+ /home/u534618643/domains/sangkangunung-desa.id/public_html/donjo-app/views/../../vendor/themes/esensi/layouts/stat.tpl.php

Configuration

base_url:https://www.sangkangunung-desa.id/
index_page:index.php/
uri_protocol:REQUEST_URI
url_suffix:
language:indonesia
charset:UTF-8
enable_hooks:1
subclass_prefix:MY_
composer_autoload:vendor/autoload.php
permitted_uri_chars:a-z 0-9~%.:_\-
enable_query_strings:
controller_trigger:c
function_trigger:m
directory_trigger:d
allow_get_array:1
log_threshold:1
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: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 ( )
compress_output:
time_reference:local
rewrite_short_tags:
proxy_ips:
server_pantau:https://pantau.opensid.my.id
token_pantau:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw
server_layanan:https://layanan.opendesa.id
rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest
rilis_premium:https://api.github.com/repos/opensid/rilis-premium/releases/latest
views_blade:resources//views/
cache_blade:storage//framework/views/
useDatabaseConfig:1
demo_mode:
defaultAdminAuthInfo:Array ( [username] => admin [password] => sid304 )
user_admin:0
Session

__ci_last_regenerate:1777868325
daftar_migrasi:Array ( [0] => migrasi_layanan )
artikel:Array ( )
pengunjungOnline:2026-05-04
Models (44)

config_model

setting_model

database_model

migrasi_layanan

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

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

first_menu_m

teks_berjalan_model

web_widget_model

first_gallery_m

anjungan_model

pengaduan_model

Statistik Penduduk

Statistik Keluarga

Statistik Bantuan

Statistik Lainnya

Data Penduduk Menurut Umur (Rentang)

Grafik Umur (Rentang)

Tabel Umur (Rentang)