SHOW TABLES FROM `pans5277_pandansari`
0.0035 sec
SHOW DATABASES
0.0187 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'pans5277_pandansari' AND table_name = 'user'
0.0003 sec
SHOW COLUMNS FROM `anjungan`
0.0008 sec
SELECT *
FROM `anjungan`
WHERE (
`ip_address` = '216.73.216.223'
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.0008 sec
SHOW COLUMNS FROM `analisis_master`
0.0008 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.0003 sec
SHOW COLUMNS FROM `analisis_master`
0.0006 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` = 'istighozah-dan-doa-bersama-periode-bulan-juni-2024'
OR `id` = 'istighozah-dan-doa-bersama-periode-bulan-juni-2024'
0.0010 sec
UPDATE `artikel` SET hit = hit + 1
WHERE (
`config_id` = 1
)
AND `id` = '459'
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` = 'istighozah-dan-doa-bersama-periode-bulan-juni-2024'
AND (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2025-12-11 21:06:02'
AND YEAR(a.tgl_upload) = '2024'
AND MONTH(a.tgl_upload) = '6'
AND DAY(a.tgl_upload) = '23'
0.0021 sec
SELECT *
FROM `agenda`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '459'
0.0003 sec
SELECT *
FROM `komentar`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '459'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0008 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-11'
0.0003 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.216.223\",\"216.73.216.223\",\"72.14.201.187\",\"47.82.11.82\",\"216.73.216.223\",\"47.128.31.5\",\"24.144.86.252\",\"66.249.75.71\",\"103.54.81.210\",\"57.141.14.40\",\"47.128.20.231\",\"47.128.119.173\",\"47.128.97.52\",\"47.128.60.195\",\"47.128.51.210\",\"216.73.216.223\",\"13.76.115.249\",\"47.82.11.49\",\"162.128.163.139\",\"185.117.225.99\",\"47.82.11.140\",\"103.54.81.210\",\"74.7.227.160\",\"2a03:2880:f80e:40::\",\"66.249.71.197\",\"152.58.63.152\",\"47.128.125.244\",\"47.128.50.86\",\"47.128.98.92\",\"162.120.184.27\",\"103.247.21.211\",\"2001:4860:7:406::e5\",\"47.82.11.71\",\"47.128.112.225\",\"43.166.255.102\",\"43.135.144.126\",\"43.135.144.126\",\"188.166.185.142\",\"47.82.11.49\",\"43.153.113.127\",\"43.157.170.13\",\"66.249.75.72\",\"101.33.55.204\",\"43.159.149.56\",\"47.128.125.107\",\"43.155.129.131\",\"2001:4860:7:806::fe\",\"36.161.193.16\",\"2a06:4882:3000::33\",\"43.153.113.127\",\"47.128.63.152\",\"43.135.185.59\",\"43.157.153.236\",\"162.62.231.139\",\"170.106.192.3\",\"43.166.240.231\",\"100.30.248.17\",\"2001:4860:7:b06::ed\",\"49.51.243.156\",\"47.128.36.119\",\"101.32.52.164\",\"167.172.84.220\",\"43.166.238.12\",\"74.7.241.29\",\"47.128.20.75\",\"157.66.35.131\",\"49.51.203.164\",\"103.54.81.210\",\"66.249.71.39\",\"178.156.177.134\",\"170.106.82.209\",\"2001:4860:7:806::d\",\"180.190.39.254\",\"106.49.141.208\",\"43.140.247.223\",\"47.128.98.68\",\"47.128.50.47\",\"103.247.21.211\",\"2a03:2880:f80e:57::\",\"57.141.14.18\",\"57.141.14.75\",\"2a03:2880:f80e:2c::\",\"162.128.163.132\",\"134.209.109.206\",\"74.7.242.40\",\"2001:4860:7:806::fa\",\"2a03:2880:f80e:4d::\",\"85.208.96.194\",\"185.191.171.4\",\"2a03:2880:f80e:4d::\",\"201.77.100.41\",\"2001:4860:7:806::c\",\"185.213.83.225\",\"2a03:2880:f80e:5e::\",\"57.141.14.42\",\"57.141.14.79\",\"66.249.71.37\",\"2a03:2880:f80e:49::\",\"47.128.110.83\",\"66.249.71.38\",\"2001:4860:7:506::d6\",\"2a03:2880:f80e:5a::\",\"2001:4860:7:b06::ee\",\"2a03:2880:f80e:58::\",\"2a03:2880:f80e:34::\",\"2a03:2880:f80e:3f::\",\"2a03:2880:f80e:61::\",\"2a03:2880:f80e:46::\",\"2a03:2880:f80e:42::\",\"103.247.21.211\",\"36.65.88.245\",\"2a03:2880:f80e:17::\",\"23.27.145.202\",\"2001:4860:7:506::e3\",\"2001:4860:7:806::bc\",\"2a03:2880:f80e:3a::\",\"2a03:2880:f80e:5::\",\"34.46.214.79\",\"2a03:2880:f80e:2b::\",\"2a03:2880:f80e:44::\",\"47.128.98.84\",\"47.128.51.1\",\"2a03:2880:f80e:1::\",\"2a03:2880:f80e:5a::\",\"2a03:2880:f80e:30::\",\"47.128.126.120\",\"57.141.14.5\",\"57.141.14.83\",\"2a03:2880:f80e:16::\",\"212.11.64.114\",\"212.11.64.114\",\"2a03:2880:f80e:3a::\",\"57.141.14.13\",\"2a03:2880:f80e:5::\",\"40.77.167.4\",\"47.128.99.182\",\"57.141.14.78\",\"2a03:2880:f80e:44::\",\"2a03:2880:f80e:2f::\",\"2a03:2880:f80e:25::\",\"2a03:2880:f80e:b::\",\"103.132.52.235\",\"2a03:2880:f80e:4d::\",\"47.82.11.78\",\"47.82.11.31\",\"124.156.157.91\",\"2a03:2880:f80e:44::\",\"43.130.139.177\",\"148.178.80.155\",\"2a03:2880:f80e:8::\",\"148.178.87.48\",\"178.93.109.194\",\"148.178.90.161\",\"148.178.82.250\",\"182.44.8.254\",\"43.157.170.13\",\"2a03:2880:f80e:20::\",\"47.128.112.174\",\"47.128.31.238\",\"2a03:2880:f80e:27::\",\"47.128.39.163\",\"43.130.139.136\",\"47.128.19.20\",\"2a03:2880:f80e:4a::\",\"47.128.48.150\",\"47.128.57.239\",\"2602:80d:1000::16\",\"2602:80d:1000::16\",\"43.153.19.83\",\"2a03:2880:f80e:5a::\",\"2a03:2880:f80e:47::\",\"148.178.81.226\",\"2a03:2880:f80e:39::\",\"2408:8719:64:208:52::\",\"2a03:2880:f80e:61::\",\"2a03:2880:f80e:4d::\",\"47.128.53.68\",\"47.128.31.203\",\"2a03:2880:f80e:5f::\",\"2a03:2880:f80e:4e::\",\"43.173.1.69\",\"2a03:2880:f80e:3b::\",\"156.59.198.136\",\"2a03:2880:f80e:23::\",\"2a03:2880:f80e:5a::\",\"2a03:2880:f80e:44::\",\"47.128.98.73\",\"43.131.32.36\",\"2a03:2880:f80e:21::\",\"47.128.51.117\",\"2a03:2880:f80e:28::\",\"43.167.239.66\",\"202.76.184.160\",\"43.154.140.188\",\"2a03:2880:f80e:4e::\",\"2a03:2880:f80e:1::\",\"2a03:2880:f80e:1d::\",\"47.128.127.184\",\"47.128.38.233\",\"2a03:2880:f80e:61::\",\"43.157.67.70\",\"47.128.51.127\",\"47.128.31.241\",\"2a03:2880:f80e:25::\",\"43.166.7.113\",\"162.62.132.25\",\"2a03:2880:f80e:39::\",\"129.226.93.214\",\"66.249.71.37\",\"2a03:2880:f80e:2c::\",\"2408:8722:b000:8:29::\",\"119.28.140.106\",\"2a03:2880:f80e:54::\",\"2a03:2880:f80e:50::\",\"180.252.80.184\",\"2a03:2880:f80e:19::\",\"170.106.180.246\",\"2a03:2880:f80e:5e::\",\"2a03:2880:f80e:30::\",\"43.167.241.46\",\"47.128.36.228\",\"49.51.183.84\",\"2a03:2880:f80e:1a::\",\"198.235.24.139\",\"2a03:2880:f80e:26::\",\"43.130.91.95\",\"2a03:2880:f80e:46::\",\"66.249.75.73\",\"66.249.75.72\",\"66.249.71.38\",\"2a03:2880:f80e:2d::\",\"40.77.167.247\",\"51.89.136.156\",\"2a03:2880:f80e:31::\",\"2001:4860:7:628::fa\",\"47.128.22.192\",\"207.46.13.54\",\"66.249.75.71\",\"47.128.56.139\",\"2a03:2880:f80e:51::\",\"185.191.171.19\",\"2a03:2880:f80e:56::\",\"112.86.225.117\",\"146.174.177.78\",\"2a03:2880:f80e:8::\",\"2a03:2880:f80e:a::\",\"35.196.75.72\",\"2a03:2880:11ff:56::\",\"114.79.47.233\",\"2a03:2880:f80e:4c::\",\"2a03:2880:30ff:70::\",\"47.128.51.43\",\"2a03:2880:24ff:2::\",\"57.141.14.67\",\"2a03:2880:27ff:76::\",\"2a03:2880:22ff:3::\",\"2a03:2880:ff:3::\",\"2a03:2880:ff:5f::\",\"2a03:2880:22ff:4e::\",\"2a03:2880:27ff:3::\",\"2a03:2880:ff:13::\",\"2a03:2880:ff:5e::\",\"69.171.231.115\",\"2a03:2880:ff:4f::\",\"2a03:2880:ff:44::\",\"31.13.127.115\",\"2a03:2880:ff:6::\",\"2a03:2880:ff:72::\",\"2a03:2880:f80e:2e::\",\"2a03:2880:7ff:4f::\",\"2a03:2880:31ff:8::\",\"2a03:2880:ff:4e::\",\"2a03:2880:ff:46::\",\"2a03:2880:11ff:56::\",\"2a03:2880:22ff:4d::\",\"2a03:2880:ff:70::\",\"2a03:2880:ff:5d::\",\"2a03:2880:f80e:16::\",\"2a03:2880:f80e:3e::\",\"31.13.127.25\",\"2a03:2880:27ff:3::\",\"2a03:2880:ff:44::\",\"2a03:2880:ff:2::\",\"2a03:2880:32ff::\",\"2a03:2880:3ff:52::\",\"2a03:2880:ff:f::\",\"2a03:2880:ff:4d::\",\"2804:14e8:5900:2e79:a43d:7ec8:b7d1:10c4\",\"2a03:2880:30ff:6::\",\"17.22.245.179\",\"2a03:2880:ff:43::\",\"2a03:2880:ff:e::\",\"2a03:2880:22ff:4d::\",\"2a03:2880:3ff:71::\",\"2a03:2880:f80e:56::\",\"2a03:2880:ff:4a::\",\"2a03:2880:ff:46::\",\"2a03:2880:10ff:5e::\",\"2a03:2880:ff:9::\",\"2a03:2880:ff:70::\",\"2803:2a00:d:e1d8:9c6:223b:69ec:c88f\",\"2a03:2880:3ff:5::\",\"135.181.3.246\",\"2a03:2880:27ff:5::\",\"2a03:2880:ff:52::\",\"2a03:2880:ff:57::\",\"2a03:2880:21ff:b::\",\"135.181.3.246\",\"2a03:2880:3ff:74::\",\"2a03:2880:ff::\",\"2a03:2880:ff:11::\",\"2a03:2880:11ff:3::\",\"2a03:2880:11ff:4a::\",\"135.181.3.246\",\"2a03:2880:12ff:5::\",\"2a03:2880:ff:5e::\",\"2a03:2880:ff:4d::\",\"173.252.79.113\",\"135.181.3.246\",\"135.181.3.246\",\"2a03:2880:ff:5::\",\"2a03:2880:ff:13::\",\"2a03:2880:12ff:72::\",\"75.11.26.160\",\"135.181.3.246\",\"2a03:2880:13ff:2::\",\"2a03:2880:ff:2::\",\"2a03:2880:ff:48::\",\"135.181.3.246\",\"2a03:2880:31ff:42::\",\"2a03:2880:13ff:1::\",\"2a03:2880:ff:16::\",\"2a03:2880:ff:3::\",\"2a03:2880:30ff:4::\",\"135.181.3.246\",\"2a03:2880:10ff:4b::\",\"2a03:2880:ff:5a::\",\"2a03:2880:ff:58::\",\"135.181.3.246\",\"154.198.86.124\",\"2a03:2880:18ff:48::\",\"135.181.3.246\",\"2a03:2880:31ff:72::\",\"2a03:2880:ff:f::\",\"2a03:2880:ff:b::\",\"135.181.3.246\",\"2a03:2880:24ff:6::\",\"2a03:2880:ff:43::\",\"2a03:2880:ff:1d::\",\"135.181.3.246\",\"2a03:2880:31ff:5b::\",\"2a03:2880:12ff:5::\",\"135.181.3.246\",\"2a03:2880:ff:47::\",\"2a03:2880:ff:1a::\",\"2a03:2880:31ff:41::\",\"135.181.3.246\",\"2a03:2880:22ff:72::\",\"2a03:2880:ff:58::\",\"2a03:2880:ff:16::\",\"2a03:2880:3ff:4c::\",\"135.181.3.246\",\"2a03:2880:13ff:70::\",\"2a03:2880:ff:5::\",\"135.181.3.246\",\"2a03:2880:ff:b::\",\"36.41.75.167\",\"2a03:2880:7ff:71::\",\"156.59.198.135\",\"135.181.3.246\",\"2a03:2880:ff:4f::\",\"2a03:2880:ff:44::\",\"135.181.3.246\",\"2a03:2880:13ff:3::\",\"2a03:2880:ff:40::\",\"2a03:2880:ff:17::\",\"135.181.3.246\",\"2a03:2880:7ff:46::\",\"2a03:2880:ff:5a::\",\"2a03:2880:ff:1d::\",\"135.181.3.246\",\"135.181.3.246\",\"2a03:2880:11ff:43::\",\"2a03:2880:ff:56::\",\"223.233.87.75\",\"2a03:2880:ff:5d::\",\"135.181.3.246\",\"2a03:2880:30ff:2::\",\"2a03:2880:ff:4a::\",\"2a03:2880:ff:1::\",\"135.181.3.246\",\"135.181.3.246\",\"2a03:2880:f80e:29::\",\"135.181.3.246\",\"2a03:2880:f80e:59::\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"119.234.28.175\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"178.92.99.31\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"2a03:2880:f80e:35::\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"2001:4860:7:506::d2\",\"135.181.3.246\",\"2001:4860:7:806::ed\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"2a03:2880:f80e:3e::\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\",\"135.181.3.246\"]}', `Jumlah` = 431
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-11'
0.0006 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-11'
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2025-12-10'
AND (
`config_id` = 1
)
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0004 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0028 sec
SHOW COLUMNS FROM `menu`
0.0005 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = 0
AND `enabled` = 1
ORDER BY `urut`
0.0003 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` = '32'
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 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.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` = '101'
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` = '99'
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` = '85'
0.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 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.0004 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.0002 sec
SHOW COLUMNS FROM `artikel`
0.0004 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.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` = '37'
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` = '62'
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` = '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.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 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.0004 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '120'
AND `enabled` = 1
ORDER BY `urut`
0.0002 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.0004 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.0002 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.0002 sec
SHOW COLUMNS FROM `menu`
0.0005 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.0002 sec
SHOW COLUMNS FROM `kategori`
0.0007 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'pengawasan'
OR `slug` = 'pengawasan'
)
0.0004 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.0003 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.0002 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.0002 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.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '4'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `kategori`
0.0004 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.0004 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.0004 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '24'
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0006 sec
SHOW COLUMNS FROM `teks_berjalan`
0.0004 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.0004 sec
SHOW COLUMNS FROM `artikel`
0.0005 sec
SHOW COLUMNS FROM `artikel`
0.0004 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-11 21:06:02'
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-11 21:06:02'
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-11 21:06:02')
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-11 21:06:02')ORDER BY RAND() LIMIT 10
0.0020 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0006 sec
SELECT `id`
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `slider` = 1
LIMIT 1
0.0003 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0004 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.0004 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0003 sec
SHOW COLUMNS FROM `config`
0.0006 sec
SHOW COLUMNS FROM `gambar_gallery`
0.0005 sec
SELECT *
FROM `gambar_gallery`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY rand()
LIMIT 4
0.0004 sec
SHOW COLUMNS FROM `agenda`
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 DATE(g.tgl_agenda) = CURDATE()
AND (
`g`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`id_kategori` = '1000'
0.0004 sec
SHOW COLUMNS FROM `agenda`
0.0004 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.0004 sec
SHOW COLUMNS FROM `agenda`
0.0004 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.0006 sec
SHOW COLUMNS FROM `komentar`
0.0005 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.0003 sec
SHOW COLUMNS FROM `media_sosial`
0.0006 sec
SELECT *
FROM `media_sosial`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
0.0003 sec
SHOW COLUMNS FROM `artikel`
0.0005 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-11 21:06:02'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0017 sec
SHOW COLUMNS FROM `artikel`
0.0005 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-11 21:06:02'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0016 sec
SHOW COLUMNS FROM `artikel`
0.0005 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-11 21:06:02'
ORDER BY rand()
LIMIT 7
0.0044 sec
SHOW COLUMNS FROM `tweb_desa_pamong`
0.0011 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.0014 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.0153 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.0051 sec
SHOW COLUMNS FROM `widget`
0.0006 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0002 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.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0009 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.0008 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0008 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.0009 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.0008 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0006 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.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0008 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.0004 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
WHERE `Kd_Bid` NOT LIKE '01%'
ORDER BY `Kd_Bid` ASC
0.0007 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.0010 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.0009 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0004 sec
SHOW COLUMNS FROM `widget`
0.0010 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0011 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0004 sec
SHOW COLUMNS FROM `widget`
0.0009 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0010 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0012 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0009 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'aparatur_desa.php'
0.0003 sec
SHOW COLUMNS FROM `widget`
0.0004 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'
3.1100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.9300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.2600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select * from `config` limit 1
0.2100 sec
select count(*) as aggregate from `config`
0.1800 sec
select count(*) as aggregate from `config`
0.1400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'setting_aplikasi'
0.5700 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
0.8400 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.5300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.6500 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.2900 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.2300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.4200 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.2100 sec
select count(*) as aggregate from `config`
0.1600 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.2200 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists`
0.6700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.5800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.6300 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.4800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.5900 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Kamis' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.4200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.5900 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` = 'Kamis' and (time(`jam_masuk`) > '21:06' or date_add(jam_keluar, interval 10 minute) < '21:06') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6200 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.6200 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.3000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6500 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.6500 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.6500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 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.6600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 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.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6500 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.6700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 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.2800 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.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5700 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.5700 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.6200 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.8000 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.8100 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.7000 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.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.2900 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.5200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4600 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.4300 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.4500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4300 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.4300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4600 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.4400 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.4500 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.4500 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.4600 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.4300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.8300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.9300 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.6300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.5500 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4600 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.2200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.4800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.6600 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 = 'tweb_desa_pamong'
1.1300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
1.0000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4500 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` = 20 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc 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.6200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.2800 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.5900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6500 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-12-11' 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.6000 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.6200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-12-11' 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 = 'kehadiran_perangkat_desa'
0.5600 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-12-11' 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-11' 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 = 'kehadiran_perangkat_desa'
0.5900 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 41 and `tanggal` = '2025-12-11' 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.7100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 43 and `tanggal` = '2025-12-11' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc 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.6400 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3800 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.5400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.7500 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.3800 sec