Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1.02 ms Query time

0 Invalid entities

2 Managed entities

0 Cache hits

0 Cache misses

0 Cache puts

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

1.02 ms
(100.00%)

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.language_id AS language_id_2, p0_.title AS title_3, p0_.content AS content_4, p0_.meta_title AS meta_title_5, p0_.meta_description AS meta_description_6, p1_.id AS id_7, p1_.published AS published_8, p1_.date_add AS date_add_9, p1_.date_upd AS date_upd_10, p0_.page_id AS page_id_11 FROM page_lang p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = ? AND p0_.page_id = ? AND p1_.published = 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.slug AS slug_1,
  p0_.language_id AS language_id_2,
  p0_.title AS title_3,
  p0_.content AS content_4,
  p0_.meta_title AS meta_title_5,
  p0_.meta_description AS meta_description_6,
  p1_.id AS id_7,
  p1_.published AS published_8,
  p1_.date_add AS date_add_9,
  p1_.date_upd AS date_upd_10,
  p0_.page_id AS page_id_11
FROM
  page_lang p0_
  LEFT JOIN page p1_ ON p0_.page_id = p1_.id
WHERE
  p0_.language_id = ?
  AND p0_.page_id = ?
  AND p1_.published = 1

SELECT p0_.id AS id_0, p0_.slug AS slug_1, p0_.language_id AS language_id_2, p0_.title AS title_3, p0_.content AS content_4, p0_.meta_title AS meta_title_5, p0_.meta_description AS meta_description_6, p1_.id AS id_7, p1_.published AS published_8, p1_.date_add AS date_add_9, p1_.date_upd AS date_upd_10, p0_.page_id AS page_id_11 FROM page_lang p0_ LEFT JOIN page p1_ ON p0_.page_id = p1_.id WHERE p0_.language_id = 2 AND p0_.page_id = 4 AND p1_.published = 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\PageLangRepository->findOneByLanguageAndId (line 41)
7	App\Controller\Front\Page\AbstractPageController->findTranslation (line 61)
8	App\Controller\Front\Page\AbstractPageController->renderContentPage (line 32)
9	App\Controller\Front\Page\PrivacyPolicyController->show (line 20)
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

0 Hits

0 Misses

0 Puts

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\PageLang	1
App\Entity\Page	1

Entities Mapping

Class	Mapping errors
App\Entity\PageLang	No errors.
App\Entity\Page	No errors.