SELECT * FROM sessions WHERE session_id = 1c4efi8icgh7gje27fo411d2h3
Speed: 1.262 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(1c4efi8icgh7gje27fo411d2h3, 3.239.33.139, CCBot/2.0 (https://commoncrawl.org/faq/), 1614485001, 1614485001, 0, , periodicos.ufpe.br
Speed: 1.106 ms
|
SELECT * FROM journals WHERE path = rb
Speed: 1.106 ms
|
Speed: 0.972 ms
|
Speed: 28.389 ms
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = objectsforreviewplugin AND journal_id = 98
Speed: 1.924 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.408 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.940 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.863 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 1.015 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 1.028 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 1.119 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.951 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.893 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.871 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 = geoprocessamento AND (o.type & 16) != 0 AND i.journal_id = 98
Speed: 32.066 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 242557
Speed: 4.201 ms
|
Speed: 1.550 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 36848
Speed: 1.216 ms
|
SELECT * FROM article_settings WHERE article_id = 242557
Speed: 2.307 ms
|
Speed: 2.302 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30747
Speed: 1.413 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30748
Speed: 1.280 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30749
Speed: 1.643 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30750
Speed: 1.188 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30770
Speed: 1.239 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30771
Speed: 1.345 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30772
Speed: 1.263 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30773
Speed: 1.185 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30774
Speed: 1.304 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30775
Speed: 1.246 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30776
Speed: 1.263 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30777
Speed: 1.223 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30778
Speed: 1.231 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 32904
Speed: 1.277 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 32905
Speed: 1.170 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 34523
Speed: 1.173 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 34524
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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 242557
Speed: 3.600 ms
|
SELECT * FROM article_settings WHERE article_id = 242557
Speed: 2.176 ms
|
SELECT * FROM sections WHERE section_id = 514
Speed: 1.084 ms
|
SELECT * FROM section_settings WHERE section_id = 514
Speed: 1.145 ms
|
Speed: 0.884 ms
|
Speed: 1.122 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2963
Speed: 1.235 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 242500
Speed: 3.813 ms
|
Speed: 1.393 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34857
Speed: 1.392 ms
|
SELECT * FROM article_settings WHERE article_id = 242500
Speed: 2.302 ms
|
Speed: 1.816 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30726
Speed: 1.257 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30727
Speed: 1.244 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30728
Speed: 1.201 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30729
Speed: 1.465 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30730
Speed: 1.202 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30731
Speed: 1.202 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30732
Speed: 2.546 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 242500
Speed: 3.622 ms
|
SELECT * FROM article_settings WHERE article_id = 242500
Speed: 2.435 ms
|
Speed: 1.264 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2904
Speed: 1.183 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 243851
Speed: 3.303 ms
|
Speed: 1.375 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 36942
Speed: 1.260 ms
|
SELECT * FROM article_settings WHERE article_id = 243851
Speed: 2.263 ms
|
Speed: 2.089 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31749
Speed: 1.229 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31750
Speed: 1.220 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31751
Speed: 1.344 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31752
Speed: 1.304 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31753
Speed: 1.224 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31754
Speed: 1.183 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31755
Speed: 1.220 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31756
Speed: 1.256 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31757
Speed: 1.224 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31758
Speed: 1.194 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 243851
Speed: 3.118 ms
|
SELECT * FROM article_settings WHERE article_id = 243851
Speed: 1.973 ms
|
SELECT * FROM sections WHERE section_id = 515
Speed: 1.077 ms
|
SELECT * FROM section_settings WHERE section_id = 515
Speed: 1.117 ms
|
Speed: 1.123 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2970
Speed: 1.280 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 240572
Speed: 3.353 ms
|
Speed: 1.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 33842
Speed: 1.176 ms
|
SELECT * FROM article_settings WHERE article_id = 240572
Speed: 2.416 ms
|
Speed: 2.421 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28918
Speed: 1.232 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28920
Speed: 1.234 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28921
Speed: 1.251 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28922
Speed: 1.215 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28923
Speed: 1.137 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28924
Speed: 1.173 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28925
Speed: 1.244 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28926
Speed: 1.122 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28927
Speed: 1.171 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28928
Speed: 1.154 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28929
Speed: 1.156 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28930
Speed: 1.194 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28931
Speed: 1.242 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28932
Speed: 1.240 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30800
Speed: 1.262 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30801
Speed: 1.183 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 240572
Speed: 2.979 ms
|
SELECT * FROM article_settings WHERE article_id = 240572
Speed: 1.977 ms
|
Speed: 0.949 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2800
Speed: 1.053 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 238945
Speed: 2.235 ms
|
Speed: 1.296 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 33846
Speed: 1.059 ms
|
SELECT * FROM article_settings WHERE article_id = 238945
Speed: 2.241 ms
|
Speed: 1.560 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28095
Speed: 1.215 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28096
Speed: 1.194 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 238945
Speed: 2.152 ms
|
SELECT * FROM article_settings WHERE article_id = 238945
Speed: 2.294 ms
|
SELECT * FROM sections WHERE section_id = 519
Speed: 1.138 ms
|
SELECT * FROM section_settings WHERE section_id = 519
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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234163
Speed: 3.020 ms
|
Speed: 1.511 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 29631
Speed: 1.207 ms
|
SELECT * FROM article_settings WHERE article_id = 234163
Speed: 2.097 ms
|
Speed: 1.675 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22434
Speed: 1.175 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22435
Speed: 1.324 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22436
Speed: 1.217 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22437
Speed: 1.207 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234163
Speed: 2.916 ms
|
SELECT * FROM article_settings WHERE article_id = 234163
Speed: 2.152 ms
|
Speed: 1.177 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2658
Speed: 1.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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 243000
Speed: 2.133 ms
|
Speed: 1.324 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34838
Speed: 1.206 ms
|
SELECT * FROM article_settings WHERE article_id = 243000
Speed: 2.151 ms
|
Speed: 1.445 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31795
Speed: 1.528 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 243000
Speed: 2.372 ms
|
SELECT * FROM article_settings WHERE article_id = 243000
Speed: 2.310 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 236681
Speed: 3.049 ms
|
Speed: 1.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 31409
Speed: 1.233 ms
|
SELECT * FROM article_settings WHERE article_id = 236681
Speed: 2.000 ms
|
Speed: 2.008 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25565
Speed: 1.215 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25566
Speed: 1.153 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25567
Speed: 1.090 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25568
Speed: 1.105 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25569
Speed: 1.126 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25570
Speed: 1.093 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25571
Speed: 1.235 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25572
Speed: 1.191 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26537
Speed: 1.247 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26538
Speed: 1.188 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 236681
Speed: 2.954 ms
|
SELECT * FROM article_settings WHERE article_id = 236681
Speed: 1.981 ms
|
SELECT * FROM sections WHERE section_id = 512
Speed: 1.099 ms
|
SELECT * FROM section_settings WHERE section_id = 512
Speed: 1.124 ms
|
Speed: 1.039 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2731
Speed: 1.158 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 242899
Speed: 3.950 ms
|
Speed: 1.309 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34858
Speed: 1.307 ms
|
SELECT * FROM article_settings WHERE article_id = 242899
Speed: 2.544 ms
|
Speed: 1.527 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30998
Speed: 1.189 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30999
Speed: 1.121 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 242899
Speed: 3.841 ms
|
SELECT * FROM article_settings WHERE article_id = 242899
Speed: 2.371 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 243912
Speed: 3.787 ms
|
Speed: 1.612 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 36012
Speed: 1.434 ms
|
SELECT * FROM article_settings WHERE article_id = 243912
Speed: 2.282 ms
|
Speed: 2.768 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31817
Speed: 1.260 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31818
Speed: 1.185 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31819
Speed: 1.222 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31820
Speed: 1.291 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31821
Speed: 1.237 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31822
Speed: 1.221 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31823
Speed: 1.205 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31824
Speed: 1.279 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31825
Speed: 1.273 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31826
Speed: 1.281 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31827
Speed: 1.331 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31828
Speed: 1.265 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31829
Speed: 1.298 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31830
Speed: 1.380 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31831
Speed: 1.322 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31832
Speed: 1.311 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31833
Speed: 1.376 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31834
Speed: 1.325 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31835
Speed: 1.384 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 33054
Speed: 1.300 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 33055
Speed: 1.209 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 243912
Speed: 3.380 ms
|
SELECT * FROM article_settings WHERE article_id = 243912
Speed: 2.235 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234348
Speed: 9.315 ms
|
Speed: 5.590 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30108
Speed: 1.482 ms
|
SELECT * FROM article_settings WHERE article_id = 234348
Speed: 2.490 ms
|
Speed: 1.696 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23373
Speed: 1.552 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234348
Speed: 3.180 ms
|
SELECT * FROM article_settings WHERE article_id = 234348
Speed: 2.148 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 241398
Speed: 2.998 ms
|
Speed: 1.359 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34955
Speed: 1.868 ms
|
SELECT * FROM article_settings WHERE article_id = 241398
Speed: 2.226 ms
|
Speed: 1.441 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29470
Speed: 1.287 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 241398
Speed: 2.677 ms
|
SELECT * FROM article_settings WHERE article_id = 241398
Speed: 2.192 ms
|
SELECT * FROM sections WHERE section_id = 513
Speed: 1.088 ms
|
SELECT * FROM section_settings WHERE section_id = 513
Speed: 1.087 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 241440
Speed: 2.770 ms
|
Speed: 1.458 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34794
Speed: 1.249 ms
|
SELECT * FROM article_settings WHERE article_id = 241440
Speed: 2.321 ms
|
Speed: 2.257 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29566
Speed: 1.379 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29570
Speed: 1.368 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29571
Speed: 1.312 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29572
Speed: 1.319 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29573
Speed: 1.316 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29574
Speed: 1.410 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29575
Speed: 1.263 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29576
Speed: 1.316 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 29577
Speed: 1.225 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30937
Speed: 1.208 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30938
Speed: 1.303 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30939
Speed: 1.151 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30940
Speed: 1.184 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30988
Speed: 1.118 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 241440
Speed: 2.709 ms
|
SELECT * FROM article_settings WHERE article_id = 241440
Speed: 2.137 ms
|
Speed: 1.240 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2900
Speed: 1.162 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234381
Speed: 2.522 ms
|
Speed: 1.704 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30749
Speed: 1.307 ms
|
SELECT * FROM article_settings WHERE article_id = 234381
Speed: 2.374 ms
|
Speed: 1.541 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234381
Speed: 2.485 ms
|
SELECT * FROM article_settings WHERE article_id = 234381
Speed: 2.338 ms
|
Speed: 1.294 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2662
Speed: 1.219 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234164
Speed: 2.791 ms
|
Speed: 1.586 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30311
Speed: 1.267 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30312
Speed: 1.137 ms
|
SELECT * FROM article_settings WHERE article_id = 234164
Speed: 2.119 ms
|
Speed: 1.666 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22438
Speed: 1.151 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22439
Speed: 1.191 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22440
Speed: 1.170 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22441
Speed: 1.209 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22442
Speed: 1.262 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234164
Speed: 2.876 ms
|
SELECT * FROM article_settings WHERE article_id = 234164
Speed: 2.479 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 242518
Speed: 3.084 ms
|
Speed: 1.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 35044
Speed: 1.160 ms
|
SELECT * FROM article_settings WHERE article_id = 242518
Speed: 2.280 ms
|
Speed: 1.943 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30740
Speed: 1.521 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30741
Speed: 1.260 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30742
Speed: 1.214 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30743
Speed: 1.308 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30744
Speed: 1.434 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30745
Speed: 1.364 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30746
Speed: 1.308 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31802
Speed: 1.480 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31803
Speed: 1.505 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 242518
Speed: 3.037 ms
|
SELECT * FROM article_settings WHERE article_id = 242518
Speed: 2.235 ms
|
Speed: 1.148 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2938
Speed: 1.145 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 248969
Speed: 3.523 ms
|
Speed: 1.436 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 37232
Speed: 1.216 ms
|
SELECT * FROM article_settings WHERE article_id = 248969
Speed: 2.172 ms
|
Speed: 2.499 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36447
Speed: 1.304 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36448
Speed: 1.126 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36449
Speed: 1.116 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36450
Speed: 1.087 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36451
Speed: 1.115 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36452
Speed: 1.131 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36453
Speed: 1.121 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36454
Speed: 1.149 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36455
Speed: 1.115 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36456
Speed: 1.137 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36457
Speed: 1.133 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36458
Speed: 1.195 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36459
Speed: 1.188 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36460
Speed: 1.196 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36461
Speed: 1.306 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 36462
Speed: 1.208 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 248969
Speed: 3.726 ms
|
SELECT * FROM article_settings WHERE article_id = 248969
Speed: 2.101 ms
|
Speed: 1.122 ms
|
SELECT * FROM issue_settings WHERE issue_id = 3044
Speed: 1.160 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 237181
Speed: 4.323 ms
|
Speed: 1.401 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 33023
Speed: 1.254 ms
|
SELECT * FROM article_settings WHERE article_id = 237181
Speed: 2.220 ms
|
Speed: 2.721 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25967
Speed: 1.448 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25968
Speed: 1.290 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25969
Speed: 1.117 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25970
Speed: 1.075 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25971
Speed: 1.145 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25972
Speed: 1.213 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25973
Speed: 1.159 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25974
Speed: 1.171 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25975
Speed: 1.338 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25976
Speed: 1.207 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25977
Speed: 1.239 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25978
Speed: 1.284 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25979
Speed: 1.237 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25980
Speed: 1.180 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25981
Speed: 15.576 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25982
Speed: 1.365 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25983
Speed: 1.299 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25984
Speed: 1.240 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25985
Speed: 1.236 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25986
Speed: 1.166 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25987
Speed: 1.183 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25988
Speed: 1.321 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25989
Speed: 1.108 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 28636
Speed: 1.146 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 237181
Speed: 4.192 ms
|
SELECT * FROM article_settings WHERE article_id = 237181
Speed: 2.272 ms
|
Speed: 1.157 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2780
Speed: 1.228 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 245450
Speed: 3.835 ms
|
Speed: 1.472 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 37223
Speed: 1.176 ms
|
SELECT * FROM article_settings WHERE article_id = 245450
Speed: 2.261 ms
|
Speed: 1.532 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 35737
Speed: 1.260 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 245450
Speed: 3.471 ms
|
SELECT * FROM article_settings WHERE article_id = 245450
Speed: 2.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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234927
Speed: 2.750 ms
|
Speed: 1.449 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30948
Speed: 1.146 ms
|
SELECT * FROM article_settings WHERE article_id = 234927
Speed: 2.239 ms
|
Speed: 2.262 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24077
Speed: 1.231 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24078
Speed: 1.267 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24079
Speed: 1.366 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24080
Speed: 1.275 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24081
Speed: 1.333 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24082
Speed: 1.232 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24083
Speed: 1.219 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24084
Speed: 1.239 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24085
Speed: 1.244 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24086
Speed: 1.175 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24087
Speed: 1.148 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24088
Speed: 1.132 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24779
Speed: 1.184 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24780
Speed: 1.129 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234927
Speed: 2.646 ms
|
SELECT * FROM article_settings WHERE article_id = 234927
Speed: 2.104 ms
|
Speed: 1.072 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2676
Speed: 1.122 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 237034
Speed: 2.586 ms
|
Speed: 1.288 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 32280
Speed: 1.108 ms
|
SELECT * FROM article_settings WHERE article_id = 237034
Speed: 2.056 ms
|
Speed: 1.941 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25857
Speed: 1.180 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25858
Speed: 1.125 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25860
Speed: 1.217 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25864
Speed: 1.160 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25866
Speed: 1.152 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25867
Speed: 1.180 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25869
Speed: 1.128 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25870
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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 237034
Speed: 2.312 ms
|
SELECT * FROM article_settings WHERE article_id = 237034
Speed: 2.121 ms
|
Speed: 1.147 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2748
Speed: 1.242 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 242456
Speed: 3.977 ms
|
Speed: 1.427 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 35319
Speed: 1.147 ms
|
SELECT * FROM article_settings WHERE article_id = 242456
Speed: 2.193 ms
|
Speed: 2.095 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30687
Speed: 1.282 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30688
Speed: 1.189 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30689
Speed: 1.181 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30690
Speed: 1.118 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30691
Speed: 1.202 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30692
Speed: 1.113 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30693
Speed: 1.165 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30694
Speed: 1.160 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 30695
Speed: 1.119 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 33094
Speed: 1.136 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 242456
Speed: 2.902 ms
|
SELECT * FROM article_settings WHERE article_id = 242456
Speed: 2.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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 237904
Speed: 3.138 ms
|
Speed: 1.335 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 32219
Speed: 1.145 ms
|
SELECT * FROM article_settings WHERE article_id = 237904
Speed: 2.124 ms
|
Speed: 1.887 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26696
Speed: 1.194 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26697
Speed: 1.151 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26698
Speed: 1.187 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26699
Speed: 1.713 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26700
Speed: 1.333 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26701
Speed: 1.308 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26702
Speed: 1.274 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26703
Speed: 1.287 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 237904
Speed: 3.349 ms
|
SELECT * FROM article_settings WHERE article_id = 237904
Speed: 2.462 ms
|
Speed: 1.132 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2739
Speed: 1.265 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 243121
Speed: 4.147 ms
|
Speed: 1.515 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 34828
Speed: 1.312 ms
|
SELECT * FROM article_settings WHERE article_id = 243121
Speed: 2.288 ms
|
Speed: 1.718 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31186
Speed: 1.199 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 31187
Speed: 1.302 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 32357
Speed: 1.272 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 32358
Speed: 1.509 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 32359
Speed: 1.470 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 243121
Speed: 3.542 ms
|
SELECT * FROM article_settings WHERE article_id = 243121
Speed: 2.577 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 238091
Speed: 3.520 ms
|
Speed: 1.522 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 32179
Speed: 1.302 ms
|
SELECT * FROM article_settings WHERE article_id = 238091
Speed: 2.074 ms
|
Speed: 1.957 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26872
Speed: 1.515 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26873
Speed: 1.294 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26874
Speed: 1.311 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26875
Speed: 1.464 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26876
Speed: 1.458 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26877
Speed: 1.425 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26878
Speed: 1.399 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26879
Speed: 1.339 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26880
Speed: 1.451 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26881
Speed: 1.395 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 238091
Speed: 3.061 ms
|
SELECT * FROM article_settings WHERE article_id = 238091
Speed: 2.021 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 236110
Speed: 2.831 ms
|
Speed: 1.462 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30984
Speed: 1.335 ms
|
SELECT * FROM article_settings WHERE article_id = 236110
Speed: 2.238 ms
|
Speed: 2.118 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25044
Speed: 1.485 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25045
Speed: 1.485 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25046
Speed: 1.378 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25047
Speed: 1.489 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25048
Speed: 1.467 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25049
Speed: 1.500 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 25050
Speed: 1.480 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 26367
Speed: 1.286 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 236110
Speed: 2.883 ms
|
SELECT * FROM article_settings WHERE article_id = 236110
Speed: 2.181 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234114
Speed: 2.433 ms
|
Speed: 1.423 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 27941
Speed: 1.139 ms
|
SELECT * FROM article_settings WHERE article_id = 234114
Speed: 2.269 ms
|
Speed: 1.900 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22190
Speed: 1.339 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22191
Speed: 1.556 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22192
Speed: 1.109 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22193
Speed: 1.144 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234114
Speed: 2.080 ms
|
SELECT * FROM article_settings WHERE article_id = 234114
Speed: 2.199 ms
|
Speed: 1.048 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2511
Speed: 1.279 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234991
Speed: 2.934 ms
|
Speed: 1.415 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 30949
Speed: 1.315 ms
|
SELECT * FROM article_settings WHERE article_id = 234991
Speed: 1.976 ms
|
Speed: 1.762 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24207
Speed: 1.172 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24208
Speed: 1.196 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24209
Speed: 1.214 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24210
Speed: 1.175 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24211
Speed: 1.131 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 24811
Speed: 1.460 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234991
Speed: 2.646 ms
|
SELECT * FROM article_settings WHERE article_id = 234991
Speed: 1.983 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 234189
Speed: 3.259 ms
|
Speed: 1.459 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 29313
Speed: 1.160 ms
|
SELECT * FROM article_settings WHERE article_id = 234189
Speed: 1.842 ms
|
Speed: 2.355 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22527
Speed: 1.675 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22528
Speed: 1.377 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22529
Speed: 1.284 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22530
Speed: 1.493 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22531
Speed: 1.415 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22532
Speed: 1.212 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22533
Speed: 1.458 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22534
Speed: 1.272 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22535
Speed: 1.206 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22536
Speed: 1.194 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22537
Speed: 1.196 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22538
Speed: 1.264 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 22539
Speed: 1.235 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23946
Speed: 1.292 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 23947
Speed: 1.379 ms
|
SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 234189
Speed: 2.800 ms
|
SELECT * FROM article_settings WHERE article_id = 234189
Speed: 1.621 ms
|
Speed: 1.088 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2632
Speed: 1.145 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE pa.article_id = a.article_id
AND a.article_id = 233912
Speed: 2.314 ms
|
Speed: 1.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 27398
Speed: 1.145 ms
|
SELECT * FROM article_settings WHERE article_id = 233912
Speed: 7.960 ms
|
Speed: 1.956 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21111
Speed: 1.326 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21112
Speed: 1.205 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21113
Speed: 1.189 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21114
Speed: 1.154 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21115
Speed: 1.128 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21116
Speed: 1.128 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21117
Speed: 1.140 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21118
Speed: 1.246 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 21119
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 = pt_BR)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = pt_BR)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = pt_BR)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = pt_BR)
WHERE article_id = 233912
Speed: 2.074 ms
|
SELECT * FROM article_settings WHERE article_id = 233912
Speed: 8.365 ms
|
Speed: 1.171 ms
|
SELECT * FROM issue_settings WHERE issue_id = 2518
Speed: 1.145 ms
|
Speed: 27.476 ms
|
Speed: 1.691 ms
|
SELECT * FROM issue_settings WHERE issue_id = 3154
Speed: 1.289 ms
|
Speed: 1.934 ms
|
SELECT * FROM issue_settings WHERE issue_id = 3154
Speed: 1.215 ms
|
Speed: 2.199 ms
|
SELECT * FROM author_settings WHERE author_id = 89680
Speed: 1.230 ms
|
SELECT * FROM author_settings WHERE author_id = 89678
Speed: 1.162 ms
|
SELECT * FROM author_settings WHERE author_id = 89681
Speed: 1.156 ms
|
SELECT * FROM author_settings WHERE author_id = 89682
Speed: 1.061 ms
|
SELECT * FROM author_settings WHERE author_id = 89683
Speed: 1.110 ms
|
Speed: 1.902 ms
|
SELECT * FROM author_settings WHERE author_id = 89587
Speed: 1.289 ms
|
SELECT * FROM author_settings WHERE author_id = 89588
Speed: 1.128 ms
|
SELECT * FROM author_settings WHERE author_id = 89589
Speed: 1.120 ms
|
SELECT * FROM author_settings WHERE author_id = 89590
Speed: 1.085 ms
|
SELECT * FROM author_settings WHERE author_id = 89591
Speed: 1.123 ms
|
SELECT * FROM author_settings WHERE author_id = 89592
Speed: 1.069 ms
|
SELECT * FROM author_settings WHERE author_id = 94020
Speed: 1.105 ms
|
SELECT * FROM author_settings WHERE author_id = 91942
Speed: 1.192 ms
|
Speed: 1.881 ms
|
SELECT * FROM author_settings WHERE author_id = 92625
Speed: 1.236 ms
|
SELECT * FROM author_settings WHERE author_id = 92624
Speed: 1.509 ms
|
SELECT * FROM author_settings WHERE author_id = 92626
Speed: 1.301 ms
|
SELECT * FROM author_settings WHERE author_id = 92627
Speed: 1.191 ms
|
SELECT * FROM author_settings WHERE author_id = 92628
Speed: 1.122 ms
|
Speed: 1.787 ms
|
SELECT * FROM author_settings WHERE author_id = 85116
Speed: 1.337 ms
|
SELECT * FROM author_settings WHERE author_id = 85118
Speed: 1.252 ms
|
SELECT * FROM author_settings WHERE author_id = 85119
Speed: 1.429 ms
|
SELECT * FROM author_settings WHERE author_id = 85120
Speed: 1.133 ms
|
Speed: 1.768 ms
|
SELECT * FROM author_settings WHERE author_id = 81125
Speed: 1.296 ms
|
Speed: 1.711 ms
|
SELECT * FROM author_settings WHERE author_id = 69847
Speed: 1.165 ms
|
SELECT * FROM author_settings WHERE author_id = 69848
Speed: 1.159 ms
|
SELECT * FROM author_settings WHERE author_id = 69849
Speed: 1.211 ms
|
Speed: 1.794 ms
|
SELECT * FROM author_settings WHERE author_id = 90654
Speed: 1.144 ms
|
SELECT * FROM author_settings WHERE author_id = 90655
Speed: 1.129 ms
|
SELECT * FROM author_settings WHERE author_id = 90656
Speed: 1.169 ms
|
Speed: 1.826 ms
|
SELECT * FROM author_settings WHERE author_id = 75887
Speed: 1.203 ms
|
SELECT * FROM author_settings WHERE author_id = 75889
Speed: 1.084 ms
|
SELECT * FROM author_settings WHERE author_id = 75890
Speed: 1.064 ms
|
SELECT * FROM author_settings WHERE author_id = 75891
Speed: 1.214 ms
|
Speed: 1.750 ms
|
SELECT * FROM author_settings WHERE author_id = 90397
Speed: 1.244 ms
|
SELECT * FROM author_settings WHERE author_id = 92434
Speed: 1.205 ms
|
SELECT * FROM author_settings WHERE author_id = 92435
Speed: 1.403 ms
|
Speed: 1.769 ms
|
SELECT * FROM author_settings WHERE author_id = 92764
Speed: 10.615 ms
|
SELECT * FROM author_settings WHERE author_id = 92765
Speed: 5.797 ms
|
SELECT * FROM author_settings WHERE author_id = 92766
Speed: 1.206 ms
|
Speed: 1.782 ms
|
SELECT * FROM author_settings WHERE author_id = 70406
Speed: 1.222 ms
|
SELECT * FROM author_settings WHERE author_id = 70407
Speed: 1.163 ms
|
Speed: 5.930 ms
|
SELECT * FROM author_settings WHERE author_id = 86982
Speed: 1.339 ms
|
SELECT * FROM author_settings WHERE author_id = 86981
Speed: 1.339 ms
|
SELECT * FROM author_settings WHERE author_id = 86983
Speed: 1.255 ms
|
Speed: 1.844 ms
|
SELECT * FROM author_settings WHERE author_id = 87072
Speed: 1.256 ms
|
SELECT * FROM author_settings WHERE author_id = 87078
Speed: 1.221 ms
|
SELECT * FROM author_settings WHERE author_id = 87079
Speed: 1.088 ms
|
SELECT * FROM author_settings WHERE author_id = 87080
Speed: 1.105 ms
|
SELECT * FROM author_settings WHERE author_id = 87081
Speed: 1.085 ms
|
SELECT * FROM author_settings WHERE author_id = 87082
Speed: 1.116 ms
|
SELECT * FROM author_settings WHERE author_id = 87083
Speed: 1.113 ms
|
Speed: 1.640 ms
|
SELECT * FROM author_settings WHERE author_id = 70491
Speed: 1.128 ms
|
SELECT * FROM author_settings WHERE author_id = 70493
Speed: 1.122 ms
|
Speed: 1.733 ms
|
SELECT * FROM author_settings WHERE author_id = 69850
Speed: 1.482 ms
|
SELECT * FROM author_settings WHERE author_id = 69851
Speed: 1.094 ms
|
SELECT * FROM author_settings WHERE author_id = 69852
Speed: 1.030 ms
|
SELECT * FROM author_settings WHERE author_id = 69853
Speed: 1.039 ms
|
Speed: 1.599 ms
|
SELECT * FROM author_settings WHERE author_id = 89625
Speed: 1.086 ms
|
SELECT * FROM author_settings WHERE author_id = 89626
Speed: 1.133 ms
|
SELECT * FROM author_settings WHERE author_id = 89627
Speed: 1.129 ms
|
SELECT * FROM author_settings WHERE author_id = 89628
Speed: 1.161 ms
|
SELECT * FROM author_settings WHERE author_id = 89629
Speed: 1.092 ms
|
SELECT * FROM author_settings WHERE author_id = 89630
Speed: 1.124 ms
|
Speed: 1.618 ms
|
SELECT * FROM author_settings WHERE author_id = 103520
Speed: 1.359 ms
|
SELECT * FROM author_settings WHERE author_id = 103754
Speed: 1.324 ms
|
SELECT * FROM author_settings WHERE author_id = 103755
Speed: 1.181 ms
|
Speed: 1.733 ms
|
SELECT * FROM author_settings WHERE author_id = 77050
Speed: 1.397 ms
|
SELECT * FROM author_settings WHERE author_id = 77051
Speed: 1.426 ms
|
SELECT * FROM author_settings WHERE author_id = 77052
Speed: 1.568 ms
|
SELECT * FROM author_settings WHERE author_id = 77053
Speed: 1.414 ms
|
Speed: 1.675 ms
|
SELECT * FROM author_settings WHERE author_id = 96258
Speed: 1.213 ms
|
SELECT * FROM author_settings WHERE author_id = 96265
Speed: 1.188 ms
|
SELECT * FROM author_settings WHERE author_id = 96266
Speed: 1.110 ms
|
SELECT * FROM author_settings WHERE author_id = 96267
Speed: 1.167 ms
|
Speed: 1.745 ms
|
SELECT * FROM author_settings WHERE author_id = 72035
Speed: 1.227 ms
|
SELECT * FROM author_settings WHERE author_id = 72034
Speed: 1.272 ms
|
Speed: 1.734 ms
|
SELECT * FROM author_settings WHERE author_id = 87698
Speed: 1.264 ms
|
SELECT * FROM author_settings WHERE author_id = 87699
Speed: 1.229 ms
|
SELECT * FROM author_settings WHERE author_id = 87700
Speed: 1.282 ms
|
SELECT * FROM author_settings WHERE author_id = 87701
Speed: 1.263 ms
|
SELECT * FROM author_settings WHERE author_id = 87702
Speed: 1.158 ms
|
SELECT * FROM author_settings WHERE author_id = 76744
Speed: 1.421 ms
|
Speed: 4.380 ms
|
SELECT * FROM author_settings WHERE author_id = 89495
Speed: 2.090 ms
|
SELECT * FROM author_settings WHERE author_id = 89496
Speed: 1.456 ms
|
Speed: 1.797 ms
|
SELECT * FROM author_settings WHERE author_id = 78775
Speed: 1.174 ms
|
SELECT * FROM author_settings WHERE author_id = 78776
Speed: 1.224 ms
|
SELECT * FROM author_settings WHERE author_id = 78777
Speed: 1.151 ms
|
Speed: 1.855 ms
|
SELECT * FROM author_settings WHERE author_id = 90907
Speed: 1.234 ms
|
SELECT * FROM author_settings WHERE author_id = 90909
Speed: 1.254 ms
|
SELECT * FROM author_settings WHERE author_id = 90910
Speed: 1.237 ms
|
Speed: 1.776 ms
|
SELECT * FROM author_settings WHERE author_id = 79231
Speed: 1.240 ms
|
SELECT * FROM author_settings WHERE author_id = 79149
Speed: 1.360 ms
|
Speed: 1.747 ms
|
SELECT * FROM author_settings WHERE author_id = 74499
Speed: 1.263 ms
|
SELECT * FROM author_settings WHERE author_id = 74505
Speed: 1.123 ms
|
SELECT * FROM author_settings WHERE author_id = 74506
Speed: 1.073 ms
|
SELECT * FROM author_settings WHERE author_id = 74507
Speed: 1.065 ms
|
SELECT * FROM author_settings WHERE author_id = 74508
Speed: 1.180 ms
|
Speed: 1.792 ms
|
SELECT * FROM author_settings WHERE author_id = 69678
Speed: 1.410 ms
|
SELECT * FROM author_settings WHERE author_id = 69679
Speed: 1.114 ms
|
SELECT * FROM author_settings WHERE author_id = 69680
Speed: 1.145 ms
|
SELECT * FROM author_settings WHERE author_id = 69681
Speed: 1.096 ms
|
Speed: 1.782 ms
|
SELECT * FROM author_settings WHERE author_id = 72232
Speed: 1.259 ms
|
SELECT * FROM author_settings WHERE author_id = 72228
Speed: 1.328 ms
|
Speed: 1.662 ms
|
SELECT * FROM author_settings WHERE author_id = 69928
Speed: 1.288 ms
|
SELECT * FROM author_settings WHERE author_id = 69929
Speed: 1.290 ms
|
Speed: 2.046 ms
|
SELECT * FROM author_settings WHERE author_id = 69049
Speed: 1.237 ms
|
SELECT * FROM author_settings WHERE author_id = 69050
Speed: 1.114 ms
|
SELECT * FROM author_settings WHERE author_id = 69051
Speed: 1.115 ms
|
SELECT * FROM author_settings WHERE author_id = 69052
Speed: 1.090 ms
|
SELECT * FROM author_settings WHERE author_id = 69053
Speed: 1.076 ms
|