SELECT * FROM sessions WHERE session_id = r4d6l7ri7tq4fpa07tabd34ev5
Speed: 0.451 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(r4d6l7ri7tq4fpa07tabd34ev5, 18.97.14.81, CCBot/2.0 (https://commoncrawl.org/faq/), 1739907356, 1739907356, 0, , journal.uinsgd.ac.id
Speed: 0.326 ms
|
SELECT * FROM journals WHERE path = ja
Speed: 0.265 ms
|
Speed: 0.239 ms
|
Speed: 37.451 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.316 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.218 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.217 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.210 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.201 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.206 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.194 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.197 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.192 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 = 6329
Speed: 6.803 ms
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 6329
Speed: 0.663 ms
|
Speed: 0.476 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4022
Speed: 0.278 ms
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 0.376 ms
|
Speed: 0.287 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 = 592
Speed: 0.401 ms
|
Speed: 0.201 ms
|
SELECT * FROM issue_settings WHERE issue_id = 592
Speed: 0.345 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(18-97-14-81.crawl.commoncrawl.org, LENGTH(18-97-14-81.crawl.commoncrawl.org)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 31
Speed: 0.405 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 308350545 >= isip.ip_start AND 308350545 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 31
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-18 19:35:56' >= s.date_start AND '2025-02-18 19:35:56' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 308350545 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 31
Speed: 0.376 ms
|
SELECT * FROM sections WHERE section_id = 33
Speed: 0.261 ms
|
SELECT * FROM section_settings WHERE section_id = 33
Speed: 0.269 ms
|
SELECT * FROM sections WHERE section_id = 33
Speed: 0.260 ms
|
SELECT * FROM section_settings WHERE section_id = 33
Speed: 0.235 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 = 6329
Speed: 0.217 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 = 6329
Speed: 1.960 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 = 6329
Speed: 0.490 ms
|
Speed: 0.372 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4022
Speed: 0.305 ms
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 0.383 ms
|
Speed: 0.323 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(18-97-14-81.crawl.commoncrawl.org, LENGTH(18-97-14-81.crawl.commoncrawl.org)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 31
Speed: 0.329 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 308350545 >= isip.ip_start AND 308350545 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 31
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-18 19:35:56' >= s.date_start AND '2025-02-18 19:35:56' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 308350545 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 31
Speed: 0.308 ms
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 6329 AND citation_state >= 0 AND citation_state <= 5
Speed: 19.653 ms
|
SELECT * FROM sections WHERE section_id = 33
Speed: 0.371 ms
|
SELECT * FROM section_settings WHERE section_id = 33
Speed: 0.358 ms
|
Speed: 40.089 ms
|
Speed: 0.481 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1511
Speed: 0.404 ms
|
Speed: 0.389 ms
|
SELECT * FROM author_settings WHERE author_id = 9259
Speed: 0.348 ms
|
Speed: 0.376 ms
|
SELECT * FROM author_settings WHERE author_id = 9259
Speed: 0.349 ms
|
Speed: 0.337 ms
|
SELECT * FROM author_settings WHERE author_id = 9259
Speed: 0.284 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 = 31
Speed: 15.955 ms
|
Speed: 0.454 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1141
Speed: 0.254 ms
|
SELECT * FROM article_settings WHERE article_id = 1687
Speed: 0.419 ms
|
Speed: 0.303 ms
|
Speed: 0.296 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1143
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 1688
Speed: 0.402 ms
|
Speed: 0.336 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1145
Speed: 0.310 ms
|
SELECT * FROM article_settings WHERE article_id = 1689
Speed: 0.359 ms
|
Speed: 0.267 ms
|
Speed: 0.293 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1146
Speed: 0.206 ms
|
SELECT * FROM article_settings WHERE article_id = 1691
Speed: 0.326 ms
|
Speed: 0.249 ms
|
Speed: 0.277 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1144
Speed: 0.208 ms
|
SELECT * FROM article_settings WHERE article_id = 1692
Speed: 0.360 ms
|
Speed: 0.297 ms
|
Speed: 0.324 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1142
Speed: 0.225 ms
|
SELECT * FROM article_settings WHERE article_id = 1693
Speed: 0.334 ms
|
Speed: 0.273 ms
|
Speed: 0.303 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1140
Speed: 0.225 ms
|
SELECT * FROM article_settings WHERE article_id = 1694
Speed: 0.306 ms
|
Speed: 0.281 ms
|
Speed: 0.379 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1174
Speed: 0.252 ms
|
SELECT * FROM article_settings WHERE article_id = 1710
Speed: 0.401 ms
|
Speed: 0.320 ms
|
Speed: 0.729 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1139
Speed: 0.250 ms
|
SELECT * FROM article_settings WHERE article_id = 1695
Speed: 0.422 ms
|
Speed: 0.283 ms
|
Speed: 0.291 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1166
Speed: 0.208 ms
|
SELECT * FROM article_settings WHERE article_id = 1712
Speed: 0.317 ms
|
Speed: 0.251 ms
|
Speed: 0.295 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1167
Speed: 0.235 ms
|
SELECT * FROM article_settings WHERE article_id = 1713
Speed: 0.386 ms
|
Speed: 0.304 ms
|
Speed: 0.331 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1168
Speed: 0.229 ms
|
SELECT * FROM article_settings WHERE article_id = 1714
Speed: 0.349 ms
|
Speed: 0.332 ms
|
Speed: 0.345 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1169
Speed: 0.264 ms
|
SELECT * FROM article_settings WHERE article_id = 1715
Speed: 0.324 ms
|
Speed: 0.306 ms
|
Speed: 0.325 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1171
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 1717
Speed: 0.365 ms
|
Speed: 0.293 ms
|
Speed: 0.345 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1170
Speed: 0.255 ms
|
SELECT * FROM article_settings WHERE article_id = 1716
Speed: 0.327 ms
|
Speed: 0.280 ms
|
Speed: 0.326 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 1172
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 1718
Speed: 0.314 ms
|
Speed: 0.288 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2489
Speed: 0.240 ms
|
SELECT * FROM article_settings WHERE article_id = 4247
Speed: 0.331 ms
|
Speed: 0.258 ms
|
Speed: 0.288 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2490
Speed: 0.213 ms
|
SELECT * FROM article_settings WHERE article_id = 4248
Speed: 0.364 ms
|
Speed: 0.303 ms
|
Speed: 0.294 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2491
Speed: 0.217 ms
|
SELECT * FROM article_settings WHERE article_id = 4250
Speed: 0.320 ms
|
Speed: 0.287 ms
|
Speed: 0.275 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2509
Speed: 0.223 ms
|
SELECT * FROM article_settings WHERE article_id = 4251
Speed: 0.379 ms
|
Speed: 0.309 ms
|
Speed: 0.345 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2495
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 4255
Speed: 0.399 ms
|
Speed: 0.286 ms
|
Speed: 0.328 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2492
Speed: 0.250 ms
|
SELECT * FROM article_settings WHERE article_id = 4252
Speed: 0.348 ms
|
Speed: 0.285 ms
|
Speed: 0.329 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2494
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 4254
Speed: 0.371 ms
|
Speed: 0.282 ms
|
Speed: 0.341 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 2493
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 4253
Speed: 0.367 ms
|
Speed: 0.296 ms
|
Speed: 0.368 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4527
Speed: 0.268 ms
|
SELECT * FROM article_settings WHERE article_id = 9374
Speed: 0.401 ms
|
Speed: 0.284 ms
|
Speed: 0.363 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4526
Speed: 0.251 ms
|
SELECT * FROM article_settings WHERE article_id = 9371
Speed: 0.409 ms
|
Speed: 0.288 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4543
Speed: 0.254 ms
|
SELECT * FROM article_settings WHERE article_id = 9399
Speed: 0.376 ms
|
Speed: 0.299 ms
|
Speed: 0.349 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4570
Speed: 0.273 ms
|
SELECT * FROM article_settings WHERE article_id = 9458
Speed: 0.396 ms
|
Speed: 0.302 ms
|
Speed: 0.341 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4573
Speed: 0.252 ms
|
SELECT * FROM article_settings WHERE article_id = 9466
Speed: 0.380 ms
|
Speed: 0.288 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4004
Speed: 0.263 ms
|
SELECT * FROM article_settings WHERE article_id = 2903
Speed: 0.408 ms
|
Speed: 0.291 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4006
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 5685
Speed: 0.409 ms
|
Speed: 0.295 ms
|
Speed: 0.358 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4007
Speed: 0.249 ms
|
SELECT * FROM article_settings WHERE article_id = 6646
Speed: 0.431 ms
|
Speed: 0.336 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 943
Speed: 0.369 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4022
Speed: 0.258 ms
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 0.388 ms
|
Speed: 0.316 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4511
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 6267
Speed: 0.413 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 867
Speed: 1.992 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4020
Speed: 0.255 ms
|
SELECT * FROM article_settings WHERE article_id = 6859
Speed: 0.388 ms
|
Speed: 0.294 ms
|
Speed: 7.208 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4021
Speed: 0.290 ms
|
SELECT * FROM article_settings WHERE article_id = 7325
Speed: 0.436 ms
|
Speed: 0.337 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4637
Speed: 0.299 ms
|
SELECT * FROM article_settings WHERE article_id = 9552
Speed: 0.470 ms
|
Speed: 0.301 ms
|
Speed: 0.327 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4636
Speed: 0.238 ms
|
SELECT * FROM article_settings WHERE article_id = 9551
Speed: 0.380 ms
|
Speed: 0.328 ms
|
Speed: 0.400 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4635
Speed: 0.237 ms
|
SELECT * FROM article_settings WHERE article_id = 9547
Speed: 0.364 ms
|
Speed: 0.292 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4638
Speed: 0.254 ms
|
SELECT * FROM article_settings WHERE article_id = 9554
Speed: 0.331 ms
|
Speed: 0.299 ms
|
Speed: 0.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4639
Speed: 0.253 ms
|
SELECT * FROM article_settings WHERE article_id = 9556
Speed: 0.409 ms
|
Speed: 0.318 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4640
Speed: 0.253 ms
|
SELECT * FROM article_settings WHERE article_id = 9565
Speed: 0.377 ms
|
Speed: 0.269 ms
|
Speed: 0.362 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4641
Speed: 0.230 ms
|
SELECT * FROM article_settings WHERE article_id = 9566
Speed: 0.413 ms
|
Speed: 0.296 ms
|
Speed: 0.876 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4660
Speed: 0.243 ms
|
SELECT * FROM article_settings WHERE article_id = 9567
Speed: 0.348 ms
|
Speed: 0.296 ms
|
Speed: 0.301 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4643
Speed: 0.559 ms
|
SELECT * FROM article_settings WHERE article_id = 9568
Speed: 0.370 ms
|
Speed: 0.383 ms
|
Speed: 0.385 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4644
Speed: 0.264 ms
|
SELECT * FROM article_settings WHERE article_id = 9570
Speed: 0.370 ms
|
Speed: 0.323 ms
|
Speed: 0.393 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4524
Speed: 0.264 ms
|
SELECT * FROM article_settings WHERE article_id = 9353
Speed: 0.381 ms
|
Speed: 0.301 ms
|
Speed: 0.384 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4523
Speed: 0.265 ms
|
SELECT * FROM article_settings WHERE article_id = 9347
Speed: 0.381 ms
|
Speed: 0.304 ms
|
Speed: 0.373 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4520
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 9331
Speed: 0.382 ms
|
Speed: 0.304 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4519
Speed: 0.274 ms
|
SELECT * FROM article_settings WHERE article_id = 9330
Speed: 0.409 ms
|
Speed: 0.352 ms
|
Speed: 0.422 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4525
Speed: 0.262 ms
|
SELECT * FROM article_settings WHERE article_id = 9354
Speed: 0.388 ms
|
Speed: 0.296 ms
|
Speed: 0.394 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4996
Speed: 0.303 ms
|
SELECT * FROM article_settings WHERE article_id = 9048
Speed: 0.423 ms
|
Speed: 0.287 ms
|
Speed: 0.356 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4995
Speed: 0.270 ms
|
SELECT * FROM article_settings WHERE article_id = 9054
Speed: 0.384 ms
|
Speed: 0.289 ms
|
Speed: 0.351 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4997
Speed: 0.272 ms
|
SELECT * FROM article_settings WHERE article_id = 9038
Speed: 0.417 ms
|
Speed: 0.313 ms
|
Speed: 0.333 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4998
Speed: 0.321 ms
|
SELECT * FROM article_settings WHERE article_id = 9060
Speed: 0.410 ms
|
Speed: 0.284 ms
|
Speed: 0.312 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5001
Speed: 0.479 ms
|
SELECT * FROM article_settings WHERE article_id = 9711
Speed: 0.435 ms
|
Speed: 0.260 ms
|
Speed: 0.387 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5000
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 10464
Speed: 0.390 ms
|
Speed: 0.277 ms
|
Speed: 0.316 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5606
Speed: 0.269 ms
|
SELECT * FROM article_settings WHERE article_id = 11669
Speed: 0.409 ms
|
Speed: 0.284 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5609
Speed: 0.270 ms
|
SELECT * FROM article_settings WHERE article_id = 12719
Speed: 0.362 ms
|
Speed: 0.299 ms
|
Speed: 0.339 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5611
Speed: 0.230 ms
|
SELECT * FROM article_settings WHERE article_id = 11873
Speed: 0.377 ms
|
Speed: 0.291 ms
|
Speed: 0.396 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5607
Speed: 0.256 ms
|
SELECT * FROM article_settings WHERE article_id = 11905
Speed: 0.424 ms
|
Speed: 0.307 ms
|
Speed: 0.314 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 5608
Speed: 0.244 ms
|
SELECT * FROM article_settings WHERE article_id = 12236
Speed: 0.405 ms
|
Speed: 0.404 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2239
Speed: 0.396 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 2240
Speed: 0.376 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6467
Speed: 0.276 ms
|
SELECT * FROM article_settings WHERE article_id = 12890
Speed: 0.437 ms
|
Speed: 0.293 ms
|
Speed: 0.343 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6469
Speed: 0.260 ms
|
SELECT * FROM article_settings WHERE article_id = 14072
Speed: 0.372 ms
|
Speed: 0.300 ms
|
Speed: 0.299 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6470
Speed: 0.250 ms
|
SELECT * FROM article_settings WHERE article_id = 12796
Speed: 0.349 ms
|
Speed: 0.249 ms
|
Speed: 0.315 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6472
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 13394
Speed: 0.389 ms
|
Speed: 0.294 ms
|
Speed: 0.350 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6471
Speed: 0.273 ms
|
SELECT * FROM article_settings WHERE article_id = 13962
Speed: 0.392 ms
|
Speed: 0.297 ms
|
Speed: 0.350 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6473
Speed: 0.267 ms
|
SELECT * FROM article_settings WHERE article_id = 15077
Speed: 0.432 ms
|
Speed: 0.303 ms
|
Speed: 0.337 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6468
Speed: 0.276 ms
|
SELECT * FROM article_settings WHERE article_id = 14028
Speed: 0.423 ms
|
Speed: 0.309 ms
|
Speed: 0.348 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6476
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 15841
Speed: 0.369 ms
|
Speed: 0.312 ms
|
Speed: 0.365 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7304
Speed: 0.316 ms
|
SELECT * FROM article_settings WHERE article_id = 12095
Speed: 0.459 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3351
Speed: 0.370 ms
|
Speed: 0.367 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7305
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 17549
Speed: 0.437 ms
|
Speed: 0.304 ms
|
Speed: 0.332 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7309
Speed: 0.284 ms
|
SELECT * FROM article_settings WHERE article_id = 17332
Speed: 0.424 ms
|
Speed: 0.303 ms
|
Speed: 0.330 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7308
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 16275
Speed: 0.455 ms
|
Speed: 0.366 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3018
Speed: 0.417 ms
|
Speed: 0.377 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7315
Speed: 0.299 ms
|
SELECT * FROM article_settings WHERE article_id = 16277
Speed: 0.464 ms
|
Speed: 0.300 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7307
Speed: 0.284 ms
|
SELECT * FROM article_settings WHERE article_id = 17579
Speed: 0.415 ms
|
Speed: 0.303 ms
|
Speed: 0.337 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7312
Speed: 0.341 ms
|
SELECT * FROM article_settings WHERE article_id = 13134
Speed: 0.383 ms
|
Speed: 0.304 ms
|
Speed: 0.345 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7311
Speed: 0.300 ms
|
SELECT * FROM article_settings WHERE article_id = 16819
Speed: 0.390 ms
|
Speed: 0.314 ms
|
Speed: 0.349 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7310
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 17910
Speed: 0.424 ms
|
Speed: 0.320 ms
|
Speed: 0.363 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7989
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 16234
Speed: 0.539 ms
|
Speed: 0.316 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3006
Speed: 0.352 ms
|
Speed: 0.387 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7982
Speed: 0.320 ms
|
SELECT * FROM article_settings WHERE article_id = 18392
Speed: 0.414 ms
|
Speed: 0.287 ms
|
Speed: 0.349 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7981
Speed: 0.263 ms
|
SELECT * FROM article_settings WHERE article_id = 17753
Speed: 0.452 ms
|
Speed: 0.291 ms
|
Speed: 0.347 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7983
Speed: 0.251 ms
|
SELECT * FROM article_settings WHERE article_id = 20180
Speed: 0.374 ms
|
Speed: 0.315 ms
|
Speed: 0.330 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7984
Speed: 0.248 ms
|
SELECT * FROM article_settings WHERE article_id = 20969
Speed: 0.365 ms
|
Speed: 0.273 ms
|
Speed: 0.303 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7986
Speed: 0.273 ms
|
SELECT * FROM article_settings WHERE article_id = 21274
Speed: 0.402 ms
|
Speed: 0.351 ms
|
Speed: 0.397 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7985
Speed: 0.242 ms
|
SELECT * FROM article_settings WHERE article_id = 20994
Speed: 0.394 ms
|
Speed: 0.296 ms
|
Speed: 0.327 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7987
Speed: 0.246 ms
|
SELECT * FROM article_settings WHERE article_id = 21490
Speed: 0.414 ms
|
Speed: 0.291 ms
|
Speed: 0.310 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 7988
Speed: 0.271 ms
|
SELECT * FROM article_settings WHERE article_id = 21314
Speed: 0.449 ms
|
Speed: 0.354 ms
|
Speed: 0.382 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9236
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 25544
Speed: 0.411 ms
|
Speed: 0.330 ms
|
Speed: 0.350 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9237
Speed: 0.279 ms
|
SELECT * FROM article_settings WHERE article_id = 22401
Speed: 0.401 ms
|
Speed: 0.281 ms
|
Speed: 0.341 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9240
Speed: 0.262 ms
|
SELECT * FROM article_settings WHERE article_id = 22739
Speed: 0.377 ms
|
Speed: 0.344 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 4364
Speed: 0.295 ms
|
Speed: 0.360 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9239
Speed: 0.261 ms
|
SELECT * FROM article_settings WHERE article_id = 23004
Speed: 0.392 ms
|
Speed: 0.315 ms
|
Speed: 0.337 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9238
Speed: 0.268 ms
|
SELECT * FROM article_settings WHERE article_id = 26627
Speed: 0.389 ms
|
Speed: 0.345 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9243
Speed: 0.283 ms
|
SELECT * FROM article_settings WHERE article_id = 25554
Speed: 0.390 ms
|
Speed: 0.306 ms
|
Speed: 0.354 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9242
Speed: 0.289 ms
|
SELECT * FROM article_settings WHERE article_id = 22809
Speed: 0.401 ms
|
Speed: 0.292 ms
|
Speed: 0.344 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9241
Speed: 0.277 ms
|
SELECT * FROM article_settings WHERE article_id = 22257
Speed: 0.481 ms
|
Speed: 0.287 ms
|
Speed: 0.376 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9838
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 11262
Speed: 0.437 ms
|
Speed: 0.307 ms
|
Speed: 0.369 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 9756
Speed: 0.311 ms
|
SELECT * FROM article_settings WHERE article_id = 20556
Speed: 0.460 ms
|
Speed: 0.299 ms
|
Speed: 0.291 ms
|
SELECT * FROM article_settings WHERE article_id = 11544
Speed: 0.428 ms
|
Speed: 0.299 ms
|
Speed: 0.308 ms
|
SELECT * FROM article_settings WHERE article_id = 23745
Speed: 0.437 ms
|
Speed: 0.294 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11059
Speed: 0.280 ms
|
SELECT * FROM article_settings WHERE article_id = 17417
Speed: 0.434 ms
|
Speed: 0.416 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 3245
Speed: 0.399 ms
|
Speed: 0.302 ms
|
SELECT * FROM article_settings WHERE article_id = 30382
Speed: 0.409 ms
|
Speed: 0.289 ms
|
Speed: 0.378 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 10015
Speed: 0.293 ms
|
SELECT * FROM article_settings WHERE article_id = 30889
Speed: 0.468 ms
|
Speed: 0.317 ms
|
Speed: 0.361 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11090
Speed: 0.313 ms
|
SELECT * FROM article_settings WHERE article_id = 19065
Speed: 0.450 ms
|
Speed: 0.292 ms
|
Speed: 0.331 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11091
Speed: 0.281 ms
|
SELECT * FROM article_settings WHERE article_id = 26470
Speed: 0.452 ms
|
Speed: 0.296 ms
|
Speed: 0.370 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11092
Speed: 0.295 ms
|
SELECT * FROM article_settings WHERE article_id = 34650
Speed: 0.451 ms
|
Speed: 0.309 ms
|
Speed: 0.393 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11116
Speed: 0.305 ms
|
SELECT * FROM article_settings WHERE article_id = 31167
Speed: 0.429 ms
|
Speed: 0.311 ms
|
Speed: 0.389 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11093
Speed: 0.290 ms
|
SELECT * FROM article_settings WHERE article_id = 33298
Speed: 0.487 ms
|
Speed: 0.303 ms
|
Speed: 0.355 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 11094
Speed: 0.273 ms
|
SELECT * FROM article_settings WHERE article_id = 28115
Speed: 0.444 ms
|
Speed: 0.310 ms
|
Speed: 0.364 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12053
Speed: 0.336 ms
|
SELECT * FROM article_settings WHERE article_id = 39714
Speed: 0.496 ms
|
Speed: 0.293 ms
|
Speed: 0.348 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 12069
Speed: 0.288 ms
|
SELECT * FROM article_settings WHERE article_id = 19866
Speed: 0.453 ms
|
Speed: 0.288 ms
|
Speed: 0.446 ms
|
SELECT * FROM issue_settings WHERE issue_id = 1511
Speed: 0.380 ms
|
Speed: 0.356 ms
|
SELECT * FROM author_settings WHERE author_id = 9259
Speed: 0.318 ms
|
Speed: 0.385 ms
|
SELECT * FROM author_settings WHERE author_id = 9259
Speed: 0.322 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103588
Speed: 2.838 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103588
Speed: 0.287 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103589
Speed: 0.278 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103589
Speed: 0.243 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103590
Speed: 2.743 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103590
Speed: 0.248 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103591
Speed: 0.278 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103591
Speed: 0.234 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103592
Speed: 0.258 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103592
Speed: 0.231 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103593
Speed: 0.259 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103593
Speed: 0.243 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103594
Speed: 0.269 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103594
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103595
Speed: 0.261 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103595
Speed: 0.221 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103596
Speed: 0.251 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103596
Speed: 0.260 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103597
Speed: 0.276 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103597
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103598
Speed: 0.250 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103598
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103599
Speed: 8.840 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103599
Speed: 0.278 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103600
Speed: 0.273 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103600
Speed: 0.244 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103601
Speed: 0.268 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103601
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103602
Speed: 0.264 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103602
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103603
Speed: 0.255 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103603
Speed: 0.235 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103604
Speed: 0.254 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103604
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103605
Speed: 2.752 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103605
Speed: 0.244 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103606
Speed: 0.256 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103606
Speed: 0.307 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103607
Speed: 0.306 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103607
Speed: 0.239 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103608
Speed: 0.506 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103608
Speed: 0.235 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103609
Speed: 0.253 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103609
Speed: 0.250 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103610
Speed: 0.277 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103610
Speed: 0.218 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103611
Speed: 0.270 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103611
Speed: 0.238 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103612
Speed: 0.253 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103612
Speed: 0.238 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103613
Speed: 0.298 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103613
Speed: 0.240 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103614
Speed: 0.255 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103614
Speed: 0.231 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103615
Speed: 0.255 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103615
Speed: 0.245 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103616
Speed: 0.285 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103616
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103617
Speed: 0.270 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103617
Speed: 0.322 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103618
Speed: 0.285 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103618
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103619
Speed: 0.259 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103619
Speed: 0.243 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103620
Speed: 0.273 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103620
Speed: 0.253 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103621
Speed: 0.559 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103621
Speed: 0.302 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103622
Speed: 0.271 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103622
Speed: 0.238 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103623
Speed: 0.311 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103623
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103624
Speed: 0.253 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103624
Speed: 0.246 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103625
Speed: 0.309 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103625
Speed: 0.221 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103626
Speed: 0.251 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103626
Speed: 0.220 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103627
Speed: 0.300 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103627
Speed: 0.270 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103628
Speed: 0.253 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103628
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103629
Speed: 0.287 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103629
Speed: 0.267 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103630
Speed: 0.282 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103630
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103631
Speed: 0.250 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103631
Speed: 0.221 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103632
Speed: 0.254 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103632
Speed: 0.218 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103633
Speed: 0.315 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103633
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103634
Speed: 0.267 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103634
Speed: 0.225 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103635
Speed: 0.259 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103635
Speed: 0.217 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103636
Speed: 0.262 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103636
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103637
Speed: 0.254 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103637
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103638
Speed: 0.261 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103638
Speed: 0.218 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103639
Speed: 0.304 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103639
Speed: 0.246 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103640
Speed: 0.284 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103640
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103641
Speed: 0.274 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103641
Speed: 0.250 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103642
Speed: 0.290 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103642
Speed: 0.229 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103643
Speed: 0.252 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103643
Speed: 0.284 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103644
Speed: 0.271 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103644
Speed: 0.238 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103645
Speed: 0.229 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103645
Speed: 0.219 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103646
Speed: 0.223 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103646
Speed: 0.270 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103647
Speed: 0.259 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103647
Speed: 0.268 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103648
Speed: 0.292 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103648
Speed: 0.239 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103649
Speed: 0.263 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103649
Speed: 0.222 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103650
Speed: 0.394 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103650
Speed: 0.243 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103651
Speed: 0.271 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103651
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103652
Speed: 0.258 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103652
Speed: 0.248 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103653
Speed: 0.279 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103653
Speed: 0.255 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103654
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103654
Speed: 0.229 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103655
Speed: 0.267 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103655
Speed: 0.242 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103656
Speed: 0.278 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103656
Speed: 0.251 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103657
Speed: 0.281 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103657
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103658
Speed: 0.262 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103658
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103659
Speed: 0.338 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103659
Speed: 0.271 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103660
Speed: 0.330 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103660
Speed: 0.281 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103661
Speed: 0.310 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103661
Speed: 0.271 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103662
Speed: 0.262 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103662
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103663
Speed: 0.263 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103663
Speed: 0.237 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103664
Speed: 0.260 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103664
Speed: 0.229 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103665
Speed: 0.255 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103665
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103666
Speed: 0.261 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103666
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103667
Speed: 0.259 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103667
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103668
Speed: 0.265 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103668
Speed: 0.220 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103669
Speed: 0.258 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103669
Speed: 0.226 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103670
Speed: 0.267 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103670
Speed: 0.232 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103671
Speed: 0.272 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103671
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103672
Speed: 0.257 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103672
Speed: 0.224 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103673
Speed: 0.255 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103673
Speed: 0.246 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103674
Speed: 0.263 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103674
Speed: 0.267 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103675
Speed: 0.260 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103675
Speed: 0.259 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103676
Speed: 0.277 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103676
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103677
Speed: 0.279 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103677
Speed: 0.225 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103678
Speed: 0.252 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103678
Speed: 0.235 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103679
Speed: 0.293 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103679
Speed: 0.230 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103680
Speed: 0.261 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103680
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103681
Speed: 0.283 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103681
Speed: 0.242 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103682
Speed: 0.274 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103682
Speed: 0.225 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103683
Speed: 0.268 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103683
Speed: 0.229 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103684
Speed: 0.308 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103684
Speed: 0.262 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103685
Speed: 0.277 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103685
Speed: 0.252 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103686
Speed: 0.269 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103686
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103687
Speed: 0.266 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103687
Speed: 0.228 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103688
Speed: 0.282 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103688
Speed: 0.240 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103689
Speed: 0.257 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103689
Speed: 0.225 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103690
Speed: 0.281 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103690
Speed: 0.227 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103691
Speed: 2.378 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103691
Speed: 0.256 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103692
Speed: 0.299 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103692
Speed: 0.268 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103693
Speed: 0.279 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103693
Speed: 0.223 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103694
Speed: 0.312 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103694
Speed: 0.266 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103695
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103695
Speed: 0.238 ms
|
SELECT * FROM citation_settings WHERE citation_id = 103696
Speed: 0.256 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 103696
Speed: 0.262 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 = 6329
Speed: 2.732 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 = 6329
Speed: 0.514 ms
|
Speed: 0.390 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4022
Speed: 0.238 ms
|
SELECT * FROM article_settings WHERE article_id = 6329
Speed: 0.404 ms
|
Speed: 0.415 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 6329 AND
r.status = 2
Speed: 1.220 ms
|