Website Resmi Desa Wateswinangun Kecamatan Sambeng Kabupaten Lamongan

Kode	Kelompok	Jumlah
1	Di bawah 1 Tahun	2	0,06%
2	2 s/d 4 Tahun	90	2,83%
3	5 s/d 9 Tahun	119	3,74%
4	10 s/d 14 Tahun	175	5,51%
5	15 s/d 19 Tahun	208	6,54%
6	20 s/d 24 Tahun	183	5,76%
7	25 s/d 29 Tahun	215	6,77%
8	30 s/d 34 Tahun	225	7,08%
9	35 s/d 39 Tahun	212	6,67%
10	40 s/d 44 Tahun	237	7,46%
11	45 s/d 49 Tahun	235	7,39%
12	50 s/d 54 Tahun	293	9,22%
13	55 s/d 59 Tahun	245	7,71%
14	60 s/d 64 Tahun	216	6,80%
15	65 s/d 69 Tahun	192	6,04%
16	70 s/d 74 Tahun	127	4,00%
17	Di atas 75 Tahun	204	6,42%
	JUMLAH	3178	100,00%
	BELUM MENGISI	0	0,00%
	TOTAL	3178	100,00%

CodeIgniter version : 3.1.11

CodeIgniter documentation

DevelBar version : 1.2.2

PHP version : 7.4.33

Default language : Indonesia
0.3179 sec

Loading Time: Base Classes : 0.0021 sec

Controller Execution Time ( First / Statistik ) : 0.1699 sec
7.9MB
Request : first/statistik

Method : GET
Database

Host:localhost/desj9119_wateswinangundb

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.0005 sec

SHOW TABLES FROM `desj9119_wateswinangundb` 0.0007 sec

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

SHOW DATABASES 0.0068 sec

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

SELECT * FROM `migrasi` WHERE `versi_database` = '2022070101' 0.0002 sec

SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0002 sec

SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.216.148' ) AND `status` = 1 0.0003 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.0002 sec

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

SELECT * FROM `menu` WHERE `link` = 'statistik/13' AND `enabled` = 1 0.0002 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.1199 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.0023 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2026-04-06' 0.0002 sec

UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"74.7.242.17\",\"2001:4860:7:806::e9\",\"74.7.242.40\",\"199.244.88.224\",\"216.244.66.249\",\"66.249.66.160\",\"66.249.66.74\",\"66.249.66.199\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.73.216.148\",\"216.244.66.249\",\"177.4.115.112\",\"2.58.56.31\",\"216.73.216.148\",\"2001:4860:7:406::de\",\"47.128.126.63\",\"47.128.126.6\",\"103.247.9.9\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"47.251.127.133\",\"66.249.66.74\",\"2602:80d:1007::55\",\"2602:80d:1008::96\",\"51.89.129.151\",\"2a03:2880:f802:27::\",\"66.249.66.11\",\"74.7.242.6\",\"74.7.243.224\",\"217.216.37.57\",\"104.248.60.32\",\"34.28.21.120\",\"216.244.66.249\",\"103.83.237.25\",\"103.83.237.25\",\"103.83.237.25\"]}', `Jumlah` = 82 WHERE `Tanggal` = '2026-04-06' 0.0004 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2026-04-06' 0.0002 sec

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

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

SELECT * FROM `menu` WHERE `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '32' OR `a`.`id` = '32' ) 0.0004 sec

SELECT * FROM `menu` WHERE `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '32' OR `a`.`id` = '32' ) 0.0004 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` < NOW() AND ( `a`.`slug` = '92' OR `a`.`id` = '92' ) 0.0004 sec

SELECT * FROM `menu` WHERE `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '92' OR `a`.`id` = '92' ) 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`.`enabled` = 1 AND `a`.`tgl_upload` < NOW() AND ( `a`.`slug` = '97' OR `a`.`id` = '97' ) 0.0003 sec

SELECT * FROM `menu` WHERE `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '115' OR `a`.`id` = '115' ) 0.0003 sec

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

SELECT * FROM `menu` WHERE `parrent` = 0 AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '32' OR `a`.`id` = '32' ) 0.0003 sec

