Symfony Profiler

Query Metrics

46 Database Queries

4 Different statements

11.38 ms Query time

0 Invalid entities

105 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.24 ms
(81.19%)

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:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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 = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\Proxy\ProxyFactory->{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxy():217} (line 223)
4	App\Entity\Publication::isValidated (line 329)
5	App\Entity\Author->getValidatedPublications (line 140)
6	App\Controller\DefaultController->public_index (line 42)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.92 ms
(8.10%)

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.author_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

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.author_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.author_id = 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1872)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 1817)
3	Doctrine\ORM\UnitOfWork->loadCollection (line 2729)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 313)
7	App\Entity\Author->getValidatedPublications (line 139)
8	App\Controller\DefaultController->public_index (line 42)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.80 ms
(7.06%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\PublicationRepository->findRecentPublications (line 56)
7	App\Controller\DefaultController->public_index (line 31)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 32)
13	require_once (line 5)

0.42 ms
(3.65%)

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:

[]

View formatted query View runnable query Explain query View query backtrace

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

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;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Controller\DefaultController->public_index (line 34)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 32)
11	require_once (line 5)

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
App\Entity\PublicationAuthor	42
App\Entity\Publication	42
App\Entity\Journal	17
App\Entity\Author	2
App\Entity\User	2

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.
App\Entity\PublicationAuthor	No errors.
App\Entity\ResearchLine	No errors.
App\Entity\ExternalAuthor	No errors.
App\Entity\Organization	No errors.
App\Entity\WosRecord	No errors.
App\Entity\Grant	No errors.
App\Entity\Keyword	No errors.
App\Entity\KeywordPlus	No errors.

Symfony Profiler

GET https://146.155.4.130/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping