SHOW TABLES FROM `pans5277_pandansari`
0.0017 sec
SHOW DATABASES
0.0118 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'pans5277_pandansari' AND table_name = 'user'
0.0003 sec
SHOW COLUMNS FROM `anjungan`
0.0007 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '216.73.216.99'
OR `id_pengunjung` IS NULL
AND (
`config_id` = 1
)
)
AND `status` = 1
ORDER BY `tipe` ASC
0.0004 sec
SELECT `status_rekam`, LOWER(nama) as nama
FROM `tweb_status_ktp`
0.0012 sec
SHOW COLUMNS FROM `analisis_master`
0.0010 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`.`config_id` = 1
)
AND `u`.`id` IS NULL
0.0006 sec
SELECT *
FROM `analisis_periode`
WHERE `aktif` = 1
AND `id_master` IS NULL
0.0007 sec
SHOW COLUMNS FROM `analisis_master`
0.0005 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`.`config_id` = 1
)
AND `u`.`id` IS NULL
0.0002 sec
SELECT `id`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `slug` = 'desa-pandansari-dan-desa-sempor-lor-jadi-contoh-kemen-pppa-luncurkan-drppa-kabupaten-purbalingga'
OR `id` = 'desa-pandansari-dan-desa-sempor-lor-jadi-contoh-kemen-pppa-luncurkan-drppa-kabupaten-purbalingga'
0.0010 sec
UPDATE `artikel` SET hit = hit + 1
WHERE (
`config_id` = 1
)
AND `id` = '205'
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`.`slug` = 'desa-pandansari-dan-desa-sempor-lor-jadi-contoh-kemen-pppa-luncurkan-drppa-kabupaten-purbalingga'
AND (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2025-12-30 21:45:13'
AND YEAR(a.tgl_upload) = '2022'
AND MONTH(a.tgl_upload) = '6'
AND DAY(a.tgl_upload) = '2'
0.0018 sec
SELECT *
FROM `agenda`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '205'
0.0003 sec
SELECT *
FROM `komentar`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '205'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0004 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0004 sec
SHOW COLUMNS FROM `sys_traffic`
0.0009 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-30'
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0007 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"47.128.22.15\",\"216.73.216.99\",\"216.73.216.99\",\"47.82.11.140\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"2409:8c50:a00:2242:35::\",\"101.33.55.204\",\"2001:4ba0:cafe:b2c::1\",\"43.128.67.187\",\"47.128.97.252\",\"27.44.125.50\",\"47.128.23.47\",\"43.130.34.74\",\"47.128.127.87\",\"47.128.28.191\",\"47.128.43.198\",\"43.130.111.40\",\"148.113.130.180\",\"2a03:2880:f802:34::\",\"47.128.46.231\",\"47.128.127.183\",\"240e:940:8f00:403:17::\",\"119.28.140.106\",\"43.128.149.102\",\"216.73.216.99\",\"202.76.185.62\",\"170.106.37.134\",\"43.155.27.244\",\"216.73.216.99\",\"43.135.133.194\",\"219.154.70.72\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"47.128.25.25\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"43.135.142.37\",\"47.128.43.144\",\"43.135.144.81\",\"43.154.140.188\",\"129.226.174.80\",\"47.128.50.238\",\"47.128.121.194\",\"47.128.52.160\",\"43.157.98.187\",\"216.73.216.99\",\"2409:8c20:6ed1:10b:20::\",\"47.82.11.87\",\"2001:41d0:303:7b8b::1\",\"47.128.20.122\",\"43.173.182.3\",\"47.128.109.34\",\"47.128.56.67\",\"47.128.19.147\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"43.166.1.243\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"216.73.216.99\",\"2408:8726:1a00:500:50::\",\"157.66.55.46\",\"157.66.55.46\",\"157.66.55.46\",\"138.199.39.166\",\"43.153.71.12\",\"122.51.127.156\",\"138.91.30.58\",\"216.73.216.99\",\"216.73.216.99\",\"42.194.128.82\",\"147.185.132.195\",\"47.128.99.183\",\"2a03:2880:f802:d::\",\"198.244.240.209\",\"42.81.251.37\",\"216.73.216.99\",\"2408:8720:1:380:4d::\",\"138.91.30.59\",\"2408:872f:20:228:6c::\",\"17.241.219.96\",\"216.73.216.99\",\"54.39.89.198\",\"47.128.44.5\",\"47.128.44.98\",\"47.82.11.144\",\"114.10.98.67\",\"205.210.31.207\",\"2a03:2880:f802:5::\",\"216.73.216.99\",\"114.10.101.194\",\"47.128.57.90\",\"47.128.114.154\",\"2409:8730:e0ff:1d:24::\",\"47.128.48.249\",\"2a03:2880:f802:37::\",\"60.188.57.0\",\"43.154.250.181\",\"20.169.78.174\",\"2a03:2880:21ff:6::\",\"47.128.122.168\",\"170.106.179.68\",\"47.128.48.88\",\"47.128.112.69\",\"2409:8c38:70:120:1c::\",\"47.128.117.94\",\"47.128.53.81\",\"129.226.213.145\",\"43.130.67.6\",\"47.128.59.69\",\"47.128.18.159\",\"43.135.142.7\",\"47.128.17.88\",\"43.163.104.54\",\"47.128.38.44\",\"2a03:2880:f802:4b::\",\"36.65.84.55\",\"144.7.103.163\",\"170.106.180.246\",\"2a03:2880:f802:3b::\",\"43.130.139.177\",\"43.157.98.187\",\"2001:4860:7:506::dd\",\"2001:4860:7:506::e7\",\"57.141.2.18\",\"47.82.11.61\",\"49.51.141.76\",\"47.128.97.8\",\"42.187.138.93\",\"47.128.17.9\",\"2001:4860:7:506::e2\",\"2a03:2880:f802:53::\",\"43.135.140.225\",\"36.73.32.56\",\"114.79.51.195\",\"36.73.32.56\",\"47.128.46.25\",\"2a03:2880:f802:41::\",\"2a03:2880:f802:5f::\",\"43.155.195.141\",\"218.93.159.150\",\"74.7.229.82\",\"2001:4860:7:506::e\",\"2001:4860:7:506::e\",\"2a03:2880:f802:f::\",\"47.128.114.190\",\"162.62.213.165\",\"2a03:2880:f802:57::\",\"52.167.144.212\",\"43.135.185.59\",\"2a03:2880:f802:10::\",\"2a03:2880:f802:34::\",\"4.196.198.88\",\"43.133.220.37\",\"47.82.11.16\",\"2a03:2880:f802:53::\",\"47.128.42.160\",\"47.128.41.156\",\"47.128.33.177\",\"2001:4860:7:806::ea\",\"43.157.172.39\",\"57.141.2.85\",\"2a03:2880:f802:4::\",\"57.141.2.75\",\"2a03:2880:f802:3a::\",\"114.79.51.177\",\"118.126.124.36\",\"57.141.2.88\",\"2001:4860:7:506::d5\",\"162.120.184.37\",\"150.109.119.38\",\"2a03:2880:f802:48::\",\"47.128.42.66\",\"47.128.62.121\",\"2a03:2880:f802:43::\",\"2a03:2880:f802:57::\",\"2001:4860:7:506::e4\",\"2a03:2880:f802:4::\",\"205.210.31.141\",\"47.128.50.194\",\"2a03:2880:f802:15::\",\"2a03:2880:f802:50::\",\"74.7.243.213\",\"2a03:2880:f802:2::\",\"47.128.28.132\",\"2a03:2880:f802:2::\",\"223.215.161.77\",\"2a03:2880:f802:50::\",\"2a03:2880:f802:3e::\",\"2a03:2880:f802:16::\",\"47.128.61.67\",\"47.128.45.251\",\"82.197.70.38\",\"103.247.21.211\",\"47.128.123.47\",\"2a03:2880:f802:48::\",\"47.128.20.191\",\"47.128.30.17\",\"47.128.110.209\",\"47.128.116.80\",\"47.128.48.177\",\"57.141.2.3\",\"47.128.38.56\",\"2a03:2880:f802:14::\",\"47.128.22.178\",\"47.128.125.210\",\"2a03:2880:f802:46::\",\"2a03:2880:f802:43::\",\"2a03:2880:f802:37::\",\"2a03:2880:f802:4a::\",\"182.44.9.147\",\"2a03:2880:f802::\",\"47.128.23.232\",\"57.141.2.35\",\"2a03:2880:f802:7::\",\"2a03:2880:f802:47::\",\"42.187.132.89\",\"57.141.2.30\",\"2a03:2880:f802:57::\",\"2a06:4883:1000::17\",\"2a03:2880:f802:4e::\",\"47.82.11.47\",\"5.135.103.166\",\"2a03:2880:f802:8::\",\"47.82.11.37\",\"47.128.31.10\",\"47.128.112.110\",\"47.128.113.152\",\"66.249.71.37\",\"47.128.44.135\",\"47.128.27.21\",\"2a03:2880:f802:3::\",\"57.141.2.17\",\"47.128.53.174\",\"2a03:2880:f802:1f::\",\"47.128.52.134\",\"170.106.84.136\",\"47.128.25.248\",\"47.128.31.30\",\"2a03:2880:f802:1a::\",\"43.166.128.86\",\"2a03:2880:f802:12::\",\"2a03:2880:f802:20::\",\"49.51.72.76\",\"2a03:2880:f802:41::\",\"47.128.33.112\",\"43.130.74.193\",\"47.128.115.127\",\"47.128.45.123\",\"47.128.49.164\",\"2a03:2880:f802:43::\",\"17.241.227.86\",\"2409:8c20:28c1:304:5b::\",\"2a03:2880:f802:d::\",\"43.131.23.154\",\"2a03:2880:f802:44::\",\"43.131.23.154\",\"2a03:2880:f802:4f::\",\"2a03:2880:f802:14::\",\"43.154.140.188\",\"47.128.29.39\",\"47.128.29.21\",\"57.141.2.23\",\"47.128.47.55\",\"47.128.33.128\",\"47.128.33.123\",\"47.128.33.125\",\"43.128.156.124\",\"2a03:2880:f802:47::\",\"119.28.177.175\",\"47.128.29.142\",\"47.128.115.11\",\"47.128.37.129\",\"2a03:2880:f802:e::\",\"47.128.110.152\",\"47.128.120.130\",\"47.128.17.222\",\"13.40.26.179\",\"43.130.31.17\",\"2a03:2880:f802:20::\",\"2a03:2880:f802:1a::\",\"47.128.33.203\",\"66.249.75.103\",\"47.128.34.8\",\"2a03:2880:f802:3e::\",\"47.128.111.205\",\"47.128.24.50\",\"2a03:2880:f802:4b::\",\"49.51.245.241\",\"2a03:2880:f802:48::\",\"43.166.244.251\",\"2a03:2880:f802:53::\",\"43.157.98.187\",\"170.106.72.93\",\"47.82.11.1\",\"217.113.196.228\",\"217.113.196.240\",\"217.113.196.235\",\"217.113.196.191\",\"217.113.196.192\",\"217.113.196.246\",\"217.113.196.202\",\"217.113.196.253\",\"217.113.196.232\",\"217.113.196.195\",\"217.113.196.237\",\"217.113.196.201\",\"217.113.196.196\",\"217.113.196.199\",\"217.113.196.227\",\"43.131.253.14\",\"217.113.196.229\",\"217.113.196.236\",\"217.113.196.217\",\"217.113.196.218\",\"217.113.196.224\",\"217.113.196.218\",\"217.113.196.228\",\"180.242.130.198\",\"2001:4860:7:1622::ff\",\"2a03:2880:f802::\",\"43.167.241.46\",\"43.153.119.119\",\"66.249.77.141\",\"2a03:2880:f802:c::\",\"47.128.120.36\",\"47.128.56.194\",\"47.128.21.125\",\"47.128.47.89\",\"47.128.60.170\",\"43.166.136.202\",\"2a03:2880:f802:41::\",\"2a03:2880:f802:4c::\",\"47.128.48.109\",\"2a03:2880:f802:55::\",\"47.128.16.235\",\"47.128.23.198\",\"2a03:2880:f802:1e::\",\"47.128.30.244\",\"47.128.51.182\",\"47.128.39.153\",\"47.128.37.175\",\"5.39.1.247\",\"2a03:2880:f802:53::\",\"43.130.9.111\",\"47.128.59.25\",\"47.128.119.190\",\"2a03:2880:f802:1::\",\"47.128.18.127\",\"47.128.33.207\",\"2a03:2880:f802:1::\",\"66.249.75.102\",\"47.128.57.208\",\"47.128.27.244\",\"2a03:2880:f802:46::\",\"57.141.2.38\",\"47.128.35.243\",\"47.128.34.190\",\"121.229.156.86\",\"47.128.35.32\",\"47.128.39.253\",\"47.128.52.203\",\"47.128.112.28\",\"51.75.236.140\",\"47.128.113.114\",\"47.128.112.91\",\"2a03:2880:f802:5::\",\"2a03:2880:f802:55::\",\"43.173.174.194\",\"216.244.66.226\",\"2a03:2880:f802:a::\",\"85.208.96.203\",\"2a03:2880:f802:d::\",\"182.42.110.255\",\"66.249.77.140\",\"2a03:2880:f802:57::\",\"2a03:2880:f802:3f::\",\"47.128.59.186\",\"47.128.127.5\",\"47.128.115.40\",\"47.128.61.245\",\"47.128.125.127\",\"47.128.52.209\",\"47.128.53.134\",\"47.128.57.44\",\"2a03:2880:f802:9::\",\"47.128.48.254\",\"47.128.21.242\",\"47.128.45.155\",\"47.128.51.229\",\"47.128.122.194\",\"2408:8722:840:f9::14\",\"112.86.225.245\",\"216.244.66.226\",\"2a03:2880:f802:17::\",\"216.244.66.226\",\"121.204.225.157\",\"85.208.96.196\",\"47.128.112.40\",\"47.128.62.108\",\"47.128.63.95\",\"47.128.23.169\",\"2a03:2880:f802:11::\",\"43.173.180.100\",\"43.173.172.198\",\"2a03:2880:f802:4c::\",\"66.249.75.103\",\"2a03:2880:f802:1a::\",\"2a03:2880:f802:1e::\",\"216.244.66.226\",\"66.249.77.140\",\"34.182.65.152\",\"47.128.113.228\",\"47.128.54.91\",\"47.128.116.100\",\"47.128.125.190\",\"47.128.57.79\",\"66.249.77.141\",\"154.47.20.211\",\"2a03:2880:f802:1f::\",\"2001:4860:7:c06::f\",\"2001:4860:7:406::e\",\"216.244.66.226\",\"85.208.96.203\",\"2001:4860:7:806::bf\",\"216.244.66.226\",\"17.246.19.145\"]}', `Jumlah` = 444
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-30'
0.0010 sec
SHOW COLUMNS FROM `sys_traffic`
0.0009 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-30'
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2025-12-29'
AND (
`config_id` = 1
)
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0007 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0021 sec
SHOW COLUMNS FROM `menu`
0.0008 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '32'
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '16'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '101'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '99'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '85'
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '17'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '93'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '92'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '37'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '62'
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0006 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '65'
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '64'
0.0002 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SELECT `slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri, `judul`, `tgl_upload`
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `id` = '97'
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '24'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '115'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '120'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '124'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0005 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'drppa'
OR `slug` = 'drppa'
)
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '128'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'perdes-tentang-drppa'
OR `slug` = 'perdes-tentang-drppa'
)
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'anti-korupsi'
OR `slug` = 'anti-korupsi'
)
0.0003 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '129'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'tata-laksana'
OR `slug` = 'tata-laksana'
)
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'pengawasan'
OR `slug` = 'pengawasan'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kualitas-pelayanan-publik'
OR `slug` = 'kualitas-pelayanan-publik'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'partisipasi-masyarakat'
OR `slug` = 'partisipasi-masyarakat'
)
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kearifan-lokal'
OR `slug` = 'kearifan-lokal'
)
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '135'
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0005 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `kategori`
0.0005 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '5'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0005 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '23'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0005 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '24'
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0006 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0005 sec
SELECT `t`.*, `a`.`judul`, `a`.`tgl_upload`
FROM `teks_berjalan` `t`
LEFT JOIN `artikel` `a` ON `t`.`tautan` = `a`.`id`
WHERE (
`t`.`config_id` = 1
)
AND `tipe` = 1
AND `status` = 1
ORDER BY `urut`
0.0004 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar` != ''
AND `tgl_upload` < '2025-12-30 21:45:13'
UNION
SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar1` != ''
AND `tgl_upload` < '2025-12-30 21:45:13'
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar2` != ''
AND `tgl_upload` < '2025-12-30 21:45:13')
UNION
(SELECT `id`, `judul`, `gambar`, `slug`, YEAR(tgl_upload) as thn, MONTH(tgl_upload) as bln, DAY(tgl_upload) as hri
FROM `artikel`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `slider` = 1
AND `gambar3` != ''
AND `tgl_upload` < '2025-12-30 21:45:13')ORDER BY RAND() LIMIT 10
0.0022 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0007 sec
SELECT `id`
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `slider` = 1
LIMIT 1
0.0003 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0005 sec
SELECT `id`, `nama` as `judul`, `gambar`
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `parrent` = '55'
AND `tipe` = 2
AND `enabled` = 1
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0005 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `config`
0.0010 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0007 sec
SELECT *
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY rand()
LIMIT 4
0.0005 sec
SHOW COLUMNS FROM `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 DATE(g.tgl_agenda) = CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
0.0005 sec
SHOW COLUMNS FROM `agenda`
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 DATE(g.tgl_agenda) > CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
ORDER BY `g`.`tgl_agenda`
0.0005 sec
SHOW COLUMNS FROM `agenda`
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 DATE(g.tgl_agenda) < CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
0.0009 sec
SHOW COLUMNS FROM `komentar`
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`.`config_id` = 1
)
AND `k`.`status` = 1
AND `k`.`id_artikel` <> 775
ORDER BY `k`.`tgl_upload` DESC
LIMIT 10
0.0006 sec
SHOW COLUMNS FROM `media_sosial`
0.0008 sec
SELECT *
FROM `media_sosial`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0008 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2025-12-30 21:45:13'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0032 sec
SHOW COLUMNS FROM `artikel`
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`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2025-12-30 21:45:13'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0031 sec
SHOW COLUMNS FROM `artikel`
0.0008 sec
SELECT `a`.*, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
WHERE (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` NOT IN (1000)
AND `a`.`tgl_upload` < '2025-12-30 21:45:13'
ORDER BY rand()
LIMIT 7
0.0091 sec
SHOW COLUMNS FROM `tweb_desa_pamong`
0.0010 sec
SELECT dp.pamong_id, rj.nama AS jabatan, dp.pamong_niap, dp.gelar_depan, dp.gelar_belakang, dp.kehadiran, CASE WHEN dp.id_pend IS NULL THEN dp.foto ELSE p.foto END as 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`
LEFT JOIN `ref_jabatan` `rj` ON `rj`.`id` = `dp`.`jabatan_id`
WHERE (
`dp`.`config_id` = 1
)
AND `dp`.`pamong_status` = '1'
ORDER BY `dp`.`urut`
0.0012 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` AND `p`.`config_id` = 1
LEFT JOIN `tweb_wil_clusterdesa` `a` ON `p`.`id_cluster` = `a`.`id`
GROUP BY `u`.`id`
0.0132 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`
WHERE (
`b`.`config_id` = 1
)
0.0076 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0004 sec
SHOW COLUMNS FROM `keuangan_master`
0.0008 sec
SELECT `tahun_anggaran`
FROM `keuangan_master`
WHERE (
`config_id` = 1
)
ORDER BY `tahun_anggaran` DESC
0.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0008 sec
SELECT `Tahun`
FROM `keuangan_manual_rinci`
WHERE (
`config_id` = 1
)
GROUP BY `Tahun`
ORDER BY `Tahun` DESC
0.0004 sec
SELECT `Akun`, `Nama_Akun`
FROM `keuangan_manual_ref_rek1`
WHERE `Akun` NOT LIKE '1.%'
AND `Akun` NOT LIKE '7.%'
GROUP BY `Akun`, `Nama_Akun`
ORDER BY `Akun` ASC
0.0007 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0006 sec
SELECT LEFT(Kd_Rincian, 2) AS jenis_pelaksanaan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `keuangan_manual_rinci`.`Tahun` = '2025'
AND `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND (
`config_id` = 1
)
GROUP BY `jenis_pelaksanaan`
0.0004 sec
SELECT `keuangan_manual_ref_rek3`.`Jenis`, `keuangan_manual_ref_rek3`.`Nama_Jenis`
FROM `keuangan_manual_ref_rek3`
WHERE `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '1.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '5.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '6.%'
AND `keuangan_manual_ref_rek3`.`Jenis` NOT LIKE '7.%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Hutang%'
AND `keuangan_manual_ref_rek3`.`Nama_Jenis` NOT LIKE '%Ekuitas SAL%'
ORDER BY `keuangan_manual_ref_rek3`.`Jenis` ASC
0.0007 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Rincian, 6) AS jenis_pendapatan, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '4.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_pendapatan`
0.0005 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
WHERE `Kd_Bid` NOT LIKE '01%'
ORDER BY `Kd_Bid` ASC
0.0006 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Anggaran) AS pagu
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0007 sec
SELECT LEFT(Kd_Keg, 10) AS jenis_belanja, SUM(Nilai_Realisasi) AS realisasi
FROM `keuangan_manual_rinci`
WHERE `Kd_Rincian` LIKE '5.%' ESCAPE '!'
AND `Tahun` = '2025'
AND (
`config_id` = 1
)
GROUP BY `jenis_belanja`
0.0004 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0002 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0002 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0004 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0008 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0007 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
2.4900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
1.7000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3800 sec
select * from `config` limit 1
0.3100 sec
select count(*) as aggregate from `config`
0.2300 sec
select count(*) as aggregate from `config`
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'setting_aplikasi'
0.6600 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
1.2200 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.5500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.7100 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.4000 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.6300 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.3400 sec
select count(*) as aggregate from `config`
0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists`
0.8300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.6500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.4400 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.5900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.6100 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Selasa' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.5800 sec
select id, nama_hari, jam_masuk, status, keterangan, date_add(jam_keluar, interval 10 minute) as jam_keluar from `kehadiran_jam_kerja` where `nama_hari` = 'Selasa' and (time(`jam_masuk`) > '21:45' or date_add(jam_keluar, interval 10 minute) < '21:45') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5800 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1
0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'tweb_desa_pamong'
1.0700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 20 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5800 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5700 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 40 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 41 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 43 and `tanggal` = '2025-12-30' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3300 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.6500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.7700 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.4100 sec