SELECT * FROM sessions WHERE session_id = bh7rvisd89mmhmgq1c7hdk5j37
Speed: 0.785 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(bh7rvisd89mmhmgq1c7hdk5j37, 34.238.189.240, CCBot/2.0 (https://commoncrawl.org/faq/), 1679677267, 1679677267, 0, , ejournal2.unib.ac.id
Speed: 2.740 ms
|
SELECT * FROM journals WHERE path = po
Speed: 0.239 ms
|
Speed: 0.191 ms
|
Speed: 0.490 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.254 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.197 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.203 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.178 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.179 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.178 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.180 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.175 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.172 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
JOIN journals j ON (a.journal_id = j.journal_id)
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 = en_US)
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 = 110
Speed: 16.263 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5656
Speed: 1.160 ms
|
Speed: 1.014 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2755
Speed: 0.408 ms
|
SELECT * FROM article_settings WHERE article_id = 5656
Speed: 0.443 ms
|
Speed: 0.473 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5656
Speed: 0.677 ms
|
SELECT * FROM article_settings WHERE article_id = 5656
Speed: 0.223 ms
|
SELECT * FROM sections WHERE section_id = 143
Speed: 0.193 ms
|
SELECT * FROM section_settings WHERE section_id = 143
Speed: 0.165 ms
|
Speed: 0.162 ms
|
Speed: 0.167 ms
|
SELECT * FROM issue_settings WHERE issue_id = 499
Speed: 0.183 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5657
Speed: 0.302 ms
|
Speed: 0.203 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2756
Speed: 0.174 ms
|
SELECT * FROM article_settings WHERE article_id = 5657
Speed: 0.184 ms
|
Speed: 0.162 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5657
Speed: 0.713 ms
|
SELECT * FROM article_settings WHERE article_id = 5657
Speed: 0.206 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5660
Speed: 0.869 ms
|
Speed: 0.544 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2757
Speed: 0.353 ms
|
SELECT * FROM article_settings WHERE article_id = 5660
Speed: 0.414 ms
|
Speed: 0.443 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5660
Speed: 0.668 ms
|
SELECT * FROM article_settings WHERE article_id = 5660
Speed: 0.200 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5661
Speed: 0.730 ms
|
Speed: 0.576 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2758
Speed: 0.371 ms
|
SELECT * FROM article_settings WHERE article_id = 5661
Speed: 0.397 ms
|
Speed: 0.433 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5661
Speed: 0.747 ms
|
SELECT * FROM article_settings WHERE article_id = 5661
Speed: 0.210 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5662
Speed: 0.815 ms
|
Speed: 0.572 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2759
Speed: 0.385 ms
|
SELECT * FROM article_settings WHERE article_id = 5662
Speed: 0.429 ms
|
Speed: 0.446 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5662
Speed: 0.666 ms
|
SELECT * FROM article_settings WHERE article_id = 5662
Speed: 0.204 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5665
Speed: 0.767 ms
|
Speed: 0.566 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2761
Speed: 0.433 ms
|
SELECT * FROM article_settings WHERE article_id = 5665
Speed: 0.431 ms
|
Speed: 0.467 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5665
Speed: 0.674 ms
|
SELECT * FROM article_settings WHERE article_id = 5665
Speed: 0.208 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5666
Speed: 0.269 ms
|
Speed: 0.199 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2762
Speed: 0.191 ms
|
SELECT * FROM article_settings WHERE article_id = 5666
Speed: 0.191 ms
|
Speed: 0.178 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5666
Speed: 0.635 ms
|
SELECT * FROM article_settings WHERE article_id = 5666
Speed: 0.212 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5668
Speed: 0.254 ms
|
Speed: 0.201 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2763
Speed: 0.220 ms
|
SELECT * FROM article_settings WHERE article_id = 5668
Speed: 0.188 ms
|
Speed: 0.184 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5668
Speed: 0.650 ms
|
SELECT * FROM article_settings WHERE article_id = 5668
Speed: 0.220 ms
|
Speed: 0.187 ms
|
SELECT * FROM issue_settings WHERE issue_id = 502
Speed: 0.194 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5670
Speed: 0.727 ms
|
Speed: 0.657 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2764
Speed: 0.412 ms
|
SELECT * FROM article_settings WHERE article_id = 5670
Speed: 0.478 ms
|
Speed: 0.481 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5670
Speed: 0.750 ms
|
SELECT * FROM article_settings WHERE article_id = 5670
Speed: 0.213 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5671
Speed: 0.786 ms
|
Speed: 0.584 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2765
Speed: 0.382 ms
|
SELECT * FROM article_settings WHERE article_id = 5671
Speed: 0.488 ms
|
Speed: 0.484 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5671
Speed: 0.691 ms
|
SELECT * FROM article_settings WHERE article_id = 5671
Speed: 0.207 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5676
Speed: 0.695 ms
|
Speed: 0.581 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2767
Speed: 0.418 ms
|
SELECT * FROM article_settings WHERE article_id = 5676
Speed: 0.415 ms
|
Speed: 0.472 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5676
Speed: 0.698 ms
|
SELECT * FROM article_settings WHERE article_id = 5676
Speed: 0.199 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5679
Speed: 0.715 ms
|
Speed: 0.561 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2768
Speed: 0.391 ms
|
SELECT * FROM article_settings WHERE article_id = 5679
Speed: 0.446 ms
|
Speed: 0.534 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5679
Speed: 0.672 ms
|
SELECT * FROM article_settings WHERE article_id = 5679
Speed: 0.199 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5680
Speed: 0.871 ms
|
Speed: 0.537 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2769
Speed: 0.357 ms
|
SELECT * FROM article_settings WHERE article_id = 5680
Speed: 0.414 ms
|
Speed: 0.465 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5680
Speed: 0.673 ms
|
SELECT * FROM article_settings WHERE article_id = 5680
Speed: 0.196 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5681
Speed: 0.686 ms
|
Speed: 0.599 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2770
Speed: 0.372 ms
|
SELECT * FROM article_settings WHERE article_id = 5681
Speed: 0.407 ms
|
Speed: 0.466 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5681
Speed: 0.700 ms
|
SELECT * FROM article_settings WHERE article_id = 5681
Speed: 0.215 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5682
Speed: 0.726 ms
|
Speed: 0.548 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2771
Speed: 0.381 ms
|
SELECT * FROM article_settings WHERE article_id = 5682
Speed: 0.484 ms
|
Speed: 0.500 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5682
Speed: 0.683 ms
|
SELECT * FROM article_settings WHERE article_id = 5682
Speed: 0.207 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5683
Speed: 0.756 ms
|
Speed: 0.534 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2772
Speed: 0.368 ms
|
SELECT * FROM article_settings WHERE article_id = 5683
Speed: 0.441 ms
|
Speed: 0.472 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5683
Speed: 0.749 ms
|
SELECT * FROM article_settings WHERE article_id = 5683
Speed: 0.211 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5684
Speed: 0.769 ms
|
Speed: 0.532 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2773
Speed: 0.385 ms
|
SELECT * FROM article_settings WHERE article_id = 5684
Speed: 0.435 ms
|
Speed: 0.452 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5684
Speed: 0.677 ms
|
SELECT * FROM article_settings WHERE article_id = 5684
Speed: 0.219 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5796
Speed: 0.811 ms
|
Speed: 0.709 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2803
Speed: 0.438 ms
|
SELECT * FROM article_settings WHERE article_id = 5796
Speed: 0.545 ms
|
Speed: 0.477 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5796
Speed: 0.699 ms
|
SELECT * FROM article_settings WHERE article_id = 5796
Speed: 0.223 ms
|
Speed: 0.350 ms
|
SELECT * FROM issue_settings WHERE issue_id = 434
Speed: 0.428 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 17313
Speed: 0.287 ms
|
Speed: 0.208 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8630
Speed: 0.183 ms
|
SELECT * FROM article_settings WHERE article_id = 17313
Speed: 0.187 ms
|
Speed: 0.204 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3506
Speed: 0.189 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 17313
Speed: 0.800 ms
|
SELECT * FROM article_settings WHERE article_id = 17313
Speed: 0.284 ms
|
Speed: 0.260 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1132
Speed: 0.209 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 16871
Speed: 0.864 ms
|
Speed: 0.836 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8581
Speed: 0.510 ms
|
SELECT * FROM article_settings WHERE article_id = 16871
Speed: 0.810 ms
|
Speed: 0.547 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 16871
Speed: 0.796 ms
|
SELECT * FROM article_settings WHERE article_id = 16871
Speed: 0.216 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 15940
Speed: 0.283 ms
|
Speed: 0.215 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8586
Speed: 0.183 ms
|
SELECT * FROM article_settings WHERE article_id = 15940
Speed: 0.188 ms
|
Speed: 0.174 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 15940
Speed: 0.732 ms
|
SELECT * FROM article_settings WHERE article_id = 15940
Speed: 0.205 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 16063
Speed: 0.911 ms
|
Speed: 0.622 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8160
Speed: 0.415 ms
|
SELECT * FROM article_settings WHERE article_id = 16063
Speed: 0.554 ms
|
Speed: 0.473 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 16063
Speed: 0.779 ms
|
SELECT * FROM article_settings WHERE article_id = 16063
Speed: 0.248 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 8188
Speed: 0.256 ms
|
Speed: 0.201 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5800
Speed: 0.200 ms
|
SELECT * FROM article_settings WHERE article_id = 8188
Speed: 0.207 ms
|
Speed: 0.188 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1019
Speed: 0.207 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 8188
Speed: 0.790 ms
|
SELECT * FROM article_settings WHERE article_id = 8188
Speed: 0.211 ms
|
Speed: 0.187 ms
|
SELECT * FROM issue_settings WHERE issue_id = 803
Speed: 0.359 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 14163
Speed: 0.802 ms
|
Speed: 0.602 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8132
Speed: 0.435 ms
|
SELECT * FROM article_settings WHERE article_id = 14163
Speed: 0.406 ms
|
Speed: 0.508 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 14163
Speed: 0.739 ms
|
SELECT * FROM article_settings WHERE article_id = 14163
Speed: 0.196 ms
|
Speed: 0.260 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1015
Speed: 0.198 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 13152
Speed: 0.266 ms
|
Speed: 0.223 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6516
Speed: 0.189 ms
|
SELECT * FROM article_settings WHERE article_id = 13152
Speed: 0.194 ms
|
Speed: 0.180 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 13152
Speed: 0.690 ms
|
SELECT * FROM article_settings WHERE article_id = 13152
Speed: 0.236 ms
|
Speed: 0.176 ms
|
SELECT * FROM issue_settings WHERE issue_id = 919
Speed: 0.179 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6155
Speed: 0.275 ms
|
Speed: 0.195 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3491
Speed: 0.181 ms
|
SELECT * FROM article_settings WHERE article_id = 6155
Speed: 0.202 ms
|
Speed: 0.176 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 630
Speed: 0.188 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6155
Speed: 0.743 ms
|
SELECT * FROM article_settings WHERE article_id = 6155
Speed: 0.232 ms
|
Speed: 0.183 ms
|
SELECT * FROM issue_settings WHERE issue_id = 603
Speed: 0.186 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 10336
Speed: 1.081 ms
|
Speed: 0.698 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6520
Speed: 0.458 ms
|
SELECT * FROM article_settings WHERE article_id = 10336
Speed: 0.463 ms
|
Speed: 0.726 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1529
Speed: 0.563 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 10336
Speed: 0.847 ms
|
SELECT * FROM article_settings WHERE article_id = 10336
Speed: 0.227 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6153
Speed: 0.786 ms
|
Speed: 0.603 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3492
Speed: 0.404 ms
|
SELECT * FROM article_settings WHERE article_id = 6153
Speed: 0.445 ms
|
Speed: 0.520 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 628
Speed: 0.394 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6153
Speed: 0.662 ms
|
SELECT * FROM article_settings WHERE article_id = 6153
Speed: 0.200 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 13151
Speed: 0.293 ms
|
Speed: 0.199 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6518
Speed: 0.193 ms
|
SELECT * FROM article_settings WHERE article_id = 13151
Speed: 0.195 ms
|
Speed: 0.171 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 13151
Speed: 0.735 ms
|
SELECT * FROM article_settings WHERE article_id = 13151
Speed: 0.229 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 16989
Speed: 0.307 ms
|
Speed: 0.206 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8377
Speed: 0.198 ms
|
SELECT * FROM article_settings WHERE article_id = 16989
Speed: 0.195 ms
|
Speed: 0.179 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 16989
Speed: 0.680 ms
|
SELECT * FROM article_settings WHERE article_id = 16989
Speed: 0.207 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 16001
Speed: 0.891 ms
|
Speed: 0.708 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8157
Speed: 0.424 ms
|
SELECT * FROM article_settings WHERE article_id = 16001
Speed: 0.571 ms
|
Speed: 0.480 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 16001
Speed: 0.772 ms
|
SELECT * FROM article_settings WHERE article_id = 16001
Speed: 0.202 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 21502
Speed: 0.247 ms
|
Speed: 0.232 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10503
Speed: 0.185 ms
|
SELECT * FROM article_settings WHERE article_id = 21502
Speed: 0.194 ms
|
Speed: 0.193 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 21502
Speed: 0.762 ms
|
SELECT * FROM article_settings WHERE article_id = 21502
Speed: 0.214 ms
|
Speed: 0.211 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1397
Speed: 0.198 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 8643
Speed: 0.751 ms
|
Speed: 0.674 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5985
Speed: 0.396 ms
|
SELECT * FROM article_settings WHERE article_id = 8643
Speed: 0.467 ms
|
Speed: 0.599 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1203
Speed: 0.433 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 8643
Speed: 0.679 ms
|
SELECT * FROM article_settings WHERE article_id = 8643
Speed: 0.205 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 3710
Speed: 0.725 ms
|
Speed: 0.695 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1958
Speed: 0.415 ms
|
SELECT * FROM article_settings WHERE article_id = 3710
Speed: 0.412 ms
|
Speed: 0.510 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 3710
Speed: 0.715 ms
|
SELECT * FROM article_settings WHERE article_id = 3710
Speed: 0.196 ms
|
Speed: 0.417 ms
|
SELECT * FROM issue_settings WHERE issue_id = 314
Speed: 0.425 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 2848
Speed: 0.752 ms
|
Speed: 0.702 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2687
Speed: 0.391 ms
|
SELECT * FROM article_settings WHERE article_id = 2848
Speed: 0.665 ms
|
Speed: 0.532 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 2848
Speed: 0.716 ms
|
SELECT * FROM article_settings WHERE article_id = 2848
Speed: 0.197 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6152
Speed: 0.797 ms
|
Speed: 0.632 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3530
Speed: 0.394 ms
|
SELECT * FROM article_settings WHERE article_id = 6152
Speed: 0.459 ms
|
Speed: 0.504 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 629
Speed: 0.423 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6152
Speed: 0.740 ms
|
SELECT * FROM article_settings WHERE article_id = 6152
Speed: 0.202 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 3576
Speed: 0.244 ms
|
Speed: 0.214 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3434
Speed: 0.222 ms
|
SELECT * FROM article_settings WHERE article_id = 3576
Speed: 0.205 ms
|
Speed: 0.177 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 3576
Speed: 0.757 ms
|
SELECT * FROM article_settings WHERE article_id = 3576
Speed: 0.219 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 14162
Speed: 0.888 ms
|
Speed: 0.745 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7167
Speed: 0.420 ms
|
SELECT * FROM article_settings WHERE article_id = 14162
Speed: 0.468 ms
|
Speed: 0.475 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 14162
Speed: 0.868 ms
|
SELECT * FROM article_settings WHERE article_id = 14162
Speed: 0.223 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 2965
Speed: 0.790 ms
|
Speed: 0.682 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3200
Speed: 0.439 ms
|
SELECT * FROM article_settings WHERE article_id = 2965
Speed: 0.655 ms
|
Speed: 0.504 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 2965
Speed: 0.776 ms
|
SELECT * FROM article_settings WHERE article_id = 2965
Speed: 0.219 ms
|
Speed: 0.186 ms
|
SELECT * FROM issue_settings WHERE issue_id = 512
Speed: 0.194 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 3718
Speed: 0.779 ms
|
Speed: 0.573 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1966
Speed: 0.424 ms
|
SELECT * FROM article_settings WHERE article_id = 3718
Speed: 0.424 ms
|
Speed: 0.473 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 = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 3718
Speed: 0.649 ms
|
SELECT * FROM article_settings WHERE article_id = 3718
Speed: 0.200 ms
|
Speed: 0.216 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1397
Speed: 0.203 ms
|
Speed: 0.367 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1397
Speed: 0.248 ms
|
Speed: 0.996 ms
|
SELECT * FROM author_settings WHERE author_id = 11136
Speed: 0.509 ms
|
SELECT * FROM author_settings WHERE author_id = 11137
Speed: 0.376 ms
|
SELECT * FROM author_settings WHERE author_id = 11138
Speed: 0.365 ms
|
Speed: 0.244 ms
|
SELECT * FROM author_settings WHERE author_id = 11139
Speed: 0.243 ms
|
SELECT * FROM author_settings WHERE author_id = 11140
Speed: 0.179 ms
|
SELECT * FROM author_settings WHERE author_id = 11141
Speed: 0.172 ms
|
Speed: 0.581 ms
|
SELECT * FROM author_settings WHERE author_id = 11148
Speed: 0.485 ms
|
SELECT * FROM author_settings WHERE author_id = 11149
Speed: 0.408 ms
|
SELECT * FROM author_settings WHERE author_id = 11150
Speed: 0.357 ms
|
Speed: 0.496 ms
|
SELECT * FROM author_settings WHERE author_id = 11151
Speed: 0.395 ms
|
SELECT * FROM author_settings WHERE author_id = 11152
Speed: 0.360 ms
|
SELECT * FROM author_settings WHERE author_id = 11153
Speed: 0.343 ms
|
Speed: 0.577 ms
|
SELECT * FROM author_settings WHERE author_id = 11154
Speed: 0.394 ms
|
SELECT * FROM author_settings WHERE author_id = 11155
Speed: 0.437 ms
|
SELECT * FROM author_settings WHERE author_id = 11156
Speed: 0.359 ms
|
Speed: 0.550 ms
|
SELECT * FROM author_settings WHERE author_id = 11161
Speed: 0.356 ms
|
SELECT * FROM author_settings WHERE author_id = 11162
Speed: 0.325 ms
|
SELECT * FROM author_settings WHERE author_id = 11163
Speed: 0.320 ms
|
Speed: 0.215 ms
|
SELECT * FROM author_settings WHERE author_id = 11164
Speed: 0.705 ms
|
SELECT * FROM author_settings WHERE author_id = 11165
Speed: 0.176 ms
|
SELECT * FROM author_settings WHERE author_id = 11166
Speed: 0.173 ms
|
Speed: 0.211 ms
|
SELECT * FROM author_settings WHERE author_id = 11168
Speed: 0.179 ms
|
SELECT * FROM author_settings WHERE author_id = 11169
Speed: 0.165 ms
|
SELECT * FROM author_settings WHERE author_id = 11170
Speed: 0.168 ms
|
Speed: 0.482 ms
|
SELECT * FROM author_settings WHERE author_id = 11172
Speed: 0.361 ms
|
SELECT * FROM author_settings WHERE author_id = 11173
Speed: 0.322 ms
|
SELECT * FROM author_settings WHERE author_id = 11174
Speed: 0.324 ms
|
Speed: 0.437 ms
|
SELECT * FROM author_settings WHERE author_id = 11175
Speed: 0.336 ms
|
SELECT * FROM author_settings WHERE author_id = 11176
Speed: 0.324 ms
|
SELECT * FROM author_settings WHERE author_id = 11177
Speed: 0.327 ms
|
Speed: 0.641 ms
|
SELECT * FROM author_settings WHERE author_id = 11184
Speed: 0.518 ms
|
SELECT * FROM author_settings WHERE author_id = 11185
Speed: 0.357 ms
|
SELECT * FROM author_settings WHERE author_id = 11186
Speed: 0.387 ms
|
Speed: 0.519 ms
|
SELECT * FROM author_settings WHERE author_id = 11192
Speed: 0.398 ms
|
SELECT * FROM author_settings WHERE author_id = 11193
Speed: 0.365 ms
|
SELECT * FROM author_settings WHERE author_id = 11194
Speed: 0.361 ms
|
Speed: 0.511 ms
|
SELECT * FROM author_settings WHERE author_id = 11195
Speed: 0.368 ms
|
SELECT * FROM author_settings WHERE author_id = 11196
Speed: 0.336 ms
|
SELECT * FROM author_settings WHERE author_id = 11197
Speed: 0.347 ms
|
Speed: 0.518 ms
|
SELECT * FROM author_settings WHERE author_id = 11198
Speed: 0.381 ms
|
SELECT * FROM author_settings WHERE author_id = 11199
Speed: 0.334 ms
|
SELECT * FROM author_settings WHERE author_id = 11200
Speed: 0.382 ms
|
Speed: 0.556 ms
|
SELECT * FROM author_settings WHERE author_id = 11201
Speed: 0.506 ms
|
SELECT * FROM author_settings WHERE author_id = 11202
Speed: 0.394 ms
|
SELECT * FROM author_settings WHERE author_id = 11203
Speed: 0.359 ms
|
Speed: 0.528 ms
|
SELECT * FROM author_settings WHERE author_id = 11204
Speed: 0.390 ms
|
SELECT * FROM author_settings WHERE author_id = 11205
Speed: 0.356 ms
|
SELECT * FROM author_settings WHERE author_id = 11206
Speed: 0.355 ms
|
Speed: 0.495 ms
|
SELECT * FROM author_settings WHERE author_id = 11207
Speed: 0.477 ms
|
SELECT * FROM author_settings WHERE author_id = 11208
Speed: 0.361 ms
|
SELECT * FROM author_settings WHERE author_id = 11209
Speed: 0.342 ms
|
Speed: 0.606 ms
|
SELECT * FROM author_settings WHERE author_id = 11501
Speed: 0.559 ms
|
SELECT * FROM author_settings WHERE author_id = 11502
Speed: 0.379 ms
|
Speed: 0.248 ms
|
SELECT * FROM author_settings WHERE author_id = 33741
Speed: 0.248 ms
|
SELECT * FROM author_settings WHERE author_id = 35418
Speed: 0.204 ms
|
Speed: 0.570 ms
|
SELECT * FROM author_settings WHERE author_id = 32906
Speed: 0.614 ms
|
SELECT * FROM author_settings WHERE author_id = 32905
Speed: 0.374 ms
|
SELECT * FROM author_settings WHERE author_id = 32907
Speed: 0.340 ms
|
Speed: 0.460 ms
|
SELECT * FROM author_settings WHERE author_id = 31041
Speed: 0.271 ms
|
SELECT * FROM author_settings WHERE author_id = 35417
Speed: 0.206 ms
|
Speed: 0.796 ms
|
SELECT * FROM author_settings WHERE author_id = 31300
Speed: 0.740 ms
|
SELECT * FROM author_settings WHERE author_id = 33155
Speed: 0.399 ms
|
SELECT * FROM author_settings WHERE author_id = 33156
Speed: 0.372 ms
|
Speed: 0.269 ms
|
SELECT * FROM author_settings WHERE author_id = 16056
Speed: 0.179 ms
|
SELECT * FROM author_settings WHERE author_id = 20909
Speed: 0.338 ms
|
SELECT * FROM author_settings WHERE author_id = 20910
Speed: 0.313 ms
|
Speed: 0.702 ms
|
SELECT * FROM author_settings WHERE author_id = 27395
Speed: 0.445 ms
|
SELECT * FROM author_settings WHERE author_id = 27396
Speed: 0.481 ms
|
SELECT * FROM author_settings WHERE author_id = 27397
Speed: 0.399 ms
|
SELECT * FROM author_settings WHERE author_id = 27398
Speed: 0.343 ms
|
Speed: 0.234 ms
|
SELECT * FROM author_settings WHERE author_id = 25328
Speed: 0.177 ms
|
SELECT * FROM author_settings WHERE author_id = 25329
Speed: 0.196 ms
|
SELECT * FROM author_settings WHERE author_id = 25330
Speed: 0.199 ms
|
Speed: 0.240 ms
|
SELECT * FROM author_settings WHERE author_id = 12165
Speed: 0.179 ms
|
SELECT * FROM author_settings WHERE author_id = 13955
Speed: 0.163 ms
|
SELECT * FROM author_settings WHERE author_id = 13956
Speed: 0.182 ms
|
Speed: 0.678 ms
|
SELECT * FROM author_settings WHERE author_id = 19914
Speed: 0.610 ms
|
SELECT * FROM author_settings WHERE author_id = 24063
Speed: 0.635 ms
|
SELECT * FROM author_settings WHERE author_id = 24064
Speed: 0.515 ms
|
Speed: 0.527 ms
|
SELECT * FROM author_settings WHERE author_id = 12163
Speed: 0.399 ms
|
SELECT * FROM author_settings WHERE author_id = 13948
Speed: 0.419 ms
|
SELECT * FROM author_settings WHERE author_id = 13949
Speed: 0.365 ms
|
Speed: 0.244 ms
|
SELECT * FROM author_settings WHERE author_id = 25327
Speed: 0.240 ms
|
SELECT * FROM author_settings WHERE author_id = 25796
Speed: 0.174 ms
|
Speed: 0.258 ms
|
SELECT * FROM author_settings WHERE author_id = 33101
Speed: 0.194 ms
|
SELECT * FROM author_settings WHERE author_id = 33103
Speed: 0.174 ms
|
SELECT * FROM author_settings WHERE author_id = 33104
Speed: 0.165 ms
|
Speed: 0.643 ms
|
SELECT * FROM author_settings WHERE author_id = 31191
Speed: 0.508 ms
|
SELECT * FROM author_settings WHERE author_id = 31192
Speed: 0.504 ms
|
Speed: 0.229 ms
|
SELECT * FROM author_settings WHERE author_id = 41742
Speed: 0.179 ms
|
SELECT * FROM author_settings WHERE author_id = 44122
Speed: 0.190 ms
|
SELECT * FROM author_settings WHERE author_id = 44123
Speed: 0.229 ms
|
Speed: 0.696 ms
|
SELECT * FROM author_settings WHERE author_id = 16678
Speed: 0.514 ms
|
SELECT * FROM author_settings WHERE author_id = 23324
Speed: 0.414 ms
|
SELECT * FROM author_settings WHERE author_id = 23325
Speed: 0.370 ms
|
Speed: 0.537 ms
|
SELECT * FROM author_settings WHERE author_id = 7393
Speed: 0.392 ms
|
SELECT * FROM author_settings WHERE author_id = 7394
Speed: 0.339 ms
|
SELECT * FROM author_settings WHERE author_id = 7395
Speed: 0.371 ms
|
Speed: 0.549 ms
|
SELECT * FROM author_settings WHERE author_id = 5517
Speed: 0.599 ms
|
SELECT * FROM author_settings WHERE author_id = 5518
Speed: 0.354 ms
|
SELECT * FROM author_settings WHERE author_id = 5519
Speed: 0.542 ms
|
Speed: 0.687 ms
|
SELECT * FROM author_settings WHERE author_id = 12162
Speed: 0.541 ms
|
SELECT * FROM author_settings WHERE author_id = 14157
Speed: 0.383 ms
|
SELECT * FROM author_settings WHERE author_id = 14158
Speed: 0.357 ms
|
Speed: 0.297 ms
|
SELECT * FROM author_settings WHERE author_id = 7064
Speed: 0.243 ms
|
SELECT * FROM author_settings WHERE author_id = 7065
Speed: 0.232 ms
|
SELECT * FROM author_settings WHERE author_id = 7066
Speed: 0.167 ms
|
Speed: 0.532 ms
|
SELECT * FROM author_settings WHERE author_id = 27394
Speed: 0.415 ms
|
SELECT * FROM author_settings WHERE author_id = 28333
Speed: 0.360 ms
|
SELECT * FROM author_settings WHERE author_id = 28334
Speed: 0.348 ms
|
Speed: 0.573 ms
|
SELECT * FROM author_settings WHERE author_id = 5723
Speed: 0.607 ms
|
SELECT * FROM author_settings WHERE author_id = 12963
Speed: 0.519 ms
|
SELECT * FROM author_settings WHERE author_id = 12964
Speed: 0.345 ms
|
Speed: 0.594 ms
|
SELECT * FROM author_settings WHERE author_id = 7417
Speed: 0.396 ms
|
SELECT * FROM author_settings WHERE author_id = 7418
Speed: 0.348 ms
|
SELECT * FROM author_settings WHERE author_id = 7419
Speed: 0.324 ms
|