|
SELECT * FROM sessions WHERE session_id = 42de48e2e3e6f518b2d4e7e7e48b030d
Speed: 0.532 ms
|
|
DELETE FROM sessions WHERE session_id = 42de48e2e3e6f518b2d4e7e7e48b030d
Speed: 0.744 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(42de48e2e3e6f518b2d4e7e7e48b030d, 38.107.179.228, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1337717485, 1337717485, 0, , 0
Speed: 0.430 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.259 ms
|
|
Speed: 0.231 ms
|
|
Speed: 0.312 ms
|
|
Speed: 0.598 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 163
Speed: 0.267 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 = 163)
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 = 163
Speed: 12.480 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 = 3 ORDER BY g.seq6
Speed: 0.291 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9853
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9854
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9855
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3619
Speed: 0.288 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.272 ms
|
|
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9856
Speed: 0.275 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9857
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3620
Speed: 0.273 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 = 3 ORDER BY s.seq6
Speed: 0.259 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 = 3 ORDER BY g.seq6
Speed: 0.279 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9858
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9859
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9860
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3621
Speed: 0.250 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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.276 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9861
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9862
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9863
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9864
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3622
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.273 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9865
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9866
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9867
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9868
Speed: 0.257 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3623
Speed: 0.250 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.273 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9869
Speed: 0.278 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9870
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9871
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3624
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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.277 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9872
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9873
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3625
Speed: 0.250 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9874
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9875
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9876
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9877
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9878
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9879
Speed: 0.267 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3626
Speed: 0.249 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.273 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9880
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9881
Speed: 0.257 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3627
Speed: 0.250 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9882
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3628
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9883
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9884
Speed: 0.268 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3629
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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9885
Speed: 0.260 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3630
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.280 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9886
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3631
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.276 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9887
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9888
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9889
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9890
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3632
Speed: 0.249 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9891
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3633
Speed: 0.251 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.276 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9892
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9893
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9894
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9895
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3634
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9896
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9897
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9898
Speed: 0.256 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3635
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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9899
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9900
Speed: 0.259 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3636
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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.276 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9901
Speed: 0.275 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9902
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9903
Speed: 0.263 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3637
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9904
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9905
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9906
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3638
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9907
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9908
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9909
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3639
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.277 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9910
Speed: 0.256 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3640
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 = 3 ORDER BY s.seq6
Speed: 0.253 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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9911
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9912
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9913
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3641
Speed: 0.250 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9914
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9915
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9916
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3642
Speed: 0.251 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 = 3 ORDER BY s.seq6
Speed: 0.252 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 = 3 ORDER BY g.seq6
Speed: 0.277 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9917
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9918
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9919
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3643
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 = 3 ORDER BY s.seq6
Speed: 0.252 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 = 3 ORDER BY g.seq6
Speed: 0.276 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9920
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9921
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9922
Speed: 0.267 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3644
Speed: 0.249 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.284 ms
|
|
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9923
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3645
Speed: 0.249 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 = 3 ORDER BY s.seq6
Speed: 0.252 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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9924
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9925
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9926
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9927
Speed: 0.256 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3646
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.275 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9928
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9929
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9930
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9931
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9932
Speed: 0.271 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3647
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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9933
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9934
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3648
Speed: 0.249 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 = 3 ORDER BY s.seq6
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 = 3 ORDER BY g.seq6
Speed: 0.274 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 9935
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 3649
Speed: 0.250 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 = 3 ORDER BY s.seq6
Speed: 0.261 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.249 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.741 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: 1.011 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.228, LENGTH(38.107.179.228)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 1.357 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592612 >= isip.ip_start AND 644592612 <= 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-05-23 05:11:25' >= s.date_start AND '2012-05-23 05:11:25' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592612 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.928 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.309 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.529 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.266 ms
|