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 = 1ljcrjg6i34s93mae6qjn74vi3
Speed: 2.394 ms
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(1ljcrjg6i34s93mae6qjn74vi3, 3.141.38.5, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1732764950, 1732764950, 0, , jab1.fe.uns.ac.id
Speed: 8.056 ms
SELECT * FROM journals WHERE path = ja
Speed: 1.395 ms
Speed: 1.250 ms
Speed: 2.583 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.588 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 1.024 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.861 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.760 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.748 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.816 ms
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.797 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.533 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.711 ms
Speed: 1.378 ms
SELECT * FROM article_settings WHERE article_id = 3
Speed: 1.203 ms
Speed: 1.022 ms
SELECT i.* FROM issues i WHERE issue_id = 1
Speed: 1.251 ms
SELECT * FROM issue_settings WHERE issue_id = 1
Speed: 1.209 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-3-141-38-5.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-141-38-5.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.026 ms
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 59581957 >= isip.ip_start AND 59581957 <= 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 10:35:50' >= s.date_start AND '2024-11-28 10:35:50' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 59581957 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.700 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 1.295 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 1.181 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 1.230 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.959 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: 1.051 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.261 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.655 ms
Speed: 1.231 ms
SELECT * FROM article_settings WHERE article_id = 3
Speed: 1.251 ms
Speed: 1.112 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-3-141-38-5.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-141-38-5.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.403 ms
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 59581957 >= isip.ip_start AND 59581957 <= 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 10:35:50' >= s.date_start AND '2024-11-28 10:35:50' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 59581957 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.429 ms
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 3 AND citation_state >= 0 AND citation_state <= 5
Speed: 1.108 ms
SELECT * FROM sections WHERE section_id = 1
Speed: 0.909 ms
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.915 ms
Speed: 2.491 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block visitor AND setting_name = enabled AND journal_id = 1
Speed: 1.258 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.963 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block visitor AND journal_id = 1
Speed: 1.062 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block indexed AND setting_name = enabled AND journal_id = 1
Speed: 0.988 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: 0.905 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block indexed AND journal_id = 1
Speed: 1.059 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block issn 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 issn AND setting_name = enabled AND journal_id = 1
Speed: 0.933 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block issn AND journal_id = 1
Speed: 0.992 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = block template AND setting_name = enabled AND journal_id = 1
Speed: 1.060 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: 1.022 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = block template AND journal_id = 1
Speed: 1.151 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = menu bar AND setting_name = enabled AND journal_id = 1
Speed: 1.027 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.874 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = menu bar AND journal_id = 1
Speed: 0.965 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = plagiat checker AND setting_name = enabled AND journal_id = 1
Speed: 1.015 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.977 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = plagiat checker AND journal_id = 1
Speed: 1.056 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = member block AND setting_name = enabled AND journal_id = 1
Speed: 0.997 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.978 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = member block AND journal_id = 1
Speed: 1.296 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = references block AND setting_name = enabled AND journal_id = 1
Speed: 1.016 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: 1.339 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = references block AND journal_id = 1
Speed: 0.987 ms
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = sertifikat akreditasi AND setting_name = enabled AND journal_id = 1
Speed: 1.032 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.961 ms
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = sertifikat akreditasi AND journal_id = 1
Speed: 0.970 ms
Speed: 1.414 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.178 ms
Speed: 1.102 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 0.998 ms
Speed: 1.171 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.018 ms
Speed: 1.147 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.081 ms
Speed: 1.182 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.095 ms
Speed: 1.314 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.211 ms
Speed: 1.010 ms
SELECT * FROM author_settings WHERE author_id = 3
Speed: 1.012 ms