(postgres7): SELECT * FROM sessions WHERE session_id = ? [ (0=>'jt87mbi88brp6eamq1ag4hvmk5') ]
(postgres7): INSERT INTO sessions
(session_id, ip_address, user_agent, created, last_used, remember, data, domain)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?) [ (0=>'jt87mbi88brp6eamq1ag4hvmk5') (1=>'18.219.22.169') (2=>'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; C...') (3=>'1714397922') (4=>'1714397922') (5=>'0') (6=>'') (7=>'revistas.unicentro.br') ]
(postgres7): SELECT * FROM journals WHERE path = ? [ (0=>'repaa') ]
(postgres7): SELECT * FROM site
(postgres7): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND ((journal_id = ?) OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1) [ (journal=>'3') ]
(postgres7): SELECT setting_name, setting_value, setting_type FROM plugin_settings WHERE plugin_name = ? AND journal_id = ? [ (0=>'objectsforreviewplugin') (1=>'3') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.generic.usageStats.UsageStatsLoader') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.generic.pln.classes.tasks.Depositor') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.importexport.datacite.DataciteInfoSender') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.importexport.medra.MedraInfoSender') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.importexport.crossref.CrossrefInfoSender') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'plugins.importexport.crossref.CrossrefInfoSender') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'classes.tasks.ReviewReminder') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'classes.tasks.SubscriptionExpiryReminder') ]
(postgres7): SELECT last_run FROM scheduled_tasks WHERE class_name = ? [ (0=>'classes.tasks.OpenAccessNotification') ]
(postgres7): 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
INNER JOIN articles a ON pa.article_id = a.article_id
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 = ? AND stpl.locale = ?)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = ? AND ast.setting_value = ? ORDER BY pa.issue_id, a.article_id [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'pub-id::publisher-id') (9=>'5509') ]
(postgres7): 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 = ? AND stpl.locale = ?)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?)
WHERE pa.article_id = a.article_id
AND a.article_id = ? [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'5509') ]
(postgres7): SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, 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 = ? ORDER BY g.seq [ (0=>'5509') ]
(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ? [ (0=>'4261') ]
(postgres7): SELECT * FROM article_settings WHERE article_id = ? [ (0=>'5509') ]
(postgres7): 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 = ? ORDER BY s.seq [ (0=>'5509') ]
(postgres7): SELECT i.*
FROM issues i INNER JOIN issue_settings ist ON i.issue_id = ist.issue_id
WHERE ist.setting_name = ? AND ist.setting_value = ? ORDER BY i.issue_id [ (0=>'pub-id::publisher-id') (1=>'329') ]
(postgres7): SELECT i.* FROM issues i WHERE issue_id = ? [ (0=>'329') ]
(postgres7): SELECT * FROM issue_settings WHERE issue_id = ? [ (0=>'329') ]
(postgres7):
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(?, LENGTH(?)+1, '.'))) != 0
AND iss.domain != ''
AND iss.subscription_id = s.subscription_id
AND s.journal_id = ?
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 ('2024-04-29 10:38:45' >= s.date_start AND '2024-04-29 10:38:45' <= s.date_end))) AND (st.format = 1
OR st.format = 17) [ (0=>'ec2-18-219-22-169.us-east-2.compute.amazonaws.com') (1=>'ec2-18-219-22-169.us-east-2.compute.amazonaws.com') (2=>'3') ]
(postgres7):
SELECT isip.subscription_id
FROM
institutional_subscription_ip isip,
subscriptions s,
subscription_types st
WHERE ((isip.ip_end IS NOT NULL
AND ? >= isip.ip_start AND ? <= isip.ip_end
AND isip.subscription_id = s.subscription_id
AND s.journal_id = ?
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 ('2024-04-29 10:38:45' >= s.date_start AND '2024-04-29 10:38:45' <= s.date_end))) AND (st.format = 1
OR st.format = 17))
OR (isip.ip_end IS NULL
AND ? = isip.ip_start
AND isip.subscription_id = s.subscription_id
AND s.journal_id = ?
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 ('2024-04-29 10:38:45' >= s.date_start AND '2024-04-29 10:38:45' <= s.date_end))) AND (st.format = 1
OR st.format = 17))) [ (0=>'316348073') (1=>'316348073') (2=>'3') (3=>'316348073') (4=>'3') ]
(postgres7): SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, 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.galley_id = ? AND g.article_id = ? [ (0=>'4261') (1=>'5509') ]
(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ? [ (0=>'4261') ]
(postgres7): SELECT v.*
FROM versions v LEFT JOIN plugin_settings ps ON
lower(v.product_class_name) = ps.plugin_name
AND ps.setting_name = 'enabled' AND ((journal_id = ?) OR v.sitewide = 1)
WHERE v.current = 1 AND (ps.setting_value = '1' OR v.lazy_load <> 1) [ (journal=>'3') ]
(postgres7): 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
INNER JOIN articles a ON pa.article_id = a.article_id
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 = ? AND stpl.locale = ?)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?) INNER JOIN article_settings ast ON a.article_id = ast.article_id
WHERE ast.setting_name = ? AND ast.setting_value = ? ORDER BY pa.issue_id, a.article_id [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'pub-id::publisher-id') (9=>'5509') ]
(postgres7): 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 = ? AND stpl.locale = ?)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?)
WHERE pa.article_id = a.article_id
AND a.article_id = ? [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'5509') ]
(postgres7): SELECT g.*,
a.file_name, a.original_file_name, a.file_stage, 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 = ? ORDER BY g.seq [ (0=>'5509') ]
(postgres7): SELECT * FROM article_galley_settings WHERE galley_id = ? [ (0=>'4261') ]
(postgres7): SELECT * FROM article_settings WHERE article_id = ? [ (0=>'5509') ]
(postgres7): 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 = ? ORDER BY s.seq [ (0=>'5509') ]
(postgres7): SELECT a.*,
COALESCE(stl.setting_value, stpl.setting_value) AS section_title,
COALESCE(sal.setting_value, sapl.setting_value) AS section_abbrev
FROM 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 = ? AND stpl.locale = ?)
LEFT JOIN section_settings stl ON (s.section_id = stl.section_id AND stl.setting_name = ? AND stl.locale = ?)
LEFT JOIN section_settings sapl ON (s.section_id = sapl.section_id AND sapl.setting_name = ? AND sapl.locale = ?)
LEFT JOIN section_settings sal ON (s.section_id = sal.section_id AND sal.setting_name = ? AND sal.locale = ?)
WHERE article_id = ? [ (0=>'title') (1=>'en_US') (2=>'title') (3=>'en_US') (4=>'abbrev') (5=>'en_US') (6=>'abbrev') (7=>'en_US') (8=>'5509') ]
(postgres7): SELECT * FROM article_settings WHERE article_id = ? [ (0=>'5509') ]
(postgres7): SELECT a.* FROM article_files a WHERE file_id = ? AND article_id = ? ORDER BY revision DESC LIMIT 1 [ (0=>'29798') (1=>'5509') ]
(postgres7): select version()
%PDF-1.4
%
35 0 obj
<>
endobj
xref
35 68
0000000016 00000 n
0000002232 00000 n
0000002365 00000 n
0000002873 00000 n
0000004052 00000 n
0000004478 00000 n
0000005283 00000 n
0000005921 00000 n
0000006032 00000 n
0000006293 00000 n
0000007002 00000 n
0000007115 00000 n
0000007373 00000 n
0000007603 00000 n
0000008245 00000 n
0000008963 00000 n
0000009100 00000 n
0000009803 00000 n
0000009943 00000 n
0000010345 00000 n
0000010370 00000 n
0000010892 00000 n
0000011156 00000 n
0000011181 00000 n
0000011651 00000 n
0000012344 00000 n
0000013044 00000 n
0000013177 00000 n
0000013836 00000 n
0000013861 00000 n
0000014511 00000 n
0000015206 00000 n
0000015814 00000 n
0000016251 00000 n
0000017039 00000 n
0000017507 00000 n
0000018077 00000 n
0000018146 00000 n
0000045392 00000 n
0000045945 00000 n
0000046216 00000 n
0000046285 00000 n
0000056534 00000 n
0000079517 00000 n
0000079626 00000 n
0000096003 00000 n
0000096270 00000 n
0000115112 00000 n
0000115473 00000 n
0000115754 00000 n
0000115823 00000 n
0000115919 00000 n
0000123896 00000 n
0000124170 00000 n
0000139066 00000 n
0000139164 00000 n
0000139642 00000 n
0000140083 00000 n
0000140374 00000 n
0000148490 00000 n
0000148759 00000 n
0000149107 00000 n
0000164085 00000 n
0000164357 00000 n
0000164816 00000 n
0000164928 00000 n
0000165024 00000 n
0000001656 00000 n
trailer
<<42D89C3A2984904D9C72C9288E96F9A6>]/Prev 234277>>
startxref
0
%%EOF
102 0 obj
<>stream
hb```b``=Ab,9$}3W0848&<8ıΧR詈,'g-]-0UeEK2]$2NO WyI!B&
-빮mˊ>&el8$!f^-+Mvf|
as9!I#~"+MZjB)c㬧.%q :% PqI考Q; G+2
#)l@@ d`z8,"|Lц25eM[ PCb/L