SHOW TABLES FROM `kh13puding_sid`
0.0004 sec
SHOW DATABASES
0.0006 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'kh13puding_sid' AND table_name = 'user'
0.0001 sec
SHOW COLUMNS FROM `anjungan`
0.0005 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '3.144.29.148'
OR `id_pengunjung` IS NULL
AND (
`config_id` = 1
)
)
AND `status` = 1
ORDER BY `tipe` ASC
0.0001 sec
SELECT `status_rekam`, LOWER(nama) as nama
FROM `tweb_status_ktp`
0.0002 sec
SHOW COLUMNS FROM `analisis_master`
0.0005 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.0010 sec
SELECT *
FROM `analisis_periode`
WHERE `aktif` = 1
AND `id_master` IS NULL
0.0001 sec
SHOW COLUMNS FROM `analisis_master`
0.0037 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 `id`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `slug` = 'penggalian-dan-penyerapan-aspirasi-masyarakat'
OR `id` = 'penggalian-dan-penyerapan-aspirasi-masyarakat'
0.0002 sec
UPDATE `artikel` SET hit = hit + 1
WHERE (
`config_id` = 1
)
AND `id` = '2'
0.0042 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`.`slug` = 'penggalian-dan-penyerapan-aspirasi-masyarakat'
AND (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2025-04-01 03:41:18'
AND YEAR(a.tgl_upload) = '2022'
AND MONTH(a.tgl_upload) = '6'
AND DAY(a.tgl_upload) = '15'
0.0010 sec
SELECT *
FROM `agenda`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '2'
0.0016 sec
SELECT *
FROM `komentar`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '2'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0005 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-04-01'
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0002 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"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` = 24
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-04-01'
0.0056 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-04-01'
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2025-03-31'
AND (
`config_id` = 1
)
0.0001 sec
SHOW COLUMNS FROM `sys_traffic`
0.0002 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0004 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '16'
AND `enabled` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `menu`
0.0002 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '17'
AND `enabled` = 1
ORDER BY `urut`
0.0001 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` = '93'
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0002 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.0003 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.0003 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.0002 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.0030 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `kategori`
0.0002 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.0003 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `kategori`
0.0005 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.0025 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0002 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload`
FROM `teks_berjalan` `t`
LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id`
WHERE (
`t`.`config_id` = 1
)
AND `tipe` = 1
AND `status` = 1
ORDER BY `urut`
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0003 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 03:41:18'
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 03:41:18'
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 03:41:18')
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 03:41:18')ORDER BY RAND() LIMIT 10
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0021 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 03:41:18'
AND (`headline` = 2 or `headline` = 3)
ORDER BY `tgl_upload` DESC
LIMIT 10
0.0001 sec
SHOW COLUMNS FROM `widget`
0.0047 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `config`
0.0017 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0035 sec
SELECT *
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY rand()
LIMIT 4
0.0002 sec
SHOW COLUMNS FROM `agenda`
0.0002 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 `agenda`
0.0002 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.0001 sec
SHOW COLUMNS FROM `agenda`
0.0002 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.0003 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.0001 sec
SHOW COLUMNS FROM `media_sosial`
0.0006 sec
SELECT *
FROM `media_sosial`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0033 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 03:41:18'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0002 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 03:41:18'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0001 sec
SHOW COLUMNS FROM `artikel`
0.0002 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 03:41:18'
ORDER BY rand()
LIMIT 7
0.0003 sec
SHOW COLUMNS FROM `tweb_desa_pamong`
0.0020 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as foto, CASE WHEN p.sex IS NOT NULL THEN p.sex ELSE dp.pamong_sex END as id_sex, CASE WHEN dp.id_pend IS NULL THEN dp.pamong_nama ELSE p.nama END AS nama
FROM `tweb_desa_pamong` `dp`
LEFT JOIN `tweb_penduduk` `p` ON `p`.`id` = `dp`.`id_pend`
LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id`
WHERE (
`dp`.`config_id` = 1
)
AND `dp`.`pamong_status` = '1'
ORDER BY `dp`.`urut`
0.0002 sec
SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan
FROM `tweb_penduduk_sex` `u`
LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` AND `p`.`config_id` = 1
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0008 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.0004 sec
SHOW COLUMNS FROM `widget`
0.0002 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0001 sec
SHOW COLUMNS FROM `keuangan_master`
0.0004 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
WHERE (
`config_id` = 1
)
ORDER BY `tahun_anggaran` DESC
0.0001 sec
SHOW COLUMNS FROM `keuangan_master`
0.0006 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.0006 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.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci`
0.0028 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.0027 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 `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.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.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.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.0011 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.0003 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.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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci`
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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0002 sec
SHOW COLUMNS FROM `keuangan_master`
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` = '2022'
AND (
`keuangan_master`.`config_id` = 1
)
ORDER BY `Kd_Bid` ASC
0.0002 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci`
0.0003 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(AnggaranStlhPAK) AS pagu
FROM `keuangan_ta_rab_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0003 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_rinci`.`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0004 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`.`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.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` = '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 `keuangan_master`
0.0005 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.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.0020 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.0030 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.0002 sec
SHOW COLUMNS FROM `keuangan_ta_tbp_rinci`
0.0031 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.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 `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.0003 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.0005 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.0004 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.0002 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.0005 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.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.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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0001 sec
SHOW COLUMNS FROM `keuangan_master`
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` = '2022'
AND (
`keuangan_master`.`config_id` = 1
)
ORDER BY `Kd_Bid` ASC
0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_rab_rinci`
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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0003 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci`
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` = '2022'
AND (
`keuangan_ta_spp_rinci`.`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0004 sec
SHOW COLUMNS FROM `keuangan_ta_spp_rinci`
0.0007 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.0005 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.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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0001 sec
SHOW COLUMNS FROM `keuangan_ta_jurnal_umum_rinci`
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` = '2022'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0001 sec
SELECT * FROM pengunjung WHERE ip='3.144.29.148' AND tanggal='2025-04-01'
0.0020 sec
INSERT INTO pengunjung (ip, tanggal, hits, online) VALUES('3.144.29.148','2025-04-01','1','1743453678')
0.0045 sec
SELECT * FROM pengunjung WHERE online > '1743453078'
0.0018 sec
select * from `config` limit 1
0.7500 sec
select count(*) as aggregate from `config`
0.0700 sec
select count(*) as aggregate from `config`
0.0600 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.1000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'setting_aplikasi'
0.3200 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
0.3300 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan'
0.3200 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.0900 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'ref_jabatan'
0.3000 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.1200 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'
0.3300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan'
0.2100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'anjungan'
0.1900 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' 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 = 'kehadiran_jam_kerja'
0.2600 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Selasa' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja'
0.2300 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`) > '03:41' or date_add(jam_keluar, interval 10 minute) < '03:41') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.3200 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1
0.1600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 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.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.5300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2300 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.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.4200 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.3300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.3000 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'
0.2600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2700 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'
0.5400 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.3800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 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.0900 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.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.3700 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 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.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2200 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'
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'
0.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 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.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2500 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.4300 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'
0.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
2.4300 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.4500 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'
0.3400 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.4500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2600 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'
0.2500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.3300 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'
0.3800 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.3000 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.1200 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.3600 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2500 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.2300 sec
select * from `config` where `app_key` = 'base64:9tC/5N8F8AQlrRPUuY5FxGW/BSV+Tn4XfzLxcrMWxw0=' limit 1
0.0800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'config'
0.4100 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.2800 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'
3.0200 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'
0.3000 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 = 'tweb_desa_pamong'
0.4900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.2400 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.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.2100 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.3100 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` = 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.1900 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.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.1900 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.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.2100 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.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.2000 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.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
1.3400 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.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.3000 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.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.4300 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.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.1900 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.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_perangkat_desa'
0.2000 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 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.1000 sec
select * from information_schema.tables where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'kh13puding_sid' and table_name = 'kehadiran_jam_kerja'
0.5700 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.1000 sec
0.3748 sec
9.94MB
Request : first/artikel
Database
N/A
Libraries (20)
Helpers (14)
Views (33) 
Configuration 
Session 
Models (45)