SHOW TABLES FROM `pans5277_pandansari`
0.0012 sec
SHOW DATABASES
0.0205 sec
SELECT `engine` FROM INFORMATION_SCHEMA.TABLES WHERE table_schema= 'pans5277_pandansari' AND table_name = 'user'
0.0004 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.0010 sec
SHOW COLUMNS FROM `analisis_master`
0.0009 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.0007 sec
SELECT *
FROM `analisis_periode`
WHERE `aktif` = 1
AND `id_master` IS NULL
0.0004 sec
SHOW COLUMNS FROM `analisis_master`
0.0007 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` = 'aparatur-pemdes-pandansari-rutin-laksanakan-pemotongan-hewan-qurban'
OR `id` = 'aparatur-pemdes-pandansari-rutin-laksanakan-pemotongan-hewan-qurban'
0.0009 sec
UPDATE `artikel` SET hit = hit + 1
WHERE (
`config_id` = 1
)
AND `id` = '456'
0.0006 sec
SELECT `a`.*, `u`.`nama` AS `owner`, `k`.`kategori`, `k`.`slug` AS `kat_slug`, YEAR(tgl_upload) AS thn, MONTH(tgl_upload) AS bln, DAY(tgl_upload) AS hri
FROM `artikel` `a`
LEFT JOIN `user` `u` ON `a`.`id_user` = `u`.`id`
LEFT JOIN `kategori` `k` ON `a`.`id_kategori` = `k`.`id`
WHERE `a`.`slug` = 'aparatur-pemdes-pandansari-rutin-laksanakan-pemotongan-hewan-qurban'
AND (
`a`.`config_id` = 1
)
AND `a`.`enabled` = 1
AND `a`.`tgl_upload` < '2025-12-10 22:31:25'
AND YEAR(a.tgl_upload) = '2024'
AND MONTH(a.tgl_upload) = '6'
AND DAY(a.tgl_upload) = '17'
0.0017 sec
SELECT *
FROM `agenda`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '456'
0.0003 sec
SELECT *
FROM `komentar`
WHERE (
`config_id` = 1
)
AND `id_artikel` = '456'
AND `status` = 1
ORDER BY `tgl_upload` DESC
0.0005 sec
SHOW COLUMNS FROM `widget`
0.0010 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `jenis_widget` <> 3
AND `enabled` = 1
0.0005 sec
SHOW COLUMNS FROM `sys_traffic`
0.0009 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-10'
0.0004 sec
SHOW COLUMNS FROM `sys_traffic`
0.0008 sec
UPDATE `sys_traffic` SET `ipAddress` = '{\"ip_address\":[\"216.73.216.223\",\"146.174.181.144\",\"103.54.81.210\",\"101.34.27.77\",\"146.174.163.65\",\"4.196.118.124\",\"148.178.92.194\",\"146.174.175.247\",\"202.76.189.185\",\"146.174.163.86\",\"101.34.27.77\",\"47.128.96.225\",\"146.174.170.1\",\"146.174.168.206\",\"66.249.75.72\",\"202.76.133.250\",\"146.174.168.15\",\"47.128.98.84\",\"202.76.171.18\",\"47.128.50.85\",\"47.82.11.98\",\"202.76.183.218\",\"47.128.33.202\",\"146.174.163.190\",\"47.128.49.27\",\"2408:874c:0:27:28::\",\"165.22.251.145\",\"66.249.71.199\",\"47.128.30.164\",\"146.174.179.65\",\"2001:4860:7:505::d7\",\"146.174.174.115\",\"47.79.203.27\",\"2a03:2880:f80e:19::\",\"202.76.142.32\",\"47.82.11.128\",\"47.128.33.109\",\"146.174.171.6\",\"2409:8754:34a0:0:4d::\",\"2a03:2880:f80e:22::\",\"202.76.164.25\",\"146.174.162.25\",\"202.76.133.128\",\"47.128.109.89\",\"202.76.143.51\",\"146.174.163.57\",\"2a03:2880:f80e:31::\",\"185.39.19.97\",\"146.174.168.195\",\"47.82.11.78\",\"146.174.184.76\",\"52.231.49.54\",\"202.76.188.3\",\"146.174.188.68\",\"85.208.96.205\",\"202.76.178.171\",\"43.140.247.223\",\"202.76.170.185\",\"172.104.34.17\",\"172.204.16.73\",\"202.76.188.172\",\"146.174.162.141\",\"202.76.138.70\",\"146.174.175.193\",\"47.128.17.177\",\"146.174.190.133\",\"2404:c0:7050::2589:69b4\",\"202.76.176.140\",\"2a03:2880:2ff:9::\",\"18.97.9.103\",\"2a03:2880:16ff:44::\",\"180.251.180.200\",\"2a03:2880:11ff:5e::\",\"2a03:2880:ff:5::\",\"2a03:2880:ff:74::\",\"47.128.51.114\",\"47.128.98.90\",\"2a03:2880:27ff:75::\",\"202.76.169.193\",\"170.106.15.3\",\"2a03:2880:11ff:3::\",\"2a03:2880:ff:48::\",\"2a03:2880:ff:53::\",\"2a03:2880:13ff:8::\",\"2a03:2880:ff:42::\",\"2a03:2880:ff:40::\",\"162.128.163.217\",\"2a03:2880:2ff:3::\",\"114.10.10.33\",\"146.174.162.125\",\"2a03:2880:22ff:8::\",\"173.252.127.7\",\"43.157.174.69\",\"47.128.61.1\",\"2a03:2880:31ff:49::\",\"2a03:2880:ff:3::\",\"146.174.164.109\",\"2a03:2880:ff:1::\",\"134.122.112.43\",\"2a03:2880:31ff:25::\",\"2a03:2880:ff:52::\",\"2a03:2880:ff:2::\",\"47.128.123.80\",\"134.122.112.43\",\"43.135.135.57\",\"103.54.81.210\",\"43.135.36.201\",\"146.174.164.199\",\"49.51.178.45\",\"202.76.175.38\",\"43.130.106.18\",\"146.174.177.77\",\"49.51.243.95\",\"202.76.136.238\",\"150.109.46.88\",\"198.235.24.18\",\"146.174.185.188\",\"47.82.11.65\",\"47.82.11.68\",\"146.174.181.52\",\"47.82.11.26\",\"47.82.11.34\",\"47.82.11.65\",\"202.76.138.212\",\"47.128.126.215\",\"146.174.163.204\",\"43.133.14.237\",\"47.82.11.25\",\"202.76.168.0\",\"43.130.174.37\",\"2001:4860:7:506::ee\",\"202.76.185.39\",\"2a03:2880:f80e:5a::\",\"162.120.184.27\",\"47.128.97.5\",\"43.156.156.96\",\"202.76.140.40\",\"193.186.4.182\",\"47.128.28.121\",\"43.157.170.126\",\"3.80.116.193\",\"146.174.186.246\",\"170.106.113.235\",\"146.174.191.209\",\"49.51.183.220\",\"43.153.27.244\",\"47.128.98.98\",\"47.128.51.117\",\"47.128.44.110\",\"47.82.11.36\",\"43.130.100.35\",\"185.191.171.14\",\"2001:4860:7:806::f0\",\"202.76.187.201\",\"43.155.140.157\",\"146.174.165.238\",\"2a03:2880:f80e:50::\",\"43.167.239.66\",\"146.174.179.99\",\"43.133.253.253\",\"2a03:2880:f80e:41::\",\"2a03:2880:25ff:4a::\",\"91.224.92.184\",\"43.157.172.39\",\"146.174.172.83\",\"173.252.87.7\",\"2a03:2880:2ff:72::\",\"2a03:2880:2ff:70::\",\"112.39.15.62\",\"74.7.227.169\",\"146.174.175.28\",\"223.25.252.21\",\"43.130.37.243\",\"146.174.179.200\",\"43.152.72.244\",\"202.76.165.56\",\"117.162.10.166\",\"146.174.181.104\",\"47.128.45.180\",\"2a03:2880:f80e:21::\",\"2a03:2880:f80e:48::\",\"202.76.178.150\",\"146.174.164.61\",\"106.54.62.156\",\"2a03:2880:f80e:20::\",\"43.157.172.39\",\"118.98.214.4\",\"57.141.14.29\",\"146.174.184.214\",\"2a03:2880:f80e:d::\",\"162.128.163.134\",\"203.83.40.4\",\"146.174.190.202\",\"31.13.115.5\",\"2a03:2880:31ff:70::\",\"2a03:2880:2ff:73::\",\"2a03:2880:2ff:5::\",\"103.247.21.211\",\"2a03:2880:f80e:3e::\",\"152.42.161.239\",\"146.174.178.130\",\"47.128.52.138\",\"2a03:2880:f80e:5c::\",\"2a03:2880:f80e:a::\",\"146.174.164.236\",\"57.141.14.96\",\"43.166.134.114\",\"47.82.11.2\",\"202.76.186.174\",\"170.106.152.218\",\"202.76.139.141\",\"2a03:2880:f80e:9::\",\"170.106.152.218\",\"2a03:2880:f80e:3::\",\"2a03:2880:f80e:3a::\",\"104.236.35.208\",\"2a03:2880:f80e:18::\",\"202.76.142.187\",\"146.174.176.59\",\"47.128.98.225\",\"2a03:2880:f80e:22::\",\"2a03:2880:f80e:56::\",\"43.166.142.76\",\"57.141.14.49\",\"202.76.187.102\",\"188.55.17.106\",\"2a03:2880:f80e:41::\",\"2a02:ce0:1002:5628:f8b1:1d8d:1e99:d9e6\",\"24.210.147.116\",\"2a03:2880:f80e:d::\",\"162.128.163.239\",\"162.128.163.138\",\"202.76.169.106\",\"103.68.30.233\",\"43.167.245.18\",\"2804:14d:7e42:8979:6487:9561:684b:dda6\",\"43.166.7.113\",\"2a03:2880:f80e:36::\",\"202.76.172.163\",\"43.130.72.177\",\"2a03:2880:f80e:1b::\",\"202.76.171.105\",\"2a03:2880:f80e:2a::\",\"2a03:2880:f80e:3e::\",\"216.73.216.223\",\"47.128.125.161\",\"216.73.216.223\",\"202.76.139.51\",\"216.73.216.223\",\"43.153.73.200\",\"57.141.14.59\",\"2a03:2880:f80e:56::\",\"2a03:2880:f80e:d::\",\"216.73.216.223\",\"47.128.50.37\",\"57.141.14.43\",\"47.128.22.54\",\"2a03:2880:f80e:3f::\",\"47.128.53.208\",\"57.141.14.39\",\"202.76.186.209\",\"2001:4860:7:806::be\",\"2a03:2880:f80e:39::\",\"2a03:2880:f80e:43::\",\"2a03:2880:f80e:c::\",\"47.128.35.43\",\"57.141.14.31\",\"66.249.71.39\",\"103.54.81.210\",\"162.120.184.53\",\"2a03:2880:f80e:48::\",\"47.128.24.240\",\"146.174.163.52\",\"2a03:2880:f80e:53::\",\"2001:4860:7:806::d\",\"47.128.61.33\",\"146.174.175.47\",\"2a03:2880:f80e:13::\",\"216.73.216.223\",\"216.73.216.223\",\"2a03:2880:f80e:1a::\",\"47.82.11.13\",\"216.73.216.223\",\"146.174.189.119\",\"216.73.216.223\",\"216.73.216.223\",\"202.76.174.227\",\"216.73.216.223\",\"2a03:2880:f80e:63::\",\"2a03:2880:f80e:39::\",\"146.174.173.32\",\"202.76.183.40\",\"2a03:2880:f80e:15::\",\"2a03:2880:f80e:49::\",\"178.128.83.122\",\"66.249.71.39\",\"2a03:2880:f80e:50::\",\"66.249.71.38\",\"2a03:2880:f80e:61::\",\"2a03:2880:f80e:12::\",\"202.76.131.164\",\"47.128.50.139\",\"47.128.121.241\",\"47.128.126.221\",\"47.128.123.171\",\"2a03:2880:f80e:4b::\",\"47.128.53.21\",\"146.174.165.23\",\"47.128.59.181\",\"2a03:2880:f80e:28::\",\"2a03:2880:f80e:38::\",\"47.128.61.119\",\"2a03:2880:f80e:59::\",\"202.76.142.166\",\"47.128.18.144\",\"146.174.175.76\",\"2a03:2880:f80e:1c::\",\"2a03:2880:f80e:56::\",\"47.128.17.245\",\"202.76.174.39\",\"47.128.26.76\",\"77.74.177.114\",\"202.76.163.138\",\"185.191.171.13\",\"185.191.171.6\",\"2a03:2880:f80e:b::\",\"146.174.170.206\",\"2a03:2880:f80e:9::\",\"167.172.84.220\",\"47.82.11.18\",\"2a03:2880:f80e:b::\",\"47.82.11.92\",\"47.82.11.93\",\"49.51.204.74\",\"202.76.170.190\",\"2a03:2880:f80e:14::\",\"43.153.54.138\",\"47.128.60.160\",\"217.113.196.207\",\"217.113.196.232\",\"217.113.196.195\",\"217.113.196.236\",\"217.113.196.212\",\"2a03:2880:f80e:a::\",\"217.113.196.212\",\"217.113.196.245\",\"217.113.196.242\",\"217.113.196.246\",\"217.113.196.201\",\"217.113.196.205\",\"43.153.71.132\",\"217.113.196.217\",\"2a03:2880:f80e:26::\",\"217.113.196.240\",\"217.113.196.233\",\"202.76.173.141\",\"47.128.21.196\",\"43.135.182.43\",\"2a03:2880:f80e:38::\",\"202.76.179.228\",\"47.128.117.205\",\"146.174.161.73\",\"2a03:2880:f80e:2::\",\"2a03:2880:f80e:c::\",\"2a03:2880:f80e:43::\",\"2a03:2880:f80e:1e::\",\"2a03:2880:f80e:3f::\",\"146.174.180.59\",\"2a03:2880:f80e:1::\",\"2a03:2880:f80e:2::\",\"240e:978:2608:801:27::\",\"2a03:2880:f80e:5c::\",\"202.76.173.202\",\"43.135.145.73\",\"66.249.71.64\",\"2a03:2880:f80e:26::\",\"202.76.139.235\",\"49.51.183.220\",\"2a03:2880:2ff:71::\",\"202.76.183.79\",\"49.51.33.159\",\"2620:96:e000::108\",\"2620:96:e000::108\",\"202.76.141.235\",\"43.166.247.155\",\"2a03:2880:f80e:e::\",\"158.94.209.57\",\"170.106.165.76\",\"146.174.178.151\",\"2a03:2880:f80e:13::\",\"2a03:2880:f80e:3f::\",\"43.164.196.57\",\"2a03:2880:f80e:5::\",\"2a03:2880:f80e:42::\",\"4.190.188.203\",\"202.76.167.79\",\"43.166.136.24\",\"2a03:2880:f80e:2a::\",\"2a03:2880:f80e:a::\",\"2a03:2880:f80e:43::\",\"2a03:2880:f80e:3b::\",\"2a03:2880:f80e:2::\",\"43.166.238.12\",\"146.174.189.156\",\"149.102.225.184\",\"2602:80d:1000::44\",\"2602:80d:1000::44\",\"43.130.100.35\",\"2a03:2880:f80e:2b::\",\"47.82.11.49\",\"202.76.141.99\",\"34.74.175.70\",\"43.133.91.48\",\"2a03:2880:f80e:61::\",\"2a03:2880:f80e:4::\",\"202.76.177.104\",\"43.157.175.122\",\"2a03:2880:f80e:43::\",\"49.51.52.250\",\"202.76.161.57\",\"2a03:2880:f80e:16::\",\"43.164.197.224\",\"43.135.133.241\",\"47.82.11.83\",\"47.82.11.77\",\"202.76.161.110\",\"43.157.95.131\",\"143.198.214.64\",\"2a03:2880:f80e:22::\",\"47.128.98.99\",\"47.128.51.106\",\"43.130.110.130\",\"146.174.161.68\",\"2a03:2880:f80e:17::\",\"190.83.105.36\",\"43.159.136.201\",\"2a00:23c6:6c11:d101:86d6:d0ff:fe56:1707\",\"146.174.167.0\",\"61.5.150.34\",\"190.114.40.117\",\"81.77.43.122\",\"2a03:2880:f80e:1e::\",\"47.128.51.113\",\"43.135.172.89\",\"146.174.176.51\",\"103.153.185.85\",\"46.110.84.100\",\"47.128.34.157\",\"101.33.66.34\",\"202.76.129.124\",\"178.120.51.148\",\"2a03:2880:f80e:2e::\",\"200.53.199.140\",\"78.182.134.245\",\"2a03:2880:f80e:34::\",\"202.76.171.0\",\"103.151.47.116\",\"49.51.183.75\",\"102.223.58.242\",\"101.128.120.40\",\"2a03:2880:f80e:40::\",\"202.76.173.244\",\"103.81.105.85\",\"2602:ffe4:8:1001::5\",\"2a03:2880:f80e:29::\",\"2804:3cd0:cf:edbc:b978:8166:938b:11dc\",\"187.107.8.213\",\"2a03:2880:f80e:5a::\",\"185.254.55.224\",\"223.109.252.229\",\"157.245.203.186\",\"179.124.199.195\",\"2a00:1d36:a025:4100:40cc:8757:d6ba:1704\",\"169.224.0.32\",\"212.237.121.128\",\"47.128.57.66\",\"52.167.144.147\",\"86.44.222.193\",\"82.4.122.18\",\"196.191.61.40\",\"2804:7c40:30b:6900:21aa:ae1d:4493:b63a\",\"2800:cd0:fb18:4e00:286f:3796:a8ab:3530\",\"91.244.17.199\",\"74.105.54.47\",\"45.164.152.23\",\"2a03:2880:f80e:49::\",\"185.186.83.42\",\"45.230.151.196\",\"2a03:2880:f80e:47::\",\"201.226.149.79\",\"2600:1700:a50:69d0:3027:2dcc:3f55:609e\",\"189.12.32.53\",\"2a03:2880:f80e:3d::\",\"2a06:4883:9000::a2\",\"223.181.239.238\",\"103.121.172.50\",\"146.174.167.121\",\"2a03:2880:f80e:22::\",\"196.65.46.229\",\"103.206.226.142\",\"2a03:2880:f80e:4::\",\"2a03:2880:f80e:13::\",\"193.176.214.18\",\"2804:14c:140:2692:d51b:19bb:b061:98d7\",\"170.239.73.58\",\"45.181.108.110\",\"202.76.139.160\",\"121.210.124.164\",\"45.230.26.97\",\"110.39.169.34\",\"195.238.116.234\",\"2804:3d04:a1ae:2900:a006:af7a:3685:9a90\",\"2a03:2880:f80e:2b::\",\"78.58.39.141\",\"2a03:2880:f80e:3c::\",\"2a03:2880:f80e:59::\",\"103.133.201.227\",\"2a00:5400:e052:23fc:b961:d62:a9:e80d\",\"146.174.171.81\",\"24.206.10.66\",\"2a03:2880:f80e:5d::\",\"207.191.244.23\",\"189.15.227.25\",\"176.228.162.13\",\"2404:7c80:8c:7a00:84db:6426:a344:4acb\",\"47.82.11.17\",\"146.174.180.191\"]}', `Jumlah` = 527
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-10'
0.0009 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
SELECT *
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
AND `Tanggal` = '2025-12-10'
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE `Tanggal` = '2025-12-09'
AND (
`config_id` = 1
)
0.0002 sec
SHOW COLUMNS FROM `sys_traffic`
0.0005 sec
SELECT SUM(`Jumlah`) AS `Jumlah`
FROM `sys_traffic`
WHERE (
`config_id` = 1
)
0.0015 sec
SHOW COLUMNS FROM `menu`
0.0006 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.0005 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.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` = '101'
0.0002 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` = '99'
0.0002 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.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.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` = '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.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` = '37'
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` = '62'
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` = '65'
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` = '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.0002 sec
SHOW COLUMNS FROM `menu`
0.0004 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.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '120'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SHOW COLUMNS FROM `menu`
0.0006 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.0006 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'drppa'
OR `slug` = 'drppa'
)
0.0004 sec
SHOW COLUMNS FROM `menu`
0.0006 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '128'
AND `enabled` = 1
ORDER BY `urut`
0.0004 sec
SHOW COLUMNS FROM `kategori`
0.0006 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'perdes-tentang-drppa'
OR `slug` = 'perdes-tentang-drppa'
)
0.0004 sec
SHOW COLUMNS FROM `kategori`
0.0006 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.0006 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.0011 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'tata-laksana'
OR `slug` = 'tata-laksana'
)
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'pengawasan'
OR `slug` = 'pengawasan'
)
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kualitas-pelayanan-publik'
OR `slug` = 'kualitas-pelayanan-publik'
)
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'partisipasi-masyarakat'
OR `slug` = 'partisipasi-masyarakat'
)
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND (
`id` = 'kearifan-lokal'
OR `slug` = 'kearifan-lokal'
)
0.0005 sec
SHOW COLUMNS FROM `menu`
0.0011 sec
SELECT *
FROM `menu`
WHERE (
`config_id` = 1
)
AND `parrent` = '135'
AND `enabled` = 1
ORDER BY `urut`
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
OR `config_id` IS NULL
)
AND `enabled` = 1
AND `parrent` = 0
ORDER BY `urut`
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0010 sec
SELECT *
FROM `kategori`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
AND `parrent` = '1'
ORDER BY `urut`
0.0005 sec
SHOW COLUMNS FROM `kategori`
0.0007 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.0003 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.0003 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.0008 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.0008 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SHOW COLUMNS FROM `artikel`
0.0007 sec
SHOW COLUMNS FROM `artikel`
0.0007 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-10 22:31:25'
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-10 22:31:25'
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-10 22:31:25')
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-10 22:31:25')ORDER BY RAND() LIMIT 10
0.0037 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.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 sec
SELECT *
FROM `widget`
WHERE (
`config_id` = 1
)
AND `enabled` = 1
ORDER BY `urut`
0.0002 sec
SHOW COLUMNS FROM `config`
0.0009 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.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.0008 sec
SHOW COLUMNS FROM `komentar`
0.0007 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.0004 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-10 22:31:25'
ORDER BY `a`.`tgl_upload` DESC
LIMIT 7
0.0020 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-10 22:31:25'
ORDER BY `a`.`hit` DESC
LIMIT 7
0.0019 sec
SHOW COLUMNS FROM `artikel`
0.0006 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-10 22:31:25'
ORDER BY rand()
LIMIT 7
0.0043 sec
SHOW COLUMNS FROM `tweb_desa_pamong`
0.0005 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.0007 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.0125 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.0044 sec
SHOW COLUMNS FROM `widget`
0.0005 sec
SELECT `setting`
FROM `widget`
WHERE (
`config_id` = 1
)
AND `isi` = 'sinergi_program.php'
0.0002 sec
SHOW COLUMNS FROM `keuangan_master`
0.0005 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.0005 sec
SELECT `Tahun`
FROM `keuangan_manual_rinci`
WHERE (
`config_id` = 1
)
GROUP BY `Tahun`
ORDER BY `Tahun` DESC
0.0003 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.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0005 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.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 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.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 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.0003 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.0005 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0005 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.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 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.0003 sec
SELECT `Kd_Bid`, `Nama_Bidang`
FROM `keuangan_manual_ref_bidang`
WHERE `Kd_Bid` NOT LIKE '01%'
ORDER BY `Kd_Bid` ASC
0.0004 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 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.0003 sec
SHOW COLUMNS FROM `keuangan_manual_rinci`
0.0004 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.0003 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.0004 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.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 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.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 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.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 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.0002 sec
SHOW COLUMNS FROM `widget`
0.0004 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.0002 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
3.7100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.7900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4800 sec
select * from `config` limit 1
0.4500 sec
select count(*) as aggregate from `config`
0.3200 sec
select count(*) as aggregate from `config`
0.2900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'setting_aplikasi'
0.9900 sec
select * from `setting_aplikasi` where `setting_aplikasi`.`config_id` = 1 order by `key` asc
1.4900 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' and table_type = 'BASE TABLE'
0.7000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan'
0.9700 sec
select * from `ref_jabatan` where `jenis` = 1 and `ref_jabatan`.`config_id` = 1 limit 1
0.5600 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'ref_jabatan' 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 = 'ref_jabatan'
0.7700 sec
select * from `ref_jabatan` where `jenis` = 2 and `ref_jabatan`.`config_id` = 1 limit 1
0.3200 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 = 'config'
0.8200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3100 sec
select exists(select * from `migrasi` where `versi_database` = 2024060101) as `exists`
0.9500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
1.1100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'anjungan'
0.9500 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.6700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.9500 sec
select * from `kehadiran_jam_kerja` where `status` = 0 and `nama_hari` = 'Rabu' and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.5200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
0.8400 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` = 'Rabu' and (time(`jam_masuk`) > '22:31' or date_add(jam_keluar, interval 10 minute) < '22:31') and `kehadiran_jam_kerja`.`config_id` = 1 limit 1
0.4900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.9000 sec
select * from `kehadiran_perangkat_desa` where `status_kehadiran` = 'hadir' and `jam_keluar` is null and `kehadiran_perangkat_desa`.`config_id` = 1
0.6200 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.9800 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.7300 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.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.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.7500 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.7700 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'
1.0100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0100 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.9500 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.9400 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'
1.0300 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 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.4500 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0200 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4500 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.4100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1600 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'
0.8400 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.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.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.5900 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.5500 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.4800 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.2000 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.1800 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4600 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0400 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.5700 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.4700 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.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'
1.1200 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.8100 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.8900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.9600 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.5900 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.5100 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.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.5000 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.4800 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.2500 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.3400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
0.7300 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.5000 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.4900 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'
1.3700 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.5700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'config'
1.0900 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.5300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'tweb_desa_pamong'
1.5100 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.9400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 14 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.5400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.9300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 20 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.9100 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 32 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4900 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.8300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 26 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.8400 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 31 and `tanggal` = '2025-12-10' 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.8200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 29 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4300 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.8200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 33 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.4400 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_perangkat_desa'
0.8200 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 35 and `tanggal` = '2025-12-10' 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.8300 sec
select * from `kehadiran_perangkat_desa` where `pamong_id` = 40 and `tanggal` = '2025-12-10' and `kehadiran_perangkat_desa`.`config_id` = 1 order by `id` desc limit 1
0.3900 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` = 41 and `tanggal` = '2025-12-10' 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` = 43 and `tanggal` = '2025-12-10' 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 = 'config'
0.7000 sec
select * from `config` where `app_key` = 'base64:pm6l67z8MPlNf3kh47t1CM9tSlbuFadj78pUa6l1GvU=' limit 1
0.3600 sec
select * from information_schema.tables where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja' and table_type = 'BASE TABLE'
0.7700 sec
select column_name as `column_name` from information_schema.columns where table_schema = 'pans5277_pandansari' and table_name = 'kehadiran_jam_kerja'
1.0900 sec
select * from `kehadiran_jam_kerja` where `kehadiran_jam_kerja`.`config_id` = 1
0.6000 sec
1.1140 sec
13.05MB
Request : first/artikel
Database
N/A
Libraries (19)
Helpers (14)
Views (31) 
Configuration 
Session 
Models (47)