Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

2.99 ms Query time

0 Invalid entities

28 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.86 ms
(28.62%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.contact_email AS contact_email_5, t0.main_color AS main_color_6, t0.secondary_color AS secondary_color_7, t0.third_color AS third_color_8, t0.text_color AS text_color_9, t0.background_image AS background_image_10, t0.location AS location_11, t0.legal_advise AS legal_advise_12, t0.privacy_policy AS privacy_policy_13, t0.slogan AS slogan_14, t0.about_us AS about_us_15, t0.why_choose_us AS why_choose_us_16 FROM brand 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.logo AS logo_3,
  t0.phone AS phone_4,
  t0.contact_email AS contact_email_5,
  t0.main_color AS main_color_6,
  t0.secondary_color AS secondary_color_7,
  t0.third_color AS third_color_8,
  t0.text_color AS text_color_9,
  t0.background_image AS background_image_10,
  t0.location AS location_11,
  t0.legal_advise AS legal_advise_12,
  t0.privacy_policy AS privacy_policy_13,
  t0.slogan AS slogan_14,
  t0.about_us AS about_us_15,
  t0.why_choose_us AS why_choose_us_16
FROM
  brand t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.logo AS logo_3, t0.phone AS phone_4, t0.contact_email AS contact_email_5, t0.main_color AS main_color_6, t0.secondary_color AS secondary_color_7, t0.third_color AS third_color_8, t0.text_color AS text_color_9, t0.background_image AS background_image_10, t0.location AS location_11, t0.legal_advise AS legal_advise_12, t0.privacy_policy AS privacy_policy_13, t0.slogan AS slogan_14, t0.about_us AS about_us_15, t0.why_choose_us AS why_choose_us_16 FROM brand t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->__construct (line 26)
6	ContainerLR6WBLG\App_KernelDevDebugContainer->getTwigService (line 2060)
7	ContainerLR6WBLG\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 616)
8	ContainerLR6WBLG\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1102)
9	ContainerLR6WBLG\App_KernelDevDebugContainer::ContainerLR6WBLG\{closure} (line 837)
10	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.50 ms
(16.64%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.brand AS brand_3, t0.description AS description_4, t0.image AS image_5, t0.category AS category_6 FROM product 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.brand AS brand_3,
  t0.description AS description_4,
  t0.image AS image_5,
  t0.category AS category_6
FROM
  product t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.brand AS brand_3, t0.description AS description_4, t0.image AS image_5, t0.category AS category_6 FROM product t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->__construct (line 33)
6	ContainerLR6WBLG\App_KernelDevDebugContainer->getTwigService (line 2060)
7	ContainerLR6WBLG\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 616)
8	ContainerLR6WBLG\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1102)
9	ContainerLR6WBLG\App_KernelDevDebugContainer::ContainerLR6WBLG\{closure} (line 837)
10	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.37 ms
(12.51%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4 FROM feature t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.icon AS icon_4
FROM
  feature t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4 FROM feature t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->getFeatures (line 162)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_1827747179c0b9eca794fd30285b9cef::block_body (line 170)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c7e91fe0a9723222b62e76832558bd62->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1827747179c0b9eca794fd30285b9cef->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\HomeController->index (line 50)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.33 ms
(10.90%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.monthly_price AS monthly_price_4, t0.yearly_price AS yearly_price_5, t0.icon AS icon_6, t0.pricing_unit AS pricing_unit_7 FROM plan t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.monthly_price AS monthly_price_4,
  t0.yearly_price AS yearly_price_5,
  t0.icon AS icon_6,
  t0.pricing_unit AS pricing_unit_7
FROM
  plan t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.monthly_price AS monthly_price_4, t0.yearly_price AS yearly_price_5, t0.icon AS icon_6, t0.pricing_unit AS pricing_unit_7 FROM plan t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->getPlans (line 186)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_1827747179c0b9eca794fd30285b9cef::block_body (line 834)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c7e91fe0a9723222b62e76832558bd62->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1827747179c0b9eca794fd30285b9cef->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\HomeController->index (line 50)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.28 ms
(9.43%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.bullet AS bullet_3, t0.image AS image_4, t0.body AS body_5, t0.author AS author_6, t0.tags AS tags_7, t0.section AS section_8, t0.publish_date AS publish_date_9, t0.published AS published_10 FROM blog t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.bullet AS bullet_3,
  t0.image AS image_4,
  t0.body AS body_5,
  t0.author AS author_6,
  t0.tags AS tags_7,
  t0.section AS section_8,
  t0.publish_date AS publish_date_9,
  t0.published AS published_10
FROM
  blog t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.bullet AS bullet_3, t0.image AS image_4, t0.body AS body_5, t0.author AS author_6, t0.tags AS tags_7, t0.section AS section_8, t0.publish_date AS publish_date_9, t0.published AS published_10 FROM blog t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->getBlogs (line 194)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_1827747179c0b9eca794fd30285b9cef::block_body (line 627)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c7e91fe0a9723222b62e76832558bd62->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1827747179c0b9eca794fd30285b9cef->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\HomeController->index (line 50)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.23 ms
(7.59%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.logo AS logo_4 FROM social_network 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.link AS link_3,
  t0.logo AS logo_4
FROM
  social_network t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.logo AS logo_4 FROM social_network t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->__construct (line 32)
6	ContainerLR6WBLG\App_KernelDevDebugContainer->getTwigService (line 2060)
7	ContainerLR6WBLG\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 616)
8	ContainerLR6WBLG\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 1102)
9	ContainerLR6WBLG\App_KernelDevDebugContainer::ContainerLR6WBLG\{closure} (line 837)
10	Symfony\Component\EventDispatcher\EventDispatcher::sortListeners (line 221)
11	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 70)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 256)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 120)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
16	Symfony\Component\HttpKernel\Kernel->handle (line 182)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
18	require_once (line 29)
19	require_once (line 5)

