Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

6.94 ms Query time

3 Invalid entities

3 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.37 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.illustration AS illustration_4, t0.weight AS weight_5, t0.available AS available_6, t0.short_description AS short_description_7, t0.description AS description_8, t0.tags AS tags_9, t0.average_rating AS average_rating_10, t0.ratings_count AS ratings_count_11, t0.info AS info_12, t0.stock AS stock_13, t0.seller_id AS seller_id_14 FROM product t0 WHERE t0.id = ?

Parameters:

[
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.price AS price_3,
  t0.illustration AS illustration_4,
  t0.weight AS weight_5,
  t0.available AS available_6,
  t0.short_description AS short_description_7,
  t0.description AS description_8,
  t0.tags AS tags_9,
  t0.average_rating AS average_rating_10,
  t0.ratings_count AS ratings_count_11,
  t0.info AS info_12,
  t0.stock AS stock_13,
  t0.seller_id AS seller_id_14
FROM
  product t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.illustration AS illustration_4, t0.weight AS weight_5, t0.available AS available_6, t0.short_description AS short_description_7, t0.description AS description_8, t0.tags AS tags_9, t0.average_rating AS average_rating_10, t0.ratings_count AS ratings_count_11, t0.info AS info_12, t0.stock AS stock_13, t0.seller_id AS seller_id_14 FROM product t0 WHERE t0.id = '1';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

4.35 ms

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.phone AS phone_5, u0_.avatar AS avatar_6, u0_.is_verified AS is_verified_7, u0_.address AS address_8, u0_.address_box AS address_box_9, u0_.postal AS postal_10, u0_.city AS city_11, u0_.country AS country_12, u0_.company_id AS company_id_13 FROM `user` u0_ INNER JOIN user_role u2_ ON u0_.id = u2_.user_id INNER JOIN role r1_ ON r1_.id = u2_.role_id WHERE r1_.title = ?

Parameters:

[
  "ROLE_SHOPPER"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.phone AS phone_5,
  u0_.avatar AS avatar_6,
  u0_.is_verified AS is_verified_7,
  u0_.address AS address_8,
  u0_.address_box AS address_box_9,
  u0_.postal AS postal_10,
  u0_.city AS city_11,
  u0_.country AS country_12,
  u0_.company_id AS company_id_13
FROM
  `user` u0_
  INNER JOIN user_role u2_ ON u0_.id = u2_.user_id
  INNER JOIN role r1_ ON r1_.id = u2_.role_id
WHERE
  r1_.title = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.phone AS phone_5, u0_.avatar AS avatar_6, u0_.is_verified AS is_verified_7, u0_.address AS address_8, u0_.address_box AS address_box_9, u0_.postal AS postal_10, u0_.city AS city_11, u0_.country AS country_12, u0_.company_id AS company_id_13 FROM `user` u0_ INNER JOIN user_role u2_ ON u0_.id = u2_.user_id INNER JOIN role r1_ ON r1_.id = u2_.role_id WHERE r1_.title = 'ROLE_SHOPPER';

#	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 43)
7	App\Repository\UserRepository->findActiveShoppers (line 28)
8	App\Controller\App\Shop\PartialController->navbar (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
11	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
12	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
13	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
14	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
15	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 119)
16	__TwigTemplate_2ef392c9d414f2f41fa43d5420f2c203->doDisplay (line 402)
17	Twig\Template->yield (line 54)
18	__TwigTemplate_97b49027affc45aa4322e06c00da79c6->doDisplay (line 402)
19	Twig\Template->yield (line 358)
20	Twig\Template->display (line 373)
21	Twig\Template->render (line 51)
22	Twig\TemplateWrapper->render (line 333)
23	Twig\Environment->render (line 459)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
25	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
27	App\Controller\App\Shop\ShopController->show (line 183)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

1.21 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.tva AS tva_3, t0.address AS address_4, t0.address_box AS address_box_5, t0.postal AS postal_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.avatar AS avatar_10, t0.bio AS bio_11, t0.slug AS slug_12, t0.city AS city_13, t14.id AS id_15, t14.email AS email_16, t14.password AS password_17, t14.first_name AS first_name_18, t14.last_name AS last_name_19, t14.phone AS phone_20, t14.avatar AS avatar_21, t14.is_verified AS is_verified_22, t14.address AS address_23, t14.address_box AS address_box_24, t14.postal AS postal_25, t14.city AS city_26, t14.country AS country_27, t14.company_id AS company_id_28 FROM company t0 LEFT JOIN `user` t14 ON t14.company_id = t0.id WHERE t0.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tva AS tva_3,
  t0.address AS address_4,
  t0.address_box AS address_box_5,
  t0.postal AS postal_6,
  t0.country AS country_7,
  t0.phone AS phone_8,
  t0.email AS email_9,
  t0.avatar AS avatar_10,
  t0.bio AS bio_11,
  t0.slug AS slug_12,
  t0.city AS city_13,
  t14.id AS id_15,
  t14.email AS email_16,
  t14.password AS password_17,
  t14.first_name AS first_name_18,
  t14.last_name AS last_name_19,
  t14.phone AS phone_20,
  t14.avatar AS avatar_21,
  t14.is_verified AS is_verified_22,
  t14.address AS address_23,
  t14.address_box AS address_box_24,
  t14.postal AS postal_25,
  t14.city AS city_26,
  t14.country AS country_27,
  t14.company_id AS company_id_28
FROM
  company t0
  LEFT JOIN `user` t14 ON t14.company_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.tva AS tva_3, t0.address AS address_4, t0.address_box AS address_box_5, t0.postal AS postal_6, t0.country AS country_7, t0.phone AS phone_8, t0.email AS email_9, t0.avatar AS avatar_10, t0.bio AS bio_11, t0.slug AS slug_12, t0.city AS city_13, t14.id AS id_15, t14.email AS email_16, t14.password AS password_17, t14.first_name AS first_name_18, t14.last_name AS last_name_19, t14.phone AS phone_20, t14.avatar AS avatar_21, t14.is_verified AS is_verified_22, t14.address AS address_23, t14.address_box AS address_box_24, t14.postal AS postal_25, t14.city AS city_26, t14.country AS country_27, t14.company_id AS company_id_28 FROM company t0 LEFT JOIN `user` t14 ON t14.company_id = t0.id WHERE t0.id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::{closure:Doctrine\ORM\Proxy\ProxyFactory::createLazyInitializer():288} (line 367)
5	Proxies\__CG__\App\Entity\Company::{closure:{closure:Doctrine\ORM\Proxy\ProxyFactory::getProxyFactory():365}:366} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Company->__get (line 199)
8	App\Entity\Company->getSlug (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 85)
10	__TwigTemplate_fc1635f627ab2312d0e7291d02ae7e0d->doDisplay (line 402)
11	Twig\Template->yield (line 358)
12	Twig\Template->display (line 373)
13	Twig\Template->render (line 51)
14	Twig\TemplateWrapper->render (line 333)
15	Twig\Environment->render (line 459)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 41)
19	App\Controller\App\Shop\PartialController->navbar (line 183)
20	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
21	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
22	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
23	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
24	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
25	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
26	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 119)
27	__TwigTemplate_2ef392c9d414f2f41fa43d5420f2c203->doDisplay (line 402)
28	Twig\Template->yield (line 54)
29	__TwigTemplate_97b49027affc45aa4322e06c00da79c6->doDisplay (line 402)
30	Twig\Template->yield (line 358)
31	Twig\Template->display (line 373)
32	Twig\Template->render (line 51)
33	Twig\TemplateWrapper->render (line 333)
34	Twig\Environment->render (line 459)
35	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
36	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
37	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 23)
38	App\Controller\App\Shop\ShopController->show (line 183)
39	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
40	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
41	Symfony\Component\HttpKernel\Kernel->handle (line 35)
42	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
43	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\Product	1
App\Entity\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\Product	No errors.
App\Entity\User	The field App\Entity\User#roleEntities is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Role#users does not contain the required 'mappedBy: "roleEntities"' attribute.
App\Entity\Rating	The association App\Entity\Rating#user refers to the inverse side field App\Entity\User#ratings which does not exist.
App\Entity\Role	The association App\Entity\Role#users refers to the inverse side field App\Entity\User#roles which does not exist.
App\Entity\Company	No errors.
App\Entity\ChoganOrder	No errors.

Symfony Profiler

GET https://entremums.com/_partial/shop/navbar-search

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping