|
SELECT * FROM sessions WHERE session_id = n05j9if8o9hhu3kr5i6sadpda0
Speed: 0.425 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(n05j9if8o9hhu3kr5i6sadpda0, 184.73.7.143, CCBot/2.0, 1371608805, 1371608805, 0, , 0
Speed: 0.408 ms
|
|
SELECT * FROM journals WHERE path = cj
Speed: 0.351 ms
|
|
Speed: 0.267 ms
|
|
Speed: 3.274 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.486 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 95
Speed: 0.478 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 = 95)
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 = 95
Speed: 3.635 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.seq4
Speed: 0.509 ms
|
|
Speed: 0.366 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2141
Speed: 0.411 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1458
Speed: 0.475 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.seq4
Speed: 0.393 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.seq4
Speed: 0.481 ms
|
|
Speed: 0.359 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2142
Speed: 0.403 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1459
Speed: 0.424 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.seq4
Speed: 0.370 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.446 ms
|
|
Speed: 0.454 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1679
Speed: 0.422 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1680
Speed: 0.414 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1681
Speed: 0.589 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1682
Speed: 0.402 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1683
Speed: 0.396 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1684
Speed: 0.398 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1685
Speed: 0.431 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1686
Speed: 0.402 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1687
Speed: 0.414 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1688
Speed: 0.401 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1689
Speed: 0.401 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1161
Speed: 0.481 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.377 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.466 ms
|
|
Speed: 0.361 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1726
Speed: 0.551 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1186
Speed: 0.463 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.359 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.seq4
Speed: 0.489 ms
|
|
Speed: 0.355 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2143
Speed: 0.383 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1460
Speed: 0.443 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.seq4
Speed: 0.358 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.454 ms
|
|
Speed: 0.364 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1692
Speed: 0.419 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1693
Speed: 0.398 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1164
Speed: 0.451 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.404 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.443 ms
|
|
Speed: 0.353 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1691
Speed: 0.419 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1163
Speed: 0.506 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.361 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.448 ms
|
|
Speed: 0.359 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1677
Speed: 0.426 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1159
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.seq1
Speed: 0.407 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.444 ms
|
|
Speed: 0.392 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1668
Speed: 0.403 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1669
Speed: 0.400 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1670
Speed: 0.400 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1671
Speed: 0.404 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1155
Speed: 0.444 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.362 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.seq4
Speed: 0.453 ms
|
|
Speed: 0.450 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2144
Speed: 0.387 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2145
Speed: 0.383 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2146
Speed: 0.391 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2147
Speed: 0.394 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2148
Speed: 0.382 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2149
Speed: 0.382 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1461
Speed: 0.430 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.seq4
Speed: 0.411 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.449 ms
|
|
Speed: 0.353 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1676
Speed: 0.397 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1158
Speed: 0.460 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.372 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.442 ms
|
|
Speed: 0.353 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1675
Speed: 0.395 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1157
Speed: 0.444 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.533 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 80
Speed: 0.520 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 81
Speed: 0.473 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.491 ms
|
|
Speed: 0.366 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1740
Speed: 0.422 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1741
Speed: 0.396 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1199
Speed: 0.428 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.372 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.444 ms
|
|
Speed: 0.354 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1768
Speed: 0.576 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1214
Speed: 0.451 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.405 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.443 ms
|
|
Speed: 0.355 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1730
Speed: 0.676 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1189
Speed: 0.482 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.363 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.seq4
Speed: 0.473 ms
|
|
Speed: 0.355 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2151
Speed: 0.447 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1463
Speed: 0.433 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.seq4
Speed: 0.361 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.seq4
Speed: 0.465 ms
|
|
Speed: 0.353 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2150
Speed: 0.394 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1462
Speed: 0.428 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.seq4
Speed: 0.372 ms
|
|
SELECT * FROM journals WHERE journal_id = 6
Speed: 0.298 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: 2.272 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: 0.553 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-184-73-7-143.compute-1.amazonaws.com, LENGTH(ec2-184-73-7-143.compute-1.amazonaws.com)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 6
Speed: 0.492 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 3091793807 >= isip.ip_start AND 3091793807 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 6
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 ('2013-06-18 23:26:45' >= s.date_start AND '2013-06-18 23:26:45' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 3091793807 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 6
Speed: 0.452 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.407 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 95
Speed: 0.474 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.427 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 95
Speed: 0.465 ms
|
Canadian Journal of Education Revue canadienne de l'eduction
