SELECT * FROM sessions WHERE session_id = 6dba6f302f0137f6679caf3b5ca5a10a
Speed: 2.848 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(6dba6f302f0137f6679caf3b5ca5a10a, 98.81.24.230, CCBot/2.0 (https://commoncrawl.org/faq/), 1726877013, 1726877013, 0, , jurnal.uisu.ac.id
Speed: 0.654 ms
|
SELECT * FROM journals WHERE path = jh
Speed: 2.564 ms
|
Speed: 0.384 ms
|
Speed: 16.277 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.445 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.303 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.317 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.293 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.325 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.330 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.352 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 1.274 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.781 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 = 9229
Speed: 1.694 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 = 9229
Speed: 0.862 ms
|
Speed: 3.638 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6374
Speed: 0.493 ms
|
SELECT * FROM article_settings WHERE article_id = 9229
Speed: 0.549 ms
|
Speed: 3.967 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 = 517
Speed: 55.337 ms
|
Speed: 1.890 ms
|
SELECT * FROM issue_settings WHERE issue_id = 517
Speed: 0.542 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-98-81-24-230.compute-1.amazonaws.com, LENGTH(ec2-98-81-24-230.compute-1.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 9.021 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 1649481958 >= isip.ip_start AND 1649481958 <= 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-09-21 07:03:34' >= s.date_start AND '2024-09-21 07:03:34' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 1649481958 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 1.364 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 0.601 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.870 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 2.713 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.411 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 = 9229
Speed: 1.335 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 = 9229
Speed: 1.382 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 = 9229
Speed: 0.745 ms
|
Speed: 41.846 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6374
Speed: 0.476 ms
|
SELECT * FROM article_settings WHERE article_id = 9229
Speed: 0.676 ms
|
Speed: 6.738 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-98-81-24-230.compute-1.amazonaws.com, LENGTH(ec2-98-81-24-230.compute-1.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.602 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 1649481958 >= isip.ip_start AND 1649481958 <= 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-09-21 07:03:34' >= s.date_start AND '2024-09-21 07:03:34' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 1649481958 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 44
Speed: 0.511 ms
|
SELECT *
FROM citations
WHERE assoc_type = 257 AND assoc_id = 9229 AND citation_state >= 0 AND citation_state <= 5
Speed: 42.767 ms
|
SELECT * FROM sections WHERE section_id = 46
Speed: 2.242 ms
|
SELECT * FROM section_settings WHERE section_id = 46
Speed: 0.565 ms
|
Speed: 8.550 ms
|
SELECT * FROM issue_settings WHERE issue_id = 558
Speed: 0.702 ms
|
Speed: 19.710 ms
|
Speed: 56.844 ms
|
SELECT * FROM author_settings WHERE author_id = 17544
Speed: 0.910 ms
|
SELECT * FROM author_settings WHERE author_id = 17545
Speed: 0.450 ms
|
SELECT * FROM author_settings WHERE author_id = 17546
Speed: 0.423 ms
|
Speed: 7.246 ms
|
SELECT * FROM author_settings WHERE author_id = 17544
Speed: 0.755 ms
|
SELECT * FROM author_settings WHERE author_id = 17545
Speed: 0.493 ms
|
SELECT * FROM author_settings WHERE author_id = 17546
Speed: 0.488 ms
|
Speed: 0.665 ms
|
SELECT * FROM author_settings WHERE author_id = 17544
Speed: 4.074 ms
|
SELECT * FROM author_settings WHERE author_id = 17545
Speed: 0.533 ms
|
SELECT * FROM author_settings WHERE author_id = 17546
Speed: 2.115 ms
|
Speed: 2.835 ms
|
SELECT * FROM author_settings WHERE author_id = 17544
Speed: 0.462 ms
|
SELECT * FROM author_settings WHERE author_id = 17545
Speed: 0.429 ms
|
SELECT * FROM author_settings WHERE author_id = 17546
Speed: 0.989 ms
|
Speed: 0.980 ms
|
SELECT * FROM author_settings WHERE author_id = 17544
Speed: 0.563 ms
|
SELECT * FROM author_settings WHERE author_id = 17545
Speed: 0.428 ms
|
SELECT * FROM author_settings WHERE author_id = 17546
Speed: 0.474 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134614
Speed: 0.451 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134614
Speed: 0.407 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134615
Speed: 0.308 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134615
Speed: 0.307 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134616
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134616
Speed: 0.317 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134617
Speed: 0.969 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134617
Speed: 0.288 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134618
Speed: 48.643 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134618
Speed: 0.577 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134619
Speed: 1.361 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134619
Speed: 0.360 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134620
Speed: 2.802 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134620
Speed: 0.354 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134621
Speed: 0.334 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134621
Speed: 0.344 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134622
Speed: 0.358 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134622
Speed: 0.356 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134623
Speed: 0.316 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134623
Speed: 0.309 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134624
Speed: 1.119 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134624
Speed: 0.343 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134625
Speed: 2.380 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134625
Speed: 0.310 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134626
Speed: 2.471 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134626
Speed: 0.300 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134627
Speed: 0.303 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134627
Speed: 0.279 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134628
Speed: 0.705 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134628
Speed: 0.352 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134629
Speed: 0.440 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134629
Speed: 0.380 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134630
Speed: 0.357 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134630
Speed: 0.398 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134631
Speed: 0.391 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134631
Speed: 0.379 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134632
Speed: 0.371 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134632
Speed: 1.361 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134633
Speed: 0.336 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134633
Speed: 0.356 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134634
Speed: 0.330 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134634
Speed: 0.383 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134635
Speed: 0.569 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134635
Speed: 0.540 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134636
Speed: 2.911 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134636
Speed: 0.365 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134637
Speed: 1.021 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134637
Speed: 0.383 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134638
Speed: 1.752 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134638
Speed: 0.374 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134639
Speed: 2.038 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134639
Speed: 0.399 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134640
Speed: 2.672 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134640
Speed: 0.401 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134641
Speed: 0.372 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134641
Speed: 0.339 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134642
Speed: 2.349 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134642
Speed: 0.354 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134643
Speed: 0.354 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134643
Speed: 0.322 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134644
Speed: 0.408 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134644
Speed: 0.308 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134645
Speed: 0.314 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134645
Speed: 0.300 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134646
Speed: 1.090 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134646
Speed: 0.342 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134647
Speed: 2.373 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134647
Speed: 0.304 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134648
Speed: 0.366 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134648
Speed: 0.279 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134649
Speed: 0.324 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134649
Speed: 0.358 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134650
Speed: 0.369 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134650
Speed: 0.350 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134651
Speed: 45.845 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134651
Speed: 1.500 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134652
Speed: 3.497 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134652
Speed: 0.422 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134653
Speed: 0.973 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134653
Speed: 1.409 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134654
Speed: 7.852 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134654
Speed: 0.447 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134655
Speed: 1.509 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134655
Speed: 4.212 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134656
Speed: 2.581 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134656
Speed: 1.875 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134657
Speed: 3.975 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134657
Speed: 2.905 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134658
Speed: 2.708 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134658
Speed: 0.941 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134659
Speed: 3.983 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134659
Speed: 1.677 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134660
Speed: 50.751 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134660
Speed: 0.543 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134661
Speed: 9.514 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134661
Speed: 0.332 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134662
Speed: 12.133 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134662
Speed: 0.521 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134663
Speed: 0.433 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134663
Speed: 0.314 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134664
Speed: 3.762 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134664
Speed: 3.897 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134665
Speed: 3.562 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134665
Speed: 0.403 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134666
Speed: 42.183 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134666
Speed: 7.815 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134667
Speed: 0.499 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134667
Speed: 1.830 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134668
Speed: 3.689 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134668
Speed: 2.859 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134669
Speed: 3.660 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134669
Speed: 1.855 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134670
Speed: 2.718 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134670
Speed: 1.851 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134671
Speed: 3.693 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134671
Speed: 1.888 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134672
Speed: 3.667 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134672
Speed: 1.855 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134673
Speed: 47.764 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134673
Speed: 2.727 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134674
Speed: 3.508 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134674
Speed: 3.868 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134675
Speed: 3.555 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134675
Speed: 2.744 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134676
Speed: 3.533 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134676
Speed: 1.854 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134677
Speed: 3.656 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134677
Speed: 1.876 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134678
Speed: 3.565 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134678
Speed: 2.840 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134679
Speed: 0.521 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134679
Speed: 3.802 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134680
Speed: 50.643 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134680
Speed: 3.709 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134681
Speed: 1.440 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134681
Speed: 0.403 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134682
Speed: 7.073 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134682
Speed: 0.447 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134683
Speed: 0.398 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134683
Speed: 0.378 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134684
Speed: 0.479 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134684
Speed: 0.318 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134685
Speed: 0.294 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134685
Speed: 0.397 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134686
Speed: 0.314 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134686
Speed: 0.376 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134687
Speed: 0.358 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134687
Speed: 0.318 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134688
Speed: 0.435 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134688
Speed: 0.361 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134689
Speed: 0.318 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134689
Speed: 0.311 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134690
Speed: 0.298 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134690
Speed: 0.294 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134691
Speed: 0.352 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134691
Speed: 0.275 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134692
Speed: 0.292 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134692
Speed: 0.276 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134693
Speed: 6.904 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134693
Speed: 0.552 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134694
Speed: 0.564 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134694
Speed: 0.419 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134695
Speed: 0.417 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134695
Speed: 0.326 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134696
Speed: 0.243 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134696
Speed: 0.270 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134697
Speed: 5.686 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134697
Speed: 0.479 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134698
Speed: 0.361 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134698
Speed: 0.313 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134699
Speed: 0.285 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134699
Speed: 0.288 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134700
Speed: 0.332 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134700
Speed: 0.267 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134701
Speed: 5.581 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134701
Speed: 0.350 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134702
Speed: 0.327 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134702
Speed: 0.331 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134703
Speed: 0.290 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134703
Speed: 0.308 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134704
Speed: 0.290 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134704
Speed: 0.276 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134705
Speed: 4.907 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134705
Speed: 0.360 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134706
Speed: 0.326 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134706
Speed: 0.290 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134707
Speed: 0.286 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134707
Speed: 0.317 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134708
Speed: 0.277 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134708
Speed: 0.290 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134709
Speed: 5.139 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134709
Speed: 0.366 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134710
Speed: 0.352 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134710
Speed: 0.286 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134711
Speed: 0.330 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134711
Speed: 0.271 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134712
Speed: 0.328 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134712
Speed: 0.296 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134713
Speed: 49.106 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134713
Speed: 0.578 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134714
Speed: 0.419 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134714
Speed: 0.438 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134715
Speed: 2.196 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134715
Speed: 0.316 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134716
Speed: 0.349 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134716
Speed: 1.920 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134717
Speed: 0.635 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134717
Speed: 0.375 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134718
Speed: 2.297 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134718
Speed: 0.457 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134719
Speed: 0.368 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134719
Speed: 1.605 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134720
Speed: 0.483 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134720
Speed: 1.999 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134721
Speed: 0.679 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134721
Speed: 0.389 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134722
Speed: 0.557 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134722
Speed: 2.176 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134723
Speed: 3.608 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134723
Speed: 1.786 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134724
Speed: 2.444 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134724
Speed: 1.827 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134725
Speed: 47.515 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134725
Speed: 0.629 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134726
Speed: 4.784 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134726
Speed: 0.545 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134727
Speed: 0.401 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134727
Speed: 0.402 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134728
Speed: 0.715 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134728
Speed: 0.375 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134729
Speed: 0.547 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134729
Speed: 0.415 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134730
Speed: 4.663 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134730
Speed: 0.456 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134731
Speed: 0.366 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134731
Speed: 0.395 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134732
Speed: 1.120 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134732
Speed: 0.382 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134733
Speed: 8.057 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134733
Speed: 0.439 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134734
Speed: 0.688 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134734
Speed: 0.413 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134735
Speed: 9.154 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134735
Speed: 0.415 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134736
Speed: 2.341 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134736
Speed: 0.670 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134737
Speed: 6.643 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134737
Speed: 3.854 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134738
Speed: 3.739 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134738
Speed: 0.392 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134739
Speed: 7.308 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134739
Speed: 0.341 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134740
Speed: 4.185 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134740
Speed: 0.337 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134741
Speed: 49.429 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134741
Speed: 0.765 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134742
Speed: 6.575 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134742
Speed: 2.854 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134743
Speed: 19.149 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134743
Speed: 0.390 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134744
Speed: 0.475 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134744
Speed: 0.344 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134745
Speed: 7.799 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134745
Speed: 3.784 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134746
Speed: 43.750 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134746
Speed: 0.612 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134747
Speed: 9.937 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134747
Speed: 0.496 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134748
Speed: 5.906 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134748
Speed: 0.476 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134749
Speed: 7.810 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134749
Speed: 0.636 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134750
Speed: 9.625 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134750
Speed: 0.510 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134751
Speed: 9.724 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134751
Speed: 5.954 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134752
Speed: 0.385 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134752
Speed: 4.414 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134753
Speed: 4.863 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134753
Speed: 0.462 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134754
Speed: 2.733 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134754
Speed: 0.528 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134755
Speed: 8.652 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134755
Speed: 0.496 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134756
Speed: 43.051 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134756
Speed: 7.594 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134757
Speed: 2.407 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134757
Speed: 0.817 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134758
Speed: 0.740 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134758
Speed: 1.852 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134759
Speed: 4.757 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134759
Speed: 1.806 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134760
Speed: 2.498 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134760
Speed: 1.825 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134761
Speed: 2.780 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134761
Speed: 1.808 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134762
Speed: 0.641 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134762
Speed: 3.887 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134763
Speed: 0.678 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134763
Speed: 2.876 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134764
Speed: 2.560 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134764
Speed: 1.793 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134765
Speed: 0.577 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134765
Speed: 2.865 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134766
Speed: 2.704 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134766
Speed: 1.813 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134767
Speed: 0.687 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134767
Speed: 1.836 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134768
Speed: 0.678 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134768
Speed: 1.886 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134769
Speed: 2.731 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134769
Speed: 1.861 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134770
Speed: 0.726 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134770
Speed: 4.862 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134771
Speed: 0.638 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134771
Speed: 2.865 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134772
Speed: 2.596 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134772
Speed: 1.856 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134773
Speed: 0.708 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134773
Speed: 3.894 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134774
Speed: 9.298 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134774
Speed: 0.632 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134775
Speed: 2.678 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134775
Speed: 5.855 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134776
Speed: 3.687 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134776
Speed: 2.726 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134777
Speed: 9.633 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134777
Speed: 2.765 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134778
Speed: 55.478 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134778
Speed: 4.693 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134779
Speed: 6.470 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134779
Speed: 4.731 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134780
Speed: 12.158 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134780
Speed: 0.517 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134781
Speed: 1.149 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134781
Speed: 2.774 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134782
Speed: 3.510 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134782
Speed: 0.726 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134783
Speed: 5.608 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134783
Speed: 1.797 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134784
Speed: 7.046 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134784
Speed: 36.970 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134785
Speed: 3.421 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134785
Speed: 3.793 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134786
Speed: 7.023 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134786
Speed: 2.486 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134787
Speed: 0.808 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134787
Speed: 2.699 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134788
Speed: 4.740 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134788
Speed: 3.799 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134789
Speed: 3.709 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134789
Speed: 2.788 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134790
Speed: 1.068 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134790
Speed: 1.680 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134791
Speed: 3.430 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134791
Speed: 48.038 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134792
Speed: 3.482 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134792
Speed: 3.773 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134793
Speed: 5.224 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134793
Speed: 4.213 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134794
Speed: 10.434 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134794
Speed: 2.793 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134795
Speed: 2.653 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134795
Speed: 2.783 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134796
Speed: 4.654 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134796
Speed: 2.817 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134797
Speed: 55.623 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134797
Speed: 8.867 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134798
Speed: 3.710 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134798
Speed: 6.323 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134799
Speed: 6.574 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134799
Speed: 2.876 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134800
Speed: 4.614 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134800
Speed: 2.830 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134801
Speed: 4.554 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134801
Speed: 1.811 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134802
Speed: 5.351 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134802
Speed: 0.438 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134803
Speed: 28.977 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134803
Speed: 3.723 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134804
Speed: 5.231 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134804
Speed: 0.564 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134805
Speed: 2.800 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134805
Speed: 0.340 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134806
Speed: 3.939 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134806
Speed: 0.363 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134807
Speed: 1.207 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134807
Speed: 1.478 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134808
Speed: 0.405 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134808
Speed: 0.352 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134809
Speed: 4.637 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134809
Speed: 0.453 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134810
Speed: 2.279 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134810
Speed: 0.388 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134811
Speed: 1.615 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134811
Speed: 0.435 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134812
Speed: 1.871 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134812
Speed: 0.746 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134813
Speed: 5.702 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134813
Speed: 0.468 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134814
Speed: 0.476 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134814
Speed: 3.030 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134815
Speed: 2.515 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134815
Speed: 0.379 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134816
Speed: 3.905 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134816
Speed: 0.370 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134817
Speed: 3.053 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134817
Speed: 1.857 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134818
Speed: 4.620 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134818
Speed: 0.407 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134819
Speed: 0.322 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134819
Speed: 0.305 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134820
Speed: 0.442 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134820
Speed: 0.313 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134821
Speed: 4.289 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134821
Speed: 0.526 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134822
Speed: 2.956 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134822
Speed: 0.419 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134823
Speed: 23.428 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134823
Speed: 4.937 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134824
Speed: 5.353 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134824
Speed: 0.434 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134825
Speed: 0.585 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134825
Speed: 0.719 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134826
Speed: 4.426 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134826
Speed: 4.637 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134827
Speed: 2.238 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134827
Speed: 0.657 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134828
Speed: 12.656 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134828
Speed: 2.044 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134829
Speed: 2.207 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134829
Speed: 0.398 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134830
Speed: 2.237 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134830
Speed: 0.381 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134831
Speed: 1.669 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134831
Speed: 0.505 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134832
Speed: 0.844 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134832
Speed: 1.883 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134833
Speed: 2.656 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134833
Speed: 2.220 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134834
Speed: 3.340 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134834
Speed: 0.318 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134835
Speed: 2.233 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134835
Speed: 0.853 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134836
Speed: 0.395 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134836
Speed: 0.330 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134837
Speed: 0.714 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134837
Speed: 0.346 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134838
Speed: 0.398 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134838
Speed: 0.406 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134839
Speed: 0.363 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134839
Speed: 0.470 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134840
Speed: 0.451 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134840
Speed: 0.343 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134841
Speed: 0.456 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134841
Speed: 0.341 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134842
Speed: 0.305 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134842
Speed: 0.389 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134843
Speed: 0.372 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134843
Speed: 0.353 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134844
Speed: 0.387 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134844
Speed: 0.375 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134845
Speed: 0.361 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134845
Speed: 0.379 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134846
Speed: 0.353 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134846
Speed: 0.307 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134847
Speed: 0.332 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134847
Speed: 0.323 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134848
Speed: 0.319 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134848
Speed: 0.380 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134849
Speed: 0.325 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134849
Speed: 0.315 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134850
Speed: 0.337 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134850
Speed: 0.387 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134851
Speed: 0.303 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134851
Speed: 3.337 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134852
Speed: 0.473 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134852
Speed: 0.440 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134853
Speed: 0.334 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134853
Speed: 0.297 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134854
Speed: 0.395 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134854
Speed: 0.314 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134855
Speed: 0.309 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134855
Speed: 0.294 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134856
Speed: 0.598 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134856
Speed: 0.445 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134857
Speed: 0.410 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134857
Speed: 0.449 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134858
Speed: 0.343 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134858
Speed: 0.493 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134859
Speed: 0.405 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134859
Speed: 0.356 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134860
Speed: 0.462 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134860
Speed: 0.398 ms
|
SELECT * FROM citation_settings WHERE citation_id = 134861
Speed: 0.354 ms
|
SELECT *
FROM metadata_descriptions
WHERE assoc_type = 1048579 AND assoc_id = 134861
Speed: 0.325 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 = 9229
Speed: 34.054 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 = 9229
Speed: 4.010 ms
|
Speed: 0.696 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 6374
Speed: 43.113 ms
|
SELECT * FROM article_settings WHERE article_id = 9229
Speed: 0.781 ms
|
Speed: 1.210 ms
|
SELECT r.*
FROM referrals r
WHERE r.article_id = 9229 AND
r.status = 2
Speed: 3.447 ms
|