1 |
1.09 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.ut AS ut_3, t0.doctype AS doctype_4, t0.pages AS pages_5, t0.issue AS issue_6, t0.volume AS volume_7, t0.published_month AS published_month_8, t0.published_year AS published_year_9, t0.doi AS doi_10, t0.issn AS issn_11, t0.isbn AS isbn_12, t0.updated_date AS updated_date_13, t0.abstract AS abstract_14, t0.times_cited AS times_cited_15, t0.funding_text AS funding_text_16, t0.interdisciplinary AS interdisciplinary_17, t0.validated AS validated_18, t0.siding_id AS siding_id_19, t0.public_comments AS public_comments_20, t0.private_comments AS private_comments_21, t0.publication_type AS publication_type_22, t0.journal_id AS journal_id_23, t0.publisher_id AS publisher_id_24 FROM publication t0 WHERE t0.id = '2229';
|
2 |
0.93 ms |
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = ?
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.in_stop_list AS in_stop_list_3, t0.sort AS sort_4 FROM keyword t0 INNER JOIN keyword_publication ON t0.id = keyword_publication.keyword_id WHERE keyword_publication.publication_id = 2229;
|
3 |
0.70 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.participation AS participation_4, t0.master_student AS master_student_5, t0.phd_student AS phd_student_6, t0.uc_not_ing AS uc_not_ing_7, t0.postdoc AS postdoc_8, t0.author_id AS author_id_9, t0.publication_id AS publication_id_10, t0.external_author_id AS external_author_id_11 FROM publication_author t0 WHERE t0.publication_id = 2229;
|
4 |
0.47 ms |
SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.researcher_id AS researcher_id_2, t0.daisng_id AS daisng_id_3, t0.bio AS bio_4, t0.vigent AS vigent_5, t0.user_id AS user_id_6 FROM author t0 WHERE t0.id = 71;
|
5 |
0.55 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.last_name AS last_name_6, t0.rut AS rut_7, t0.sex AS sex_8, t0.photo AS photo_9, t10.id AS id_11, t10.researcher_id AS researcher_id_12, t10.daisng_id AS daisng_id_13, t10.bio AS bio_14, t10.vigent AS vigent_15, t10.user_id AS user_id_16 FROM `user` t0 LEFT JOIN author t10 ON t10.user_id = t0.id WHERE t0.id = 185;
|
6 |
0.44 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 10268;
|
7 |
0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21818;
|
8 |
0.42 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7410;
|
9 |
0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21819;
|
10 |
0.34 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7404;
|
11 |
0.44 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21820;
|
12 |
0.33 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7411;
|
13 |
0.40 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21821;
|
14 |
0.36 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7406;
|
15 |
0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21822;
|
16 |
0.31 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7409;
|
17 |
0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21823;
|
18 |
0.34 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7408;
|
19 |
0.39 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21824;
|
20 |
0.30 ms |
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.firstname AS firstname_2, t0.lastname AS lastname_3, t0.researcher_id AS researcher_id_4, t0.daisng_id AS daisng_id_5, t0.gender AS gender_6, t0.gender_probability AS gender_probability_7 FROM external_author t0 WHERE t0.id = 7407;
|
21 |
0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.city AS city_3, t0.country AS country_4 FROM organization t0 INNER JOIN publication_author_organization ON t0.id = publication_author_organization.organization_id WHERE publication_author_organization.publication_author_id = 21825;
|