footer slogan
footer slogan
© 2024 CRACS & Inesc TEC - All Rights Reserved Privacy Policy | Terms of Service
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT COUNT(*) AS `count` FROM `authenticus`.`publications` AS `Publication` WHERE `Publication`.`id` = 513142 | 1 | 1 | 0 | |
| 2 | SELECT * FROM `publication_profiles` WHERE `publication_profiles`.`profile`=? , params[ public ] | 43 | 43 | 1 | |
| 3 | SELECT `article_number`,`authors_string`,`book_authors_full_name`,`book_doi`,`book_group_authors`,`book_series_editors`,`book_series_title`,`conference_date`,`conference_host`,`conference_location`,`conference_sponsors`,`conference_title`,`document_title`,`doi`,`editors`,`group_authors`,`id`,`issn`,`issue`,`pages`,`page_count`,`part_number`,`publication_name`,`volume`,`year_published` FROM `publications` WHERE `publications`.`id`=? , params[ 513142 ] | 1 | 1 | 0 | |
| 4 | SELECT `document_type`,`type` FROM `publication_document_types` WHERE `publication_id`=? AND `type` IN (?) , params[ 513142, authenticus ] | 1 | 1 | 0 | |
| 5 | SELECT `publication_authors`.`author_name`,`publication_authors`.`name_order`,`publication_authors`.`researcher_id`,`publication_authors`.`validated`,`publication_authors`.`id` FROM `publication_authors` WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 513142 ] | 9 | 9 | 0 | |
| 6 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? AND `type` IN (?) , params[ 513142, crossref ] | 0 | 0 | 0 | |
| 7 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? AND `type` IN (?,?,?) , params[ 513142, cover_link, openlibrary, url_for_pdf ] | 0 | 0 | 0 | |
| 8 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? AND `type` IN (?,?,?,?,?,?,?,?,?) , params[ 513142, arxiv, crossref, dblp, handle, openlibrary, pubmed, scopus, unpaywall, wos ] | 1 | 1 | 0 | |
| 9 | SELECT COUNT(*) AS `count` FROM `publication_duplicates` WHERE `enable`>? AND (`pub_id_1`=? OR `pub_id_2`=?) , params[ 0, 513142, 513142 ] | 1 | 1 | 0 | |
| 10 | SELECT * FROM `publication_duplicates` WHERE `enable`>? AND (`pub_id_1`=? OR `pub_id_2`=?) ORDER BY `score` DESC LIMIT 5 , params[ 0, 513142, 513142 ] | 0 | 0 | 0 | |
| 11 | SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'publications' AND `published` = '1' | 0 | 0 | 1 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `permissions_groups`.`name`,`permissions_groups`.`require_extra_id` FROM `permissions_objects_groups` JOIN `permissions_objects` ON (`permissions_objects_groups`.`object_id`=`permissions_objects`.`id`) JOIN `permissions_groups` ON (`permissions_objects_groups`.`group_id`=`permissions_groups`.`id`) WHERE `permissions_objects`.`name`=? , params[ controller/publications/view ] | 5 | 5 | 1 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|