SELECT * FROM sessions WHERE session_id = mvgrdr898au7ojobc9f4r4aat2
Speed: 2.475 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(mvgrdr898au7ojobc9f4r4aat2, 18.221.22.8, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1740373307, 1740373307, 0, , journal.uinsgd.ac.id.
Speed: 0.346 ms
|
SELECT * FROM journals WHERE path = jp
Speed: 4.163 ms
|
Speed: 3.598 ms
|
Speed: 139.786 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 120.107 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 3.125 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 2.971 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 2.503 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 2.844 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 3.026 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 2.900 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 2.799 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 2.736 ms
|
SELECT pa.*,
a.*,
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 = 15577
Speed: 55.340 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 15577
Speed: 1.761 ms
|
Speed: 12.793 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 4.133 ms
|
SELECT * FROM article_settings WHERE article_id = 15577
Speed: 3.300 ms
|
Speed: 0.973 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 = 837
Speed: 11.471 ms
|
Speed: 2.288 ms
|
SELECT * FROM issue_settings WHERE issue_id = 837
Speed: 1.842 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-18-221-22-8.us-east-2.compute.amazonaws.com, LENGTH(ec2-18-221-22-8.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 88
Speed: 0.508 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 316478984 >= isip.ip_start AND 316478984 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 88
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-24 05:01:48' >= s.date_start AND '2025-02-24 05:01:48' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 316478984 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 88
Speed: 0.325 ms
|
SELECT * FROM sections WHERE section_id = 122
Speed: 0.852 ms
|
SELECT * FROM section_settings WHERE section_id = 122
Speed: 0.294 ms
|
SELECT * FROM sections WHERE section_id = 122
Speed: 0.263 ms
|
SELECT * FROM section_settings WHERE section_id = 122
Speed: 0.292 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 = 6413 AND g.article_id = 15577
Speed: 0.351 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 51.913 ms
|
SELECT * FROM sections WHERE section_id = 122
Speed: 13.284 ms
|
SELECT * FROM section_settings WHERE section_id = 122
Speed: 2.564 ms
|
Speed: 12.911 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1516
Speed: 3.268 ms
|
Speed: 0.962 ms
|
SELECT * FROM author_settings WHERE author_id = 23970
Speed: 2.052 ms
|
SELECT * FROM author_settings WHERE author_id = 23971
Speed: 4.062 ms
|
SELECT * FROM author_settings WHERE author_id = 23972
Speed: 1.442 ms
|
SELECT * FROM author_settings WHERE author_id = 23973
Speed: 1.774 ms
|
SELECT * FROM author_settings WHERE author_id = 23974
Speed: 0.987 ms
|
Speed: 13.030 ms
|
SELECT * FROM author_settings WHERE author_id = 23970
Speed: 4.180 ms
|
SELECT * FROM author_settings WHERE author_id = 23971
Speed: 3.443 ms
|
SELECT * FROM author_settings WHERE author_id = 23972
Speed: 19.309 ms
|
SELECT * FROM author_settings WHERE author_id = 23973
Speed: 2.477 ms
|
SELECT * FROM author_settings WHERE author_id = 23974
Speed: 1.603 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
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 = 15577
Speed: 13.261 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_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 = 15577
Speed: 24.775 ms
|
Speed: 3.860 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 1.692 ms
|
SELECT * FROM article_settings WHERE article_id = 15577
Speed: 1.680 ms
|
Speed: 12.456 ms
|
Speed: 12.053 ms
|
SELECT * FROM author_settings WHERE author_id = 23970
Speed: 1.638 ms
|
SELECT * FROM author_settings WHERE author_id = 23971
Speed: 2.232 ms
|
SELECT * FROM author_settings WHERE author_id = 23972
Speed: 0.974 ms
|
SELECT * FROM author_settings WHERE author_id = 23973
Speed: 0.994 ms
|
SELECT * FROM author_settings WHERE author_id = 23974
Speed: 1.607 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa
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 = 15577
Speed: 5.888 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 15577
Speed: 2.770 ms
|
Speed: 2.709 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 2.866 ms
|
SELECT * FROM article_settings WHERE article_id = 15577
Speed: 2.262 ms
|
Speed: 29.135 ms
|
SELECT pa.*,
a.*,
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 = 88
Speed: 36.036 ms
|
Speed: 3.036 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5232
Speed: 2.020 ms
|
SELECT * FROM article_settings WHERE article_id = 11053
Speed: 2.052 ms
|
Speed: 1.413 ms
|
Speed: 1.882 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5234
Speed: 1.344 ms
|
SELECT * FROM article_settings WHERE article_id = 11055
Speed: 3.615 ms
|
Speed: 2.176 ms
|
Speed: 2.226 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5236
Speed: 2.765 ms
|
SELECT * FROM article_settings WHERE article_id = 11057
Speed: 3.231 ms
|
Speed: 3.144 ms
|
Speed: 3.262 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5233
Speed: 2.896 ms
|
SELECT * FROM article_settings WHERE article_id = 11054
Speed: 6.077 ms
|
Speed: 1.541 ms
|
Speed: 4.155 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5235
Speed: 9.433 ms
|
SELECT * FROM article_settings WHERE article_id = 11056
Speed: 4.046 ms
|
Speed: 5.360 ms
|
Speed: 1.789 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5479
Speed: 2.603 ms
|
SELECT * FROM article_settings WHERE article_id = 12199
Speed: 3.171 ms
|
Speed: 3.060 ms
|
Speed: 2.877 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5480
Speed: 3.510 ms
|
SELECT * FROM article_settings WHERE article_id = 12206
Speed: 3.839 ms
|
Speed: 5.317 ms
|
Speed: 2.438 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5476
Speed: 2.151 ms
|
SELECT * FROM article_settings WHERE article_id = 12446
Speed: 2.581 ms
|
Speed: 2.348 ms
|
Speed: 3.242 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5477
Speed: 18.000 ms
|
SELECT * FROM article_settings WHERE article_id = 12205
Speed: 3.569 ms
|
Speed: 2.748 ms
|
Speed: 4.674 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5478
Speed: 3.010 ms
|
SELECT * FROM article_settings WHERE article_id = 12207
Speed: 4.980 ms
|
Speed: 6.015 ms
|
Speed: 3.702 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5481
Speed: 2.863 ms
|
SELECT * FROM article_settings WHERE article_id = 12202
Speed: 6.403 ms
|
Speed: 1.682 ms
|
Speed: 2.149 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6073
Speed: 2.301 ms
|
SELECT * FROM article_settings WHERE article_id = 12461
Speed: 3.368 ms
|
Speed: 9.321 ms
|
Speed: 3.240 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6072
Speed: 3.262 ms
|
SELECT * FROM article_settings WHERE article_id = 12700
Speed: 4.063 ms
|
Speed: 3.980 ms
|
Speed: 3.458 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6071
Speed: 1.672 ms
|
SELECT * FROM article_settings WHERE article_id = 12862
Speed: 8.931 ms
|
Speed: 2.584 ms
|
Speed: 3.905 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6077
Speed: 2.489 ms
|
SELECT * FROM article_settings WHERE article_id = 11742
Speed: 2.344 ms
|
Speed: 2.274 ms
|
Speed: 2.293 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6063
Speed: 2.453 ms
|
SELECT * FROM article_settings WHERE article_id = 12674
Speed: 7.254 ms
|
Speed: 1.755 ms
|
Speed: 2.617 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6076
Speed: 2.266 ms
|
SELECT * FROM article_settings WHERE article_id = 12845
Speed: 2.749 ms
|
Speed: 2.137 ms
|
Speed: 5.543 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6074
Speed: 2.551 ms
|
SELECT * FROM article_settings WHERE article_id = 12704
Speed: 6.611 ms
|
Speed: 2.517 ms
|
Speed: 4.120 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6075
Speed: 3.754 ms
|
SELECT * FROM article_settings WHERE article_id = 12769
Speed: 4.867 ms
|
Speed: 1.674 ms
|
Speed: 18.902 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6078
Speed: 2.774 ms
|
SELECT * FROM article_settings WHERE article_id = 12792
Speed: 4.044 ms
|
Speed: 16.276 ms
|
Speed: 3.078 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6079
Speed: 2.367 ms
|
SELECT * FROM article_settings WHERE article_id = 12242
Speed: 2.652 ms
|
Speed: 2.580 ms
|
Speed: 3.113 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6463
Speed: 2.144 ms
|
SELECT * FROM article_settings WHERE article_id = 13525
Speed: 2.726 ms
|
Speed: 5.698 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2489
Speed: 2.925 ms
|
Speed: 4.623 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6192
Speed: 3.333 ms
|
SELECT * FROM article_settings WHERE article_id = 13591
Speed: 2.495 ms
|
Speed: 6.235 ms
|
Speed: 19.067 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6115
Speed: 3.497 ms
|
SELECT * FROM article_settings WHERE article_id = 12823
Speed: 15.760 ms
|
Speed: 39.099 ms
|
Speed: 2.009 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6110
Speed: 1.936 ms
|
SELECT * FROM article_settings WHERE article_id = 13418
Speed: 1.138 ms
|
Speed: 47.269 ms
|
Speed: 1.850 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6460
Speed: 12.429 ms
|
SELECT * FROM article_settings WHERE article_id = 13469
Speed: 2.285 ms
|
Speed: 0.958 ms
|
Speed: 0.994 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6113
Speed: 3.556 ms
|
SELECT * FROM article_settings WHERE article_id = 13657
Speed: 1.550 ms
|
Speed: 1.526 ms
|
Speed: 1.683 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6111
Speed: 1.536 ms
|
SELECT * FROM article_settings WHERE article_id = 13562
Speed: 1.619 ms
|
Speed: 0.876 ms
|
Speed: 1.599 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6108
Speed: 1.463 ms
|
SELECT * FROM article_settings WHERE article_id = 13580
Speed: 1.684 ms
|
Speed: 2.224 ms
|
Speed: 7.641 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6461
Speed: 2.022 ms
|
SELECT * FROM article_settings WHERE article_id = 13583
Speed: 1.780 ms
|
Speed: 1.455 ms
|
Speed: 1.509 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6106
Speed: 1.495 ms
|
SELECT * FROM article_settings WHERE article_id = 13590
Speed: 1.801 ms
|
Speed: 1.712 ms
|
Speed: 3.909 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6102
Speed: 3.070 ms
|
SELECT * FROM article_settings WHERE article_id = 13608
Speed: 7.185 ms
|
Speed: 1.667 ms
|
Speed: 1.640 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6109
Speed: 4.582 ms
|
SELECT * FROM article_settings WHERE article_id = 13615
Speed: 1.525 ms
|
Speed: 1.982 ms
|
Speed: 1.537 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6197
Speed: 1.576 ms
|
SELECT * FROM article_settings WHERE article_id = 13594
Speed: 2.459 ms
|
Speed: 1.399 ms
|
Speed: 1.439 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6462
Speed: 1.499 ms
|
SELECT * FROM article_settings WHERE article_id = 13500
Speed: 1.700 ms
|
Speed: 1.384 ms
|
Speed: 1.466 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6378
Speed: 1.496 ms
|
SELECT * FROM article_settings WHERE article_id = 14393
Speed: 1.951 ms
|
Speed: 1.386 ms
|
Speed: 3.861 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6379
Speed: 1.585 ms
|
SELECT * FROM article_settings WHERE article_id = 15055
Speed: 4.028 ms
|
Speed: 1.500 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2761
Speed: 1.478 ms
|
Speed: 2.274 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6464
Speed: 0.756 ms
|
SELECT * FROM article_settings WHERE article_id = 14510
Speed: 4.001 ms
|
Speed: 10.536 ms
|
Speed: 9.910 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6410
Speed: 2.072 ms
|
SELECT * FROM article_settings WHERE article_id = 15575
Speed: 2.206 ms
|
Speed: 1.532 ms
|
Speed: 1.081 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 1.550 ms
|
SELECT * FROM article_settings WHERE article_id = 15577
Speed: 2.670 ms
|
Speed: 0.852 ms
|
Speed: 1.802 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6415
Speed: 2.030 ms
|
SELECT * FROM article_settings WHERE article_id = 15578
Speed: 0.962 ms
|
Speed: 0.990 ms
|
Speed: 3.626 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6231
Speed: 2.816 ms
|
SELECT * FROM article_settings WHERE article_id = 13693
Speed: 2.487 ms
|
Speed: 1.419 ms
|
Speed: 1.701 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7060
Speed: 1.572 ms
|
SELECT * FROM article_settings WHERE article_id = 13595
Speed: 1.647 ms
|
Speed: 1.484 ms
|
Speed: 1.439 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7062
Speed: 1.431 ms
|
SELECT * FROM article_settings WHERE article_id = 13635
Speed: 1.814 ms
|
Speed: 1.353 ms
|
Speed: 1.705 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7064
Speed: 0.834 ms
|
SELECT * FROM article_settings WHERE article_id = 13663
Speed: 6.606 ms
|
Speed: 1.500 ms
|
Speed: 3.211 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7065
Speed: 1.680 ms
|
SELECT * FROM article_settings WHERE article_id = 14300
Speed: 2.426 ms
|
Speed: 1.345 ms
|
Speed: 1.687 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7061
Speed: 1.339 ms
|
SELECT * FROM article_settings WHERE article_id = 13672
Speed: 1.721 ms
|
Speed: 1.480 ms
|
Speed: 1.584 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7066
Speed: 1.313 ms
|
SELECT * FROM article_settings WHERE article_id = 14435
Speed: 1.690 ms
|
Speed: 1.399 ms
|
Speed: 1.754 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7070
Speed: 1.000 ms
|
SELECT * FROM article_settings WHERE article_id = 14440
Speed: 2.115 ms
|
Speed: 0.814 ms
|
Speed: 1.773 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7067
Speed: 1.865 ms
|
SELECT * FROM article_settings WHERE article_id = 14455
Speed: 1.528 ms
|
Speed: 1.617 ms
|
Speed: 1.647 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7069
Speed: 1.362 ms
|
SELECT * FROM article_settings WHERE article_id = 14428
Speed: 1.564 ms
|
Speed: 1.551 ms
|
Speed: 3.306 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7071
Speed: 3.077 ms
|
SELECT * FROM article_settings WHERE article_id = 16876
Speed: 1.615 ms
|
Speed: 3.329 ms
|
Speed: 1.622 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7068
Speed: 1.519 ms
|
SELECT * FROM article_settings WHERE article_id = 14453
Speed: 1.554 ms
|
Speed: 1.579 ms
|
Speed: 1.029 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7072
Speed: 3.544 ms
|
SELECT * FROM article_settings WHERE article_id = 16979
Speed: 1.514 ms
|
Speed: 1.700 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3177
Speed: 1.592 ms
|
Speed: 1.473 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7074
Speed: 1.417 ms
|
SELECT * FROM article_settings WHERE article_id = 15496
Speed: 2.375 ms
|
Speed: 0.910 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2849
Speed: 2.144 ms
|
Speed: 3.497 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7076
Speed: 1.739 ms
|
SELECT * FROM article_settings WHERE article_id = 16827
Speed: 1.496 ms
|
Speed: 1.464 ms
|
Speed: 1.834 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7078
Speed: 1.320 ms
|
SELECT * FROM article_settings WHERE article_id = 17018
Speed: 1.727 ms
|
Speed: 1.491 ms
|
Speed: 1.762 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7073
Speed: 1.399 ms
|
SELECT * FROM article_settings WHERE article_id = 17009
Speed: 1.641 ms
|
Speed: 3.806 ms
|
Speed: 1.949 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7077
Speed: 1.508 ms
|
SELECT * FROM article_settings WHERE article_id = 17008
Speed: 1.817 ms
|
Speed: 2.958 ms
|
Speed: 2.209 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7075
Speed: 3.886 ms
|
SELECT * FROM article_settings WHERE article_id = 17056
Speed: 4.107 ms
|
Speed: 1.596 ms
|
Speed: 1.953 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8292
Speed: 1.415 ms
|
SELECT * FROM article_settings WHERE article_id = 19430
Speed: 1.685 ms
|
Speed: 1.517 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3716
Speed: 6.520 ms
|
Speed: 5.035 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8290
Speed: 2.073 ms
|
SELECT * FROM article_settings WHERE article_id = 19303
Speed: 1.269 ms
|
Speed: 1.620 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3677
Speed: 1.927 ms
|
Speed: 1.547 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8291
Speed: 1.580 ms
|
SELECT * FROM article_settings WHERE article_id = 19521
Speed: 3.067 ms
|
Speed: 0.308 ms
|
Speed: 2.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8293
Speed: 4.554 ms
|
SELECT * FROM article_settings WHERE article_id = 19625
Speed: 2.226 ms
|
Speed: 0.980 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3731
Speed: 2.280 ms
|
Speed: 1.532 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8284
Speed: 1.712 ms
|
SELECT * FROM article_settings WHERE article_id = 17583
Speed: 5.998 ms
|
Speed: 1.617 ms
|
Speed: 1.633 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8288
Speed: 1.545 ms
|
SELECT * FROM article_settings WHERE article_id = 18714
Speed: 1.537 ms
|
Speed: 1.816 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3547
Speed: 3.532 ms
|
Speed: 4.059 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10369
Speed: 1.357 ms
|
SELECT * FROM article_settings WHERE article_id = 23344
Speed: 2.245 ms
|
Speed: 1.510 ms
|
Speed: 0.932 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8324
Speed: 1.895 ms
|
SELECT * FROM article_settings WHERE article_id = 14653
Speed: 1.720 ms
|
Speed: 2.050 ms
|
Speed: 1.090 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8325
Speed: 1.312 ms
|
SELECT * FROM article_settings WHERE article_id = 17558
Speed: 2.204 ms
|
Speed: 3.672 ms
|
Speed: 1.675 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8472
Speed: 1.469 ms
|
SELECT * FROM article_settings WHERE article_id = 23897
Speed: 1.508 ms
|
Speed: 3.102 ms
|
Speed: 1.690 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8966
Speed: 1.594 ms
|
SELECT * FROM article_settings WHERE article_id = 24629
Speed: 1.593 ms
|
Speed: 1.481 ms
|
Speed: 1.940 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9000
Speed: 1.558 ms
|
SELECT * FROM article_settings WHERE article_id = 24757
Speed: 1.597 ms
|
Speed: 1.496 ms
|
Speed: 3.964 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8967
Speed: 3.940 ms
|
SELECT * FROM article_settings WHERE article_id = 25467
Speed: 5.093 ms
|
Speed: 1.844 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4841
Speed: 1.864 ms
|
Speed: 1.834 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8969
Speed: 3.806 ms
|
SELECT * FROM article_settings WHERE article_id = 25476
Speed: 1.745 ms
|
Speed: 1.758 ms
|
Speed: 1.668 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 8964
Speed: 1.482 ms
|
SELECT * FROM article_settings WHERE article_id = 24163
Speed: 1.588 ms
|
Speed: 3.938 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4599
Speed: 4.349 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4600
Speed: 3.000 ms
|
Speed: 4.167 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9847
Speed: 1.685 ms
|
SELECT * FROM article_settings WHERE article_id = 27833
Speed: 2.844 ms
|
Speed: 0.893 ms
|
Speed: 1.879 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9845
Speed: 20.122 ms
|
SELECT * FROM article_settings WHERE article_id = 28445
Speed: 1.896 ms
|
Speed: 1.593 ms
|
Speed: 1.896 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9846
Speed: 1.710 ms
|
SELECT * FROM article_settings WHERE article_id = 30741
Speed: 1.741 ms
|
Speed: 1.508 ms
|
Speed: 1.874 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9848
Speed: 1.325 ms
|
SELECT * FROM article_settings WHERE article_id = 30748
Speed: 1.921 ms
|
Speed: 1.450 ms
|
Speed: 1.914 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9844
Speed: 1.666 ms
|
SELECT * FROM article_settings WHERE article_id = 29450
Speed: 1.635 ms
|
Speed: 1.405 ms
|
Speed: 1.820 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10374
Speed: 1.382 ms
|
SELECT * FROM article_settings WHERE article_id = 31723
Speed: 3.391 ms
|
Speed: 1.813 ms
|
Speed: 0.920 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10370
Speed: 2.399 ms
|
SELECT * FROM article_settings WHERE article_id = 31717
Speed: 2.000 ms
|
Speed: 0.852 ms
|
Speed: 2.044 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10371
Speed: 0.869 ms
|
SELECT * FROM article_settings WHERE article_id = 32332
Speed: 4.236 ms
|
Speed: 12.755 ms
|
Speed: 1.174 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10375
Speed: 11.990 ms
|
SELECT * FROM article_settings WHERE article_id = 32601
Speed: 1.889 ms
|
Speed: 1.820 ms
|
Speed: 1.448 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10377
Speed: 1.469 ms
|
SELECT * FROM article_settings WHERE article_id = 32609
Speed: 1.672 ms
|
Speed: 1.603 ms
|
Speed: 1.423 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10596
Speed: 1.803 ms
|
SELECT * FROM article_settings WHERE article_id = 34158
Speed: 1.460 ms
|
Speed: 1.584 ms
|
Speed: 1.487 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10679
Speed: 1.798 ms
|
SELECT * FROM article_settings WHERE article_id = 33758
Speed: 2.314 ms
|
Speed: 0.912 ms
|
Speed: 3.047 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10698
Speed: 1.033 ms
|
SELECT * FROM article_settings WHERE article_id = 33622
Speed: 3.300 ms
|
Speed: 0.965 ms
|
Speed: 5.775 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10700
Speed: 1.894 ms
|
SELECT * FROM article_settings WHERE article_id = 34631
Speed: 5.412 ms
|
Speed: 2.997 ms
|
Speed: 1.185 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10699
Speed: 1.443 ms
|
SELECT * FROM article_settings WHERE article_id = 34630
Speed: 10.018 ms
|
Speed: 1.699 ms
|
Speed: 1.917 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11689
Speed: 1.495 ms
|
SELECT * FROM article_settings WHERE article_id = 38662
Speed: 3.396 ms
|
Speed: 1.515 ms
|
Speed: 3.139 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11690
Speed: 1.703 ms
|
SELECT * FROM article_settings WHERE article_id = 37087
Speed: 1.763 ms
|
Speed: 1.760 ms
|
Speed: 0.931 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11692
Speed: 1.626 ms
|
SELECT * FROM article_settings WHERE article_id = 37453
Speed: 2.389 ms
|
Speed: 1.042 ms
|
Speed: 1.068 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11855
Speed: 1.611 ms
|
SELECT * FROM article_settings WHERE article_id = 38133
Speed: 1.671 ms
|
Speed: 0.922 ms
|
Speed: 3.510 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11688
Speed: 1.529 ms
|
SELECT * FROM article_settings WHERE article_id = 38661
Speed: 1.712 ms
|
Speed: 1.587 ms
|
Speed: 2.042 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12306
Speed: 10.028 ms
|
SELECT * FROM article_settings WHERE article_id = 43171
Speed: 1.768 ms
|
Speed: 6.376 ms
|
Speed: 3.715 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12326
Speed: 1.733 ms
|
SELECT * FROM article_settings WHERE article_id = 38145
Speed: 1.687 ms
|
Speed: 1.571 ms
|
Speed: 2.149 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12327
Speed: 2.319 ms
|
SELECT * FROM article_settings WHERE article_id = 43497
Speed: 4.314 ms
|
Speed: 1.570 ms
|
Speed: 1.961 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12335
Speed: 1.589 ms
|
SELECT * FROM article_settings WHERE article_id = 40656
Speed: 2.858 ms
|
Speed: 1.540 ms
|
Speed: 4.479 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12337
Speed: 2.855 ms
|
SELECT * FROM article_settings WHERE article_id = 41345
Speed: 1.615 ms
|
Speed: 1.476 ms
|
Speed: 12.973 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12424
Speed: 3.808 ms
|
SELECT * FROM article_settings WHERE article_id = 41450
Speed: 3.617 ms
|
Speed: 1.692 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8276
Speed: 1.632 ms
|
Speed: 12.910 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12422
Speed: 32.300 ms
|
SELECT * FROM article_settings WHERE article_id = 43186
Speed: 2.415 ms
|
Speed: 4.299 ms
|
Speed: 0.427 ms
|
SELECT * FROM author_settings WHERE author_id = 23970
Speed: 0.325 ms
|
SELECT * FROM author_settings WHERE author_id = 23971
Speed: 0.293 ms
|
SELECT * FROM author_settings WHERE author_id = 23972
Speed: 0.268 ms
|
SELECT * FROM author_settings WHERE author_id = 23973
Speed: 0.297 ms
|
SELECT * FROM author_settings WHERE author_id = 23974
Speed: 0.277 ms
|
SELECT pa.*,
a.*,
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 = 15577
Speed: 57.906 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 15577
Speed: 1.893 ms
|
Speed: 2.171 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6413
Speed: 3.887 ms
|
SELECT * FROM article_settings WHERE article_id = 15577
Speed: 1.651 ms
|
Speed: 3.644 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 15577 AND
r.status = 2
Speed: 12.672 ms
|