Optimalisasi Peran DPRD dalam Pengawasan Keuangan Daerah
Sri Murni
##article.abstract##
The Objective of this paper is discussing how to optimizing the role oflegislative (DPRD) in controlling region’s finance. It will describe about introduction,concepts of region’s finance and management of region’s finance, budgeting andbudgeting cycle, oversight of region’s finance, role and function of legislative (DPRD),optimizing role of legislative in controlling region’s finance, future implication, andconclusion.
Jurnal Akuntansi dan Bisnis (JAB) ISSN 1412-0852 (print), 2580-5444 (online) Published by Accounting Study Program, Faculty of Economics and Business, Universitas Sebelas Maret, Indonesia
SELECT * FROM sessions WHERE session_id = v9dcs03vidn3jfuibn185sv6o2
Speed: 2.115 ms
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(v9dcs03vidn3jfuibn185sv6o2, 18.190.153.77, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1732771756, 1732771756, 0, , jab1.fe.uns.ac.id
Speed: 9.395 ms
SELECT * FROM journals WHERE path = ja
Speed: 1.686 ms
Speed: 1.595 ms
Speed: 3.877 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.665 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.850 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.930 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.792 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.816 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.740 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.710 ms
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 3
Speed: 1.847 ms
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 3
Speed: 1.174 ms
Speed: 0.959 ms
SELECT * FROM article_settings WHERE article_id = 3
Speed: 0.896 ms
Speed: 0.838 ms
SELECT i.* FROM issues i WHERE issue_id = 1
Speed: 0.927 ms
SELECT * FROM issue_settings WHERE issue_id = 1
Speed: 0.805 ms
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-18-190-153-77.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-190-153-77.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 2.062 ms
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 314480973 >= isip.ip_start AND 314480973 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-11-28 12:29:16' >= s.date_start AND '2024-11-28 12:29:16' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 314480973 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.697 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 1.129 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.945 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 0.932 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.852 ms
SELECT g.*,
af.file_name, af.original_file_name, af.file_stage, af.file_type, af.file_size, af.date_uploaded, af.date_modified
FROM article_galleys g
LEFT JOIN article_files af ON (g.file_id = af.file_id)
INNER JOIN articles a ON a.article_id = g.article_id
LEFT JOIN published_articles pa ON g.article_id = pa.article_id INNER JOIN article_galley_settings gs ON g.galley_id = gs.galley_id
WHERE gs.setting_name = pub-id::publisher-id AND gs.setting_value = 0 AND g.article_id = 3
Speed: 1.852 ms
SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.galley_id = 0 AND g.article_id = 3
Speed: 0.994 ms
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 3
Speed: 2.028 ms
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 3
Speed: 1.375 ms
Speed: 1.021 ms
SELECT * FROM article_settings WHERE article_id = 3
Speed: 0.996 ms
Speed: 0.989 ms
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-18-190-153-77.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-190-153-77.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.203 ms
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 314480973 >= isip.ip_start AND 314480973 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2024-11-28 12:29:16' >= s.date_start AND '2024-11-28 12:29:16' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 314480973 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.576 ms
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 3 AND citation_state >= 0 AND citation_state <= 5
Speed: 1.236 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 0.923 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.908 ms
Speed: 2.417 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block visitor AND setting_name = enabled AND journal_id = 1
Speed: 1.083 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = block visitor AND setting_name = enabled AND journal_id = 1
Speed: 0.895 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block visitor AND journal_id = 1
Speed: 0.908 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block indexed AND setting_name = enabled AND journal_id = 1
Speed: 0.864 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = block indexed AND setting_name = enabled AND journal_id = 1
Speed: 1.032 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block indexed AND journal_id = 1
Speed: 1.015 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block issn AND setting_name = enabled AND journal_id = 1
Speed: 0.880 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = block issn AND setting_name = enabled AND journal_id = 1
Speed: 0.861 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block issn AND journal_id = 1
Speed: 1.044 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block template AND setting_name = enabled AND journal_id = 1
Speed: 0.941 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = block template AND setting_name = enabled AND journal_id = 1
Speed: 0.863 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block template AND journal_id = 1
Speed: 0.903 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = menu bar AND setting_name = enabled AND journal_id = 1
Speed: 0.850 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = menu bar AND setting_name = enabled AND journal_id = 1
Speed: 0.869 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = menu bar AND journal_id = 1
Speed: 0.890 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = plagiat checker AND setting_name = enabled AND journal_id = 1
Speed: 0.871 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = plagiat checker AND setting_name = enabled AND journal_id = 1
Speed: 0.944 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = plagiat checker AND journal_id = 1
Speed: 0.962 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = member block AND setting_name = enabled AND journal_id = 1
Speed: 0.872 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = member block AND setting_name = enabled AND journal_id = 1
Speed: 0.915 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = member block AND journal_id = 1
Speed: 0.915 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = references block AND setting_name = enabled AND journal_id = 1
Speed: 0.948 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = references block AND setting_name = enabled AND journal_id = 1
Speed: 0.808 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = references block AND journal_id = 1
Speed: 0.916 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = sertifikat akreditasi AND setting_name = enabled AND journal_id = 1
Speed: 0.898 ms
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = sertifikat akreditasi AND setting_name = enabled AND journal_id = 1
Speed: 0.865 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = sertifikat akreditasi AND journal_id = 1
Speed: 0.910 ms
Speed: 1.247 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.970 ms
Speed: 0.954 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.911 ms
Speed: 1.010 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.840 ms
Speed: 1.013 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.875 ms
Speed: 0.908 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.863 ms
Speed: 1.484 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.986 ms
Speed: 1.005 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.869 ms