Query Metrics
30
Database Queries
4
Different statements
17.39 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
12.95 ms (74.51%) |
27 |
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 = ?
Parameters:
[
1456
]
|
2.52 ms (14.51%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.name AS name_4, t0.last_name AS last_name_5, t0.rut AS rut_6, t0.sex AS sex_7, t8.id AS id_9, t8.researcher_id AS researcher_id_10, t8.daisng_id AS daisng_id_11, t8.user_id AS user_id_12 FROM user t0 LEFT JOIN author t8 ON t8.user_id = t0.id WHERE t0.id = ?
Parameters:
[
183
]
|
0.98 ms (5.61%) |
1 |
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.externalAuthor_id AS externalAuthor_id_9, t0.author_id AS author_id_10, t0.publication_id AS publication_id_11 FROM publication_author t0 WHERE t0.author_id = ?
Parameters:
[
186
]
|
0.93 ms (5.36%) |
1 |
SELECT t0.id AS id_1, t0.role AS role_2, t0.text AS text_3 FROM role t0 INNER JOIN users_userRoles ON t0.id = users_userRoles.role_id WHERE users_userRoles.user_id = ?
Parameters:
[
183
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\Publication | No errors. |
App\Entity\User | No errors. |
App\Entity\Author | No errors. |
App\Entity\Role | No errors. |
App\Entity\PublicationAuthor | No errors. |
App\Entity\ExternalAuthor | No errors. |
App\Entity\Organization | No errors. |
App\Entity\Journal | No errors. |
App\Entity\Publisher | No errors. |
App\Entity\Keyword | No errors. |
App\Entity\KeywordPlus | No errors. |
App\Entity\WosRecord | No errors. |
App\Entity\Grant | No errors. |