0.22 ms
(7.29%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.second_name AS second_name_3, t0.father_name AS father_name_4, t0.mother_name AS mother_name_5, t0.position AS position_6, t0.image AS image_7, t0.description AS description_8, t0.greetings AS greetings_9 FROM talent t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.second_name AS second_name_3,
  t0.father_name AS father_name_4,
  t0.mother_name AS mother_name_5,
  t0.position AS position_6,
  t0.image AS image_7,
  t0.description AS description_8,
  t0.greetings AS greetings_9
FROM
  talent t0

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.second_name AS second_name_3, t0.father_name AS father_name_4, t0.mother_name AS mother_name_5, t0.position AS position_6, t0.image AS image_7, t0.description AS description_8, t0.greetings AS greetings_9 FROM talent t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->getTalents (line 170)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_1827747179c0b9eca794fd30285b9cef::block_body (line 295)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c7e91fe0a9723222b62e76832558bd62->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1827747179c0b9eca794fd30285b9cef->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\HomeController->index (line 50)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	require_once (line 5)

0.21 ms
(7.02%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.base_price AS base_price_5 FROM service t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.icon AS icon_4,
  t0.base_price AS base_price_5
FROM
  service t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.icon AS icon_4, t0.base_price AS base_price_5 FROM service t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\BrandInfoService->getServices (line 178)
6	Twig\Extension\CoreExtension->getAttribute (line 1913)
7	__TwigTemplate_1827747179c0b9eca794fd30285b9cef::block_body (line 359)
8	Twig\Template->yieldBlock (line 446)
9	__TwigTemplate_c7e91fe0a9723222b62e76832558bd62->doDisplay (line 128)
10	Twig\Template->yield (line 402)
11	__TwigTemplate_1827747179c0b9eca794fd30285b9cef->doDisplay (line 54)
12	Twig\Template->yield (line 402)
13	Twig\Template->display (line 358)
14	Twig\Template->render (line 373)
15	Twig\TemplateWrapper->render (line 51)
16	Twig\Environment->render (line 333)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 459)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 464)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 278)
20	App\Controller\HomeController->index (line 50)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
23	Symfony\Component\HttpKernel\Kernel->handle (line 182)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
25	require_once (line 29)
26	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	21
App\Entity\Brand	1
App\Entity\SocialNetwork	1
App\Entity\Feature	1
App\Entity\Talent	1
App\Entity\Service	1
App\Entity\Blog	1
App\Entity\Plan	1

Entities Mapping

Class	Mapping errors
App\Entity\Brand	No errors.
App\Entity\SocialNetwork	No errors.
App\Entity\Product	No errors.
App\Entity\Feature	No errors.
App\Entity\Talent	No errors.
App\Entity\Service	No errors.
App\Entity\Blog	No errors.
App\Entity\ContactForm	No errors.
App\Entity\Plan	No errors.
App\Entity\FinalClient	No errors.

Symfony Profiler

GET https://dev.hisoluciones.com.mx/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping