SELECT * FROM sessions WHERE session_id = 13lq6gjucbe4o83lhg765f4pg5
Speed: 2.192 ms
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(13lq6gjucbe4o83lhg765f4pg5, 3.238.132.168, CCBot/2.0 (https://commoncrawl.org/faq/), 1619112810, 1619112810, 0, , revistas.unicentro.br
Speed: 1.046 ms
|
SELECT * FROM journals WHERE path = re
Speed: 0.567 ms
|
Speed: 0.514 ms
|
Speed: 2.283 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.pln.classes.tasks.Depositor
Speed: 0.575 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.generic.usageStats.UsageStatsLoader
Speed: 0.478 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.datacite.DataciteInfoSender
Speed: 0.493 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.medra.MedraInfoSender
Speed: 0.399 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.497 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = plugins.importexport.crossref.CrossrefInfoSender
Speed: 0.484 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.ReviewReminder
Speed: 0.576 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.SubscriptionExpiryReminder
Speed: 0.558 ms
|
SELECT last_run FROM scheduled_tasks WHERE class_name = classes.tasks.OpenAccessNotification
Speed: 0.488 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 = 6449
Speed: 26.105 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 = 6449
Speed: 3.413 ms
|
Speed: 0.921 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4593
Speed: 0.626 ms
|
SELECT * FROM article_settings WHERE article_id = 6449
Speed: 0.808 ms
|
Speed: 1.034 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1361
Speed: 1.012 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1362
Speed: 0.637 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 = 354
Speed: 1.639 ms
|
Speed: 0.685 ms
|
SELECT * FROM issue_settings WHERE issue_id = 354
Speed: 0.669 ms
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(ec2-3-238-132-168.compute-1.amazonaws.com, LENGTH(ec2-3-238-132-168.compute-1.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 3
Speed: 1.071 ms
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 65963176 >= isip.ip_start AND 65963176 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 3
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 ('2021-04-22 14:33:30' >= s.date_start AND '2021-04-22 14:33:30' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 65963176 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 3
Speed: 1.117 ms
|
SELECT * FROM sections WHERE section_id = 7
Speed: 0.719 ms
|
SELECT * FROM section_settings WHERE section_id = 7
Speed: 0.663 ms
|
SELECT * FROM rt_versions WHERE version_id = 41 AND journal_id = 3
Speed: 0.880 ms
|
SELECT * FROM rt_contexts WHERE version_id = 41
Speed: 1.057 ms
|
SELECT * FROM rt_searches WHERE context_id = 525
Speed: 1.190 ms
|
SELECT * FROM rt_searches WHERE context_id = 526
Speed: 0.714 ms
|
SELECT * FROM rt_searches WHERE context_id = 527
Speed: 0.751 ms
|
SELECT * FROM rt_searches WHERE context_id = 528
Speed: 0.685 ms
|
SELECT * FROM rt_searches WHERE context_id = 529
Speed: 0.682 ms
|
SELECT * FROM rt_searches WHERE context_id = 530
Speed: 0.713 ms
|
SELECT * FROM rt_searches WHERE context_id = 531
Speed: 0.664 ms
|
SELECT * FROM rt_searches WHERE context_id = 532
Speed: 0.680 ms
|
SELECT * FROM rt_searches WHERE context_id = 533
Speed: 0.700 ms
|
SELECT * FROM rt_searches WHERE context_id = 534
Speed: 0.684 ms
|
SELECT * FROM rt_searches WHERE context_id = 535
Speed: 0.689 ms
|
SELECT * FROM rt_searches WHERE context_id = 536
Speed: 0.672 ms
|
SELECT * FROM sections WHERE section_id = 7
Speed: 0.595 ms
|
SELECT * FROM section_settings WHERE section_id = 7
Speed: 0.615 ms
|
Speed: 17.138 ms
|
SELECT * FROM users WHERE user_id = 137109
Speed: 0.703 ms
|
SELECT * FROM user_settings WHERE user_id = 137109
Speed: 4.635 ms
|
SELECT * FROM users WHERE user_id = 137108
Speed: 0.714 ms
|
SELECT * FROM user_settings WHERE user_id = 137108
Speed: 6.269 ms
|
SELECT * FROM users WHERE user_id = 137085
Speed: 0.725 ms
|
SELECT * FROM user_settings WHERE user_id = 137085
Speed: 8.782 ms
|
SELECT * FROM users WHERE user_id = 137087
Speed: 0.771 ms
|
SELECT * FROM user_settings WHERE user_id = 137087
Speed: 1.516 ms
|
SELECT * FROM users WHERE user_id = 137086
Speed: 0.760 ms
|
SELECT * FROM user_settings WHERE user_id = 137086
Speed: 7.940 ms
|
SELECT * FROM users WHERE user_id = 137097
Speed: 0.735 ms
|
SELECT * FROM user_settings WHERE user_id = 137097
Speed: 0.892 ms
|
SELECT * FROM users WHERE user_id = 137094
Speed: 0.746 ms
|
SELECT * FROM user_settings WHERE user_id = 137094
Speed: 1.254 ms
|
SELECT * FROM users WHERE user_id = 137090
Speed: 0.746 ms
|
SELECT * FROM user_settings WHERE user_id = 137090
Speed: 2.097 ms
|
SELECT * FROM users WHERE user_id = 137094
Speed: 0.739 ms
|
SELECT * FROM user_settings WHERE user_id = 137094
Speed: 0.874 ms
|
SELECT * FROM users WHERE user_id = 137094
Speed: 0.734 ms
|
SELECT * FROM user_settings WHERE user_id = 137094
Speed: 0.743 ms
|
SELECT * FROM users WHERE user_id = 137089
Speed: 0.620 ms
|
SELECT * FROM user_settings WHERE user_id = 137089
Speed: 0.999 ms
|
SELECT * FROM users WHERE user_id = 137093
Speed: 0.657 ms
|
SELECT * FROM user_settings WHERE user_id = 137093
Speed: 0.864 ms
|
SELECT * FROM users WHERE user_id = 137093
Speed: 0.659 ms
|
SELECT * FROM user_settings WHERE user_id = 137093
Speed: 0.839 ms
|
SELECT * FROM users WHERE user_id = 137098
Speed: 0.639 ms
|
SELECT * FROM user_settings WHERE user_id = 137098
Speed: 0.881 ms
|
SELECT * FROM users WHERE user_id = 137106
Speed: 0.633 ms
|
SELECT * FROM user_settings WHERE user_id = 137106
Speed: 1.358 ms
|
SELECT * FROM users WHERE user_id = 137106
Speed: 0.750 ms
|
SELECT * FROM user_settings WHERE user_id = 137106
Speed: 0.778 ms
|
SELECT * FROM users WHERE user_id = 137111
Speed: 0.651 ms
|
SELECT * FROM user_settings WHERE user_id = 137111
Speed: 1.101 ms
|
SELECT * FROM users WHERE user_id = 137111
Speed: 0.769 ms
|
SELECT * FROM user_settings WHERE user_id = 137111
Speed: 0.919 ms
|
SELECT * FROM users WHERE user_id = 137099
Speed: 0.746 ms
|
SELECT * FROM user_settings WHERE user_id = 137099
Speed: 0.925 ms
|
SELECT * FROM users WHERE user_id = 137112
Speed: 0.712 ms
|
SELECT * FROM user_settings WHERE user_id = 137112
Speed: 8.248 ms
|
SELECT * FROM users WHERE user_id = 137112
Speed: 0.673 ms
|
SELECT * FROM user_settings WHERE user_id = 137112
Speed: 0.874 ms
|
SELECT * FROM users WHERE user_id = 137110
Speed: 0.700 ms
|
SELECT * FROM user_settings WHERE user_id = 137110
Speed: 1.186 ms
|
SELECT * FROM users WHERE user_id = 137149
Speed: 0.668 ms
|
SELECT * FROM user_settings WHERE user_id = 137149
Speed: 7.723 ms
|
SELECT * FROM users WHERE user_id = 137118
Speed: 0.705 ms
|
SELECT * FROM user_settings WHERE user_id = 137118
Speed: 0.956 ms
|
SELECT * FROM users WHERE user_id = 137122
Speed: 0.666 ms
|
SELECT * FROM user_settings WHERE user_id = 137122
Speed: 0.551 ms
|
SELECT * FROM users WHERE user_id = 137123
Speed: 0.643 ms
|
SELECT * FROM user_settings WHERE user_id = 137123
Speed: 0.793 ms
|
SELECT * FROM users WHERE user_id = 137124
Speed: 0.648 ms
|
SELECT * FROM user_settings WHERE user_id = 137124
Speed: 1.135 ms
|
SELECT * FROM users WHERE user_id = 137128
Speed: 0.723 ms
|
SELECT * FROM user_settings WHERE user_id = 137128
Speed: 0.592 ms
|
SELECT * FROM users WHERE user_id = 137119
Speed: 0.743 ms
|
SELECT * FROM user_settings WHERE user_id = 137119
Speed: 2.910 ms
|
SELECT * FROM users WHERE user_id = 137125
Speed: 0.726 ms
|
SELECT * FROM user_settings WHERE user_id = 137125
Speed: 2.653 ms
|
SELECT * FROM users WHERE user_id = 137120
Speed: 0.699 ms
|
SELECT * FROM user_settings WHERE user_id = 137120
Speed: 0.932 ms
|
SELECT * FROM users WHERE user_id = 137126
Speed: 0.720 ms
|
SELECT * FROM user_settings WHERE user_id = 137126
Speed: 1.928 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.687 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 0.966 ms
|
SELECT * FROM users WHERE user_id = 137126
Speed: 0.682 ms
|
SELECT * FROM user_settings WHERE user_id = 137126
Speed: 1.387 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.682 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 0.757 ms
|
SELECT * FROM users WHERE user_id = 137134
Speed: 0.683 ms
|
SELECT * FROM user_settings WHERE user_id = 137134
Speed: 2.040 ms
|
SELECT * FROM users WHERE user_id = 137133
Speed: 0.658 ms
|
SELECT * FROM user_settings WHERE user_id = 137133
Speed: 1.091 ms
|
SELECT * FROM users WHERE user_id = 137132
Speed: 0.631 ms
|
SELECT * FROM user_settings WHERE user_id = 137132
Speed: 1.134 ms
|
SELECT * FROM users WHERE user_id = 137099
Speed: 0.723 ms
|
SELECT * FROM user_settings WHERE user_id = 137099
Speed: 0.756 ms
|
SELECT * FROM users WHERE user_id = 137093
Speed: 0.637 ms
|
SELECT * FROM user_settings WHERE user_id = 137093
Speed: 0.699 ms
|
SELECT * FROM users WHERE user_id = 137199
Speed: 0.639 ms
|
SELECT * FROM user_settings WHERE user_id = 137199
Speed: 0.636 ms
|
SELECT * FROM users WHERE user_id = 137200
Speed: 0.744 ms
|
SELECT * FROM user_settings WHERE user_id = 137200
Speed: 0.815 ms
|
SELECT * FROM users WHERE user_id = 137092
Speed: 0.766 ms
|
SELECT * FROM user_settings WHERE user_id = 137092
Speed: 0.931 ms
|
SELECT * FROM users WHERE user_id = 137087
Speed: 0.689 ms
|
SELECT * FROM user_settings WHERE user_id = 137087
Speed: 0.902 ms
|
SELECT * FROM users WHERE user_id = 137101
Speed: 0.726 ms
|
SELECT * FROM user_settings WHERE user_id = 137101
Speed: 0.832 ms
|
SELECT * FROM users WHERE user_id = 137101
Speed: 0.733 ms
|
SELECT * FROM user_settings WHERE user_id = 137101
Speed: 0.842 ms
|
SELECT * FROM users WHERE user_id = 137107
Speed: 0.715 ms
|
SELECT * FROM user_settings WHERE user_id = 137107
Speed: 0.787 ms
|
SELECT * FROM users WHERE user_id = 137123
Speed: 0.717 ms
|
SELECT * FROM user_settings WHERE user_id = 137123
Speed: 0.867 ms
|
SELECT * FROM users WHERE user_id = 137121
Speed: 0.725 ms
|
SELECT * FROM user_settings WHERE user_id = 137121
Speed: 1.189 ms
|
SELECT * FROM users WHERE user_id = 137121
Speed: 0.728 ms
|
SELECT * FROM user_settings WHERE user_id = 137121
Speed: 0.922 ms
|
SELECT * FROM users WHERE user_id = 137106
Speed: 0.709 ms
|
SELECT * FROM user_settings WHERE user_id = 137106
Speed: 0.895 ms
|
SELECT * FROM users WHERE user_id = 137120
Speed: 0.744 ms
|
SELECT * FROM user_settings WHERE user_id = 137120
Speed: 0.922 ms
|
SELECT * FROM users WHERE user_id = 137123
Speed: 0.715 ms
|
SELECT * FROM user_settings WHERE user_id = 137123
Speed: 0.951 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.760 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 0.865 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.754 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 0.877 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.753 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 1.184 ms
|
SELECT * FROM users WHERE user_id = 137130
Speed: 0.697 ms
|
SELECT * FROM user_settings WHERE user_id = 137130
Speed: 0.816 ms
|
SELECT * FROM users WHERE user_id = 137026
Speed: 0.744 ms
|
SELECT * FROM user_settings WHERE user_id = 137026
Speed: 0.934 ms
|
SELECT * FROM users WHERE user_id = 137032
Speed: 0.683 ms
|
SELECT * FROM user_settings WHERE user_id = 137032
Speed: 1.073 ms
|
SELECT * FROM users WHERE user_id = 137156
Speed: 0.765 ms
|
SELECT * FROM user_settings WHERE user_id = 137156
Speed: 0.976 ms
|
SELECT * FROM users WHERE user_id = 137075
Speed: 0.713 ms
|
SELECT * FROM user_settings WHERE user_id = 137075
Speed: 0.800 ms
|
SELECT * FROM users WHERE user_id = 137074
Speed: 0.702 ms
|
SELECT * FROM user_settings WHERE user_id = 137074
Speed: 0.774 ms
|
SELECT * FROM users WHERE user_id = 137062
Speed: 0.708 ms
|
SELECT * FROM user_settings WHERE user_id = 137062
Speed: 0.948 ms
|
SELECT * FROM users WHERE user_id = 137053
Speed: 0.759 ms
|
SELECT * FROM user_settings WHERE user_id = 137053
Speed: 0.829 ms
|
SELECT * FROM users WHERE user_id = 137134
Speed: 0.725 ms
|
SELECT * FROM user_settings WHERE user_id = 137134
Speed: 0.932 ms
|
SELECT * FROM users WHERE user_id = 137278
Speed: 0.741 ms
|
SELECT * FROM user_settings WHERE user_id = 137278
Speed: 0.657 ms
|
SELECT * FROM users WHERE user_id = 137286
Speed: 0.739 ms
|
SELECT * FROM user_settings WHERE user_id = 137286
Speed: 0.685 ms
|
SELECT * FROM users WHERE user_id = 137292
Speed: 2.645 ms
|
SELECT * FROM user_settings WHERE user_id = 137292
Speed: 0.617 ms
|
SELECT * FROM users WHERE user_id = 136217
Speed: 0.717 ms
|
SELECT * FROM user_settings WHERE user_id = 136217
Speed: 0.616 ms
|
SELECT * FROM users WHERE user_id = 136217
Speed: 0.925 ms
|
SELECT * FROM user_settings WHERE user_id = 136217
Speed: 1.126 ms
|
SELECT * FROM users WHERE user_id = 136217
Speed: 1.300 ms
|
SELECT * FROM user_settings WHERE user_id = 136217
Speed: 0.631 ms
|
SELECT * FROM users WHERE user_id = 136367
Speed: 0.776 ms
|
SELECT * FROM user_settings WHERE user_id = 136367
Speed: 0.653 ms
|
SELECT * FROM users WHERE user_id = 137328
Speed: 0.771 ms
|
SELECT * FROM user_settings WHERE user_id = 137328
Speed: 1.600 ms
|
SELECT * FROM users WHERE user_id = 137288
Speed: 0.814 ms
|
SELECT * FROM user_settings WHERE user_id = 137288
Speed: 0.709 ms
|
SELECT * FROM users WHERE user_id = 137348
Speed: 0.720 ms
|
SELECT * FROM user_settings WHERE user_id = 137348
Speed: 0.704 ms
|
SELECT * FROM users WHERE user_id = 137205
Speed: 0.728 ms
|
SELECT * FROM user_settings WHERE user_id = 137205
Speed: 0.890 ms
|
SELECT * FROM users WHERE user_id = 137355
Speed: 0.726 ms
|
SELECT * FROM user_settings WHERE user_id = 137355
Speed: 0.619 ms
|
SELECT * FROM users WHERE user_id = 137357
Speed: 0.725 ms
|
SELECT * FROM user_settings WHERE user_id = 137357
Speed: 0.783 ms
|
SELECT * FROM users WHERE user_id = 137324
Speed: 0.724 ms
|
SELECT * FROM user_settings WHERE user_id = 137324
Speed: 0.595 ms
|
SELECT * FROM users WHERE user_id = 137372
Speed: 1.167 ms
|
SELECT * FROM user_settings WHERE user_id = 137372
Speed: 4.443 ms
|
SELECT * FROM users WHERE user_id = 137379
Speed: 10.037 ms
|
SELECT * FROM user_settings WHERE user_id = 137379
Speed: 7.230 ms
|
SELECT * FROM users WHERE user_id = 137441
Speed: 1.015 ms
|
SELECT * FROM user_settings WHERE user_id = 137441
Speed: 0.790 ms
|
SELECT * FROM users WHERE user_id = 137447
Speed: 0.729 ms
|
SELECT * FROM user_settings WHERE user_id = 137447
Speed: 0.970 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 = 4593 AND g.article_id = 6449
Speed: 1.002 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4593
Speed: 0.554 ms
|
SELECT * FROM sections WHERE section_id = 7
Speed: 0.630 ms
|
SELECT * FROM section_settings WHERE section_id = 7
Speed: 0.655 ms
|
Speed: 0.777 ms
|
SELECT * FROM author_settings WHERE author_id = 15233
Speed: 0.639 ms
|
SELECT * FROM author_settings WHERE author_id = 15234
Speed: 0.636 ms
|
SELECT * FROM author_settings WHERE author_id = 15235
Speed: 0.621 ms
|
SELECT * FROM author_settings WHERE author_id = 15236
Speed: 0.733 ms
|
SELECT * FROM author_settings WHERE author_id = 15237
Speed: 0.720 ms
|
Speed: 0.858 ms
|
SELECT * FROM author_settings WHERE author_id = 15233
Speed: 0.636 ms
|
SELECT * FROM author_settings WHERE author_id = 15234
Speed: 0.606 ms
|
SELECT * FROM author_settings WHERE author_id = 15235
Speed: 0.590 ms
|
SELECT * FROM author_settings WHERE author_id = 15236
Speed: 0.608 ms
|
SELECT * FROM author_settings WHERE author_id = 15237
Speed: 0.621 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 = 6449
Speed: 23.106 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 = 6449
Speed: 3.583 ms
|
Speed: 0.966 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4593
Speed: 0.604 ms
|
SELECT * FROM article_settings WHERE article_id = 6449
Speed: 0.753 ms
|
Speed: 1.004 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1361
Speed: 0.588 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1362
Speed: 0.572 ms
|
Speed: 0.792 ms
|
SELECT * FROM author_settings WHERE author_id = 15233
Speed: 0.581 ms
|
SELECT * FROM author_settings WHERE author_id = 15234
Speed: 0.613 ms
|
SELECT * FROM author_settings WHERE author_id = 15235
Speed: 0.547 ms
|
SELECT * FROM author_settings WHERE author_id = 15236
Speed: 0.577 ms
|
SELECT * FROM author_settings WHERE author_id = 15237
Speed: 0.581 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 = 6449
Speed: 21.237 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 = 6449
Speed: 3.391 ms
|
Speed: 0.984 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4593
Speed: 0.541 ms
|
SELECT * FROM article_settings WHERE article_id = 6449
Speed: 0.761 ms
|
Speed: 0.901 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1361
Speed: 0.592 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1362
Speed: 0.576 ms
|
Speed: 0.794 ms
|
SELECT * FROM author_settings WHERE author_id = 15233
Speed: 0.575 ms
|
SELECT * FROM author_settings WHERE author_id = 15234
Speed: 0.631 ms
|
SELECT * FROM author_settings WHERE author_id = 15235
Speed: 0.566 ms
|
SELECT * FROM author_settings WHERE author_id = 15236
Speed: 0.553 ms
|
SELECT * FROM author_settings WHERE author_id = 15237
Speed: 0.579 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 = 6449
Speed: 19.710 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 = 6449
Speed: 3.356 ms
|
Speed: 0.969 ms
|
SELECT * FROM article_galley_settings WHERE galley_id = 4593
Speed: 0.564 ms
|
SELECT * FROM article_settings WHERE article_id = 6449
Speed: 0.737 ms
|
Speed: 0.894 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1361
Speed: 0.590 ms
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 1362
Speed: 0.578 ms
|
Speed: 0.758 ms
|
SELECT * FROM author_settings WHERE author_id = 15233
Speed: 0.585 ms
|
SELECT * FROM author_settings WHERE author_id = 15234
Speed: 0.592 ms
|
SELECT * FROM author_settings WHERE author_id = 15235
Speed: 0.550 ms
|
SELECT * FROM author_settings WHERE author_id = 15236
Speed: 0.571 ms
|
SELECT * FROM author_settings WHERE author_id = 15237
Speed: 0.565 ms
|
Comments on this article
by Hopkins Pickett (05-12-2020)
by Ibsen Ravn (05-12-2020)
by Connolly Foss (06-12-2020)
by Dohn McCallum (06-12-2020)
by Nymann Lake (06-12-2020)
by Bynum Moody (06-12-2020)
by Herring Kure (06-12-2020)
by Polat Rosendal (06-12-2020)
by Herring Kure (06-12-2020)
by Herring Kure (06-12-2020)
by Isaksen Sumner (06-12-2020)
by Langston Patterson (06-12-2020)
by Langston Patterson (06-12-2020)
by Whitfield Klein (06-12-2020)
by Karlsen Honore (06-12-2020)
by Karlsen Honore (06-12-2020)
by MacKay Dreyer (06-12-2020)
by MacKay Dreyer (06-12-2020)
by Marsh Krogh (06-12-2020)
by Keene Dreyer (06-12-2020)
by Keene Dreyer (06-12-2020)
by Morsing Hartman (06-12-2020)
by nando irawan (07-12-2020)
by Daley Tennant (08-12-2020)
by Kaae Powell (09-12-2020)
by Clemensen McFarland (09-12-2020)
by Berry Horne (09-12-2020)
by Taylor Floyd (09-12-2020)
by Kendall Velazquez (11-12-2020)
by Kaae McCallum (11-12-2020)
by Alexandersen Cormier (11-12-2020)
by Gutierrez Kay (11-12-2020)
by Ohlsen Floyd (11-12-2020)
by Gutierrez Kay (11-12-2020)
by Ohlsen Floyd (11-12-2020)
by Sanford Corneliussen (11-12-2020)
by Lykke Jacobs (12-12-2020)
by Mejia Buckner (12-12-2020)
by Marsh Krogh (28-12-2020)
by Langston Patterson (28-12-2020)
by Sergio Albert (28-12-2020)
by kokiqq jaya (28-12-2020)
by Kragelund Riggs (28-12-2020)
by Dohn McCallum (29-12-2020)
by Price Ebsen (30-12-2020)
by Price Ebsen (30-12-2020)
by Velasquez Lloyd (30-12-2020)
by Clemensen McFarland (30-12-2020)
by Karlsson Cahill (30-12-2020)
by Karlsson Cahill (30-12-2020)
by Karlsen Honore (30-12-2020)
by Alexandersen Cormier (30-12-2020)
by Clemensen McFarland (31-12-2020)
by Ohlsen Floyd (08-01-2021)
by Ohlsen Floyd (08-01-2021)
by Ohlsen Floyd (08-01-2021)
by Ohlsen Floyd (08-01-2021)
by Chan Zhang (08-01-2021)
by Monrad Yang (08-01-2021)
by Enrico Vicente Cortês (08-01-2021)
by Krabbe Skov (09-01-2021)
by Roberts Wilson (09-01-2021)
by Timmermann Riddle (09-01-2021)
by Wulff Donahue (09-01-2021)
by Sanford Corneliussen (09-01-2021)
by Hey Jaggerman Jensen (30-01-2021)
by ทางเข้า sbo สมัคร sbobet บนมือถือ (04-02-2021)
by Dion Mours (05-02-2021)
by Lara Pardo (08-02-2021)
by Lara Pardo (08-02-2021)
by Lara Pardo (08-02-2021)
by kucing mo (19-02-2021)
by mr booongo slot (27-02-2021)
by Friska Simatumpang (07-03-2021)
by ทางเข้า ligaz สมัคร ligaz888 (10-03-2021)
by muabanthuoctay mua ban thuoc tay (11-03-2021)
by Friska Chen (13-03-2021)
by domino qq (13-03-2021)
by Crystal Lala (21-03-2021)
by miku miku (22-03-2021)
by situs slot online terpercaya (24-03-2021)
by Skyey Preston (18-04-2021)
by dunia jackpot (22-04-2021)