SELECT * FROM sessions WHERE session_id = aaths1gedecb5q9etpoqii2fm4
Speed: 7.117 ms
|
DELETE FROM sessions WHERE (last_used < 1740206040 AND remember = 0) OR (last_used < 1737700440
Speed: 880.501 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(aaths1gedecb5q9etpoqii2fm4, 3.131.37.236, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1740292441, 1740292441, 0, , journal.uinsgd.ac.id
Speed: 124.105 ms
|
SELECT * FROM journals WHERE path = ji
Speed: 0.720 ms
|
Speed: 0.360 ms
|
Speed: 99.632 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 4.233 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 1.667 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.967 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 1.402 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 1.511 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.816 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 1.376 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 1.475 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.861 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 4954
Speed: 22.946 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 4954
Speed: 1.758 ms
|
Speed: 1.213 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2751
Speed: 0.848 ms
|
SELECT * FROM article_settings WHERE article_id = 4954
Speed: 1.607 ms
|
Speed: 0.310 ms
|
SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = pub-id::publisher-id AND ist.setting_value = 394
Speed: 4.777 ms
|
Speed: 0.262 ms
|
SELECT * FROM issue_settings WHERE issue_id = 394
Speed: 0.980 ms
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-131-37-236.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-131-37-236.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 11
Speed: 0.414 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 58926572 >= isip.ip_start AND 58926572 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 11
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-02-23 06:34:02' >= s.date_start AND '2025-02-23 06:34:02' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 58926572 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 11
Speed: 0.317 ms
|
SELECT * FROM sections WHERE section_id = 73
Speed: 0.280 ms
|
SELECT * FROM section_settings WHERE section_id = 73
Speed: 0.381 ms
|
SELECT * FROM rt_versions WHERE version_id = 204 AND journal_id = 11
Speed: 3.229 ms
|
SELECT * FROM rt_contexts WHERE version_id = 204
Speed: 0.636 ms
|
SELECT * FROM rt_searches WHERE context_id = 2636
Speed: 0.494 ms
|
SELECT * FROM rt_searches WHERE context_id = 2637
Speed: 0.388 ms
|
SELECT * FROM rt_searches WHERE context_id = 2638
Speed: 0.402 ms
|
SELECT * FROM rt_searches WHERE context_id = 2639
Speed: 0.342 ms
|
SELECT * FROM rt_searches WHERE context_id = 2640
Speed: 0.348 ms
|
SELECT * FROM rt_searches WHERE context_id = 2641
Speed: 0.328 ms
|
SELECT * FROM rt_searches WHERE context_id = 2642
Speed: 0.365 ms
|
SELECT * FROM rt_searches WHERE context_id = 2643
Speed: 0.331 ms
|
SELECT * FROM rt_searches WHERE context_id = 2644
Speed: 0.336 ms
|
SELECT * FROM rt_searches WHERE context_id = 2645
Speed: 0.360 ms
|
SELECT * FROM rt_searches WHERE context_id = 2646
Speed: 0.341 ms
|
SELECT * FROM rt_searches WHERE context_id = 2647
Speed: 0.349 ms
|
SELECT * FROM rt_searches WHERE context_id = 2648
Speed: 0.395 ms
|
SELECT * FROM rt_searches WHERE context_id = 2649
Speed: 0.495 ms
|
SELECT * FROM rt_searches WHERE context_id = 2650
Speed: 1.760 ms
|
SELECT * FROM rt_searches WHERE context_id = 2651
Speed: 1.076 ms
|
SELECT * FROM sections WHERE section_id = 73
Speed: 0.984 ms
|
SELECT * FROM section_settings WHERE section_id = 73
Speed: 0.933 ms
|
SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.galley_id = 0 AND g.article_id = 4954
Speed: 0.303 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 4954
Speed: 4.377 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 4954
Speed: 0.539 ms
|
Speed: 0.463 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2751
Speed: 3.307 ms
|
SELECT * FROM article_settings WHERE article_id = 4954
Speed: 6.980 ms
|
Speed: 0.367 ms
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-131-37-236.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-131-37-236.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 11
Speed: 0.446 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 58926572 >= isip.ip_start AND 58926572 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 11
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2025-02-23 06:34:02' >= s.date_start AND '2025-02-23 06:34:02' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 58926572 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 11
Speed: 0.297 ms
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 4954 AND citation_state >= 0 AND citation_state <= 5
Speed: 12.554 ms
|
SELECT * FROM sections WHERE section_id = 73
Speed: 0.499 ms
|
SELECT * FROM section_settings WHERE section_id = 73
Speed: 1.242 ms
|
Speed: 53.981 ms
|
Speed: 40.515 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1314
Speed: 0.429 ms
|
Speed: 11.436 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 0.444 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 0.310 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.315 ms
|
Speed: 1.060 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 0.857 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 0.307 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.798 ms
|
Speed: 0.370 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 0.309 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 0.308 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.286 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
LEFT JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN issues i ON pa.issue_id = i.issue_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE i.published = 1
AND a.journal_id = 11
Speed: 65.963 ms
|
Speed: 0.521 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1600
Speed: 0.337 ms
|
SELECT * FROM article_settings WHERE article_id = 2414
Speed: 0.439 ms
|
Speed: 0.366 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1176
Speed: 0.253 ms
|
SELECT * FROM article_settings WHERE article_id = 1732
Speed: 0.437 ms
|
Speed: 0.300 ms
|
Speed: 0.363 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1177
Speed: 0.241 ms
|
SELECT * FROM article_settings WHERE article_id = 1733
Speed: 0.425 ms
|
Speed: 0.315 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1179
Speed: 0.319 ms
|
SELECT * FROM article_settings WHERE article_id = 1736
Speed: 0.421 ms
|
Speed: 0.325 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1288
Speed: 0.276 ms
|
SELECT * FROM article_settings WHERE article_id = 1861
Speed: 0.415 ms
|
Speed: 0.305 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1175
Speed: 0.251 ms
|
SELECT * FROM article_settings WHERE article_id = 1731
Speed: 0.461 ms
|
Speed: 0.298 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1180
Speed: 0.241 ms
|
SELECT * FROM article_settings WHERE article_id = 1737
Speed: 0.427 ms
|
Speed: 0.289 ms
|
Speed: 0.331 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1181
Speed: 0.252 ms
|
SELECT * FROM article_settings WHERE article_id = 1738
Speed: 0.432 ms
|
Speed: 0.333 ms
|
Speed: 0.337 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1182
Speed: 0.242 ms
|
SELECT * FROM article_settings WHERE article_id = 1739
Speed: 0.443 ms
|
Speed: 0.299 ms
|
Speed: 0.380 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2160
Speed: 0.254 ms
|
SELECT * FROM article_settings WHERE article_id = 3552
Speed: 0.428 ms
|
Speed: 0.289 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3253
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 5707
Speed: 0.405 ms
|
Speed: 0.305 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3254
Speed: 0.287 ms
|
SELECT * FROM article_settings WHERE article_id = 5605
Speed: 0.377 ms
|
Speed: 0.302 ms
|
Speed: 0.356 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1545
Speed: 0.292 ms
|
SELECT * FROM article_settings WHERE article_id = 2269
Speed: 0.419 ms
|
Speed: 0.305 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1548
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 2271
Speed: 0.398 ms
|
Speed: 0.295 ms
|
Speed: 0.358 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1550
Speed: 0.283 ms
|
SELECT * FROM article_settings WHERE article_id = 2273
Speed: 0.396 ms
|
Speed: 0.296 ms
|
Speed: 0.353 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1549
Speed: 0.279 ms
|
SELECT * FROM article_settings WHERE article_id = 2272
Speed: 0.387 ms
|
Speed: 0.303 ms
|
Speed: 0.342 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1551
Speed: 0.293 ms
|
SELECT * FROM article_settings WHERE article_id = 2274
Speed: 0.359 ms
|
Speed: 0.333 ms
|
Speed: 0.390 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1552
Speed: 0.276 ms
|
SELECT * FROM article_settings WHERE article_id = 2275
Speed: 0.400 ms
|
Speed: 0.306 ms
|
Speed: 0.358 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1553
Speed: 0.275 ms
|
SELECT * FROM article_settings WHERE article_id = 2276
Speed: 0.482 ms
|
Speed: 0.293 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2429
Speed: 0.240 ms
|
SELECT * FROM article_settings WHERE article_id = 4148
Speed: 0.397 ms
|
Speed: 0.308 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3444
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 4317
Speed: 0.415 ms
|
Speed: 0.296 ms
|
Speed: 0.343 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3354
Speed: 0.285 ms
|
SELECT * FROM article_settings WHERE article_id = 5930
Speed: 0.434 ms
|
Speed: 0.298 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3727
Speed: 0.286 ms
|
SELECT * FROM article_settings WHERE article_id = 7395
Speed: 0.392 ms
|
Speed: 0.307 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1809
Speed: 0.270 ms
|
SELECT * FROM article_settings WHERE article_id = 2769
Speed: 0.390 ms
|
Speed: 0.332 ms
|
Speed: 0.375 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1811
Speed: 0.290 ms
|
SELECT * FROM article_settings WHERE article_id = 2771
Speed: 0.347 ms
|
Speed: 0.320 ms
|
Speed: 0.340 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1813
Speed: 0.264 ms
|
SELECT * FROM article_settings WHERE article_id = 2773
Speed: 1.153 ms
|
Speed: 0.324 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1808
Speed: 0.277 ms
|
SELECT * FROM article_settings WHERE article_id = 2768
Speed: 0.340 ms
|
Speed: 0.306 ms
|
Speed: 0.343 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1814
Speed: 0.260 ms
|
SELECT * FROM article_settings WHERE article_id = 2774
Speed: 0.333 ms
|
Speed: 0.297 ms
|
Speed: 0.353 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1810
Speed: 0.278 ms
|
SELECT * FROM article_settings WHERE article_id = 2770
Speed: 0.365 ms
|
Speed: 0.969 ms
|
Speed: 2.579 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1815
Speed: 1.418 ms
|
SELECT * FROM article_settings WHERE article_id = 2775
Speed: 0.830 ms
|
Speed: 0.880 ms
|
Speed: 1.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1812
Speed: 1.230 ms
|
SELECT * FROM article_settings WHERE article_id = 2772
Speed: 1.223 ms
|
Speed: 0.897 ms
|
Speed: 0.786 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2101
Speed: 1.278 ms
|
SELECT * FROM article_settings WHERE article_id = 3398
Speed: 1.457 ms
|
Speed: 0.805 ms
|
Speed: 0.780 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2354
Speed: 1.290 ms
|
SELECT * FROM article_settings WHERE article_id = 3943
Speed: 1.344 ms
|
Speed: 0.814 ms
|
Speed: 0.793 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1875
Speed: 1.282 ms
|
SELECT * FROM article_settings WHERE article_id = 2963
Speed: 1.383 ms
|
Speed: 0.795 ms
|
Speed: 1.291 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2246
Speed: 0.764 ms
|
SELECT * FROM article_settings WHERE article_id = 3747
Speed: 1.344 ms
|
Speed: 0.871 ms
|
Speed: 1.426 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2247
Speed: 1.202 ms
|
SELECT * FROM article_settings WHERE article_id = 3749
Speed: 1.514 ms
|
Speed: 0.773 ms
|
Speed: 0.906 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2248
Speed: 1.377 ms
|
SELECT * FROM article_settings WHERE article_id = 3751
Speed: 1.345 ms
|
Speed: 0.746 ms
|
Speed: 1.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2249
Speed: 1.248 ms
|
SELECT * FROM article_settings WHERE article_id = 3752
Speed: 0.991 ms
|
Speed: 1.285 ms
|
Speed: 0.833 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2237
Speed: 1.335 ms
|
SELECT * FROM article_settings WHERE article_id = 3738
Speed: 1.399 ms
|
Speed: 0.901 ms
|
Speed: 1.068 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2238
Speed: 0.726 ms
|
SELECT * FROM article_settings WHERE article_id = 3739
Speed: 1.836 ms
|
Speed: 0.840 ms
|
Speed: 0.949 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2239
Speed: 0.764 ms
|
SELECT * FROM article_settings WHERE article_id = 3740
Speed: 1.105 ms
|
Speed: 0.833 ms
|
Speed: 1.122 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2240
Speed: 0.742 ms
|
SELECT * FROM article_settings WHERE article_id = 3741
Speed: 0.981 ms
|
Speed: 0.811 ms
|
Speed: 0.950 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2241
Speed: 0.760 ms
|
SELECT * FROM article_settings WHERE article_id = 3742
Speed: 0.957 ms
|
Speed: 0.817 ms
|
Speed: 0.946 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2245
Speed: 0.751 ms
|
SELECT * FROM article_settings WHERE article_id = 3746
Speed: 0.966 ms
|
Speed: 0.818 ms
|
Speed: 0.968 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2242
Speed: 0.763 ms
|
SELECT * FROM article_settings WHERE article_id = 3743
Speed: 0.964 ms
|
Speed: 0.824 ms
|
Speed: 1.000 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2243
Speed: 0.786 ms
|
SELECT * FROM article_settings WHERE article_id = 3744
Speed: 0.959 ms
|
Speed: 0.806 ms
|
Speed: 0.999 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2264
Speed: 0.784 ms
|
SELECT * FROM article_settings WHERE article_id = 3782
Speed: 1.053 ms
|
Speed: 0.851 ms
|
Speed: 0.987 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2265
Speed: 0.785 ms
|
SELECT * FROM article_settings WHERE article_id = 3796
Speed: 0.994 ms
|
Speed: 0.949 ms
|
Speed: 0.982 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2266
Speed: 0.761 ms
|
SELECT * FROM article_settings WHERE article_id = 3797
Speed: 0.970 ms
|
Speed: 0.823 ms
|
Speed: 0.989 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2267
Speed: 0.760 ms
|
SELECT * FROM article_settings WHERE article_id = 3798
Speed: 1.128 ms
|
Speed: 0.818 ms
|
Speed: 0.983 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2268
Speed: 0.762 ms
|
SELECT * FROM article_settings WHERE article_id = 3799
Speed: 0.984 ms
|
Speed: 0.843 ms
|
Speed: 0.965 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2271
Speed: 0.759 ms
|
SELECT * FROM article_settings WHERE article_id = 3816
Speed: 1.072 ms
|
Speed: 0.884 ms
|
Speed: 1.002 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2358
Speed: 0.799 ms
|
SELECT * FROM article_settings WHERE article_id = 3957
Speed: 1.041 ms
|
Speed: 0.848 ms
|
Speed: 0.954 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2433
Speed: 0.709 ms
|
SELECT * FROM article_settings WHERE article_id = 4153
Speed: 0.960 ms
|
Speed: 0.861 ms
|
Speed: 1.032 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2364
Speed: 0.773 ms
|
SELECT * FROM article_settings WHERE article_id = 4055
Speed: 1.045 ms
|
Speed: 0.812 ms
|
Speed: 0.951 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2365
Speed: 0.776 ms
|
SELECT * FROM article_settings WHERE article_id = 4056
Speed: 0.970 ms
|
Speed: 0.843 ms
|
Speed: 0.961 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2363
Speed: 0.837 ms
|
SELECT * FROM article_settings WHERE article_id = 4054
Speed: 1.534 ms
|
Speed: 3.007 ms
|
Speed: 1.055 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2383
Speed: 1.375 ms
|
SELECT * FROM article_settings WHERE article_id = 4084
Speed: 7.297 ms
|
Speed: 0.335 ms
|
Speed: 1.062 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2637
Speed: 1.411 ms
|
SELECT * FROM article_settings WHERE article_id = 4499
Speed: 0.931 ms
|
Speed: 1.022 ms
|
Speed: 1.018 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2431
Speed: 0.826 ms
|
SELECT * FROM article_settings WHERE article_id = 4150
Speed: 0.922 ms
|
Speed: 0.331 ms
|
Speed: 0.949 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2432
Speed: 0.811 ms
|
SELECT * FROM article_settings WHERE article_id = 4151
Speed: 1.500 ms
|
Speed: 1.252 ms
|
Speed: 0.994 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2425
Speed: 0.772 ms
|
SELECT * FROM article_settings WHERE article_id = 4143
Speed: 1.525 ms
|
Speed: 0.894 ms
|
Speed: 0.830 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2426
Speed: 0.822 ms
|
SELECT * FROM article_settings WHERE article_id = 4144
Speed: 0.947 ms
|
Speed: 0.882 ms
|
Speed: 0.892 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2427
Speed: 0.883 ms
|
SELECT * FROM article_settings WHERE article_id = 4145
Speed: 0.969 ms
|
Speed: 2.791 ms
|
Speed: 0.894 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2430
Speed: 0.855 ms
|
SELECT * FROM article_settings WHERE article_id = 4149
Speed: 0.946 ms
|
Speed: 0.892 ms
|
Speed: 0.854 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2434
Speed: 0.863 ms
|
SELECT * FROM article_settings WHERE article_id = 4165
Speed: 0.917 ms
|
Speed: 0.906 ms
|
Speed: 23.891 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3445
Speed: 1.085 ms
|
SELECT * FROM article_settings WHERE article_id = 4359
Speed: 1.080 ms
|
Speed: 0.960 ms
|
Speed: 0.891 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2627
Speed: 0.924 ms
|
SELECT * FROM article_settings WHERE article_id = 4479
Speed: 0.995 ms
|
Speed: 0.913 ms
|
Speed: 0.867 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2663
Speed: 0.883 ms
|
SELECT * FROM article_settings WHERE article_id = 4594
Speed: 1.549 ms
|
Speed: 0.308 ms
|
Speed: 0.885 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2662
Speed: 0.861 ms
|
SELECT * FROM article_settings WHERE article_id = 4593
Speed: 2.438 ms
|
Speed: 0.436 ms
|
Speed: 1.806 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2672
Speed: 1.031 ms
|
SELECT * FROM article_settings WHERE article_id = 4611
Speed: 1.222 ms
|
Speed: 1.029 ms
|
Speed: 1.087 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2675
Speed: 1.037 ms
|
SELECT * FROM article_settings WHERE article_id = 4641
Speed: 1.046 ms
|
Speed: 0.926 ms
|
Speed: 0.922 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2674
Speed: 0.908 ms
|
SELECT * FROM article_settings WHERE article_id = 4638
Speed: 0.847 ms
|
Speed: 0.931 ms
|
Speed: 0.989 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2676
Speed: 1.186 ms
|
SELECT * FROM article_settings WHERE article_id = 4642
Speed: 1.436 ms
|
Speed: 0.299 ms
|
Speed: 0.906 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2681
Speed: 0.925 ms
|
SELECT * FROM article_settings WHERE article_id = 4662
Speed: 1.429 ms
|
Speed: 0.803 ms
|
Speed: 0.938 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3380
Speed: 0.742 ms
|
SELECT * FROM article_settings WHERE article_id = 4932
Speed: 1.012 ms
|
Speed: 0.843 ms
|
Speed: 0.918 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2683
Speed: 0.749 ms
|
SELECT * FROM article_settings WHERE article_id = 4683
Speed: 0.990 ms
|
Speed: 0.809 ms
|
Speed: 0.954 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3335
Speed: 5.350 ms
|
SELECT * FROM article_settings WHERE article_id = 5857
Speed: 1.624 ms
|
Speed: 3.214 ms
|
Speed: 0.902 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2746
Speed: 0.898 ms
|
SELECT * FROM article_settings WHERE article_id = 4933
Speed: 0.958 ms
|
Speed: 0.897 ms
|
Speed: 0.844 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2750
Speed: 0.832 ms
|
SELECT * FROM article_settings WHERE article_id = 4950
Speed: 1.024 ms
|
Speed: 0.896 ms
|
Speed: 11.550 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2751
Speed: 0.999 ms
|
SELECT * FROM article_settings WHERE article_id = 4954
Speed: 0.986 ms
|
Speed: 0.945 ms
|
Speed: 0.843 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3257
Speed: 1.379 ms
|
SELECT * FROM article_settings WHERE article_id = 5709
Speed: 0.971 ms
|
Speed: 0.788 ms
|
Speed: 0.923 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3352
Speed: 0.803 ms
|
SELECT * FROM article_settings WHERE article_id = 5936
Speed: 1.000 ms
|
Speed: 0.774 ms
|
Speed: 0.937 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3264
Speed: 0.803 ms
|
SELECT * FROM article_settings WHERE article_id = 5716
Speed: 1.878 ms
|
Speed: 0.803 ms
|
Speed: 1.038 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2884
Speed: 2.559 ms
|
SELECT * FROM article_settings WHERE article_id = 5110
Speed: 2.982 ms
|
Speed: 0.912 ms
|
Speed: 0.933 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3730
Speed: 0.864 ms
|
SELECT * FROM article_settings WHERE article_id = 4955
Speed: 0.983 ms
|
Speed: 0.901 ms
|
Speed: 2.114 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3328
Speed: 0.873 ms
|
SELECT * FROM article_settings WHERE article_id = 4956
Speed: 0.904 ms
|
Speed: 0.876 ms
|
Speed: 3.381 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2885
Speed: 0.936 ms
|
SELECT * FROM article_settings WHERE article_id = 5113
Speed: 9.290 ms
|
Speed: 1.018 ms
|
Speed: 0.964 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2898
Speed: 0.912 ms
|
SELECT * FROM article_settings WHERE article_id = 5119
Speed: 0.875 ms
|
Speed: 0.900 ms
|
Speed: 0.908 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2899
Speed: 0.950 ms
|
SELECT * FROM article_settings WHERE article_id = 5120
Speed: 0.931 ms
|
Speed: 0.924 ms
|
Speed: 0.881 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2900
Speed: 0.861 ms
|
SELECT * FROM article_settings WHERE article_id = 5134
Speed: 0.938 ms
|
Speed: 0.858 ms
|
Speed: 0.920 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3731
Speed: 18.758 ms
|
SELECT * FROM article_settings WHERE article_id = 5196
Speed: 1.877 ms
|
Speed: 0.885 ms
|
Speed: 0.971 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3732
Speed: 0.740 ms
|
SELECT * FROM article_settings WHERE article_id = 5199
Speed: 1.269 ms
|
Speed: 0.834 ms
|
Speed: 0.954 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3733
Speed: 0.782 ms
|
SELECT * FROM article_settings WHERE article_id = 5200
Speed: 1.027 ms
|
Speed: 1.112 ms
|
Speed: 1.168 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3734
Speed: 2.435 ms
|
SELECT * FROM article_settings WHERE article_id = 5201
Speed: 4.016 ms
|
Speed: 0.937 ms
|
Speed: 0.883 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3329
Speed: 0.876 ms
|
SELECT * FROM article_settings WHERE article_id = 5229
Speed: 0.976 ms
|
Speed: 0.910 ms
|
Speed: 0.881 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3079
Speed: 3.317 ms
|
SELECT * FROM article_settings WHERE article_id = 5324
Speed: 0.986 ms
|
Speed: 0.949 ms
|
Speed: 0.859 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3080
Speed: 0.859 ms
|
SELECT * FROM article_settings WHERE article_id = 5325
Speed: 1.008 ms
|
Speed: 0.921 ms
|
Speed: 5.203 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3086
Speed: 1.460 ms
|
SELECT * FROM article_settings WHERE article_id = 5331
Speed: 1.015 ms
|
Speed: 0.310 ms
|
Speed: 1.519 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3129
Speed: 0.854 ms
|
SELECT * FROM article_settings WHERE article_id = 5382
Speed: 1.010 ms
|
Speed: 0.330 ms
|
Speed: 1.392 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3130
Speed: 0.796 ms
|
SELECT * FROM article_settings WHERE article_id = 5383
Speed: 1.047 ms
|
Speed: 0.813 ms
|
Speed: 1.078 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3132
Speed: 0.936 ms
|
SELECT * FROM article_settings WHERE article_id = 5384
Speed: 3.023 ms
|
Speed: 0.848 ms
|
Speed: 1.058 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3145
Speed: 0.921 ms
|
SELECT * FROM article_settings WHERE article_id = 5392
Speed: 1.245 ms
|
Speed: 0.919 ms
|
Speed: 17.440 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3344
Speed: 1.059 ms
|
SELECT * FROM article_settings WHERE article_id = 5402
Speed: 3.282 ms
|
Speed: 0.913 ms
|
Speed: 1.038 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3166
Speed: 0.838 ms
|
SELECT * FROM article_settings WHERE article_id = 5410
Speed: 8.439 ms
|
Speed: 1.085 ms
|
Speed: 1.123 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3165
Speed: 0.878 ms
|
SELECT * FROM article_settings WHERE article_id = 5408
Speed: 1.036 ms
|
Speed: 1.395 ms
|
Speed: 0.898 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3179
Speed: 0.888 ms
|
SELECT * FROM article_settings WHERE article_id = 5468
Speed: 0.888 ms
|
Speed: 0.884 ms
|
Speed: 0.893 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3181
Speed: 0.881 ms
|
SELECT * FROM article_settings WHERE article_id = 5482
Speed: 0.880 ms
|
Speed: 5.420 ms
|
Speed: 1.028 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3182
Speed: 11.277 ms
|
SELECT * FROM article_settings WHERE article_id = 5483
Speed: 1.089 ms
|
Speed: 0.990 ms
|
Speed: 1.326 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3195
Speed: 0.977 ms
|
SELECT * FROM article_settings WHERE article_id = 5550
Speed: 0.917 ms
|
Speed: 0.935 ms
|
Speed: 0.929 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3196
Speed: 0.986 ms
|
SELECT * FROM article_settings WHERE article_id = 5551
Speed: 0.945 ms
|
Speed: 0.937 ms
|
Speed: 0.984 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3197
Speed: 0.981 ms
|
SELECT * FROM article_settings WHERE article_id = 5557
Speed: 3.105 ms
|
Speed: 0.999 ms
|
Speed: 0.959 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3208
Speed: 1.008 ms
|
SELECT * FROM article_settings WHERE article_id = 5564
Speed: 0.914 ms
|
Speed: 0.955 ms
|
Speed: 0.951 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3210
Speed: 0.967 ms
|
SELECT * FROM article_settings WHERE article_id = 5577
Speed: 0.926 ms
|
Speed: 0.907 ms
|
Speed: 0.928 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3221
Speed: 2.915 ms
|
SELECT * FROM article_settings WHERE article_id = 5633
Speed: 3.266 ms
|
Speed: 1.064 ms
|
Speed: 0.968 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3232
Speed: 1.186 ms
|
SELECT * FROM article_settings WHERE article_id = 5653
Speed: 0.962 ms
|
Speed: 5.421 ms
|
Speed: 1.588 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3268
Speed: 1.779 ms
|
SELECT * FROM article_settings WHERE article_id = 5768
Speed: 1.552 ms
|
Speed: 1.671 ms
|
Speed: 1.491 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3381
Speed: 1.731 ms
|
SELECT * FROM article_settings WHERE article_id = 6046
Speed: 1.577 ms
|
Speed: 1.595 ms
|
Speed: 1.553 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3412
Speed: 1.729 ms
|
SELECT * FROM article_settings WHERE article_id = 6188
Speed: 1.566 ms
|
Speed: 1.660 ms
|
Speed: 1.524 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3413
Speed: 1.681 ms
|
SELECT * FROM article_settings WHERE article_id = 6200
Speed: 1.493 ms
|
Speed: 1.587 ms
|
Speed: 1.806 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3414
Speed: 0.952 ms
|
SELECT * FROM article_settings WHERE article_id = 6205
Speed: 2.479 ms
|
Speed: 3.515 ms
|
Speed: 4.823 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3736
Speed: 1.601 ms
|
SELECT * FROM article_settings WHERE article_id = 6207
Speed: 2.472 ms
|
Speed: 1.462 ms
|
Speed: 4.430 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3417
Speed: 4.200 ms
|
SELECT * FROM article_settings WHERE article_id = 6208
Speed: 1.745 ms
|
Speed: 1.558 ms
|
Speed: 1.611 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3735
Speed: 1.622 ms
|
SELECT * FROM article_settings WHERE article_id = 6206
Speed: 1.646 ms
|
Speed: 20.816 ms
|
Speed: 1.949 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3434
Speed: 1.868 ms
|
SELECT * FROM article_settings WHERE article_id = 6242
Speed: 1.615 ms
|
Speed: 1.531 ms
|
Speed: 1.598 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 3383
Speed: 1.536 ms
|
SELECT * FROM article_settings WHERE article_id = 6103
Speed: 2.194 ms
|
Speed: 1.539 ms
|
Speed: 1.459 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4296
Speed: 2.332 ms
|
SELECT * FROM article_settings WHERE article_id = 8162
Speed: 4.921 ms
|
Speed: 3.254 ms
|
Speed: 3.937 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4298
Speed: 1.827 ms
|
SELECT * FROM article_settings WHERE article_id = 7237
Speed: 1.642 ms
|
Speed: 1.598 ms
|
Speed: 1.491 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4297
Speed: 2.849 ms
|
SELECT * FROM article_settings WHERE article_id = 7817
Speed: 2.506 ms
|
Speed: 1.533 ms
|
Speed: 1.482 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4299
Speed: 1.520 ms
|
SELECT * FROM article_settings WHERE article_id = 4882
Speed: 2.202 ms
|
Speed: 1.472 ms
|
Speed: 1.222 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4300
Speed: 1.663 ms
|
SELECT * FROM article_settings WHERE article_id = 6665
Speed: 2.165 ms
|
Speed: 1.493 ms
|
Speed: 1.566 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4302
Speed: 1.471 ms
|
SELECT * FROM article_settings WHERE article_id = 4636
Speed: 2.228 ms
|
Speed: 1.453 ms
|
Speed: 1.796 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4301
Speed: 0.781 ms
|
SELECT * FROM article_settings WHERE article_id = 7966
Speed: 2.772 ms
|
Speed: 0.876 ms
|
Speed: 1.771 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5096
Speed: 1.969 ms
|
SELECT * FROM article_settings WHERE article_id = 8176
Speed: 1.727 ms
|
Speed: 2.705 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1281
Speed: 2.334 ms
|
Speed: 1.547 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5097
Speed: 1.390 ms
|
SELECT * FROM article_settings WHERE article_id = 8316
Speed: 1.738 ms
|
Speed: 1.488 ms
|
Speed: 1.523 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5098
Speed: 1.470 ms
|
SELECT * FROM article_settings WHERE article_id = 8388
Speed: 4.552 ms
|
Speed: 1.776 ms
|
Speed: 1.482 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5099
Speed: 3.977 ms
|
SELECT * FROM article_settings WHERE article_id = 8923
Speed: 1.644 ms
|
Speed: 1.722 ms
|
Speed: 1.554 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5100
Speed: 1.635 ms
|
SELECT * FROM article_settings WHERE article_id = 9451
Speed: 3.565 ms
|
Speed: 1.078 ms
|
Speed: 1.489 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5920
Speed: 1.579 ms
|
SELECT * FROM article_settings WHERE article_id = 10420
Speed: 4.957 ms
|
Speed: 1.633 ms
|
Speed: 0.911 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5921
Speed: 1.669 ms
|
SELECT * FROM article_settings WHERE article_id = 10765
Speed: 2.251 ms
|
Speed: 1.582 ms
|
Speed: 1.539 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5922
Speed: 1.937 ms
|
SELECT * FROM article_settings WHERE article_id = 10844
Speed: 1.684 ms
|
Speed: 1.381 ms
|
Speed: 1.660 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5923
Speed: 1.332 ms
|
SELECT * FROM article_settings WHERE article_id = 11567
Speed: 1.691 ms
|
Speed: 3.129 ms
|
Speed: 3.226 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5925
Speed: 1.488 ms
|
SELECT * FROM article_settings WHERE article_id = 11903
Speed: 2.681 ms
|
Speed: 3.417 ms
|
Speed: 2.227 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5924
Speed: 2.231 ms
|
SELECT * FROM article_settings WHERE article_id = 11739
Speed: 2.337 ms
|
Speed: 1.624 ms
|
Speed: 0.916 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5926
Speed: 2.097 ms
|
SELECT * FROM article_settings WHERE article_id = 12201
Speed: 1.592 ms
|
Speed: 3.899 ms
|
Speed: 1.004 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5927
Speed: 2.336 ms
|
SELECT * FROM article_settings WHERE article_id = 12253
Speed: 3.492 ms
|
Speed: 1.735 ms
|
Speed: 0.996 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6765
Speed: 1.674 ms
|
SELECT * FROM article_settings WHERE article_id = 14411
Speed: 5.217 ms
|
Speed: 3.294 ms
|
Speed: 1.427 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6767
Speed: 2.213 ms
|
SELECT * FROM article_settings WHERE article_id = 12811
Speed: 1.911 ms
|
Speed: 3.317 ms
|
Speed: 1.660 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6768
Speed: 2.381 ms
|
SELECT * FROM article_settings WHERE article_id = 13868
Speed: 1.627 ms
|
Speed: 1.827 ms
|
Speed: 1.785 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6770
Speed: 1.729 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6771
Speed: 3.138 ms
|
SELECT * FROM article_settings WHERE article_id = 14148
Speed: 1.904 ms
|
Speed: 1.664 ms
|
Speed: 1.611 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6766
Speed: 1.406 ms
|
SELECT * FROM article_settings WHERE article_id = 12805
Speed: 2.286 ms
|
Speed: 2.901 ms
|
Speed: 1.685 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6769
Speed: 1.552 ms
|
SELECT * FROM article_settings WHERE article_id = 13879
Speed: 2.063 ms
|
Speed: 1.435 ms
|
Speed: 1.705 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6772
Speed: 1.527 ms
|
SELECT * FROM article_settings WHERE article_id = 14572
Speed: 2.035 ms
|
Speed: 1.442 ms
|
Speed: 1.621 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7818
Speed: 1.415 ms
|
SELECT * FROM article_settings WHERE article_id = 14638
Speed: 1.967 ms
|
Speed: 1.457 ms
|
Speed: 1.710 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7815
Speed: 1.497 ms
|
SELECT * FROM article_settings WHERE article_id = 14324
Speed: 2.080 ms
|
Speed: 3.249 ms
|
Speed: 1.702 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7816
Speed: 3.177 ms
|
SELECT * FROM article_settings WHERE article_id = 14370
Speed: 2.384 ms
|
Speed: 1.471 ms
|
Speed: 1.633 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7817
Speed: 1.442 ms
|
SELECT * FROM article_settings WHERE article_id = 14577
Speed: 1.969 ms
|
Speed: 1.459 ms
|
Speed: 1.574 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7819
Speed: 4.604 ms
|
SELECT * FROM article_settings WHERE article_id = 15766
Speed: 1.307 ms
|
Speed: 1.931 ms
|
Speed: 1.702 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7821
Speed: 1.543 ms
|
SELECT * FROM article_settings WHERE article_id = 17944
Speed: 2.094 ms
|
Speed: 1.531 ms
|
Speed: 1.726 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7820
Speed: 1.484 ms
|
SELECT * FROM article_settings WHERE article_id = 17554
Speed: 1.993 ms
|
Speed: 1.544 ms
|
Speed: 1.815 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9705
Speed: 2.114 ms
|
SELECT * FROM article_settings WHERE article_id = 20432
Speed: 1.900 ms
|
Speed: 0.989 ms
|
Speed: 2.081 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9707
Speed: 4.000 ms
|
SELECT * FROM article_settings WHERE article_id = 20818
Speed: 2.512 ms
|
Speed: 1.983 ms
|
Speed: 1.805 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9706
Speed: 1.711 ms
|
SELECT * FROM article_settings WHERE article_id = 20699
Speed: 1.694 ms
|
Speed: 1.710 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3928
Speed: 1.847 ms
|
Speed: 2.135 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9709
Speed: 2.208 ms
|
SELECT * FROM article_settings WHERE article_id = 24613
Speed: 2.879 ms
|
Speed: 2.744 ms
|
Speed: 3.592 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9708
Speed: 1.800 ms
|
SELECT * FROM article_settings WHERE article_id = 21177
Speed: 2.649 ms
|
Speed: 1.228 ms
|
Speed: 1.716 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10502
Speed: 2.260 ms
|
SELECT * FROM article_settings WHERE article_id = 24050
Speed: 1.747 ms
|
Speed: 4.043 ms
|
Speed: 1.584 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10499
Speed: 1.632 ms
|
SELECT * FROM article_settings WHERE article_id = 20952
Speed: 1.682 ms
|
Speed: 5.724 ms
|
Speed: 11.315 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10501
Speed: 8.941 ms
|
SELECT * FROM article_settings WHERE article_id = 23824
Speed: 2.417 ms
|
Speed: 3.906 ms
|
Speed: 1.901 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10500
Speed: 1.779 ms
|
SELECT * FROM article_settings WHERE article_id = 23725
Speed: 1.837 ms
|
Speed: 1.697 ms
|
Speed: 1.651 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10503
Speed: 2.279 ms
|
SELECT * FROM article_settings WHERE article_id = 24969
Speed: 1.979 ms
|
Speed: 0.954 ms
|
Speed: 2.459 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10504
Speed: 0.943 ms
|
SELECT * FROM article_settings WHERE article_id = 25568
Speed: 2.565 ms
|
Speed: 1.698 ms
|
Speed: 1.869 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10511
Speed: 6.565 ms
|
SELECT * FROM article_settings WHERE article_id = 25834
Speed: 2.073 ms
|
Speed: 1.674 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4923
Speed: 2.159 ms
|
Speed: 4.224 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10587
Speed: 1.951 ms
|
SELECT * FROM article_settings WHERE article_id = 27713
Speed: 2.485 ms
|
Speed: 3.640 ms
|
Speed: 4.631 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10588
Speed: 3.400 ms
|
SELECT * FROM article_settings WHERE article_id = 28396
Speed: 2.094 ms
|
Speed: 1.618 ms
|
Speed: 2.006 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10589
Speed: 1.810 ms
|
SELECT * FROM article_settings WHERE article_id = 27792
Speed: 2.087 ms
|
Speed: 2.000 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5334
Speed: 1.968 ms
|
Speed: 2.613 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10590
Speed: 1.912 ms
|
SELECT * FROM article_settings WHERE article_id = 28412
Speed: 2.547 ms
|
Speed: 1.792 ms
|
Speed: 1.010 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10591
Speed: 4.520 ms
|
SELECT * FROM article_settings WHERE article_id = 27908
Speed: 4.368 ms
|
Speed: 2.705 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 5375
Speed: 2.941 ms
|
Speed: 2.694 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10592
Speed: 2.358 ms
|
SELECT * FROM article_settings WHERE article_id = 29003
Speed: 2.824 ms
|
Speed: 2.382 ms
|
Speed: 3.283 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12085
Speed: 5.128 ms
|
SELECT * FROM article_settings WHERE article_id = 35426
Speed: 3.312 ms
|
Speed: 2.769 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 7001
Speed: 2.606 ms
|
Speed: 3.076 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12086
Speed: 2.788 ms
|
SELECT * FROM article_settings WHERE article_id = 38478
Speed: 3.321 ms
|
Speed: 2.679 ms
|
Speed: 5.077 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12089
Speed: 1.710 ms
|
SELECT * FROM article_settings WHERE article_id = 39500
Speed: 4.357 ms
|
Speed: 1.018 ms
|
Speed: 3.024 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12087
Speed: 1.598 ms
|
SELECT * FROM article_settings WHERE article_id = 39356
Speed: 2.030 ms
|
Speed: 1.803 ms
|
Speed: 3.501 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12088
Speed: 1.750 ms
|
SELECT * FROM article_settings WHERE article_id = 39495
Speed: 1.995 ms
|
Speed: 1.945 ms
|
Speed: 1.932 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12090
Speed: 1.989 ms
|
SELECT * FROM article_settings WHERE article_id = 34842
Speed: 1.782 ms
|
Speed: 1.753 ms
|
Speed: 0.450 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 0.360 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 0.338 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.296 ms
|
Speed: 0.327 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 0.300 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 0.306 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.295 ms
|
Speed: 2.144 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1314
Speed: 1.741 ms
|
Speed: 9.391 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 1.294 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 1.102 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.905 ms
|
Speed: 2.378 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 2.266 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 2.516 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.337 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80210
Speed: 0.954 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80210
Speed: 2.385 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80211
Speed: 2.761 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80211
Speed: 1.651 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80212
Speed: 7.887 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80212
Speed: 0.931 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80213
Speed: 3.303 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80213
Speed: 1.592 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80214
Speed: 8.170 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80214
Speed: 0.365 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80215
Speed: 2.311 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80215
Speed: 0.301 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80216
Speed: 3.719 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80216
Speed: 1.411 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80217
Speed: 5.823 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80217
Speed: 1.820 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80218
Speed: 4.193 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80218
Speed: 0.323 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80219
Speed: 6.969 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80219
Speed: 1.018 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80220
Speed: 4.040 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80220
Speed: 0.850 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80221
Speed: 15.061 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80221
Speed: 2.749 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80222
Speed: 2.262 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80222
Speed: 2.277 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80223
Speed: 2.766 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80223
Speed: 2.286 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80224
Speed: 2.067 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80224
Speed: 2.608 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80225
Speed: 2.595 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80225
Speed: 2.306 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80226
Speed: 2.540 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80226
Speed: 0.277 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80227
Speed: 5.278 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80227
Speed: 0.817 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80228
Speed: 14.387 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80228
Speed: 1.659 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80229
Speed: 3.653 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80229
Speed: 0.817 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80230
Speed: 3.714 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80230
Speed: 1.337 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80231
Speed: 3.683 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80231
Speed: 1.410 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80232
Speed: 3.263 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80232
Speed: 1.538 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80233
Speed: 4.406 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80233
Speed: 2.519 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80234
Speed: 2.253 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80234
Speed: 2.242 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80235
Speed: 13.078 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80235
Speed: 1.866 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80236
Speed: 2.862 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80236
Speed: 3.698 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80237
Speed: 2.310 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80237
Speed: 1.795 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80238
Speed: 3.705 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80238
Speed: 0.296 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80239
Speed: 3.838 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80239
Speed: 1.092 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80240
Speed: 1.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80240
Speed: 0.294 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80241
Speed: 0.313 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80241
Speed: 0.290 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80242
Speed: 2.232 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80242
Speed: 1.051 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80243
Speed: 71.376 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80243
Speed: 1.514 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80244
Speed: 5.943 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80244
Speed: 0.833 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80245
Speed: 3.883 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80245
Speed: 1.417 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80246
Speed: 4.542 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80246
Speed: 0.302 ms
|
SELECT * FROM citation_settings WHERE citation_id = 80247
Speed: 4.317 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 80247
Speed: 1.383 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
INNER JOIN articles a ON pa.article_id = a.article_id
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = pub-id::publisher-id AND ast.setting_value = 4954
Speed: 10.839 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 4954
Speed: 0.558 ms
|
Speed: 0.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2751
Speed: 1.463 ms
|
SELECT * FROM article_settings WHERE article_id = 4954
Speed: 1.747 ms
|
Speed: 1.628 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 4954 AND
r.status = 2
Speed: 2.489 ms
|
Speed: 9.565 ms
|
SELECT * FROM author_settings WHERE author_id = 7185
Speed: 1.465 ms
|
SELECT * FROM author_settings WHERE author_id = 7186
Speed: 1.752 ms
|
SELECT * FROM author_settings WHERE author_id = 7187
Speed: 0.911 ms
|