SHOW TABLES FROM `opensid8001`
0.0042 sec
SHOW DATABASES
0.0008 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'opensid8001' AND table_name = 'user'
0.0006 sec
SHOW COLUMNS FROM `anjungan`
0.0014 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '10.91.52.2'
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.0012 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.0004 sec
SHOW COLUMNS FROM `analisis_master`
0.0009 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.0002 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.0634 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '1'
0.0051 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` = 'MANGSIT'
ORDER BY `u`.`urut` ASC
0.0363 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` = 'MANGSIT'
ORDER BY `u`.`urut` ASC
0.0040 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` = 'MANGSIT'
ORDER BY `u`.`urut` ASC
0.0023 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '5'
0.0218 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` = 'SENGGIGI'
ORDER BY `u`.`urut` ASC
0.0028 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` = 'SENGGIGI'
ORDER BY `u`.`urut` ASC
0.0036 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '9'
0.0004 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` = 'KERANDANGAN'
ORDER BY `u`.`urut` ASC
0.0024 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` = 'KERANDANGAN'
ORDER BY `u`.`urut` ASC
0.0072 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '13'
0.0004 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` = 'LOCO'
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` = '-'
AND `u`.`dusun` = 'LOCO'
ORDER BY `u`.`urut` ASC
0.0499 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '35'
0.0005 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` = 'SENANG'
ORDER BY `u`.`urut` ASC
0.0024 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` = 'SENANG'
ORDER BY `u`.`urut` ASC
0.0039 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '39'
0.0015 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` = 'BARU'
ORDER BY `u`.`urut` ASC
0.0022 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` = 'BARU'
ORDER BY `u`.`urut` ASC
0.0038 sec
SELECT *
FROM `tweb_wil_clusterdesa`
WHERE (
`config_id` = 1
)
AND `id` = '43'
0.0055 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` = 'RORA PEDI'
ORDER BY `u`.`urut` ASC
0.0035 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` = 'RORA PEDI'
ORDER BY `u`.`urut` ASC
0.0023 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.0036 sec
SHOW COLUMNS FROM `widget`
0.0013 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0011 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2026-04-05'
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0006 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2026-04-04'
AND (
`config_id` = 1
)
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0006 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0008 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0009 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '1'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0012 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` = '1'
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '2'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '3'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '11'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0009 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` = '4'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0011 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` = '5'
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0010 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` = '6'
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0008 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '2'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0009 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '7'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '8'
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '3'
AND `enabled` = 1
ORDER BY `urut`
0.0326 sec
SHOW COLUMNS FROM `artikel`
0.0008 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` = '9'
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '17'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0010 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '18'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0007 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '10'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0008 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` = '12'
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '13'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '14'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 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` = '10'
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '19'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '28'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `kategori`
0.0009 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'berita'
OR `slug` = 'berita'
)
0.0009 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '44'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `kategori`
0.0007 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `kategori`
0.0007 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '3'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0009 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0006 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.0001 sec
SHOW COLUMNS FROM `artikel`
0.0008 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SHOW COLUMNS FROM `artikel`
0.0008 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar` != ''
AND `tgl_upload` < '2026-04-05 11:05: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` < '2026-04-05 11:05: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` < '2026-04-05 11:05: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` < '2026-04-05 11:05:22')ORDER BY RAND() LIMIT 10
0.0040 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar` != ''
AND `tgl_upload` < '2026-04-05 11:05:22'ORDER BY tgl_upload DESC LIMIT 10
0.0008 sec
SHOW COLUMNS FROM `widget`
0.0007 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `config`
0.0014 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0010 sec
SELECT *
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY rand()
LIMIT 4
0.0008 sec
SHOW COLUMNS FROM `agenda`
0.0010 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.0009 sec
SHOW COLUMNS FROM `agenda`
0.0009 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.0006 sec
SHOW COLUMNS FROM `agenda`
0.0009 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.0009 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.*
FROM `komentar` `k`
JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id`
WHERE (
`k`.`config_id` = 1
)
AND `k`.`status` = 1
AND `k`.`id_artikel` <> 775
ORDER BY `k`.`tgl_upload` DESC
LIMIT 10
0.0002 sec
SHOW COLUMNS FROM `media_sosial`
0.0009 sec
SELECT *
FROM `media_sosial`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-04-05 11:05:22'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0010 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-04-05 11:05:22'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0008 sec
SHOW COLUMNS FROM `artikel`
0.0105 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-04-05 11:05:22'
ORDER BY rand()
LIMIT 7
0.0029 sec
SHOW COLUMNS FROM `tweb_desa_pamong`
0.0009 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama
FROM `tweb_desa_pamong` `dp`
LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend`
LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id`
WHERE (
`dp`.`config_id` = 1
)
AND `dp`.`pamong_status` = '1'
ORDER BY `dp`.`urut`
0.0002 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan
FROM `tweb_penduduk_sex` `u`
LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.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`
WHERE (
`b`.`config_id` = 1
)
0.0002 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0001 sec
SHOW COLUMNS FROM `keuangan_master`
0.0009 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
WHERE (
`config_id` = 1
)
ORDER BY `tahun_anggaran` DESC
0.0002 sec
SHOW COLUMNS FROM `keuangan_master`
0.0008 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
WHERE (
`config_id` = 1
)
ORDER BY `tahun_anggaran` DESC
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/13'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/15'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/0'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/14'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/1'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/2'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/3'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/4'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/hubungan_kk'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/5'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/6'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/7'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/9'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/10'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/16'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/17'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/18'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/19'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/covid'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/suku'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bpjs-tenagakerja'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/hamil'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/kelas_sosial'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bantuan_penduduk'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'statistik/bantuan_keluarga'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'dpt'
AND `enabled` = 1
0.0001 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `link` = 'data-wilayah'
AND `enabled` = 1
0.0001 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
6.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.9500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2000 sec
select * from `config` limit 1
0.2200 sec
select count(*) as aggregate from `config`
0.1700 sec
select count(*) as aggregate from `config`
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'setting_aplikasi'
0.9300 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
1.0000 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.9200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan'
1.0400 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.2000 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'ref_jabatan'
0.6800 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.1800 sec
select count(*) as aggregate from `config`
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.8300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2000 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists`
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan'
0.6500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'anjungan'
0.5900 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja'
0.6600 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Minggu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja'
0.6300 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`) > '11:05' or date_add(jam_keluar, interval 10 minute) < '11:05') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa'
0.8700 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1
0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.9400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.9500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.8100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.8200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7500 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.9700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.7600 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.8300 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'tweb_desa_pamong'
1.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_perangkat_desa'
0.6300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 1 and `tanggal` = '2026-04-05' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
37.8200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'config'
0.8400 sec
select * from `config` where `app_key` = 'base64:E5u1TxTaMORrKekAC1ep6390HP4DbKq4kVhIxH3Fglc=' limit 1
0.1600 sec
select * from information_schema.tables where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'opensid8001' and table_name = 'kehadiran_jam_kerja'
0.7800 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.2700 sec
select * from `program`
0.2600 sec