|
SELECT * FROM sessions WHERE session_id = 6u0ts604vmonpas8humi629vr2
Speed: 1.051 ms
|
|
DELETE FROM sessions WHERE (last_used < 1794069308 AND remember = 0) OR (last_used < 1791563708
Speed: 28.545 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(6u0ts604vmonpas8humi629vr2, 18.97.9.170, CCBot/2.0 (https://commoncrawl.org/faq/), 1794155708, 1794155708, 0, , abdimasku.lppm.dinus.ac.id
Speed: 2.384 ms
|
|
SELECT * FROM journals WHERE path = jp
Speed: 0.478 ms
|
|
Speed: 0.311 ms
|
|
Speed: 1.707 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = customthemeplugin AND journal_id = 4
Speed: 0.817 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.409 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.277 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.287 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.237 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.218 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.241 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.304 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.232 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.242 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 = 4
AND (aa.last_name IS NOT NULL AND aa.last_name <> '')
AND ((s.hide_author = 0 AND a.hide_author = 0) OR a.hide_author = 2)
AND LOWER(aa.last_name) LIKE LOWER(z%
Speed: 3.261 ms
|
|
Speed: 0.554 ms
|