|
SELECT * FROM sessions WHERE session_id = b3n7olqk5409aj4379tmnffi9t3nv007trviig1odmmn3kfc6e31
Speed: 57.668 ms
|
|
DELETE FROM sessions WHERE session_id = b3n7olqk5409aj4379tmnffi9t3nv007trviig1odmmn3kfc6e31
Speed: 43.183 ms
|
|
INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, acting_as)
VALUES
(b3n7olqk5409aj4379tmnffi9t3nv007trviig1odmmn3kfc6e31, 38.107.179.208, CCBot/1.0 (+http://www.commoncrawl.org/bot.html), 1338376713, 1338376713, 0, , 0
Speed: 42.046 ms
|
|
SELECT * FROM journals WHERE path = ob
Speed: 0.807 ms
|
|
Speed: 0.350 ms
|
|
Speed: 5.056 ms
|
|
Speed: 0.839 ms
|
|
SELECT * FROM issue_settings WHERE issue_id = 11
Speed: 0.518 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 = 11)
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 = 11
Speed: 629.114 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.seq9
Speed: 7.791 ms
|
|
Speed: 11.527 ms
|
|
SELECT * FROM author_settings WHERE author_id = 266
Speed: 51.571 ms
|
|
SELECT * FROM article_settings WHERE article_id = 193
Speed: 48.419 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.seq9
Speed: 0.893 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.seq9
Speed: 0.582 ms
|
|
Speed: 0.324 ms
|
|
SELECT * FROM author_settings WHERE author_id = 272
Speed: 0.352 ms
|
|
SELECT * FROM article_settings WHERE article_id = 198
Speed: 0.305 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.seq9
Speed: 0.508 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.seq9
Speed: 5.726 ms
|
|
Speed: 0.360 ms
|
|
SELECT * FROM author_settings WHERE author_id = 273
Speed: 0.310 ms
|
|
SELECT * FROM author_settings WHERE author_id = 274
Speed: 0.309 ms
|
|
SELECT * FROM author_settings WHERE author_id = 275
Speed: 2.785 ms
|
|
SELECT * FROM article_settings WHERE article_id = 199
Speed: 7.795 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.seq9
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 = 2 ORDER BY g.seq0
Speed: 0.547 ms
|
|
Speed: 0.322 ms
|
|
SELECT * FROM author_settings WHERE author_id = 276
Speed: 0.319 ms
|
|
SELECT * FROM author_settings WHERE author_id = 277
Speed: 0.309 ms
|
|
SELECT * FROM article_settings WHERE article_id = 200
Speed: 7.399 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 = 2 ORDER BY s.seq0
Speed: 0.487 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 = 2 ORDER BY g.seq0
Speed: 0.532 ms
|
|
Speed: 0.324 ms
|
|
SELECT * FROM author_settings WHERE author_id = 278
Speed: 0.326 ms
|
|
SELECT * FROM article_settings WHERE article_id = 201
Speed: 0.298 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 = 2 ORDER BY s.seq0
Speed: 0.514 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 = 2 ORDER BY g.seq0
Speed: 0.555 ms
|
|
Speed: 0.329 ms
|
|
SELECT * FROM author_settings WHERE author_id = 279
Speed: 0.300 ms
|
|
SELECT * FROM author_settings WHERE author_id = 280
Speed: 0.291 ms
|
|
SELECT * FROM article_settings WHERE article_id = 202
Speed: 0.306 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 = 2 ORDER BY s.seq0
Speed: 0.509 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 = 2 ORDER BY g.seq0
Speed: 0.529 ms
|
|
Speed: 8.562 ms
|
|
SELECT * FROM author_settings WHERE author_id = 281
Speed: 0.294 ms
|
|
SELECT * FROM author_settings WHERE author_id = 282
Speed: 0.293 ms
|
|
SELECT * FROM author_settings WHERE author_id = 283
Speed: 0.335 ms
|
|
SELECT * FROM article_settings WHERE article_id = 203
Speed: 11.581 ms
|
|
SELECT s.*, a.file_name, a.original_file_name, a.file_type, a.file_size, a.date_uploaded, a.date_modified FROM article_supplementary_files s LEFT JOIN article_files a ON (s.file_id = a.file_id) WHERE s.article_id = 2 ORDER BY s.seq0
Speed: 0.590 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 = 2 ORDER BY g.seq0
Speed: 0.647 ms
|
|
Speed: 0.343 ms
|
|
SELECT * FROM author_settings WHERE author_id = 285
Speed: 0.330 ms
|
|
SELECT * FROM author_settings WHERE author_id = 286
Speed: 0.344 ms
|
|
SELECT * FROM author_settings WHERE author_id = 287
Speed: 0.419 ms
|
|
SELECT * FROM author_settings WHERE author_id = 288
Speed: 0.297 ms
|
|
SELECT * FROM article_settings WHERE article_id = 205
Speed: 0.312 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 = 2 ORDER BY s.seq0
Speed: 0.496 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 = 2 ORDER BY g.seq0
Speed: 0.536 ms
|
|
Speed: 0.327 ms
|
|
SELECT * FROM author_settings WHERE author_id = 289
Speed: 0.337 ms
|
|
SELECT * FROM author_settings WHERE author_id = 290
Speed: 0.301 ms
|
|
SELECT * FROM article_settings WHERE article_id = 206
Speed: 3.385 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 = 2 ORDER BY s.seq0
Speed: 0.502 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 = 2 ORDER BY g.seq1
Speed: 0.535 ms
|
|
Speed: 0.378 ms
|
|
SELECT * FROM author_settings WHERE author_id = 309
Speed: 0.324 ms
|
|
SELECT * FROM author_settings WHERE author_id = 310
Speed: 0.291 ms
|
|
SELECT * FROM article_settings WHERE article_id = 219
Speed: 6.815 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 = 2 ORDER BY s.seq1
Speed: 0.525 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.531 ms
|
|
Speed: 0.323 ms
|
|
SELECT * FROM author_settings WHERE author_id = 131
Speed: 0.327 ms
|
|
SELECT * FROM article_settings WHERE article_id = 101
Speed: 52.523 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.543 ms
|
|
SELECT g.*,
a.file_name, a.original_file_name, a.type, a.file_type, a.file_size, a.date_uploaded, a.date_modified
FROM article_galleys g
LEFT JOIN article_files a ON (g.file_id = a.file_id)
WHERE g.article_id = 1 ORDER BY g.seq0
Speed: 0.560 ms
|
|
Speed: 0.344 ms
|
|
SELECT * FROM author_settings WHERE author_id = 139
Speed: 0.300 ms
|
|
SELECT * FROM article_settings WHERE article_id = 109
Speed: 0.314 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.594 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.532 ms
|
|
Speed: 0.319 ms
|
|
SELECT * FROM author_settings WHERE author_id = 142
Speed: 9.320 ms
|
|
SELECT * FROM article_settings WHERE article_id = 112
Speed: 1.293 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.539 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.555 ms
|
|
Speed: 0.317 ms
|
|
SELECT * FROM author_settings WHERE author_id = 144
Speed: 0.306 ms
|
|
SELECT * FROM article_settings WHERE article_id = 114
Speed: 0.289 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.524 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.seq2
Speed: 0.559 ms
|
|
Speed: 0.344 ms
|
|
SELECT * FROM author_settings WHERE author_id = 162
Speed: 6.741 ms
|
|
SELECT * FROM article_settings WHERE article_id = 126
Speed: 2.758 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.seq2
Speed: 0.488 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.seq5
Speed: 0.555 ms
|
|
Speed: 0.325 ms
|
|
SELECT * FROM author_settings WHERE author_id = 213
Speed: 2.554 ms
|
|
SELECT * FROM article_settings WHERE article_id = 157
Speed: 1.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 = 1 ORDER BY s.seq5
Speed: 0.522 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.597 ms
|
|
Speed: 0.386 ms
|
|
SELECT * FROM author_settings WHERE author_id = 147
Speed: 0.309 ms
|
|
SELECT * FROM article_settings WHERE article_id = 117
Speed: 0.351 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.484 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.seq2
Speed: 0.626 ms
|
|
Speed: 0.333 ms
|
|
SELECT * FROM author_settings WHERE author_id = 150
Speed: 0.331 ms
|
|
SELECT * FROM author_settings WHERE author_id = 151
Speed: 0.295 ms
|
|
SELECT * FROM article_settings WHERE article_id = 120
Speed: 0.299 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.seq2
Speed: 0.485 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.seq3
Speed: 0.557 ms
|
|
Speed: 0.346 ms
|
|
SELECT * FROM author_settings WHERE author_id = 171
Speed: 0.349 ms
|
|
SELECT * FROM article_settings WHERE article_id = 133
Speed: 0.306 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.seq3
Speed: 0.532 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.seq6
Speed: 0.536 ms
|
|
Speed: 0.413 ms
|
|
SELECT * FROM author_settings WHERE author_id = 217
Speed: 0.321 ms
|
|
SELECT * FROM article_settings WHERE article_id = 161
Speed: 9.066 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.seq6
Speed: 0.520 ms
|
|
SELECT * FROM journals WHERE journal_id = 1
Speed: 0.289 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.417 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.770 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.208, LENGTH(38.107.179.208)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 2.897 ms
|
|
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND 644592592 >= isip.ip_start AND 644592592 <= 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-30 11:18:35' >= s.date_start AND '2012-05-30 11:18:35' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND 644592592 = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = 1
Speed: 0.971 ms
|
Observatorio (OBS*)
