|
SELECT * FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.826 ms
|
|
DELETE FROM sessions WHERE session_id = a5ce42b1641fd6a1b36e7b445fa955c7
Speed: 0.446 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(a5ce42b1641fd6a1b36e7b445fa955c7, 38.107.179.229, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1328795038, 1328795038, 0, , 0
Speed: 0.438 ms
|
|
SELECT * FROM journals WHERE path = pu
Speed: 0.259 ms
|
|
Speed: 0.225 ms
|
|
Speed: 0.309 ms
|
|
Speed: 0.574 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 24
Speed: 0.261 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 = 24)
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 = 24
Speed: 18.917 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.seq4
Speed: 36.457 ms
|
|
Speed: 0.496 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1821
Speed: 0.466 ms
|
|
SELECT * FROM article_settings WHERE article_id = 641
Speed: 0.464 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.seq4
Speed: 0.560 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.seq4
Speed: 0.701 ms
|
|
Speed: 0.845 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1822
Speed: 0.483 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1823
Speed: 0.483 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1824
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1825
Speed: 1.077 ms
|
|
SELECT * FROM article_settings WHERE article_id = 642
Speed: 0.564 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.seq4
Speed: 0.688 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.seq4
Speed: 0.715 ms
|
|
Speed: 0.648 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1826
Speed: 0.524 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1827
Speed: 0.478 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1828
Speed: 0.912 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1829
Speed: 0.534 ms
|
|
SELECT * FROM article_settings WHERE article_id = 643
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 = 6 ORDER BY s.seq4
Speed: 0.564 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 6 ORDER BY g.seq4
Speed: 0.639 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1830
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1831
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1832
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 644
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 = 6 ORDER BY s.seq4
Speed: 0.264 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.seq4
Speed: 0.622 ms
|
|
Speed: 0.489 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1833
Speed: 0.463 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1834
Speed: 0.446 ms
|
|
SELECT * FROM article_settings WHERE article_id = 645
Speed: 0.462 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.seq4
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 = 6 ORDER BY g.seq4
Speed: 0.641 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1835
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1836
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 646
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 = 6 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 = 6 ORDER BY g.seq4
Speed: 0.622 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1837
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1838
Speed: 0.253 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1839
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1840
Speed: 0.272 ms
|
|
SELECT * FROM article_settings WHERE article_id = 647
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 = 6 ORDER BY s.seq4
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 = 6 ORDER BY g.seq4
Speed: 0.769 ms
|
|
Speed: 0.551 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1841
Speed: 0.463 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1842
Speed: 0.496 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1843
Speed: 0.459 ms
|
|
SELECT * FROM article_settings WHERE article_id = 648
Speed: 0.470 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 6 ORDER BY s.seq4
Speed: 0.568 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.seq4
Speed: 0.680 ms
|
|
Speed: 0.495 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1844
Speed: 0.466 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1845
Speed: 0.553 ms
|
|
SELECT * FROM article_settings WHERE article_id = 649
Speed: 0.471 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.seq4
Speed: 0.552 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.seq5
Speed: 0.626 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1846
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1847
Speed: 0.249 ms
|
|
SELECT * FROM article_settings WHERE article_id = 650
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 = 6 ORDER BY s.seq5
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 = 6 ORDER BY g.seq5
Speed: 0.647 ms
|
|
Speed: 0.258 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1848
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1849
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 651
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 = 6 ORDER BY s.seq5
Speed: 0.264 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.seq5
Speed: 0.780 ms
|
|
Speed: 0.661 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1850
Speed: 0.498 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1851
Speed: 0.448 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1852
Speed: 0.520 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1853
Speed: 0.455 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1854
Speed: 0.452 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1855
Speed: 0.455 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1856
Speed: 0.460 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1857
Speed: 0.459 ms
|
|
SELECT * FROM article_settings WHERE article_id = 652
Speed: 0.468 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.seq5
Speed: 0.662 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.seq5
Speed: 0.632 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1858
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1859
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1860
Speed: 0.250 ms
|
|
SELECT * FROM article_settings WHERE article_id = 653
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 = 6 ORDER BY s.seq5
Speed: 0.269 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.seq5
Speed: 0.627 ms
|
|
Speed: 0.624 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1861
Speed: 0.460 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1862
Speed: 0.492 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1863
Speed: 0.465 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1864
Speed: 0.462 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1865
Speed: 0.466 ms
|
|
SELECT * FROM article_settings WHERE article_id = 654
Speed: 0.497 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 6 ORDER BY s.seq5
Speed: 0.575 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.seq5
Speed: 0.636 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1866
Speed: 0.246 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1867
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 655
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 = 6 ORDER BY s.seq5
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 = 6 ORDER BY g.seq5
Speed: 0.635 ms
|
|
Speed: 0.257 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1868
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 656
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 = 6 ORDER BY s.seq5
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 = 6 ORDER BY g.seq5
Speed: 0.289 ms
|
|
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1869
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1870
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1871
Speed: 0.253 ms
|
|
SELECT * FROM article_settings WHERE article_id = 657
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 = 6 ORDER BY s.seq5
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 = 6 ORDER BY g.seq5
Speed: 0.626 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1872
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1873
Speed: 0.254 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1874
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1875
Speed: 0.252 ms
|
|
SELECT * FROM article_settings WHERE article_id = 658
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 = 6 ORDER BY s.seq5
Speed: 0.260 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 6 ORDER BY g.seq5
Speed: 0.626 ms
|
|
Speed: 0.548 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1876
Speed: 0.484 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1877
Speed: 0.484 ms
|
|
SELECT * FROM article_settings WHERE article_id = 659
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 = 6 ORDER BY s.seq5
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 = 6 ORDER BY g.seq6
Speed: 0.643 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1878
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1879
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1880
Speed: 0.252 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1881
Speed: 0.251 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1882
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 660
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 = 6 ORDER BY s.seq6
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 = 6 ORDER BY g.seq6
Speed: 0.621 ms
|
|
Speed: 0.260 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1883
Speed: 0.250 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1884
Speed: 0.254 ms
|
|
SELECT * FROM article_settings WHERE article_id = 661
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 = 6 ORDER BY s.seq6
Speed: 0.260 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 6 ORDER BY g.seq6
Speed: 0.616 ms
|
|
Speed: 0.522 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1885
Speed: 0.529 ms
|
|
SELECT * FROM article_settings WHERE article_id = 662
Speed: 0.529 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.seq6
Speed: 0.565 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 6 ORDER BY g.seq6
Speed: 0.615 ms
|
|
Speed: 0.480 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1886
Speed: 0.541 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1887
Speed: 0.560 ms
|
|
SELECT * FROM article_settings WHERE article_id = 663
Speed: 0.470 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 6 ORDER BY s.seq6
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 = 6 ORDER BY g.seq6
Speed: 0.633 ms
|
|
Speed: 0.464 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1888
Speed: 0.496 ms
|
|
SELECT * FROM article_settings WHERE article_id = 664
Speed: 0.475 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 6 ORDER BY s.seq6
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 = 6 ORDER BY g.seq6
Speed: 0.292 ms
|
|
Speed: 0.256 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1889
Speed: 0.247 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1890
Speed: 0.249 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1891
Speed: 0.251 ms
|
|
SELECT * FROM article_settings WHERE article_id = 665
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 = 6 ORDER BY s.seq6
Speed: 0.260 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 6 ORDER BY g.seq6
Speed: 0.671 ms
|
|
Speed: 0.511 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1892
Speed: 0.520 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1893
Speed: 0.501 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1894
Speed: 0.521 ms
|
|
SELECT * FROM article_settings WHERE article_id = 666
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 = 6 ORDER BY s.seq6
Speed: 0.561 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.seq6
Speed: 0.630 ms
|
|
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1895
Speed: 0.487 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1896
Speed: 0.455 ms
|
|
SELECT * FROM article_settings WHERE article_id = 667
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 = 6 ORDER BY s.seq6
Speed: 0.552 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.seq6
Speed: 0.669 ms
|
|
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1897
Speed: 0.255 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1898
Speed: 0.267 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1899
Speed: 0.261 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1900
Speed: 0.264 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1901
Speed: 0.262 ms
|
|
SELECT * FROM article_settings WHERE article_id = 668
Speed: 0.272 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.seq6
Speed: 0.274 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.seq6
Speed: 0.647 ms
|
|
Speed: 0.507 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1902
Speed: 0.479 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1903
Speed: 0.467 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1904
Speed: 0.470 ms
|
|
SELECT * FROM article_settings WHERE article_id = 669
Speed: 0.498 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.seq6
Speed: 0.575 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.seq7
Speed: 0.638 ms
|
|
Speed: 0.270 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1905
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1906
Speed: 0.261 ms
|
|
SELECT * FROM article_settings WHERE article_id = 670
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 = 6 ORDER BY s.seq7
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 = 6 ORDER BY g.seq7
Speed: 0.641 ms
|
|
Speed: 0.559 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1907
Speed: 0.555 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1908
Speed: 0.469 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1909
Speed: 0.479 ms
|
|
SELECT * FROM article_settings WHERE article_id = 671
Speed: 0.487 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.seq7
Speed: 0.703 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.seq7
Speed: 0.622 ms
|
|
Speed: 0.477 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1910
Speed: 0.487 ms
|
|
SELECT * FROM article_settings WHERE article_id = 672
Speed: 0.471 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.seq7
Speed: 0.567 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.seq7
Speed: 0.630 ms
|
|
Speed: 0.509 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1911
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1912
Speed: 0.484 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1913
Speed: 0.482 ms
|
|
SELECT * FROM article_settings WHERE article_id = 673
Speed: 0.518 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.seq7
Speed: 0.552 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.seq7
Speed: 0.662 ms
|
|
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1914
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1915
Speed: 0.265 ms
|
|
SELECT * FROM article_settings WHERE article_id = 674
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 = 6 ORDER BY s.seq7
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 = 6 ORDER BY g.seq7
Speed: 0.669 ms
|
|
Speed: 0.483 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1916
Speed: 0.488 ms
|
|
SELECT * FROM article_settings WHERE article_id = 675
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 = 6 ORDER BY s.seq7
Speed: 0.554 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.seq7
Speed: 0.630 ms
|
|
Speed: 0.266 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1917
Speed: 0.263 ms
|
|
SELECT * FROM article_settings WHERE article_id = 676
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 = 6 ORDER BY s.seq7
Speed: 0.275 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.seq7
Speed: 0.616 ms
|
|
Speed: 0.529 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1918
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1919
Speed: 0.488 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1920
Speed: 0.484 ms
|
|
SELECT * FROM article_settings WHERE article_id = 677
Speed: 0.539 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.seq7
Speed: 0.567 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.seq7
Speed: 0.632 ms
|
|
Speed: 0.481 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1922
Speed: 0.501 ms
|
|
SELECT * FROM article_settings WHERE article_id = 678
Speed: 0.481 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.seq7
Speed: 0.574 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.seq7
Speed: 0.635 ms
|
|
Speed: 0.531 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1923
Speed: 0.494 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1924
Speed: 0.491 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1925
Speed: 0.495 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1926
Speed: 0.496 ms
|
|
SELECT * FROM article_settings WHERE article_id = 679
Speed: 0.499 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.seq7
Speed: 0.570 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.seq8
Speed: 0.642 ms
|
|
Speed: 0.273 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1927
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1928
Speed: 0.263 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1929
Speed: 0.268 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1930
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 680
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 = 6 ORDER BY s.seq8
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 = 6 ORDER BY g.seq8
Speed: 0.631 ms
|
|
Speed: 0.486 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1931
Speed: 0.499 ms
|
|
SELECT * FROM article_settings WHERE article_id = 681
Speed: 0.485 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 6 ORDER BY s.seq8
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 = 6 ORDER BY g.seq8
Speed: 0.297 ms
|
|
Speed: 0.269 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1932
Speed: 0.266 ms
|
|
SELECT * FROM article_settings WHERE article_id = 682
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 = 6 ORDER BY s.seq8
Speed: 0.275 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.seq8
Speed: 0.655 ms
|
|
Speed: 0.485 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1933
Speed: 0.502 ms
|
|
SELECT * FROM article_settings WHERE article_id = 683
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 = 6 ORDER BY s.seq8
Speed: 0.613 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.seq8
Speed: 0.718 ms
|
|
Speed: 0.551 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1934
Speed: 0.506 ms
|
|
SELECT * FROM article_settings WHERE article_id = 684
Speed: 0.524 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.seq8
Speed: 0.645 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.seq8
Speed: 0.660 ms
|
|
Speed: 0.271 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1935
Speed: 0.264 ms
|
|
SELECT * FROM article_settings WHERE article_id = 685
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 = 6 ORDER BY s.seq8
Speed: 0.269 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.seq8
Speed: 0.727 ms
|
|
Speed: 0.527 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1936
Speed: 0.579 ms
|
|
SELECT * FROM article_settings WHERE article_id = 686
Speed: 0.499 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.seq8
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 = 6 ORDER BY g.seq8
Speed: 0.688 ms
|
|
Speed: 0.566 ms
|
|
SELECT * FROM author_settings WHERE author_id = 1937
Speed: 0.554 ms
|
|
SELECT * FROM article_settings WHERE article_id = 687
Speed: 0.487 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.seq8
Speed: 0.561 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.274 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US
Speed: 0.396 ms
|
|
SELECT pa.*,
a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM published_articles pa,
articles a
LEFT JOIN sections s ON s.section_id = a.section_id
LEFT JOIN section_settings stpl ON (s.section_id = stpl.section_id AND stpl.setting_name = title AND stpl.locale = en_US)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = title AND stl.locale = en_US)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = abbrev AND sapl.locale = en_US)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = abbrev AND sal.locale = en_US)
WHERE pa.article_id = a.article_id
AND a.article_id = 0
Speed: 0.382 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.757 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-02-09 22:43:58' >= s.date_start AND '2012-02-09 22:43:58' <= 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.855 ms
|
|
SELECT COUNT(*) FROM plugin_settings WHERE plugin_name = newnav AND setting_name = enabled AND journal_id = 1
Speed: 0.302 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.557 ms
|
|
SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = newnav AND journal_id = 1
Speed: 0.280 ms
|