Website Resmi Desa Wateswinangun Kecamatan Sambeng Kabupaten Lamongan

No	Wilayah / Ketua	KK	L+P	L	P
1	Dusun TLATAH , Ketua Rosid Tanto	365	1275	709	566
	1	RW 01	138	487	265	222
		1	RT 001	57	203	102	101
		2	RT 002	45	150	90	60
		3	RT 003	35	129	70	59
	2	RW 02	102	337	177	160
		1	RT 001	37	123	66	57
		2	RT 002	49	165	88	77
		3	RT 003	16	49	23	26
	3	RW 03	125	451	267	184
		1	RT 001	34	128	79	49
		2	RT 002	41	153	90	63
		3	RT 003	49	168	97	71
2	Dusun SAHAR , Ketua Hari Subagiyo	251	989	506	483
	1	RW 04	130	471	231	240
		1	RT 001	51	172	87	85
		2	RT 002	47	180	87	93
		3	RT 003	32	119	57	62
	2	RW 05	83	357	185	172
		1	RT 001	40	166	82	84
		2	RT 002	30	132	73	59
		3	RT 003	13	59	30	29
	3	RW 06	38	161	90	71
		1	RT 001	32	149	81	68
		2	RT 002	6	12	9	3
3	Dusun GRENJENGAN , Ketua Jasman	197	637	322	315
	1	RW 07	121	394	202	192
		1	RT 001	47	154	75	79
		2	RT 002	55	171	90	81
		3	RT 003	19	68	36	32
	2	RW 08	76	243	120	123
		1	RT 001	33	98	47	51
		2	RT 002	43	145	73	72
4	Dusun JUWOK , Ketua MIYONO	86	277	139	138
	1	RW 009	86	277	139	138
		1	RT 001	46	159	79	80
		2	RT 002	40	118	60	58
TOTAL	899	3178	1676	1502

CodeIgniter version : 3.1.11

CodeIgniter documentation

DevelBar version : 1.2.2

PHP version : 7.4.33

Default language : Indonesia
1.7486 sec

Loading Time: Base Classes : 0.0136 sec

Controller Execution Time ( First / Wilayah ) : 0.7061 sec
7.79MB
Request : first/wilayah

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

SHOW TABLES FROM `desj9119_wateswinangundb` 0.0009 sec

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

SHOW DATABASES 0.0046 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.0001 sec

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

SELECT * FROM `anjungan` WHERE ( `ip_address` = '3.144.3.100' ) AND `status` = 1 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`.`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` = 'data-wilayah' AND `enabled` = 1 0.0005 sec

SELECT u.*, a.nama AS nama_kadus, a.nik AS nik_kadus, (SELECT COUNT(rw.id) FROM tweb_wil_clusterdesa rw WHERE dusun = u.dusun AND rw <> '-' AND rt = '-') AS jumlah_rw, (SELECT COUNT(v.id) FROM tweb_wil_clusterdesa v WHERE dusun = u.dusun AND v.rt <> '0' AND v.rt <> '-') AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = u.dusun)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = u.dusun) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = u.dusun) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala = p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = u.dusun) AND p.kk_level = 1) AS jumlah_kk FROM tweb_wil_clusterdesa u LEFT JOIN penduduk_hidup a ON u.id_kepala = a.id WHERE u.rt = '0' AND u.rw = '0' ORDER BY`u`.`urut` ASC LIMIT 0,500 0.0728 sec

SELECT * FROM `tweb_wil_clusterdesa` WHERE `id` = '9' 0.0003 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE dusun = u.dusun AND rw = u.rw AND rt <> '-' AND rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'TLATAH' ORDER BY `u`.`urut` ASC 0.0628 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '-' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '-' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '-' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '-' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'TLATAH' ORDER BY `u`.`urut` ASC 0.0025 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '01' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '01' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '01' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '01' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '01' AND `u`.`dusun` = 'TLATAH' ORDER BY `u`.`urut` ASC 0.0292 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '02' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '02' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '02' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '02' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '02' AND `u`.`dusun` = 'TLATAH' ORDER BY `u`.`urut` ASC 0.0280 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '03' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '03' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '03' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'TLATAH' AND rw = '03' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '03' AND `u`.`dusun` = 'TLATAH' ORDER BY `u`.`urut` ASC 0.0308 sec

SELECT * FROM `tweb_wil_clusterdesa` WHERE `id` = '5' 0.0002 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE dusun = u.dusun AND rw = u.rw AND rt <> '-' AND rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'SAHAR' ORDER BY `u`.`urut` ASC 0.0631 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '-' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '-' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '-' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '-' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'SAHAR' ORDER BY `u`.`urut` ASC 0.0023 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '04' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '04' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '04' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '04' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '04' AND `u`.`dusun` = 'SAHAR' ORDER BY `u`.`urut` ASC 0.0275 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '05' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '05' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '05' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '05' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '05' AND `u`.`dusun` = 'SAHAR' ORDER BY `u`.`urut` ASC 0.0274 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '06' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '06' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '06' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'SAHAR' AND rw = '06' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '06' AND `u`.`dusun` = 'SAHAR' ORDER BY `u`.`urut` ASC 0.0190 sec

SELECT * FROM `tweb_wil_clusterdesa` WHERE `id` = '1' 0.0003 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE dusun = u.dusun AND rw = u.rw AND rt <> '-' AND rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'GRENJENGAN' ORDER BY `u`.`urut` ASC 0.0469 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '-' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '-' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '-' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '-' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'GRENJENGAN' ORDER BY `u`.`urut` ASC 0.0023 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '07' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '07' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '07' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '07' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '07' AND `u`.`dusun` = 'GRENJENGAN' ORDER BY `u`.`urut` ASC 0.0279 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '08' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '08' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '08' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'GRENJENGAN' AND rw = '08' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '08' AND `u`.`dusun` = 'GRENJENGAN' ORDER BY `u`.`urut` ASC 0.0212 sec

SELECT * FROM `tweb_wil_clusterdesa` WHERE `id` = '13' 0.0002 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE dusun = u.dusun AND rw = u.rw AND rt <> '-' AND rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = u.rw)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = u.rw) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = u.rw) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = u.rw) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` = '0' AND `u`.`rw` <> '0' AND `u`.`dusun` = 'JUWOK' ORDER BY `u`.`urut` ASC 0.0334 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '009' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '009' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '009' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '009' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '009' AND `u`.`dusun` = 'JUWOK' ORDER BY `u`.`urut` ASC 0.0213 sec

