|
SELECT * FROM sessions WHERE session_id = fv0o08f0ire40it7dqjlsht0f5
Speed: 1.293 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(fv0o08f0ire40it7dqjlsht0f5, 54.156.67.164, CCBot/2.0 (http://commoncrawl.org/faq/), 1505983796, 1505983796, 0, , periodicos.ufpe.br
Speed: 1.059 ms
|
|
SELECT * FROM journals WHERE path = re
Speed: 1.002 ms
|
|
Speed: 0.954 ms
|
|
Speed: 18.249 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 1.392 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.063 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.961 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.854 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.823 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.849 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.809 ms
|
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.854 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: 124.568 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: 17.198 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 10714
Speed: 2.177 ms
|
|
Speed: 1.537 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11796
Speed: 1.015 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11797
Speed: 1.009 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10714
Speed: 10.853 ms
|
|
Speed: 1.612 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5257
Speed: 1.179 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5258
Speed: 1.095 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5259
Speed: 1.075 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5260
Speed: 1.089 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5261
Speed: 1.036 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.751 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10714
Speed: 10.440 ms
|
|
SELECT * FROM sections WHERE section_id = 155
Speed: 1.128 ms
|
|
SELECT * FROM section_settings WHERE section_id = 155
Speed: 4.226 ms
|
|
Speed: 0.909 ms
|
|
Speed: 1.198 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1270
Speed: 1.040 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.891 ms
|
|
Speed: 1.335 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9701
Speed: 1.002 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9702
Speed: 1.030 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9669
Speed: 10.747 ms
|
|
Speed: 1.510 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2337
Speed: 1.148 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2338
Speed: 1.152 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2339
Speed: 1.137 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.737 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9669
Speed: 10.719 ms
|
|
Speed: 1.389 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1237
Speed: 1.085 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.826 ms
|
|
Speed: 1.378 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16532
Speed: 1.058 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16533
Speed: 1.039 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13658
Speed: 16.749 ms
|
|
Speed: 1.484 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12665
Speed: 1.209 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.122 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 13658
Speed: 1.773 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13658
Speed: 16.279 ms
|
|
SELECT * FROM sections WHERE section_id = 161
Speed: 1.069 ms
|
|
SELECT * FROM section_settings WHERE section_id = 161
Speed: 4.106 ms
|
|
Speed: 1.109 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1241
Speed: 1.014 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.922 ms
|
|
Speed: 1.340 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10196
Speed: 1.027 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10197
Speed: 1.064 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9917
Speed: 9.947 ms
|
|
Speed: 1.497 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3057
Speed: 1.240 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3058
Speed: 1.193 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3059
Speed: 1.211 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 9917
Speed: 1.755 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9917
Speed: 9.944 ms
|
|
Speed: 1.088 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1243
Speed: 1.035 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.844 ms
|
|
Speed: 1.308 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12075
Speed: 1.043 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12076
Speed: 1.006 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10855
Speed: 10.305 ms
|
|
Speed: 1.607 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5653
Speed: 1.334 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5654
Speed: 1.160 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5655
Speed: 1.187 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5656
Speed: 1.145 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.750 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10855
Speed: 10.242 ms
|
|
Speed: 1.155 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1275
Speed: 1.095 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.869 ms
|
|
Speed: 1.336 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10977
Speed: 1.008 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10978
Speed: 1.014 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10307
Speed: 9.774 ms
|
|
Speed: 1.655 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4097
Speed: 1.124 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4098
Speed: 1.110 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4099
Speed: 1.110 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4100
Speed: 1.069 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4101
Speed: 1.081 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4102
Speed: 1.141 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4103
Speed: 1.098 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.716 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10307
Speed: 9.834 ms
|
|
Speed: 1.228 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1254
Speed: 1.059 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: 1.900 ms
|
|
Speed: 1.351 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12971
Speed: 1.005 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12972
Speed: 1.050 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11303
Speed: 10.126 ms
|
|
Speed: 1.784 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6961
Speed: 1.187 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6962
Speed: 1.184 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6963
Speed: 1.190 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6964
Speed: 1.163 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6965
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6966
Speed: 1.180 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6967
Speed: 1.179 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6968
Speed: 1.193 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 11303
Speed: 1.763 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11303
Speed: 10.359 ms
|
|
Speed: 1.299 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1289
Speed: 1.081 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.884 ms
|
|
Speed: 1.396 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13691
Speed: 1.028 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13692
Speed: 1.040 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11627
Speed: 10.086 ms
|
|
Speed: 1.728 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7839
Speed: 1.181 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7840
Speed: 1.125 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7841
Speed: 1.109 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7842
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 = 11627
Speed: 1.765 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11627
Speed: 10.077 ms
|
|
Speed: 1.094 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1297
Speed: 1.081 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: 1.868 ms
|
|
Speed: 1.370 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11844
Speed: 1.016 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11845
Speed: 1.005 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10739
Speed: 10.253 ms
|
|
Speed: 1.554 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5324
Speed: 1.297 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5325
Speed: 1.247 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5326
Speed: 1.229 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: 1.792 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10739
Speed: 10.210 ms
|
|
Speed: 1.129 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1271
Speed: 1.075 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: 1.891 ms
|
|
Speed: 1.350 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12692
Speed: 1.026 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12693
Speed: 1.000 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11165
Speed: 10.456 ms
|
|
Speed: 1.720 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6554
Speed: 1.131 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6555
Speed: 1.123 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6556
Speed: 1.189 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6557
Speed: 1.131 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6558
Speed: 1.145 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.803 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11165
Speed: 10.368 ms
|
|
Speed: 1.163 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1286
Speed: 1.073 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: 1.879 ms
|
|
Speed: 1.323 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12300
Speed: 1.040 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12301
Speed: 0.984 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10970
Speed: 11.568 ms
|
|
Speed: 1.624 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5970
Speed: 1.128 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5971
Speed: 1.124 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5972
Speed: 1.108 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 10970
Speed: 1.737 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10970
Speed: 11.457 ms
|
|
Speed: 1.195 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1279
Speed: 1.051 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: 1.814 ms
|
|
Speed: 1.283 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10168
Speed: 1.008 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10169
Speed: 0.964 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9903
Speed: 9.672 ms
|
|
Speed: 1.480 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3032
Speed: 1.084 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3033
Speed: 1.172 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3034
Speed: 1.089 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.650 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9903
Speed: 9.838 ms
|
|
SELECT * FROM sections WHERE section_id = 162
Speed: 1.090 ms
|
|
SELECT * FROM section_settings WHERE section_id = 162
Speed: 1.424 ms
|
|
Speed: 1.077 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1242
Speed: 1.020 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 10749
Speed: 1.885 ms
|
|
Speed: 1.323 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11864
Speed: 1.048 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11865
Speed: 0.993 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10749
Speed: 9.998 ms
|
|
Speed: 1.486 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5345
Speed: 1.158 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5346
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5347
Speed: 1.141 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: 1.738 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10749
Speed: 9.853 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.917 ms
|
|
Speed: 1.334 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10034
Speed: 1.015 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10035
Speed: 1.009 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9836
Speed: 10.450 ms
|
|
Speed: 1.495 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2831
Speed: 1.107 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2832
Speed: 1.104 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2833
Speed: 1.124 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: 1.776 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9836
Speed: 10.311 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: 1.866 ms
|
|
Speed: 1.279 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11636
Speed: 1.008 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11637
Speed: 0.988 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10634
Speed: 9.590 ms
|
|
Speed: 1.424 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5051
Speed: 1.174 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5052
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5053
Speed: 1.123 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 10634
Speed: 1.697 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10634
Speed: 9.677 ms
|
|
Speed: 1.097 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1266
Speed: 1.400 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.872 ms
|
|
Speed: 1.263 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19155
Speed: 1.047 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23448
Speed: 16.141 ms
|
|
Speed: 1.381 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: 1.790 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23448
Speed: 16.253 ms
|
|
Speed: 1.243 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1715
Speed: 1.175 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.918 ms
|
|
Speed: 1.331 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14400
Speed: 1.093 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14401
Speed: 1.065 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11913
Speed: 10.465 ms
|
|
Speed: 1.502 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8554
Speed: 1.247 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8555
Speed: 1.115 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8556
Speed: 1.139 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.723 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11913
Speed: 10.557 ms
|
|
Speed: 1.141 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1306
Speed: 1.223 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 10119
Speed: 1.821 ms
|
|
Speed: 1.415 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10601
Speed: 1.048 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10602
Speed: 0.989 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10119
Speed: 10.120 ms
|
|
Speed: 1.419 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3618
Speed: 1.142 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3619
Speed: 1.120 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: 1.668 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10119
Speed: 10.202 ms
|
|
SELECT * FROM sections WHERE section_id = 158
Speed: 1.059 ms
|
|
SELECT * FROM section_settings WHERE section_id = 158
Speed: 4.581 ms
|
|
Speed: 1.206 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1247
Speed: 1.089 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.895 ms
|
|
Speed: 1.321 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 18995
Speed: 1.065 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 18996
Speed: 1.017 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23366
Speed: 11.080 ms
|
|
Speed: 1.494 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14439
Speed: 1.184 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14440
Speed: 1.102 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14441
Speed: 1.102 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.729 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23366
Speed: 11.143 ms
|
|
Speed: 1.145 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1712
Speed: 1.139 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.862 ms
|
|
Speed: 1.312 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9569
Speed: 1.006 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9570
Speed: 0.984 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9603
Speed: 10.017 ms
|
|
Speed: 1.879 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2146
Speed: 1.168 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2147
Speed: 1.117 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2148
Speed: 1.109 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2149
Speed: 1.089 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2150
Speed: 1.227 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2151
Speed: 1.065 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2152
Speed: 1.077 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2153
Speed: 1.125 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2154
Speed: 1.099 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2155
Speed: 1.076 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: 1.746 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9603
Speed: 9.646 ms
|
|
Speed: 1.162 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1235
Speed: 1.173 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.867 ms
|
|
Speed: 1.242 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5607
Speed: 1.020 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 3.608 ms
|
|
Speed: 1.156 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.760 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6361
Speed: 3.649 ms
|
|
Speed: 1.038 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 993
Speed: 0.984 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.789 ms
|
|
Speed: 1.304 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11836
Speed: 1.015 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11837
Speed: 0.998 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10734
Speed: 10.131 ms
|
|
Speed: 1.537 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5310
Speed: 1.138 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5311
Speed: 1.070 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5312
Speed: 1.089 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5313
Speed: 1.098 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5314
Speed: 1.112 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5315
Speed: 1.087 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.665 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10734
Speed: 10.298 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.880 ms
|
|
Speed: 1.310 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11119
Speed: 1.057 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11120
Speed: 0.990 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10377
Speed: 10.018 ms
|
|
Speed: 1.547 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4319
Speed: 1.090 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4320
Speed: 1.041 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4321
Speed: 1.083 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4322
Speed: 1.052 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4323
Speed: 1.111 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4324
Speed: 1.094 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.743 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10377
Speed: 10.210 ms
|
|
Speed: 1.106 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1256
Speed: 1.043 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: 1.852 ms
|
|
Speed: 1.326 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 17987
Speed: 1.074 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 17988
Speed: 1.055 ms
|
|
SELECT * FROM article_settings WHERE article_id = 15225
Speed: 9.656 ms
|
|
Speed: 1.468 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13489
Speed: 1.316 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13490
Speed: 1.101 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13491
Speed: 1.018 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.787 ms
|
|
SELECT * FROM article_settings WHERE article_id = 15225
Speed: 9.922 ms
|
|
Speed: 1.093 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1545
Speed: 1.130 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.886 ms
|
|
Speed: 1.325 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9721
Speed: 1.020 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9722
Speed: 0.978 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9679
Speed: 10.361 ms
|
|
Speed: 1.503 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2372
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2373
Speed: 1.185 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2374
Speed: 1.124 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.786 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9679
Speed: 10.155 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.886 ms
|
|
Speed: 1.315 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11046
Speed: 0.999 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11047
Speed: 0.995 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10341
Speed: 9.954 ms
|
|
Speed: 1.470 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4215
Speed: 1.107 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4216
Speed: 1.080 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4217
Speed: 1.044 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.780 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10341
Speed: 10.312 ms
|
|
Speed: 1.196 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1255
Speed: 1.117 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.944 ms
|
|
Speed: 1.357 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5457
Speed: 1.111 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6209
Speed: 2.923 ms
|
|
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 = 6209
Speed: 1.873 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6209
Speed: 2.907 ms
|
|
Speed: 1.125 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 986
Speed: 1.090 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.966 ms
|
|
Speed: 1.430 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12594
Speed: 1.102 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12595
Speed: 1.032 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11117
Speed: 11.788 ms
|
|
Speed: 1.522 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.928 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11117
Speed: 11.414 ms
|
|
Speed: 1.140 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1283
Speed: 1.114 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.847 ms
|
|
Speed: 1.299 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12215
Speed: 0.992 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12216
Speed: 0.989 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10927
Speed: 10.832 ms
|
|
Speed: 1.641 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5842
Speed: 1.225 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5843
Speed: 1.322 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5844
Speed: 1.231 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.770 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10927
Speed: 10.797 ms
|
|
Speed: 1.136 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1277
Speed: 1.069 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6970
Speed: 1.897 ms
|
|
Speed: 1.226 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6219
Speed: 1.017 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6970
Speed: 3.228 ms
|
|
Speed: 1.150 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6970
Speed: 1.713 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6970
Speed: 3.119 ms
|
|
Speed: 1.075 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1016
Speed: 1.025 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.773 ms
|
|
Speed: 1.309 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13222
Speed: 0.982 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13223
Speed: 0.978 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11427
Speed: 9.568 ms
|
|
Speed: 1.533 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7326
Speed: 1.275 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7327
Speed: 1.177 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7328
Speed: 1.190 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.656 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11427
Speed: 9.466 ms
|
|
Speed: 1.135 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1291
Speed: 1.070 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.837 ms
|
|
Speed: 1.393 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 7130
Speed: 0.993 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 7131
Speed: 0.999 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7501
Speed: 6.866 ms
|
|
Speed: 1.416 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1443
Speed: 1.173 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.663 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7501
Speed: 6.967 ms
|
|
SELECT * FROM sections WHERE section_id = 159
Speed: 1.115 ms
|
|
SELECT * FROM section_settings WHERE section_id = 159
Speed: 1.168 ms
|
|
Speed: 1.053 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1034
Speed: 1.017 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.841 ms
|
|
Speed: 1.352 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16817
Speed: 1.092 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16818
Speed: 1.019 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13973
Speed: 9.820 ms
|
|
Speed: 1.460 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12966
Speed: 1.118 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12967
Speed: 1.070 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12968
Speed: 1.154 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: 1.697 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13973
Speed: 9.785 ms
|
|
Speed: 1.226 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1456
Speed: 1.155 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.854 ms
|
|
Speed: 1.336 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14996
Speed: 1.034 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14997
Speed: 1.019 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12311
Speed: 10.053 ms
|
|
Speed: 1.536 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9090
Speed: 1.089 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9091
Speed: 1.139 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9092
Speed: 1.086 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: 1.763 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12311
Speed: 9.923 ms
|
|
Speed: 1.101 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1336
Speed: 1.026 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.855 ms
|
|
Speed: 1.245 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6288
Speed: 1.032 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7035
Speed: 2.733 ms
|
|
Speed: 1.496 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 707
Speed: 1.200 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 708
Speed: 1.180 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 7035
Speed: 1.734 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7035
Speed: 2.698 ms
|
|
Speed: 1.039 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1020
Speed: 0.991 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.846 ms
|
|
Speed: 1.298 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9751
Speed: 1.010 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 9752
Speed: 0.998 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9694
Speed: 14.596 ms
|
|
Speed: 1.328 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: 1.673 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9694
Speed: 14.560 ms
|
|
SELECT * FROM sections WHERE section_id = 160
Speed: 1.210 ms
|
|
SELECT * FROM section_settings WHERE section_id = 160
Speed: 9.778 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.027 ms
|
|
Speed: 1.350 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5444
Speed: 1.060 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6196
Speed: 3.874 ms
|
|
Speed: 1.339 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 462
Speed: 1.179 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6196
Speed: 1.792 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6196
Speed: 3.801 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.897 ms
|
|
Speed: 1.305 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6601
Speed: 1.040 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6602
Speed: 0.964 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7231
Speed: 3.907 ms
|
|
Speed: 1.327 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1001
Speed: 1.218 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.771 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7231
Speed: 3.933 ms
|
|
Speed: 1.181 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1026
Speed: 1.086 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 = 11863
Speed: 1.835 ms
|
|
Speed: 1.347 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14305
Speed: 1.046 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14306
Speed: 1.018 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11863
Speed: 9.740 ms
|
|
Speed: 1.593 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8409
Speed: 1.189 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8410
Speed: 1.173 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8411
Speed: 1.108 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 11863
Speed: 1.695 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11863
Speed: 9.648 ms
|
|
Speed: 1.139 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1304
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 = 5590
Speed: 1.914 ms
|
|
Speed: 1.263 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 4810
Speed: 0.991 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5590
Speed: 2.973 ms
|
|
Speed: 1.166 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 = 5590
Speed: 1.770 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5590
Speed: 2.999 ms
|
|
Speed: 1.116 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 924
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 = 23474
Speed: 1.848 ms
|
|
Speed: 1.295 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19206
Speed: 1.032 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19207
Speed: 1.024 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23474
Speed: 16.362 ms
|
|
Speed: 1.657 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14777
Speed: 1.071 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14778
Speed: 1.104 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14779
Speed: 1.080 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14780
Speed: 1.053 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14781
Speed: 1.025 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14782
Speed: 1.018 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 = 23474
Speed: 1.761 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23474
Speed: 16.371 ms
|
|
Speed: 1.118 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1716
Speed: 1.222 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 = 10793
Speed: 1.932 ms
|
|
Speed: 1.323 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11951
Speed: 1.028 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11952
Speed: 0.994 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10793
Speed: 10.052 ms
|
|
Speed: 1.466 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5470
Speed: 1.121 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5471
Speed: 1.114 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5472
Speed: 1.127 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 = 10793
Speed: 1.738 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10793
Speed: 10.045 ms
|
|
Speed: 1.136 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1273
Speed: 1.129 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 5591
Speed: 1.920 ms
|
|
Speed: 1.362 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 4811
Speed: 1.023 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5591
Speed: 2.764 ms
|
|
Speed: 1.434 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 372
Speed: 1.152 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 373
Speed: 1.177 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 5591
Speed: 2.173 ms
|
|
SELECT * FROM article_settings WHERE article_id = 5591
Speed: 2.771 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 = 13671
Speed: 1.895 ms
|
|
Speed: 1.339 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16558
Speed: 1.063 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16559
Speed: 1.030 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13671
Speed: 9.897 ms
|
|
Speed: 1.763 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12703
Speed: 1.196 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12704
Speed: 1.184 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12705
Speed: 1.109 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12706
Speed: 1.150 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12707
Speed: 1.162 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12708
Speed: 1.109 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12709
Speed: 1.078 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 = 13671
Speed: 1.740 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13671
Speed: 9.873 ms
|
|
Speed: 1.045 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1303
Speed: 1.095 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 = 23461
Speed: 1.851 ms
|
|
Speed: 1.312 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19180
Speed: 1.035 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19181
Speed: 1.011 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23461
Speed: 17.610 ms
|
|
Speed: 1.689 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14730
Speed: 1.141 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14731
Speed: 1.201 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14732
Speed: 1.053 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14733
Speed: 1.178 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14734
Speed: 1.109 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 = 23461
Speed: 1.770 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23461
Speed: 17.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 = 11113
Speed: 1.989 ms
|
|
Speed: 1.439 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12586
Speed: 1.123 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12587
Speed: 1.043 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11113
Speed: 9.957 ms
|
|
Speed: 1.622 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6390
Speed: 1.645 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 6391
Speed: 1.141 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 = 11113
Speed: 1.764 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11113
Speed: 9.940 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 = 10854
Speed: 1.980 ms
|
|
Speed: 1.295 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12073
Speed: 1.029 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12074
Speed: 0.970 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10854
Speed: 10.609 ms
|
|
Speed: 1.775 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5645
Speed: 1.234 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5646
Speed: 1.216 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5647
Speed: 1.196 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5648
Speed: 1.136 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5649
Speed: 1.134 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5650
Speed: 1.155 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5651
Speed: 1.176 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5652
Speed: 1.181 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 10854
Speed: 1.726 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10854
Speed: 10.519 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: 2.003 ms
|
|
Speed: 1.309 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6296
Speed: 1.056 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7043
Speed: 5.072 ms
|
|
Speed: 1.492 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 721
Speed: 1.059 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 722
Speed: 1.142 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.707 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7043
Speed: 4.939 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 9824
Speed: 1.967 ms
|
|
Speed: 1.329 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10010
Speed: 0.992 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 10011
Speed: 0.987 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9824
Speed: 10.191 ms
|
|
Speed: 1.334 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.724 ms
|
|
SELECT * FROM article_settings WHERE article_id = 9824
Speed: 10.376 ms
|
|
Speed: 1.170 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1240
Speed: 1.064 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.835 ms
|
|
Speed: 1.475 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13212
Speed: 1.021 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13213
Speed: 0.977 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11422
Speed: 9.939 ms
|
|
Speed: 1.509 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7313
Speed: 1.276 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7314
Speed: 1.216 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7315
Speed: 1.195 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.733 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11422
Speed: 9.901 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.949 ms
|
|
Speed: 1.347 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12095
Speed: 1.032 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 12096
Speed: 0.990 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10865
Speed: 9.883 ms
|
|
Speed: 1.725 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5684
Speed: 1.228 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5685
Speed: 1.133 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5686
Speed: 1.068 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5687
Speed: 1.207 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5688
Speed: 1.102 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5689
Speed: 1.093 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5690
Speed: 1.076 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.769 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10865
Speed: 9.873 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: 2.085 ms
|
|
Speed: 1.370 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6255
Speed: 1.083 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7006
Speed: 2.649 ms
|
|
Speed: 1.290 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 676
Speed: 1.252 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.755 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7006
Speed: 2.630 ms
|
|
Speed: 1.046 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1017
Speed: 1.065 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.736 ms
|
|
Speed: 1.244 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5476
Speed: 1.006 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6228
Speed: 3.390 ms
|
|
Speed: 1.219 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.655 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6228
Speed: 3.358 ms
|
|
SELECT * FROM sections WHERE section_id = 157
Speed: 1.211 ms
|
|
SELECT * FROM section_settings WHERE section_id = 157
Speed: 4.376 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.794 ms
|
|
Speed: 1.239 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 5519
Speed: 1.020 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6272
Speed: 2.784 ms
|
|
Speed: 1.130 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.692 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6272
Speed: 2.806 ms
|
|
Speed: 1.061 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 991
Speed: 1.084 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.814 ms
|
|
Speed: 1.250 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14371
Speed: 1.069 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11898
Speed: 10.995 ms
|
|
Speed: 1.591 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8517
Speed: 1.324 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8518
Speed: 1.237 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.646 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11898
Speed: 11.009 ms
|
|
Speed: 1.164 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1305
Speed: 1.195 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: 1.827 ms
|
|
Speed: 1.331 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16522
Speed: 1.051 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16523
Speed: 1.047 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13653
Speed: 9.867 ms
|
|
Speed: 1.613 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12648
Speed: 1.138 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12649
Speed: 1.132 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12650
Speed: 1.118 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12651
Speed: 1.153 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 12652
Speed: 1.090 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.652 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13653
Speed: 9.813 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: 1.823 ms
|
|
Speed: 1.269 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6444
Speed: 1.012 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7149
Speed: 2.889 ms
|
|
Speed: 1.282 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 847
Speed: 1.201 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.643 ms
|
|
SELECT * FROM article_settings WHERE article_id = 7149
Speed: 2.878 ms
|
|
Speed: 1.050 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1023
Speed: 1.079 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 = 11643
Speed: 1.790 ms
|
|
Speed: 1.452 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13736
Speed: 1.032 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13737
Speed: 1.033 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13738
Speed: 1.005 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 13739
Speed: 0.997 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11643
Speed: 9.555 ms
|
|
Speed: 1.553 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7874
Speed: 1.242 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7875
Speed: 1.186 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 11643
Speed: 1.636 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11643
Speed: 9.549 ms
|
|
Speed: 1.123 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1298
Speed: 1.124 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 = 11897
Speed: 1.838 ms
|
|
Speed: 1.249 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14369
Speed: 1.066 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14370
Speed: 1.040 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11897
Speed: 10.627 ms
|
|
Speed: 1.591 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8512
Speed: 1.236 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8513
Speed: 1.217 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8514
Speed: 1.233 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8515
Speed: 1.198 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8516
Speed: 1.245 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 11897
Speed: 1.671 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11897
Speed: 10.666 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 = 6883
Speed: 1.934 ms
|
|
Speed: 1.350 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6132
Speed: 1.070 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6883
Speed: 8.434 ms
|
|
Speed: 1.254 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6883
Speed: 1.824 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6883
Speed: 8.446 ms
|
|
Speed: 1.070 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1013
Speed: 1.067 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 = 23430
Speed: 1.911 ms
|
|
Speed: 1.300 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19120
Speed: 1.099 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 19121
Speed: 1.027 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23430
Speed: 7.932 ms
|
|
Speed: 1.541 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14635
Speed: 1.196 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14636
Speed: 1.384 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14637
Speed: 1.396 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 14638
Speed: 1.191 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 = 23430
Speed: 1.775 ms
|
|
SELECT * FROM article_settings WHERE article_id = 23430
Speed: 7.933 ms
|
|
Speed: 1.302 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1714
Speed: 1.251 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 = 6998
Speed: 1.949 ms
|
|
Speed: 1.346 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6247
Speed: 1.100 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6998
Speed: 2.697 ms
|
|
Speed: 1.181 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 6998
Speed: 1.803 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6998
Speed: 2.686 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 = 10330
Speed: 1.797 ms
|
|
Speed: 1.325 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11024
Speed: 0.999 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 11025
Speed: 0.991 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10330
Speed: 10.084 ms
|
|
Speed: 1.421 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4179
Speed: 1.108 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4180
Speed: 1.086 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 = 10330
Speed: 1.638 ms
|
|
SELECT * FROM article_settings WHERE article_id = 10330
Speed: 10.036 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 = 6838
Speed: 2.041 ms
|
|
Speed: 1.317 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 6086
Speed: 1.060 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6838
Speed: 2.929 ms
|
|
Speed: 1.323 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 606
Speed: 1.140 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 = 6838
Speed: 1.696 ms
|
|
SELECT * FROM article_settings WHERE article_id = 6838
Speed: 2.873 ms
|
|
Speed: 1.031 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1012
Speed: 1.059 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 = 12289
Speed: 1.844 ms
|
|
Speed: 1.260 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14952
Speed: 1.042 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14953
Speed: 0.998 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12289
Speed: 6.212 ms
|
|
Speed: 1.538 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9035
Speed: 1.195 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9036
Speed: 1.167 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9037
Speed: 1.197 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9038
Speed: 1.145 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9039
Speed: 1.104 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 9040
Speed: 1.100 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 = 12289
Speed: 1.708 ms
|
|
SELECT * FROM article_settings WHERE article_id = 12289
Speed: 6.114 ms
|
|
Speed: 1.153 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1335
Speed: 1.032 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 = 13989
Speed: 1.896 ms
|
|
Speed: 1.365 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16848
Speed: 1.052 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 16849
Speed: 1.048 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13989
Speed: 10.838 ms
|
|
Speed: 1.430 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13025
Speed: 1.112 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13026
Speed: 1.096 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 13027
Speed: 1.085 ms
|
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE article_id = 13989
Speed: 1.722 ms
|
|
SELECT * FROM article_settings WHERE article_id = 13989
Speed: 10.803 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 = 11779
Speed: 2.076 ms
|
|
Speed: 1.502 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14136
Speed: 1.069 ms
|
|
SELECT * FROM article_galley_settings WHERE galley_id = 14137
Speed: 1.030 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11779
Speed: 10.170 ms
|
|
Speed: 1.448 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8147
Speed: 1.119 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8148
Speed: 1.086 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8149
Speed: 1.075 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 = 11779
Speed: 1.750 ms
|
|
SELECT * FROM article_settings WHERE article_id = 11779
Speed: 10.177 ms
|
|
Speed: 1.152 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1302
Speed: 1.094 ms
|
|
Speed: 38.141 ms
|
|
Speed: 1.791 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 1716
Speed: 1.274 ms
|
|
Speed: 1.785 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26547
Speed: 1.457 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26548
Speed: 1.245 ms
|
|
Speed: 1.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22018
Speed: 1.313 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22019
Speed: 1.169 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22020
Speed: 1.182 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22021
Speed: 1.202 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22022
Speed: 1.201 ms
|
|
Speed: 1.363 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37926
Speed: 1.514 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37927
Speed: 1.337 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37928
Speed: 1.239 ms
|
|
Speed: 1.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23111
Speed: 1.477 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23112
Speed: 1.373 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23113
Speed: 1.467 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23114
Speed: 1.472 ms
|
|
Speed: 1.415 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27180
Speed: 1.438 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27181
Speed: 1.356 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27182
Speed: 1.350 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27183
Speed: 1.330 ms
|
|
Speed: 1.383 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24794
Speed: 1.436 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24795
Speed: 1.326 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24796
Speed: 1.312 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24797
Speed: 1.321 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24798
Speed: 1.291 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24799
Speed: 1.376 ms
|
|
Speed: 1.358 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29156
Speed: 1.400 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29157
Speed: 1.120 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29158
Speed: 1.122 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29159
Speed: 1.177 ms
|
|
Speed: 1.496 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30657
Speed: 1.230 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30658
Speed: 1.205 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30659
Speed: 1.225 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30660
Speed: 1.183 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30661
Speed: 1.200 ms
|
|
Speed: 1.610 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26635
Speed: 1.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26636
Speed: 1.333 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26637
Speed: 1.183 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26638
Speed: 1.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26639
Speed: 1.243 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26640
Speed: 1.377 ms
|
|
Speed: 1.537 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28554
Speed: 1.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28555
Speed: 1.806 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28556
Speed: 1.194 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28557
Speed: 1.328 ms
|
|
Speed: 1.717 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27669
Speed: 1.437 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27670
Speed: 1.315 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27671
Speed: 1.540 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27672
Speed: 1.324 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27673
Speed: 1.334 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27674
Speed: 1.275 ms
|
|
Speed: 1.734 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23050
Speed: 1.440 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23051
Speed: 1.365 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23052
Speed: 1.191 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23053
Speed: 1.184 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23054
Speed: 1.144 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23055
Speed: 1.201 ms
|
|
Speed: 1.719 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26669
Speed: 1.194 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26670
Speed: 1.132 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26671
Speed: 1.123 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26672
Speed: 1.128 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26673
Speed: 1.152 ms
|
|
Speed: 1.548 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22749
Speed: 1.572 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22750
Speed: 1.483 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22751
Speed: 1.360 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22752
Speed: 1.368 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22753
Speed: 2.941 ms
|
|
Speed: 1.950 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26223
Speed: 1.411 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26224
Speed: 1.380 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26225
Speed: 1.314 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26226
Speed: 1.412 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26227
Speed: 1.342 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26228
Speed: 1.369 ms
|
|
Speed: 2.420 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46902
Speed: 1.929 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46903
Speed: 1.215 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46904
Speed: 1.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46905
Speed: 1.681 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46906
Speed: 1.389 ms
|
|
Speed: 1.619 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31805
Speed: 1.341 ms
|
|
Speed: 1.405 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23953
Speed: 1.307 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23954
Speed: 1.243 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23955
Speed: 1.207 ms
|
|
SELECT * FROM author_settings WHERE author_id = 23956
Speed: 1.347 ms
|
|
Speed: 1.794 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46538
Speed: 1.463 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46539
Speed: 1.112 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46540
Speed: 1.128 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46541
Speed: 1.112 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46542
Speed: 1.098 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46543
Speed: 1.136 ms
|
|
Speed: 1.654 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21726
Speed: 1.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21727
Speed: 1.190 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21728
Speed: 1.215 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21729
Speed: 1.176 ms
|
|
SELECT * FROM author_settings WHERE author_id = 21730
Speed: 1.197 ms
|
|
Speed: 1.454 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11974
Speed: 1.194 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11975
Speed: 1.133 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11976
Speed: 1.113 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11977
Speed: 1.128 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11978
Speed: 1.111 ms
|
|
Speed: 1.408 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26623
Speed: 1.446 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26624
Speed: 1.358 ms
|
|
Speed: 1.438 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25106
Speed: 1.424 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25107
Speed: 1.306 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25108
Speed: 1.311 ms
|
|
SELECT * FROM author_settings WHERE author_id = 25109
Speed: 1.325 ms
|
|
Speed: 1.369 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41396
Speed: 1.462 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41397
Speed: 1.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41398
Speed: 1.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41399
Speed: 1.293 ms
|
|
SELECT * FROM author_settings WHERE author_id = 41400
Speed: 1.368 ms
|
|
Speed: 1.469 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22060
Speed: 1.278 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22061
Speed: 1.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22062
Speed: 1.181 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22063
Speed: 1.188 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22064
Speed: 1.215 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22065
Speed: 1.194 ms
|
|
Speed: 1.384 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24948
Speed: 1.457 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24949
Speed: 1.173 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24950
Speed: 1.083 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24951
Speed: 1.172 ms
|
|
Speed: 1.365 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11389
Speed: 1.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11390
Speed: 1.140 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11391
Speed: 1.119 ms
|
|
Speed: 1.329 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28355
Speed: 1.311 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28356
Speed: 1.343 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28357
Speed: 1.399 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28358
Speed: 1.422 ms
|
|
Speed: 1.169 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27490
Speed: 0.494 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27491
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27492
Speed: 0.473 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27493
Speed: 0.469 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27494
Speed: 0.488 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27495
Speed: 0.484 ms
|
|
Speed: 0.615 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14461
Speed: 0.609 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14462
Speed: 0.536 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14463
Speed: 0.538 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14464
Speed: 0.547 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14465
Speed: 0.554 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14466
Speed: 0.567 ms
|
|
Speed: 0.663 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29714
Speed: 0.555 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29715
Speed: 0.505 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29716
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29717
Speed: 0.502 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29718
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29719
Speed: 0.501 ms
|
|
Speed: 0.600 ms
|
|
SELECT * FROM author_settings WHERE author_id = 16653
Speed: 0.615 ms
|
|
SELECT * FROM author_settings WHERE author_id = 16654
Speed: 0.523 ms
|
|
Speed: 0.654 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39156
Speed: 0.607 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39157
Speed: 0.511 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39158
Speed: 0.509 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39159
Speed: 0.495 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39160
Speed: 0.502 ms
|
|
Speed: 0.677 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33057
Speed: 0.575 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33058
Speed: 0.528 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33059
Speed: 0.518 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33060
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33061
Speed: 0.504 ms
|
|
SELECT * FROM author_settings WHERE author_id = 33062
Speed: 0.542 ms
|
|
Speed: 0.648 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14724
Speed: 0.632 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14725
Speed: 0.594 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14726
Speed: 0.513 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14727
Speed: 0.512 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14728
Speed: 0.522 ms
|
|
Speed: 0.605 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22136
Speed: 0.629 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22137
Speed: 0.546 ms
|
|
Speed: 0.636 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11333
Speed: 0.610 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11334
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11335
Speed: 0.543 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11336
Speed: 0.525 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11337
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11338
Speed: 0.548 ms
|
|
Speed: 0.627 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15515
Speed: 0.627 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15516
Speed: 0.547 ms
|
|
Speed: 0.695 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31606
Speed: 0.596 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31607
Speed: 0.546 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31608
Speed: 0.542 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31609
Speed: 0.531 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31610
Speed: 0.550 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31611
Speed: 0.584 ms
|
|
Speed: 0.631 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9718
Speed: 0.631 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9719
Speed: 0.598 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9720
Speed: 0.577 ms
|
|
Speed: 0.715 ms
|
|
SELECT * FROM author_settings WHERE author_id = 47021
Speed: 0.567 ms
|
|
SELECT * FROM author_settings WHERE author_id = 47022
Speed: 0.510 ms
|
|
SELECT * FROM author_settings WHERE author_id = 47023
Speed: 0.534 ms
|
|
Speed: 0.731 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26879
Speed: 0.577 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26880
Speed: 0.570 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26881
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26882
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26883
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 26884
Speed: 0.499 ms
|
|
Speed: 0.620 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9721
Speed: 0.598 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9722
Speed: 0.527 ms
|
|
Speed: 0.639 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37976
Speed: 0.582 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37977
Speed: 0.533 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37978
Speed: 0.549 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37979
Speed: 0.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37980
Speed: 0.531 ms
|
|
Speed: 0.667 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46957
Speed: 0.558 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46958
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46959
Speed: 0.473 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46960
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46961
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46962
Speed: 0.484 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46963
Speed: 0.523 ms
|
|
Speed: 0.646 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28338
Speed: 0.924 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28339
Speed: 0.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28340
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28341
Speed: 0.554 ms
|
|
SELECT * FROM author_settings WHERE author_id = 28342
Speed: 0.585 ms
|
|
Speed: 0.768 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27175
Speed: 0.642 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27176
Speed: 0.515 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27177
Speed: 0.516 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27178
Speed: 0.510 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27179
Speed: 0.515 ms
|
|
Speed: 0.690 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14754
Speed: 0.620 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14755
Speed: 0.529 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14756
Speed: 0.513 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14757
Speed: 0.546 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14758
Speed: 0.517 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14759
Speed: 0.533 ms
|
|
Speed: 0.602 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22703
Speed: 0.595 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22704
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22705
Speed: 0.540 ms
|
|
SELECT * FROM author_settings WHERE author_id = 22706
Speed: 0.493 ms
|
|
Speed: 0.680 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29690
Speed: 0.582 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29691
Speed: 0.546 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29692
Speed: 0.630 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29693
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 29694
Speed: 0.508 ms
|
|
Speed: 0.635 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27225
Speed: 0.655 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27226
Speed: 0.540 ms
|
|
SELECT * FROM author_settings WHERE author_id = 27227
Speed: 0.527 ms
|
|
Speed: 0.652 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14619
Speed: 0.595 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14620
Speed: 0.536 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14621
Speed: 0.523 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14622
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14623
Speed: 0.534 ms
|
|
Speed: 0.618 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11462
Speed: 0.556 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11463
Speed: 0.485 ms
|
|
Speed: 0.586 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11634
Speed: 0.658 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11635
Speed: 0.527 ms
|
|
SELECT * FROM author_settings WHERE author_id = 11636
Speed: 0.805 ms
|
|
Speed: 0.803 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31738
Speed: 0.552 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31739
Speed: 0.535 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31740
Speed: 0.503 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31741
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31742
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31743
Speed: 0.563 ms
|
|
Speed: 0.710 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37908
Speed: 0.644 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37909
Speed: 0.613 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37910
Speed: 0.522 ms
|
|
SELECT * FROM author_settings WHERE author_id = 37911
Speed: 0.479 ms
|
|
Speed: 0.651 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15180
Speed: 0.675 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15181
Speed: 0.569 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15182
Speed: 0.577 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15183
Speed: 0.580 ms
|
|
SELECT * FROM author_settings WHERE author_id = 15184
Speed: 0.584 ms
|
|
Speed: 0.655 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30734
Speed: 0.564 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30735
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30736
Speed: 0.503 ms
|
|
SELECT * FROM author_settings WHERE author_id = 30737
Speed: 0.473 ms
|
|
Speed: 0.687 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31733
Speed: 0.552 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31734
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31735
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31736
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31737
Speed: 0.511 ms
|
|
Speed: 0.649 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14113
Speed: 0.581 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14114
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14115
Speed: 0.521 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14116
Speed: 0.492 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14117
Speed: 0.503 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14118
Speed: 0.501 ms
|
|
Speed: 0.635 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46820
Speed: 0.697 ms
|
|
SELECT * FROM author_settings WHERE author_id = 46821
Speed: 0.538 ms
|
|
Speed: 0.672 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14585
Speed: 0.697 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14586
Speed: 0.594 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14587
Speed: 0.642 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14588
Speed: 0.602 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14589
Speed: 0.580 ms
|
|
SELECT * FROM author_settings WHERE author_id = 14590
Speed: 0.606 ms
|
|
Speed: 0.736 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24901
Speed: 0.584 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24902
Speed: 0.540 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24903
Speed: 0.552 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24904
Speed: 0.755 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24905
Speed: 0.801 ms
|
|
SELECT * FROM author_settings WHERE author_id = 24906
Speed: 0.798 ms
|
|
Speed: 0.947 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13946
Speed: 0.824 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13947
Speed: 0.775 ms
|
|
SELECT * FROM author_settings WHERE author_id = 13948
Speed: 0.768 ms
|
|
Speed: 0.971 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32972
Speed: 0.920 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32973
Speed: 0.733 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32974
Speed: 0.728 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32975
Speed: 0.715 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32976
Speed: 0.799 ms
|
|
SELECT * FROM author_settings WHERE author_id = 32977
Speed: 0.834 ms
|
|
Speed: 0.947 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39237
Speed: 0.873 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39238
Speed: 0.690 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39239
Speed: 0.697 ms
|
|
SELECT * FROM author_settings WHERE author_id = 39240
Speed: 0.667 ms
|
|
Speed: 1.170 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31267
Speed: 0.801 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31268
Speed: 0.709 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31269
Speed: 0.703 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31270
Speed: 0.716 ms
|
|
SELECT * FROM author_settings WHERE author_id = 31271
Speed: 0.739 ms
|
