SHOW TABLES FROM `wonolelo`
0.0024 sec
SELECT *
FROM `setting_aplikasi`
ORDER BY `key`
0.0007 sec
SHOW DATABASES
0.0012 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'wonolelo' AND table_name = 'user'
0.0003 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.0004 sec
SELECT `u`.*, `s`.`subjek` as `subjek_nama`
FROM `analisis_master` `u`
LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id`
WHERE `u`.`id` IS NULL
0.0002 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.0002 sec
SELECT `id`
FROM `artikel`
WHERE `slug` = 'peningkatan-kapasitas-fprb-kalurahan-wonolelo'
OR `id` = 'peningkatan-kapasitas-fprb-kalurahan-wonolelo'
0.0009 sec
UPDATE `artikel` SET hit = hit + 1
WHERE `id` = '623'
0.0056 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 11:38:20'
AND `a`.`slug` = 'peningkatan-kapasitas-fprb-kalurahan-wonolelo'
0.0021 sec
SELECT *
FROM `agenda`
WHERE `id_artikel` = '623'
0.0016 sec
SELECT *
FROM `komentar`
WHERE `id_artikel` = '623'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0020 sec
SELECT *
FROM `widget`
WHERE `jenis_widget` <> 3
AND `enabled` = 1
0.0004 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2026-10-02'
0.0003 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"104.23.175.40\",\"162.158.88.16\",\"172.69.176.24\",\"104.23.175.40\",\"172.70.93.86\",\"172.68.164.61\",\"172.69.166.5\",\"162.158.162.30\",\"172.69.176.74\",\"172.70.142.48\",\"172.68.164.61\",\"172.71.124.45\",\"172.69.166.4\",\"172.70.188.27\",\"162.158.108.63\",\"172.71.124.80\",\"162.158.170.94\",\"162.158.162.88\",\"162.158.170.95\",\"172.70.142.49\",\"162.158.189.43\",\"162.158.106.183\",\"162.158.162.30\",\"162.158.108.78\",\"104.23.175.40\",\"172.70.142.49\",\"172.71.124.81\",\"104.23.175.40\",\"162.158.88.15\",\"172.69.176.24\",\"172.70.142.48\",\"172.69.176.24\",\"172.71.124.81\",\"162.158.108.62\",\"162.158.162.88\",\"172.68.164.68\",\"162.158.189.43\",\"172.71.124.45\",\"172.69.176.75\",\"172.68.164.60\",\"172.71.124.80\",\"172.70.208.58\",\"108.162.226.150\",\"172.68.164.88\",\"172.70.188.27\",\"162.158.108.63\",\"162.158.170.39\",\"162.158.190.72\",\"172.70.189.131\",\"172.70.208.68\",\"162.158.88.47\",\"162.158.163.199\",\"172.70.93.15\",\"162.158.163.200\",\"162.158.163.200\",\"172.70.142.56\",\"172.70.208.69\",\"162.158.88.47\",\"162.158.88.15\",\"108.162.226.8\",\"172.70.189.166\",\"104.23.175.57\",\"162.158.88.17\",\"172.69.166.4\",\"172.70.93.87\",\"162.158.170.38\",\"172.70.208.69\",\"172.68.164.68\",\"162.158.107.29\",\"172.71.124.44\",\"172.71.124.45\",\"172.70.142.57\",\"172.70.142.56\",\"172.70.142.56\",\"162.158.162.88\",\"172.69.166.5\",\"162.158.108.154\",\"172.68.164.60\",\"172.71.124.81\",\"162.158.108.63\",\"172.69.166.4\",\"162.158.162.88\",\"172.70.188.27\",\"172.71.124.81\",\"172.70.208.58\",\"162.158.88.46\",\"162.158.108.155\",\"108.162.226.158\",\"162.158.108.155\",\"172.70.208.69\",\"172.70.142.56\",\"172.69.176.24\",\"162.158.189.63\",\"172.70.93.15\",\"162.158.107.30\",\"104.23.175.122\",\"162.158.88.16\",\"104.23.175.122\",\"162.158.88.47\",\"162.158.106.183\",\"162.158.88.16\",\"162.158.190.72\",\"172.71.124.80\",\"172.70.208.88\",\"162.158.88.17\",\"162.158.106.182\",\"104.22.66.193\",\"172.70.208.88\",\"172.71.124.80\",\"162.158.88.47\",\"172.70.208.68\",\"172.70.92.182\",\"172.70.142.57\",\"162.158.107.30\",\"104.23.175.41\",\"104.23.175.123\",\"104.23.175.122\",\"172.71.124.44\",\"172.70.142.56\",\"162.158.107.30\",\"162.158.108.155\",\"162.158.108.78\",\"162.158.108.154\",\"162.158.170.132\",\"172.70.208.88\",\"172.70.208.59\",\"172.68.164.68\",\"162.158.108.78\",\"172.69.176.55\",\"162.158.108.154\",\"172.69.166.4\",\"172.68.164.69\",\"162.158.108.154\",\"172.68.164.68\",\"172.70.142.56\",\"104.23.175.122\",\"172.69.176.74\",\"162.158.88.15\",\"172.71.124.81\",\"172.70.142.57\",\"104.22.66.17\",\"172.68.164.69\",\"172.70.93.15\",\"172.70.142.57\",\"172.69.176.54\",\"162.158.162.31\",\"162.158.189.63\",\"162.158.106.67\",\"104.23.175.57\",\"172.70.208.58\",\"172.70.142.56\",\"172.71.124.45\",\"172.69.166.5\",\"162.158.108.63\",\"172.71.124.44\",\"162.158.88.15\",\"162.158.88.15\",\"104.23.175.123\",\"162.158.88.15\",\"172.68.164.69\",\"172.69.176.74\",\"162.158.163.200\",\"104.23.175.123\",\"172.70.92.182\",\"172.69.176.55\",\"162.158.88.15\",\"172.70.93.87\",\"162.158.170.94\",\"172.70.92.183\",\"172.70.142.56\",\"172.70.142.48\",\"162.158.189.42\",\"104.22.66.17\",\"162.158.162.88\",\"162.158.88.15\",\"172.71.124.80\",\"172.69.176.55\",\"172.69.166.4\",\"108.162.226.158\",\"104.23.175.41\",\"172.71.124.45\",\"172.70.142.57\",\"172.70.188.26\",\"172.68.164.68\",\"104.22.66.17\",\"172.70.208.68\",\"172.70.208.68\",\"172.70.142.49\",\"172.71.124.80\",\"172.71.124.80\",\"108.162.226.159\",\"104.22.66.16\",\"162.158.88.46\",\"172.70.208.68\",\"172.70.188.27\",\"172.69.176.75\",\"172.70.142.56\",\"162.158.162.89\",\"162.158.88.47\",\"162.158.162.88\",\"162.158.88.15\",\"172.69.176.75\",\"172.71.124.81\",\"172.68.164.60\",\"172.70.92.182\",\"172.70.189.166\",\"162.158.88.47\",\"162.158.162.88\",\"172.69.176.74\",\"104.22.66.17\",\"172.68.164.88\",\"162.158.170.39\",\"172.69.176.24\",\"172.69.176.75\",\"108.162.226.150\",\"104.23.175.56\",\"108.162.226.150\",\"162.158.108.78\",\"104.23.175.40\",\"172.68.164.60\",\"172.68.164.61\",\"162.158.106.67\",\"104.23.175.40\",\"162.158.170.39\",\"162.158.106.182\",\"162.158.189.42\",\"172.70.93.86\",\"162.158.108.63\",\"104.23.175.40\",\"162.158.189.42\",\"172.70.93.87\",\"172.70.208.58\",\"172.69.176.54\",\"172.70.142.48\",\"172.71.124.81\",\"172.71.124.81\",\"162.158.162.89\",\"162.158.88.16\",\"172.70.93.87\",\"172.70.188.26\",\"172.68.164.68\",\"162.158.106.67\",\"162.158.106.183\",\"172.70.142.48\",\"162.158.189.43\",\"172.70.208.89\",\"172.70.142.57\",\"104.22.66.193\",\"172.71.124.44\",\"162.158.88.14\",\"172.70.142.56\",\"172.71.124.44\",\"162.158.189.42\",\"162.158.189.43\",\"162.158.107.29\",\"172.70.93.87\",\"104.22.66.17\",\"162.158.88.47\",\"162.158.108.155\",\"172.69.166.4\",\"104.23.175.122\",\"172.71.124.81\",\"172.70.189.165\",\"162.158.108.79\",\"162.158.108.155\",\"172.69.176.75\",\"172.71.124.45\",\"162.158.170.39\",\"172.69.176.24\",\"162.158.106.67\",\"104.22.66.211\",\"108.162.226.159\",\"162.158.162.30\",\"172.70.208.88\",\"108.162.226.9\",\"104.22.66.17\",\"172.68.164.60\",\"172.70.208.88\",\"104.23.175.40\",\"172.69.176.74\",\"162.158.106.67\",\"172.71.124.81\",\"172.70.142.57\",\"172.69.166.5\",\"108.162.226.159\",\"172.71.124.44\",\"104.23.175.122\",\"162.158.107.29\",\"172.70.92.182\",\"104.23.175.122\",\"162.158.108.79\",\"162.158.88.14\",\"162.158.108.78\",\"172.69.166.4\",\"172.69.176.55\",\"162.158.163.199\",\"172.70.208.89\",\"172.70.93.86\",\"172.70.208.88\",\"162.158.88.15\",\"172.70.208.88\",\"162.158.106.67\",\"172.71.124.81\",\"172.71.124.45\",\"172.71.124.44\",\"172.70.208.68\",\"172.71.124.45\",\"172.69.166.4\",\"104.23.175.122\",\"172.69.176.55\",\"104.23.175.57\",\"104.23.175.122\",\"172.70.93.15\",\"172.70.208.69\",\"172.70.189.131\",\"172.70.189.131\",\"162.158.88.46\",\"172.68.164.89\",\"162.158.190.72\",\"172.69.166.5\",\"172.69.176.74\",\"104.23.175.57\",\"172.71.124.80\",\"172.68.164.89\",\"104.23.175.122\",\"172.70.189.166\",\"172.70.188.27\",\"104.23.175.57\",\"172.69.176.54\",\"172.69.166.5\",\"172.71.124.45\",\"162.158.88.14\",\"104.23.175.122\",\"172.69.166.5\",\"162.158.162.30\",\"104.23.175.123\",\"162.158.108.78\",\"172.71.124.80\",\"104.23.175.56\",\"162.158.88.47\",\"162.158.106.67\",\"172.69.166.5\",\"162.158.189.63\",\"104.23.175.122\",\"162.158.189.62\",\"172.71.124.80\",\"172.70.208.58\",\"104.23.175.122\",\"172.68.164.60\",\"172.70.188.27\",\"172.68.164.60\",\"172.70.93.87\",\"162.158.88.17\",\"108.162.226.150\",\"172.70.142.48\",\"172.70.142.56\",\"172.70.93.87\",\"172.70.208.59\",\"162.158.88.16\",\"104.23.175.122\",\"172.70.188.26\",\"172.70.142.49\",\"162.158.162.88\",\"162.158.88.14\",\"172.68.164.61\",\"172.70.142.48\",\"162.158.170.94\",\"172.71.124.80\",\"108.162.226.150\",\"104.23.175.40\",\"162.158.88.16\",\"172.70.92.183\",\"172.71.124.80\",\"162.158.108.78\",\"104.23.175.40\",\"162.158.88.46\",\"162.158.106.182\",\"162.158.170.95\",\"172.68.164.69\",\"104.23.175.123\",\"172.70.93.86\",\"172.69.176.25\",\"104.23.175.57\",\"172.70.93.14\",\"162.158.88.47\",\"162.158.162.30\",\"162.158.162.88\",\"172.70.208.59\",\"104.23.175.56\",\"104.23.175.123\",\"172.70.93.14\",\"162.158.170.95\",\"162.158.106.182\",\"172.71.124.81\",\"172.68.164.68\",\"172.68.164.88\",\"162.158.162.30\",\"162.158.108.79\",\"172.70.208.58\",\"172.68.164.89\",\"172.70.93.14\",\"104.23.175.56\",\"162.158.170.132\",\"172.68.164.88\",\"172.68.164.88\",\"172.68.164.89\",\"162.158.108.154\",\"172.69.176.75\",\"162.158.163.200\",\"172.70.93.14\",\"172.70.208.59\",\"172.70.92.182\",\"172.68.164.89\",\"172.70.142.56\",\"162.158.170.132\",\"172.68.164.69\",\"172.68.164.89\",\"172.69.166.5\",\"172.69.176.75\",\"104.23.175.57\",\"172.70.208.69\",\"172.71.124.80\",\"162.158.88.15\",\"162.158.88.46\",\"172.69.176.75\",\"104.23.175.57\",\"162.158.88.47\",\"172.68.164.68\",\"162.158.108.79\",\"108.162.226.158\",\"172.70.208.68\",\"162.158.108.79\",\"162.158.170.132\",\"172.69.166.4\",\"172.70.142.56\",\"108.162.226.8\",\"172.69.166.5\",\"172.68.164.88\",\"108.162.226.158\",\"172.70.92.182\",\"162.158.88.15\",\"162.158.88.46\",\"104.22.66.211\",\"162.158.88.47\",\"172.69.176.74\",\"172.70.93.14\",\"162.158.162.31\",\"162.158.107.30\",\"172.69.176.75\",\"172.68.164.88\",\"162.158.170.38\",\"162.158.108.78\",\"172.70.92.182\",\"162.158.108.154\",\"172.70.142.57\",\"172.70.93.14\",\"172.69.176.75\",\"172.70.142.57\",\"162.158.88.46\",\"162.158.106.67\",\"172.69.176.74\",\"172.68.164.88\",\"172.69.166.5\",\"172.70.189.131\",\"162.158.162.31\",\"172.70.208.88\",\"172.70.208.88\",\"172.69.176.55\",\"172.71.124.44\",\"172.70.142.57\",\"172.69.166.4\",\"172.70.189.165\",\"104.23.175.123\",\"162.158.170.133\",\"172.70.92.182\",\"162.158.163.200\",\"172.71.124.80\",\"172.69.176.54\",\"162.158.162.31\",\"162.158.162.30\",\"172.69.176.55\",\"172.69.176.75\",\"172.70.92.182\",\"172.70.142.56\",\"162.158.170.39\",\"172.68.164.68\",\"104.23.175.56\",\"172.71.124.80\",\"172.71.124.80\",\"162.158.162.30\",\"172.69.166.5\",\"162.158.106.66\",\"172.69.166.4\",\"162.158.108.79\",\"104.23.175.56\",\"104.23.175.123\",\"172.70.92.183\",\"104.22.66.17\",\"172.68.164.88\",\"172.70.208.88\",\"172.68.164.68\",\"162.158.108.155\",\"162.158.108.154\",\"162.158.162.30\",\"172.70.208.88\",\"172.69.176.75\",\"104.22.66.17\",\"172.70.208.88\",\"172.70.208.89\",\"162.158.108.78\",\"162.158.170.94\",\"162.158.170.94\",\"162.158.162.88\",\"162.158.189.42\",\"172.70.208.59\",\"172.70.188.26\",\"162.158.163.200\",\"172.70.208.89\",\"162.158.189.42\",\"162.158.163.200\",\"162.158.88.42\",\"104.23.175.123\",\"162.158.108.155\",\"108.162.226.151\",\"104.23.175.123\",\"172.70.208.88\",\"172.69.166.5\",\"172.70.189.131\",\"172.69.176.75\",\"172.70.142.56\",\"172.70.142.57\",\"162.158.88.147\",\"172.70.142.56\",\"172.68.164.88\",\"162.158.108.79\",\"162.158.88.147\",\"162.158.88.43\",\"162.158.88.147\",\"104.22.66.254\",\"172.70.142.57\",\"162.158.108.155\",\"162.158.106.66\",\"172.70.93.15\",\"162.158.108.154\",\"104.22.66.254\",\"162.158.88.130\",\"162.158.88.147\",\"172.69.166.4\",\"172.69.176.55\",\"172.68.164.68\",\"172.70.208.68\",\"162.158.162.30\",\"172.71.124.80\",\"162.158.88.130\",\"172.70.208.89\",\"162.158.163.199\",\"172.70.208.89\",\"104.23.175.122\",\"108.162.226.8\",\"162.158.108.78\",\"162.158.88.146\",\"104.22.66.16\",\"172.70.208.88\",\"172.68.164.89\",\"172.70.208.69\",\"162.158.170.133\",\"108.162.226.8\",\"172.71.124.45\",\"172.70.142.56\",\"104.23.175.56\",\"172.69.176.54\",\"162.158.163.200\",\"172.68.164.89\",\"172.70.92.183\",\"172.70.142.56\",\"172.69.176.74\",\"162.158.189.63\",\"172.70.208.88\",\"172.70.92.182\",\"172.70.93.15\",\"172.69.166.4\",\"104.23.175.123\",\"172.71.124.28\",\"108.162.226.8\",\"172.69.166.4\",\"172.70.189.131\",\"104.23.175.57\",\"172.70.189.166\",\"104.23.175.57\",\"162.158.163.199\",\"172.70.92.183\",\"172.69.166.5\",\"162.158.108.79\",\"172.70.92.183\",\"172.69.176.74\",\"172.69.176.54\",\"104.23.175.123\",\"172.69.176.74\",\"172.69.176.54\",\"162.158.163.199\",\"162.158.107.29\",\"172.71.152.87\",\"104.23.175.57\",\"172.69.176.74\",\"172.70.142.73\",\"172.71.124.183\",\"162.158.170.132\",\"162.158.170.133\",\"162.158.108.78\",\"172.71.124.28\",\"162.158.107.29\",\"172.70.142.72\",\"104.23.175.123\",\"172.70.142.72\",\"172.71.152.88\",\"108.162.226.8\",\"162.158.162.30\",\"104.23.175.123\",\"172.71.124.28\",\"162.158.190.71\",\"162.158.108.79\",\"172.68.164.88\",\"172.70.208.68\",\"162.158.163.200\",\"172.70.142.73\",\"162.158.88.5\",\"104.23.175.56\",\"172.69.176.74\",\"172.68.164.69\",\"172.69.176.75\",\"104.23.175.56\",\"172.68.164.89\",\"172.69.176.75\",\"172.70.92.183\",\"104.23.175.57\",\"172.70.208.89\",\"172.70.142.73\",\"172.71.152.87\",\"172.71.124.182\",\"162.158.108.78\",\"162.158.88.152\",\"162.158.108.79\",\"162.158.108.154\",\"172.68.164.68\",\"104.23.175.122\",\"104.23.175.57\",\"162.158.88.5\",\"172.70.92.183\",\"104.23.175.56\",\"172.68.164.60\",\"172.68.164.69\",\"172.70.189.165\",\"162.158.162.88\",\"108.162.226.151\",\"172.70.208.59\",\"108.162.226.159\",\"172.70.208.69\",\"104.23.175.123\",\"162.158.163.199\",\"172.68.164.68\",\"172.71.152.31\",\"104.23.175.122\",\"108.162.226.159\",\"162.158.108.155\",\"162.158.107.30\",\"172.68.164.89\",\"162.158.163.200\",\"172.68.164.69\",\"104.23.175.40\",\"172.71.124.29\",\"172.68.164.69\",\"162.158.163.200\",\"162.158.108.78\",\"162.158.162.88\",\"172.68.164.88\",\"172.68.164.88\",\"172.71.124.29\",\"172.71.124.182\",\"172.70.93.15\",\"162.158.162.30\",\"172.70.208.68\",\"172.71.124.29\",\"162.158.88.144\",\"172.68.164.69\",\"172.70.208.68\",\"172.70.142.72\",\"172.68.164.88\",\"162.158.108.154\",\"108.162.226.158\",\"162.158.108.155\",\"172.69.176.91\",\"162.158.162.118\",\"172.71.152.88\",\"104.23.175.57\",\"172.70.92.182\",\"172.71.124.183\",\"162.158.114.141\",\"108.162.226.159\",\"162.158.189.62\",\"172.68.164.89\",\"172.71.152.88\",\"172.68.211.120\",\"172.70.142.72\",\"162.158.107.29\",\"172.71.210.98\",\"172.68.211.120\",\"172.68.211.120\",\"172.70.142.73\",\"162.158.108.154\",\"172.71.215.42\",\"108.162.226.159\",\"172.70.208.68\",\"172.69.176.63\",\"172.70.189.131\",\"172.70.142.73\",\"172.69.176.91\",\"172.69.176.91\",\"172.71.152.88\",\"108.162.226.158\",\"162.158.162.119\",\"108.162.226.8\",\"172.68.211.32\",\"172.70.92.183\",\"172.70.189.132\",\"172.71.124.183\",\"172.68.164.69\",\"172.70.92.182\",\"172.70.189.165\",\"172.70.142.56\",\"172.70.189.166\",\"104.23.175.123\",\"162.158.107.29\",\"172.70.92.182\",\"104.22.66.17\",\"162.158.189.62\",\"172.70.208.68\",\"172.70.142.56\",\"172.70.189.166\",\"162.158.108.79\",\"172.68.164.68\",\"162.158.107.30\",\"104.22.66.17\",\"172.69.176.71\",\"172.70.142.57\",\"104.23.175.122\",\"172.70.189.166\",\"172.70.142.57\",\"108.162.226.158\",\"162.158.170.26\",\"162.158.88.145\",\"104.23.175.123\",\"172.70.92.183\",\"162.158.108.79\",\"172.70.208.68\",\"162.158.162.119\",\"172.70.92.182\",\"162.158.108.79\",\"162.158.88.145\",\"162.158.162.119\",\"162.158.189.62\",\"172.70.189.165\",\"162.158.162.118\",\"104.23.175.123\",\"162.158.88.145\",\"162.158.189.62\",\"172.70.208.69\",\"104.23.175.123\",\"172.70.189.166\",\"172.68.164.88\",\"162.158.108.79\",\"162.158.163.132\",\"172.69.176.75\",\"172.69.176.74\",\"172.69.176.75\",\"162.158.88.128\",\"162.158.106.66\",\"104.22.66.195\",\"172.71.124.183\",\"162.158.189.63\",\"104.22.66.195\",\"172.70.92.183\",\"162.158.190.72\",\"162.158.163.131\",\"162.158.163.132\",\"162.158.88.129\",\"172.68.164.89\",\"172.69.176.74\",\"172.68.164.89\",\"104.22.66.195\",\"162.158.170.62\",\"172.70.93.14\",\"172.68.164.88\",\"172.71.124.182\",\"162.158.106.66\",\"172.69.176.75\",\"172.69.176.74\",\"162.158.163.131\",\"172.70.189.132\",\"162.158.108.154\",\"172.68.164.89\",\"172.70.93.15\",\"172.70.189.131\",\"172.70.189.132\",\"172.70.93.14\",\"172.71.124.183\",\"104.23.175.56\",\"162.158.163.132\",\"172.69.166.5\",\"104.22.66.195\",\"172.69.166.4\",\"172.68.164.88\",\"104.22.66.195\",\"162.158.170.63\",\"162.158.190.71\",\"162.158.190.72\",\"172.70.93.14\",\"172.71.124.29\",\"162.158.88.128\",\"162.158.108.155\",\"108.162.226.9\",\"104.23.175.57\",\"162.158.170.62\",\"104.23.175.57\",\"172.69.176.75\",\"172.71.124.182\",\"162.158.170.63\",\"172.69.176.74\",\"172.69.166.4\",\"162.158.170.63\",\"172.69.176.74\",\"162.158.108.154\",\"172.68.164.88\",\"162.158.170.62\",\"172.69.166.5\",\"172.69.166.5\",\"162.158.108.155\",\"172.71.124.182\",\"172.71.124.182\",\"162.158.162.119\",\"162.158.189.62\",\"172.70.92.183\",\"162.158.108.78\",\"162.158.108.78\",\"162.158.189.63\",\"172.70.189.165\",\"172.69.176.55\",\"104.22.66.16\",\"104.22.66.16\",\"172.70.92.183\",\"108.162.226.159\",\"162.158.162.119\",\"172.68.164.69\",\"162.158.88.145\",\"172.68.164.69\",\"162.158.190.72\",\"162.158.88.144\",\"104.22.66.17\",\"172.70.208.68\",\"162.158.162.119\",\"108.162.226.159\",\"172.69.176.54\",\"172.70.208.68\",\"162.158.162.118\",\"172.69.176.54\",\"162.158.108.79\",\"162.158.162.118\",\"172.70.208.69\",\"172.70.208.69\",\"162.158.107.30\",\"108.162.226.158\",\"172.69.176.54\",\"172.71.124.28\",\"162.158.162.119\",\"162.158.189.63\",\"162.158.162.119\",\"172.68.164.89\",\"172.71.124.29\",\"172.70.142.56\",\"172.71.124.28\",\"172.70.208.69\",\"162.158.189.63\",\"162.158.107.29\",\"162.158.170.26\",\"172.69.176.55\",\"172.71.124.29\",\"172.69.176.55\",\"162.158.162.118\",\"172.70.142.56\",\"172.70.208.69\",\"172.70.92.182\",\"172.68.164.68\",\"104.23.175.122\",\"172.68.164.68\",\"172.69.166.5\",\"172.70.208.68\",\"104.23.175.56\",\"162.158.88.144\",\"162.158.190.71\",\"162.158.88.145\",\"172.70.208.58\",\"162.158.88.144\",\"172.71.124.45\",\"162.158.162.119\",\"162.158.106.182\",\"104.23.175.40\",\"172.68.164.88\",\"162.158.162.118\",\"104.23.175.57\",\"104.22.66.16\",\"172.68.164.61\",\"172.71.124.81\",\"172.71.124.81\",\"172.70.208.59\",\"104.22.66.209\",\"172.71.124.44\",\"172.71.124.80\",\"172.71.124.80\",\"108.162.226.150\",\"172.71.124.81\",\"162.158.88.40\",\"162.158.108.63\",\"162.158.170.29\",\"162.158.88.145\",\"172.70.142.57\",\"172.68.164.69\",\"104.23.175.122\",\"162.158.88.128\",\"172.68.164.69\",\"172.70.208.89\",\"108.162.226.8\",\"172.70.92.182\",\"172.71.124.80\",\"162.158.107.30\",\"172.70.208.68\",\"172.70.93.14\",\"108.162.226.159\",\"162.158.88.144\",\"162.158.163.132\",\"172.70.208.68\",\"172.70.142.56\",\"162.158.108.79\",\"172.68.164.68\",\"172.70.142.56\",\"172.68.164.69\",\"172.71.124.45\",\"172.70.142.56\",\"104.22.66.193\",\"172.69.176.55\",\"162.158.108.79\",\"172.70.208.69\",\"162.158.170.63\",\"162.158.88.144\",\"172.70.93.15\",\"104.23.175.122\",\"172.70.208.68\",\"172.69.166.4\",\"162.158.163.200\",\"172.69.176.54\",\"172.69.176.55\",\"172.70.142.56\",\"172.70.142.57\",\"172.69.166.5\",\"162.158.162.31\",\"104.23.175.122\",\"162.158.163.200\",\"172.70.208.89\",\"172.69.176.74\",\"172.70.92.182\",\"104.23.175.123\",\"172.70.142.57\",\"172.71.124.44\",\"172.71.124.44\",\"162.158.108.78\",\"104.23.175.123\",\"162.158.88.128\",\"162.158.88.144\",\"172.70.189.131\",\"172.68.164.69\",\"162.158.163.199\",\"162.158.88.128\",\"104.22.66.211\",\"162.158.108.79\",\"162.158.189.62\",\"162.158.190.72\",\"162.158.163.200\",\"172.69.176.54\",\"162.158.163.200\",\"172.70.142.57\",\"172.69.176.74\",\"172.71.124.45\",\"172.70.142.56\",\"172.68.164.69\",\"104.23.175.123\",\"162.158.163.199\",\"172.70.189.166\",\"172.68.164.61\",\"172.71.124.44\",\"162.158.108.79\",\"104.23.175.123\",\"108.162.226.159\",\"172.69.176.55\",\"172.71.152.88\",\"172.70.142.72\",\"162.158.107.30\",\"162.158.88.46\",\"162.158.189.63\",\"172.68.164.69\",\"172.70.93.15\",\"172.71.124.44\",\"172.70.93.14\",\"172.70.208.68\",\"172.69.176.55\",\"162.158.108.155\",\"162.158.163.199\",\"162.158.189.62\",\"162.158.170.132\",\"162.158.88.14\",\"172.70.208.69\",\"172.71.124.80\",\"172.69.176.54\",\"162.158.189.63\",\"162.158.108.154\",\"162.158.88.15\",\"104.22.66.193\",\"172.70.208.68\",\"172.70.92.183\",\"162.158.163.199\",\"162.158.107.30\",\"162.158.108.63\",\"172.68.164.88\",\"104.23.175.122\",\"172.70.208.58\",\"172.71.124.45\",\"104.22.66.16\",\"172.70.92.183\",\"172.70.208.88\",\"104.23.175.41\",\"162.158.106.183\",\"162.158.108.63\",\"172.70.189.132\",\"172.70.142.73\",\"172.70.208.59\",\"172.71.152.88\",\"162.158.189.63\",\"172.70.208.58\",\"162.158.108.62\",\"162.158.106.66\",\"104.23.175.57\",\"172.70.93.87\",\"172.71.124.80\",\"172.69.176.55\",\"162.158.170.39\",\"162.158.170.95\",\"162.158.162.89\",\"172.69.176.24\",\"172.71.152.32\",\"172.70.208.59\",\"172.71.124.81\",\"172.68.164.69\",\"172.69.176.75\",\"172.69.176.55\",\"172.71.124.44\",\"162.158.88.14\",\"108.162.226.158\",\"104.23.175.122\",\"162.158.170.133\",\"172.70.92.183\",\"172.70.208.68\",\"172.71.124.81\",\"162.158.106.66\",\"162.158.190.25\",\"172.70.92.182\",\"172.71.124.44\",\"162.158.189.12\",\"162.158.88.43\",\"104.23.175.57\",\"162.158.88.43\",\"172.71.124.80\",\"162.158.88.43\",\"172.70.189.166\",\"172.70.142.72\",\"172.71.124.44\",\"162.158.163.199\",\"108.162.226.159\",\"162.158.108.79\",\"172.68.164.69\",\"172.70.208.68\",\"172.70.208.89\",\"162.158.162.31\",\"172.70.142.73\",\"172.69.176.54\",\"172.70.189.131\",\"172.70.142.73\",\"172.71.152.87\",\"162.158.108.79\",\"172.70.208.88\",\"162.158.88.43\",\"104.23.175.56\",\"104.22.66.254\",\"172.70.142.72\",\"162.158.108.154\",\"104.23.175.123\",\"172.71.152.87\",\"172.70.92.167\",\"172.69.176.55\",\"162.158.108.79\",\"162.158.88.42\",\"172.68.164.89\",\"162.158.163.200\",\"172.69.176.55\",\"108.162.226.158\",\"104.23.175.122\",\"104.23.175.122\",\"162.158.106.67\",\"162.158.189.251\",\"172.69.166.4\",\"162.158.108.78\",\"172.70.93.32\",\"162.158.88.46\",\"162.158.162.30\",\"172.70.189.166\",\"172.69.176.54\",\"172.71.124.44\",\"104.22.66.254\",\"162.158.189.13\",\"162.158.162.31\",\"162.158.189.250\",\"172.70.142.56\",\"162.158.163.132\",\"172.68.164.68\",\"172.69.176.91\",\"172.69.176.70\",\"104.23.175.122\",\"162.158.108.155\",\"108.162.226.158\",\"172.69.166.5\",\"162.158.88.131\",\"172.69.165.61\",\"172.70.189.131\",\"162.158.108.154\",\"162.158.106.183\",\"162.158.88.5\",\"172.70.189.165\",\"172.70.208.88\",\"172.69.166.5\",\"162.158.108.79\",\"162.158.107.29\",\"172.69.166.5\",\"108.162.227.5\",\"172.71.124.45\",\"172.70.208.68\",\"162.158.88.5\",\"172.69.176.71\",\"162.158.190.72\",\"172.71.124.81\",\"172.70.189.166\",\"172.69.176.71\",\"172.70.142.57\",\"172.69.165.60\",\"162.158.189.63\",\"172.70.92.182\",\"162.158.189.63\",\"172.69.165.61\",\"162.158.189.63\",\"162.158.190.71\",\"172.70.93.15\",\"172.71.124.80\",\"162.158.163.132\",\"172.71.124.81\",\"162.158.162.119\",\"108.162.227.6\",\"172.70.93.14\",\"162.158.190.57\",\"104.23.175.122\",\"162.158.163.199\",\"172.70.92.183\",\"172.70.208.89\",\"104.23.175.56\",\"172.69.166.5\",\"162.158.106.66\",\"162.158.162.30\",\"172.68.164.60\",\"162.158.108.78\",\"162.158.88.155\",\"172.69.176.75\",\"172.69.176.55\",\"162.158.108.155\",\"172.69.176.74\",\"172.68.164.88\",\"162.158.170.128\",\"162.158.88.155\",\"172.71.152.87\",\"104.23.175.56\",\"104.23.175.56\",\"172.71.124.80\",\"172.71.152.88\",\"162.158.88.5\",\"172.69.176.74\",\"172.70.92.183\",\"172.70.142.73\",\"172.70.142.72\",\"162.158.163.199\",\"104.23.175.57\",\"172.70.208.68\",\"162.158.163.199\",\"162.158.170.65\",\"162.158.108.155\",\"162.158.108.155\",\"172.70.189.132\",\"172.70.93.14\",\"104.23.175.57\",\"162.158.108.79\",\"162.158.107.29\",\"162.158.88.70\",\"162.158.190.71\",\"172.69.176.54\",\"162.158.107.30\",\"172.70.92.182\",\"162.158.108.155\",\"104.23.175.122\",\"104.23.175.122\",\"172.70.93.33\",\"162.158.190.71\",\"162.158.170.27\",\"104.23.175.57\",\"172.70.208.68\",\"104.23.175.123\",\"104.23.175.123\",\"104.23.175.123\",\"172.69.176.54\",\"108.162.226.8\",\"172.71.124.81\",\"162.158.108.79\",\"172.68.164.89\",\"108.162.226.158\",\"104.23.175.57\",\"172.70.142.73\",\"172.69.176.75\",\"172.70.208.68\",\"172.70.93.33\",\"172.71.124.44\",\"172.70.142.72\",\"172.69.176.55\",\"162.158.106.66\",\"162.158.88.71\",\"172.71.124.45\",\"104.22.66.211\",\"162.158.107.29\",\"162.158.88.46\",\"162.158.108.79\",\"104.23.175.122\",\"172.70.208.88\",\"162.158.106.67\",\"162.158.108.154\",\"172.70.189.132\",\"172.70.208.88\",\"172.68.164.61\",\"172.70.189.132\",\"172.71.124.44\",\"162.158.190.72\",\"172.69.176.24\",\"104.22.66.211\",\"162.158.88.43\",\"162.158.170.26\",\"162.158.189.63\",\"172.69.176.55\",\"172.69.176.54\",\"162.158.88.42\",\"104.23.175.56\",\"172.70.189.166\",\"162.158.88.46\",\"104.23.175.122\",\"162.158.163.132\",\"162.158.88.42\",\"162.158.189.62\",\"172.69.166.5\",\"172.70.208.68\",\"162.158.108.79\",\"172.68.164.108\",\"172.68.164.109\",\"172.71.124.81\",\"162.158.88.42\",\"162.158.107.30\",\"172.69.176.55\",\"172.68.164.109\",\"108.162.226.9\",\"172.69.176.75\",\"162.158.108.134\",\"108.162.226.158\",\"162.158.106.66\",\"172.70.142.57\",\"172.71.124.80\",\"162.158.88.47\",\"162.158.108.135\",\"162.158.163.131\",\"172.70.208.89\",\"172.70.208.59\",\"162.158.162.119\",\"172.70.142.56\",\"172.71.124.44\",\"172.69.176.74\",\"172.68.164.109\",\"162.158.107.29\",\"162.158.88.47\",\"104.23.175.56\",\"172.70.189.166\",\"172.71.124.45\",\"172.70.189.166\",\"162.158.107.29\",\"172.68.164.108\",\"162.158.88.15\",\"172.69.166.5\",\"172.69.166.4\",\"104.22.66.211\",\"162.158.189.62\",\"172.70.92.183\",\"162.158.163.131\",\"172.71.124.81\",\"172.70.208.69\",\"104.23.175.123\",\"162.158.170.178\",\"104.23.175.123\",\"108.162.226.158\",\"172.68.164.37\",\"172.70.189.166\",\"172.69.176.55\",\"104.23.175.123\",\"172.70.208.88\",\"162.158.106.164\",\"104.23.175.56\",\"172.68.164.147\",\"162.158.162.118\",\"104.23.175.57\",\"172.68.164.146\",\"108.162.226.9\",\"172.71.124.28\",\"172.69.176.75\",\"172.71.124.29\",\"172.70.142.57\",\"172.71.124.185\",\"172.70.93.32\",\"162.158.106.165\",\"172.69.166.4\",\"172.69.166.4\",\"172.71.124.28\",\"104.23.175.123\",\"162.158.189.62\",\"172.70.92.140\",\"104.22.66.193\",\"162.158.108.32\",\"172.70.208.69\",\"108.162.226.158\",\"172.70.189.132\",\"104.22.66.211\",\"172.70.93.90\",\"162.158.170.65\",\"104.23.175.57\",\"104.23.175.57\",\"108.162.226.158\",\"104.23.175.122\",\"172.70.208.69\",\"162.158.189.62\",\"172.71.124.28\",\"162.158.108.32\",\"162.158.88.41\",\"172.68.164.69\",\"162.158.107.30\",\"162.158.88.146\",\"172.69.176.74\",\"172.69.166.4\",\"162.158.162.119\",\"162.158.106.165\",\"172.68.164.88\",\"162.158.88.146\",\"172.68.164.32\",\"104.23.175.122\",\"162.158.88.146\",\"162.158.170.26\",\"172.71.124.28\",\"162.158.162.119\",\"104.23.175.56\",\"172.69.176.54\",\"172.70.208.88\",\"104.23.175.123\",\"162.158.189.62\",\"104.23.175.122\",\"104.22.66.211\",\"172.70.208.89\",\"162.158.163.132\",\"162.158.107.99\",\"172.69.176.54\",\"172.70.142.56\",\"172.68.164.89\",\"172.70.189.166\",\"162.158.108.109\",\"172.70.208.68\",\"162.158.108.32\",\"172.70.208.68\",\"104.23.175.122\",\"162.158.108.32\",\"172.71.124.29\",\"104.23.175.123\",\"162.158.108.109\",\"172.71.124.185\",\"172.69.166.5\",\"104.23.175.123\",\"172.69.176.74\",\"172.69.176.74\",\"162.158.107.99\",\"172.70.189.166\",\"162.158.88.41\",\"172.70.92.183\",\"162.158.189.63\",\"172.69.166.5\",\"172.70.208.88\",\"162.158.163.200\",\"172.69.166.5\",\"162.158.163.199\",\"172.70.142.57\",\"104.23.175.122\",\"172.70.208.69\",\"172.70.208.68\",\"172.68.164.149\",\"162.158.108.99\",\"172.69.176.55\",\"108.162.227.94\",\"172.69.176.54\",\"108.162.227.93\",\"172.69.166.4\",\"172.70.208.69\",\"104.23.175.57\",\"172.71.124.29\",\"172.69.176.74\",\"162.158.88.47\",\"172.69.166.4\",\"172.70.142.56\",\"172.70.142.56\",\"172.69.176.54\",\"172.70.92.183\",\"108.162.226.150\",\"104.22.66.193\",\"162.158.88.14\",\"162.158.162.31\",\"172.69.166.5\",\"172.71.124.185\",\"162.158.88.47\",\"162.158.189.63\",\"172.71.124.29\",\"104.23.175.57\",\"162.158.108.99\",\"172.70.208.89\",\"104.23.175.57\",\"172.70.93.15\",\"172.71.124.185\",\"162.158.170.18\",\"162.158.190.71\",\"172.70.208.89\",\"162.158.163.200\",\"162.158.189.62\",\"172.70.142.57\",\"108.162.226.159\",\"172.70.189.131\",\"162.158.163.200\",\"172.70.142.57\",\"172.70.142.57\",\"162.158.170.27\",\"172.71.124.45\",\"104.23.175.122\",\"172.69.176.54\",\"162.158.108.79\",\"162.158.163.200\",\"162.158.88.14\",\"172.70.142.57\",\"172.71.124.45\",\"172.70.142.57\",\"162.158.108.135\",\"104.22.66.193\",\"108.162.226.9\",\"172.69.166.5\",\"162.158.88.14\",\"172.70.93.14\",\"104.23.175.57\",\"172.70.189.131\",\"104.23.175.122\",\"104.23.175.122\",\"172.69.176.55\",\"108.162.226.159\",\"172.69.166.4\",\"172.69.166.5\",\"172.69.176.74\",\"172.71.124.81\",\"172.70.142.56\",\"172.71.124.81\",\"172.68.164.80\",\"162.158.108.79\",\"162.158.88.47\",\"172.70.208.69\",\"172.70.92.182\",\"162.158.162.31\",\"162.158.163.200\",\"162.158.88.14\",\"172.70.142.57\",\"172.70.93.14\",\"172.69.176.74\",\"172.68.164.137\",\"172.69.166.4\",\"172.69.166.4\",\"104.23.175.123\",\"162.158.108.78\",\"172.70.142.56\",\"172.69.176.75\",\"172.68.164.137\",\"108.162.226.159\",\"172.69.166.4\",\"162.158.108.79\",\"162.158.162.31\",\"172.70.92.183\",\"172.69.166.5\",\"162.158.108.155\",\"172.69.166.5\",\"162.158.88.46\",\"172.68.164.137\",\"104.22.66.193\",\"162.158.170.132\",\"172.71.124.80\",\"162.158.108.154\",\"162.158.108.154\",\"162.158.88.16\",\"162.158.189.115\",\"172.71.124.81\",\"172.70.208.88\",\"172.70.142.48\",\"172.70.93.87\",\"172.69.166.4\",\"172.68.164.59\",\"172.69.176.75\",\"162.158.163.200\",\"172.68.164.98\",\"172.69.166.4\",\"172.68.164.99\",\"172.70.208.88\",\"172.69.176.74\",\"172.68.164.58\",\"162.158.88.16\",\"162.158.88.47\",\"162.158.170.133\",\"104.23.175.57\",\"104.23.175.41\",\"162.158.106.66\",\"172.70.142.57\",\"172.70.208.89\",\"172.68.164.58\",\"172.70.208.89\",\"172.68.164.137\",\"172.71.124.80\",\"162.158.190.11\",\"172.70.142.49\",\"172.69.166.5\",\"172.70.208.59\",\"172.71.124.80\",\"172.70.208.68\",\"172.70.142.56\",\"172.70.208.68\",\"172.70.142.57\",\"172.68.164.88\",\"172.70.92.182\",\"108.162.226.159\",\"162.158.107.29\",\"162.158.190.72\",\"172.70.142.57\",\"104.23.175.122\",\"172.70.93.15\",\"172.70.208.69\",\"172.70.208.69\",\"172.69.176.55\",\"162.158.163.200\",\"172.70.142.57\",\"172.71.124.81\",\"172.69.166.5\",\"104.22.66.211\",\"172.69.176.74\",\"108.162.226.9\",\"104.23.175.122\",\"172.71.124.45\",\"172.70.208.58\",\"172.69.176.74\",\"172.70.92.182\",\"172.69.176.55\",\"172.70.142.56\",\"172.70.142.56\",\"172.69.166.5\",\"172.71.124.80\",\"162.158.190.72\",\"172.69.166.4\",\"162.158.108.154\",\"104.23.175.56\",\"172.69.176.74\",\"162.158.88.47\",\"162.158.189.42\",\"104.22.66.211\",\"172.70.92.183\",\"172.70.208.68\",\"104.23.175.122\",\"172.70.208.68\",\"162.158.88.47\",\"104.23.175.122\",\"104.23.175.57\",\"172.70.93.14\",\"104.22.66.193\",\"104.22.66.193\",\"172.69.166.5\",\"172.68.164.69\",\"172.69.176.55\",\"172.69.176.55\",\"108.162.226.158\",\"162.158.108.78\",\"162.158.189.62\",\"172.70.189.166\",\"172.70.189.166\",\"172.70.208.69\",\"162.158.163.200\",\"172.68.164.68\",\"162.158.163.199\",\"172.68.164.68\",\"104.23.175.56\",\"172.71.124.44\",\"104.22.66.193\",\"104.22.66.193\",\"108.162.226.8\",\"162.158.88.14\",\"162.158.170.133\",\"162.158.189.62\",\"172.70.189.166\",\"172.70.208.69\",\"162.158.170.133\",\"104.22.66.193\",\"172.70.208.68\",\"172.70.142.57\",\"162.158.88.15\",\"172.70.208.89\",\"172.68.164.69\",\"172.70.208.89\",\"162.158.88.14\",\"172.71.124.45\",\"162.158.107.29\",\"162.158.108.78\",\"172.70.189.165\",\"108.162.226.9\",\"162.158.88.15\",\"172.70.189.165\",\"162.158.107.30\",\"172.70.208.88\",\"172.69.176.54\",\"172.70.142.57\",\"172.70.93.15\",\"172.71.124.80\",\"172.69.176.74\",\"172.71.124.45\",\"162.158.88.15\",\"172.68.164.68\",\"172.69.176.74\",\"172.70.208.69\",\"172.70.93.15\",\"172.69.176.54\",\"104.22.66.211\",\"172.69.166.4\",\"162.158.107.29\",\"104.22.66.193\",\"162.158.190.72\",\"172.70.142.56\",\"172.70.142.56\",\"172.70.92.183\",\"162.158.88.15\"]}', `Jumlah` = 1673
WHERE `Tanggal` = '2026-10-02'
0.0024 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2026-10-02'
0.0005 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2026-10-01'
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
0.0007 sec
SELECT *
FROM `menu`
WHERE `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2026-10-02 11:38:20'
AND `a`.`id` = '3649'
0.0004 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 11:38:20'
AND `a`.`id` = '247'
0.0005 sec
SELECT *
FROM `menu`
WHERE `parrent` = '40'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '107'
AND `enabled` = 1
ORDER BY `urut`
0.0002 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 11:38:20'
AND `a`.`id` = '706'
0.0004 sec
SELECT *
FROM `menu`
WHERE `parrent` = '122'
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 11:38:20'
AND `a`.`id` = '707'
0.0004 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 11:38:20'
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 11:38:20'
AND `a`.`id` = '705'
0.0007 sec
SELECT *
FROM `menu`
WHERE `parrent` = '125'
AND `enabled` = 1
ORDER BY `urut`
0.0002 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 11:38:20'
AND `a`.`id` = '3647'
0.0004 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.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '7'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '8'
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 11:38:20'
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 11:38:20'
AND `a`.`id` = '38'
0.0008 sec
SELECT *
FROM `menu`
WHERE `parrent` = '30'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '31'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '76'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '77'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '126'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '127'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '25'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '99'
AND `enabled` = 1
ORDER BY `urut`
0.0002 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.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '136'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '137'
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '138'
AND `enabled` = 1
ORDER BY `urut`
0.0002 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.0002 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.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '17'
ORDER BY `urut`
0.0003 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.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '8'
ORDER BY `urut`
0.0002 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.0008 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 11:38:20'
AND `a`.`slug` = ''
0.0023 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 11:38:20'
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 11:38:20'
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 11:38:20')
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 11:38:20')ORDER BY RAND() LIMIT 10
0.0062 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 11:38:20'
ORDER BY `tgl_upload` DESC
LIMIT 10
0.0019 sec
SELECT *
FROM `widget`
WHERE `enabled` = 1
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '104.23.175.40'
)
AND `status` = 1
0.0002 sec
SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4
0.0005 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.0062 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.0185 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.0040 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.0004 sec
SELECT *
FROM `media_sosial`
WHERE `enabled` = 1
0.0006 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 11:38:20'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
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`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2026-10-02 11:38:20'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0011 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 11:38:20'
ORDER BY rand()
LIMIT 7
0.0074 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.0003 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan
FROM `tweb_penduduk_sex` `u`
LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0002 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.0024 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'sinergi_program.php'
0.0002 sec
SELECT `setting`
FROM `widget`
WHERE `isi` = 'sub_link.php'
0.0003 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.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 `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.0003 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.0002 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.0002 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.0002 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.0005 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.0003 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.0003 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.0002 sec
Komentar baru terbit setelah disetujui Admin