SHOW TABLES FROM `wonolelo`
0.0028 sec
SELECT *
FROM `setting_aplikasi`
ORDER BY `key`
0.0005 sec
SHOW DATABASES
0.0009 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'wonolelo' AND table_name = 'user'
0.0005 sec
SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa
FROM `config` `c`
LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id`
LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id`
0.0004 sec
SELECT `status_rekam`, LOWER(nama) as nama
FROM `tweb_status_ktp`
0.0003 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama`
FROM `analisis_master` `u`
LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id`
WHERE `u`.`id` IS NULL
0.0004 sec
SELECT *
FROM `analisis_periode`
WHERE `aktif` = 1
AND `id_master` IS NULL
0.0003 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama`
FROM `analisis_master` `u`
LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id`
WHERE `u`.`id` IS NULL
0.0005 sec
SELECT `id`
FROM `artikel`
WHERE `slug` = 'psn-di-dusun-purworejo'
OR `id` = 'psn-di-dusun-purworejo'
0.0012 sec
UPDATE `artikel` SET hit = hit + 1
WHERE `id` = '272'
0.0023 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`slug` = 'psn-di-dusun-purworejo'
0.0034 sec
SELECT *
FROM `agenda`
WHERE `id_artikel` = '272'
0.0006 sec
SELECT *
FROM `komentar`
WHERE `id_artikel` = '272'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0005 sec
SELECT *
FROM `widget`
WHERE `jenis_widget` <> 3
AND `enabled` = 1
0.0003 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2026-10-02'
0.0003 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2026-10-01'
0.0003 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '3649'
0.0007 sec
SELECT *
FROM `menu`
WHERE `parrent` = '24'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '247'
0.0007 sec
SELECT *
FROM `menu`
WHERE `parrent` = '40'
AND `enabled` = 1
ORDER BY `urut`
0.0006 sec
SELECT *
FROM `menu`
WHERE `parrent` = '107'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '21'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '706'
0.0006 sec
SELECT *
FROM `menu`
WHERE `parrent` = '122'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '707'
0.0006 sec
SELECT *
FROM `menu`
WHERE `parrent` = '123'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '704'
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '124'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '705'
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '125'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '9'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '10'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '37'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '3647'
0.0008 sec
SELECT *
FROM `menu`
WHERE `parrent` = '1'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '2'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '3'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '4'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '6'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '5'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '7'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '8'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '4122'
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '69'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`id` = '38'
0.0006 sec
SELECT *
FROM `menu`
WHERE `parrent` = '30'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '31'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '76'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '77'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '126'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '127'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '25'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '99'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '100'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '101'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '102'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '103'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '104'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '105'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '129'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '130'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '131'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '132'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '133'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '134'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '136'
AND `enabled` = 1
ORDER BY `urut`
0.0006 sec
SELECT *
FROM `menu`
WHERE `parrent` = '137'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '138'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '139'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '140'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '142'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '143'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '144'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '147'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '17'
ORDER BY `urut`
0.0005 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '8'
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '5'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '6'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '25'
ORDER BY `urut`
0.0002 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload`
FROM `teks_berjalan` `t`
LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id`
WHERE `status` = 1
ORDER BY `urut`
0.0009 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
AND `a`.`slug` = ''
0.0037 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar` != ''
AND `tgl_upload` < '2026-10-02 07:17:57'
UNION
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar1` != ''
AND `tgl_upload` < '2026-10-02 07:17:57'
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar2` != ''
AND `tgl_upload` < '2026-10-02 07:17:57')
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `headline` = 3
AND `gambar3` != ''
AND `tgl_upload` < '2026-10-02 07:17:57')ORDER BY RAND() LIMIT 10
0.0040 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE `enabled` = 1
AND `gambar` != ''
AND `tgl_upload` < '2026-10-02 07:17:57'
ORDER BY `tgl_upload` DESC
LIMIT 10
0.0018 sec
SELECT *
FROM `widget`
WHERE `enabled` = 1
ORDER BY `urut`
0.0004 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '162.158.162.89'
)
AND `status` = 1
0.0002 sec
SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4
0.0006 sec
SELECT v.*,YEAR(v.tgl_upload) AS thn, MONTH(v.tgl_upload) AS bln, DAY(v.tgl_upload) AS hri FROM v_agenda_lain AS v
WHERE DATE(v.`tgl_agenda`)=CURDATE();
0.0066 sec
SELECT v.*,YEAR(v.tgl_upload) AS thn, MONTH(v.tgl_upload) AS bln, DAY(v.tgl_upload) AS hri FROM v_agenda_lain AS v
WHERE DATE(v.`tgl_agenda`)>CURDATE();
0.0119 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `agenda` `g`
LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
AND DATE(g.tgl_agenda) < CURDATE()
0.0013 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.*
FROM `komentar` `k`
JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id`
WHERE `k`.`status` = 1
AND `k`.`id_artikel` <> 775
ORDER BY `k`.`tgl_upload` DESC
LIMIT 10
0.0011 sec
SELECT *
FROM `media_sosial`
WHERE `enabled` = 1
0.0003 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0017 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0021 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-10-02 07:17:57'
ORDER BY rand()
LIMIT 7
0.0093 sec
select * from (
SELECT
`p`.`pamong_id` AS `pamong_id`,`p`.`pamong_ub`, `p`.`pamong_ttd`,
`p`.`is_wilayah`,
`p`.`is_absen_hp`,
IFNULL(p.`pamong_masajab`,'-') AS `masajab`,
`pen`.`nama` AS `nama`,
`p`.`jabatan` AS `jabatan`,
`p`.`id_pend` AS `id_pend`,
`pen`.`nik` AS `nik`,
`p`.`pamong_niap` AS `kode`,
`pen`.`telepon` AS `telepon`,
`p`.`urut` AS `urut`,
IFNULL(`pen`.`telegram`,'-') AS `telegram`,
IFNULL(`u`.`id`,'0') AS `id_user`,
IFNULL(CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`p`.`foto`),CONCAT('https://wonolelo.sides.id/','desa/upload/user_pict/kecil_',`pen`.`foto`)) AS `foto`
FROM `tweb_desa_pamong` `p`
LEFT JOIN `tweb_penduduk` `pen`
ON `p`.`id_pend` = `pen`.`id`
LEFT JOIN `user` as `u`
ON `p`.`pamong_id`=`u`.`pamong_id`
WHERE 1
and`p`.`pamong_status` = '1' order by urut asc ) as v
left join (
SELECT
`c`.`userid` AS `userid`,
TIME(MIN(`c`.`checktime`)) AS `masuk`,
IF(MIN(`c`.`checktime`)<>MAX(`c`.`checktime`),TIME(MAX(`c`.`checktime`)),NULL) AS `pulang`,
COUNT(`c`.`checktime`) AS `jumlah`
FROM `checkinout` `c`
WHERE DATE(c.`checktime`)='2026-10-02'
GROUP BY `c`.`userid`
) as x
on v.kode=x.userid
order by urut asc
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`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0003 sec
SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan
FROM `penduduk_hidup` `b`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id`
0.0004 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'sinergi_program.php'
0.0002 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'sub_link.php'
0.0002 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
ORDER BY `tahun_anggaran` DESC
0.0002 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_master`
LEFT JOIN `keuangan_ref_rek1` ON `keuangan_ref_rek1`.`id_keuangan_master` = `keuangan_master`.`id`
WHERE `Akun` NOT LIKE '1.%'
AND `Akun` NOT LIKE '7.%'
AND `tahun_anggaran` = '2026'
GROUP BY `Akun`, `Nama_Akun`
ORDER BY `Akun` ASC
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu
FROM `keuangan_ta_rab_rinci`
WHERE `Tahun` = '2026'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_tbp_rinci`
WHERE `Tahun` = '2026'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spp_rinci`
LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP`
WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2026'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
GROUP BY `jenis_pelaksanaan`
0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spp_rinci`
LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP`
WHERE `keuangan_ta_spp_rinci`.`Tahun` = '2026'
AND `keuangan_ta_spp`.`Jn_SPP` = 'UM'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spj_rinci`
WHERE `Tahun` = '2026'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_mutasi`
WHERE `Tahun` = '2026'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi
FROM `keuangan_ta_jurnal_umum_rinci`
WHERE `Tahun` = '2026'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi
FROM `keuangan_ta_jurnal_umum_rinci`
WHERE `Tahun` = '2026'
GROUP BY `jenis_pelaksanaan`
0.0002 sec
SELECT `keuangan_ref_rek3`.`Jenis`, `keuangan_ref_rek3`.`Nama_Jenis`
FROM `keuangan_master`
LEFT JOIN `keuangan_ref_rek2` ON `keuangan_ref_rek2`.`id_keuangan_master` = `keuangan_master`.`id`
LEFT JOIN `keuangan_ref_rek3` ON `keuangan_ref_rek3`.`Kelompok` = `keuangan_ref_rek2`.`Kelompok`
WHERE `keuangan_ref_rek3`.`Jenis` NOT LIKE '1.%'
AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '5.%'
AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '6.%'
AND `keuangan_ref_rek3`.`Jenis` NOT LIKE '7.%'
AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%'
AND `keuangan_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%'
AND `tahun_anggaran` = '2026'
ORDER BY `keuangan_ref_rek3`.`Jenis` ASC
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(AnggaranStlhPAK) AS pagu
FROM `keuangan_ta_rab_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_pendapatan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_tbp_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_pendapatan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai) AS realisasi
FROM `keuangan_ta_mutasi`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_pendapatan`
0.0002 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Kredit) AS realisasi
FROM `keuangan_ta_jurnal_umum_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_pendapatan`
0.0003 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_master`
LEFT JOIN `keuangan_ta_bidang` ON `keuangan_ta_bidang`.`id_keuangan_master` = `keuangan_master`.`id`
WHERE `Kd_Bid` NOT LIKE '01%'
AND `Tahun` = '2026'
ORDER BY `Kd_Bid` ASC
0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu
FROM `keuangan_ta_rab_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spp_rinci`
LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `keuangan_ta_spp_rinci`.`Tahun` = '2026'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spp_rinci`
LEFT JOIN `keuangan_ta_spp` ON `keuangan_ta_spp`.`No_SPP` = `keuangan_ta_spp_rinci`.`No_SPP`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `keuangan_ta_spp_rinci`.`Tahun` = '2026'
AND `keuangan_ta_spp`.`Jn_SPP` = 'UM'
GROUP BY `jenis_belanja`
0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi
FROM `keuangan_ta_spj_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai) AS realisasi
FROM `keuangan_ta_mutasi`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2026'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(keuangan_ta_jurnal_umum_rinci.Debet) AS realisasi
FROM `keuangan_ta_jurnal_umum_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `keuangan_ta_jurnal_umum_rinci`.`Tahun` = '2026'
GROUP BY `jenis_belanja`
0.0002 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
ORDER BY `tahun_anggaran` DESC
0.0003 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
ORDER BY `tahun_anggaran` DESC
0.0003 sec
1.5562 sec
4.81MB
Request : first/artikel
Database
N/A
Libraries (19)
Helpers (16)
Views (30) 
Configuration 
Session 
Models (45)
Komentar baru terbit setelah disetujui Admin