|
SELECT * FROM sessions WHERE session_id = 42de48e2e3e6f518b2d4e7e7e48b030d
Speed: 0.757 ms
|
|
DELETE FROM sessions WHERE session_id = 42de48e2e3e6f518b2d4e7e7e48b030d
Speed: 1.188 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(42de48e2e3e6f518b2d4e7e7e48b030d, 38.107.179.229, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1337717514, 1337717514, 0, , 0
Speed: 0.445 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.255 ms
|
|
Speed: 0.242 ms
|
|
Speed: 0.320 ms
|
|
Speed: 0.418 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 32
Speed: 0.269 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 = 32)
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 = 32
Speed: 14.213 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 73.114 ms
|
|
Speed: 0.282 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2565
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2566
Speed: 0.243 ms
|
|
SELECT * FROM article_settings WHERE article_id = 913
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 = 9 ORDER BY s.seq1
Speed: 0.240 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 0.257 ms
|
|
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2567
Speed: 0.236 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2568
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2569
Speed: 0.235 ms
|
|
SELECT * FROM article_settings WHERE article_id = 914
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 = 9 ORDER BY s.seq1
Speed: 0.231 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 0.255 ms
|
|
Speed: 0.234 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2570
Speed: 0.245 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2571
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 915
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 = 9 ORDER BY s.seq1
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 = 9 ORDER BY g.seq1
Speed: 0.713 ms
|
|
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2572
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2573
Speed: 0.240 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2574
Speed: 0.233 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2575
Speed: 0.234 ms
|
|
SELECT * FROM article_settings WHERE article_id = 916
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 = 9 ORDER BY s.seq1
Speed: 0.232 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 0.250 ms
|
|
Speed: 0.234 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2576
Speed: 0.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2577
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2578
Speed: 0.242 ms
|
|
SELECT * FROM article_settings WHERE article_id = 917
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 = 9 ORDER BY s.seq1
Speed: 0.229 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 0.251 ms
|
|
Speed: 0.236 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2579
Speed: 0.239 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2580
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2581
Speed: 0.240 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2582
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2583
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2584
Speed: 0.248 ms
|
|
SELECT * FROM article_settings WHERE article_id = 918
Speed: 0.274 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq1
Speed: 0.239 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq1
Speed: 0.255 ms
|
|
Speed: 0.231 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2585
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2586
Speed: 0.236 ms
|
|
SELECT * FROM article_settings WHERE article_id = 919
Speed: 0.229 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq1
Speed: 0.225 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 0.673 ms
|
|
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2587
Speed: 0.347 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2588
Speed: 0.451 ms
|
|
SELECT * FROM article_settings WHERE article_id = 920
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 = 9 ORDER BY s.seq2
Speed: 0.494 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 1.408 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2589
Speed: 0.292 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2590
Speed: 0.244 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2591
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2592
Speed: 0.245 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2593
Speed: 0.234 ms
|
|
SELECT * FROM article_settings WHERE article_id = 921
Speed: 0.235 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq2
Speed: 0.238 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 0.807 ms
|
|
Speed: 0.239 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2594
Speed: 0.240 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2595
Speed: 0.240 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2596
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 922
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 = 9 ORDER BY s.seq2
Speed: 0.237 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 0.656 ms
|
|
Speed: 0.246 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2597
Speed: 0.243 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2598
Speed: 0.240 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2599
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2600
Speed: 0.364 ms
|
|
SELECT * FROM article_settings WHERE article_id = 923
Speed: 0.472 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq2
Speed: 0.850 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 3.867 ms
|
|
Speed: 0.506 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2601
Speed: 0.539 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2602
Speed: 0.537 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2603
Speed: 0.524 ms
|
|
SELECT * FROM article_settings WHERE article_id = 924
Speed: 0.542 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq2
Speed: 0.517 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 1.413 ms
|
|
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2604
Speed: 0.282 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2605
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2606
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2607
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2608
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 925
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 = 9 ORDER BY s.seq2
Speed: 0.262 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq2
Speed: 0.282 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2609
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2610
Speed: 0.265 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2611
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2612
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 926
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 = 9 ORDER BY s.seq2
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 = 9 ORDER BY g.seq2
Speed: 1.096 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2613
Speed: 0.255 ms
|
|
SELECT * FROM article_settings WHERE article_id = 927
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 = 9 ORDER BY s.seq2
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 = 9 ORDER BY g.seq2
Speed: 0.285 ms
|
|
Speed: 0.271 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2614
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2615
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2616
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2617
Speed: 0.262 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2618
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 928
Speed: 0.259 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq2
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 = 9 ORDER BY g.seq2
Speed: 0.737 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2619
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2620
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 929
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 = 9 ORDER BY s.seq2
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 = 9 ORDER BY g.seq3
Speed: 0.860 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2621
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2622
Speed: 0.274 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2623
Speed: 0.274 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2624
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 930
Speed: 0.261 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq3
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 = 9 ORDER BY g.seq3
Speed: 0.281 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2625
Speed: 0.278 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2626
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 931
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 = 9 ORDER BY s.seq3
Speed: 0.287 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 1.056 ms
|
|
Speed: 0.296 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2627
Speed: 0.272 ms
|
|
SELECT * FROM article_settings WHERE article_id = 932
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 = 9 ORDER BY s.seq3
Speed: 0.265 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 0.686 ms
|
|
Speed: 0.286 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2628
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2629
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2630
Speed: 0.267 ms
|
|
SELECT * FROM article_settings WHERE article_id = 933
Speed: 0.259 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq3
Speed: 0.262 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 0.745 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2631
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2632
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2633
Speed: 0.259 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2634
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 934
Speed: 0.258 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq3
Speed: 0.343 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 0.264 ms
|
|
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2635
Speed: 0.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2636
Speed: 0.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2637
Speed: 0.235 ms
|
|
SELECT * FROM article_settings WHERE article_id = 935
Speed: 0.231 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq3
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 = 9 ORDER BY g.seq3
Speed: 1.224 ms
|
|
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2638
Speed: 0.244 ms
|
|
SELECT * FROM article_settings WHERE article_id = 936
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 = 9 ORDER BY s.seq3
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 = 9 ORDER BY g.seq3
Speed: 0.692 ms
|
|
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2639
Speed: 0.233 ms
|
|
SELECT * FROM article_settings WHERE article_id = 937
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 = 9 ORDER BY s.seq3
Speed: 0.232 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 0.641 ms
|
|
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2640
Speed: 0.239 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2641
Speed: 0.232 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2642
Speed: 0.236 ms
|
|
SELECT * FROM article_settings WHERE article_id = 938
Speed: 0.226 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq3
Speed: 0.240 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq3
Speed: 0.631 ms
|
|
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2643
Speed: 0.248 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2644
Speed: 0.232 ms
|
|
SELECT * FROM article_settings WHERE article_id = 939
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 = 9 ORDER BY s.seq3
Speed: 0.231 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq4
Speed: 0.640 ms
|
|
Speed: 0.239 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2645
Speed: 0.247 ms
|
|
SELECT * FROM article_settings WHERE article_id = 940
Speed: 0.226 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq4
Speed: 0.231 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq4
Speed: 0.255 ms
|
|
Speed: 0.241 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2646
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2647
Speed: 0.233 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2648
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2649
Speed: 0.236 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2650
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2651
Speed: 0.235 ms
|
|
SELECT * FROM article_settings WHERE article_id = 941
Speed: 0.229 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq4
Speed: 0.227 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq4
Speed: 0.636 ms
|
|
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2652
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2653
Speed: 0.238 ms
|
|
SELECT * FROM article_settings WHERE article_id = 942
Speed: 0.225 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq4
Speed: 0.233 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq4
Speed: 0.252 ms
|
|
Speed: 0.233 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2654
Speed: 0.237 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2655
Speed: 0.235 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2656
Speed: 0.226 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2657
Speed: 0.228 ms
|
|
SELECT * FROM article_settings WHERE article_id = 943
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 = 9 ORDER BY s.seq4
Speed: 0.232 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 9 ORDER BY g.seq4
Speed: 0.793 ms
|
|
Speed: 0.654 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2658
Speed: 0.235 ms
|
|
SELECT * FROM article_settings WHERE article_id = 944
Speed: 0.223 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq4
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 = 9 ORDER BY g.seq4
Speed: 0.681 ms
|
|
Speed: 0.238 ms
|
|
SELECT * FROM author_settings WHERE author_id = 2659
Speed: 0.244 ms
|
|
SELECT * FROM article_settings WHERE article_id = 945
Speed: 0.226 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 9 ORDER BY s.seq4
Speed: 0.232 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.228 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: 2.207 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.825 ms
|
|
SELECT iss.subscription_id
FROM
institutional_subscriptions iss,
subscriptions s,
subscription_types st
WHERE POSITION(UPPER(LPAD(iss.domain, LENGTH(iss.domain)+1, '.')) IN UPPER(LPAD(38.107.179.229, LENGTH(38.107.179.229)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.882 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592613 >= isip.ip_start AND 644592613 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
AND s.status = 1
AND s.type_id = st.type_id
AND st.institutional = 1 AND ((st.non_expiring = 1) OR (st.non_expiring = 0 AND ('2012-05-23 05:11:55' >= s.date_start AND '2012-05-23 05:11:55' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592613 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.904 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.335 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.668 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.251 ms
|