|
SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.736 ms
|
|
DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.427 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), 1328795797, 1328795797, 0, , 0
Speed: 0.435 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.255 ms
|
|
Speed: 0.226 ms
|
|
Speed: 0.306 ms
|
|
Speed: 0.542 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 29
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 = 29)
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 = 29
Speed: 6.248 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: 14.739 ms
|
|
Speed: 0.484 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2345
Speed: 0.505 ms
|
|
SELECT * FROM article_settings WHERE article_id = 834
Speed: 0.513 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.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.seq3
Speed: 0.606 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2346
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2347
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2348
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2349
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 835
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 = 8 ORDER BY s.seq3
Speed: 0.251 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.614 ms
|
|
Speed: 0.478 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2350
Speed: 0.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2351
Speed: 0.496 ms
|
|
SELECT * FROM article_settings WHERE article_id = 836
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.seq3
Speed: 0.541 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.611 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2352
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2353
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 837
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 = 8 ORDER BY s.seq3
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 = 8 ORDER BY g.seq3
Speed: 0.625 ms
|
|
Speed: 0.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2354
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2355
Speed: 0.486 ms
|
|
SELECT * FROM article_settings WHERE article_id = 838
Speed: 0.491 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.549 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.613 ms
|
|
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2356
Speed: 0.495 ms
|
|
SELECT * FROM article_settings WHERE article_id = 839
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.seq3
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.seq4
Speed: 0.609 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2357
Speed: 0.246 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2358
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2359
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2360
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 840
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 = 8 ORDER BY s.seq4
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 = 8 ORDER BY g.seq4
Speed: 0.666 ms
|
|
Speed: 0.549 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2361
Speed: 0.510 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2362
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2363
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2364
Speed: 0.498 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2365
Speed: 0.505 ms
|
|
SELECT * FROM article_settings WHERE article_id = 841
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 = 8 ORDER BY s.seq4
Speed: 0.548 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.seq4
Speed: 0.604 ms
|
|
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2366
Speed: 0.495 ms
|
|
SELECT * FROM article_settings WHERE article_id = 842
Speed: 0.553 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.seq4
Speed: 0.544 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.seq4
Speed: 0.617 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2367
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2368
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2369
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 843
Speed: 0.260 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 8 ORDER BY s.seq4
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 = 8 ORDER BY g.seq4
Speed: 0.619 ms
|
|
Speed: 0.461 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2370
Speed: 0.456 ms
|
|
SELECT * FROM article_settings WHERE article_id = 844
Speed: 0.512 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.seq4
Speed: 0.579 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.seq4
Speed: 0.616 ms
|
|
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2371
Speed: 0.246 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2372
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2373
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 845
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 = 8 ORDER BY s.seq4
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 = 8 ORDER BY g.seq4
Speed: 0.618 ms
|
|
Speed: 0.548 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2374
Speed: 0.465 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2375
Speed: 0.493 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2376
Speed: 0.460 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2377
Speed: 0.454 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2378
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2379
Speed: 0.463 ms
|
|
SELECT * FROM article_settings WHERE article_id = 846
Speed: 0.511 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.seq4
Speed: 0.542 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.seq4
Speed: 0.665 ms
|
|
Speed: 0.536 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2380
Speed: 0.465 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2381
Speed: 0.460 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2382
Speed: 0.464 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2383
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2384
Speed: 0.465 ms
|
|
SELECT * FROM article_settings WHERE article_id = 847
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 = 8 ORDER BY s.seq4
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 = 8 ORDER BY g.seq4
Speed: 0.618 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2385
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2386
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2387
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2388
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 848
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 = 8 ORDER BY s.seq4
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 = 8 ORDER BY g.seq4
Speed: 0.611 ms
|
|
Speed: 0.576 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2389
Speed: 0.490 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2390
Speed: 0.492 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2391
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2392
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2393
Speed: 0.476 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2394
Speed: 0.488 ms
|
|
SELECT * FROM article_settings WHERE article_id = 849
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.seq4
Speed: 0.562 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.seq5
Speed: 0.623 ms
|
|
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2395
Speed: 0.245 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2396
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2397
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2398
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 850
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 = 8 ORDER BY s.seq5
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 = 8 ORDER BY g.seq5
Speed: 0.666 ms
|
|
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2399
Speed: 0.489 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2400
Speed: 0.486 ms
|
|
SELECT * FROM article_settings WHERE article_id = 851
Speed: 0.538 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.seq5
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.seq5
Speed: 0.641 ms
|
|
Speed: 0.515 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2401
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2402
Speed: 0.505 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2403
Speed: 0.497 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2404
Speed: 0.499 ms
|
|
SELECT * FROM article_settings WHERE article_id = 852
Speed: 0.463 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.seq5
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 = 8 ORDER BY g.seq5
Speed: 0.627 ms
|
|
Speed: 0.489 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2405
Speed: 0.512 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2406
Speed: 0.498 ms
|
|
SELECT * FROM article_settings WHERE article_id = 853
Speed: 0.478 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.seq5
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 = 8 ORDER BY g.seq5
Speed: 0.612 ms
|
|
Speed: 0.526 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2407
Speed: 0.505 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2408
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2409
Speed: 0.503 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2410
Speed: 0.520 ms
|
|
SELECT * FROM article_settings WHERE article_id = 854
Speed: 0.492 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.seq5
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 = 8 ORDER BY g.seq5
Speed: 0.612 ms
|
|
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2411
Speed: 0.513 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2412
Speed: 0.492 ms
|
|
SELECT * FROM article_settings WHERE article_id = 855
Speed: 0.465 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.seq5
Speed: 0.549 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.seq5
Speed: 0.606 ms
|
|
Speed: 0.516 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2413
Speed: 0.464 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2414
Speed: 0.442 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2415
Speed: 0.441 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2416
Speed: 0.448 ms
|
|
SELECT * FROM article_settings WHERE article_id = 856
Speed: 0.473 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.seq5
Speed: 0.543 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.seq5
Speed: 0.614 ms
|
|
Speed: 0.501 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2417
Speed: 0.449 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2418
Speed: 0.437 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2419
Speed: 0.450 ms
|
|
SELECT * FROM article_settings WHERE article_id = 857
Speed: 0.530 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.seq5
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 = 8 ORDER BY g.seq5
Speed: 0.626 ms
|
|
Speed: 0.482 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2420
Speed: 0.456 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2421
Speed: 0.450 ms
|
|
SELECT * FROM article_settings WHERE article_id = 858
Speed: 0.480 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.seq5
Speed: 0.548 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.seq5
Speed: 0.631 ms
|
|
Speed: 0.493 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2422
Speed: 0.453 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2423
Speed: 0.445 ms
|
|
SELECT * FROM article_settings WHERE article_id = 859
Speed: 0.534 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.seq5
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 = 8 ORDER BY g.seq6
Speed: 0.624 ms
|
|
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2424
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2425
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 860
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 = 8 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 = 8 ORDER BY g.seq6
Speed: 0.661 ms
|
|
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2426
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2427
Speed: 0.248 ms
|
|
SELECT * FROM article_settings WHERE article_id = 861
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 = 8 ORDER BY s.seq6
Speed: 0.262 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.248 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.389 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.385 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.701 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:56:37' >= s.date_start AND '2012-02-09 22:56:37' <= 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.892 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.301 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.530 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.272 ms
|