|
SELECT * FROM sessions WHERE session_id = 3c24de2bbbc9e2462d6e2d33766976a2
Speed: 0.729 ms
|
|
DELETE FROM sessions WHERE session_id = 3c24de2bbbc9e2462d6e2d33766976a2
Speed: 0.947 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(3c24de2bbbc9e2462d6e2d33766976a2, 38.107.179.229, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1329968414, 1329968414, 0, , 0
Speed: 0.433 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.254 ms
|
|
Speed: 0.237 ms
|
|
Speed: 0.309 ms
|
|
Speed: 0.420 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 35
Speed: 0.270 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 = 35)
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 = 35
Speed: 21.471 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: 117.894 ms
|
|
Speed: 0.282 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2869
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2868
Speed: 0.256 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1049
Speed: 0.271 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.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 = 1 ORDER BY g.seq0
Speed: 0.664 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2842
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2843
Speed: 0.257 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1041
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.661 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2788
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1018
Speed: 0.255 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.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 = 1 ORDER BY g.seq0
Speed: 0.626 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2800
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2801
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2799
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1024
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 = 1 ORDER BY s.seq0
Speed: 0.256 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.631 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2833
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1037
Speed: 0.252 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.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 = 1 ORDER BY g.seq0
Speed: 0.625 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2771
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1010
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 = 1 ORDER BY s.seq0
Speed: 0.255 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.615 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2857
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2856
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2858
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2855
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1046
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.618 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2755
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2756
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2757
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1005
Speed: 0.254 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.262 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.626 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2776
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2779
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2780
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2781
Speed: 0.256 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1013
Speed: 0.255 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.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 = 1 ORDER BY g.seq0
Speed: 0.625 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2823
Speed: 0.247 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1033
Speed: 0.253 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.254 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.645 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2845
Speed: 0.248 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1043
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.631 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2754
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1004
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.619 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2846
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2847
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2848
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1044
Speed: 0.254 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.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 = 9 ORDER BY g.seq9
Speed: 0.627 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2747
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 997
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 = 9 ORDER BY s.seq9
Speed: 0.262 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.seq9
Speed: 0.625 ms
|
|
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2746
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2853
Speed: 0.555 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2854
Speed: 0.300 ms
|
|
SELECT * FROM article_settings WHERE article_id = 996
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 = 9 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 = 1 ORDER BY g.seq0
Speed: 1.039 ms
|
|
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2770
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2769
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1009
Speed: 0.254 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.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 = 1 ORDER BY g.seq0
Speed: 0.945 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2820
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2819
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2821
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2822
Speed: 0.281 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1032
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.704 ms
|
|
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2760
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2761
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2762
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2763
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2764
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2765
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2766
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2767
Speed: 0.259 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1007
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 = 1 ORDER BY s.seq0
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 = 9 ORDER BY g.seq9
Speed: 0.758 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2744
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2863
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2864
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 994
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 = 9 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 = 1 ORDER BY g.seq0
Speed: 0.647 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2752
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2862
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1002
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 = 1 ORDER BY s.seq0
Speed: 0.262 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.632 ms
|
|
Speed: 0.416 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2758
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2759
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1006
Speed: 0.272 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.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 = 1 ORDER BY g.seq0
Speed: 0.671 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2768
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1008
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 = 1 ORDER BY s.seq0
Speed: 0.262 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.632 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2784
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2865
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2866
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2867
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1015
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 = 1 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 = 1 ORDER BY g.seq0
Speed: 0.614 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2785
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2786
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2861
Speed: 0.257 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1016
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 = 1 ORDER BY s.seq0
Speed: 0.284 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 8
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 = 1 ORDER BY g.seq0
Speed: 0.658 ms
|
|
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2794
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2795
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2793
Speed: 0.273 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1022
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 = 1 ORDER BY s.seq0
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 = 1 ORDER BY g.seq0
Speed: 0.289 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2816
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2817
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2818
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1031
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 = 1 ORDER BY s.seq0
Speed: 0.280 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 10
Speed: 0.254 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.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
Speed: 1.560 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.991 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.837 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-23 12:40:15' >= s.date_start AND '2012-02-23 12:40:15' <= 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.855 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.306 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.591 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.265 ms
|