|
SELECT * FROM sessions WHERE session_id = g6vmnpr525gi02a51if6l3ct37
Speed: 0.452 ms
|
|
DELETE FROM sessions WHERE (last_used < 1791541832 AND remember = 0) OR (last_used < 1789036232
Speed: 797.468 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(g6vmnpr525gi02a51if6l3ct37, 18.97.14.88, CCBot/2.0 (https://commoncrawl.org/faq/), 1791628232, 1791628232, 0, , abdimasku.lppm.dinus.ac.id
Speed: 30.095 ms
|
|
SELECT * FROM journals WHERE path = te
Speed: 0.705 ms
|
|
Speed: 0.551 ms
|
|
Speed: 1.457 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.350 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.223 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.192 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.184 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.172 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.686 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.439 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.371 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.367 ms
|
|
SELECT DISTINCT
CAST('' AS CHAR) AS url,
0 AS author_id,
0 AS submission_id,
CAST('' AS CHAR) AS email,
0 AS primary_contact,
0 AS seq,
aa.first_name,
aa.middle_name,
aa.last_name,
CASE WHEN asl.setting_value = '' THEN NULL ELSE SUBSTRING(asl.setting_value FROM 1 FOR 255) END AS affiliation_l,
CASE WHEN asl.setting_value = '' THEN NULL ELSE asl.locale END AS locale,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE SUBSTRING(aspl.setting_value FROM 1 FOR 255) END AS affiliation_pl,
CASE WHEN aspl.setting_value = '' THEN NULL ELSE aspl.locale END AS primary_locale,
CASE WHEN aa.country = '' THEN NULL ELSE aa.country END AS country
FROM authors aa
LEFT JOIN author_settings aspl ON (aa.author_id = aspl.author_id AND aspl.setting_name = affiliation AND aspl.locale = en_US)
LEFT JOIN author_settings asl ON (aa.author_id = asl.author_id AND asl.setting_name = affiliation AND asl.locale = en_US)
JOIN articles a ON (a.article_id = aa.submission_id AND a.status = 3)
JOIN published_articles pa ON (pa.article_id = a.article_id)
JOIN issues i ON (pa.issue_id = i.issue_id AND i.published = 1)
JOIN sections s ON (a.section_id = s.section_id)
JOIN journals j ON (a.journal_id = j.journal_id)
WHERE a.journal_id = 3
|
