Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

39.25 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

22.69 ms

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE ? ORDER BY k0_.sort ASC) dctrn_result) dctrn_table

Parameters:

[
  "%Complete Streets And Automobility%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          k0_.id AS id_0,
          k0_.keyword AS keyword_1,
          k0_.in_stop_list AS in_stop_list_2,
          k0_.sort AS sort_3,
          p1_.id AS id_4,
          p1_.title AS title_5,
          p1_.ut AS ut_6,
          p1_.doctype AS doctype_7,
          p1_.pages AS pages_8,
          p1_.issue AS issue_9,
          p1_.volume AS volume_10,
          p1_.published_month AS published_month_11,
          p1_.published_year AS published_year_12,
          p1_.doi AS doi_13,
          p1_.issn AS issn_14,
          p1_.isbn AS isbn_15,
          p1_.updated_date AS updated_date_16,
          p1_.abstract AS abstract_17,
          p1_.times_cited AS times_cited_18,
          p1_.funding_text AS funding_text_19,
          p1_.interdisciplinary AS interdisciplinary_20,
          p1_.validated AS validated_21,
          p1_.siding_id AS siding_id_22,
          p1_.public_comments AS public_comments_23,
          p1_.private_comments AS private_comments_24,
          p1_.publication_type AS publication_type_25,
          p2_.id AS id_26,
          p2_.firstname AS firstname_27,
          p2_.lastname AS lastname_28,
          p2_.participation AS participation_29,
          p2_.master_student AS master_student_30,
          p2_.phd_student AS phd_student_31,
          p2_.uc_not_ing AS uc_not_ing_32,
          p2_.postdoc AS postdoc_33,
          a3_.id AS id_34,
          a3_.researcher_id AS researcher_id_35,
          a3_.daisng_id AS daisng_id_36,
          a3_.bio AS bio_37,
          a3_.vigent AS vigent_38
        FROM
          keyword k0_
          INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id
          INNER JOIN publication p1_ ON p1_.id = k4_.publication_id
          INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id
          INNER JOIN author a3_ ON p2_.author_id = a3_.id
        WHERE
          p1_.validated = 1
          AND a3_.vigent = 1
          AND k0_.keyword LIKE ?
        ORDER BY
          k0_.sort ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE '%Complete Streets And Automobility%' ORDER BY k0_.sort ASC) dctrn_result) dctrn_table;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 96)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 90)
8	App\Controller\KeywordController->index_public (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

16.55 ms

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_3 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE ?) dctrn_result_inner ORDER BY sort_3 ASC) dctrn_result LIMIT 4

Parameters:

