|
SELECT * FROM sessions WHERE session_id = u7pnc9jtj4vsilb5oj0thvrntbd4fqj6bu65inhl36betqtd8v01
Speed: 4.811 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(u7pnc9jtj4vsilb5oj0thvrntbd4fqj6bu65inhl36betqtd8v01, 54.92.239.120, CCBot/2.0 (http://commoncrawl.org/faq/), 1422577151, 1422577151, 0, , 0
Speed: 2.561 ms
|
|
SELECT * FROM journals WHERE path = ob
Speed: 0.554 ms
|
|
Speed: 0.389 ms
|
|
Speed: 1.493 ms
|
|
Speed: 0.648 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 10
Speed: 0.572 ms
|
|
SELECT DISTINCT
pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev,
s.abstracts_not_required AS abstracts_not_required,
s.hide_title AS section_hide_title,
s.hide_author AS section_hide_author,
COALESCE(o.seq, s.seq) AS section_seq,
pa.seq
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN custom_section_orders o ON (a.section_id = o.section_id AND o.issue_id = 10)
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 pa.issue_id = 10
Speed: 15.592 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq8
Speed: 2.647 ms
|
|
Speed: 0.544 ms
|
|
SELECT * FROM author_settings WHERE author_id = 245
Speed: 0.501 ms
|
|
SELECT * FROM article_settings WHERE article_id = 180
Speed: 0.527 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq8
Speed: 0.897 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 8 ORDER BY g.seq0
Speed: 0.776 ms
|
|
Speed: 0.472 ms
|
|
SELECT * FROM author_settings WHERE author_id = 107
Speed: 0.467 ms
|
|
SELECT * FROM article_settings WHERE article_id = 80
Speed: 0.532 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq0
Speed: 0.785 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq3
Speed: 0.769 ms
|
|
Speed: 0.537 ms
|
|
SELECT * FROM author_settings WHERE author_id = 221
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 222
Speed: 0.429 ms
|
|
SELECT * FROM author_settings WHERE author_id = 175
Speed: 0.439 ms
|
|
SELECT * FROM author_settings WHERE author_id = 223
Speed: 0.418 ms
|
|
SELECT * FROM author_settings WHERE author_id = 224
Speed: 0.428 ms
|
|
SELECT * FROM author_settings WHERE author_id = 225
Speed: 0.433 ms
|
|
SELECT * FROM article_settings WHERE article_id = 137
Speed: 0.526 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq3
Speed: 0.812 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 8 ORDER BY g.seq1
Speed: 0.798 ms
|
|
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 108
Speed: 0.423 ms
|
|
SELECT * FROM article_settings WHERE article_id = 81
Speed: 0.473 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq1
Speed: 0.783 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 8 ORDER BY g.seq2
Speed: 0.785 ms
|
|
Speed: 0.472 ms
|
|
SELECT * FROM author_settings WHERE author_id = 109
Speed: 0.476 ms
|
|
SELECT * FROM article_settings WHERE article_id = 82
Speed: 0.521 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq2
Speed: 0.785 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq9
Speed: 0.813 ms
|
|
Speed: 0.526 ms
|
|
SELECT * FROM author_settings WHERE author_id = 263
Speed: 0.497 ms
|
|
SELECT * FROM article_settings WHERE article_id = 191
Speed: 0.522 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq9
Speed: 0.797 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq9
Speed: 0.817 ms
|
|
Speed: 0.500 ms
|
|
SELECT * FROM author_settings WHERE author_id = 264
Speed: 0.434 ms
|
|
SELECT * FROM author_settings WHERE author_id = 265
Speed: 0.414 ms
|
|
SELECT * FROM article_settings WHERE article_id = 192
Speed: 0.412 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq9
Speed: 0.792 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 8 ORDER BY g.seq7
Speed: 0.811 ms
|
|
Speed: 0.470 ms
|
|
SELECT * FROM author_settings WHERE author_id = 114
Speed: 0.449 ms
|
|
SELECT * FROM article_settings WHERE article_id = 87
Speed: 0.484 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq7
Speed: 0.789 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 8 ORDER BY g.seq8
Speed: 0.793 ms
|
|
Speed: 0.501 ms
|
|
SELECT * FROM author_settings WHERE author_id = 115
Speed: 0.444 ms
|
|
SELECT * FROM article_settings WHERE article_id = 88
Speed: 0.498 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq8
Speed: 0.802 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq6
Speed: 0.782 ms
|
|
Speed: 0.497 ms
|
|
SELECT * FROM author_settings WHERE author_id = 229
Speed: 0.464 ms
|
|
SELECT * FROM article_settings WHERE article_id = 168
Speed: 0.488 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq6
Speed: 0.793 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq6
Speed: 0.853 ms
|
|
Speed: 0.502 ms
|
|
SELECT * FROM author_settings WHERE author_id = 218
Speed: 0.444 ms
|
|
SELECT * FROM article_settings WHERE article_id = 162
Speed: 0.469 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq6
Speed: 0.843 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq0
Speed: 0.807 ms
|
|
Speed: 0.536 ms
|
|
SELECT * FROM author_settings WHERE author_id = 136
Speed: 0.464 ms
|
|
SELECT * FROM article_settings WHERE article_id = 106
Speed: 0.487 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq0
Speed: 0.783 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq3
Speed: 0.778 ms
|
|
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 174
Speed: 0.463 ms
|
|
SELECT * FROM article_settings WHERE article_id = 136
Speed: 0.497 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq3
Speed: 0.794 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 9 ORDER BY g.seq2
Speed: 0.780 ms
|
|
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 121
Speed: 0.461 ms
|
|
SELECT * FROM article_settings WHERE article_id = 92
Speed: 0.479 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq2
Speed: 0.813 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq0
Speed: 0.803 ms
|
|
Speed: 0.534 ms
|
|
SELECT * FROM author_settings WHERE author_id = 132
Speed: 0.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 166
Speed: 0.436 ms
|
|
SELECT * FROM article_settings WHERE article_id = 102
Speed: 0.493 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq0
Speed: 0.775 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq0
Speed: 0.771 ms
|
|
Speed: 0.523 ms
|
|
SELECT * FROM author_settings WHERE author_id = 134
Speed: 0.511 ms
|
|
SELECT * FROM author_settings WHERE author_id = 247
Speed: 0.449 ms
|
|
SELECT * FROM article_settings WHERE article_id = 104
Speed: 0.489 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq0
Speed: 0.798 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq1
Speed: 0.759 ms
|
|
Speed: 0.510 ms
|
|
SELECT * FROM author_settings WHERE author_id = 146
Speed: 0.426 ms
|
|
SELECT * FROM article_settings WHERE article_id = 116
Speed: 0.457 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq1
Speed: 0.794 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, 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.article_id = 1 ORDER BY g.seq2
Speed: 0.761 ms
|
|
Speed: 0.526 ms
|
|
SELECT * FROM author_settings WHERE author_id = 159
Speed: 0.471 ms
|
|
SELECT * FROM article_settings WHERE article_id = 125
Speed: 0.677 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 1 ORDER BY s.seq2
Speed: 0.792 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.467 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
Speed: 4.324 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 = 0
Speed: 3.168 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-54-92-239-120.compute-1.amazonaws.com, LENGTH(ec2-54-92-239-120.compute-1.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.475 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 912060280 >= isip.ip_start AND 912060280 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
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 ('2015-01-30 00:19:11' >= s.date_start AND '2015-01-30 00:19:11' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 912060280 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.206 ms
|
Observatorio (OBS*)
