| 0.0119 |
SHOW TABLES FROM `desa-lasori-butontengah`
|
| 0.0012 |
SELECT * FROM `setting_aplikasi` ORDER BY `key`
|
| 0.0026 |
SHOW DATABASES
|
| 0.0012 |
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'desa-lasori-butontengah' AND table_name = 'user'
|
| 0.0007 |
SELECT * FROM `migrasi` WHERE `versi_database` = '2021090101'
|
| 0.0002 |
SELECT * FROM `migrasi` WHERE `versi_database` = '2021090101'
|
| 0.0007 |
SELECT * FROM `menu` WHERE `link` = 'peta' AND `enabled` = 1
|
| 0.0004 |
SELECT * FROM `tweb_wil_clusterdesa` WHERE `rt` = '0' AND `rw` = '0' ORDER BY `urut` ASC
|
| 0.0003 |
SELECT * FROM `tweb_wil_clusterdesa` WHERE `zoom` > '0'
|
| 0.0004 |
SELECT * FROM `config` LIMIT 1
|
| 0.0003 |
SELECT * FROM `tweb_wil_clusterdesa` WHERE `rt` = '0' AND `rw` <> '0' ORDER BY `urut` ASC
|
| 0.0003 |
SELECT * FROM `tweb_wil_clusterdesa` WHERE `rt` <> '0' ORDER BY `urut` ASC
|
| 0.0014 |
SELECT `u`.*, COUNT(k.id) as jumlah, COUNT(CASE WHEN k.status_covid = u.nama AND p.sex = 1 THEN k.id_terdata END) AS laki, COUNT(CASE WHEN k.status_covid = u.nama AND p.sex = 2 THEN k.id_terdata END) AS perempuan FROM `ref_status_covid` `u` LEFT JOIN `covid19_pemudik` `k` ON `k`.`status_covid` = `u`.`nama` LEFT JOIN `tweb_penduduk` `p` ON `p`.`id`=`k`.`id_terdata` GROUP BY `u`.`id`
|
| 0.0020 |
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.0021 |
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol` FROM `lokasi` `l` LEFT JOIN `point` `p` ON `l`.`ref_point` = `p`.`id` LEFT JOIN `point` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1
|
| 0.0022 |
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol`, `p`.`color` AS `color` FROM `garis` `l` LEFT JOIN `line` `p` ON `l`.`ref_line` = `p`.`id` JOIN `line` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1
|
| 0.0010 |
SELECT `l`.*, `p`.`nama` AS `kategori`, `m`.`nama` AS `jenis`, `p`.`simbol` AS `simbol`, `p`.`color` AS `color` FROM `area` `l` LEFT JOIN `polygon` `p` ON `l`.`ref_polygon` = `p`.`id` LEFT JOIN `polygon` `m` ON `p`.`parrent` = `m`.`id` WHERE `l`.`enabled` = 1 AND `p`.`enabled` = 1 AND `m`.`enabled` = 1
|
| 0.0006 |
SELECT `p`.*, (CASE WHEN p.id_lokasi IS NOT NULL THEN CONCAT("RT ", w.rt, " / RW ", w.rw, " - ", w.dusun) ELSE p.lokasi END) AS alamat FROM `pembangunan` `p` LEFT JOIN `tweb_wil_clusterdesa` `w` ON `p`.`id_lokasi` = `w`.`id` WHERE `p`.`status` = 1
|
| 0.0003 |
SELECT * FROM `config` LIMIT 1
|
| 0.0003 |
SELECT m.* FROM menu m WHERE m.parrent = 1 AND m.enabled = 1 AND m.tipe = 1 order by urut asc
|
| 0.0012 |
SELECT * FROM `menu` WHERE `parrent` = '16' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0009 |
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` = '103' OR `a`.`id` = '103' )
|
| 0.0006 |
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` = '102' OR `a`.`id` = '102' )
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '121' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0005 |
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` = '101' OR `a`.`id` = '101' )
|
| 0.0005 |
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.0003 |
SELECT * FROM `menu` WHERE `parrent` = '24' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '115' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '116' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0003 |
SELECT m.* FROM menu m WHERE m.parrent = 1 AND m.enabled = 1 AND m.tipe = 1 order by urut asc
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '16' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0005 |
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` = '103' OR `a`.`id` = '103' )
|
| 0.0005 |
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` = '102' OR `a`.`id` = '102' )
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '121' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0005 |
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` = '101' OR `a`.`id` = '101' )
|
| 0.0006 |
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.0003 |
SELECT * FROM `menu` WHERE `parrent` = '24' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '115' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0003 |
SELECT * FROM `menu` WHERE `parrent` = '116' AND `enabled` = 1 AND `tipe` = 3 ORDER BY `urut`
|
| 0.0002 |
SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = 0 ORDER BY `urut`
|
| 0.0002 |
SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '1' ORDER BY `urut`
|
| 0.0002 |
SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '4' ORDER BY `urut`
|
| 0.0002 |
SELECT * FROM `kategori` WHERE `enabled` = 1 AND `parrent` = '5' ORDER BY `urut`
|
| 0.0003 |
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.0005 |
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.0010 |
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.0002 |
SELECT `id` FROM `gambar_gallery` WHERE `slider` = 1 LIMIT 1
|
| 0.0003 |
SELECT `id`, `nama` as `judul`, `gambar` FROM `gambar_gallery` WHERE `parrent` = '36' AND `tipe` = 2 AND `enabled` = 1
|
| 0.0003 |
SELECT * FROM `widget` WHERE `enabled` = 1 ORDER BY `urut`
|
| 0.0002 |
SELECT * FROM `anjungan` WHERE `ip_address` = '104.23.243.121' AND `status` = 1
|
| 0.0004 |
SELECT * FROM gambar_gallery WHERE enabled = '1' and parrent = 0 order by rand() limit 4
|
| 0.0003 |
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.0003 |
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.0003 |
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.0004 |
SELECT a.*, b.*, YEAR(b.tgl_upload) AS thn, MONTH(b.tgl_upload) AS bln, DAY(b.tgl_upload) AS hri, b.slug as slug FROM komentar a INNER JOIN artikel b ON a.id_artikel = b.id WHERE a.status = 1 AND a.id_artikel <> 775 ORDER BY a.tgl_upload DESC LIMIT 10
|
| 0.0002 |
SELECT * FROM `media_sosial` WHERE `enabled` = 1
|
| 0.0005 |
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.0011 |
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.0008 |
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.0004 |
SELECT dp.jabatan, dp.pamong_niap, dp.foto, 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.0030 |
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.0019 |
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 |
SELECT `setting` FROM `widget` WHERE `isi` = 'sinergi_program.php'
|
| 0.0002 |
SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC
|
| 0.0002 |
SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC
|
| 0.0002 |
SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC
|
| 0.0003 |
SELECT * FROM `config` LIMIT 1
|
| 0.0002 |
SELECT `tahun_anggaran` FROM `keuangan_master` ORDER BY `tahun_anggaran` DESC
|