Online
3 Visitor
| Hari ini | : | 38 |
| Kemarin | : | 63 |
| Total | : | 43.159 |
| OS | : | Unknown Platform |
| IP Address | : | 18.191.190.165 |
| Browser | : | Mozilla 5.0 |
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
Belum Hadir
OpenSID Mobile
Dapatkan Aplikasi Layanan Mandiri Mobile
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Tidak ada di Kantor
Hubungi Perangkat Desa untuk mendapatkan PIN
Sistem Informasi Desa Puding Kecamatan Kumpeh, Kabupaten Muaro Jambi
Jl. Jambi -Suak Kandis KM. 41 Desa Puding Kecamatan Kumpeh, Kabupaten Muaro Jambi
CodeIgniter version : 3.1.13
DevelBar version : 1.2.2
PHP version : 7.4.33
Default language : Indonesia
0.7547 secLoading Time: Base Classes : 0.0026 sec
Controller Execution Time ( First / Index ) : 0.6216 sec
10.05MB
Request : first/indexMethod : GET
DatabaseSHOW TABLES FROM `kh13puding_sid` 0.0007 sec
SHOW DATABASES 0.0013 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'kh13puding_sid' AND table_name = 'user' 0.0002 sec
SHOW COLUMNS FROM `anjungan` 0.0006 sec
SELECT * FROM `anjungan` WHERE ( `ip_address` = '18.191.190.165' 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.0002 sec
SHOW COLUMNS FROM `analisis_master` 0.0024 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.0001 sec
SHOW COLUMNS FROM `analisis_master` 0.0039 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
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT COUNT(a.id) AS jml 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`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND (`a`.`headline` != 1 and `a`.`headline` != 2) AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0006 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`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND (`a`.`headline` != 1 and `a`.`headline` != 2) AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' ORDER BY `a`.`tgl_upload` DESC LIMIT 6 0.0021 sec
SHOW COLUMNS FROM `artikel` 0.0029 sec
SELECT `a`.*, `u`.`nama` AS `owner`, 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` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND (`headline` = 2 or `headline` = 1) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' ORDER BY `tgl_upload` DESC 0.0003 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 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.0005 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0005 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 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` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0005 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0016 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0005 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0100 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0006 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0060 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` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0007 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0027 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0025 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0014 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0049 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SELECT `u`.*, COUNT(k.id) as jumlah, COUNT(CASE WHEN k.status_covid = u.id AND p.sex = 1 THEN k.id_terdata END) AS laki, COUNT(CASE WHEN k.status_covid = u.id AND p.sex = 2 THEN k.id_terdata END) AS perempuan FROM `ref_status_covid` `u` LEFT JOIN `covid19_pemudik` `k` ON `k`.`status_covid` = `u`.`id` and `k`.`config_id` = 1 LEFT JOIN `tweb_penduduk` `p` ON `p`.`id`=`k`.`id_terdata` GROUP BY `u`.`id` 0.0425 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.0007 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `jenis_widget` <> 3 AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0003 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0001 sec
SHOW COLUMNS FROM `sys_traffic` 0.0017 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"18.191.190.165\",\"3.148.109.137\",\"57.141.2.29\",\"3.19.70.25\",\"3.19.70.25\",\"18.218.2.200\",\"3.137.188.40\",\"3.141.46.189\",\"18.224.20.254\",\"3.21.122.130\",\"3.21.122.130\",\"3.21.122.130\",\"3.144.29.148\",\"3.144.29.148\",\"3.144.29.148\",\"57.141.2.4\",\"18.217.168.117\",\"18.118.254.77\",\"18.118.254.77\",\"57.141.2.1\",\"3.129.52.253\",\"18.226.163.178\",\"18.226.163.178\",\"57.141.2.12\",\"18.216.227.61\",\"194.163.182.227\",\"57.141.2.26\",\"57.141.2.15\",\"57.141.2.8\",\"209.97.174.181\",\"57.141.2.26\",\"66.249.71.199\",\"66.249.66.32\",\"57.141.2.2\",\"57.141.2.3\",\"66.249.66.4\",\"66.249.66.20\",\"57.141.2.24\"]}', `Jumlah` = 38 WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0074 sec
SHOW COLUMNS FROM `sys_traffic` 0.0058 sec
SELECT * FROM `sys_traffic` WHERE ( `config_id` = 1 ) AND `Tanggal` = '2025-04-01' 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0087 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2025-03-31' AND ( `config_id` = 1 ) 0.0002 sec
SHOW COLUMNS FROM `sys_traffic` 0.0035 sec
SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE ( `config_id` = 1 ) 0.0006 sec
SHOW COLUMNS FROM `menu` 0.0046 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.0059 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '16' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `menu` 0.0050 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '17' AND `enabled` = 1 ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0058 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '93' 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload` FROM `artikel` WHERE ( `config_id` = 1 ) AND `id` = '92' 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0002 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '24' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0004 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '115' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0003 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '122' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0008 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '109' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `menu` 0.0028 sec
SELECT * FROM `menu` WHERE ( `config_id` = 1 ) AND `parrent` = '119' AND `enabled` = 1 ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0034 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 OR `config_id` IS NULL ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0054 sec
SHOW COLUMNS FROM `kategori` 0.0036 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '1' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `kategori` 0.0061 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '4' ORDER BY `urut` 0.0002 sec
SHOW COLUMNS FROM `kategori` 0.0056 sec
SELECT * FROM `kategori` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = '5' ORDER BY `urut` 0.0001 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0002 sec
SHOW COLUMNS FROM `teks_berjalan` 0.0021 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.0002 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0022 sec
SHOW COLUMNS FROM `artikel` 0.0061 sec
SHOW COLUMNS FROM `artikel` 0.0002 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 (`headline` = 2 or `headline` = 3) AND `gambar` != '' AND `tgl_upload` < '2025-04-01 04:09:49' 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 (`headline` = 2 or `headline` = 3) AND `gambar1` != '' AND `tgl_upload` < '2025-04-01 04:09:49' 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 (`headline` = 2 or `headline` = 3) AND `gambar2` != '' AND `tgl_upload` < '2025-04-01 04:09:49') 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 (`headline` = 2 or `headline` = 3) AND `gambar3` != '' AND `tgl_upload` < '2025-04-01 04:09:49')ORDER BY RAND() LIMIT 10 0.0003 sec
SHOW COLUMNS FROM `artikel` 0.0003 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `gambar` != '' AND `tgl_upload` < '2025-04-01 04:09:49' AND (`headline` = 2 or `headline` = 3) ORDER BY `tgl_upload` DESC LIMIT 10 0.0001 sec
SHOW COLUMNS FROM `widget` 0.0004 sec
SELECT * FROM `widget` WHERE ( `config_id` = 1 ) AND `enabled` = 1 ORDER BY `urut` 0.0010 sec
SHOW COLUMNS FROM `config` 0.0003 sec
SHOW COLUMNS FROM `gambar_gallery` 0.0061 sec
SELECT * FROM `gambar_gallery` WHERE ( `config_id` = 1 ) AND `enabled` = 1 AND `parrent` = 0 ORDER BY rand() LIMIT 4 0.0004 sec
SHOW COLUMNS FROM `agenda` 0.0056 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.0027 sec
SHOW COLUMNS FROM `agenda` 0.0028 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) > CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' ORDER BY `g`.`tgl_agenda` 0.0003 sec
SHOW COLUMNS FROM `agenda` 0.0003 sec
SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE DATE(g.tgl_agenda) < CURDATE() AND ( `g`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' 0.0001 sec
SHOW COLUMNS FROM `komentar` 0.0004 sec
SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.* FROM `komentar` `k` JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id` WHERE ( `k`.`config_id` = 1 ) AND `k`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0002 sec
SHOW COLUMNS FROM `media_sosial` 0.0004 sec
SELECT * FROM `media_sosial` WHERE ( `config_id` = 1 ) AND `enabled` = 1 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0048 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0002 sec
SHOW COLUMNS FROM `artikel` 0.0018 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' ORDER BY `a`.`hit` DESC LIMIT 7 0.0001 sec
SHOW COLUMNS FROM `artikel` 0.0066 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE ( `a`.`config_id` = 1 ) AND `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < '2025-04-01 04:09:49' ORDER BY rand() LIMIT 7 0.0005 sec
SHOW COLUMNS FROM `tweb_desa_pamong` 0.0059 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama FROM `tweb_desa_pamong` `dp` LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend` LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id` WHERE ( `dp`.`config_id` = 1 ) AND `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0004 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1 LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0012 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.0007 sec
SHOW COLUMNS FROM `widget` 0.0060 sec
SELECT `setting` FROM `widget` WHERE ( `config_id` = 1 ) AND `isi` = 'sinergi_program.php' 0.0003 sec
SHOW COLUMNS FROM `keuangan_master` 0.0030 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.0004 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0005 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` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0005 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0018 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0030 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0002 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0004 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0007 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0007 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0022 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0003 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0048 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0030 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0025 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0030 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` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0008 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0012 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0002 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 sec
SELECT `tahun_anggaran` FROM `keuangan_master` WHERE ( `config_id` = 1 ) ORDER BY `tahun_anggaran` DESC 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0022 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) GROUP BY `Akun`, `Nama_Akun` ORDER BY `Akun` ASC 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(AnggaranStlhPAK) AS pagu FROM `keuangan_ta_rab_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0074 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_tbp_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0004 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` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0007 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0048 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 0.0004 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_spj_rinci` WHERE `Tahun` = '2022' AND `Kd_Rincian` LIKE '5.%' ESCAPE '!' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0023 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai) AS realisasi FROM `keuangan_ta_mutasi` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0025 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Kredit) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0003 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(debet) AS realisasi FROM `keuangan_ta_jurnal_umum_rinci` WHERE `Tahun` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pelaksanaan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0003 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `keuangan_ref_rek3`.`Jenis` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0003 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0003 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0006 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_pendapatan` 0.0001 sec
SHOW COLUMNS FROM `keuangan_master` 0.0076 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` = '2022' AND ( `keuangan_master`.`config_id` = 1 ) ORDER BY `Kd_Bid` ASC 0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci` 0.0043 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0005 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0003 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` = '2022' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0005 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci` 0.0005 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` = '2022' AND `keuangan_ta_spp`.`Jn_SPP` = 'UM' AND ( `keuangan_ta_spp_rinci`.`config_id` = 1 ) GROUP BY `jenis_belanja` 0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_spj_rinci` 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_mutasi` 0.0004 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci` 0.0005 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` = '2022' AND ( `config_id` = 1 ) GROUP BY `jenis_belanja` 0.0001 sec
SHOW COLUMNS FROM `log_surat` 0.0066 sec
SELECT * FROM pengunjung WHERE ip='18.191.190.165' AND tanggal='2025-04-01' 0.0025 sec
INSERT INTO pengunjung (ip, tanggal, hits, online) VALUES('18.191.190.165','2025-04-01','1','1743455390') 0.0110 sec
SELECT * FROM pengunjung WHERE online > '1743454790' 0.0019 sec
Total Execution Time 0.3416 sec
Host:localhost_ORM/kh13puding_sidselect * from `config` limit 1 0.9900 sec
select count(*) as aggregate from `config` 0.1000 sec
select count(*) as aggregate from `config` 0.0500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 3.4000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'setting_aplikasi' 0.4700 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc 0.5200 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.3800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 0.4700 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1 0.1500 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE' 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' 0.6000 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1 0.0900 sec
select count(*) as aggregate from `config` 0.0700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.5000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.5200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 0.5400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan' 0.5100 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 0.4500 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Selasa' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 3.5800 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` = 'Selasa' and (time(`jam_masuk`) > '04:09' or date_add(jam_keluar, interval 10 minute) < '04:09') 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 = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 2.1200 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1 0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.5000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.1600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.2600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.2400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.9300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.2200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.7200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 5.6100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 3.9400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.6100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 5.3600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.9500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.0700 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.0800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 12.9100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.6600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.2100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.3100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.1900 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.5100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 3.5600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.6300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.5200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 7.2000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 1.3900 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.1100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 5.7900 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3900 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.8400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.7200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.9100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 5.2200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.4400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 0.3100 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 2.0000 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config' 4.5200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1 0.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'tweb_desa_pamong' 1.9900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 1.6600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 27 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 2.9000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 28 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.2500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 30 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.7300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.4700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.5600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 36 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 4.6200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 37 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.5000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 1.8300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 38 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa' 0.3400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 39 and `tanggal` = '2025-04-01' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1 0.3200 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE' 0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 9.0100 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1 0.2100 sec
Total Execution Time 153.7800 sec
154.1216 sec
N/A
Libraries (21)Benchmark
Cache
Config
Hooks
Input
Lang
Loader
Log
Output
Paging
Router
Security
Security_header
Security_trusted_host
Session
Spreadsheet_Excel_Reader
URI
Upload
User_agent
Utf8
Validasi
Helpers (14)Cek_helper
Database_helper
Date_helper
Donjolib_helper
File_helper
Form_helper
General_helper
Language_helper
Opensid_helper
Pict_helper
Surat_helper
Text_helper
Url_helper
Utility_helper
Views (30)
Configuration trusted_hosts:Array ( )
base_url:https://puding.desa.id/
index_page:index.php/
uri_protocol:REQUEST_URI
url_suffix:
language:indonesia
charset:UTF-8
enable_hooks:1
subclass_prefix:MY_
composer_autoload:vendor/autoload.php
permitted_uri_chars:a-z 0-9~%.:_\-
enable_query_strings:
controller_trigger:c
function_trigger:m
directory_trigger:d
allow_get_array:1
log_threshold:Array ( [0] => 1 [1] => 5 )
log_path:storage//logs/
clv_log_file_pattern:log-*.php
log_file_extension:
log_file_permissions:420
log_date_format:Y-m-d H:i:s
error_views_path:
cache_path:/home/kh13puding/public_html/desa/cache/
cache_query_string:
encryption_key:lumbungkomunitas
sess_driver:files
sess_cookie_name:ci_session
sess_expiration:7200
sess_save_path:/tmp
sess_match_ip:
sess_time_to_update:300
sess_regenerate_destroy:
cookie_prefix:
cookie_domain:
cookie_path:/
cookie_secure:
cookie_httponly:
standardize_newlines:
global_xss_filtering:
csrf_protection:1
csrf_token_name:sidcsrf
csrf_cookie_name:sidcsrf
csrf_expire:7200
csrf_regenerate:1
csrf_exclude_uris:Array ( [0] => api.*+ )
compress_output:
time_reference:local
rewrite_short_tags:
proxy_ips:
nama_aplikasi:OpenSID
nama_lembaga:OpenDesa
server_pantau:https://pantau.opensid.my.id
token_pantau:eyJ0eXAiOiJKV1QiLCJhbGciOiJIUzI1NiJ9.eyJpZCI6bnVsbCwidGltZXN0YW1wIjoxNjAzNDY2MjM5fQ.HVCNnMLokF2tgHwjQhSIYo6-2GNXB4-Kf28FSIeXnZw
server_layanan:https://layanan.opendesa.id
rilis_umum:https://api.github.com/repos/opensid/opensid/releases/latest
rilis_premium:https://api.github.com/repos/opensid/rilis-premium/releases/latest
api_idm:https://idm.kemendesa.go.id/open/api/desa/rumusan
api_sdgs:https://sid.kemendesa.go.id/sdgs/searching/score-sdgs?location_code=
api_hari_libur:https://raw.githubusercontent.com/guangrei/APIHariLibur_V2/main/calendar.min.json
views_blade:resources/views/
cache_blade:storage/framework/views/
maximum_login_attempts:3
lockout_time:300
useDatabaseConfig:1
demo_mode:
demo_akun:Array ( [1] => 123456 [2] => 234561 [3] => 345612 )
demo_user:Array ( [username] => admin [password] => sid304 )
rentang_kirim_pesan:60
user_admin:1
kode_kota:603
desa:Array ( [desa/anjungan/menu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/arsip/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/cache/] => Array ( [0] => 509 ) [desa/config/] => Array ( [0] => 509 ) [desa/logo/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/pengaturan/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/] => Array ( [0] => 509 ) [desa/pengaturan/siteman/images/] => Array ( [0] => 509 ) [desa/template-surat/] => Array ( [0] => 509 ) [desa/template-surat/lampiran/] => Array ( [0] => 509 ) [desa/themes/] => Array ( [0] => 509 ) [desa/upload/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/artikel/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/buku_tamu/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dokumen/] => Array ( [0] => 509 [1] => htaccess2 ) [desa/upload/galeri/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/area/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/garis/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/gis/lokasi/point/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/media/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pendaftaran/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengaduan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/pengesahan/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/produk/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/sinkronisasi/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/thumbs/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/user_pict/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/vaksin/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/widgets/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/upload/dtks/] => Array ( [0] => 509 [1] => htaccess1 ) [desa/widgets/] => Array ( [0] => 509 ) )
lainnya:Array ( [storage/framework/] => Array ( [0] => 509 [1] => htaccess3 ) [storage/logs/] => Array ( [0] => 509 [1] => htaccess3 ) [backup_inkremental/] => Array ( [0] => 509 [1] => htaccess3 ) [assets/] => Array ( [0] => 493 [1] => htaccess3 ) [assets/filemanager/] => Array ( [0] => 493 [1] => htaccess4 ) )
config:<?php // ---------------------------------------------------------------------------- // Konfigurasi aplikasi dalam berkas ini merupakan setting konfigurasi tambahan // SID. Letakkan setting konfigurasi ini di desa/config/config.php. // ---------------------------------------------------------------------------- // Uncomment jika situs ini untuk demo. Pada demo, user admin tidak bisa dihapus // dan username/password tidak bisa diubah // $config['demo_mode'] = false; // Setting ini untuk menentukan user yang dipercaya. User dengan id di setting ini // dapat membuat artikel berisi video yang aktif ditampilkan di Web. // Misalnya, ganti dengan id = 1 jika ingin membuat pengguna admin sebagai pengguna terpecaya. $config['user_admin'] = 0; // Ijinkan agar bisa melakukan impor data penduduk dari OpenKAB $config['impor_massal'] = false; // Untuk menghindari masalah keamanan, Anda mungkin ingin mengonfigurasi daftar "host tepercaya". // Contoh: ['localhost', 'my-development.com', 'my-production.com', 'subdomain.domain.com'] $config['trusted_hosts'] = []; // config email $config['protocol'] = 'smtp'; // mail mail, sendmail, or smtp The mail sending protocol. $config['smtp_host'] = ''; // SMTP Server Address. $config['smtp_user'] = ''; // SMTP Username. $config['smtp_pass'] = ''; // SMTP Password. $config['smtp_port'] = ''; // SMTP Port."
database:<?php // ------------------------------------------------------------------------- // // Letakkan username, password dan database sebetulnya di file ini. // File ini JANGAN di-commit ke GIT. TAMBAHKAN di .gitignore // ------------------------------------------------------------------------- // Data Konfigurasi MySQL yang disesuaikan $db['default']['hostname'] = 'localhost'; $db['default']['username'] = 'root'; $db['default']['password'] = ''; $db['default']['port'] = 3306; $db['default']['database'] = 'premium'; /* | Untuk setting koneksi database 'Strict Mode' | Sesuaikan dengan ketentuan hosting */ $db['default']['stricton'] = TRUE;
index_html:<html> <head> <title>403 Forbidden</title> </head> <body> <p>Directory access is forbidden.</p> </body> </html>
htaccess1:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess2:<FilesMatch "\.(rtf|pdf|jpe?g|png|php|php\.|php3?|phtml|phpjpeg)$"> Order Allow,Deny Deny from all </FilesMatch>
htaccess3:<FilesMatch "\.(php|php\.|php3?|phtml|phpjpeg|pl|py|jsp|asp|htm|shtml|sh|cgi)$"> order allow,deny deny from all </FilesMatch>
htaccess4:<FilesMatch "\.(php)$"> order allow,deny allow from all </FilesMatch>
offline_mode:<!DOCTYPE html> <html> <head> <title>Offline Mode - <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?></title> <link rel="shortcut icon" href="<?= favico_desa() ?>"/> </head> <body> <br/><br/><br/> <div align="center"> <img class="profile-user-img img-responsive img-circle" src="<?= gambar_desa($main['logo']); ?>" alt="Logo"> <p> Selamat datang di Halaman Situs Resmi <?= ucwords($this->setting->sebutan_desa).' '.$main['nama_desa'] ?><br/> Kami mohon maaf untuk sementara halaman tidak dapat di akses, dikarenakan sedang adanya perbaikan oleh tim terkait. </p> <p> Jika ada keperluan yang mendesak silakan langsung datang ke Kantor <?= ucwords($this->setting->sebutan_desa)?>.<br> Alamat : <?= $main['alamat_kantor'] ?><br> Email : <?= $main['email_desa'] ?><br> Telepon : <?= $main['telepon'] ?> </p> <p> <?= ucwords($pamong_kades['jabatan']).' '.$main['nama_desa'] ?> <br> <br> <br> <u><b><?= $main['nama_kepala_desa'] ?></b></u><br> NIP. <?= $main['nip_kepala_desa'] ?> </p> </div> </body> </html>
siteman_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
siteman_mandiri_css:/* * File ini berisi CSS ubahan desa untuk tampilan siteman * Letakkan file ini di: desa/css/siteman.css */ /* Sebagai contoh: * - Perubahan css di bawah memungkinkan penggunaan gambar untuk latar belakang halaman siteman. * Gambar yang digunakan harus ditempatkan di desa/css/images/latar_login.jpg * */ /* * Ubah latar login/siteman pd halaman admin Pengaturan > Aplikasi, upload dan ganti latar login sesuia yg diinginkan. * */ body.login{ background-size: cover; -webkit-background-size: cover; -moz-background-size: cover; -o-background-size: cover; } /* Contoh mengubah warna latar belakang deretan tombol menu utama */ div.contentm{ background-color: #f4f4da; /* misalnya coba ganti menjadi #c8f1c8 */ }
folders:Array ( [storage.framework] => Array ( [name] => storage/framework [check] => Closure Object ( ) ) [storage.logs] => Array ( [name] => storage/logs [check] => Closure Object ( ) ) [backup_inkremental] => Array ( [name] => backup_inkremental/ [check] => Closure Object ( ) ) )
server:Array ( [php] => Array ( [name] => PHP Version [version] => >= 7.4.0 | < 8.0.0 [check] => Closure Object ( ) ) [pdo] => Array ( [name] => PDO [check] => Closure Object ( ) ) [curl] => Array ( [name] => Curl extention [check] => Closure Object ( ) ) [fileinfo] => Array ( [name] => Fileinfo extension [check] => Closure Object ( ) ) [gd] => Array ( [name] => GD extension [check] => Closure Object ( ) ) [iconv] => Array ( [name] => Iconv extension [check] => Closure Object ( ) ) [json] => Array ( [name] => Json extension [check] => Closure Object ( ) ) [mbstring] => Array ( [name] => Mbstring extension [check] => Closure Object ( ) ) [mysqli] => Array ( [name] => Mysqli extension [check] => Closure Object ( ) ) [mysqlnd] => Array ( [name] => Mysqlnd extension [check] => Closure Object ( ) ) [tidy] => Array ( [name] => Tidy extension [check] => Closure Object ( ) ) [zip] => Array ( [name] => Zip extension [check] => Closure Object ( ) ) [exif] => Array ( [name] => Exif extension [check] => Closure Object ( ) ) )
security/headers:Array ( [Strict-Transport-Security] => max-age=31536000; includeSubDomains [X-Content-Type-Options] => nosniff [X-Permitted-Cross-Domain-Policies] => none [Permissions-Policy] => accelerometer=(),ambient-light-sensor=(),autoplay=(),battery=(),camera=(),display-capture=(),document-domain=(),encrypted-media=(),fullscreen=(),gamepad=(),geolocation=(),gyroscope=(),layout-animations=(self),legacy-image-formats=(self),magnetometer=(),microphone=(),midi=(),oversized-images=(self),payment=(),picture-in-picture=(),publickey-credentials-get=(),speaker-selection=(),sync-xhr=(self),unoptimized-images=(self),unsized-media=(self),usb=(),screen-wake-lock=(),web-share=(),xr-spatial-tracking=() [Cross-Origin-Embedder-Policy] => same-origin [Cross-Origin-Resource-Policy] => same-origin [Cross-Origin-Opener-Policy] => same-origin )
Session __ci_last_regenerate:1743455389
artikel:Array ( )
pengunjungOnline:2025-04-01
balik_ke:first
Models (45)seeder
setting_model
anjungan_model
database_model
theme_model
web_menu_model
first_artikel_m
web_sosmed_model
shortcode_model
keuangan_grafik_model
keuangan_model
keuangan_grafik_manual_model
keuangan_manual_model
laporan_penduduk_model
program_bantuan_model
penduduk_model
keluarga_model
web_dokumen_model
referensi_model
penduduk_log_model
rtm_model
kelompok_model
wilayah_model
pamong_model
first_penduduk_m
surat_model
penomoran_surat_model
url_shortener_model
track_model
keluar_model
plan_lokasi_model
plan_area_model
plan_garis_model
analisis_import_model
analisis_indikator_model
analisis_master_model
analisis_periode_model
analisis_respon_model
statistik_penduduk_model
statistik_pengunjung_model
first_menu_m
teks_berjalan_model
web_widget_model
first_gallery_m
pengaduan_model
