Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

1.44 ms Query time

4 Invalid entities

34 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.85 ms
(59.38%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c0_.category_id AS category_id_13 FROM chogan_product c0_ WHERE c0_.average_rating IS NOT NULL AND c0_.available IS NOT NULL ORDER BY c0_.average_rating DESC, c0_.ratings_count DESC LIMIT 4

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_description AS short_description_2,
  c0_.description AS description_3,
  c0_.default_image AS default_image_4,
  c0_.available AS available_5,
  c0_.tags AS tags_6,
  c0_.video AS video_7,
  c0_.price AS price_8,
  c0_.info AS info_9,
  c0_.average_rating AS average_rating_10,
  c0_.ratings_count AS ratings_count_11,
  c0_.size AS size_12,
  c0_.category_id AS category_id_13
FROM
  chogan_product c0_
WHERE
  c0_.average_rating IS NOT NULL
  AND c0_.available IS NOT NULL
ORDER BY
  c0_.average_rating DESC,
  c0_.ratings_count DESC
LIMIT
  4

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_description AS short_description_2, c0_.description AS description_3, c0_.default_image AS default_image_4, c0_.available AS available_5, c0_.tags AS tags_6, c0_.video AS video_7, c0_.price AS price_8, c0_.info AS info_9, c0_.average_rating AS average_rating_10, c0_.ratings_count AS ratings_count_11, c0_.size AS size_12, c0_.category_id AS category_id_13 FROM chogan_product c0_ WHERE c0_.average_rating IS NOT NULL AND c0_.available IS NOT NULL ORDER BY c0_.average_rating DESC, c0_.ratings_count DESC LIMIT 4;

#	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 69)
7	App\Repository\ChoganProductRepository->findTopRated (line 18)
8	App\Controller\App\Chogan\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)

0.30 ms
(20.77%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM chogan_category c0_ ORDER BY c0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.slug AS slug_2
FROM
  chogan_category c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2 FROM chogan_category c0_ ORDER BY c0_.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 35)
6	Symfony\Bridge\Doctrine\Form\ChoiceList\ORMQueryBuilderLoader->getEntities (line 53)
7	Symfony\Bridge\Doctrine\Form\ChoiceList\DoctrineChoiceLoader->loadChoices (line 29)
8	Symfony\Component\Form\ChoiceList\Loader\AbstractChoiceLoader->loadChoiceList (line 56)
9	Symfony\Component\Form\ChoiceList\LazyChoiceList->getChoices (line 60)
10	Symfony\Component\Form\ChoiceList\Factory\DefaultChoiceListFactory->createView (line 178)
11	Symfony\Component\Form\ChoiceList\Factory\PropertyAccessDecorator->createView (line 187)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 479)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 234)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildView (line 107)
15	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 105)
17	Symfony\Component\Form\ResolvedFormType->buildView (line 78)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildView (line 888)
19	Symfony\Component\Form\Form->createView (line 891)
20	Symfony\Component\Form\Form->createView (line 18)
21	App\Controller\App\Chogan\PartialController->navbarSearch (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
24	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
25	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
26	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
27	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
28	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 313)
29	__TwigTemplate_fed96cd075a82136a1c72089f2733537->doDisplay (line 402)
30	Twig\Template->yield (line 135)
31	__TwigTemplate_2ef392c9d414f2f41fa43d5420f2c203->doDisplay (line 402)
32	Twig\Template->yield (line 55)
33	__TwigTemplate_4b3b0b271ba9f1b70e5e598ac483bfe0->doDisplay (line 402)
34	Twig\Template->yield (line 358)
35	Twig\Template->display (line 373)
36	Twig\Template->render (line 51)
37	Twig\TemplateWrapper->render (line 333)
38	Twig\Environment->render (line 459)
39	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
40	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 19)
42	App\Controller\App\Chogan\PageController->index (line 183)
43	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
44	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
45	Symfony\Component\HttpKernel\Kernel->handle (line 35)
46	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
47	require_once (line 5)

0.29 ms
(19.85%)

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 55)
13	__TwigTemplate_4b3b0b271ba9f1b70e5e598ac483bfe0->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 19)
22	App\Controller\App\Chogan\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\ChoganCategory	29
App\Entity\ChoganProduct	4
App\Entity\Partner	1

Entities Mapping

Class	Mapping errors
App\Entity\ChoganProduct	No errors.
App\Entity\ChoganCategory	No errors.
App\Entity\ChoganRating	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\ChoganFragrance	No errors.
App\Entity\ChoganSize	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\ChoganColor	No errors.
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\Product	No errors.
App\Entity\ChoganOrder	No errors.
App\Entity\Company	No errors.
App\Entity\Carrier	No errors.
App\Entity\Chapter	No errors.
App\Entity\Client	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\Rating	The association App\Entity\Rating#user refers to the inverse side field App\Entity\User#ratings which does not exist.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\WishlistItem	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.entremums.com/bien-etre

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping