Symfony Profiler

Query Metrics

15 Database Queries

8 Different statements

12.45 ms Query time

1 Invalid entities

16 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.77 ms
(22.29%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.file AS file_4, t0.uuid AS uuid_5, t0.type AS type_6, t0.temp AS temp_7, t0.path AS path_8, t0.width AS width_9, t0.height AS height_10, t0.extension AS extension_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_15 FROM image t0 WHERE t0.id = ?

Parameters:

[
  27518
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.alt AS alt_3,
  t0.file AS file_4,
  t0.uuid AS uuid_5,
  t0.type AS type_6,
  t0.temp AS temp_7,
  t0.path AS path_8,
  t0.width AS width_9,
  t0.height AS height_10,
  t0.extension AS extension_11,
  t0.position AS position_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.owner_id AS owner_id_15
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.alt AS alt_3, t0.file AS file_4, t0.uuid AS uuid_5, t0.type AS type_6, t0.temp AS temp_7, t0.path AS path_8, t0.width AS width_9, t0.height AS height_10, t0.extension AS extension_11, t0.position AS position_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.owner_id AS owner_id_15 FROM image t0 WHERE t0.id = 27518;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Image::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Image->__get (line 112)
8	App\Entity\Image->getFile (line 28)
9	App\Manager\ImageManager->getPublicUrl (line 26)
10	App\Twig\Runtime\UploadedAssetRuntime->getUploadedAssetPath (line 83)
11	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->block_og_image (line 446)
12	Twig\Template->yieldBlock (line 333)
13	__TwigTemplate_70d7e93218197b48cff238f406a78612->block_meta (line 446)
14	Twig\Template->yieldBlock (line 92)
15	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
16	Twig\Template->yield (line 60)
17	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
18	Twig\Template->yield (line 358)
19	Twig\Template->display (line 373)
20	Twig\Template->render (line 51)
21	Twig\TemplateWrapper->render (line 333)
22	Twig\Environment->render (line 431)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
26	App\Controller\Frontend\BlogController->post (line 183)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

2.62 ms
(21.06%)

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.content AS content_4, b0_.date_created_at AS date_created_at_5, b0_.date_updated_at AS date_updated_at_6, b0_.active AS active_7, b0_.is_featured AS is_featured_8, b0_.position AS position_9, b0_.title AS title_10, b0_.meta_title AS meta_title_11, b0_.meta_keywords AS meta_keywords_12, b0_.meta_description AS meta_description_13, b0_.image_id AS image_id_14, b0_.big_image_id AS big_image_id_15, b0_.author_id AS author_id_16 FROM blog b0_ WHERE b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY RAND() ASC LIMIT 3

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.slug AS slug_2,
  b0_.description AS description_3,
  b0_.content AS content_4,
  b0_.date_created_at AS date_created_at_5,
  b0_.date_updated_at AS date_updated_at_6,
  b0_.active AS active_7,
  b0_.is_featured AS is_featured_8,
  b0_.position AS position_9,
  b0_.title AS title_10,
  b0_.meta_title AS meta_title_11,
  b0_.meta_keywords AS meta_keywords_12,
  b0_.meta_description AS meta_description_13,
  b0_.image_id AS image_id_14,
  b0_.big_image_id AS big_image_id_15,
  b0_.author_id AS author_id_16
FROM
  blog b0_
WHERE
  b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  RAND() ASC
LIMIT
  3

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.content AS content_4, b0_.date_created_at AS date_created_at_5, b0_.date_updated_at AS date_updated_at_6, b0_.active AS active_7, b0_.is_featured AS is_featured_8, b0_.position AS position_9, b0_.title AS title_10, b0_.meta_title AS meta_title_11, b0_.meta_keywords AS meta_keywords_12, b0_.meta_description AS meta_description_13, b0_.image_id AS image_id_14, b0_.big_image_id AS big_image_id_15, b0_.author_id AS author_id_16 FROM blog b0_ WHERE b0_.id IN (11, 17, 15, 19, 3, 24, 9, 12, 20, 13) ORDER BY RAND() ASC LIMIT 3;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 41)
7	App\Twig\Components\SimilarPostsComponent->getPosts (line 1909)
8	Twig\Extension\CoreExtension::getAttribute (line 49)
9	__TwigTemplate_53ae013646176bbfda534068024b509d->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 225)
16	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->block_body (line 446)
17	Twig\Template->yieldBlock (line 199)
18	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
19	Twig\Template->yield (line 60)
20	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
29	App\Controller\Frontend\BlogController->post (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

2.50 ms
(20.10%)

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = ? AND t1_.resource_type = ?) ORDER BY t0_.name ASC

Parameters:

[
  23
  "App\Entity\Blog"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.slug AS slug_2
FROM
  tag t0_
  INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id
  AND (
    t1_.resource_id = ?
    AND t1_.resource_type = ?
  )
ORDER BY
  t0_.name ASC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.slug AS slug_2 FROM tag t0_ INNER JOIN tagging t1_ ON t0_.id = t1_.tag_id AND (t1_.resource_id = 23 AND t1_.resource_type = 'App\\Entity\\Blog') ORDER BY t0_.name ASC;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 389)
7	eduMedia\TagBundle\Service\TagService->queryTagging (line 155)
8	eduMedia\TagBundle\Service\TagService->loadTagging (line 81)
9	eduMedia\TagBundle\Service\TagService->getTags (line 77)
10	App\Controller\Frontend\BlogController->post (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

1.55 ms
(12.44%)

SELECT t0_.resource_id AS resource_id_0 FROM tag t1_ INNER JOIN tagging t0_ ON t1_.id = t0_.tag_id WHERE t0_.resource_type = ? AND t1_.slug IN (?) ORDER BY RAND() ASC

Parameters:

[
  "App\Entity\Blog"
  "pies"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.resource_id AS resource_id_0
FROM
  tag t1_
  INNER JOIN tagging t0_ ON t1_.id = t0_.tag_id
WHERE
  t0_.resource_type = ?
  AND t1_.slug IN (?)
ORDER BY
  RAND() ASC

SELECT t0_.resource_id AS resource_id_0 FROM tag t1_ INNER JOIN tagging t0_ ON t1_.id = t0_.tag_id WHERE t0_.resource_type = 'App\\Entity\\Blog' AND t1_.slug IN ('pies') ORDER BY RAND() ASC;

#	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 55)
6	App\Twig\Components\SimilarPostsComponent->getResourceIdsForTag (line 27)
7	App\Twig\Components\SimilarPostsComponent->getPosts (line 1909)
8	Twig\Extension\CoreExtension::getAttribute (line 49)
9	__TwigTemplate_53ae013646176bbfda534068024b509d->doDisplay (line 402)
10	Twig\Template->yield (line 358)
11	Twig\Template->display (line 373)
12	Twig\Template->render (line 77)
13	Symfony\UX\TwigComponent\ComponentRenderer->render (line 56)
14	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
15	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 225)
16	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->block_body (line 446)
17	Twig\Template->yieldBlock (line 199)
18	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
19	Twig\Template->yield (line 60)
20	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
21	Twig\Template->yield (line 358)
22	Twig\Template->display (line 373)
23	Twig\Template->render (line 51)
24	Twig\TemplateWrapper->render (line 333)
25	Twig\Environment->render (line 431)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
29	App\Controller\Frontend\BlogController->post (line 183)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 5)

0.84 ms
(6.78%)

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.location AS location_2, a0_.advert_height AS advert_height_3, a0_.advert_width AS advert_width_4, a0_.active AS active_5, a0_.max_quantity AS max_quantity_6 FROM advert_group a0_ WHERE a0_.location = ? AND a0_.active = ?

Parameters:

