1 | SELECT COUNT(*) AS `count` FROM `authenticus`.`publications` AS `Publication` WHERE `Publication`.`id` = 142137 | | 1 | 1 | 0 |
2 | SELECT * FROM `publication_profiles` WHERE `publication_profiles`.`profile`=? , params[ public ] | | 43 | 43 | 0 |
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[ 142137 ] | | 1 | 1 | 0 |
4 | SELECT `document_type`,`type` FROM `publication_document_types` WHERE `publication_id`=? AND `type` IN (?) , params[ 142137, 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[ 142137 ] | | 4 | 4 | 0 |
6 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? AND `type` IN (?) , params[ 142137, crossref ] | | 0 | 0 | 0 |
7 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? AND `type` IN (?,?,?) , params[ 142137, 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[ 142137, arxiv, crossref, dblp, handle, openlibrary, pubmed, scopus, unpaywall, wos ] | | 3 | 3 | 0 |
9 | SELECT COUNT(*) AS `count` FROM `publication_duplicates` WHERE `enable`>? AND (`pub_id_1`=? OR `pub_id_2`=?) , params[ 0, 142137, 142137 ] | | 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, 142137, 142137 ] | | 1 | 1 | 0 |
11 | SELECT `publications`.`id`,`document_title`,`publication_name`,`conference_title`,`volume`,`issue`,`page_count`,`year_published` FROM `publications` WHERE `id`=? , params[ 142137 ] | | 1 | 1 | 0 |
12 | SELECT * FROM `publication_authors` WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 142137 ] | | 4 | 4 | 0 |
13 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 142137 ] | | 2 | 2 | 0 |
14 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 142137 ] | | 4 | 4 | 0 |
15 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 142137 ] | | 4 | 4 | 0 |
16 | SELECT `publications`.`id`,`document_title`,`publication_name`,`conference_title`,`volume`,`issue`,`page_count`,`year_published` FROM `publications` WHERE `id`=? , params[ 600989 ] | | 1 | 1 | 0 |
17 | SELECT * FROM `publication_authors` WHERE `publication_id`=? ORDER BY `name_order` ASC , params[ 600989 ] | | 4 | 4 | 0 |
18 | SELECT `type`,`times_cited`,`last_update` FROM `publication_times_cited` WHERE `publication_id`=? , params[ 600989 ] | | 0 | 0 | 0 |
19 | SELECT `type`,`url` FROM `publication_urls` WHERE `publication_id`=? , params[ 600989 ] | | 2 | 2 | 0 |
20 | SELECT `type`,`external_id` FROM `publication_external_ids` WHERE `publication_id`=? , params[ 600989 ] | | 1 | 1 | 0 |
21 | SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'publications' AND `published` = '1' | | 0 | 0 | 0 |