Desa

SHOW TABLES FROM `d293desaremb_sumurpule` 0.0007 sec

SELECT * FROM `setting_aplikasi` ORDER BY `key` 0.0209 sec

SHOW DATABASES 0.0010 sec

SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'd293desaremb_sumurpule' AND table_name = 'user' 0.0002 sec

SELECT * FROM `migrasi` WHERE `versi_database` = '2022020101' 0.0003 sec

SELECT (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1) AS pend, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =1 AND warganegara_id <> 2) AS wni_lk, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =2 AND warganegara_id <> 2) AS wni_pr, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =1 AND warganegara_id = 2) AS wna_lk, (SELECT COUNT(id) FROM tweb_penduduk WHERE status_dasar =1 AND sex =2 AND warganegara_id = 2) AS wna_pr, (SELECT COUNT(p.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.status_dasar = 1 AND k.nik_kepala IS NOT NULL AND k.nik_kepala <> 0) AS kk, (SELECT COUNT(k.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.sex = 1 AND p.status_dasar = 1) AS kk_lk, (SELECT COUNT(k.id) FROM tweb_keluarga k LEFT JOIN tweb_penduduk p ON k.nik_kepala = p.id WHERE p.sex = 2 AND p.status_dasar = 1) AS kk_pr 0.0146 sec

SELECT * FROM log_bulanan WHERE month(tgl) = 05 AND year(tgl) = 2024 0.0029 sec

UPDATE `log_bulanan` SET `pend` = '0', `wni_lk` = '0', `wni_pr` = '0', `wna_lk` = '0', `wna_pr` = '0', `kk` = '0', `kk_lk` = '0', `kk_pr` = '0' WHERE month(tgl) = 05 AND year(tgl) = 2024 0.0001 sec

SELECT * FROM `anjungan` WHERE `ip_address` = '192.168.36.253' AND `status` = 1 0.0001 sec

SELECT COUNT(a.id) AS id FROM artikel a LEFT JOIN user u ON a.id_user = u.id LEFT JOIN kategori k ON a.id_kategori = k.id WHERE a.enabled=1 AND a.tgl_upload < NOW() 0.0035 sec

SELECT a.*,u.nama AS owner,k.kategori, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM artikel a LEFT JOIN user u ON a.id_user = u.id LEFT JOIN kategori k ON a.id_kategori = k.id WHERE a.enabled=1 AND a.tgl_upload < NOW() ORDER BY a.tgl_upload DESC LIMIT 0,20 0.0002 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2024-05-19' 0.0272 sec

UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"192.168.36.253\",\"192.168.36.253\"]}', `Jumlah` = 2 WHERE `Tanggal` = '2024-05-19' 0.0067 sec

SELECT * FROM `sys_traffic` WHERE `Tanggal` = '2024-05-19' 0.0001 sec

SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` WHERE `Tanggal` = '2024-05-18' 0.0001 sec

SELECT SUM(`Jumlah`) AS `Jumlah` FROM `sys_traffic` 0.0001 sec

SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa FROM `config` `c` LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id` LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id` 0.0002 sec

SELECT m.* FROM menu m WHERE m.parrent = 1 AND m.enabled = 1 AND m.tipe = 1 order by urut asc 0.0064 sec

SELECT m.* FROM menu m WHERE m.parrent = 1 AND m.enabled = 1 AND m.tipe = 1 order by urut asc 0.0001 sec

SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = 0 ORDER BY `urut` 0.0210 sec

SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload` FROM `teks_berjalan` `t` LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id` WHERE `status` = 1 ORDER BY `urut` 0.0001 sec

SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar` != '' AND `tgl_upload` < NOW() UNION SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar1` != '' AND `tgl_upload` < NOW() UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar2` != '' AND `tgl_upload` < NOW()) UNION (SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `headline` = 3 AND `gambar3` != '' AND `tgl_upload` < NOW())ORDER BY RAND() LIMIT 10 0.0007 sec

SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri FROM `artikel` WHERE `enabled` = 1 AND `gambar` != '' AND `tgl_upload` < NOW() ORDER BY `tgl_upload` DESC LIMIT 10 0.0001 sec

SELECT * FROM `widget` WHERE `enabled` = 1 ORDER BY `urut` 0.0043 sec

SELECT * FROM `anjungan` WHERE `ip_address` = '192.168.36.253' AND `status` = 1 0.0001 sec

SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4 0.0057 sec

SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) = CURDATE() 0.0064 sec

SELECT `a`.*, `g`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `agenda` `g` LEFT JOIN `artikel` `a` ON `a`.`id` = `g`.`id_artikel` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) > CURDATE() ORDER BY `g`.`tgl_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 `a`.`enabled` = 1 AND `a`.`id_kategori` = '1000' AND DATE(g.tgl_agenda) < CURDATE() 0.0001 sec

SELECT YEAR(a.tgl_upload) AS thn, MONTH(a.tgl_upload) AS bln, DAY(a.tgl_upload) AS hri, `a`.`slug` as `slug`, `k`.* FROM `komentar` `k` JOIN `artikel` `a` ON `k`.`id_artikel` = `a`.`id` WHERE `k`.`status` = 1 AND `k`.`id_artikel` <> 775 ORDER BY `k`.`tgl_upload` DESC LIMIT 10 0.0031 sec

SELECT * FROM `media_sosial` WHERE `enabled` = 1 0.0014 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < NOW() ORDER BY `a`.`tgl_upload` DESC LIMIT 7 0.0001 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < NOW() ORDER BY `a`.`hit` DESC LIMIT 7 0.0001 sec

SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri FROM `artikel` `a` WHERE `a`.`enabled` = 1 AND `a`.`id_kategori` NOT IN (1000) AND `a`.`tgl_upload` < NOW() ORDER BY rand() LIMIT 7 0.0003 sec

SELECT dp.jabatan, dp.pamong_niap, 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` WHERE `dp`.`pamong_status` = '1' ORDER BY `dp`.`urut` 0.0039 sec

SELECT `u`.*, COUNT(p.id) AS jumlah, COUNT(CASE WHEN p.sex = 1 THEN p.id END) AS laki, COUNT(CASE WHEN p.sex = 2 THEN p.id END) AS perempuan FROM `tweb_penduduk_sex` `u` LEFT JOIN `penduduk_hidup` `p` ON `u`.`id` = `p`.`sex` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id` GROUP BY `u`.`id` 0.0066 sec

SELECT COUNT(b.id) AS jumlah, COUNT(CASE WHEN b.sex = 1 THEN b.id END) AS laki, COUNT(CASE WHEN b.sex = 2 THEN b.id END) AS perempuan FROM `penduduk_hidup` `b` LEFT JOIN `tweb_wil_clusterdesa` `a` ON `b`.`id_cluster` = `a`.`id` 0.0003 sec

SELECT `setting` FROM `widget` WHERE `isi` = 'sinergi_program.php' 0.0001 sec

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0001 sec

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0000 sec

SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC 0.0000 sec

SELECT `c`.*, `u`.`pamong_nip` AS `nip_kepala_desa`, (case when p.nama is not null then p.nama else u.pamong_nama end) AS nama_kepala_desa FROM `config` `c` LEFT JOIN `tweb_desa_pamong` `u` ON `c`.`pamong_id` = `u`.`pamong_id` LEFT JOIN `tweb_penduduk` `p` ON `u`.`id_pend` = `p`.`id` 0.0001 sec

SELECT `setting` FROM `widget` WHERE `isi` = 'aparatur_desa.php' 0.0001 sec