Z. R. Nakic
AuthID: R-00J-VCQ
AuthID: R-00J-VCQ
Um espaço para investigadores e suas Instituições
Um espaço para investigadores e suas Instituições
© 2024 CRACS & Inesc TEC - All Rights Reserved Política de Privacidade | Terms of Service
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT * FROM `researchers` WHERE `researchers`.`id`=? , params[ 617879 ] | 1 | 1 | 0 | |
| 2 | SELECT MIN(`publications`.`year_published`) AS `min` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) WHERE `publication_authors`.`researcher_id`=? , params[ 617879 ] | 1 | 1 | 0 | |
| 3 | SELECT `publication_document_types`.`document_type`,count(*) AS `count` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` ON (`publication_authors`.`publication_id`=`publication_document_types`.`publication_id` AND `publication_document_types`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? GROUP BY `publication_document_types`.`document_type` ORDER BY `count` DESC , params[ authenticus, 617879, 1 ] | 0 | 0 | 0 | |
| 4 | SELECT COUNT(DISTINCT `publications`.`id`) AS `count` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `pdt` ON (`publications`.`id`=`pdt`.`publication_id` AND `pdt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? , params[ authenticus, 617879, 1 ] | 1 | 1 | 0 | |
| 5 | SELECT `publications`.`id`,`pdt`.`document_type`,`document_title`,`subtitle`,`publication_name`,`conference_title`,`volume`,`issue`,`page_count`,`publications`.`year_published` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) JOIN `publication_document_types` AS `pdt` ON (`publications`.`id`=`pdt`.`publication_id` AND `pdt`.`type`=?) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? GROUP BY `publications`.`id` ORDER BY `publications`.`year_published` DESC, `publications`.`document_title` ASC LIMIT 10 , params[ authenticus, 617879, 1 ] | 0 | 0 | 0 | |
| 6 | SELECT COUNT(*) AS `count` FROM `publication_authors` JOIN `publications` ON (`publication_authors`.`publication_id`=`publications`.`id`) WHERE `publication_authors`.`researcher_id`=? AND `publication_authors`.`validated`=? AND `publication_authors`.`publication_id` NOT IN (SELECT `publication_id` FROM `researcher_publication_external_databases` WHERE `type`=? AND `researcher_id`=?) , params[ 617879, 1, orcid_authen, 617879 ] | 1 | 1 | 0 | |
| 7 | SELECT `name` FROM `researchers` WHERE `id`=? , params[ 617879 ] | 1 | 1 | 0 | |
| 8 | SELECT `Article`.`id`, `Article`.`title_en`, `Article`.`title_pt` FROM `authenticus`.`articles` AS `Article` WHERE `controller` = 'profileOfResearchers' AND `published` = '1' | 0 | 0 | 0 |
| 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/profileOfResearchers/publicationsList ] | 5 | 5 | 0 | |
| 2 | SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 617879 ] | 0 | 0 | 0 | |
| 3 | SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 617879 ] | 0 | 0 | 0 | |
| 4 | SELECT `field`,`required_level` FROM `researcher_privacy_settings` WHERE `researcher_id`=? , params[ 617879 ] | 0 | 0 | 0 |
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|