|
SELECT * FROM sessions WHERE session_id = 8j628j36u93u3u3ggt2656fci2
Speed: 0.637 ms
|
|
DELETE FROM sessions WHERE (last_used < 1784133627 AND remember = 0) OR (last_used < 1781628027
Speed: 100.697 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(8j628j36u93u3u3ggt2656fci2, 18.97.9.174, CCBot/2.0 (https://commoncrawl.org/faq/), 1784220027, 1784220027, 0, , abdimasku.lppm.dinus.ac.id
Speed: 6.631 ms
|
|
SELECT * FROM journals WHERE path = ju
Speed: 0.762 ms
|
|
Speed: 0.542 ms
|
|
Speed: 2.617 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.454 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.321 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.233 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.262 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.213 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.209 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.221 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.217 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.228 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 = 3065
Speed: 2.127 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 = 3065
Speed: 1.137 ms
|
|
Speed: 0.757 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 804
Speed: 0.373 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3065
Speed: 0.304 ms
|
|
Speed: 0.321 ms
|
|
SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = pub-id::publisher-id AND ist.setting_value = 74
Speed: 0.433 ms
|
|
Speed: 0.235 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 74
Speed: 0.309 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(18-97-9-174.crawl.commoncrawl.org, LENGTH(18-97-9-174.crawl.commoncrawl.org)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.473 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 308349358 >= isip.ip_start AND 308349358 <= 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 ('2026-07-16 16:40:27' >= s.date_start AND '2026-07-16 16:40:27' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 308349358 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.409 ms
|
|
SELECT * FROM sections WHERE section_id = 1
Speed: 0.247 ms
|
|
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.194 ms
|
|
SELECT * FROM sections WHERE section_id = 1
Speed: 0.206 ms
|
|
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.183 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 = 3065
Speed: 0.183 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 = 3065
Speed: 0.659 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 = 3065
Speed: 0.338 ms
|
|
Speed: 0.253 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 804
Speed: 0.210 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3065
Speed: 0.200 ms
|
|
Speed: 0.207 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(18-97-9-174.crawl.commoncrawl.org, LENGTH(18-97-9-174.crawl.commoncrawl.org)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.313 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 308349358 >= isip.ip_start AND 308349358 <= 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 ('2026-07-16 16:40:27' >= s.date_start AND '2026-07-16 16:40:27' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 308349358 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.320 ms
|
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 3065 AND citation_state >= 0 AND citation_state <= 5
Speed: 0.285 ms
|
|
SELECT * FROM sections WHERE section_id = 1
Speed: 0.170 ms
|
|
SELECT * FROM section_settings WHERE section_id = 1
Speed: 0.181 ms
|
|
Speed: 1.076 ms
|
|
Speed: 0.372 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 80
Speed: 0.239 ms
|
|
Speed: 0.459 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6498
Speed: 0.319 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6702
Speed: 0.244 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6703
Speed: 0.226 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6704
Speed: 0.561 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6705
Speed: 0.429 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6706
Speed: 0.335 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6707
Speed: 0.368 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6708
Speed: 0.312 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6709
Speed: 0.301 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6710
Speed: 0.290 ms
|
|
Speed: 0.590 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6498
Speed: 0.521 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6702
Speed: 0.333 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6703
Speed: 0.311 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6704
Speed: 0.293 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6705
Speed: 0.290 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6706
Speed: 0.309 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6707
Speed: 0.284 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6708
Speed: 0.304 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6709
Speed: 0.284 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6710
Speed: 0.295 ms
|
|
Speed: 0.367 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6498
Speed: 0.520 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6702
Speed: 0.342 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6703
Speed: 0.308 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6704
Speed: 0.292 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6705
Speed: 0.314 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6706
Speed: 0.357 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6707
Speed: 0.352 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6708
Speed: 0.292 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6709
Speed: 0.285 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6710
Speed: 0.285 ms
|
|
Speed: 0.568 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6498
Speed: 0.349 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6702
Speed: 0.317 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6703
Speed: 0.299 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6704
Speed: 0.290 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6705
Speed: 0.298 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6706
Speed: 0.296 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6707
Speed: 0.302 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6708
Speed: 0.284 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6709
Speed: 0.280 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6710
Speed: 0.365 ms
|
|
Speed: 0.672 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6498
Speed: 0.377 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6702
Speed: 0.322 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6703
Speed: 0.307 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6704
Speed: 0.314 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6705
Speed: 0.289 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6706
Speed: 0.285 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6707
Speed: 0.296 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6708
Speed: 0.288 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6709
Speed: 0.301 ms
|
|
SELECT * FROM author_settings WHERE author_id = 6710
Speed: 0.281 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16621
Speed: 0.292 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16621
Speed: 0.356 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16622
Speed: 0.466 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16622
Speed: 0.362 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16623
Speed: 0.317 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16623
Speed: 0.323 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16624
Speed: 0.354 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16624
Speed: 0.300 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16625
Speed: 0.284 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16625
Speed: 0.281 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16626
Speed: 0.275 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16626
Speed: 0.272 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16627
Speed: 0.397 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16627
Speed: 0.379 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16628
Speed: 0.392 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16628
Speed: 0.305 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16629
Speed: 0.374 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16629
Speed: 0.309 ms
|
|
SELECT * FROM citation_settings WHERE citation_id = 16630
Speed: 0.328 ms
|
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 16630
Speed: 0.269 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 = 3065
Speed: 1.129 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 = 3065
Speed: 0.621 ms
|
|
Speed: 0.466 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 804
Speed: 0.347 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3065
Speed: 0.344 ms
|
|
Speed: 0.379 ms
|
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 3065 AND
r.status = 2
Speed: 0.339 ms
|