Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

3.27 ms Query time

4 Invalid entities

4 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.95 ms

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.illustration AS illustration_3, p0_.weight AS weight_4, p0_.available AS available_5, p0_.short_description AS short_description_6, p0_.description AS description_7, p0_.tags AS tags_8, p0_.average_rating AS average_rating_9, p0_.ratings_count AS ratings_count_10, p0_.info AS info_11, p0_.stock AS stock_12, p0_.seller_id AS seller_id_13 FROM product p0_ WHERE p0_.average_rating IS NOT NULL AND p0_.available IS NOT NULL ORDER BY p0_.average_rating DESC, p0_.ratings_count DESC LIMIT 5

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.price AS price_2,
  p0_.illustration AS illustration_3,
  p0_.weight AS weight_4,
  p0_.available AS available_5,
  p0_.short_description AS short_description_6,
  p0_.description AS description_7,
  p0_.tags AS tags_8,
  p0_.average_rating AS average_rating_9,
  p0_.ratings_count AS ratings_count_10,
  p0_.info AS info_11,
  p0_.stock AS stock_12,
  p0_.seller_id AS seller_id_13
FROM
  product p0_
WHERE
  p0_.average_rating IS NOT NULL
  AND p0_.available IS NOT NULL
ORDER BY
  p0_.average_rating DESC,
  p0_.ratings_count DESC
LIMIT
  5

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.price AS price_2, p0_.illustration AS illustration_3, p0_.weight AS weight_4, p0_.available AS available_5, p0_.short_description AS short_description_6, p0_.description AS description_7, p0_.tags AS tags_8, p0_.average_rating AS average_rating_9, p0_.ratings_count AS ratings_count_10, p0_.info AS info_11, p0_.stock AS stock_12, p0_.seller_id AS seller_id_13 FROM product p0_ WHERE p0_.average_rating IS NOT NULL AND p0_.available IS NOT NULL ORDER BY p0_.average_rating DESC, p0_.ratings_count DESC LIMIT 5;

#	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 38)
7	App\Repository\ProductRepository->findTopRated (line 19)
8	App\Controller\App\Shop\PageController->index (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)

1.19 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_8435954893952aa9a81bf0f36b9e062c->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 20)
27	App\Controller\App\Shop\PageController->index (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)

0.74 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_8435954893952aa9a81bf0f36b9e062c->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 20)
38	App\Controller\App\Shop\PageController->index (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)

0.40 ms

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image AS image_4 FROM partner t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.image AS image_4
FROM
  partner t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.image AS image_4 FROM partner t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 1909)
6	Twig\Extension\CoreExtension::getAttribute (line 57)
7	__TwigTemplate_006a275bf78fdc692fb446540567bfb8->doDisplay (line 402)
8	Twig\Template->yield (line 319)
9	__TwigTemplate_2ef392c9d414f2f41fa43d5420f2c203->block_partners (line 446)
10	Twig\Template->yieldBlock (line 157)
11	__TwigTemplate_2ef392c9d414f2f41fa43d5420f2c203->doDisplay (line 402)
12	Twig\Template->yield (line 54)
13	__TwigTemplate_8435954893952aa9a81bf0f36b9e062c->doDisplay (line 402)
14	Twig\Template->yield (line 358)
15	Twig\Template->display (line 373)
16	Twig\Template->render (line 51)
17	Twig\TemplateWrapper->render (line 333)
18	Twig\Environment->render (line 459)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 20)
22	App\Controller\App\Shop\PageController->index (line 183)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	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
App\Entity\Partner	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.
App\Entity\Client	No errors.
App\Entity\WishlistItem	No errors.
App\Entity\Carrier	No errors.
App\Entity\Chapter	No errors.
App\Entity\ChoganCategory	No errors.
App\Entity\ChoganColor	No errors.
App\Entity\ChoganFragrance	No errors.
App\Entity\ChoganIllustration	The association App\Entity\ChoganIllustration#color refers to the inverse side field App\Entity\ChoganColor#illustrations which does not exist.
App\Entity\ChoganProduct	No errors.
App\Entity\ChoganRating	No errors.
App\Entity\ChoganSize	No errors.
App\Entity\Course	No errors.
App\Entity\Document	No errors.
App\Entity\Lesson	No errors.
App\Entity\Order	No errors.
App\Entity\OrderDetails	No errors.
App\Entity\Partner	No errors.
App\Entity\Progress	No errors.
App\Entity\ResetPasswordRequest	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.entremums.com/boutique

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping