|
SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 1.469 ms
|
|
DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.483 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(a5ce42b1641fd6a1b36e7b445fa955c7, 38.107.179.229, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1328794680, 1328794680, 0, , 0
Speed: 0.438 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.270 ms
|
|
Speed: 0.228 ms
|
|
Speed: 0.314 ms
|
|
Speed: 0.358 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 25
Speed: 0.259 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 = 25)
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 = 25
Speed: 17.768 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 = 6 ORDER BY g.seq8
Speed: 18.820 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1938
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 688
Speed: 0.247 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 = 6 ORDER BY s.seq8
Speed: 0.257 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 = 6 ORDER BY g.seq8
Speed: 0.668 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1939
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1940
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 689
Speed: 0.262 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 = 6 ORDER BY s.seq8
Speed: 0.260 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 = 6 ORDER BY g.seq9
Speed: 0.637 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1941
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1942
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 690
Speed: 0.277 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 = 6 ORDER BY s.seq9
Speed: 0.261 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 = 6 ORDER BY g.seq9
Speed: 0.741 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1943
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1944
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1945
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1946
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1947
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1948
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1949
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1950
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 691
Speed: 0.256 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 = 6 ORDER BY s.seq9
Speed: 0.266 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 = 6 ORDER BY g.seq9
Speed: 0.664 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1951
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1952
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1953
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 692
Speed: 0.260 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 = 6 ORDER BY s.seq9
Speed: 0.268 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 = 6 ORDER BY g.seq9
Speed: 0.810 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1954
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1955
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 693
Speed: 0.258 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 = 6 ORDER BY s.seq9
Speed: 0.265 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 = 6 ORDER BY g.seq9
Speed: 0.668 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1956
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1957
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 694
Speed: 0.260 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 = 6 ORDER BY s.seq9
Speed: 0.258 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 = 6 ORDER BY g.seq9
Speed: 0.618 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1958
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1959
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1960
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 695
Speed: 0.257 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 = 6 ORDER BY s.seq9
Speed: 0.257 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 = 6 ORDER BY g.seq9
Speed: 0.620 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1961
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1962
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1963
Speed: 0.248 ms
|
|
SELECT * FROM article_settings WHERE article_id = 696
Speed: 0.259 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 = 6 ORDER BY s.seq9
Speed: 0.263 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 = 6 ORDER BY g.seq9
Speed: 0.796 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1964
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1965
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1966
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 697
Speed: 0.263 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 = 6 ORDER BY s.seq9
Speed: 0.264 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 = 6 ORDER BY g.seq9
Speed: 0.282 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1967
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1968
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1969
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1970
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1971
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 698
Speed: 0.266 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 = 6 ORDER BY s.seq9
Speed: 0.272 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 = 6 ORDER BY g.seq9
Speed: 0.673 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1972
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1973
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1974
Speed: 0.258 ms
|
|
SELECT * FROM article_settings WHERE article_id = 699
Speed: 0.266 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 = 6 ORDER BY s.seq9
Speed: 0.265 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 = 7 ORDER BY g.seq0
Speed: 0.789 ms
|
|
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1975
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 700
Speed: 0.263 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 = 7 ORDER BY s.seq0
Speed: 0.272 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 = 7 ORDER BY g.seq0
Speed: 0.692 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1976
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1977
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1978
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1979
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1980
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1981
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 701
Speed: 0.270 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 = 7 ORDER BY s.seq0
Speed: 0.269 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 = 7 ORDER BY g.seq0
Speed: 0.683 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1982
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1983
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1984
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1985
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 702
Speed: 0.263 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 = 7 ORDER BY s.seq0
Speed: 0.272 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 = 7 ORDER BY g.seq0
Speed: 0.641 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1986
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 703
Speed: 0.261 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 = 7 ORDER BY s.seq0
Speed: 0.269 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 = 7 ORDER BY g.seq0
Speed: 0.657 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1987
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 704
Speed: 0.267 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 = 7 ORDER BY s.seq0
Speed: 0.270 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 = 7 ORDER BY g.seq0
Speed: 0.625 ms
|
|
Speed: 0.271 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1988
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1989
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1990
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1991
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1992
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 705
Speed: 0.270 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 = 7 ORDER BY s.seq0
Speed: 0.274 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 = 7 ORDER BY g.seq0
Speed: 0.642 ms
|
|
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1993
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1994
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1995
Speed: 0.257 ms
|
|
SELECT * FROM article_settings WHERE article_id = 706
Speed: 0.268 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 = 7 ORDER BY s.seq0
Speed: 0.276 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 = 7 ORDER BY g.seq0
Speed: 0.624 ms
|
|
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1996
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 707
Speed: 0.269 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 = 7 ORDER BY s.seq0
Speed: 0.273 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 = 7 ORDER BY g.seq0
Speed: 0.724 ms
|
|
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1997
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 708
Speed: 0.266 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 = 7 ORDER BY s.seq0
Speed: 0.275 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 = 7 ORDER BY g.seq0
Speed: 0.680 ms
|
|
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1998
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1999
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2000
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2001
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 709
Speed: 0.270 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 = 7 ORDER BY s.seq0
Speed: 0.261 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 = 7 ORDER BY g.seq1
Speed: 0.640 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2002
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 710
Speed: 0.265 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 = 7 ORDER BY s.seq1
Speed: 0.270 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 = 7 ORDER BY g.seq1
Speed: 0.690 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2003
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2004
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2005
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 711
Speed: 0.265 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 = 7 ORDER BY s.seq1
Speed: 0.264 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 = 7 ORDER BY g.seq1
Speed: 0.646 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2006
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2007
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2008
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2009
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 712
Speed: 0.266 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 = 7 ORDER BY s.seq1
Speed: 0.271 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 = 7 ORDER BY g.seq1
Speed: 0.626 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2010
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2011
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2012
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 713
Speed: 0.278 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 = 7 ORDER BY s.seq1
Speed: 0.266 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 = 7 ORDER BY g.seq1
Speed: 0.632 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2013
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 714
Speed: 0.279 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 = 7 ORDER BY s.seq1
Speed: 0.274 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 = 7 ORDER BY g.seq1
Speed: 0.704 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2014
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2015
Speed: 0.263 ms
|
|
SELECT * FROM article_settings WHERE article_id = 715
Speed: 0.264 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 = 7 ORDER BY s.seq1
Speed: 0.264 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 = 7 ORDER BY g.seq1
Speed: 0.640 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2016
Speed: 0.259 ms
|
|
SELECT * FROM article_settings WHERE article_id = 716
Speed: 0.263 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 = 7 ORDER BY s.seq1
Speed: 0.269 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 = 7 ORDER BY g.seq1
Speed: 0.619 ms
|
|
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2017
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2018
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2019
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2020
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 717
Speed: 0.265 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 = 7 ORDER BY s.seq1
Speed: 0.274 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 = 7 ORDER BY g.seq1
Speed: 0.680 ms
|
|
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2021
Speed: 0.263 ms
|
|
SELECT * FROM article_settings WHERE article_id = 718
Speed: 0.265 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 = 7 ORDER BY s.seq1
Speed: 0.275 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 = 7 ORDER BY g.seq1
Speed: 0.709 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2022
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2023
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 719
Speed: 0.264 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 = 7 ORDER BY s.seq1
Speed: 0.267 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 = 7 ORDER BY g.seq2
Speed: 0.792 ms
|
|
Speed: 0.271 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2024
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2025
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 720
Speed: 0.270 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 = 7 ORDER BY s.seq2
Speed: 0.273 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 = 7 ORDER BY g.seq2
Speed: 0.644 ms
|
|
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2026
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2027
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 721
Speed: 0.269 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 = 7 ORDER BY s.seq2
Speed: 0.271 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 = 7 ORDER BY g.seq2
Speed: 0.687 ms
|
|
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2028
Speed: 0.265 ms
|
|
SELECT * FROM article_settings WHERE article_id = 722
Speed: 0.269 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 = 7 ORDER BY s.seq2
Speed: 0.273 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 = 7 ORDER BY g.seq2
Speed: 0.667 ms
|
|
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2029
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 723
Speed: 0.270 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 = 7 ORDER BY s.seq2
Speed: 0.272 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 = 7 ORDER BY g.seq2
Speed: 0.667 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2030
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 724
Speed: 0.267 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 = 7 ORDER BY s.seq2
Speed: 0.274 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 = 7 ORDER BY g.seq2
Speed: 0.293 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2031
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2032
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2033
Speed: 0.263 ms
|
|
SELECT * FROM article_settings WHERE article_id = 725
Speed: 0.270 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 = 7 ORDER BY s.seq2
Speed: 0.271 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 = 7 ORDER BY g.seq2
Speed: 0.653 ms
|
|
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2034
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2035
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 726
Speed: 0.267 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 = 7 ORDER BY s.seq2
Speed: 0.273 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.271 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: 1.500 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.983 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(38.107.179.229, LENGTH(38.107.179.229)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.706 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592613 >= isip.ip_start AND 644592613 <= 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 ('2012-02-09 22:38:01' >= s.date_start AND '2012-02-09 22:38:01' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592613 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.842 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.297 ms
|
|
UPDATE plugin_settings SET
setting_value = 1,
setting_type = bool
WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.524 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.258 ms
|