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