SELECT * FROM sessions WHERE session_id = pviq2v37cf8kohjsj89b579em4
Speed: 1.543 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data)
VALUES
(pviq2v37cf8kohjsj89b579em4, 18.222.125.171, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1713874632, 1713874632, 0,
Speed: 9.196 ms
|
SELECT * FROM journals WHERE path = tc
Speed: 0.994 ms
|
Speed: 0.848 ms
|
Speed: 2.199 ms
|
SELECT a.article_id AS pub_id,
COALESCE(atl.setting_value, atpl.setting_value) AS article_title
FROM published_articles pa,
issues i,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN article_settings atl ON (a.article_id = atl.article_id AND atl.setting_name = cleanTitle AND atl.locale = vi_VN)
LEFT JOIN article_settings atpl ON (a.article_id = atpl.article_id AND atpl.setting_name = cleanTitle AND atpl.locale = a.locale)
WHERE pa.article_id = a.article_id
AND i.issue_id = pa.issue_id
AND i.published = 1
AND s.section_id IS NOT NULL AND a.journal_id = 1
Speed: 37.607 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 662
Speed: 1.493 ms
|
Speed: 1.226 ms
|
SELECT * FROM article_settings WHERE article_id = 662
Speed: 0.989 ms
|
Speed: 0.933 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 662
Speed: 1.005 ms
|
SELECT * FROM article_settings WHERE article_id = 662
Speed: 0.626 ms
|
SELECT * FROM sections WHERE section_id = 2
Speed: 0.590 ms
|
SELECT * FROM section_settings WHERE section_id = 2
Speed: 0.625 ms
|
Speed: 0.502 ms
|
SELECT i.* FROM issues i WHERE issue_id = 33
Speed: 0.532 ms
|
SELECT * FROM issue_settings WHERE issue_id = 33
Speed: 0.849 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 662
Speed: 3.553 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 662
Speed: 0.921 ms
|
Speed: 0.728 ms
|
SELECT * FROM article_settings WHERE article_id = 662
Speed: 0.574 ms
|
Speed: 0.821 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.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.112 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.968 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 552
Speed: 0.997 ms
|
Speed: 0.654 ms
|
SELECT * FROM article_settings WHERE article_id = 552
Speed: 0.726 ms
|
Speed: 0.728 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 552
Speed: 0.921 ms
|
SELECT * FROM article_settings WHERE article_id = 552
Speed: 0.654 ms
|
SELECT i.* FROM issues i WHERE issue_id = 28
Speed: 0.734 ms
|
SELECT * FROM issue_settings WHERE issue_id = 28
Speed: 0.520 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 552
Speed: 4.415 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 552
Speed: 1.067 ms
|
Speed: 0.473 ms
|
SELECT * FROM article_settings WHERE article_id = 552
Speed: 0.760 ms
|
Speed: 0.637 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.689 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.719 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 521
Speed: 0.831 ms
|
Speed: 0.718 ms
|
SELECT * FROM article_settings WHERE article_id = 521
Speed: 0.741 ms
|
Speed: 0.639 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 521
Speed: 0.867 ms
|
SELECT * FROM article_settings WHERE article_id = 521
Speed: 0.694 ms
|
SELECT i.* FROM issues i WHERE issue_id = 25
Speed: 0.492 ms
|
SELECT * FROM issue_settings WHERE issue_id = 25
Speed: 0.573 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 521
Speed: 3.836 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 521
Speed: 0.975 ms
|
Speed: 0.724 ms
|
SELECT * FROM article_settings WHERE article_id = 521
Speed: 0.564 ms
|
Speed: 0.658 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.775 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.965 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 502
Speed: 0.988 ms
|
Speed: 0.697 ms
|
SELECT * FROM article_settings WHERE article_id = 502
Speed: 0.909 ms
|
Speed: 0.640 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 502
Speed: 0.987 ms
|
SELECT * FROM article_settings WHERE article_id = 502
Speed: 0.727 ms
|
SELECT i.* FROM issues i WHERE issue_id = 22
Speed: 0.454 ms
|
SELECT * FROM issue_settings WHERE issue_id = 22
Speed: 0.584 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 502
Speed: 3.733 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 502
Speed: 1.054 ms
|
Speed: 0.712 ms
|
SELECT * FROM article_settings WHERE article_id = 502
Speed: 0.744 ms
|
Speed: 0.666 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.716 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.806 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 28
Speed: 0.958 ms
|
Speed: 0.555 ms
|
SELECT * FROM article_settings WHERE article_id = 28
Speed: 0.638 ms
|
Speed: 0.611 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 28
Speed: 0.839 ms
|
SELECT * FROM article_settings WHERE article_id = 28
Speed: 0.648 ms
|
SELECT i.* FROM issues i WHERE issue_id = 1
Speed: 0.605 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1
Speed: 0.647 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 312
Speed: 0.982 ms
|
Speed: 0.528 ms
|
SELECT * FROM article_settings WHERE article_id = 312
Speed: 0.637 ms
|
Speed: 0.549 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 312
Speed: 0.900 ms
|
SELECT * FROM article_settings WHERE article_id = 312
Speed: 0.625 ms
|
SELECT i.* FROM issues i WHERE issue_id = 11
Speed: 0.479 ms
|
SELECT * FROM issue_settings WHERE issue_id = 11
Speed: 0.667 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 312
Speed: 3.473 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 312
Speed: 0.845 ms
|
Speed: 0.581 ms
|
SELECT * FROM article_settings WHERE article_id = 312
Speed: 0.584 ms
|
Speed: 0.628 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.696 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.783 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 48
Speed: 0.781 ms
|
Speed: 0.609 ms
|
SELECT * FROM article_settings WHERE article_id = 48
Speed: 0.564 ms
|
Speed: 0.593 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 48
Speed: 0.799 ms
|
SELECT * FROM article_settings WHERE article_id = 48
Speed: 0.485 ms
|
SELECT i.* FROM issues i WHERE issue_id = 2
Speed: 0.526 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2
Speed: 0.627 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 48
Speed: 3.050 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 48
Speed: 0.787 ms
|
Speed: 0.564 ms
|
SELECT * FROM article_settings WHERE article_id = 48
Speed: 0.569 ms
|
Speed: 0.544 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.661 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.743 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 345
Speed: 0.809 ms
|
Speed: 0.547 ms
|
SELECT * FROM article_settings WHERE article_id = 345
Speed: 0.571 ms
|
Speed: 0.543 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 345
Speed: 0.743 ms
|
SELECT * FROM article_settings WHERE article_id = 345
Speed: 0.594 ms
|
SELECT i.* FROM issues i WHERE issue_id = 13
Speed: 0.478 ms
|
SELECT * FROM issue_settings WHERE issue_id = 13
Speed: 0.517 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 345
Speed: 2.973 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 345
Speed: 0.790 ms
|
Speed: 0.500 ms
|
SELECT * FROM article_settings WHERE article_id = 345
Speed: 0.521 ms
|
Speed: 0.437 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.709 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.664 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 558
Speed: 0.675 ms
|
Speed: 0.425 ms
|
SELECT * FROM article_settings WHERE article_id = 558
Speed: 0.615 ms
|
Speed: 0.565 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 558
Speed: 0.799 ms
|
SELECT * FROM article_settings WHERE article_id = 558
Speed: 0.430 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 916
Speed: 0.837 ms
|
Speed: 0.508 ms
|
SELECT * FROM article_settings WHERE article_id = 916
Speed: 0.411 ms
|
Speed: 0.414 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 916
Speed: 0.486 ms
|
SELECT * FROM article_settings WHERE article_id = 916
Speed: 0.433 ms
|
SELECT i.* FROM issues i WHERE issue_id = 40
Speed: 0.431 ms
|
SELECT * FROM issue_settings WHERE issue_id = 40
Speed: 0.470 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 916
Speed: 2.850 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 916
Speed: 0.715 ms
|
Speed: 0.462 ms
|
SELECT * FROM article_settings WHERE article_id = 916
Speed: 0.480 ms
|
Speed: 0.545 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.535 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.623 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 551
Speed: 0.623 ms
|
Speed: 0.438 ms
|
SELECT * FROM article_settings WHERE article_id = 551
Speed: 0.470 ms
|
Speed: 0.471 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 551
Speed: 0.580 ms
|
SELECT * FROM article_settings WHERE article_id = 551
Speed: 0.466 ms
|
SELECT i.* FROM issues i WHERE issue_id = 14
Speed: 0.444 ms
|
SELECT * FROM issue_settings WHERE issue_id = 14
Speed: 0.438 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 551
Speed: 2.607 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 551
Speed: 0.543 ms
|
Speed: 0.351 ms
|
SELECT * FROM article_settings WHERE article_id = 551
Speed: 0.363 ms
|
Speed: 0.382 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.431 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.433 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 407
Speed: 0.586 ms
|
Speed: 0.492 ms
|
SELECT * FROM article_settings WHERE article_id = 407
Speed: 0.584 ms
|
Speed: 0.376 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 407
Speed: 0.504 ms
|
SELECT * FROM article_settings WHERE article_id = 407
Speed: 0.411 ms
|
SELECT i.* FROM issues i WHERE issue_id = 18
Speed: 0.332 ms
|
SELECT * FROM issue_settings WHERE issue_id = 18
Speed: 0.458 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 407
Speed: 2.112 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 407
Speed: 0.558 ms
|
Speed: 0.852 ms
|
SELECT * FROM article_settings WHERE article_id = 407
Speed: 0.414 ms
|
Speed: 0.393 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.434 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.569 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 457
Speed: 0.608 ms
|
Speed: 0.359 ms
|
SELECT * FROM article_settings WHERE article_id = 457
Speed: 0.481 ms
|
Speed: 0.449 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 457
Speed: 0.614 ms
|
SELECT * FROM article_settings WHERE article_id = 457
Speed: 0.401 ms
|
SELECT i.* FROM issues i WHERE issue_id = 24
Speed: 0.306 ms
|
SELECT * FROM issue_settings WHERE issue_id = 24
Speed: 0.436 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 457
Speed: 1.999 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 457
Speed: 0.643 ms
|
Speed: 0.370 ms
|
SELECT * FROM article_settings WHERE article_id = 457
Speed: 0.465 ms
|
Speed: 0.381 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.549 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.501 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 480
Speed: 0.645 ms
|
Speed: 0.428 ms
|
SELECT * FROM article_settings WHERE article_id = 480
Speed: 0.579 ms
|
Speed: 0.441 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 480
Speed: 0.627 ms
|
SELECT * FROM article_settings WHERE article_id = 480
Speed: 0.447 ms
|
SELECT i.* FROM issues i WHERE issue_id = 20
Speed: 0.363 ms
|
SELECT * FROM issue_settings WHERE issue_id = 20
Speed: 0.421 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 480
Speed: 2.312 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 480
Speed: 0.506 ms
|
Speed: 0.439 ms
|
SELECT * FROM article_settings WHERE article_id = 480
Speed: 0.420 ms
|
Speed: 0.435 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.511 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.504 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 279
Speed: 0.641 ms
|
Speed: 0.473 ms
|
SELECT * FROM article_settings WHERE article_id = 279
Speed: 0.462 ms
|
Speed: 0.376 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 279
Speed: 0.593 ms
|
SELECT * FROM article_settings WHERE article_id = 279
Speed: 0.462 ms
|
SELECT i.* FROM issues i WHERE issue_id = 9
Speed: 0.363 ms
|
SELECT * FROM issue_settings WHERE issue_id = 9
Speed: 0.361 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 279
Speed: 2.671 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 279
Speed: 0.661 ms
|
Speed: 0.478 ms
|
SELECT * FROM article_settings WHERE article_id = 279
Speed: 0.402 ms
|
Speed: 0.416 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.487 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.605 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 663
Speed: 0.641 ms
|
Speed: 0.397 ms
|
SELECT * FROM article_settings WHERE article_id = 663
Speed: 0.424 ms
|
Speed: 0.403 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 663
Speed: 0.490 ms
|
SELECT * FROM article_settings WHERE article_id = 663
Speed: 0.357 ms
|
SELECT i.* FROM issues i WHERE issue_id = 37
Speed: 0.384 ms
|
SELECT * FROM issue_settings WHERE issue_id = 37
Speed: 0.366 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 663
Speed: 4.171 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 663
Speed: 0.487 ms
|
Speed: 0.399 ms
|
SELECT * FROM article_settings WHERE article_id = 663
Speed: 0.397 ms
|
Speed: 0.475 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.436 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.505 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 508
Speed: 0.582 ms
|
Speed: 0.484 ms
|
SELECT * FROM article_settings WHERE article_id = 508
Speed: 0.419 ms
|
Speed: 0.455 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 508
Speed: 0.567 ms
|
SELECT * FROM article_settings WHERE article_id = 508
Speed: 0.391 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 447
Speed: 0.711 ms
|
Speed: 0.434 ms
|
SELECT * FROM article_settings WHERE article_id = 447
Speed: 0.577 ms
|
Speed: 0.558 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 447
Speed: 0.630 ms
|
SELECT * FROM article_settings WHERE article_id = 447
Speed: 0.507 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 274
Speed: 0.816 ms
|
Speed: 0.475 ms
|
SELECT * FROM article_settings WHERE article_id = 274
Speed: 0.506 ms
|
Speed: 0.378 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 274
Speed: 0.518 ms
|
SELECT * FROM article_settings WHERE article_id = 274
Speed: 0.596 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 872
Speed: 0.606 ms
|
Speed: 0.455 ms
|
SELECT * FROM article_settings WHERE article_id = 872
Speed: 0.572 ms
|
Speed: 0.368 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 872
Speed: 0.714 ms
|
SELECT * FROM article_settings WHERE article_id = 872
Speed: 0.581 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 29
Speed: 0.651 ms
|
Speed: 0.467 ms
|
SELECT * FROM article_settings WHERE article_id = 29
Speed: 0.475 ms
|
Speed: 0.553 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 29
Speed: 0.717 ms
|
SELECT * FROM article_settings WHERE article_id = 29
Speed: 0.584 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 534
Speed: 0.799 ms
|
Speed: 0.462 ms
|
SELECT * FROM article_settings WHERE article_id = 534
Speed: 0.458 ms
|
Speed: 0.488 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 534
Speed: 0.741 ms
|
SELECT * FROM article_settings WHERE article_id = 534
Speed: 0.589 ms
|
SELECT i.* FROM issues i WHERE issue_id = 23
Speed: 0.530 ms
|
SELECT * FROM issue_settings WHERE issue_id = 23
Speed: 0.432 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 330
Speed: 0.667 ms
|
Speed: 0.412 ms
|
SELECT * FROM article_settings WHERE article_id = 330
Speed: 0.439 ms
|
Speed: 0.624 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 330
Speed: 0.773 ms
|
SELECT * FROM article_settings WHERE article_id = 330
Speed: 0.489 ms
|
SELECT i.* FROM issues i WHERE issue_id = 12
Speed: 0.401 ms
|
SELECT * FROM issue_settings WHERE issue_id = 12
Speed: 0.469 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 330
Speed: 2.545 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 330
Speed: 0.566 ms
|
Speed: 0.335 ms
|
SELECT * FROM article_settings WHERE article_id = 330
Speed: 0.422 ms
|
Speed: 0.667 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-222-125-171.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-222-125-171.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.554 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316571051 >= isip.ip_start AND 316571051 <= 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-04-23 20:17:12' >= s.date_start AND '2024-04-23 20:17:12' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316571051 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.652 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 488
Speed: 0.686 ms
|
Speed: 0.519 ms
|
SELECT * FROM article_settings WHERE article_id = 488
Speed: 0.637 ms
|
Speed: 0.456 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 488
Speed: 0.527 ms
|
SELECT * FROM article_settings WHERE article_id = 488
Speed: 0.416 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE pa.article_id = a.article_id
AND a.article_id = 532
Speed: 0.644 ms
|
Speed: 0.520 ms
|
SELECT * FROM article_settings WHERE article_id = 532
Speed: 0.401 ms
|
Speed: 0.375 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = vi_VN)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = vi_VN)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = vi_VN)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = vi_VN)
WHERE article_id = 532
Speed: 0.560 ms
|
SELECT * FROM article_settings WHERE article_id = 532
Speed: 0.422 ms
|
SELECT i.* FROM issues i WHERE journal_id = 1
Speed: 0.394 ms
|
SELECT * FROM issue_settings WHERE issue_id = 40
Speed: 0.362 ms
|
SELECT i.* FROM issues i WHERE journal_id = 1
Speed: 0.797 ms
|
SELECT * FROM issue_settings WHERE issue_id = 40
Speed: 0.711 ms
|
Speed: 1.221 ms
|
SELECT * FROM author_settings WHERE author_id = 901
Speed: 0.786 ms
|
Speed: 0.542 ms
|
SELECT * FROM author_settings WHERE author_id = 761
Speed: 0.618 ms
|
Speed: 0.527 ms
|
SELECT * FROM author_settings WHERE author_id = 716
Speed: 0.514 ms
|
Speed: 0.590 ms
|
SELECT * FROM author_settings WHERE author_id = 691
Speed: 0.531 ms
|
Speed: 0.673 ms
|
SELECT * FROM author_settings WHERE author_id = 32
Speed: 0.688 ms
|
Speed: 0.607 ms
|
SELECT * FROM author_settings WHERE author_id = 368
Speed: 0.685 ms
|
Speed: 0.667 ms
|
SELECT * FROM author_settings WHERE author_id = 52
Speed: 0.730 ms
|
SELECT * FROM author_settings WHERE author_id = 53
Speed: 0.735 ms
|
Speed: 0.740 ms
|
SELECT * FROM author_settings WHERE author_id = 411
Speed: 0.571 ms
|
Speed: 0.597 ms
|
SELECT * FROM author_settings WHERE author_id = 770
Speed: 0.588 ms
|
Speed: 0.767 ms
|
SELECT * FROM author_settings WHERE author_id = 1219
Speed: 0.629 ms
|
SELECT * FROM author_settings WHERE author_id = 1282
Speed: 0.675 ms
|
SELECT * FROM author_settings WHERE author_id = 1283
Speed: 0.716 ms
|
Speed: 0.707 ms
|
SELECT * FROM author_settings WHERE author_id = 773
Speed: 0.580 ms
|
Speed: 0.633 ms
|
SELECT * FROM author_settings WHERE author_id = 516
Speed: 0.728 ms
|
Speed: 0.660 ms
|
SELECT * FROM author_settings WHERE author_id = 594
Speed: 0.639 ms
|
Speed: 0.660 ms
|
SELECT * FROM author_settings WHERE author_id = 646
Speed: 0.622 ms
|
SELECT * FROM author_settings WHERE author_id = 647
Speed: 0.661 ms
|
SELECT * FROM author_settings WHERE author_id = 648
Speed: 0.578 ms
|
Speed: 0.722 ms
|
SELECT * FROM author_settings WHERE author_id = 327
Speed: 0.566 ms
|
SELECT * FROM author_settings WHERE author_id = 328
Speed: 0.599 ms
|
Speed: 0.677 ms
|
SELECT * FROM author_settings WHERE author_id = 902
Speed: 0.579 ms
|
Speed: 0.643 ms
|
SELECT * FROM author_settings WHERE author_id = 700
Speed: 0.623 ms
|
Speed: 0.645 ms
|
SELECT * FROM author_settings WHERE author_id = 580
Speed: 0.525 ms
|
Speed: 0.607 ms
|
SELECT * FROM author_settings WHERE author_id = 322
Speed: 0.534 ms
|
Speed: 0.644 ms
|
SELECT * FROM author_settings WHERE author_id = 1149
Speed: 0.669 ms
|
Speed: 0.609 ms
|
SELECT * FROM author_settings WHERE author_id = 33
Speed: 0.578 ms
|
Speed: 0.696 ms
|
SELECT * FROM author_settings WHERE author_id = 739
Speed: 0.553 ms
|
Speed: 0.634 ms
|
SELECT * FROM author_settings WHERE author_id = 395
Speed: 0.662 ms
|
SELECT * FROM author_settings WHERE author_id = 396
Speed: 0.740 ms
|
Speed: 0.707 ms
|
SELECT * FROM author_settings WHERE author_id = 660
Speed: 0.683 ms
|
SELECT * FROM author_settings WHERE author_id = 661
Speed: 0.607 ms
|
Speed: 0.692 ms
|
SELECT * FROM author_settings WHERE author_id = 732
Speed: 0.604 ms
|
SELECT * FROM author_settings WHERE author_id = 733
Speed: 0.728 ms
|
SELECT * FROM author_settings WHERE author_id = 734
Speed: 0.677 ms
|