SELECT * FROM `menu` WHERE `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '32' OR `a`.`id` = '32' ) 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`.`enabled` = 1 AND `a`.`tgl_upload` < NOW() AND ( `a`.`slug` = '92' OR `a`.`id` = '92' ) 0.0003 sec

SELECT * FROM `menu` WHERE `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '92' OR `a`.`id` = '92' ) 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`.`enabled` = 1 AND `a`.`tgl_upload` < NOW() AND ( `a`.`slug` = '97' OR `a`.`id` = '97' ) 0.0003 sec

SELECT * FROM `menu` WHERE `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0002 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` < NOW() AND ( `a`.`slug` = '115' OR `a`.`id` = '115' ) 0.0003 sec

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

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

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

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

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0002 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.0002 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` < NOW() AND ( `a`.`slug` = '' OR `a`.`id` = '' ) 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`.`enabled` = 1 AND `a`.`tgl_upload` < NOW() AND ( `a`.`slug` = '' OR `a`.`id` = '' ) 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 `headline` = 3 AND `gambar` != '' AND `tgl_upload` < NOW() 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` < NOW() 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` < NOW()) 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` < NOW())ORDER BY RAND() LIMIT 10 0.0006 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` < NOW() ORDER BY `tgl_upload` DESC LIMIT 10 0.0003 sec

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

SELECT * FROM `anjungan` WHERE ( `ip_address` = '216.73.216.148' ) AND `status` = 1 0.0002 sec

SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4 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 `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) = CURDATE() 0.0002 sec

SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) > CURDATE() ORDER BY `g`.`tgl_agenda` 0.0002 sec

SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) < CURDATE() 0.0002 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.0003 sec

SELECT * FROM `media_sosial` WHERE `enabled` = 1 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` < NOW() ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0003 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < NOW() ORDER BY `a`.`hit` DESC LIMIT 7 0.0003 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < NOW() ORDER BY rand() LIMIT 7 0.0007 sec

SELECT dp.jabatan, dp.pamong_niap, 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` WHERE `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` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0035 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.0021 sec

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

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0002 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 `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0001 sec

Total Execution Time 0.1520 sec

0.1520 sec
N/A
Method Status URL Time Profiler
Libraries (17)

Benchmark

Config

Hooks

Input

Lang

Loader

Log

Output

Router

Security

Session

Spreadsheet_Excel_Reader

Statistik_pengunjung

URI

Upload

User_agent

Utf8
Helpers (12)

Database_helper

Date_helper

Donjolib_helper

File_helper

Language_helper

Opensid_helper

Password_helper

Pict_helper

Surat_helper

Text_helper

Url_helper

Utility_helper

Views (11)

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/global/validasi_form.php

Array
(
    [web_ui] => 1
)

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/head_tags_front.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/commons/meta.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/header.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/menu_head.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/statistik.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/bottom_content_right.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/footer_top.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/partials/footer_bottom.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/commons/meta_footer.php

+ /home/desj9119/public_html/wateswinangun.desa.id/donjo-app/views/../../themes/natra/layouts/stat.tpl.php

Configuration

base_url:https://wateswinangun.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:/home/desj9119/public_html/wateswinangun.desa.id/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
useDatabaseConfig:1
demo_mode:
defaultAdminAuthInfo:Array ( [username] => admin [password] => sid304 )
user_admin:0
Session

__ci_last_regenerate:1775442864
artikel:Array ( )
pengunjungOnline:2026-04-06
Models (48)

config_model

setting_model

database_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

web_artikel_model

agenda_model

keluar_model

data_persil_model

user_model

grup_model

mandiri_model

anjungan_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

theme_model

first_menu_m

teks_berjalan_model

web_widget_model

first_gallery_m

Hari ini	:	82
Kemarin	:	87
Total Pengunjung	:	41.181
Sistem Operasi	:	Unknown Platform
IP Address	:	216.73.216.148
Browser	:	Mozilla 5.0

Data Demografi Berdasar Umur (Rentang)

Tabel Umur (Rentang)

Statistik Penduduk

Wilayah Desa

Lokasi Kantor Desa

Statistik Pengunjung

Alamat	:	Jl. Kambangan-Garung no.01 Grenjengan
Desa	:	Wateswinangun
Kecamatan	:	Sambeng
Kabupaten	:	Lamongan
Kodepos	:	62284
Telepon	:
Email	: