|
SELECT * FROM sessions WHERE session_id = hq6na98gl0f75n2g37es5eb7d6
Speed: 1.360 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(hq6na98gl0f75n2g37es5eb7d6, 34.238.248.103, CCBot/2.0 (https://commoncrawl.org/faq/), 1597299818, 1597299818, 0, , periodicos.ufpe.br
Speed: 1.089 ms
|
|
SELECT * FROM journals WHERE path = re
Speed: 1.171 ms
|
|
Speed: 0.969 ms
|
|
Speed: 21.274 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = objectsforreviewplugin AND journal_id = 36
Speed: 1.784 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.129 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.985 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.935 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.899 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.844 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.892 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.887 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.842 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.828 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 = 36
Speed: 603.617 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 = 6302
Speed: 2.404 ms
|
|
Speed: 1.367 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5548
Speed: 1.078 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6302
Speed: 2.758 ms
|
|
Speed: 1.352 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 = 6302
Speed: 1.708 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6302
Speed: 2.582 ms
|
|
SELECT * FROM sections WHERE section_id = 154
Speed: 1.053 ms
|
|
SELECT * FROM section_settings WHERE section_id = 154
Speed: 6.919 ms
|
|
Speed: 1.076 ms
|
|
Speed: 1.135 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 992
Speed: 1.127 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6306
Speed: 2.169 ms
|
|
Speed: 1.332 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5552
Speed: 1.039 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6306
Speed: 2.416 ms
|
|
Speed: 1.516 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 = 6306
Speed: 1.866 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6306
Speed: 2.422 ms
|
|
SELECT * FROM sections WHERE section_id = 155
Speed: 1.097 ms
|
|
SELECT * FROM section_settings WHERE section_id = 155
Speed: 4.224 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 = 6307
Speed: 1.910 ms
|
|
Speed: 1.277 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5553
Speed: 1.018 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6307
Speed: 3.076 ms
|
|
Speed: 1.307 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 = 6307
Speed: 1.737 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6307
Speed: 2.868 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 = 6308
Speed: 1.899 ms
|
|
Speed: 1.344 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5554
Speed: 1.081 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6308
Speed: 3.156 ms
|
|
Speed: 1.448 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 478
Speed: 1.548 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 = 6308
Speed: 1.804 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6308
Speed: 3.162 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 = 6309
Speed: 2.001 ms
|
|
Speed: 1.230 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5555
Speed: 1.019 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6309
Speed: 2.697 ms
|
|
Speed: 1.382 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 479
Speed: 1.199 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 = 6309
Speed: 1.721 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6309
Speed: 2.784 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 = 6310
Speed: 1.841 ms
|
|
Speed: 1.213 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5556
Speed: 1.017 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6310
Speed: 3.255 ms
|
|
Speed: 1.492 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 480
Speed: 1.078 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 481
Speed: 1.051 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 = 6310
Speed: 1.779 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6310
Speed: 3.254 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 = 6311
Speed: 1.979 ms
|
|
Speed: 1.257 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5557
Speed: 1.090 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6311
Speed: 2.526 ms
|
|
Speed: 1.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 = 6311
Speed: 1.829 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6311
Speed: 2.603 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 = 6312
Speed: 1.849 ms
|
|
Speed: 1.289 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5558
Speed: 1.066 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6312
Speed: 3.016 ms
|
|
Speed: 1.309 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 = 6312
Speed: 1.940 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6312
Speed: 3.022 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 = 6313
Speed: 1.893 ms
|
|
Speed: 1.449 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5559
Speed: 1.046 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6313
Speed: 2.937 ms
|
|
Speed: 1.304 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 = 6313
Speed: 1.808 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6313
Speed: 3.094 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 = 6314
Speed: 1.974 ms
|
|
Speed: 1.247 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5560
Speed: 1.126 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6314
Speed: 2.819 ms
|
|
Speed: 1.317 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 = 6314
Speed: 1.955 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6314
Speed: 2.787 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 = 6315
Speed: 1.850 ms
|
|
Speed: 1.285 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5561
Speed: 1.089 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6315
Speed: 3.235 ms
|
|
Speed: 1.323 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 = 6315
Speed: 1.844 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6315
Speed: 3.147 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 = 6316
Speed: 1.888 ms
|
|
Speed: 1.254 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5562
Speed: 1.076 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6316
Speed: 3.322 ms
|
|
Speed: 1.388 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 = 6316
Speed: 1.836 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6316
Speed: 3.397 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 = 6317
Speed: 1.943 ms
|
|
Speed: 1.295 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5563
Speed: 1.118 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6317
Speed: 2.523 ms
|
|
Speed: 1.292 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 = 6317
Speed: 1.824 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6317
Speed: 2.559 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 = 6318
Speed: 1.907 ms
|
|
Speed: 1.305 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5564
Speed: 1.056 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6318
Speed: 3.044 ms
|
|
Speed: 1.313 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 = 6318
Speed: 1.825 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6318
Speed: 2.994 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 = 6319
Speed: 1.867 ms
|
|
Speed: 1.514 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5565
Speed: 1.067 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6319
Speed: 4.754 ms
|
|
Speed: 1.399 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 = 6319
Speed: 1.773 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6319
Speed: 3.939 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 = 6320
Speed: 1.965 ms
|
|
Speed: 1.306 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5566
Speed: 1.041 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6320
Speed: 2.800 ms
|
|
Speed: 1.331 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 = 6320
Speed: 1.938 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6320
Speed: 2.945 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 = 6321
Speed: 1.918 ms
|
|
Speed: 1.396 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5567
Speed: 1.092 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6321
Speed: 2.675 ms
|
|
Speed: 1.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 = 6321
Speed: 1.738 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6321
Speed: 2.621 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 = 6322
Speed: 1.870 ms
|
|
Speed: 1.277 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5568
Speed: 1.060 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6322
Speed: 3.443 ms
|
|
Speed: 1.417 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 482
Speed: 1.227 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 = 6322
Speed: 1.950 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6322
Speed: 3.394 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 = 6323
Speed: 1.983 ms
|
|
Speed: 1.276 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5569
Speed: 1.095 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6323
Speed: 3.204 ms
|
|
Speed: 1.297 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 = 6323
Speed: 1.867 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6323
Speed: 3.162 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 = 6324
Speed: 2.102 ms
|
|
Speed: 1.375 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5570
Speed: 1.072 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6324
Speed: 3.855 ms
|
|
Speed: 1.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 = 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 = 6324
Speed: 1.754 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6324
Speed: 3.808 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 = 6325
Speed: 1.987 ms
|
|
Speed: 1.284 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5571
Speed: 1.061 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6325
Speed: 3.980 ms
|
|
Speed: 1.622 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 = 6325
Speed: 1.785 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6325
Speed: 3.974 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 = 6326
Speed: 1.944 ms
|
|
Speed: 1.544 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5572
Speed: 1.024 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6326
Speed: 2.910 ms
|
|
Speed: 1.393 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 = 6326
Speed: 1.755 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6326
Speed: 2.685 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 = 6327
Speed: 1.975 ms
|
|
Speed: 1.335 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5573
Speed: 1.094 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6327
Speed: 2.987 ms
|
|
Speed: 1.312 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 = 6327
Speed: 1.926 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6327
Speed: 4.029 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 = 6328
Speed: 2.042 ms
|
|
Speed: 1.252 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5574
Speed: 1.035 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6328
Speed: 4.614 ms
|
|
Speed: 1.339 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 = 6328
Speed: 1.768 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6328
Speed: 5.164 ms
|
|
SELECT * FROM sections WHERE section_id = 156
Speed: 1.181 ms
|
|
SELECT * FROM section_settings WHERE section_id = 156
Speed: 4.384 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 = 6329
Speed: 1.800 ms
|
|
Speed: 1.296 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5575
Speed: 1.170 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 2.657 ms
|
|
Speed: 1.246 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 = 6329
Speed: 1.661 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 2.518 ms
|
|
SELECT * FROM sections WHERE section_id = 157
Speed: 1.003 ms
|
|
SELECT * FROM section_settings WHERE section_id = 157
Speed: 4.446 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 = 6330
Speed: 1.855 ms
|
|
Speed: 1.233 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5576
Speed: 1.080 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6330
Speed: 3.836 ms
|
|
Speed: 1.432 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 = 6330
Speed: 1.765 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6330
Speed: 3.888 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 = 6331
Speed: 1.918 ms
|
|
Speed: 1.293 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5577
Speed: 1.065 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6331
Speed: 2.693 ms
|
|
Speed: 1.370 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 = 6331
Speed: 1.751 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6331
Speed: 2.628 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 = 6332
Speed: 1.533 ms
|
|
Speed: 1.073 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5578
Speed: 0.847 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6332
Speed: 2.813 ms
|
|
Speed: 1.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 = 6332
Speed: 1.481 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6332
Speed: 2.786 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 = 6333
Speed: 1.542 ms
|
|
Speed: 1.040 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5579
Speed: 0.845 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6333
Speed: 2.361 ms
|
|
Speed: 1.077 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 = 6333
Speed: 1.450 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6333
Speed: 2.399 ms
|
|
SELECT * FROM sections WHERE section_id = 160
Speed: 0.849 ms
|
|
SELECT * FROM section_settings WHERE section_id = 160
Speed: 9.831 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 = 6334
Speed: 1.640 ms
|
|
Speed: 1.258 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5580
Speed: 0.993 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6334
Speed: 3.039 ms
|
|
Speed: 1.370 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 483
Speed: 0.939 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 = 6334
Speed: 1.464 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6334
Speed: 3.006 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 = 6335
Speed: 1.765 ms
|
|
Speed: 1.098 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5581
Speed: 0.880 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6335
Speed: 3.840 ms
|
|
Speed: 1.212 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 = 6335
Speed: 1.493 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6335
Speed: 2.643 ms
|
|
SELECT * FROM sections WHERE section_id = 162
Speed: 0.955 ms
|
|
SELECT * FROM section_settings WHERE section_id = 162
Speed: 1.145 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 = 6336
Speed: 1.594 ms
|
|
Speed: 1.121 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5582
Speed: 0.875 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6336
Speed: 1.686 ms
|
|
Speed: 1.113 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 = 6336
Speed: 1.484 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6336
Speed: 1.652 ms
|
|
Speed: 0.953 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 993
Speed: 1.044 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 = 6337
Speed: 1.624 ms
|
|
Speed: 1.047 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5583
Speed: 0.923 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6337
Speed: 2.346 ms
|
|
Speed: 1.151 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 = 6337
Speed: 1.616 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6337
Speed: 2.233 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 = 6338
Speed: 5.037 ms
|
|
Speed: 1.132 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5584
Speed: 0.874 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6338
Speed: 2.573 ms
|
|
Speed: 1.123 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 = 6338
Speed: 1.585 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6338
Speed: 2.638 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 = 6339
Speed: 1.744 ms
|
|
Speed: 1.131 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5585
Speed: 0.855 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6339
Speed: 3.395 ms
|
|
Speed: 1.281 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 = 6339
Speed: 1.605 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6339
Speed: 2.891 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 = 6340
Speed: 1.681 ms
|
|
Speed: 1.107 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5586
Speed: 5.673 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6340
Speed: 3.133 ms
|
|
Speed: 1.225 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 = 6340
Speed: 1.548 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6340
Speed: 3.192 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 = 6341
Speed: 1.718 ms
|
|
Speed: 1.198 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5587
Speed: 1.003 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6341
Speed: 2.976 ms
|
|
Speed: 1.438 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 484
Speed: 1.161 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 = 6341
Speed: 1.871 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6341
Speed: 3.069 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 = 6342
Speed: 1.840 ms
|
|
Speed: 1.290 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5588
Speed: 1.040 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6342
Speed: 2.986 ms
|
|
Speed: 1.322 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 = 6342
Speed: 1.769 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6342
Speed: 2.893 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 = 6343
Speed: 1.943 ms
|
|
Speed: 1.320 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5589
Speed: 0.966 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6343
Speed: 3.735 ms
|
|
Speed: 1.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 = 6343
Speed: 1.644 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6343
Speed: 3.710 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 = 6344
Speed: 1.973 ms
|
|
Speed: 1.245 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5590
Speed: 0.983 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6344
Speed: 2.411 ms
|
|
Speed: 1.271 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 = 6344
Speed: 1.669 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6344
Speed: 2.363 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 = 6345
Speed: 1.803 ms
|
|
Speed: 1.166 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5591
Speed: 0.962 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6345
Speed: 2.540 ms
|
|
Speed: 1.238 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 = 6345
Speed: 1.673 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6345
Speed: 2.476 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 = 6346
Speed: 1.838 ms
|
|
Speed: 1.157 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5592
Speed: 0.951 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6346
Speed: 2.567 ms
|
|
Speed: 1.167 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 = 6346
Speed: 1.651 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6346
Speed: 2.571 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 = 6347
Speed: 1.772 ms
|
|
Speed: 1.184 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5593
Speed: 0.999 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6347
Speed: 2.698 ms
|
|
Speed: 1.273 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 = 6347
Speed: 1.578 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6347
Speed: 2.882 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 = 6348
Speed: 1.883 ms
|
|
Speed: 1.286 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5594
Speed: 0.918 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6348
Speed: 3.416 ms
|
|
Speed: 1.336 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 = 6348
Speed: 1.670 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6348
Speed: 3.328 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 = 6349
Speed: 1.788 ms
|
|
Speed: 1.204 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5595
Speed: 1.021 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6349
Speed: 3.018 ms
|
|
Speed: 1.211 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 = 6349
Speed: 1.657 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6349
Speed: 2.909 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 = 6350
Speed: 1.737 ms
|
|
Speed: 1.177 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5596
Speed: 1.100 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6350
Speed: 2.467 ms
|
|
Speed: 1.451 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 485
Speed: 1.047 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 = 6350
Speed: 1.615 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6350
Speed: 2.318 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 = 6351
Speed: 1.759 ms
|
|
Speed: 1.172 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5597
Speed: 0.919 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6351
Speed: 3.054 ms
|
|
Speed: 1.211 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 = 6351
Speed: 1.569 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6351
Speed: 3.046 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 = 6352
Speed: 1.746 ms
|
|
Speed: 1.173 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5598
Speed: 1.035 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6352
Speed: 2.820 ms
|
|
Speed: 1.254 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 = 6352
Speed: 1.578 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6352
Speed: 2.582 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 = 6353
Speed: 1.762 ms
|
|
Speed: 1.228 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5599
Speed: 1.040 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6353
Speed: 2.840 ms
|
|
Speed: 1.183 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 = 6353
Speed: 1.850 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6353
Speed: 2.877 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 = 6354
Speed: 1.834 ms
|
|
Speed: 1.192 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5600
Speed: 1.052 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6354
Speed: 2.410 ms
|
|
Speed: 1.545 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 486
Speed: 1.269 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 487
Speed: 1.024 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 = 6354
Speed: 4.314 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6354
Speed: 2.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 = 6355
Speed: 1.936 ms
|
|
Speed: 1.228 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5601
Speed: 1.292 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6355
Speed: 2.626 ms
|
|
Speed: 3.442 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 = 6355
Speed: 1.776 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6355
Speed: 2.585 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 = 6356
Speed: 1.930 ms
|
|
Speed: 1.273 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5602
Speed: 0.998 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6356
Speed: 3.031 ms
|
|
Speed: 1.288 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 = 6356
Speed: 1.727 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6356
Speed: 2.959 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 = 6357
Speed: 5.548 ms
|
|
Speed: 1.262 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5603
Speed: 1.019 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6357
Speed: 3.533 ms
|
|
Speed: 1.301 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 = 6357
Speed: 1.800 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6357
Speed: 3.700 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 = 6358
Speed: 1.821 ms
|
|
Speed: 1.165 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5604
Speed: 1.169 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6358
Speed: 3.665 ms
|
|
Speed: 3.394 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 488
Speed: 1.157 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 = 6358
Speed: 1.770 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6358
Speed: 3.565 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 = 6359
Speed: 1.836 ms
|
|
Speed: 1.266 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5605
Speed: 0.986 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6359
Speed: 3.182 ms
|
|
Speed: 3.071 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 = 6359
Speed: 1.714 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6359
Speed: 3.099 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 = 6360
Speed: 1.647 ms
|
|
Speed: 1.091 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5606
Speed: 0.875 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6360
Speed: 2.389 ms
|
|
Speed: 1.115 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 = 6360
Speed: 1.487 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6360
Speed: 2.383 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 = 6361
Speed: 1.630 ms
|
|
Speed: 1.102 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5607
Speed: 0.898 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 3.598 ms
|
|
Speed: 1.677 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 = 6361
Speed: 5.431 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 3.527 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 = 6362
Speed: 1.805 ms
|
|
Speed: 1.115 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5608
Speed: 0.873 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6362
Speed: 2.676 ms
|
|
Speed: 1.181 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 = 6362
Speed: 1.543 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6362
Speed: 2.708 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 = 6363
Speed: 1.961 ms
|
|
Speed: 1.067 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5609
Speed: 1.121 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6363
Speed: 3.100 ms
|
|
Speed: 1.215 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 = 6363
Speed: 1.920 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6363
Speed: 2.978 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 = 6364
Speed: 1.807 ms
|
|
Speed: 1.163 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5610
Speed: 4.224 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6364
Speed: 2.671 ms
|
|
Speed: 1.122 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 = 6364
Speed: 1.904 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6364
Speed: 5.120 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 = 6365
Speed: 1.699 ms
|
|
Speed: 1.969 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5611
Speed: 0.848 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6365
Speed: 2.879 ms
|
|
Speed: 1.108 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 = 6365
Speed: 1.644 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6365
Speed: 2.862 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 = 6366
Speed: 1.677 ms
|
|
Speed: 1.096 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5612
Speed: 1.762 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6366
Speed: 3.215 ms
|
|
Speed: 1.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 = 6366
Speed: 1.541 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6366
Speed: 3.127 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6367
Speed: 2.994 ms
|
|
Speed: 1.070 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5613
Speed: 0.859 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6367
Speed: 2.603 ms
|
|
Speed: 1.182 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 = 6367
Speed: 1.540 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6367
Speed: 2.644 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 = 6368
Speed: 1.615 ms
|
|
Speed: 1.110 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5614
Speed: 0.902 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6368
Speed: 2.482 ms
|
|
Speed: 1.095 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 = 6368
Speed: 1.575 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6368
Speed: 2.464 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 = 6369
Speed: 1.738 ms
|
|
Speed: 1.201 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5615
Speed: 1.072 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6369
Speed: 3.119 ms
|
|
Speed: 1.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 = 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 = 6369
Speed: 1.771 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6369
Speed: 3.020 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 = 6370
Speed: 1.641 ms
|
|
Speed: 1.096 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5616
Speed: 0.883 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6370
Speed: 2.566 ms
|
|
Speed: 1.168 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 = 6370
Speed: 1.535 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6370
Speed: 2.636 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 = 6371
Speed: 1.799 ms
|
|
Speed: 1.075 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5617
Speed: 0.871 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6371
Speed: 3.009 ms
|
|
Speed: 1.253 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 = 6371
Speed: 1.543 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6371
Speed: 2.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 = 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 = 6372
Speed: 1.604 ms
|
|
Speed: 1.122 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5618
Speed: 0.857 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6372
Speed: 2.081 ms
|
|
Speed: 1.249 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 = 6372
Speed: 1.694 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6372
Speed: 1.991 ms
|
|
Speed: 0.925 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 994
Speed: 1.028 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 = 6373
Speed: 1.645 ms
|
|
Speed: 1.130 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5619
Speed: 0.894 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6373
Speed: 2.393 ms
|
|
Speed: 1.149 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 = 6373
Speed: 1.619 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6373
Speed: 2.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 = 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 = 6374
Speed: 1.653 ms
|
|
Speed: 1.070 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5620
Speed: 0.911 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6374
Speed: 2.673 ms
|
|
Speed: 1.119 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 = 6374
Speed: 1.534 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6374
Speed: 2.590 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 = 6375
Speed: 1.611 ms
|
|
Speed: 1.069 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5621
Speed: 0.937 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6375
Speed: 3.160 ms
|
|
Speed: 1.149 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 = 6375
Speed: 1.732 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6375
Speed: 3.151 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 = 6376
Speed: 1.634 ms
|
|
Speed: 1.124 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5622
Speed: 0.882 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6376
Speed: 2.682 ms
|
|
Speed: 1.152 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 = 6376
Speed: 1.494 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6376
Speed: 2.658 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 = 6377
Speed: 1.746 ms
|
|
Speed: 1.099 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5623
Speed: 0.890 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6377
Speed: 2.962 ms
|
|
Speed: 1.315 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 = 6377
Speed: 1.534 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6377
Speed: 2.904 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 = 6378
Speed: 1.643 ms
|
|
Speed: 1.107 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5624
Speed: 1.062 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6378
Speed: 3.093 ms
|
|
Speed: 1.379 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 = 6378
Speed: 1.596 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6378
Speed: 3.129 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6379
Speed: 1.952 ms
|
|
Speed: 1.125 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5625
Speed: 0.920 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6379
Speed: 2.802 ms
|
|
Speed: 1.385 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 489
Speed: 0.984 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 490
Speed: 0.966 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 = 6379
Speed: 1.520 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6379
Speed: 2.832 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 = 6380
Speed: 1.793 ms
|
|
Speed: 1.162 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5626
Speed: 0.970 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6380
Speed: 2.685 ms
|
|
Speed: 1.186 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 = 6380
Speed: 1.654 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6380
Speed: 2.688 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 = 6381
Speed: 1.749 ms
|
|
Speed: 1.492 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5627
Speed: 1.077 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6381
Speed: 2.988 ms
|
|
Speed: 1.396 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 491
Speed: 1.126 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 = 6381
Speed: 1.766 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6381
Speed: 3.058 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 = 6382
Speed: 3.371 ms
|
|
Speed: 1.331 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5628
Speed: 1.026 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6382
Speed: 2.756 ms
|
|
Speed: 1.313 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 = 6382
Speed: 1.874 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6382
Speed: 3.530 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 = 6383
Speed: 1.933 ms
|
|
Speed: 1.330 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5629
Speed: 3.349 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6383
Speed: 2.817 ms
|
|
Speed: 1.308 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 = 6383
Speed: 2.592 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6383
Speed: 3.214 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 = 6384
Speed: 1.832 ms
|
|
Speed: 1.258 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5630
Speed: 5.625 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6384
Speed: 3.060 ms
|
|
Speed: 1.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 = 6384
Speed: 1.749 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6384
Speed: 3.018 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 = 6385
Speed: 1.815 ms
|
|
Speed: 1.299 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5631
Speed: 1.109 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6385
Speed: 2.998 ms
|
|
Speed: 1.345 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 = 6385
Speed: 1.809 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6385
Speed: 3.013 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 = 6386
Speed: 1.862 ms
|
|
Speed: 1.373 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5632
Speed: 1.183 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6386
Speed: 3.187 ms
|
|
Speed: 1.521 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 = 6386
Speed: 1.725 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6386
Speed: 3.110 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 = 6387
Speed: 2.046 ms
|
|
Speed: 1.324 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5633
Speed: 1.030 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6387
Speed: 3.216 ms
|
|
Speed: 1.386 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 = 6387
Speed: 1.741 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6387
Speed: 3.158 ms
|
|
SELECT * FROM sections WHERE section_id = 158
Speed: 1.157 ms
|
|
SELECT * FROM section_settings WHERE section_id = 158
Speed: 4.435 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 = 6388
Speed: 2.034 ms
|
|
Speed: 1.279 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5634
Speed: 1.063 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6388
Speed: 7.658 ms
|
|
Speed: 1.591 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 = 6388
Speed: 1.695 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6388
Speed: 3.452 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 = 6389
Speed: 2.129 ms
|
|
Speed: 1.281 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5635
Speed: 1.090 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6389
Speed: 3.292 ms
|
|
Speed: 1.413 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 = 6389
Speed: 1.896 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6389
Speed: 3.337 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 = 6390
Speed: 1.899 ms
|
|
Speed: 1.230 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5636
Speed: 1.031 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6390
Speed: 2.650 ms
|
|
Speed: 1.338 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 492
Speed: 1.148 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 = 6390
Speed: 1.717 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6390
Speed: 2.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 = 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 = 6726
Speed: 1.829 ms
|
|
Speed: 1.271 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5973
Speed: 1.010 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6726
Speed: 2.749 ms
|
|
Speed: 1.283 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 = 6726
Speed: 1.853 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6726
Speed: 2.661 ms
|
|
Speed: 1.165 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1008
Speed: 1.102 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 = 6727
Speed: 1.911 ms
|
|
Speed: 1.391 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5974
Speed: 1.044 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6727
Speed: 4.462 ms
|
|
Speed: 1.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 = 6727
Speed: 1.801 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6727
Speed: 4.526 ms
|
|
Speed: 1.175 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1009
Speed: 1.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 = 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 = 6728
Speed: 1.922 ms
|
|
Speed: 1.278 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5975
Speed: 1.101 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6728
Speed: 3.739 ms
|
|
Speed: 1.397 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 554
Speed: 1.125 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 = 6728
Speed: 1.855 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6728
Speed: 3.696 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 = 6729
Speed: 2.028 ms
|
|
Speed: 1.360 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5976
Speed: 1.021 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6729
Speed: 3.208 ms
|
|
Speed: 1.306 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 = 6729
Speed: 1.763 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6729
Speed: 3.053 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 = 6730
Speed: 1.897 ms
|
|
Speed: 1.244 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5977
Speed: 1.043 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6730
Speed: 3.374 ms
|
|
Speed: 1.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 = 6730
Speed: 1.918 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6730
Speed: 3.570 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 = 6731
Speed: 1.889 ms
|
|
Speed: 1.279 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5978
Speed: 1.046 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6731
Speed: 3.248 ms
|
|
Speed: 1.509 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 555
Speed: 1.150 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 = 6731
Speed: 1.771 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6731
Speed: 3.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 = 6732
Speed: 1.901 ms
|
|
Speed: 1.361 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5979
Speed: 1.077 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6732
Speed: 3.524 ms
|
|
Speed: 1.518 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 556
Speed: 1.085 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 = 6732
Speed: 1.848 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6732
Speed: 3.532 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 = 6733
Speed: 1.904 ms
|
|
Speed: 1.298 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5980
Speed: 1.040 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6733
Speed: 2.906 ms
|
|
Speed: 1.245 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 = 6733
Speed: 1.703 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6733
Speed: 2.837 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 = 6734
Speed: 1.902 ms
|
|
Speed: 1.399 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5981
Speed: 1.092 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6734
Speed: 4.203 ms
|
|
Speed: 1.569 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 = 6734
Speed: 1.795 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6734
Speed: 4.126 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 = 6735
Speed: 1.896 ms
|
|
Speed: 1.235 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5982
Speed: 1.049 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6735
Speed: 2.610 ms
|
|
Speed: 1.114 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 = 6735
Speed: 1.584 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6735
Speed: 2.598 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 = 6736
Speed: 1.599 ms
|
|
Speed: 1.389 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5983
Speed: 1.013 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6736
Speed: 2.557 ms
|
|
Speed: 1.123 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 = 6736
Speed: 1.492 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6736
Speed: 2.544 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 = 6737
Speed: 1.881 ms
|
|
Speed: 1.207 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5984
Speed: 1.026 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6737
Speed: 3.259 ms
|
|
Speed: 1.343 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 557
Speed: 0.948 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 558
Speed: 0.866 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 = 6737
Speed: 1.484 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6737
Speed: 3.052 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 = 6738
Speed: 1.548 ms
|
|
Speed: 1.086 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5985
Speed: 0.863 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6738
Speed: 3.637 ms
|
|
Speed: 1.544 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 559
Speed: 1.111 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 = 6738
Speed: 1.642 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6738
Speed: 3.562 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 = 6739
Speed: 1.757 ms
|
|
Speed: 1.484 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5986
Speed: 0.989 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6739
Speed: 2.895 ms
|
|
Speed: 1.160 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 = 6739
Speed: 1.667 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6739
Speed: 2.919 ms
|
|
Speed: 1.468 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2880
Speed: 1.001 ms
|
|
Speed: 2.028 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11735
Speed: 1.235 ms
|
|
Speed: 2.084 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11748
Speed: 1.037 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11749
Speed: 1.024 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11750
Speed: 0.958 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11751
Speed: 0.899 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11752
Speed: 1.085 ms
|
|
Speed: 1.491 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11753
Speed: 0.994 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11754
Speed: 0.995 ms
|
|
Speed: 1.557 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11755
Speed: 0.974 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11756
Speed: 0.912 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11757
Speed: 0.891 ms
|
|
Speed: 1.587 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11758
Speed: 1.295 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11759
Speed: 0.942 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11760
Speed: 0.959 ms
|
|
Speed: 1.639 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11761
Speed: 1.004 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11762
Speed: 0.849 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11763
Speed: 0.920 ms
|
|
Speed: 1.635 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11764
Speed: 0.968 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11765
Speed: 0.920 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11766
Speed: 0.890 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11767
Speed: 0.888 ms
|
|
Speed: 1.532 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11768
Speed: 1.116 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11769
Speed: 0.894 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11770
Speed: 0.911 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11771
Speed: 0.877 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11772
Speed: 0.911 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11773
Speed: 0.895 ms
|
|
Speed: 1.571 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11774
Speed: 1.034 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11775
Speed: 1.122 ms
|
|
Speed: 1.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11776
Speed: 0.945 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11777
Speed: 0.911 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11778
Speed: 0.904 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11779
Speed: 0.900 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11780
Speed: 0.904 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11781
Speed: 0.888 ms
|
|
Speed: 1.634 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11782
Speed: 1.033 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11783
Speed: 0.942 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11784
Speed: 0.938 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11785
Speed: 1.181 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11786
Speed: 0.960 ms
|
|
Speed: 1.546 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11787
Speed: 0.982 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11788
Speed: 0.912 ms
|
|
Speed: 1.600 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11789
Speed: 0.982 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11790
Speed: 0.956 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11791
Speed: 0.931 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11792
Speed: 0.909 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11793
Speed: 0.922 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11794
Speed: 0.992 ms
|
|
Speed: 1.434 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11795
Speed: 1.000 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11796
Speed: 0.970 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11797
Speed: 0.864 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11798
Speed: 0.900 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11799
Speed: 0.891 ms
|
|
Speed: 1.637 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11800
Speed: 1.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11801
Speed: 1.023 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11802
Speed: 0.999 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11803
Speed: 1.098 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11804
Speed: 1.285 ms
|
|
Speed: 1.734 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11805
Speed: 1.001 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11806
Speed: 1.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11807
Speed: 1.061 ms
|
|
Speed: 1.913 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11808
Speed: 1.117 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11809
Speed: 1.145 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11810
Speed: 1.081 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11811
Speed: 1.068 ms
|
|
Speed: 1.667 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11812
Speed: 1.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11813
Speed: 1.175 ms
|
|
Speed: 1.732 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11814
Speed: 1.115 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11815
Speed: 1.090 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11816
Speed: 1.140 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11817
Speed: 1.142 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11818
Speed: 1.083 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11819
Speed: 1.061 ms
|
|
Speed: 1.715 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11820
Speed: 1.128 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11821
Speed: 1.073 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11822
Speed: 1.041 ms
|
|
Speed: 1.788 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11823
Speed: 1.325 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11824
Speed: 1.100 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11825
Speed: 1.059 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11826
Speed: 1.077 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11827
Speed: 1.028 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11828
Speed: 1.064 ms
|
|
Speed: 1.697 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11829
Speed: 1.175 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11830
Speed: 1.092 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11831
Speed: 1.127 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11832
Speed: 1.145 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11833
Speed: 1.103 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11834
Speed: 1.203 ms
|
|
Speed: 1.695 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11835
Speed: 1.190 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11836
Speed: 1.123 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11837
Speed: 1.062 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11838
Speed: 1.097 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11839
Speed: 1.054 ms
|
|
Speed: 1.677 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11840
Speed: 1.108 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11841
Speed: 1.046 ms
|
|
Speed: 1.715 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11842
Speed: 1.088 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11843
Speed: 1.112 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11844
Speed: 1.043 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11845
Speed: 1.124 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11846
Speed: 1.002 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11847
Speed: 1.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11848
Speed: 1.051 ms
|
|
Speed: 1.669 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11849
Speed: 1.214 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11850
Speed: 1.049 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11851
Speed: 1.043 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11852
Speed: 1.081 ms
|
|
Speed: 1.646 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11853
Speed: 1.132 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11854
Speed: 1.062 ms
|
|
Speed: 1.611 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11855
Speed: 1.135 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11856
Speed: 1.081 ms
|
|
Speed: 1.709 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11857
Speed: 1.098 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11858
Speed: 1.075 ms
|
|
Speed: 2.136 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11859
Speed: 1.125 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11860
Speed: 1.123 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11861
Speed: 1.034 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11862
Speed: 1.082 ms
|
|
Speed: 1.702 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11863
Speed: 1.130 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11864
Speed: 1.136 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11865
Speed: 1.054 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11866
Speed: 1.060 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11867
Speed: 1.178 ms
|
|
Speed: 1.659 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11868
Speed: 1.123 ms
|
|
Speed: 1.703 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11869
Speed: 1.110 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11870
Speed: 1.041 ms
|
|
Speed: 1.755 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11871
Speed: 1.096 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11872
Speed: 1.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11873
Speed: 1.059 ms
|
|
Speed: 1.824 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11874
Speed: 1.118 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11875
Speed: 1.172 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11876
Speed: 1.159 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11877
Speed: 1.177 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11878
Speed: 1.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11879
Speed: 1.171 ms
|
|
Speed: 1.843 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11880
Speed: 1.056 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11881
Speed: 1.038 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11882
Speed: 1.020 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11883
Speed: 1.066 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11884
Speed: 1.036 ms
|
|
Speed: 1.801 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11885
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11886
Speed: 1.114 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11887
Speed: 1.003 ms
|
|
Speed: 1.827 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11888
Speed: 1.333 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11889
Speed: 1.111 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11890
Speed: 1.060 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11891
Speed: 1.102 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11892
Speed: 1.058 ms
|
|
Speed: 1.809 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11893
Speed: 1.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11894
Speed: 1.095 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11895
Speed: 1.210 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11896
Speed: 1.078 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11897
Speed: 1.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11898
Speed: 1.061 ms
|
|
Speed: 1.776 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11899
Speed: 1.145 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11900
Speed: 1.114 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11901
Speed: 1.233 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11902
Speed: 1.129 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11903
Speed: 1.060 ms
|
|
Speed: 1.681 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11904
Speed: 1.124 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11905
Speed: 1.055 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11906
Speed: 1.182 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11907
Speed: 1.088 ms
|
|
Speed: 1.818 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11908
Speed: 1.137 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11909
Speed: 1.037 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11910
Speed: 1.127 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11911
Speed: 1.111 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11912
Speed: 1.136 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11913
Speed: 1.067 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11914
Speed: 1.067 ms
|
|
Speed: 1.876 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11915
Speed: 1.223 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11916
Speed: 1.158 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11917
Speed: 1.148 ms
|
|
Speed: 1.857 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11918
Speed: 1.213 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11919
Speed: 1.119 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11920
Speed: 1.124 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11921
Speed: 1.069 ms
|
|
Speed: 1.709 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11922
Speed: 1.305 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11923
Speed: 1.101 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11924
Speed: 1.103 ms
|
|
Speed: 1.778 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11925
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11926
Speed: 1.101 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11927
Speed: 1.070 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11928
Speed: 1.071 ms
|
|
Speed: 1.645 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11929
Speed: 1.157 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11930
Speed: 1.133 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11931
Speed: 1.268 ms
|
|
Speed: 1.873 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11932
Speed: 1.168 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11933
Speed: 1.102 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11934
Speed: 1.067 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11935
Speed: 1.131 ms
|
|
Speed: 1.844 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11936
Speed: 1.194 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11937
Speed: 1.193 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11938
Speed: 1.102 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11939
Speed: 1.101 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11940
Speed: 1.174 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11941
Speed: 1.124 ms
|
|
Speed: 1.878 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11942
Speed: 1.243 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11943
Speed: 1.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11944
Speed: 1.080 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11945
Speed: 1.118 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11946
Speed: 1.164 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11947
Speed: 1.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11948
Speed: 1.030 ms
|
|
Speed: 1.777 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11949
Speed: 1.200 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11950
Speed: 1.063 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11951
Speed: 1.086 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11952
Speed: 1.138 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11953
Speed: 1.097 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11954
Speed: 1.044 ms
|
|
Speed: 2.064 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11955
Speed: 1.099 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11956
Speed: 1.129 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11957
Speed: 1.210 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11958
Speed: 1.045 ms
|
|
Speed: 1.659 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11959
Speed: 1.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11960
Speed: 1.316 ms
|
|
Speed: 1.670 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11961
Speed: 1.163 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11962
Speed: 1.053 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11963
Speed: 1.342 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11964
Speed: 1.166 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11965
Speed: 1.131 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11966
Speed: 1.078 ms
|
|
Speed: 1.839 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11967
Speed: 1.206 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11968
Speed: 1.093 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11969
Speed: 1.081 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11970
Speed: 1.426 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11971
Speed: 1.065 ms
|
|
Speed: 1.774 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11972
Speed: 1.163 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11973
Speed: 1.068 ms
|
|
Speed: 1.694 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11974
Speed: 1.149 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11975
Speed: 1.072 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11976
Speed: 1.585 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11977
Speed: 1.151 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11978
Speed: 1.275 ms
|
|
Speed: 1.781 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11979
Speed: 1.117 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11980
Speed: 1.064 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11981
Speed: 1.178 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11982
Speed: 1.412 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11983
Speed: 1.148 ms
|
|
Speed: 1.858 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11984
Speed: 1.113 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11985
Speed: 1.080 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11986
Speed: 1.054 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11987
Speed: 1.059 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11988
Speed: 1.114 ms
|
|
Speed: 1.685 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11989
Speed: 1.104 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11990
Speed: 1.073 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11991
Speed: 1.140 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11992
Speed: 1.210 ms
|
|
Speed: 1.723 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11993
Speed: 1.142 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11994
Speed: 1.036 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11995
Speed: 1.079 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11996
Speed: 1.070 ms
|
|
Speed: 1.855 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11997
Speed: 1.093 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11998
Speed: 1.164 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11999
Speed: 1.009 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12000
Speed: 1.107 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12001
Speed: 1.163 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12002
Speed: 1.143 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12003
Speed: 1.069 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12004
Speed: 1.027 ms
|
|
Speed: 2.212 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12005
Speed: 1.129 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12006
Speed: 1.053 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12007
Speed: 1.218 ms
|
|
Speed: 1.663 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12008
Speed: 1.218 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12009
Speed: 1.155 ms
|
|
Speed: 1.767 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12010
Speed: 1.134 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12011
Speed: 1.096 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12012
Speed: 1.118 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12013
Speed: 1.212 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12014
Speed: 1.128 ms
|
|
Speed: 1.793 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12015
Speed: 1.420 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12016
Speed: 1.167 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12017
Speed: 1.347 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12018
Speed: 1.094 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12019
Speed: 1.184 ms
|
|
Speed: 1.898 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12020
Speed: 1.127 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12021
Speed: 1.087 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12022
Speed: 1.177 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12023
Speed: 1.095 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12024
Speed: 1.104 ms
|
|
Speed: 2.008 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12025
Speed: 1.188 ms
|
|
Speed: 1.732 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12026
Speed: 1.192 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12027
Speed: 1.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12028
Speed: 1.114 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12029
Speed: 1.158 ms
|
|
Speed: 1.841 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12030
Speed: 1.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12031
Speed: 1.098 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12032
Speed: 1.122 ms
|
|
Speed: 1.684 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12033
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12034
Speed: 1.123 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12035
Speed: 1.437 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12036
Speed: 1.077 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12037
Speed: 1.198 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12038
Speed: 1.112 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12039
Speed: 1.116 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12040
Speed: 1.108 ms
|
|
Speed: 6.534 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12041
Speed: 5.504 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12042
Speed: 1.244 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12043
Speed: 1.141 ms
|
|
Speed: 1.825 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12044
Speed: 1.174 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12045
Speed: 1.232 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12046
Speed: 1.144 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12047
Speed: 1.119 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12048
Speed: 1.069 ms
|
|
Speed: 2.234 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12049
Speed: 1.195 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12050
Speed: 1.244 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12051
Speed: 1.199 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12052
Speed: 1.120 ms
|
|
Speed: 1.973 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12053
Speed: 1.396 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12054
Speed: 1.301 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12055
Speed: 1.175 ms
|
|
Speed: 1.994 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12056
Speed: 1.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12057
Speed: 1.076 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12058
Speed: 1.117 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12059
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12060
Speed: 1.050 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12061
Speed: 1.177 ms
|
|
Speed: 1.771 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12062
Speed: 1.181 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12063
Speed: 1.158 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12064
Speed: 1.095 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12065
Speed: 1.113 ms
|
|
Speed: 1.961 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12066
Speed: 1.215 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12067
Speed: 1.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12068
Speed: 3.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12069
Speed: 1.198 ms
|
|
Speed: 1.901 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12070
Speed: 1.434 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12071
Speed: 1.147 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12072
Speed: 3.449 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12073
Speed: 1.273 ms
|
|
Speed: 2.036 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12074
Speed: 1.071 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12075
Speed: 1.039 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12076
Speed: 1.043 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12077
Speed: 1.056 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12078
Speed: 1.107 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12079
Speed: 1.075 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12080
Speed: 6.142 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12081
Speed: 1.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12082
Speed: 1.152 ms
|
|
Speed: 1.791 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12083
Speed: 1.216 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12084
Speed: 1.122 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12085
Speed: 1.105 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12086
Speed: 1.102 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12087
Speed: 1.091 ms
|
|
Speed: 1.874 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12088
Speed: 1.110 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12089
Speed: 1.092 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12090
Speed: 1.064 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12091
Speed: 1.047 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12092
Speed: 1.039 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12093
Speed: 1.525 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12094
Speed: 1.277 ms
|
|
Speed: 1.831 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12095
Speed: 1.197 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12096
Speed: 1.314 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12097
Speed: 1.093 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12098
Speed: 1.288 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12099
Speed: 3.649 ms
|
|
Speed: 2.413 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12100
Speed: 1.355 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12101
Speed: 1.068 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12102
Speed: 5.925 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12103
Speed: 1.337 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12104
Speed: 1.103 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12105
Speed: 1.109 ms
|
|
Speed: 1.992 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12106
Speed: 1.154 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12107
Speed: 1.119 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12108
Speed: 1.073 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12109
Speed: 1.057 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12110
Speed: 1.002 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12111
Speed: 1.004 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12112
Speed: 1.156 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12113
Speed: 1.136 ms
|
|
Speed: 1.783 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12114
Speed: 1.219 ms
|
|
SELECT * FROM author_settings WHERE author_id = 12115
Speed: 1.276 ms
|
|
Speed: 2.211 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13488
Speed: 5.480 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13489
Speed: 0.991 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13490
Speed: 0.873 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13491
Speed: 0.927 ms
|
|
Speed: 1.532 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13492
Speed: 1.010 ms
|
|
Speed: 1.513 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13493
Speed: 1.423 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13494
Speed: 0.969 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13495
Speed: 3.798 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13496
Speed: 1.004 ms
|
|
Speed: 6.532 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13497
Speed: 1.163 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13498
Speed: 0.944 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13499
Speed: 0.915 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13500
Speed: 1.179 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13501
Speed: 0.913 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13502
Speed: 1.027 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13503
Speed: 0.973 ms
|
|
Speed: 1.608 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13504
Speed: 0.970 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13505
Speed: 0.942 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13506
Speed: 0.900 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13507
Speed: 0.957 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13508
Speed: 0.917 ms
|
|
Speed: 5.040 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13509
Speed: 1.049 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13510
Speed: 0.945 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13511
Speed: 1.109 ms
|
|
Speed: 1.534 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13512
Speed: 0.961 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13513
Speed: 0.902 ms
|
|
Speed: 5.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13514
Speed: 1.950 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13515
Speed: 1.883 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13516
Speed: 1.748 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13517
Speed: 1.787 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13518
Speed: 1.778 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13519
Speed: 1.757 ms
|
|
Speed: 1.639 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13520
Speed: 0.939 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13521
Speed: 0.973 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13522
Speed: 1.356 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13523
Speed: 1.224 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13524
Speed: 1.028 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13525
Speed: 1.149 ms
|
|
Speed: 1.697 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13526
Speed: 1.192 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13527
Speed: 1.047 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13528
Speed: 1.052 ms
|
|
Speed: 1.716 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13529
Speed: 1.099 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13530
Speed: 1.066 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13531
Speed: 1.076 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13532
Speed: 1.011 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13533
Speed: 1.012 ms
|
|
Speed: 1.864 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13534
Speed: 1.068 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13535
Speed: 1.047 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13536
Speed: 0.980 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13537
Speed: 1.186 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13538
Speed: 1.025 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13539
Speed: 1.197 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13540
Speed: 0.974 ms
|
|
Speed: 1.731 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13541
Speed: 1.024 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13542
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13543
Speed: 0.949 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13544
Speed: 1.033 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13545
Speed: 0.998 ms
|
|
Speed: 1.763 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13546
Speed: 1.127 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13547
Speed: 1.071 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13548
Speed: 1.000 ms
|