[
  "%Complete Streets And Automobility%"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      sort_3
    FROM
      (
        SELECT
          k0_.id AS id_0,
          k0_.keyword AS keyword_1,
          k0_.in_stop_list AS in_stop_list_2,
          k0_.sort AS sort_3,
          p1_.id AS id_4,
          p1_.title AS title_5,
          p1_.ut AS ut_6,
          p1_.doctype AS doctype_7,
          p1_.pages AS pages_8,
          p1_.issue AS issue_9,
          p1_.volume AS volume_10,
          p1_.published_month AS published_month_11,
          p1_.published_year AS published_year_12,
          p1_.doi AS doi_13,
          p1_.issn AS issn_14,
          p1_.isbn AS isbn_15,
          p1_.updated_date AS updated_date_16,
          p1_.abstract AS abstract_17,
          p1_.times_cited AS times_cited_18,
          p1_.funding_text AS funding_text_19,
          p1_.interdisciplinary AS interdisciplinary_20,
          p1_.validated AS validated_21,
          p1_.siding_id AS siding_id_22,
          p1_.public_comments AS public_comments_23,
          p1_.private_comments AS private_comments_24,
          p1_.publication_type AS publication_type_25,
          p2_.id AS id_26,
          p2_.firstname AS firstname_27,
          p2_.lastname AS lastname_28,
          p2_.participation AS participation_29,
          p2_.master_student AS master_student_30,
          p2_.phd_student AS phd_student_31,
          p2_.uc_not_ing AS uc_not_ing_32,
          p2_.postdoc AS postdoc_33,
          a3_.id AS id_34,
          a3_.researcher_id AS researcher_id_35,
          a3_.daisng_id AS daisng_id_36,
          a3_.bio AS bio_37,
          a3_.vigent AS vigent_38
        FROM
          keyword k0_
          INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id
          INNER JOIN publication p1_ ON p1_.id = k4_.publication_id
          INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id
          INNER JOIN author a3_ ON p2_.author_id = a3_.id
        WHERE
          p1_.validated = 1
          AND a3_.vigent = 1
          AND k0_.keyword LIKE ?
      ) dctrn_result_inner
    ORDER BY
      sort_3 ASC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, sort_3 FROM (SELECT k0_.id AS id_0, k0_.keyword AS keyword_1, k0_.in_stop_list AS in_stop_list_2, k0_.sort AS sort_3, p1_.id AS id_4, p1_.title AS title_5, p1_.ut AS ut_6, p1_.doctype AS doctype_7, p1_.pages AS pages_8, p1_.issue AS issue_9, p1_.volume AS volume_10, p1_.published_month AS published_month_11, p1_.published_year AS published_year_12, p1_.doi AS doi_13, p1_.issn AS issn_14, p1_.isbn AS isbn_15, p1_.updated_date AS updated_date_16, p1_.abstract AS abstract_17, p1_.times_cited AS times_cited_18, p1_.funding_text AS funding_text_19, p1_.interdisciplinary AS interdisciplinary_20, p1_.validated AS validated_21, p1_.siding_id AS siding_id_22, p1_.public_comments AS public_comments_23, p1_.private_comments AS private_comments_24, p1_.publication_type AS publication_type_25, p2_.id AS id_26, p2_.firstname AS firstname_27, p2_.lastname AS lastname_28, p2_.participation AS participation_29, p2_.master_student AS master_student_30, p2_.phd_student AS phd_student_31, p2_.uc_not_ing AS uc_not_ing_32, p2_.postdoc AS postdoc_33, a3_.id AS id_34, a3_.researcher_id AS researcher_id_35, a3_.daisng_id AS daisng_id_36, a3_.bio AS bio_37, a3_.vigent AS vigent_38 FROM keyword k0_ INNER JOIN keyword_publication k4_ ON k0_.id = k4_.keyword_id INNER JOIN publication p1_ ON p1_.id = k4_.publication_id INNER JOIN publication_author p2_ ON p1_.id = p2_.publication_id INNER JOIN author a3_ ON p2_.author_id = a3_.id WHERE p1_.validated = 1 AND a3_.vigent = 1 AND k0_.keyword LIKE '%Complete Streets And Automobility%') dctrn_result_inner ORDER BY sort_3 ASC) dctrn_result LIMIT 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 725)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 127)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 177)
8	__TwigTemplate_f501964a6e05a6b46109ca58394676b1->block_body (line 431)
9	Twig\Template->yieldBlock (line 553)
10	__TwigTemplate_121357dfd36ae00b609ce7acee96c7b7->doDisplay (line 387)
11	Twig\Template->yield (line 56)
12	__TwigTemplate_f501964a6e05a6b46109ca58394676b1->doDisplay (line 387)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 51)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 87)
21	App\Controller\KeywordController->index_public (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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.

Entities Mapping

Class	Mapping errors
App\Entity\Keyword	No errors.
App\Entity\Publication	No errors.
App\Entity\PublicationAuthor	No errors.
App\Entity\Author	No errors.

Symfony Profiler

GET https://dii-investigacion.ing.uc.cl/keyword/public?query=Complete%20Streets%20And%20Automobility

Configuration Settings

Theme