|
SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.849 ms
|
|
DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 1.003 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(a5ce42b1641fd6a1b36e7b445fa955c7, 38.107.179.230, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1328795182, 1328795182, 0, , 0
Speed: 0.446 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.258 ms
|
|
Speed: 0.227 ms
|
|
Speed: 0.308 ms
|
|
Speed: 0.570 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 27
Speed: 0.263 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 = 27)
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 = 27
Speed: 6.805 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.seq6
Speed: 27.205 ms
|
|
Speed: 0.501 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2168
Speed: 0.494 ms
|
|
SELECT * FROM article_settings WHERE article_id = 763
Speed: 0.520 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.seq6
Speed: 0.564 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.seq6
Speed: 0.644 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2169
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2170
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 764
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 = 7 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 = 7 ORDER BY g.seq6
Speed: 0.620 ms
|
|
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2171
Speed: 0.462 ms
|
|
SELECT * FROM article_settings WHERE article_id = 765
Speed: 0.519 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.seq6
Speed: 0.553 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.seq6
Speed: 0.610 ms
|
|
Speed: 0.467 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2172
Speed: 0.468 ms
|
|
SELECT * FROM article_settings WHERE article_id = 766
Speed: 0.504 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.seq6
Speed: 0.546 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.seq6
Speed: 0.612 ms
|
|
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2173
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2174
Speed: 0.474 ms
|
|
SELECT * FROM article_settings WHERE article_id = 767
Speed: 0.519 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.seq6
Speed: 0.559 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.seq6
Speed: 0.620 ms
|
|
Speed: 0.495 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2175
Speed: 0.470 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2176
Speed: 0.474 ms
|
|
SELECT * FROM article_settings WHERE article_id = 768
Speed: 0.517 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.seq6
Speed: 0.550 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.seq6
Speed: 0.627 ms
|
|
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2177
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2178
Speed: 0.482 ms
|
|
SELECT * FROM article_settings WHERE article_id = 769
Speed: 0.486 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.seq6
Speed: 0.571 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.seq7
Speed: 0.620 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2179
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2180
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2181
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 770
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 = 7 ORDER BY s.seq7
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 = 7 ORDER BY g.seq7
Speed: 0.612 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2182
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 771
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 = 7 ORDER BY s.seq7
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 = 7 ORDER BY g.seq7
Speed: 0.648 ms
|
|
Speed: 0.484 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2183
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2184
Speed: 0.482 ms
|
|
SELECT * FROM article_settings WHERE article_id = 772
Speed: 0.470 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.seq7
Speed: 0.558 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.seq7
Speed: 0.629 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2185
Speed: 0.245 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2186
Speed: 0.247 ms
|
|
SELECT * FROM article_settings WHERE article_id = 773
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 = 7 ORDER BY s.seq7
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 = 7 ORDER BY g.seq7
Speed: 0.610 ms
|
|
Speed: 0.536 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2187
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2188
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2189
Speed: 0.488 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2190
Speed: 0.478 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2191
Speed: 0.492 ms
|
|
SELECT * FROM article_settings WHERE article_id = 774
Speed: 0.488 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq7
Speed: 0.547 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.seq7
Speed: 0.619 ms
|
|
Speed: 0.472 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2192
Speed: 0.486 ms
|
|
SELECT * FROM article_settings WHERE article_id = 775
Speed: 0.485 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.seq7
Speed: 0.556 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.seq7
Speed: 0.631 ms
|
|
Speed: 0.505 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2193
Speed: 0.491 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2194
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2195
Speed: 0.495 ms
|
|
SELECT * FROM article_settings WHERE article_id = 776
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 = 7 ORDER BY s.seq7
Speed: 0.540 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.seq7
Speed: 0.614 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2196
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2197
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2198
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 777
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 = 7 ORDER BY s.seq7
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 = 7 ORDER BY g.seq7
Speed: 0.626 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2199
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2200
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2201
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 778
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 = 7 ORDER BY s.seq7
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 = 7 ORDER BY g.seq7
Speed: 0.615 ms
|
|
Speed: 0.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2202
Speed: 0.517 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2203
Speed: 0.469 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2204
Speed: 0.457 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2205
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 779
Speed: 0.493 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq7
Speed: 0.538 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.seq8
Speed: 0.645 ms
|
|
Speed: 0.488 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2206
Speed: 0.458 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2207
Speed: 0.456 ms
|
|
SELECT * FROM article_settings WHERE article_id = 780
Speed: 0.484 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq8
Speed: 0.550 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.seq8
Speed: 0.625 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2208
Speed: 0.243 ms
|
|
SELECT * FROM article_settings WHERE article_id = 781
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 = 7 ORDER BY s.seq8
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 = 7 ORDER BY g.seq8
Speed: 0.669 ms
|
|
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2209
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2210
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 782
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.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 = 7 ORDER BY g.seq8
Speed: 0.638 ms
|
|
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2211
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2212
Speed: 0.466 ms
|
|
SELECT * FROM article_settings WHERE article_id = 783
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 = 7 ORDER BY s.seq8
Speed: 0.563 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.seq8
Speed: 0.667 ms
|
|
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2213
Speed: 0.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2214
Speed: 0.466 ms
|
|
SELECT * FROM article_settings WHERE article_id = 784
Speed: 0.509 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.seq8
Speed: 0.546 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.seq8
Speed: 0.616 ms
|
|
Speed: 0.546 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2215
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2216
Speed: 0.472 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2217
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2218
Speed: 0.463 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2219
Speed: 0.497 ms
|
|
SELECT * FROM article_settings WHERE article_id = 785
Speed: 0.517 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.seq8
Speed: 0.545 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.seq8
Speed: 0.617 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2220
Speed: 0.281 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2221
Speed: 0.274 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2222
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2223
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2224
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2225
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 786
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 = 7 ORDER BY s.seq8
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 = 7 ORDER BY g.seq8
Speed: 1.093 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2226
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2227
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2228
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 787
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 = 7 ORDER BY s.seq8
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.seq8
Speed: 0.799 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2229
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2230
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2231
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2232
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2233
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 788
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 = 7 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 = 7 ORDER BY g.seq8
Speed: 0.648 ms
|
|
Speed: 0.502 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2234
Speed: 0.523 ms
|
|
SELECT * FROM article_settings WHERE article_id = 789
Speed: 0.591 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.seq8
Speed: 0.572 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.seq9
Speed: 0.635 ms
|
|
Speed: 1.367 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2235
Speed: 0.595 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2236
Speed: 0.493 ms
|
|
SELECT * FROM article_settings WHERE article_id = 790
Speed: 0.784 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.seq9
Speed: 0.672 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.seq9
Speed: 0.679 ms
|
|
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2237
Speed: 0.544 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2238
Speed: 0.579 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2239
Speed: 0.566 ms
|
|
SELECT * FROM article_settings WHERE article_id = 791
Speed: 0.514 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.seq9
Speed: 0.551 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.seq9
Speed: 0.698 ms
|
|
Speed: 0.541 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2240
Speed: 0.670 ms
|
|
SELECT * FROM article_settings WHERE article_id = 792
Speed: 0.521 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq9
Speed: 0.670 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.seq9
Speed: 0.669 ms
|
|
Speed: 0.534 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2241
Speed: 0.622 ms
|
|
SELECT * FROM article_settings WHERE article_id = 793
Speed: 0.596 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.seq9
Speed: 0.565 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.seq9
Speed: 0.628 ms
|
|
Speed: 0.271 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2242
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2243
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 794
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.seq9
Speed: 0.274 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.264 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: 0.396 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.383 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.230, LENGTH(38.107.179.230)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.741 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592614 >= isip.ip_start AND 644592614 <= 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:46:23' >= s.date_start AND '2012-02-09 22:46:23' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592614 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.887 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.305 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.559 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.267 ms
|