SELECT * FROM sessions WHERE session_id = 79vg00mggh6ce3hm9dhp478nv1
Speed: 0.299 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(79vg00mggh6ce3hm9dhp478nv1, 3.148.109.101, Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com), 1730369099, 1730369099, 0, , jurnal.uisu.ac.id
Speed: 0.192 ms
|
SELECT * FROM journals WHERE path = jh
Speed: 0.175 ms
|
Speed: 0.138 ms
|
Speed: 12.161 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.286 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.149 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.128 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.125 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.134 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.121 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.118 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.119 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.100 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.103 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 = 9954
Speed: 0.793 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.status <> 0
AND a.article_id = 9954
Speed: 0.439 ms
|
Speed: 0.326 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6951
Speed: 0.184 ms
|
SELECT * FROM article_settings WHERE article_id = 9954
Speed: 0.216 ms
|
Speed: 0.176 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 = 558
Speed: 0.223 ms
|
Speed: 0.174 ms
|
SELECT * FROM issue_settings WHERE issue_id = 558
Speed: 0.228 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-148-109-101.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-148-109-101.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.542 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 60058981 >= isip.ip_start AND 60058981 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
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 ('2024-10-31 17:04:59' >= s.date_start AND '2024-10-31 17:04:59' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 60058981 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.292 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 0.315 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.234 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 0.180 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.212 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 = 9954
Speed: 0.172 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 = 9954
Speed: 0.840 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.status <> 0
AND a.article_id = 9954
Speed: 0.394 ms
|
Speed: 0.258 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6951
Speed: 0.193 ms
|
SELECT * FROM article_settings WHERE article_id = 9954
Speed: 0.254 ms
|
Speed: 0.202 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-148-109-101.us-east-2.compute.amazonaws.com, LENGTH(ec2-3-148-109-101.us-east-2.compute.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.221 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 60058981 >= isip.ip_start AND 60058981 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
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 ('2024-10-31 17:04:59' >= s.date_start AND '2024-10-31 17:04:59' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 60058981 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.218 ms
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 9954 AND citation_state >= 0 AND citation_state <= 5
Speed: 2.340 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 0.171 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.197 ms
|
Speed: 0.328 ms
|
SELECT * FROM issue_settings WHERE issue_id = 558
Speed: 0.262 ms
|
Speed: 14.737 ms
|
Speed: 0.234 ms
|
SELECT * FROM author_settings WHERE author_id = 19407
Speed: 0.266 ms
|
SELECT * FROM author_settings WHERE author_id = 19408
Speed: 0.190 ms
|
SELECT * FROM author_settings WHERE author_id = 19409
Speed: 0.189 ms
|
Speed: 0.278 ms
|
SELECT * FROM author_settings WHERE author_id = 19407
Speed: 0.276 ms
|
SELECT * FROM author_settings WHERE author_id = 19408
Speed: 0.243 ms
|
SELECT * FROM author_settings WHERE author_id = 19409
Speed: 0.225 ms
|
Speed: 0.216 ms
|
SELECT * FROM author_settings WHERE author_id = 19407
Speed: 0.213 ms
|
SELECT * FROM author_settings WHERE author_id = 19408
Speed: 0.185 ms
|
SELECT * FROM author_settings WHERE author_id = 19409
Speed: 0.173 ms
|
Speed: 0.331 ms
|
SELECT * FROM author_settings WHERE author_id = 19407
Speed: 0.218 ms
|
SELECT * FROM author_settings WHERE author_id = 19408
Speed: 0.191 ms
|
SELECT * FROM author_settings WHERE author_id = 19409
Speed: 0.186 ms
|
Speed: 0.362 ms
|
SELECT * FROM author_settings WHERE author_id = 19407
Speed: 0.220 ms
|
SELECT * FROM author_settings WHERE author_id = 19408
Speed: 0.191 ms
|
SELECT * FROM author_settings WHERE author_id = 19409
Speed: 0.196 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147713
Speed: 0.157 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147713
Speed: 0.184 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147714
Speed: 0.145 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147714
Speed: 0.144 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147715
Speed: 0.182 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147715
Speed: 0.151 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147716
Speed: 0.173 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147716
Speed: 0.151 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147717
Speed: 0.152 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147717
Speed: 0.116 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147718
Speed: 0.170 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147718
Speed: 0.152 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147719
Speed: 0.137 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147719
Speed: 0.130 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147720
Speed: 0.147 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147720
Speed: 0.109 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147721
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147721
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147722
Speed: 0.140 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147722
Speed: 0.133 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147723
Speed: 0.152 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147723
Speed: 0.152 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147724
Speed: 0.185 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147724
Speed: 0.163 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147725
Speed: 0.146 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147725
Speed: 0.127 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147726
Speed: 0.169 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147726
Speed: 0.129 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147727
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147727
Speed: 0.139 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147728
Speed: 0.141 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147728
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147729
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147729
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147730
Speed: 0.137 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147730
Speed: 0.124 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147731
Speed: 0.137 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147731
Speed: 0.115 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147732
Speed: 0.129 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147732
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147733
Speed: 0.126 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147733
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147734
Speed: 0.145 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147734
Speed: 0.131 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147735
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147735
Speed: 0.116 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147736
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147736
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147737
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147737
Speed: 0.113 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147738
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147738
Speed: 0.109 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147739
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147739
Speed: 0.106 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147740
Speed: 0.141 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147740
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147741
Speed: 0.154 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147741
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147742
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147742
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147743
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147743
Speed: 0.132 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147744
Speed: 0.138 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147744
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147745
Speed: 0.146 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147745
Speed: 0.126 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147746
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147746
Speed: 0.107 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147747
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147747
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147748
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147748
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147749
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147749
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147750
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147750
Speed: 0.124 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147751
Speed: 0.135 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147751
Speed: 0.113 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147752
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147752
Speed: 0.111 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147753
Speed: 0.140 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147753
Speed: 0.127 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147754
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147754
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147755
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147755
Speed: 0.100 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147756
Speed: 0.129 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147756
Speed: 0.111 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147757
Speed: 0.129 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147757
Speed: 0.124 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147758
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147758
Speed: 0.112 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147759
Speed: 0.111 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147759
Speed: 0.098 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147760
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147760
Speed: 0.098 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147761
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147761
Speed: 0.109 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147762
Speed: 0.112 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147762
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147763
Speed: 0.121 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147763
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147764
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147764
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147765
Speed: 0.134 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147765
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147766
Speed: 0.111 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147766
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147767
Speed: 0.126 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147767
Speed: 0.116 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147768
Speed: 0.120 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147768
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147769
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147769
Speed: 0.103 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147770
Speed: 0.113 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147770
Speed: 0.111 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147771
Speed: 0.113 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147771
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147772
Speed: 0.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147772
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147773
Speed: 0.122 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147773
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147774
Speed: 0.138 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147774
Speed: 0.116 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147775
Speed: 0.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147775
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147776
Speed: 0.118 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147776
Speed: 0.103 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147777
Speed: 0.118 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147777
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147778
Speed: 0.117 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147778
Speed: 0.100 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147779
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147779
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147780
Speed: 0.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147780
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147781
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147781
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147782
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147782
Speed: 0.107 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147783
Speed: 0.117 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147783
Speed: 0.100 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147784
Speed: 0.113 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147784
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147785
Speed: 0.148 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147785
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147786
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147786
Speed: 0.130 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147787
Speed: 0.132 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147787
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147788
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147788
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147789
Speed: 0.124 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147789
Speed: 0.105 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147790
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147790
Speed: 0.134 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147791
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147791
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147792
Speed: 0.113 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147792
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147793
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147793
Speed: 0.113 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147794
Speed: 0.114 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147794
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147795
Speed: 0.126 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147795
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147796
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147796
Speed: 0.119 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147797
Speed: 0.117 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147797
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147798
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147798
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147799
Speed: 0.202 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147799
Speed: 0.125 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147800
Speed: 0.140 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147800
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147801
Speed: 0.125 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147801
Speed: 0.119 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147802
Speed: 0.124 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147802
Speed: 0.109 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147803
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147803
Speed: 0.117 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147804
Speed: 0.124 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147804
Speed: 0.115 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147805
Speed: 0.117 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147805
Speed: 0.108 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147806
Speed: 0.124 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147806
Speed: 0.106 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147807
Speed: 0.160 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147807
Speed: 0.138 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147808
Speed: 0.148 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147808
Speed: 0.135 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147809
Speed: 0.192 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147809
Speed: 0.133 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147810
Speed: 0.137 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147810
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147811
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147811
Speed: 0.106 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147812
Speed: 0.147 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147812
Speed: 0.108 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147813
Speed: 0.117 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147813
Speed: 0.107 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147814
Speed: 0.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147814
Speed: 0.106 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147815
Speed: 0.115 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147815
Speed: 0.113 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147816
Speed: 0.116 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147816
Speed: 0.129 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147817
Speed: 0.126 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147817
Speed: 0.107 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147818
Speed: 0.121 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147818
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147819
Speed: 0.119 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147819
Speed: 0.104 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147820
Speed: 0.113 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147820
Speed: 0.102 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147821
Speed: 0.118 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147821
Speed: 0.113 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147822
Speed: 0.127 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147822
Speed: 0.109 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147823
Speed: 0.118 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147823
Speed: 0.101 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147824
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147824
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147825
Speed: 0.140 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147825
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147826
Speed: 0.135 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147826
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147827
Speed: 0.148 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147827
Speed: 0.123 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147828
Speed: 0.133 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147828
Speed: 0.115 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147829
Speed: 0.167 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147829
Speed: 0.205 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147830
Speed: 0.189 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147830
Speed: 0.144 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147831
Speed: 0.170 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147831
Speed: 0.143 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147832
Speed: 0.172 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147832
Speed: 0.128 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147833
Speed: 0.153 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147833
Speed: 0.173 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147834
Speed: 0.157 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147834
Speed: 0.142 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147835
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147835
Speed: 0.147 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147836
Speed: 0.149 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147836
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147837
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147837
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147838
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147838
Speed: 0.128 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147839
Speed: 0.134 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147839
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147840
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147840
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147841
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147841
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147842
Speed: 0.134 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147842
Speed: 0.119 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147843
Speed: 0.134 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147843
Speed: 0.116 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147844
Speed: 0.145 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147844
Speed: 0.262 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147845
Speed: 0.161 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147845
Speed: 0.138 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147846
Speed: 0.142 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147846
Speed: 0.132 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147847
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147847
Speed: 0.132 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147848
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147848
Speed: 0.133 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147849
Speed: 0.144 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147849
Speed: 0.154 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147850
Speed: 0.176 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147850
Speed: 0.140 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147851
Speed: 0.174 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147851
Speed: 0.119 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147852
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147852
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147853
Speed: 0.135 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147853
Speed: 0.123 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147854
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147854
Speed: 0.124 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147855
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147855
Speed: 0.117 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147856
Speed: 0.133 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147856
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147857
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147857
Speed: 0.117 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147858
Speed: 0.177 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147858
Speed: 0.135 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147859
Speed: 0.132 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147859
Speed: 0.144 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147860
Speed: 0.128 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147860
Speed: 0.115 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147861
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147861
Speed: 0.125 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147862
Speed: 0.135 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147862
Speed: 0.120 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147863
Speed: 0.141 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147863
Speed: 0.274 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147864
Speed: 0.151 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147864
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147865
Speed: 0.149 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147865
Speed: 0.146 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147866
Speed: 0.150 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147866
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147867
Speed: 0.149 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147867
Speed: 0.139 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147868
Speed: 0.147 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147868
Speed: 0.130 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147869
Speed: 0.190 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147869
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147870
Speed: 0.144 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147870
Speed: 0.131 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147871
Speed: 0.155 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147871
Speed: 0.134 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147872
Speed: 0.138 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147872
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147873
Speed: 0.133 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147873
Speed: 0.122 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147874
Speed: 0.140 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147874
Speed: 0.143 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147875
Speed: 0.132 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147875
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147876
Speed: 0.136 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147876
Speed: 0.114 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147877
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147877
Speed: 0.145 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147878
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147878
Speed: 0.130 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147879
Speed: 0.132 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147879
Speed: 0.121 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147880
Speed: 0.131 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147880
Speed: 0.124 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147881
Speed: 0.130 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147881
Speed: 0.118 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147882
Speed: 0.157 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147882
Speed: 0.127 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147883
Speed: 0.143 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147883
Speed: 0.132 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147884
Speed: 0.133 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147884
Speed: 0.115 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147885
Speed: 0.137 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147885
Speed: 0.117 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147886
Speed: 0.141 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147886
Speed: 0.130 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147887
Speed: 0.165 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147887
Speed: 0.119 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147888
Speed: 0.167 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147888
Speed: 0.137 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147889
Speed: 0.132 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147889
Speed: 0.135 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147890
Speed: 0.153 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147890
Speed: 0.126 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147891
Speed: 0.157 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147891
Speed: 0.165 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147892
Speed: 0.165 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147892
Speed: 0.146 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147893
Speed: 0.180 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147893
Speed: 0.159 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147894
Speed: 0.160 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147894
Speed: 0.134 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147895
Speed: 0.142 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147895
Speed: 0.133 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147896
Speed: 0.183 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147896
Speed: 0.165 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147897
Speed: 0.162 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147897
Speed: 0.146 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147898
Speed: 0.203 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147898
Speed: 0.180 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147899
Speed: 0.206 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147899
Speed: 0.183 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147900
Speed: 0.173 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147900
Speed: 0.164 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147901
Speed: 0.184 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147901
Speed: 0.180 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147902
Speed: 0.204 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147902
Speed: 0.181 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147903
Speed: 0.172 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147903
Speed: 0.158 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147904
Speed: 0.166 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147904
Speed: 0.159 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147905
Speed: 0.172 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147905
Speed: 0.167 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147906
Speed: 0.171 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147906
Speed: 0.160 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147907
Speed: 0.170 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147907
Speed: 0.164 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147908
Speed: 0.181 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147908
Speed: 0.156 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147909
Speed: 0.168 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147909
Speed: 0.156 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147910
Speed: 0.169 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147910
Speed: 0.169 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147911
Speed: 0.172 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147911
Speed: 0.160 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147912
Speed: 0.173 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147912
Speed: 0.158 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147913
Speed: 0.168 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147913
Speed: 0.169 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147914
Speed: 0.187 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147914
Speed: 0.159 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147915
Speed: 0.167 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147915
Speed: 0.161 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147916
Speed: 0.187 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147916
Speed: 0.263 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147917
Speed: 0.212 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147917
Speed: 0.168 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147918
Speed: 0.189 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147918
Speed: 0.202 ms
|
SELECT * FROM citation_settings WHERE citation_id = 147919
Speed: 0.169 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 147919
Speed: 0.156 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 = 9954
Speed: 1.040 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.status <> 0
AND a.article_id = 9954
Speed: 0.516 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6951
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 9954
Speed: 0.334 ms
|
Speed: 0.237 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 9954 AND
r.status = 2
Speed: 0.248 ms
|