---

SHOW TABLES FROM `u534618643_websgunung` 0.0006 sec

---

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

---

SHOW DATABASES 0.6893 sec

---

SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'u534618643_websgunung' AND table_name = 'user' 0.0502 sec

---

SELECT * FROM `migrasi` WHERE `versi_database` = '2022120107' 0.0018 sec

---

INSERT INTO `setting_modul` (`id`, `modul`, `url`, `aktif`, `ikon`, `urut`, `level`, `parent`, `hidden`, `ikon_kecil`) VALUES ('313', 'Layanan Pelanggan', 'pelanggan', '1', 'fa-credit-card', '5', '0', '200', '0', 'fa-credit-card') ON DUPLICATE KEY UPDATE modul = VALUES(modul), url = VALUES(url), ikon = VALUES(ikon), hidden = VALUES(hidden), urut = VALUES(urut), parent = VALUES(parent) 0.0012 sec

---

INSERT INTO `grup_akses` (`id_grup`, `id_modul`, `akses`) VALUES (2, '313', 3) 0.0002 sec

---

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('api_key_opensid', '', 'Opensid API Key untuk Pelanggan OpenDesa', '') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0002 sec

---

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_server', 'https://layanan.opendesa.id', 'Alamat Server Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0002 sec

---

INSERT INTO `setting_aplikasi` (`key`, `value`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_dev_server', '', 'Alamat Server Dev Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0001 sec

---

INSERT INTO `setting_aplikasi` (`key`, `value`, `jenis`, `keterangan`, `kategori`) VALUES ('layanan_opendesa_token', '', 'textarea', 'Token pelanggan Layanan OpenDESA', 'sistem') ON DUPLICATE KEY UPDATE keterangan = VALUES(keterangan), jenis = VALUES(jenis), kategori = VALUES(kategori) 0.0001 sec

---

DELETE FROM `setting_aplikasi` WHERE `key` = 'api_key_opensid' 0.0002 sec

---

UPDATE `setting_aplikasi` SET `kategori` = 'pelanggan' WHERE `key` IN('layanan_opendesa_server', 'layanan_opendesa_dev_server', 'layanan_opendesa_token') 0.0003 sec

---

DELETE FROM `setting_aplikasi` WHERE `key` IN('layanan_opendesa_server', 'layanan_opendesa_dev_server', 'dev_tracker') 0.0001 sec

---

INSERT INTO `setting_modul` (`id`, `modul`, `url`, `aktif`, `ikon`, `urut`, `level`, `hidden`, `ikon_kecil`, `parent`) VALUES (331, 'Pendaftaran Kerjasama', 'pendaftaran_kerjasama', 1, 'fa-list', 6, 2, 0, 'fa-list', 200) ON DUPLICATE KEY UPDATE modul = VALUES(modul), url = VALUES(url), ikon = VALUES(ikon), hidden = VALUES(hidden), urut = VALUES(urut), parent = VALUES(parent) 0.0001 sec

---

INSERT INTO `grup_akses` (`id_grup`, `id_modul`, `akses`) VALUES (2, 331, 3) 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.0011 sec

---

SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0006 sec

---

SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE `u`.`id` IS NULL 0.0002 sec

---

SELECT * FROM `analisis_periode` WHERE `aktif` = 1 AND `id_master` IS NULL 0.0001 sec

---

SELECT `u`.*, `s`.`subjek` as `subjek_nama` FROM `analisis_master` `u` LEFT JOIN `analisis_ref_subjek` `s` ON `u`.`subjek_tipe` = `s`.`id` WHERE `u`.`id` IS NULL 0.0001 sec

---

SELECT bahasa.nama as bahasa_nama, u.sex as id_sex, u.*, a.dusun, a.rw, a.rt, t.id AS id_status, t.nama AS status, o.nama AS pendidikan_sedang, m.nama as golongan_darah, h.nama as hubungan, b.nama AS pendidikan_kk, d.no_kk AS no_kk, d.alamat, u.id_cluster as id_cluster, ux.nama as nama_pengubah, ucreate.nama as nama_pendaftar, polis.nama AS asuransi, (CASE WHEN u.status_kawin IS NULL THEN '' WHEN u.status_kawin <> 2 THEN k.nama ELSE case WHEN (u.akta_perkawinan IS NULL OR u.akta_perkawinan = '') AND u.tanggalperkawinan IS NULL THEN 'KAWIN BELUM TERCATAT' ELSE 'KAWIN TERCATAT' END END) AS kawin, DATE_FORMAT(FROM_DAYS(TO_DAYS(NOW())-TO_DAYS(`tanggallahir`)), '%Y')+0 AS umur, x.nama AS sex, w.nama AS warganegara, p.nama AS pekerjaan, g.nama AS agama, c.nama as cacat, kb.nama as cara_kb, sm.nama as sakit_menahun, sd.nama as status_dasar, u.status_dasar as status_dasar_id, (select tweb_penduduk.nama AS nama from tweb_penduduk where (tweb_penduduk.id = d.nik_kepala)) AS kepala_kk, log.no_kk as log_no_kk, log.tgl_lapor as tgl_lapor, log.tgl_peristiwa as tgl_peristiwa, log.maksud_tujuan_kedatangan as maksud_tujuan_kedatangan FROM tweb_penduduk u LEFT JOIN tweb_keluarga d ON u.id_kk = d.id LEFT JOIN tweb_wil_clusterdesa a ON u.id_cluster = a.id LEFT JOIN tweb_penduduk_pendidikan o ON u.pendidikan_sedang_id = o.id LEFT JOIN tweb_penduduk_pendidikan_kk b ON u.pendidikan_kk_id = b.id LEFT JOIN tweb_penduduk_warganegara w ON u.warganegara_id = w.id LEFT JOIN tweb_penduduk_status t ON u.status = t.id LEFT JOIN tweb_penduduk_pekerjaan p ON u.pekerjaan_id = p.id LEFT JOIN tweb_penduduk_kawin k ON u.status_kawin = k.id LEFT JOIN tweb_penduduk_sex x ON u.sex = x.id LEFT JOIN tweb_penduduk_agama g ON u.agama_id = g.id LEFT JOIN tweb_golongan_darah m ON u.golongan_darah_id = m.id LEFT JOIN tweb_penduduk_hubungan h on u.kk_level = h.id LEFT JOIN tweb_cacat c ON u.cacat_id = c.id LEFT JOIN tweb_sakit_menahun sm ON u.sakit_menahun_id = sm.id LEFT JOIN tweb_cara_kb kb ON u.cara_kb_id = kb.id LEFT JOIN tweb_status_dasar sd ON u.status_dasar = sd.id LEFT JOIN log_penduduk log ON u.id = log.id_pend LEFT JOIN user ux ON u.updated_by = ux.id LEFT JOIN user ucreate ON u.created_by = ucreate.id LEFT JOIN tweb_penduduk_asuransi polis ON polis.id = u.id_asuransi LEFT JOIN ref_penduduk_bahasa bahasa ON bahasa.id = u.bahasa_id WHERE u.id='1' 0.0012 sec

---

SELECT * FROM `tweb_wil_clusterdesa` WHERE `id` IS NULL 0.0004 sec