SHOW TABLES FROM `pans5277_pandansari`
0.0028 sec
SHOW DATABASES
0.0151 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'pans5277_pandansari' AND table_name = 'user'
0.0003 sec
SHOW COLUMNS FROM `anjungan`
0.0004 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '18.97.9.169'
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.0003 sec
SHOW COLUMNS FROM `analisis_master`
0.0006 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.0002 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 `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'data-wilayah'
AND `enabled` = 1
0.0006 sec
SELECT u.*, a.nama AS nama_kadus, a.nik AS nik_kadus,
(SELECT COUNT(rw.id) FROM tweb_wil_clusterdesa rw WHERE rw.config_id = u.config_id AND rw.dusun = u.dusun AND rw <> '-' AND rt = '-') AS jumlah_rw,
(SELECT COUNT(rt.id) FROM tweb_wil_clusterdesa rt WHERE rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rt <> '0' AND rt.rt <> '-') AS jumlah_rt,
(SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.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 c WHERE c.config_id = u.config_id AND c.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 c WHERE c.config_id = u.config_id AND c.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 c WHERE c.config_id = u.config_id AND c.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.config_id = '1' AND u.rt = '0' AND u.rw = '0' ORDER BY`u`.`urut` ASC LIMIT 0,500
0.1004 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '315'
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 rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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`.`config_id` = 1
)
AND `u`.`rt` = '0'
AND `u`.`rw` <> '0'
AND `u`.`dusun` = 'Dusun I'
ORDER BY `u`.`urut` ASC
0.0520 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '-'
AND `u`.`dusun` = 'Dusun I'
ORDER BY `u`.`urut` ASC
0.0019 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '001'
AND `u`.`dusun` = 'Dusun I'
ORDER BY `u`.`urut` ASC
0.0312 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '002'
AND `u`.`dusun` = 'Dusun I'
ORDER BY `u`.`urut` ASC
0.0470 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '327'
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 rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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`.`config_id` = 1
)
AND `u`.`rt` = '0'
AND `u`.`rw` <> '0'
AND `u`.`dusun` = 'Dusun II'
ORDER BY `u`.`urut` ASC
0.0364 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '-'
AND `u`.`dusun` = 'Dusun II'
ORDER BY `u`.`urut` ASC
0.0021 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '003'
AND `u`.`dusun` = 'Dusun II'
ORDER BY `u`.`urut` ASC
0.0540 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '341'
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 rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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`.`config_id` = 1
)
AND `u`.`rt` = '0'
AND `u`.`rw` <> '0'
AND `u`.`dusun` = 'Dusun III'
ORDER BY `u`.`urut` ASC
0.0380 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '-'
AND `u`.`dusun` = 'Dusun III'
ORDER BY `u`.`urut` ASC
0.0020 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '004'
AND `u`.`dusun` = 'Dusun III'
ORDER BY `u`.`urut` ASC
0.0466 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '335'
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 rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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`.`config_id` = 1
)
AND `u`.`rt` = '0'
AND `u`.`rw` <> '0'
AND `u`.`dusun` = 'Dusun IV'
ORDER BY `u`.`urut` ASC
0.0528 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '-'
AND `u`.`dusun` = 'Dusun IV'
ORDER BY `u`.`urut` ASC
0.0053 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '005'
AND `u`.`dusun` = 'Dusun IV'
ORDER BY `u`.`urut` ASC
0.0396 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '006'
AND `u`.`dusun` = 'Dusun IV'
ORDER BY `u`.`urut` ASC
0.0321 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '354'
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 rt.config_id = u.config_id AND rt.dusun = u.dusun AND rt.rw = u.rw AND rt.rt <> '-' AND rt.rt <> '0' ) AS jumlah_rt, (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.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`.`config_id` = 1
)
AND `u`.`rt` = '0'
AND `u`.`rw` <> '0'
AND `u`.`dusun` = 'Dusun V'
ORDER BY `u`.`urut` ASC
0.0525 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '007'
AND `u`.`dusun` = 'Dusun V'
ORDER BY `u`.`urut` ASC
0.0165 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '-'
AND `u`.`dusun` = 'Dusun V'
ORDER BY `u`.`urut` ASC
0.0018 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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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 c WHERE c.config_id = u.config_id AND c.dusun = u.dusun AND c.rw = u.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`.`config_id` = 1
)
AND `u`.`rt` <> '0'
AND `u`.`rt` <> '-'
AND `u`.`rw` = '008'
AND `u`.`dusun` = 'Dusun V'
ORDER BY `u`.`urut` ASC
0.0312 sec
SELECT
(SELECT COUNT(w.id) FROM tweb_wil_clusterdesa w WHERE w.config_id = u.config_id AND w.rw <> '-' AND w.rt = '-') AS total_rw,
(SELECT COUNT(v.id) FROM tweb_wil_clusterdesa v WHERE v.config_id = u.config_id AND 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 c WHERE c.config_id = u.config_id)) AS total_warga,
(SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa c WHERE c.config_id = u.config_id) 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 c WHERE c.config_id = u.config_id) 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 c WHERE c.config_id = u.config_id) 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' AND u.config_id = '1' limit 1
0.0180 sec
SHOW COLUMNS FROM `widget`
0.0005 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-07'
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"13.76.115.253\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"47.82.11.30\",\"2600:1f28:365:80b0:d0c5:bc4b:1a7a:bb5f\",\"2600:1f28:365:80b0:d0c5:bc4b:1a7a:bb5f\",\"43.166.224.244\",\"18.97.9.169\",\"18.97.9.169\",\"170.106.65.93\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"47.128.58.42\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"66.249.71.38\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"47.128.46.74\",\"47.128.35.27\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"43.155.188.157\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"47.128.127.83\",\"47.128.43.248\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"43.131.253.14\",\"18.97.9.169\",\"18.97.9.169\",\"20.194.1.11\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"18.97.9.169\",\"43.153.113.127\",\"18.97.9.169\",\"2a03:2880:f802:43::\",\"216.73.216.223\",\"18.97.9.169\",\"43.157.50.58\",\"49.51.180.2\",\"47.128.35.154\",\"47.128.97.35\",\"43.133.66.51\",\"2001:4860:7:406::ff\",\"47.128.39.97\",\"47.128.53.58\",\"198.235.24.183\",\"43.153.86.78\",\"170.106.113.159\",\"43.159.144.16\",\"139.99.30.187\",\"47.82.11.71\",\"43.130.74.193\",\"182.42.111.213\",\"2001:4860:7:1731::e\",\"49.51.33.159\",\"47.128.44.88\",\"206.189.87.160\",\"47.128.111.82\",\"47.128.34.117\",\"47.128.98.184\",\"2.58.56.101\",\"170.106.35.187\",\"142.93.152.201\",\"47.128.24.130\",\"2001:4860:7:406::ea\",\"101.32.52.164\",\"47.128.43.146\",\"47.128.60.148\",\"213.35.103.66\",\"43.130.110.130\",\"213.35.103.66\",\"149.57.191.78\",\"47.128.53.176\",\"43.153.67.21\",\"43.130.57.76\",\"43.164.196.57\",\"47.128.48.251\",\"47.128.19.113\",\"74.7.242.54\",\"47.128.96.65\",\"95.173.223.240\",\"2001:4860:7:506::e8\",\"43.153.96.233\",\"148.178.61.178\",\"47.128.54.190\",\"47.128.59.58\",\"47.128.47.123\",\"47.128.97.173\",\"2001:4860:7:806::ff\",\"162.120.184.245\",\"109.105.210.74\",\"109.105.210.74\",\"47.128.27.40\",\"47.82.11.54\",\"47.128.52.136\",\"47.128.58.61\",\"216.73.216.223\",\"216.73.216.223\",\"216.73.216.223\",\"47.82.11.12\",\"216.73.216.223\",\"43.157.149.188\",\"216.73.216.223\",\"216.73.216.223\",\"47.82.11.74\",\"57.141.2.28\",\"2a03:2880:12ff:4d::\",\"43.157.174.69\",\"178.252.190.114\",\"43.166.131.228\",\"2a03:2880:f802:e::\",\"2a03:2880:f802:8::\",\"2a03:2880:f802:20::\",\"43.135.182.95\",\"2a03:2880:f802:3a::\",\"2a03:2880:f802:4d::\",\"216.73.216.223\",\"57.141.2.25\",\"2a03:2880:f802:39::\",\"43.166.130.123\",\"57.141.2.76\",\"2a03:2880:f802:53::\",\"2a03:2880:f802:37::\",\"2a03:2880:f802:b::\",\"2a03:2880:f802:13::\",\"2a03:2880:f802:4d::\",\"2a03:2880:f802:4a::\",\"57.141.2.29\",\"2a03:2880:f802:43::\",\"47.128.31.16\",\"43.166.226.186\",\"2a03:2880:f802:46::\",\"2a03:2880:f802:44::\",\"2a03:2880:f802:20::\",\"2a03:2880:f802:4c::\",\"2a03:2880:f802:1f::\",\"2a03:2880:f802:1e::\",\"47.128.50.46\",\"47.128.52.143\",\"2a03:2880:f802:4c::\",\"47.128.19.226\",\"47.128.97.65\",\"2a03:2880:f802:1f::\",\"2001:4860:7:806::ab\",\"162.120.184.24\",\"43.130.141.193\",\"203.189.130.51\",\"2a03:2880:f802:50::\",\"2a03:2880:f802:5::\",\"47.82.11.40\",\"157.55.39.56\",\"2001:4860:7:b06::ed\",\"2a03:2880:f802:4::\",\"27.115.124.6\",\"47.128.118.147\",\"2a03:2880:f802:d::\",\"122.51.236.174\",\"138.68.55.137\",\"47.128.53.239\",\"47.128.53.205\",\"2a03:2880:f802:5f::\",\"2a03:2880:f802:b::\",\"2a03:2880:f802:59::\",\"2a03:2880:f802:13::\",\"2a03:2880:f802:46::\",\"2a03:2880:f802:2::\",\"2a03:2880:f802:2a::\",\"2a03:2880:f802:15::\",\"47.128.60.32\",\"2a03:2880:f802:2f::\",\"216.73.216.223\",\"216.73.216.223\",\"216.73.216.223\",\"47.128.22.124\",\"149.57.191.61\",\"47.82.11.20\",\"47.128.46.151\",\"47.128.110.141\",\"47.82.11.65\",\"2a03:2880:f802:7::\",\"2a03:2880:f802:1e::\",\"66.249.75.130\",\"2a03:2880:f802:7::\",\"2a03:2880:f802:17::\",\"2a03:2880:f802:11::\",\"23.27.145.142\",\"2a03:2880:f802:58::\",\"2a03:2880:f802:23::\",\"2001:4860:7:806::d1\",\"2a03:2880:f802:a::\",\"2001:4860:7:806::b7\",\"2001:4860:7:506::d2\",\"2a03:2880:f802:1d::\",\"2a03:2880:f802:4f::\",\"20.191.45.212\",\"2a03:2880:f802:13::\",\"2a03:2880:f802:c::\",\"2a03:2880:f802:4a::\",\"2a03:2880:f802:b::\",\"47.128.96.78\",\"47.128.58.210\",\"43.153.47.201\",\"47.128.18.235\",\"47.128.19.178\",\"43.157.142.101\",\"2a03:2880:f802:3f::\",\"2a03:2880:f802:41::\",\"47.128.122.252\",\"47.128.54.160\",\"66.249.69.12\",\"170.106.180.246\",\"2a03:2880:f802:16::\",\"47.128.19.255\",\"216.73.216.223\",\"2a03:2880:f802::\",\"89.208.103.210\",\"2a03:2880:f802:12::\",\"216.73.216.223\",\"66.249.75.130\",\"2a03:2880:f802:44::\",\"2a03:2880:f802:a::\",\"47.128.40.31\",\"2a03:2880:f802:59::\",\"47.128.62.180\",\"57.141.2.62\",\"47.128.25.228\",\"2a03:2880:f802:18::\",\"2a03:2880:f802:3::\",\"47.128.45.221\",\"47.128.63.115\",\"2a03:2880:f802:e::\",\"2.58.56.101\",\"2a03:2880:f802:19::\",\"2a03:2880:f802:4a::\",\"47.128.63.85\",\"47.128.57.55\",\"2a03:2880:f802:7::\",\"2a03:2880:f802:5c::\",\"2a03:2880:f802:44::\",\"2a03:2880:f802:4e::\",\"2a03:2880:f802:3b::\",\"66.249.75.128\",\"2a03:2880:f802:4a::\",\"43.153.79.218\",\"2a03:2880:f802:5e::\",\"47.82.11.91\",\"43.165.69.68\",\"216.73.216.223\",\"66.249.75.129\",\"43.131.39.179\",\"66.249.75.130\",\"43.166.130.123\",\"2a03:2880:f802:4d::\",\"43.130.67.6\",\"2a03:2880:f802:8::\",\"2a03:2880:f802:4b::\",\"49.51.39.209\",\"43.135.142.37\",\"43.166.251.233\",\"2a03:2880:f802:34::\",\"47.128.29.99\",\"47.82.11.79\",\"47.128.23.89\",\"47.82.11.82\",\"43.153.73.200\",\"2a03:2880:f802:4::\",\"2a03:2880:f802:2f::\",\"47.128.41.108\",\"2a03:2880:f802:21::\",\"47.128.41.164\",\"52.167.144.217\",\"43.130.26.3\",\"57.141.2.61\",\"47.128.56.237\",\"2a03:2880:f802:14::\",\"2a03:2880:f802:3a::\",\"47.128.22.19\",\"2a03:2880:f802:22::\",\"2a03:2880:f802:3e::\",\"43.157.62.101\",\"2a03:2880:f802:1b::\",\"2a03:2880:f802:1e::\",\"47.128.44.43\",\"2a03:2880:f802:e::\",\"2a03:2880:f802:14::\",\"2a03:2880:f802:e::\",\"47.128.32.75\",\"43.152.72.244\",\"47.128.46.185\",\"2a03:2880:f802:5e::\",\"47.128.99.65\",\"2a03:2880:f802:5b::\",\"2a03:2880:f802:9::\",\"2a03:2880:f802:2f::\",\"47.128.116.113\",\"2a03:2880:f802:a::\",\"43.130.3.122\",\"47.128.38.120\",\"108.136.162.67\",\"2a03:2880:f802:23::\",\"2a03:2880:f802:1f::\",\"47.128.57.132\",\"47.128.116.148\",\"43.157.82.252\",\"2a03:2880:f802:4::\",\"182.42.111.213\",\"2a03:2880:f802::\",\"43.159.149.216\",\"47.128.97.43\",\"66.249.75.128\",\"47.128.21.108\",\"43.159.143.139\",\"47.128.122.216\",\"2a03:2880:f802:41::\",\"2a03:2880:f802:4f::\",\"47.82.11.19\",\"47.128.98.60\",\"2a03:2880:f802:21::\",\"43.153.113.127\",\"2a03:2880:f802:1::\",\"47.128.51.121\",\"101.32.208.70\",\"66.249.71.39\",\"2a03:2880:f802:5b::\",\"43.157.95.239\",\"2a03:2880:f802:1d::\",\"43.134.141.244\",\"85.11.167.4\",\"85.11.167.4\",\"166.1.173.197\",\"2a03:2880:f802:b::\",\"2a03:2880:f802:6::\",\"2a03:2880:f802:1f::\",\"43.135.182.43\",\"2a03:2880:f802:a::\",\"57.141.2.31\",\"58.68.221.163\",\"2a03:2880:f802:57::\",\"2a03:2880:f802:55::\",\"47.82.11.10\",\"47.82.11.104\",\"43.130.15.147\",\"2a03:2880:f802:18::\",\"66.249.75.129\",\"47.82.11.15\",\"2a03:2880:f802:3f::\",\"57.141.2.90\",\"2804:7f3:ff80:6e4f:7c61:9f35:cf1a:f62e\",\"41.90.172.227\",\"2a03:2880:f802:48::\",\"83.244.126.36\",\"98.221.42.127\",\"170.247.100.116\",\"102.206.123.96\",\"41.90.209.211\",\"47.82.11.92\",\"2a03:2880:f802:57::\",\"41.223.116.244\",\"2a03:2880:f802:55::\",\"145.82.201.247\",\"177.54.66.156\",\"2804:5c:5993:b00:2146:86ba:6f99:db8\",\"202.52.40.11\",\"41.82.16.60\",\"2a03:2880:f802:44::\",\"134.0.3.19\",\"212.95.131.227\",\"2a03:2880:f802::\",\"108.230.190.245\",\"65.245.178.91\",\"66.249.71.38\",\"2a03:2880:f802:3e::\",\"201.238.124.64\",\"223.109.252.177\",\"2804:3084:f800:72d:e548:be28:fd02:3163\",\"2a03:2880:f802:12::\",\"2601:804:8701:5910:dc8:52fc:73c3:79a5\",\"47.15.9.9\",\"185.189.131.16\",\"2a03:2880:f802:3b::\",\"201.182.190.59\",\"2402:a00:184:7007:f4e6:19d6:d4ae:a2c1\",\"103.87.215.69\",\"162.246.109.171\",\"105.161.230.25\",\"85.11.167.4\",\"85.11.167.4\",\"151.83.65.58\",\"105.184.68.42\",\"186.148.207.243\",\"2a00:23c7:c881:3b01:3cfa:f74b:f77a:ae7\",\"47.82.11.2\",\"47.128.98.87\",\"181.29.113.143\",\"46.42.239.176\",\"47.128.51.110\",\"47.82.11.60\",\"157.49.152.95\",\"2a03:2880:f802:3f::\",\"2a03:2880:f802:1d::\",\"45.154.98.70\",\"57.141.2.36\",\"85.11.167.4\",\"85.11.167.4\",\"2a03:2880:f802:5f::\",\"2602:80d:1000::10\",\"57.141.2.80\",\"2602:80d:1000::10\",\"2a03:2880:f802:46::\",\"2a03:2880:f802:4c::\",\"47.128.39.131\",\"47.128.29.241\",\"47.82.11.77\",\"2a03:2880:f802:4d::\",\"47.128.47.124\",\"47.128.52.220\",\"2001:4860:7:406::f9\"]}', `Jumlah` = 482
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-07'
0.0006 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-07'
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2025-12-06'
AND (
`config_id` = 1
)
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0014 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.0003 sec
SHOW COLUMNS FROM `artikel`
0.0005 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.0004 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` = '101'
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.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` = '85'
0.0002 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.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` = '93'
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` = '92'
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` = '37'
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` = '62'
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` = '65'
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` = '64'
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` = '97'
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 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.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '115'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '120'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '124'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'drppa'
OR `slug` = 'drppa'
)
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 `kategori`
0.0003 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'perdes-tentang-drppa'
OR `slug` = 'perdes-tentang-drppa'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'anti-korupsi'
OR `slug` = 'anti-korupsi'
)
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0003 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '129'
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 (
`id` = 'tata-laksana'
OR `slug` = 'tata-laksana'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'pengawasan'
OR `slug` = 'pengawasan'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0003 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kualitas-pelayanan-publik'
OR `slug` = 'kualitas-pelayanan-publik'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0003 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'partisipasi-masyarakat'
OR `slug` = 'partisipasi-masyarakat'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kearifan-lokal'
OR `slug` = 'kearifan-lokal'
)
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0003 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '135'
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.0004 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.0004 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.0004 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.0004 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.0004 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.0003 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0004 sec
SHOW COLUMNS FROM `artikel`
0.0004 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` < '2025-12-07 20:33:22'
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` < '2025-12-07 20:33:22'
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` < '2025-12-07 20:33:22')
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` < '2025-12-07 20:33:22')ORDER BY RAND() LIMIT 10
0.0018 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0004 sec
SELECT `id`
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `slider` = 1
LIMIT 1
0.0002 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0004 sec
SELECT `id`, `nama` as `judul`, `gambar`
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `parrent` = '55'
AND `tipe` = 2
AND `enabled` = 1
0.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `config`
0.0005 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0004 sec
SELECT *
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY rand()
LIMIT 4
0.0003 sec
SHOW COLUMNS FROM `agenda`
0.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 DATE(g.tgl_agenda) = CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
0.0003 sec
SHOW COLUMNS FROM `agenda`
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 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.0003 sec
SHOW COLUMNS FROM `agenda`
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 DATE(g.tgl_agenda) < CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
0.0005 sec
SHOW COLUMNS FROM `komentar`
0.0004 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.*
FROM `komentar` `k`
JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id`
WHERE (
`k`.`config_id` = 1
)
AND `k`.`status` = 1
AND `k`.`id_artikel` <> 775
ORDER BY `k`.`tgl_upload` DESC
LIMIT 10
0.0003 sec
SHOW COLUMNS FROM `media_sosial`
0.0004 sec
SELECT *
FROM `media_sosial`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
0.0002 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` < '2025-12-07 20:33:22'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0016 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` < '2025-12-07 20:33:22'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0016 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` < '2025-12-07 20:33:22'
ORDER BY rand()
LIMIT 7
0.0040 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.0004 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.0059 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.0038 sec
SHOW COLUMNS FROM `widget`
0.0005 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0002 sec
SHOW COLUMNS FROM `keuangan_master`
0.0004 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
WHERE (
`config_id` = 1
)
ORDER BY `tahun_anggaran` DESC
0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 sec
SELECT `Tahun`
FROM `keuangan_manual_rinci`
WHERE (
`config_id` = 1
)
GROUP BY `Tahun`
ORDER BY `Tahun` DESC
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` NOT LIKE '1.%'
AND `Akun` NOT LIKE '7.%'
GROUP BY `Akun`, `Nama_Akun`
ORDER BY `Akun` ASC
0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `keuangan_manual_rinci`.`Tahun` = '2025'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0009 sec
SELECT `keuangan_manual_ref_rek3`.`Jenis`, `keuangan_manual_ref_rek3`.`Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '1.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '5.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '6.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '7.%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%'
ORDER BY `keuangan_manual_ref_rek3`.`Jenis` ASC
0.0006 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0011 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0007 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0010 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0007 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
WHERE `Kd_Bid` NOT LIKE '01%'
ORDER BY `Kd_Bid` ASC
0.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0010 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0007 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0011 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0007 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/13'
AND `enabled` = 1
0.0008 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/15'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/0'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/14'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/1'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/2'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/3'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/4'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/hubungan_kk'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/6'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/7'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/9'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/10'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/16'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/17'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/18'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/19'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/covid'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/suku'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bpjs-tenagakerja'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/hamil'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/kelas_sosial'
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bantuan_penduduk'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bantuan_keluarga'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/501'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/502'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/503'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/505'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/507'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/508'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5014'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5016'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5017'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5018'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5019'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5020'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'dpt'
AND `enabled` = 1
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'data-wilayah'
AND `enabled` = 1
0.0002 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
3.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.6200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.5500 sec
select * from `config` limit 1
0.4700 sec
select count(*) as aggregate from `config`
0.3700 sec
select count(*) as aggregate from `config`
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'setting_aplikasi'
1.0200 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
1.5500 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.4900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.8700 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.4600 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.8000 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.4300 sec
select count(*) as aggregate from `config`
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.9200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4200 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists`
0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.4100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.4200 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.4100 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Minggu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.3700 sec
select id, nama_hari, jam_masuk, status, keterangan, date_add(jam_keluar, interval 10 minute) as jam_keluar from `kehadiran_jam_kerja` where `nama_hari` = 'Minggu' and (time(`jam_masuk`) > '20:33' or date_add(jam_keluar, interval 10 minute) < '20:33') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5200 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.6600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.5500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.4500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.5900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'tweb_desa_pamong'
0.5400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.4700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 20 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.4000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.4000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.4000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 40 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 41 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.3700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 43 and `tanggal` = '2025-12-07' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2000 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.3500 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.2000 sec
select * from `program`
0.9600 sec
1.3107 sec
11.76MB
Request : first/wilayah
Database
N/A
Libraries (19)
Helpers (14)
Views (15) 
Configuration 
Session 
Models (47)