Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

3.68 ms Query time

0 Invalid entities

6 Managed entities

1 Cache hits

0 Cache misses

0 Cache puts

Queries

Group similar statements

default connection

#▲

Time

Info

2.27 ms

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND n0_.slug = ? AND l2_.iso_code = ?

Parameters:

[
  "news-titolo-test"
  "en"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.meta_title AS meta_title_4,
  n0_.meta_description AS meta_description_5,
  n1_.id AS id_6,
  n1_.published AS published_7,
  n1_.published_at AS published_at_8,
  n1_.notification_queued_at AS notification_queued_at_9,
  n1_.notification_sent_at AS notification_sent_at_10,
  n1_.notification_last_user_id AS notification_last_user_id_11,
  n1_.notifications_created AS notifications_created_12,
  n1_.date_add AS date_add_13,
  n1_.date_upd AS date_upd_14,
  l2_.id AS id_15,
  l2_.name AS name_16,
  l2_.active AS active_17,
  l2_.iso_code AS iso_code_18,
  l2_.language_code AS language_code_19,
  l2_.locale AS locale_20,
  l2_.is_rtl AS is_rtl_21,
  n0_.news_id AS news_id_22,
  n0_.language_id AS language_id_23,
  n1_.created_by_id AS created_by_id_24
FROM
  news_lang n0_
  INNER JOIN news n1_ ON n0_.news_id = n1_.id
  INNER JOIN lang l2_ ON n0_.language_id = l2_.id
WHERE
  n1_.published = 1
  AND n0_.slug = ?
  AND l2_.iso_code = ?

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND n0_.slug = 'news-titolo-test' AND l2_.iso_code = 'en';

#	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->getOneOrNullResult (line 737)
6	App\Repository\NewsLangRepository->findPublishedBySlug (line 55)
7	App\Controller\Front\NewsController->findTranslationOrRedirect (line 112)
8	App\Controller\Front\NewsController->show (line 61)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.81 ms

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND n0_.slug = ? LIMIT 1

Parameters:

[
  "news-titolo-test"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  n0_.id AS id_0,
  n0_.title AS title_1,
  n0_.slug AS slug_2,
  n0_.content AS content_3,
  n0_.meta_title AS meta_title_4,
  n0_.meta_description AS meta_description_5,
  n1_.id AS id_6,
  n1_.published AS published_7,
  n1_.published_at AS published_at_8,
  n1_.notification_queued_at AS notification_queued_at_9,
  n1_.notification_sent_at AS notification_sent_at_10,
  n1_.notification_last_user_id AS notification_last_user_id_11,
  n1_.notifications_created AS notifications_created_12,
  n1_.date_add AS date_add_13,
  n1_.date_upd AS date_upd_14,
  l2_.id AS id_15,
  l2_.name AS name_16,
  l2_.active AS active_17,
  l2_.iso_code AS iso_code_18,
  l2_.language_code AS language_code_19,
  l2_.locale AS locale_20,
  l2_.is_rtl AS is_rtl_21,
  n0_.news_id AS news_id_22,
  n0_.language_id AS language_id_23,
  n1_.created_by_id AS created_by_id_24
FROM
  news_lang n0_
  INNER JOIN news n1_ ON n0_.news_id = n1_.id
  INNER JOIN lang l2_ ON n0_.language_id = l2_.id
WHERE
  n1_.published = 1
  AND n0_.slug = ?
LIMIT
  1

SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.slug AS slug_2, n0_.content AS content_3, n0_.meta_title AS meta_title_4, n0_.meta_description AS meta_description_5, n1_.id AS id_6, n1_.published AS published_7, n1_.published_at AS published_at_8, n1_.notification_queued_at AS notification_queued_at_9, n1_.notification_sent_at AS notification_sent_at_10, n1_.notification_last_user_id AS notification_last_user_id_11, n1_.notifications_created AS notifications_created_12, n1_.date_add AS date_add_13, n1_.date_upd AS date_upd_14, l2_.id AS id_15, l2_.name AS name_16, l2_.active AS active_17, l2_.iso_code AS iso_code_18, l2_.language_code AS language_code_19, l2_.locale AS locale_20, l2_.is_rtl AS is_rtl_21, n0_.news_id AS news_id_22, n0_.language_id AS language_id_23, n1_.created_by_id AS created_by_id_24 FROM news_lang n0_ INNER JOIN news n1_ ON n0_.news_id = n1_.id INNER JOIN lang l2_ ON n0_.language_id = l2_.id WHERE n1_.published = 1 AND n0_.slug = 'news-titolo-test' LIMIT 1;

#	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->getOneOrNullResult (line 737)
6	App\Repository\NewsLangRepository->findPublishedBySlugInAnyLanguage (line 69)
7	App\Controller\Front\NewsController->findTranslationOrRedirect (line 117)
8	App\Controller\Front\NewsController->show (line 61)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 208)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.60 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.news_id AS news_id_7, t0.language_id AS language_id_8 FROM news_lang t0 WHERE t0.news_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.slug AS slug_3,
  t0.content AS content_4,
  t0.meta_title AS meta_title_5,
  t0.meta_description AS meta_description_6,
  t0.news_id AS news_id_7,
  t0.language_id AS language_id_8
FROM
  news_lang t0
WHERE
  t0.news_id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.news_id AS news_id_7, t0.language_id AS language_id_8 FROM news_lang t0 WHERE t0.news_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 2733)
4	Doctrine\ORM\PersistentCollection->doInitialize (line 636)
5	Doctrine\ORM\PersistentCollection->initialize (line 186)
6	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 315)
7	App\Entity\News->getTranslationByLocale (line 245)
8	App\Controller\Front\NewsController->findTranslationOrRedirect (line 120)
9	App\Controller\Front\NewsController->show (line 61)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 208)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
messenger	doctrine.dbal.messenger_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

1 Hits

0 Misses

0 Puts

Number of cache hits

Region	Hits
append_only	1

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\NewsLang	2
App\Entity\Lang	2
App\Entity\News	1
App\Entity\Admin\Employee	1

Entities Mapping

Class	Mapping errors
App\Entity\NewsLang	No errors.
App\Entity\News	No errors.
App\Entity\Lang	No errors.
App\Entity\Admin\Employee	No errors.
App\Entity\NewsComment	No errors.

Symfony Profiler

GET https://app.dev.localero.it/news/news-titolo-test

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Number of cache hits

Managed Entities

default entity manager

Entities Mapping