SELECT `u`.*, `a`.`nama` AS `nama_ketua`, `a`.`nik` AS `nik_ketua`, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '-' AND rt = u.rt)) AS jumlah_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '-' AND rt = u.rt) AND p.sex = 1) AS jumlah_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '-' AND rt = u.rt) AND p.sex = 2) AS jumlah_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = 'JUWOK' AND rw = '-' AND rt = u.rt) AND p.kk_level = 1) AS jumlah_kk FROM `tweb_wil_clusterdesa` `u` LEFT JOIN `penduduk_hidup` `a` ON `u`.`id_kepala` = `a`.`id` WHERE `u`.`rt` <> '0' AND `u`.`rt` <> '-' AND `u`.`rw` = '-' AND `u`.`dusun` = 'JUWOK' ORDER BY `u`.`urut` ASC 0.0022 sec

SELECT (SELECT COUNT(rw.id) FROM tweb_wil_clusterdesa rw WHERE rw <> '-' AND rt = '-') AS total_rw, (SELECT COUNT(v.id) FROM tweb_wil_clusterdesa v WHERE v.rt <> '0' AND v.rt <> '-') AS total_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa)) AS total_warga, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.sex = 1) AS total_warga_l, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.sex = 2) AS total_warga_p, (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.kk_level = 1) AS total_kk FROM tweb_wil_clusterdesa u LEFT JOIN penduduk_hidup a ON u.id_kepala = a.id WHERE u.rt = '0' AND u.rw = '0' limit 1 0.0165 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2025-04-19' 0.0001 sec

UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"3.144.3.100\",\"3.16.70.193\",\"66.249.73.161\",\"66.249.73.160\",\"128.199.248.253\",\"128.199.248.253\",\"51.8.102.39\",\"2a00:da00:f429:ca00::1\",\"159.223.64.75\",\"66.249.74.160\",\"103.247.9.9\"]}', `Jumlah` = 11 WHERE `Tanggal` = '2025-04-19' 0.0008 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2025-04-19' 0.0002 sec

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

SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` 0.0023 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` < NOW() AND ( `a`.`slug` = '32' OR `a`.`id` = '32' ) 0.0025 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` < 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.0003 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` < 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.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` < 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.0001 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` < 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.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` < 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.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` < 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.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` < 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.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.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` = '' 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.0001 sec

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

SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4 0.0006 sec

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

SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0001 sec

SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` 0.0001 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 `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.5615 sec

0.5615 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/wilayah.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:1745054448
artikel:Array ( )
pengunjungOnline:2025-04-19
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

theme_model

first_menu_m

teks_berjalan_model

web_widget_model

first_gallery_m

statistik_penduduk_model

Hari ini	:	11
Kemarin	:	37
Total Pengunjung	:	14.887
Sistem Operasi	:	Unknown Platform
IP Address	:	3.144.3.100
Browser	:	Mozilla 5.0

Data Demografi Berdasar Populasi Per Wilayah

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	: