|
SELECT * FROM sessions WHERE session_id = dqeflbvmbvflob06remqqs1i02
Speed: 1.597 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(dqeflbvmbvflob06remqqs1i02, 54.80.247.119, CCBot/2.0 (http://commoncrawl.org/faq/), 1529272895, 1529272895, 0, , periodicos.ufpe.br
Speed: 1.365 ms
|
|
SELECT * FROM journals WHERE path = re
Speed: 1.476 ms
|
|
Speed: 1.284 ms
|
|
Speed: 21.548 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 1.503 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.299 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 1.153 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 1.137 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 1.089 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 1.124 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 1.085 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 1.079 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 1.115 ms
|
|
SELECT o.article_id,
COUNT(*) AS count
FROM articles a,
published_articles pa,
issues i,
article_search_objects o NATURAL JOIN article_search_object_keywords o0 NATURAL JOIN article_search_keyword_list k0
WHERE pa.article_id = a.article_id AND
a.status = 3 AND
pa.article_id = o.article_id AND
i.issue_id = pa.issue_id AND
i.published = 1 AND k0.keyword_text = saúde AND (o.type & 16) != 0 AND i.journal_id = 36
Speed: 191.016 ms
|
|
SELECT o.article_id,
COUNT(*) AS count
FROM articles a,
published_articles pa,
issues i,
article_search_objects o NATURAL JOIN article_search_object_keywords o0 NATURAL JOIN article_search_keyword_list k0
WHERE pa.article_id = a.article_id AND
a.status = 3 AND
pa.article_id = o.article_id AND
i.issue_id = pa.issue_id AND
i.published = 1 AND k0.keyword_text = mulher AND (o.type & 16) != 0 AND i.journal_id = 36
Speed: 23.001 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 = 234522
Speed: 2.295 ms
|
|
Speed: 1.435 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 29187
Speed: 1.285 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 29188
Speed: 1.122 ms
|
|
SELECT * FROM article_settings WHERE article_id = 234522
Speed: 3.058 ms
|
|
Speed: 1.770 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23703
Speed: 1.224 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23704
Speed: 1.131 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23705
Speed: 1.192 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23706
Speed: 1.144 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23916
Speed: 1.267 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23917
Speed: 1.237 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23918
Speed: 0.998 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 = 234522
Speed: 1.466 ms
|
|
SELECT * FROM article_settings WHERE article_id = 234522
Speed: 2.750 ms
|
|
SELECT * FROM sections WHERE section_id = 155
Speed: 0.964 ms
|
|
SELECT * FROM section_settings WHERE section_id = 155
Speed: 4.458 ms
|
|
Speed: 0.787 ms
|
|
Speed: 0.923 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2634
Speed: 0.968 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 234396
Speed: 1.503 ms
|
|
Speed: 1.197 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 29226
Speed: 0.917 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 29227
Speed: 0.915 ms
|
|
SELECT * FROM article_settings WHERE article_id = 234396
Speed: 2.985 ms
|
|
Speed: 1.127 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25078
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 = 234396
Speed: 1.415 ms
|
|
SELECT * FROM article_settings WHERE article_id = 234396
Speed: 2.953 ms
|
|
SELECT * FROM sections WHERE section_id = 158
Speed: 0.906 ms
|
|
SELECT * FROM section_settings WHERE section_id = 158
Speed: 4.564 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 = 231096
Speed: 1.559 ms
|
|
Speed: 1.164 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28630
Speed: 0.935 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28631
Speed: 0.891 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231096
Speed: 2.995 ms
|
|
Speed: 1.337 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16389
Speed: 1.029 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16390
Speed: 1.015 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16391
Speed: 1.009 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16408
Speed: 1.232 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 = 231096
Speed: 1.890 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231096
Speed: 3.244 ms
|
|
Speed: 1.141 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2575
Speed: 1.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 = 230602
Speed: 1.879 ms
|
|
Speed: 1.461 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28709
Speed: 1.153 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28710
Speed: 1.071 ms
|
|
SELECT * FROM article_settings WHERE article_id = 230602
Speed: 3.523 ms
|
|
Speed: 1.404 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16137
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 = 230602
Speed: 1.715 ms
|
|
SELECT * FROM article_settings WHERE article_id = 230602
Speed: 3.469 ms
|
|
SELECT * FROM sections WHERE section_id = 161
Speed: 1.087 ms
|
|
SELECT * FROM section_settings WHERE section_id = 161
Speed: 4.779 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 = 10714
Speed: 1.922 ms
|
|
Speed: 1.352 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11796
Speed: 1.272 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11797
Speed: 1.058 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10714
Speed: 9.877 ms
|
|
Speed: 1.479 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5257
Speed: 0.944 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5258
Speed: 0.899 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5259
Speed: 0.875 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5260
Speed: 0.868 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5261
Speed: 0.849 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 = 10714
Speed: 1.461 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10714
Speed: 9.762 ms
|
|
Speed: 1.111 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1270
Speed: 1.150 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 = 10855
Speed: 1.889 ms
|
|
Speed: 1.418 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12075
Speed: 1.083 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12076
Speed: 1.061 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10855
Speed: 10.430 ms
|
|
Speed: 1.588 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5653
Speed: 1.130 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5654
Speed: 1.086 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5655
Speed: 1.432 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5656
Speed: 1.052 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 = 10855
Speed: 1.701 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10855
Speed: 10.323 ms
|
|
Speed: 1.182 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1275
Speed: 1.138 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 = 9917
Speed: 1.897 ms
|
|
Speed: 1.667 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10196
Speed: 1.158 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10197
Speed: 0.990 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9917
Speed: 10.161 ms
|
|
Speed: 1.729 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3057
Speed: 1.314 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3058
Speed: 1.083 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3059
Speed: 1.046 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 = 9917
Speed: 1.647 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9917
Speed: 9.560 ms
|
|
Speed: 1.217 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1243
Speed: 1.096 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 = 9669
Speed: 1.925 ms
|
|
Speed: 1.364 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9701
Speed: 1.058 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9702
Speed: 1.043 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9669
Speed: 9.748 ms
|
|
Speed: 1.573 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2337
Speed: 1.218 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2338
Speed: 1.140 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2339
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 = 9669
Speed: 1.783 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9669
Speed: 9.714 ms
|
|
Speed: 1.119 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1237
Speed: 1.062 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 = 231219
Speed: 1.768 ms
|
|
Speed: 1.408 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 25234
Speed: 1.114 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 25235
Speed: 1.046 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231219
Speed: 16.384 ms
|
|
Speed: 1.472 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16622
Speed: 1.650 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 = 231219
Speed: 1.794 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231219
Speed: 16.690 ms
|
|
Speed: 1.130 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2307
Speed: 1.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 = 13658
Speed: 1.912 ms
|
|
Speed: 1.490 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16532
Speed: 1.081 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16533
Speed: 1.045 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13658
Speed: 16.038 ms
|
|
Speed: 1.647 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12665
Speed: 1.325 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12666
Speed: 1.240 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12667
Speed: 1.188 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 13658
Speed: 1.752 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13658
Speed: 15.872 ms
|
|
Speed: 1.243 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1241
Speed: 1.131 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 = 10307
Speed: 1.880 ms
|
|
Speed: 1.508 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10977
Speed: 1.062 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10978
Speed: 1.030 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10307
Speed: 9.635 ms
|
|
Speed: 1.494 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4097
Speed: 0.953 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4098
Speed: 0.890 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4099
Speed: 0.862 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4100
Speed: 0.857 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4101
Speed: 0.950 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4102
Speed: 0.915 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4103
Speed: 1.081 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 = 10307
Speed: 1.824 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10307
Speed: 9.589 ms
|
|
Speed: 1.216 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1254
Speed: 1.098 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 = 9836
Speed: 1.980 ms
|
|
Speed: 1.402 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10034
Speed: 1.276 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10035
Speed: 1.039 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9836
Speed: 10.437 ms
|
|
Speed: 1.605 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2831
Speed: 1.282 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2832
Speed: 1.238 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2833
Speed: 1.132 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 = 9836
Speed: 2.145 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9836
Speed: 10.413 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 = 231094
Speed: 1.701 ms
|
|
Speed: 1.239 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28863
Speed: 0.952 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28864
Speed: 0.841 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231094
Speed: 2.739 ms
|
|
Speed: 1.345 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16386
Speed: 0.974 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16387
Speed: 0.940 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16388
Speed: 0.932 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16407
Speed: 0.973 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 = 231094
Speed: 1.411 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231094
Speed: 2.705 ms
|
|
Speed: 0.985 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2583
Speed: 0.952 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 = 11627
Speed: 1.490 ms
|
|
Speed: 1.170 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13691
Speed: 0.508 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13692
Speed: 0.476 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11627
Speed: 1.136 ms
|
|
Speed: 0.684 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7839
Speed: 0.555 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7840
Speed: 0.520 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7841
Speed: 0.516 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7842
Speed: 0.578 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 = 11627
Speed: 0.776 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11627
Speed: 1.161 ms
|
|
Speed: 0.481 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1297
Speed: 0.495 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 = 11303
Speed: 0.787 ms
|
|
Speed: 0.602 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12971
Speed: 0.513 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12972
Speed: 0.508 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11303
Speed: 1.211 ms
|
|
Speed: 0.738 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6961
Speed: 0.542 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6962
Speed: 0.692 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6963
Speed: 0.603 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6964
Speed: 0.554 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6965
Speed: 0.653 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6966
Speed: 0.875 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6967
Speed: 0.639 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6968
Speed: 0.624 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 11303
Speed: 0.990 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11303
Speed: 1.192 ms
|
|
Speed: 0.538 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1289
Speed: 0.623 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 11165
Speed: 0.972 ms
|
|
Speed: 0.752 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12692
Speed: 0.576 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12693
Speed: 0.611 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11165
Speed: 1.319 ms
|
|
Speed: 0.821 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6554
Speed: 0.632 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6555
Speed: 0.608 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6556
Speed: 0.617 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6557
Speed: 0.626 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6558
Speed: 0.603 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 = 11165
Speed: 1.011 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11165
Speed: 1.285 ms
|
|
Speed: 0.547 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1286
Speed: 0.627 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 10739
Speed: 0.947 ms
|
|
Speed: 0.710 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11844
Speed: 0.569 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11845
Speed: 0.547 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10739
Speed: 1.359 ms
|
|
Speed: 0.773 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5324
Speed: 0.692 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5325
Speed: 0.612 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5326
Speed: 0.648 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 = 10739
Speed: 0.951 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10739
Speed: 1.362 ms
|
|
Speed: 0.535 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1271
Speed: 0.599 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 = 231196
Speed: 1.010 ms
|
|
Speed: 0.826 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 25188
Speed: 0.602 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 25189
Speed: 0.575 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231196
Speed: 2.020 ms
|
|
Speed: 0.855 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16547
Speed: 0.742 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16548
Speed: 0.701 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16549
Speed: 0.712 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 = 231196
Speed: 0.970 ms
|
|
SELECT * FROM article_settings WHERE article_id = 231196
Speed: 1.650 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 = 10970
Speed: 0.946 ms
|
|
Speed: 0.747 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12300
Speed: 0.622 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12301
Speed: 0.569 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10970
Speed: 1.316 ms
|
|
Speed: 0.778 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5970
Speed: 0.632 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5971
Speed: 0.630 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5972
Speed: 0.635 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 = 10970
Speed: 0.930 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10970
Speed: 1.367 ms
|
|
Speed: 0.577 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1279
Speed: 0.649 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 = 23448
Speed: 1.053 ms
|
|
Speed: 0.683 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19155
Speed: 0.611 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23448
Speed: 1.710 ms
|
|
Speed: 0.681 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 = 23448
Speed: 0.915 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23448
Speed: 1.647 ms
|
|
Speed: 0.546 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1715
Speed: 0.662 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 = 9903
Speed: 0.943 ms
|
|
Speed: 0.732 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10168
Speed: 0.562 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10169
Speed: 0.531 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9903
Speed: 1.206 ms
|
|
Speed: 0.785 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3032
Speed: 0.715 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3033
Speed: 0.648 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3034
Speed: 0.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 = 9903
Speed: 1.070 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9903
Speed: 1.216 ms
|
|
SELECT * FROM sections WHERE section_id = 162
Speed: 0.525 ms
|
|
SELECT * FROM section_settings WHERE section_id = 162
Speed: 0.796 ms
|
|
Speed: 0.561 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1242
Speed: 0.607 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 10749
Speed: 0.965 ms
|
|
Speed: 0.729 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11864
Speed: 0.594 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11865
Speed: 0.572 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10749
Speed: 1.263 ms
|
|
Speed: 0.796 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5345
Speed: 0.665 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5346
Speed: 0.612 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5347
Speed: 0.638 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 = 10749
Speed: 0.915 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10749
Speed: 1.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 = 10634
Speed: 0.935 ms
|
|
Speed: 0.703 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11636
Speed: 0.569 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11637
Speed: 0.555 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10634
Speed: 1.254 ms
|
|
Speed: 0.819 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5051
Speed: 0.911 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5052
Speed: 0.568 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5053
Speed: 0.540 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 = 10634
Speed: 0.750 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10634
Speed: 1.108 ms
|
|
Speed: 0.489 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1266
Speed: 0.510 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 = 10119
Speed: 0.785 ms
|
|
Speed: 0.599 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10601
Speed: 0.481 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10602
Speed: 0.474 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10119
Speed: 1.158 ms
|
|
Speed: 0.650 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3618
Speed: 0.562 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3619
Speed: 0.514 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 = 10119
Speed: 0.736 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10119
Speed: 1.126 ms
|
|
Speed: 0.474 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1247
Speed: 0.490 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 = 11913
Speed: 1.185 ms
|
|
Speed: 0.844 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14400
Speed: 0.678 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14401
Speed: 0.653 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11913
Speed: 1.596 ms
|
|
Speed: 0.922 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8554
Speed: 0.782 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8555
Speed: 0.745 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8556
Speed: 0.717 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 = 11913
Speed: 1.117 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11913
Speed: 1.428 ms
|
|
Speed: 0.603 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1306
Speed: 0.764 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 = 23366
Speed: 1.117 ms
|
|
Speed: 0.827 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 18995
Speed: 0.674 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 18996
Speed: 0.659 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23366
Speed: 1.714 ms
|
|
Speed: 1.320 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14439
Speed: 0.783 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14440
Speed: 0.752 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14441
Speed: 0.717 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 = 23366
Speed: 1.055 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23366
Speed: 1.504 ms
|
|
Speed: 0.613 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1712
Speed: 0.768 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 = 9603
Speed: 1.143 ms
|
|
Speed: 0.671 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9569
Speed: 0.543 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9570
Speed: 0.515 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9603
Speed: 1.302 ms
|
|
Speed: 0.984 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2146
Speed: 0.791 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2147
Speed: 0.552 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2148
Speed: 0.504 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2149
Speed: 0.613 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2150
Speed: 2.622 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2151
Speed: 0.585 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2152
Speed: 0.561 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2153
Speed: 0.776 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2154
Speed: 0.538 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2155
Speed: 0.488 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 9603
Speed: 0.820 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9603
Speed: 1.164 ms
|
|
Speed: 0.470 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1235
Speed: 8.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 = 10927
Speed: 1.465 ms
|
|
Speed: 0.955 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12215
Speed: 0.683 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12216
Speed: 0.675 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10927
Speed: 1.558 ms
|
|
Speed: 0.935 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5842
Speed: 0.615 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5843
Speed: 0.571 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5844
Speed: 0.769 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 = 10927
Speed: 1.014 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10927
Speed: 1.476 ms
|
|
Speed: 0.579 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1277
Speed: 0.879 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 = 230504
Speed: 0.998 ms
|
|
Speed: 0.938 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 26101
Speed: 0.818 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 26102
Speed: 0.879 ms
|
|
SELECT * FROM article_settings WHERE article_id = 230504
Speed: 1.374 ms
|
|
Speed: 0.986 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16090
Speed: 0.764 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 16091
Speed: 0.784 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 = 230504
Speed: 1.067 ms
|
|
SELECT * FROM article_settings WHERE article_id = 230504
Speed: 1.056 ms
|
|
Speed: 0.598 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2129
Speed: 0.822 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 = 10734
Speed: 1.121 ms
|
|
Speed: 0.845 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11836
Speed: 0.756 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11837
Speed: 0.678 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10734
Speed: 1.534 ms
|
|
Speed: 1.082 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5310
Speed: 0.777 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5311
Speed: 0.739 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5312
Speed: 0.720 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5313
Speed: 0.727 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5314
Speed: 0.898 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5315
Speed: 0.785 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 = 10734
Speed: 1.183 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10734
Speed: 1.390 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.183 ms
|
|
Speed: 0.959 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5607
Speed: 0.705 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 1.145 ms
|
|
Speed: 0.786 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: 1.096 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 1.089 ms
|
|
Speed: 0.631 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 993
Speed: 1.097 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 = 10377
Speed: 1.382 ms
|
|
Speed: 0.902 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11119
Speed: 0.758 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11120
Speed: 0.670 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10377
Speed: 1.859 ms
|
|
Speed: 1.067 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4319
Speed: 0.829 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4320
Speed: 0.783 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4321
Speed: 0.775 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4322
Speed: 0.737 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4323
Speed: 0.715 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4324
Speed: 0.732 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 = 10377
Speed: 1.123 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10377
Speed: 1.327 ms
|
|
Speed: 0.654 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1256
Speed: 8.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 = 15225
Speed: 6.718 ms
|
|
Speed: 1.019 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 17987
Speed: 0.706 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 17988
Speed: 0.706 ms
|
|
SELECT * FROM article_settings WHERE article_id = 15225
Speed: 1.374 ms
|
|
Speed: 0.930 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13489
Speed: 0.878 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13490
Speed: 0.866 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13491
Speed: 0.783 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 = 15225
Speed: 1.159 ms
|
|
SELECT * FROM article_settings WHERE article_id = 15225
Speed: 1.343 ms
|
|
Speed: 0.721 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1545
Speed: 0.822 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 = 10341
Speed: 1.215 ms
|
|
Speed: 0.871 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11046
Speed: 0.668 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11047
Speed: 0.649 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10341
Speed: 1.379 ms
|
|
Speed: 0.946 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4215
Speed: 0.781 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4216
Speed: 0.742 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4217
Speed: 0.719 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 = 10341
Speed: 1.103 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10341
Speed: 1.394 ms
|
|
Speed: 0.628 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1255
Speed: 0.745 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 = 110232
Speed: 1.167 ms
|
|
Speed: 0.815 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 22158
Speed: 0.707 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 22159
Speed: 0.665 ms
|
|
SELECT * FROM article_settings WHERE article_id = 110232
Speed: 1.824 ms
|
|
Speed: 1.002 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 15652
Speed: 0.836 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 15653
Speed: 0.825 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 15654
Speed: 0.791 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 = 110232
Speed: 1.108 ms
|
|
SELECT * FROM article_settings WHERE article_id = 110232
Speed: 1.902 ms
|
|
Speed: 1.233 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1990
Speed: 0.906 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 = 9679
Speed: 1.208 ms
|
|
Speed: 0.909 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9721
Speed: 0.680 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9722
Speed: 0.656 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9679
Speed: 1.426 ms
|
|
Speed: 0.947 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2372
Speed: 0.818 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2373
Speed: 0.805 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2374
Speed: 0.798 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 = 9679
Speed: 1.076 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9679
Speed: 1.356 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 = 6209
Speed: 1.197 ms
|
|
Speed: 0.835 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5457
Speed: 0.662 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6209
Speed: 1.009 ms
|
|
Speed: 0.824 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 = 6209
Speed: 1.149 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6209
Speed: 1.010 ms
|
|
Speed: 0.630 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 986
Speed: 0.748 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 = 11117
Speed: 1.148 ms
|
|
Speed: 0.846 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12594
Speed: 0.700 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12595
Speed: 0.662 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11117
Speed: 1.607 ms
|
|
Speed: 0.802 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 = 11117
Speed: 1.108 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11117
Speed: 1.521 ms
|
|
Speed: 0.639 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1283
Speed: 0.734 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 = 7501
Speed: 1.142 ms
|
|
Speed: 1.295 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 7130
Speed: 1.078 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 7131
Speed: 1.309 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7501
Speed: 1.452 ms
|
|
Speed: 0.931 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1443
Speed: 0.896 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 = 7501
Speed: 1.401 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7501
Speed: 1.487 ms
|
|
SELECT * FROM sections WHERE section_id = 159
Speed: 0.938 ms
|
|
SELECT * FROM section_settings WHERE section_id = 159
Speed: 1.260 ms
|
|
Speed: 0.701 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1034
Speed: 0.797 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 = 9694
Speed: 1.163 ms
|
|
Speed: 0.930 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9751
Speed: 1.001 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9752
Speed: 0.876 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9694
Speed: 2.014 ms
|
|
Speed: 0.843 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 = 9694
Speed: 2.858 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9694
Speed: 1.726 ms
|
|
SELECT * FROM sections WHERE section_id = 160
Speed: 0.874 ms
|
|
SELECT * FROM section_settings WHERE section_id = 160
Speed: 7.237 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 = 11427
Speed: 1.178 ms
|
|
Speed: 0.893 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13222
Speed: 0.719 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13223
Speed: 0.682 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11427
Speed: 1.376 ms
|
|
Speed: 1.086 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7326
Speed: 0.785 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7327
Speed: 0.801 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7328
Speed: 0.789 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 = 11427
Speed: 1.077 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11427
Speed: 1.367 ms
|
|
Speed: 0.636 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1291
Speed: 0.713 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 = 6970
Speed: 1.209 ms
|
|
Speed: 0.880 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6219
Speed: 0.790 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6970
Speed: 1.106 ms
|
|
Speed: 0.813 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 = 6970
Speed: 1.208 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6970
Speed: 1.021 ms
|
|
Speed: 0.623 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1016
Speed: 0.737 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 = 22870
Speed: 1.715 ms
|
|
Speed: 1.030 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28037
Speed: 0.842 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 28038
Speed: 0.788 ms
|
|
SELECT * FROM article_settings WHERE article_id = 22870
Speed: 1.545 ms
|
|
Speed: 1.075 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14036
Speed: 0.609 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14037
Speed: 1.037 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 = 22870
Speed: 0.861 ms
|
|
SELECT * FROM article_settings WHERE article_id = 22870
Speed: 1.151 ms
|
|
Speed: 0.755 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2569
Speed: 0.702 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 = 12311
Speed: 1.122 ms
|
|
Speed: 0.738 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14996
Speed: 0.640 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14997
Speed: 0.538 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12311
Speed: 1.685 ms
|
|
Speed: 1.038 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9090
Speed: 1.165 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9091
Speed: 0.667 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9092
Speed: 1.338 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 = 12311
Speed: 2.357 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12311
Speed: 3.482 ms
|
|
Speed: 0.704 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1336
Speed: 1.023 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 = 13973
Speed: 1.244 ms
|
|
Speed: 1.455 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16817
Speed: 1.243 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16818
Speed: 1.046 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13973
Speed: 1.609 ms
|
|
Speed: 1.121 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12966
Speed: 0.597 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12967
Speed: 3.445 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12968
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 = 13973
Speed: 4.051 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13973
Speed: 1.334 ms
|
|
Speed: 0.646 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1456
Speed: 0.719 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 7035
Speed: 1.046 ms
|
|
Speed: 0.840 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6288
Speed: 0.618 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7035
Speed: 0.898 ms
|
|
Speed: 0.729 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 707
Speed: 0.678 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 708
Speed: 0.826 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 = 7035
Speed: 3.199 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7035
Speed: 1.089 ms
|
|
Speed: 0.860 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1020
Speed: 2.106 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 = 6196
Speed: 2.066 ms
|
|
Speed: 1.042 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5444
Speed: 0.742 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6196
Speed: 1.274 ms
|
|
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 462
Speed: 1.062 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 = 6196
Speed: 1.330 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6196
Speed: 1.178 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 = 7231
Speed: 1.069 ms
|
|
Speed: 0.870 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 27597
Speed: 0.677 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 27598
Speed: 1.117 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7231
Speed: 0.943 ms
|
|
Speed: 1.662 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1001
Speed: 0.875 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 = 7231
Speed: 1.823 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7231
Speed: 1.399 ms
|
|
Speed: 5.847 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1026
Speed: 1.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 = 5699
Speed: 1.224 ms
|
|
Speed: 1.145 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 4919
Speed: 0.857 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5699
Speed: 1.258 ms
|
|
Speed: 0.857 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 = 5699
Speed: 2.349 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5699
Speed: 1.352 ms
|
|
Speed: 0.844 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 927
Speed: 1.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 = 6272
Speed: 1.401 ms
|
|
Speed: 0.918 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5519
Speed: 0.693 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6272
Speed: 1.027 ms
|
|
Speed: 0.775 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 = 6272
Speed: 1.047 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6272
Speed: 1.020 ms
|
|
SELECT * FROM sections WHERE section_id = 157
Speed: 0.694 ms
|
|
SELECT * FROM section_settings WHERE section_id = 157
Speed: 1.434 ms
|
|
Speed: 1.136 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 991
Speed: 1.231 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 = 13653
Speed: 8.867 ms
|
|
Speed: 4.856 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16522
Speed: 3.417 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16523
Speed: 3.294 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13653
Speed: 1.659 ms
|
|
Speed: 1.069 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12648
Speed: 0.841 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12649
Speed: 0.800 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12650
Speed: 0.829 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12651
Speed: 0.747 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12652
Speed: 0.757 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 = 13653
Speed: 1.075 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13653
Speed: 1.401 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 = 7149
Speed: 5.349 ms
|
|
Speed: 1.439 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6444
Speed: 1.026 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7149
Speed: 1.213 ms
|
|
Speed: 2.457 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 847
Speed: 0.954 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 = 7149
Speed: 1.124 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7149
Speed: 1.087 ms
|
|
Speed: 0.971 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1023
Speed: 0.776 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 = 7043
Speed: 1.585 ms
|
|
Speed: 1.028 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6296
Speed: 0.919 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7043
Speed: 1.389 ms
|
|
Speed: 1.216 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 721
Speed: 0.977 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 722
Speed: 0.971 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 = 7043
Speed: 1.479 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7043
Speed: 1.676 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 = 11422
Speed: 1.712 ms
|
|
Speed: 1.116 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13212
Speed: 1.200 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13213
Speed: 0.667 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11422
Speed: 1.670 ms
|
|
Speed: 1.243 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7313
Speed: 0.897 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7314
Speed: 4.075 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7315
Speed: 0.902 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 = 11422
Speed: 1.586 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11422
Speed: 1.589 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 = 10865
Speed: 1.503 ms
|
|
Speed: 6.800 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12095
Speed: 2.292 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12096
Speed: 0.960 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10865
Speed: 1.818 ms
|
|
Speed: 1.449 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5684
Speed: 1.029 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5685
Speed: 0.849 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5686
Speed: 0.808 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5687
Speed: 0.815 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5688
Speed: 0.817 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5689
Speed: 0.749 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5690
Speed: 0.724 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 = 10865
Speed: 1.187 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10865
Speed: 1.422 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 = 9824
Speed: 1.119 ms
|
|
Speed: 0.882 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10010
Speed: 0.669 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10011
Speed: 0.652 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9824
Speed: 1.329 ms
|
|
Speed: 0.766 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 = 9824
Speed: 1.025 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9824
Speed: 1.332 ms
|
|
Speed: 0.631 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1240
Speed: 0.719 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 11898
Speed: 1.108 ms
|
|
Speed: 1.119 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14371
Speed: 0.726 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11898
Speed: 1.423 ms
|
|
Speed: 1.042 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8517
Speed: 0.905 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8518
Speed: 0.760 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 = 11898
Speed: 1.061 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11898
Speed: 1.414 ms
|
|
Speed: 0.628 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1305
Speed: 0.731 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 = 7006
Speed: 1.198 ms
|
|
Speed: 0.807 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6255
Speed: 0.696 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7006
Speed: 0.999 ms
|
|
Speed: 0.846 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 676
Speed: 0.736 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 = 7006
Speed: 1.130 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7006
Speed: 0.965 ms
|
|
Speed: 0.663 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1017
Speed: 0.699 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 = 6228
Speed: 1.076 ms
|
|
Speed: 0.777 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5476
Speed: 0.649 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6228
Speed: 1.109 ms
|
|
Speed: 0.805 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 = 6228
Speed: 1.023 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6228
Speed: 1.092 ms
|
|
Speed: 45.549 ms
|
|
Speed: 0.915 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 2634
Speed: 0.640 ms
|
|
Speed: 1.774 ms
|
|
SELECT * FROM author_settings WHERE author_id = 70905
Speed: 1.046 ms
|
|
SELECT * FROM author_settings WHERE author_id = 70999
Speed: 0.895 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71000
Speed: 0.882 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71001
Speed: 0.863 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71002
Speed: 0.859 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71003
Speed: 0.903 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71004
Speed: 0.880 ms
|
|
SELECT * FROM author_settings WHERE author_id = 71005
Speed: 0.884 ms
|
|
Speed: 1.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 70518
Speed: 1.806 ms
|
|
SELECT * FROM author_settings WHERE author_id = 70519
Speed: 0.937 ms
|
|
Speed: 1.292 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61403
Speed: 0.947 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61402
Speed: 0.870 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61404
Speed: 0.850 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61405
Speed: 0.846 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61406
Speed: 0.884 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61407
Speed: 0.776 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61408
Speed: 0.789 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61409
Speed: 0.859 ms
|
|
Speed: 1.126 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60358
Speed: 0.860 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60381
Speed: 0.799 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60382
Speed: 0.980 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60383
Speed: 1.025 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60384
Speed: 0.946 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60385
Speed: 0.964 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60386
Speed: 0.984 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60387
Speed: 1.001 ms
|
|
Speed: 1.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26547
Speed: 1.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26548
Speed: 1.010 ms
|
|
Speed: 1.501 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27180
Speed: 1.183 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27181
Speed: 1.132 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27182
Speed: 1.112 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27183
Speed: 2.087 ms
|
|
Speed: 8.628 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23111
Speed: 1.302 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23112
Speed: 6.552 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23113
Speed: 1.082 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23114
Speed: 1.091 ms
|
|
Speed: 3.504 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22018
Speed: 1.055 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22019
Speed: 0.998 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22020
Speed: 0.962 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22021
Speed: 1.204 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22022
Speed: 1.056 ms
|
|
Speed: 1.512 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61854
Speed: 1.031 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61855
Speed: 0.985 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61856
Speed: 1.052 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61857
Speed: 1.056 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61858
Speed: 1.014 ms
|
|
Speed: 1.333 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37926
Speed: 1.180 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37927
Speed: 1.047 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37928
Speed: 1.001 ms
|
|
Speed: 1.345 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24794
Speed: 1.107 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24795
Speed: 0.983 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24796
Speed: 0.984 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24797
Speed: 0.999 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24798
Speed: 1.056 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24799
Speed: 1.046 ms
|
|
Speed: 1.514 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22749
Speed: 1.174 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22750
Speed: 1.046 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22751
Speed: 1.048 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22752
Speed: 1.053 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22753
Speed: 0.975 ms
|
|
Speed: 1.941 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61394
Speed: 1.186 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61393
Speed: 1.067 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61395
Speed: 1.096 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61396
Speed: 1.205 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61397
Speed: 1.066 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61398
Speed: 1.058 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61399
Speed: 1.014 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61400
Speed: 1.065 ms
|
|
Speed: 1.535 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30657
Speed: 1.115 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30658
Speed: 1.009 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30659
Speed: 1.012 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30660
Speed: 0.978 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30661
Speed: 1.013 ms
|
|
Speed: 1.397 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29156
Speed: 1.213 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29157
Speed: 1.091 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29158
Speed: 0.975 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29159
Speed: 1.065 ms
|
|
Speed: 1.478 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28554
Speed: 1.052 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28555
Speed: 0.980 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28556
Speed: 0.973 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28557
Speed: 1.044 ms
|
|
Speed: 1.571 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26635
Speed: 1.064 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26636
Speed: 1.083 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26637
Speed: 0.964 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26638
Speed: 0.949 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26639
Speed: 0.949 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26640
Speed: 0.926 ms
|
|
Speed: 1.431 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61737
Speed: 0.934 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61738
Speed: 0.861 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61739
Speed: 0.812 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61740
Speed: 0.779 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61741
Speed: 0.794 ms
|
|
SELECT * FROM author_settings WHERE author_id = 61742
Speed: 0.800 ms
|
|
Speed: 1.073 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27669
Speed: 0.890 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27670
Speed: 0.833 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27671
Speed: 0.807 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27672
Speed: 0.788 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27673
Speed: 0.849 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27674
Speed: 0.865 ms
|
|
Speed: 1.026 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46902
Speed: 1.131 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46903
Speed: 0.822 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46904
Speed: 0.744 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46905
Speed: 0.866 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46906
Speed: 0.810 ms
|
|
Speed: 1.158 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23050
Speed: 0.829 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23051
Speed: 0.729 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23052
Speed: 0.733 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23053
Speed: 0.733 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23054
Speed: 0.728 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23055
Speed: 0.824 ms
|
|
Speed: 1.206 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26669
Speed: 0.789 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26670
Speed: 0.770 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26671
Speed: 0.750 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26672
Speed: 0.786 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26673
Speed: 0.803 ms
|
|
Speed: 1.597 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26223
Speed: 1.069 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26224
Speed: 0.984 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26225
Speed: 0.928 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26226
Speed: 0.898 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26227
Speed: 0.915 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26228
Speed: 1.230 ms
|
|
Speed: 1.507 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23953
Speed: 1.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23954
Speed: 1.176 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23955
Speed: 0.953 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23956
Speed: 0.921 ms
|
|
Speed: 1.509 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31805
Speed: 1.043 ms
|
|
Speed: 1.768 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46538
Speed: 1.131 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46539
Speed: 0.958 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46540
Speed: 0.933 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46541
Speed: 1.343 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46542
Speed: 1.016 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46543
Speed: 1.039 ms
|
|
Speed: 1.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21726
Speed: 1.180 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21727
Speed: 1.002 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21728
Speed: 0.960 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21729
Speed: 0.977 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21730
Speed: 0.949 ms
|
|
Speed: 1.581 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27490
Speed: 1.043 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27491
Speed: 1.018 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27492
Speed: 0.945 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27493
Speed: 1.033 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27494
Speed: 0.971 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27495
Speed: 1.018 ms
|
|
Speed: 1.472 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60145
Speed: 1.207 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60146
Speed: 1.071 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60147
Speed: 1.044 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60148
Speed: 1.057 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60149
Speed: 1.099 ms
|
|
SELECT * FROM author_settings WHERE author_id = 60150
Speed: 1.073 ms
|
|
Speed: 1.375 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26623
Speed: 1.219 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26624
Speed: 1.107 ms
|
|
Speed: 1.470 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11974
Speed: 1.058 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11975
Speed: 0.966 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11976
Speed: 1.006 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11977
Speed: 1.013 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11978
Speed: 0.987 ms
|
|
Speed: 1.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25106
Speed: 1.319 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25107
Speed: 1.069 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25108
Speed: 1.061 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25109
Speed: 1.044 ms
|
|
Speed: 1.351 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41396
Speed: 1.158 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41397
Speed: 1.131 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41398
Speed: 1.042 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41399
Speed: 1.146 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41400
Speed: 1.133 ms
|
|
Speed: 1.435 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24948
Speed: 1.119 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24949
Speed: 0.970 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24950
Speed: 0.916 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24951
Speed: 0.909 ms
|
|
Speed: 1.459 ms
|
|
SELECT * FROM author_settings WHERE author_id = 54512
Speed: 1.048 ms
|
|
SELECT * FROM author_settings WHERE author_id = 54513
Speed: 0.970 ms
|
|
SELECT * FROM author_settings WHERE author_id = 54514
Speed: 0.950 ms
|
|
SELECT * FROM author_settings WHERE author_id = 54515
Speed: 0.984 ms
|
|
SELECT * FROM author_settings WHERE author_id = 54516
Speed: 0.966 ms
|
|
Speed: 1.397 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22060
Speed: 1.174 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22061
Speed: 0.918 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22062
Speed: 0.932 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22063
Speed: 0.922 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22064
Speed: 1.086 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22065
Speed: 0.971 ms
|
|
Speed: 1.331 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11389
Speed: 1.014 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11390
Speed: 0.919 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11391
Speed: 0.937 ms
|
|
Speed: 1.330 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28355
Speed: 1.145 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28356
Speed: 1.110 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28357
Speed: 1.005 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28358
Speed: 1.090 ms
|
|
Speed: 1.496 ms
|
|
SELECT * FROM author_settings WHERE author_id = 16653
Speed: 1.069 ms
|
|
SELECT * FROM author_settings WHERE author_id = 16654
Speed: 0.965 ms
|
|
Speed: 1.394 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22136
Speed: 1.076 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22137
Speed: 0.959 ms
|
|
Speed: 1.413 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29714
Speed: 1.060 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29715
Speed: 1.020 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29716
Speed: 0.914 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29717
Speed: 0.959 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29718
Speed: 0.945 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29719
Speed: 0.925 ms
|
|
Speed: 1.468 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14461
Speed: 1.099 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14462
Speed: 0.898 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14463
Speed: 0.879 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14464
Speed: 0.878 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14465
Speed: 0.897 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14466
Speed: 0.863 ms
|
|
Speed: 1.455 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45240
Speed: 0.859 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45241
Speed: 0.803 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45242
Speed: 0.815 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45243
Speed: 0.775 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45244
Speed: 0.828 ms
|
|
SELECT * FROM author_settings WHERE author_id = 45245
Speed: 0.824 ms
|
|
Speed: 1.095 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33057
Speed: 0.808 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33058
Speed: 0.773 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33059
Speed: 0.773 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33060
Speed: 0.783 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33061
Speed: 0.798 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33062
Speed: 0.845 ms
|
|
Speed: 1.352 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39156
Speed: 1.164 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39157
Speed: 1.001 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39158
Speed: 0.973 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39159
Speed: 0.969 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39160
Speed: 1.371 ms
|
|
Speed: 1.626 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14724
Speed: 1.153 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14725
Speed: 1.053 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14726
Speed: 0.905 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14727
Speed: 1.006 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14728
Speed: 1.003 ms
|
|
Speed: 1.568 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11333
Speed: 0.916 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11334
Speed: 1.058 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11335
Speed: 1.089 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11336
Speed: 1.076 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11337
Speed: 1.004 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11338
Speed: 0.930 ms
|
|
Speed: 1.504 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15515
Speed: 1.114 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15516
Speed: 1.023 ms
|
|
Speed: 1.582 ms
|
|
SELECT * FROM author_settings WHERE author_id = 10128
Speed: 1.068 ms
|
|
SELECT * FROM author_settings WHERE author_id = 10129
Speed: 1.005 ms
|
|
SELECT * FROM author_settings WHERE author_id = 10130
Speed: 0.882 ms
|
|
SELECT * FROM author_settings WHERE author_id = 10131
Speed: 0.917 ms
|
|
Speed: 1.375 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11634
Speed: 1.062 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11635
Speed: 0.932 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11636
Speed: 0.893 ms
|
|
Speed: 1.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37908
Speed: 1.823 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37909
Speed: 1.033 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37910
Speed: 0.922 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37911
Speed: 0.907 ms
|
|
Speed: 1.357 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15180
Speed: 1.169 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15181
Speed: 1.003 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15182
Speed: 0.988 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15183
Speed: 1.118 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15184
Speed: 2.750 ms
|
|
Speed: 1.565 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14754
Speed: 1.131 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14755
Speed: 0.942 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14756
Speed: 1.954 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14757
Speed: 1.035 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14758
Speed: 0.808 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14759
Speed: 0.839 ms
|
|
Speed: 1.166 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29690
Speed: 0.747 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29691
Speed: 0.759 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29692
Speed: 0.704 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29693
Speed: 0.718 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29694
Speed: 0.772 ms
|
|
Speed: 1.127 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27225
Speed: 0.964 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27226
Speed: 0.815 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27227
Speed: 0.797 ms
|
|
Speed: 1.177 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22703
Speed: 0.909 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22704
Speed: 0.805 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22705
Speed: 0.792 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22706
Speed: 0.759 ms
|
|
Speed: 1.301 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31738
Speed: 0.819 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31739
Speed: 0.768 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31740
Speed: 0.753 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31741
Speed: 0.786 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31742
Speed: 0.784 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31743
Speed: 0.765 ms
|
|
Speed: 1.164 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14619
Speed: 0.926 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14620
Speed: 0.945 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14621
Speed: 0.780 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14622
Speed: 0.739 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14623
Speed: 0.711 ms
|
|
Speed: 1.298 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11462
Speed: 0.953 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11463
Speed: 0.784 ms
|
