| 0.0067 |
SHOW TABLES FROM `desa-lasori-butontengah`
|
| 0.0010 |
SELECT *
FROM `setting_aplikasi`
ORDER BY `key`
|
| 0.0030 |
SHOW DATABASES
|
| 0.0014 |
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'desa-lasori-butontengah' AND table_name = 'user'
|
| 0.0004 |
SELECT *
FROM `migrasi`
WHERE `versi_database` = '2021090101'
|
| 0.0003 |
SELECT *
FROM `migrasi`
WHERE `versi_database` = '2021090101'
|
| 0.0007 |
SELECT *
FROM `menu`
WHERE `link` = 'wilayah'
AND `enabled` = 1
|
| 0.0005 |
SELECT `id`, `dusun`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` = '0'
AND `rw` = '0'
ORDER BY `urut`
|
| 0.0057 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 1
WHERE `id` = '32'
|
| 0.0004 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` = '0'
AND `rw` <> '0'
AND `dusun` = 'Lamena'
ORDER BY `urut`
|
| 0.0068 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 2
WHERE `id` = '33'
|
| 0.0004 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` <> '0'
AND `rw` = '-'
AND `dusun` = 'Lamena'
ORDER BY `urut`
|
| 0.0050 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 3
WHERE `id` = '34'
|
| 0.0054 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 4
WHERE `id` = '38'
|
| 0.0005 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` = '0'
AND `rw` <> '0'
AND `dusun` = 'Kakaha'
ORDER BY `urut`
|
| 0.0043 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 5
WHERE `id` = '39'
|
| 0.0018 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` <> '0'
AND `rw` = '-'
AND `dusun` = 'Kakaha'
ORDER BY `urut`
|
| 0.0059 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 6
WHERE `id` = '40'
|
| 0.0056 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 7
WHERE `id` = '35'
|
| 0.0008 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` = '0'
AND `rw` <> '0'
AND `dusun` = 'Labelenga'
ORDER BY `urut`
|
| 0.0060 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 8
WHERE `id` = '36'
|
| 0.0005 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` <> '0'
AND `rw` = '-'
AND `dusun` = 'Labelenga'
ORDER BY `urut`
|
| 0.0065 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 9
WHERE `id` = '37'
|
| 0.0052 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 10
WHERE `id` = '41'
|
| 0.0009 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` = '0'
AND `rw` <> '0'
AND `dusun` = 'Mantunga'
ORDER BY `urut`
|
| 0.0046 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 11
WHERE `id` = '42'
|
| 0.0026 |
SELECT `id`, `dusun`, `rw`, `urut`
FROM `tweb_wil_clusterdesa`
WHERE `rt` <> '0'
AND `rw` = '-'
AND `dusun` = 'Mantunga'
ORDER BY `urut`
|
| 0.0052 |
UPDATE `tweb_wil_clusterdesa` SET `urut_cetak` = 12
WHERE `id` = '43'
|
| 0.0274 |
SELECT (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(id) FROM tweb_wil_clusterdesa WHERE dusun = w.dusun AND rw <> '-' AND rt = '-')
END) AS jumlah_rw, (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(id) FROM tweb_wil_clusterdesa WHERE dusun = w.dusun AND rt <> '0' AND rt <> '-')
WHEN w.rw <> '0' and w.rw <> '-' and w.rt = '0' THEN (SELECT COUNT(id) FROM tweb_wil_clusterdesa WHERE dusun = w.dusun AND rw = w.rw AND rt <> '0' AND rt <> '-')
END) AS jumlah_rt, (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun))
WHEN w.rw <> '0' and w.rw <> '-' and w.rt = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun and rw = w.rw))
WHEN w.rt <> '0' and w.rt <> '-' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster = w.id)
END) AS jumlah_warga, (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun) AND p.sex = 1)
WHEN w.rw <> '0' and w.rw <> '-' and w.rt = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun and rw = w.rw) AND p.sex = 1)
WHEN w.rt <> '0' and w.rt <> '-' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster = w.id and p.sex = 1)
END) AS jumlah_warga_l, (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun) AND p.sex = 2)
WHEN w.rw <> '0' and w.rw <> '-' and w.rt = '0' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun and rw = w.rw) AND p.sex = 2)
WHEN w.rt <> '0' and w.rt <> '-' THEN (SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster = w.id and p.sex = 2)
END) AS jumlah_warga_p, (CASE
WHEN w.rt = '0' and w.rw = '0' THEN (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala = p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun) AND p.kk_level = 1)
WHEN w.rw <> '0' and w.rw <> '-' and w.rt = '0' THEN (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala = p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa WHERE dusun = w.dusun and rw = w.rw) AND p.kk_level = 1)
WHEN w.rt <> '0' and w.rt <> '-' THEN (SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala = p.id WHERE p.id_cluster = w.id AND p.kk_level = 1)
END) AS jumlah_kk, `w`.*, `p`.`nama` AS `nama_kepala`, `p`.`nik` AS `nik_kepala`, (CASE WHEN w.rw = '0' THEN '' ELSE w.rw END) AS rw, (CASE WHEN w.rt = '0' THEN '' ELSE w.rt END) AS rt
FROM `tweb_wil_clusterdesa` `w`
LEFT JOIN `penduduk_hidup` `p` ON `w`.`id_kepala` = `p`.`id`
WHERE (
`w`.`rt` = '0' and `w`.`rw` = '0'
OR `w`.`rw` <> '-' and `w`.`rt` = '0'
OR `w`.`rt` <> '0' and `w`.`rt` <> '-'
)
ORDER BY `w`.`urut_cetak`, `w`.`dusun`, `rw`, `rt`
|
| 0.0078 |
SELECT
(SELECT COUNT(rw.id) FROM tweb_wil_clusterdesa rw WHERE rw <> '-' AND rt = '-') AS total_rw,
(SELECT COUNT(v.id) FROM tweb_wil_clusterdesa v WHERE v.rt <> '0' AND v.rt <> '-') AS total_rt,
(SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa)) AS total_warga,
(SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.sex = 1) AS total_warga_l,
(SELECT COUNT(p.id) FROM penduduk_hidup p WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.sex = 2) AS total_warga_p,
(SELECT COUNT(p.id) FROM keluarga_aktif k inner join penduduk_hidup p ON k.nik_kepala=p.id WHERE p.id_cluster IN(SELECT id FROM tweb_wil_clusterdesa) AND p.kk_level = 1) AS total_kk
FROM tweb_wil_clusterdesa u
LEFT JOIN penduduk_hidup a ON u.id_kepala = a.id WHERE u.rt = '0' AND u.rw = '0' limit 1
|
| 0.0005 |
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.0003 |
SELECT *
FROM `menu`
WHERE `parrent` = '16'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
|
| 0.0007 |
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.0004 |
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.0004 |
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.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` = '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.0004 |
SELECT *
FROM `menu`
WHERE `parrent` = '121'
AND `enabled` = 1
AND `tipe` = 3
ORDER BY `urut`
|
| 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` = '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 *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
|
| 0.0003 |
SELECT *
FROM `kategori`
WHERE `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
|
| 0.0003 |
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.0009 |
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.74'
AND `status` = 1
|
| 0.0003 |
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.0004 |
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.0004 |
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.0005 |
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.0003 |
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.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`.`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.0032 |
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.0021 |
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.0005 |
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
|
| 0.0005 |
SELECT `setting`
FROM `widget`
WHERE `isi` = 'aparatur_desa.php'
|
| 0.0005 |
SELECT Tanggal,ipAddress FROM sys_traffic WHERE Tanggal='2026-04-10'
|
| 0.0053 |
UPDATE sys_traffic SET Jumlah=Jumlah + 1,ipAddress='' WHERE Tanggal='2026-04-10'
|
| 0.0003 |
SELECT Jumlah AS Visitor FROM sys_traffic WHERE Tanggal="2026-04-10" LIMIT 1
|
| 0.0005 |
SELECT Jumlah AS Visitor FROM sys_traffic WHERE
Tanggal=(SELECT DATE_ADD(CURDATE(),INTERVAL -1 DAY) FROM sys_traffic LIMIT 1)
LIMIT 1
|
| 0.0004 |
SELECT SUM(Jumlah) as Total FROM sys_traffic
|
