SHOW TABLES FROM `u534618643_websgunung` 0.0006 sec

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

SHOW DATABASES 0.3009 sec

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

SELECT * FROM `migrasi` WHERE `versi_database` = '2022120107' 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.0003 sec

SELECT `status_rekam`, LOWER(nama) as nama FROM `tweb_status_ktp` 0.0172 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.0003 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.0002 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='4369' 0.0086 sec