|
SELECT * FROM sessions WHERE session_id = ht3o2gjo8ht8st9h30a7h0bai5
Speed: 0.419 ms
|
|
SELECT * FROM journals WHERE path = cj
Speed: 0.375 ms
|
|
Speed: 0.246 ms
|
|
Speed: 3.466 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.490 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 88
Speed: 0.462 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 = 88)
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 = 88
Speed: 4.107 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 = 1 ORDER BY g.seq1
Speed: 0.509 ms
|
|
Speed: 0.381 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1694
Speed: 0.456 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1165
Speed: 0.616 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 = 1 ORDER BY s.seq1
Speed: 0.349 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 = 1 ORDER BY g.seq1
Speed: 0.615 ms
|
|
Speed: 0.357 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1695
Speed: 0.407 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1696
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1166
Speed: 0.583 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 = 1 ORDER BY s.seq1
Speed: 0.351 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 7 ORDER BY g.seq7
Speed: 0.451 ms
|
|
Speed: 0.382 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1035
Speed: 0.455 ms
|
|
SELECT * FROM article_settings WHERE article_id = 770
Speed: 0.691 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 7 ORDER BY s.seq7
Speed: 0.358 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 = 1 ORDER BY g.seq1
Speed: 0.451 ms
|
|
Speed: 0.402 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1697
Speed: 0.410 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1698
Speed: 0.425 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1167
Speed: 0.639 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 = 1 ORDER BY s.seq1
Speed: 0.349 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.seq1
Speed: 0.508 ms
|
|
Speed: 0.369 ms
|
|
SELECT * FROM author_settings WHERE author_id = 966
Speed: 0.407 ms
|
|
SELECT * FROM article_settings WHERE article_id = 717
Speed: 0.490 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.seq1
Speed: 0.349 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.seq0
Speed: 0.476 ms
|
|
Speed: 0.350 ms
|
|
SELECT * FROM author_settings WHERE author_id = 956
Speed: 0.403 ms
|
|
SELECT * FROM article_settings WHERE article_id = 707
Speed: 0.482 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.seq0
Speed: 0.356 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.seq9
Speed: 0.512 ms
|
|
Speed: 0.386 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1223
Speed: 0.523 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1224
Speed: 0.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1225
Speed: 0.396 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1226
Speed: 0.453 ms
|
|
SELECT * FROM article_settings WHERE article_id = 891
Speed: 0.543 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.seq9
Speed: 0.418 ms
|
|
SELECT * FROM article_supp_file_settings WHERE supp_id = 40
Speed: 0.556 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 7 ORDER BY g.seq1
Speed: 0.495 ms
|
|
Speed: 0.374 ms
|
|
SELECT * FROM author_settings WHERE author_id = 961
Speed: 0.384 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1704
Speed: 0.419 ms
|
|
SELECT * FROM article_settings WHERE article_id = 712
Speed: 0.445 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.seq1
Speed: 0.372 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 = 6 ORDER BY g.seq9
Speed: 0.450 ms
|
|
Speed: 0.376 ms
|
|
SELECT * FROM author_settings WHERE author_id = 946
Speed: 0.373 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1705
Speed: 0.434 ms
|
|
SELECT * FROM article_settings WHERE article_id = 697
Speed: 0.443 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 = 6 ORDER BY s.seq9
Speed: 0.348 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 = 1 ORDER BY g.seq0
Speed: 0.458 ms
|
|
Speed: 0.363 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1407
Speed: 0.407 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1410
Speed: 0.428 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1009
Speed: 0.527 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 = 1 ORDER BY s.seq0
Speed: 0.357 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.462 ms
|
|
Speed: 0.404 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1161
Speed: 0.449 ms
|
|
SELECT * FROM article_settings WHERE article_id = 852
Speed: 0.535 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.348 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.seq5
Speed: 0.455 ms
|
|
Speed: 0.370 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1330
Speed: 0.442 ms
|
|
SELECT * FROM article_settings WHERE article_id = 957
Speed: 0.583 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.seq5
Speed: 0.351 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.457 ms
|
|
Speed: 0.347 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1184
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 864
Speed: 0.577 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.347 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.456 ms
|
|
Speed: 0.370 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1138
Speed: 0.457 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1139
Speed: 0.406 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1140
Speed: 0.394 ms
|
|
SELECT * FROM article_settings WHERE article_id = 837
Speed: 0.579 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.349 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 3 ORDER BY g.seq4
Speed: 0.465 ms
|
|
Speed: 0.371 ms
|
|
SELECT * FROM author_settings WHERE author_id = 492
Speed: 0.437 ms
|
|
SELECT * FROM author_settings WHERE author_id = 493
Speed: 0.424 ms
|
|
SELECT * FROM article_settings WHERE article_id = 346
Speed: 0.506 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 3 ORDER BY s.seq4
Speed: 0.345 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.469 ms
|
|
Speed: 0.378 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1154
Speed: 0.448 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1155
Speed: 0.414 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1156
Speed: 0.427 ms
|
|
SELECT * FROM article_settings WHERE article_id = 847
Speed: 0.490 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.347 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 = 5 ORDER BY g.seq7
Speed: 0.452 ms
|
|
Speed: 0.361 ms
|
|
SELECT * FROM author_settings WHERE author_id = 762
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 571
Speed: 0.547 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 = 5 ORDER BY s.seq7
Speed: 0.352 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 = 1 ORDER BY g.seq1
Speed: 0.497 ms
|
|
Speed: 0.349 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1706
Speed: 0.418 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1170
Speed: 0.446 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 = 1 ORDER BY s.seq1
Speed: 0.510 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 = 1 ORDER BY g.seq1
Speed: 0.468 ms
|
|
Speed: 0.343 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1707
Speed: 0.430 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1171
Speed: 0.428 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 = 1 ORDER BY s.seq1
Speed: 0.352 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 = 1 ORDER BY g.seq1
Speed: 0.453 ms
|
|
Speed: 0.344 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1708
Speed: 0.430 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1172
Speed: 0.453 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 = 1 ORDER BY s.seq1
Speed: 0.355 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 = 1 ORDER BY g.seq1
Speed: 0.451 ms
|
|
Speed: 0.342 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1709
Speed: 0.452 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1173
Speed: 0.436 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 = 1 ORDER BY s.seq1
Speed: 0.351 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 = 1 ORDER BY g.seq1
Speed: 0.451 ms
|
|
Speed: 0.344 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1714
Speed: 0.439 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1176
Speed: 0.452 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 = 1 ORDER BY s.seq1
Speed: 0.347 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 = 1 ORDER BY g.seq1
Speed: 0.451 ms
|
|
Speed: 0.355 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1715
Speed: 0.452 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1716
Speed: 0.432 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1177
Speed: 0.450 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 = 1 ORDER BY s.seq1
Speed: 0.349 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 = 1 ORDER BY g.seq1
Speed: 0.452 ms
|
|
Speed: 0.352 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1717
Speed: 0.444 ms
|
|
SELECT * FROM article_settings WHERE article_id = 1178
Speed: 0.448 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 = 1 ORDER BY s.seq1
Speed: 0.347 ms
|
|
SELECT * FROM journals WHERE journal_id = 6
Speed: 0.313 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.862 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.510 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.211, LENGTH(38.107.179.211)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 6
Speed: 0.463 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592595 >= isip.ip_start AND 644592595 <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 6
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-20 15:52:10' >= s.date_start AND '2012-05-20 15:52:10' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592595 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 6
Speed: 0.441 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.396 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 88
Speed: 0.429 ms
|
|
SELECT i.* FROM issues i WHERE journal_id = 6
Speed: 0.486 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 88
Speed: 0.418 ms
|