|
SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.859 ms
|
|
DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.977 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), 1328795413, 1328795413, 0, , 0
Speed: 0.442 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.255 ms
|
|
Speed: 0.226 ms
|
|
Speed: 0.307 ms
|
|
Speed: 0.561 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 28
Speed: 0.262 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 = 28)
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 = 28
Speed: 34.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 = 7 ORDER BY g.seq9
Speed: 18.275 ms
|
|
Speed: 0.508 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2244
Speed: 0.526 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2245
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 795
Speed: 0.548 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.555 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.647 ms
|
|
Speed: 0.453 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2246
Speed: 0.437 ms
|
|
SELECT * FROM article_settings WHERE article_id = 796
Speed: 0.476 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.531 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.599 ms
|
|
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2247
Speed: 0.225 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2248
Speed: 0.225 ms
|
|
SELECT * FROM article_settings WHERE article_id = 797
Speed: 0.228 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.236 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.594 ms
|
|
Speed: 0.497 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2249
Speed: 0.432 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2250
Speed: 0.423 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2251
Speed: 0.436 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2252
Speed: 0.439 ms
|
|
SELECT * FROM article_settings WHERE article_id = 798
Speed: 0.451 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq9
Speed: 0.518 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.594 ms
|
|
Speed: 0.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2253
Speed: 0.224 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2254
Speed: 0.224 ms
|
|
SELECT * FROM article_settings WHERE article_id = 799
Speed: 0.232 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.235 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 = 8 ORDER BY g.seq0
Speed: 0.602 ms
|
|
Speed: 0.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2255
Speed: 0.225 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2256
Speed: 0.226 ms
|
|
SELECT * FROM article_settings WHERE article_id = 800
Speed: 0.227 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 = 8 ORDER BY s.seq0
Speed: 0.230 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 = 8 ORDER BY g.seq0
Speed: 0.588 ms
|
|
Speed: 0.480 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2257
Speed: 0.442 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2258
Speed: 0.432 ms
|
|
SELECT * FROM article_settings WHERE article_id = 801
Speed: 0.458 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 = 8 ORDER BY s.seq0
Speed: 0.531 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 = 8 ORDER BY g.seq0
Speed: 0.598 ms
|
|
Speed: 0.236 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2259
Speed: 0.226 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2260
Speed: 0.225 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2261
Speed: 0.227 ms
|
|
SELECT * FROM article_settings WHERE article_id = 802
Speed: 0.236 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 = 8 ORDER BY s.seq0
Speed: 0.230 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 = 8 ORDER BY g.seq0
Speed: 0.623 ms
|
|
Speed: 0.489 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2262
Speed: 0.451 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2263
Speed: 0.439 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2264
Speed: 0.451 ms
|
|
SELECT * FROM article_settings WHERE article_id = 803
Speed: 0.483 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 = 8 ORDER BY s.seq0
Speed: 0.526 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 = 8 ORDER BY g.seq0
Speed: 0.622 ms
|
|
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2265
Speed: 0.227 ms
|
|
SELECT * FROM article_settings WHERE article_id = 804
Speed: 0.230 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 = 8 ORDER BY s.seq0
Speed: 0.230 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 = 8 ORDER BY g.seq0
Speed: 0.596 ms
|
|
Speed: 0.234 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2266
Speed: 0.227 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2267
Speed: 0.228 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2268
Speed: 0.229 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2269
Speed: 0.226 ms
|
|
SELECT * FROM article_settings WHERE article_id = 805
Speed: 0.232 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 = 8 ORDER BY s.seq0
Speed: 0.236 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 = 8 ORDER BY g.seq0
Speed: 0.602 ms
|
|
Speed: 0.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2270
Speed: 0.223 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2271
Speed: 0.224 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2272
Speed: 0.226 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2273
Speed: 0.236 ms
|
|
SELECT * FROM article_settings WHERE article_id = 806
Speed: 0.236 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 = 8 ORDER BY s.seq0
Speed: 0.235 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 = 8 ORDER BY g.seq0
Speed: 0.597 ms
|
|
Speed: 0.478 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2274
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2275
Speed: 0.475 ms
|
|
SELECT * FROM article_settings WHERE article_id = 807
Speed: 0.544 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 = 8 ORDER BY s.seq0
Speed: 0.530 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 = 8 ORDER BY g.seq0
Speed: 0.603 ms
|
|
Speed: 0.510 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2276
Speed: 0.471 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2277
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2278
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2279
Speed: 0.507 ms
|
|
SELECT * FROM article_settings WHERE article_id = 808
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 = 8 ORDER BY s.seq0
Speed: 0.533 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 = 8 ORDER BY g.seq0
Speed: 0.602 ms
|
|
Speed: 0.244 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2280
Speed: 0.236 ms
|
|
SELECT * FROM article_settings WHERE article_id = 809
Speed: 0.238 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 = 8 ORDER BY s.seq0
Speed: 0.234 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 = 8 ORDER BY g.seq1
Speed: 0.643 ms
|
|
Speed: 0.500 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2281
Speed: 0.444 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2282
Speed: 0.449 ms
|
|
SELECT * FROM article_settings WHERE article_id = 810
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 = 8 ORDER BY s.seq1
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 = 8 ORDER BY g.seq1
Speed: 0.598 ms
|
|
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2283
Speed: 0.448 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2284
Speed: 0.458 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2285
Speed: 0.446 ms
|
|
SELECT * FROM article_settings WHERE article_id = 811
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 = 8 ORDER BY s.seq1
Speed: 0.535 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 = 8 ORDER BY g.seq1
Speed: 0.599 ms
|
|
Speed: 0.525 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2286
Speed: 0.455 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2287
Speed: 0.448 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2288
Speed: 0.455 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2289
Speed: 0.446 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2290
Speed: 0.460 ms
|
|
SELECT * FROM article_settings WHERE article_id = 812
Speed: 0.494 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 = 8 ORDER BY s.seq1
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 = 8 ORDER BY g.seq1
Speed: 0.957 ms
|
|
Speed: 0.324 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2291
Speed: 0.275 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2292
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2293
Speed: 0.276 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2294
Speed: 0.268 ms
|
|
SELECT * FROM article_settings WHERE article_id = 813
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 = 8 ORDER BY s.seq1
Speed: 0.278 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 = 8 ORDER BY g.seq1
Speed: 1.681 ms
|
|
Speed: 0.958 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2295
Speed: 0.868 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2296
Speed: 0.822 ms
|
|
SELECT * FROM article_settings WHERE article_id = 814
Speed: 0.927 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 = 8 ORDER BY s.seq1
Speed: 0.931 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 = 8 ORDER BY g.seq1
Speed: 0.683 ms
|
|
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2297
Speed: 0.267 ms
|
|
SELECT * FROM article_settings WHERE article_id = 815
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 = 8 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 = 8 ORDER BY g.seq1
Speed: 0.656 ms
|
|
Speed: 0.557 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2298
Speed: 0.513 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2299
Speed: 0.494 ms
|
|
SELECT * FROM article_settings WHERE article_id = 816
Speed: 0.536 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 = 8 ORDER BY s.seq1
Speed: 0.569 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 = 8 ORDER BY g.seq1
Speed: 0.645 ms
|
|
Speed: 0.277 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2300
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 817
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 = 8 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 = 8 ORDER BY g.seq1
Speed: 0.695 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2301
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 818
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 = 8 ORDER BY s.seq1
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 = 8 ORDER BY g.seq1
Speed: 0.646 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2302
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 819
Speed: 0.276 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 = 8 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 = 8 ORDER BY g.seq2
Speed: 0.644 ms
|
|
Speed: 0.514 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2303
Speed: 0.520 ms
|
|
SELECT * FROM article_settings WHERE article_id = 820
Speed: 0.558 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 = 8 ORDER BY s.seq2
Speed: 0.581 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 = 8 ORDER BY g.seq2
Speed: 0.636 ms
|
|
Speed: 0.274 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2304
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2305
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2306
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2307
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2308
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2309
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 821
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 = 8 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 = 8 ORDER BY g.seq2
Speed: 0.633 ms
|
|
Speed: 0.272 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2310
Speed: 0.271 ms
|
|
SELECT * FROM article_settings WHERE article_id = 822
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 = 8 ORDER BY s.seq2
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 = 8 ORDER BY g.seq2
Speed: 0.652 ms
|
|
Speed: 0.523 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2312
Speed: 0.530 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2314
Speed: 0.508 ms
|
|
SELECT * FROM article_settings WHERE article_id = 823
Speed: 0.649 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 = 8 ORDER BY s.seq2
Speed: 0.585 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 = 8 ORDER BY g.seq2
Speed: 0.636 ms
|
|
Speed: 0.529 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2315
Speed: 0.516 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2316
Speed: 0.505 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2317
Speed: 0.513 ms
|
|
SELECT * FROM article_settings WHERE article_id = 824
Speed: 0.496 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 = 8 ORDER BY s.seq2
Speed: 0.576 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 = 8 ORDER BY g.seq2
Speed: 0.638 ms
|
|
Speed: 0.531 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2318
Speed: 0.521 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2319
Speed: 0.519 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2320
Speed: 0.507 ms
|
|
SELECT * FROM article_settings WHERE article_id = 825
Speed: 0.555 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 = 8 ORDER BY s.seq2
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 = 8 ORDER BY g.seq2
Speed: 0.653 ms
|
|
Speed: 0.274 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2321
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2322
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 826
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 = 8 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 = 8 ORDER BY g.seq2
Speed: 0.635 ms
|
|
Speed: 0.618 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2323
Speed: 0.540 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2324
Speed: 0.532 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2325
Speed: 0.544 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2326
Speed: 0.467 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2327
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2328
Speed: 0.475 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2329
Speed: 0.474 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2330
Speed: 0.478 ms
|
|
SELECT * FROM article_settings WHERE article_id = 827
Speed: 0.581 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 = 8 ORDER BY s.seq2
Speed: 0.619 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 = 8 ORDER BY g.seq2
Speed: 0.661 ms
|
|
Speed: 0.552 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2331
Speed: 0.494 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2332
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2333
Speed: 0.511 ms
|
|
SELECT * FROM article_settings WHERE article_id = 828
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 = 8 ORDER BY s.seq2
Speed: 0.593 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 = 8 ORDER BY g.seq2
Speed: 0.665 ms
|
|
Speed: 0.277 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2334
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2335
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2336
Speed: 0.272 ms
|
|
SELECT * FROM article_settings WHERE article_id = 829
Speed: 0.275 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 = 8 ORDER BY s.seq2
Speed: 0.282 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 = 8 ORDER BY g.seq3
Speed: 0.726 ms
|
|
Speed: 0.278 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2337
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2338
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2339
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2340
Speed: 0.288 ms
|
|
SELECT * FROM article_settings WHERE article_id = 830
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 = 8 ORDER BY s.seq3
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 = 8 ORDER BY g.seq3
Speed: 0.791 ms
|
|
Speed: 0.558 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2341
Speed: 0.543 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2342
Speed: 0.788 ms
|
|
SELECT * FROM article_settings WHERE article_id = 831
Speed: 0.611 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 = 8 ORDER BY s.seq3
Speed: 0.720 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 = 8 ORDER BY g.seq3
Speed: 0.755 ms
|
|
Speed: 0.591 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2343
Speed: 0.547 ms
|
|
SELECT * FROM article_settings WHERE article_id = 832
Speed: 0.544 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 = 8 ORDER BY s.seq3
Speed: 1.141 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 = 8 ORDER BY g.seq3
Speed: 1.138 ms
|
|
Speed: 0.819 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2344
Speed: 0.613 ms
|
|
SELECT * FROM article_settings WHERE article_id = 833
Speed: 0.515 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 = 8 ORDER BY s.seq3
Speed: 0.563 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.273 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.572 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.995 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.766 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:50:14' >= s.date_start AND '2012-02-09 22:50:14' <= 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.915 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.358 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.556 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.269 ms
|