SHOW TABLES FROM `c1_db_lbGunuang`
0.0015 sec
SELECT *
FROM `setting_aplikasi`
ORDER BY `key`
0.0002 sec
SHOW DATABASES
0.0006 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'c1_db_lbGunuang' AND table_name = 'user'
0.0004 sec
SELECT *
FROM `migrasi`
WHERE `versi_database` = '2021120101'
0.0001 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.0002 sec
SELECT * FROM log_bulanan WHERE month(tgl) = 10 AND year(tgl) = 2024
0.0001 sec
UPDATE `log_bulanan` SET `pend` = '5810', `wni_lk` = '2874', `wni_pr` = '2936', `wna_lk` = '0', `wna_pr` = '0', `kk` = '1820', `kk_lk` = '1434', `kk_pr` = '386'
WHERE month(tgl) = 10 AND year(tgl) = 2024
0.0018 sec
SELECT *
FROM `anjungan`
WHERE `ip_address` = '52.14.190.74'
AND `status` = 1
0.0005 sec
SELECT *
FROM `menu`
WHERE `link` = 'informasi_publik'
AND `enabled` = 1
0.0005 sec
SELECT *
FROM `ref_dokumen`
WHERE `id` NOT IN (1)
ORDER BY `id`
0.0160 sec
SELECT `tahun`
FROM `dokumen_hidup`
GROUP BY `tahun`
0.0014 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2024-10-18'
0.0005 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"52.14.190.74\",\"18.226.186.172\",\"198.235.24.236\",\"125.165.106.165\",\"66.249.68.34\"]}', `Jumlah` = 5
WHERE `Tanggal` = '2024-10-18'
0.0022 sec
SELECT *
FROM `sys_traffic`
WHERE `Tanggal` = '2024-10-18'
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2024-10-17'
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
0.0014 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 m.* FROM menu m WHERE m.parrent = 1 AND m.enabled = 1 AND m.tipe = 1 order by urut asc
0.0002 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '32'
OR `a`.`id` = '32'
)
0.0007 sec
SELECT *
FROM `menu`
WHERE `parrent` = '16'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0003 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '33'
OR `a`.`id` = '33'
)
0.0008 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '99'
OR `a`.`id` = '99'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '85'
OR `a`.`id` = '85'
)
0.0008 sec
SELECT *
FROM `menu`
WHERE `parrent` = '17'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0002 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '93'
OR `a`.`id` = '93'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '92'
OR `a`.`id` = '92'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '97'
OR `a`.`id` = '97'
)
0.0009 sec
SELECT *
FROM `menu`
WHERE `parrent` = '24'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '115'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `menu`
WHERE `parrent` = '116'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
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.0002 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '32'
OR `a`.`id` = '32'
)
0.0008 sec
SELECT *
FROM `menu`
WHERE `parrent` = '16'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0002 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '33'
OR `a`.`id` = '33'
)
0.0008 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '99'
OR `a`.`id` = '99'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '85'
OR `a`.`id` = '85'
)
0.0009 sec
SELECT *
FROM `menu`
WHERE `parrent` = '17'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0003 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '93'
OR `a`.`id` = '93'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '92'
OR `a`.`id` = '92'
)
0.0009 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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = '97'
OR `a`.`id` = '97'
)
0.0008 sec
SELECT *
FROM `menu`
WHERE `parrent` = '24'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '115'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0003 sec
SELECT *
FROM `menu`
WHERE `parrent` = '116'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '5'
ORDER BY `urut`
0.0001 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.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`.`enabled` = 1
AND `a`.`tgl_upload` < NOW()
AND (
`a`.`slug` = ''
OR `a`.`id` = ''
)
0.0008 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.0011 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.0007 sec
SELECT *
FROM `widget`
WHERE `enabled` = 1
ORDER BY `urut`
0.0002 sec
SELECT *
FROM `anjungan`
WHERE `ip_address` = '52.14.190.74'
AND `status` = 1
0.0002 sec
SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4
0.0005 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.0006 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.0007 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.0006 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.0009 sec
SELECT *
FROM `media_sosial`
WHERE `enabled` = 1
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`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < NOW()
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0007 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.0009 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.0022 sec
SELECT dp.jabatan, dp.pamong_niap, dp.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.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`
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0002 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.0001 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.0001 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
ORDER BY `tahun_anggaran` DESC
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 `setting`
FROM `widget`
WHERE `isi` = 'aparatur_desa.php'
0.0002 sec
Visi dan Misi
Wilayah Nagari Labuah Gunuang
0.3326 sec
2.52MB
Request : first/informasi_publik
Database
N/A
Libraries (17)
Helpers (12)
Views (11) 
Configuration 
Session 
Models (58)