[
  "blog_single_content"
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.location AS location_2,
  a0_.advert_height AS advert_height_3,
  a0_.advert_width AS advert_width_4,
  a0_.active AS active_5,
  a0_.max_quantity AS max_quantity_6
FROM
  advert_group a0_
WHERE
  a0_.location = ?
  AND a0_.active = ?

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.location AS location_2, a0_.advert_height AS advert_height_3, a0_.advert_width AS advert_width_4, a0_.active AS active_5, a0_.max_quantity AS max_quantity_6 FROM advert_group a0_ WHERE a0_.location = 'blog_single_content' AND a0_.active = 1;

#	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 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 53)
7	App\Repository\AdvertGroupRepository->getActiveByLocation (line 34)
8	App\Service\AdvertService->getAdvertGroup (line 29)
9	App\Twig\Components\AdvertBlock->postMount (line 196)
10	Symfony\UX\TwigComponent\ComponentFactory->postMount (line 105)
11	Symfony\UX\TwigComponent\ComponentFactory->mountFromObject (line 81)
12	Symfony\UX\TwigComponent\ComponentFactory->create (line 56)
13	Symfony\UX\TwigComponent\ComponentRenderer->createAndRender (line 51)
14	Symfony\UX\TwigComponent\Twig\ComponentRuntime->render (line 174)
15	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->block_body (line 446)
16	Twig\Template->yieldBlock (line 199)
17	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
18	Twig\Template->yield (line 60)
19	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
20	Twig\Template->yield (line 358)
21	Twig\Template->display (line 373)
22	Twig\Template->render (line 51)
23	Twig\TemplateWrapper->render (line 333)
24	Twig\Environment->render (line 431)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
28	App\Controller\Frontend\BlogController->post (line 183)
29	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
30	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
31	Symfony\Component\HttpKernel\Kernel->handle (line 35)
32	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
33	require_once (line 5)

0.78 ms
(6.27%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.display_name AS display_name_7 FROM employee t0 WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.display_name AS display_name_7
FROM
  employee t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.display_name AS display_name_7 FROM employee t0 WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():219} (line 286)
5	Proxies\__CG__\App\Entity\Employee::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():284}:285} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Employee->__get (line 166)
8	App\Entity\Employee->getDisplayName (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 148)
10	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->block_body (line 446)
11	Twig\Template->yieldBlock (line 199)
12	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
13	Twig\Template->yield (line 60)
14	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 431)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
23	App\Controller\Frontend\BlogController->post (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.72 ms
(5.81%)

SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.value AS value_1
FROM
  setting s0_

SELECT s0_.name AS name_0, s0_.value AS value_1 FROM setting s0_;

#	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 701)
6	Doctrine\ORM\AbstractQuery->getArrayResult (line 66)
7	App\Repository\SettingRepository->findAllOnlyValuesWithKey (line 25)
8	App\Service\SettingService->getList (line 37)
9	App\Service\SettingService->loadList (line 49)
10	App\Service\SettingService->get (line 18)
11	App\Twig\Runtime\SettingExtensionRuntime->setting (line 246)
12	__TwigTemplate_70d7e93218197b48cff238f406a78612->block_title (line 446)
13	Twig\Template->yieldBlock (line 82)
14	__TwigTemplate_70d7e93218197b48cff238f406a78612->doDisplay (line 402)
15	Twig\Template->yield (line 60)
16	__TwigTemplate_f320bbfe46d242a251e9a2dd1eafdfb8->doDisplay (line 402)
17	Twig\Template->yield (line 358)
18	Twig\Template->display (line 373)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 333)
21	Twig\Environment->render (line 431)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 79)
25	App\Controller\Frontend\BlogController->post (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
28	Symfony\Component\HttpKernel\Kernel->handle (line 35)
29	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
30	require_once (line 5)

0.65 ms
(5.25%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.date_created_at AS date_created_at_6, t0.date_updated_at AS date_updated_at_7, t0.active AS active_8, t0.is_featured AS is_featured_9, t0.position AS position_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_keywords AS meta_keywords_13, t0.meta_description AS meta_description_14, t0.image_id AS image_id_15, t0.big_image_id AS big_image_id_16, t0.author_id AS author_id_17 FROM blog t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "jak-zalozyc-hodowle-psow-rasowych-poradnik-krok-po-kroku"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4,
  t0.content AS content_5,
  t0.date_created_at AS date_created_at_6,
  t0.date_updated_at AS date_updated_at_7,
  t0.active AS active_8,
  t0.is_featured AS is_featured_9,
  t0.position AS position_10,
  t0.title AS title_11,
  t0.meta_title AS meta_title_12,
  t0.meta_keywords AS meta_keywords_13,
  t0.meta_description AS meta_description_14,
  t0.image_id AS image_id_15,
  t0.big_image_id AS big_image_id_16,
  t0.author_id AS author_id_17
FROM
  blog t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.content AS content_5, t0.date_created_at AS date_created_at_6, t0.date_updated_at AS date_updated_at_7, t0.active AS active_8, t0.is_featured AS is_featured_9, t0.position AS position_10, t0.title AS title_11, t0.meta_title AS meta_title_12, t0.meta_keywords AS meta_keywords_13, t0.meta_description AS meta_description_14, t0.image_id AS image_id_15, t0.big_image_id AS big_image_id_16, t0.author_id AS author_id_17 FROM blog t0 WHERE t0.slug = 'jak-zalozyc-hodowle-psow-rasowych-poradnik-krok-po-kroku' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 69)
5	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
6	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
7	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
8	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
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)

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\Blog	6
App\Entity\Image	6
App\Entity\Employee	2
App\Entity\Tag	1
App\Entity\AdvertGroup	1

Entities Mapping

Class	Mapping errors
App\Entity\Blog	No errors.
App\Entity\Image	No errors.
App\Entity\Employee	No errors.
App\Entity\Tag	No errors.
App\Entity\Tagging	No errors.
App\Entity\Setting	No errors.
App\Entity\User	The mappings App\Entity\User#plans and App\Entity\UserPlan#owner are inconsistent with each other.
App\Entity\AdvertGroup	No errors.
App\Entity\Advert	No errors.

Symfony Profiler

GET https://dev.petso.halisz.pl/blog/jak-zalozyc-hodowle-psow-rasowych-poradnik-krok-po-kroku

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping