Query Metrics
2
Database Queries
2
Different statements
1.05 ms
Query time
0
Invalid entities
0
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.72 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.ut AS ut_2, p0_.doctype AS doctype_3, p0_.pages AS pages_4, p0_.issue AS issue_5, p0_.volume AS volume_6, p0_.published_month AS published_month_7, p0_.published_year AS published_year_8, p0_.doi AS doi_9, p0_.issn AS issn_10, p0_.isbn AS isbn_11, p0_.updated_date AS updated_date_12, p0_.abstract AS abstract_13, p0_.times_cited AS times_cited_14, p0_.funding_text AS funding_text_15, p0_.interdisciplinary AS interdisciplinary_16, p0_.validated AS validated_17, p0_.siding_id AS siding_id_18, p0_.public_comments AS public_comments_19, p0_.private_comments AS private_comments_20, p0_.publication_type AS publication_type_21, p0_.journal_id AS journal_id_22, p0_.publisher_id AS publisher_id_23 FROM publication p0_ WHERE p0_.validated = 1 ORDER BY p0_.published_year DESC, p0_.published_month DESC LIMIT 20
Parameters:
[]
|
||||||||||||||||||||||||||||
| 2 | 0.33 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
Parameters:
[]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Publication | No errors. |
| App\Entity\Journal | No errors. |
| App\Entity\Publisher | No errors. |
| App\Entity\Author | No errors. |
| App\Entity\User | No errors. |