Symfony Profiler

Query Metrics

9 Database Queries

6 Different statements

2.86 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.71 ms
(24.77%)

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_name AS logo_name_3, t0.logo_footer_name AS logo_footer_name_4, t0.tel AS tel_5, t0.email AS email_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.twitter AS twitter_9, t0.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.instagram AS instagram_12, t0.slogan AS slogan_13, t0.updated_at AS updated_at_14, t0.bg_header_name AS bg_header_name_15, t0.bg_footer_name AS bg_footer_name_16, t0.theme AS theme_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19 FROM parameter t0 WHERE t0.nom = ? LIMIT 1

Parameters:

[
  "header-footer"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.logo_name AS logo_name_3,
  t0.logo_footer_name AS logo_footer_name_4,
  t0.tel AS tel_5,
  t0.email AS email_6,
  t0.adresse1 AS adresse1_7,
  t0.adresse2 AS adresse2_8,
  t0.twitter AS twitter_9,
  t0.facebook AS facebook_10,
  t0.pinterest AS pinterest_11,
  t0.instagram AS instagram_12,
  t0.slogan AS slogan_13,
  t0.updated_at AS updated_at_14,
  t0.bg_header_name AS bg_header_name_15,
  t0.bg_footer_name AS bg_footer_name_16,
  t0.theme AS theme_17,
  t0.latitude AS latitude_18,
  t0.longitude AS longitude_19
FROM
  parameter t0
WHERE
  t0.nom = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.logo_name AS logo_name_3, t0.logo_footer_name AS logo_footer_name_4, t0.tel AS tel_5, t0.email AS email_6, t0.adresse1 AS adresse1_7, t0.adresse2 AS adresse2_8, t0.twitter AS twitter_9, t0.facebook AS facebook_10, t0.pinterest AS pinterest_11, t0.instagram AS instagram_12, t0.slogan AS slogan_13, t0.updated_at AS updated_at_14, t0.bg_header_name AS bg_header_name_15, t0.bg_footer_name AS bg_footer_name_16, t0.theme AS theme_17, t0.latitude AS latitude_18, t0.longitude AS longitude_19 FROM parameter t0 WHERE t0.nom = 'header-footer' 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 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 98)
5	App\Controller\HomeController->header (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
8	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
9	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
10	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
11	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
12	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 142)
13	__TwigTemplate_1c32d4f13ab873b09e932fef90d3b17e->doDisplay (line 387)
14	Twig\Template->yield (line 54)
15	__TwigTemplate_4846fa74212d28c7f48ca0b50ac0e594->doDisplay (line 387)
16	Twig\Template->yield (line 343)
17	Twig\Template->display (line 358)
18	Twig\Template->render (line 51)
19	Twig\TemplateWrapper->render (line 320)
20	Twig\Environment->render (line 431)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
24	App\Controller\TeamController->teamShow (line 183)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 5)

0.66 ms
(23.20%)

SELECT t0.id AS id_1, t0.name AS name_2 FROM skill 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
FROM
  skill t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM skill 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::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Skill::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 129)
7	Proxies\__CG__\App\Entity\Skill->__get (line 48)
8	App\Entity\Skill->getName (line 1871)
9	Twig\Extension\CoreExtension::getAttribute (line 217)
10	__TwigTemplate_4846fa74212d28c7f48ca0b50ac0e594->block_main (line 431)
11	Twig\Template->yieldBlock (line 265)
12	__TwigTemplate_1c32d4f13ab873b09e932fef90d3b17e->doDisplay (line 387)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_4846fa74212d28c7f48ca0b50ac0e594->doDisplay (line 387)
15	Twig\Template->yield (line 343)
16	Twig\Template->display (line 358)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 320)
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 37)
23	App\Controller\TeamController->teamShow (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.47 ms
(16.36%)

SELECT t0_.id AS id_0, t0_.level AS level_1, t0_.team_id AS team_id_2, t0_.skill_id AS skill_id_3 FROM team_skill t0_ WHERE t0_.team_id = ? ORDER BY t0_.id ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0_.id AS id_0,
  t0_.level AS level_1,
  t0_.team_id AS team_id_2,
  t0_.skill_id AS skill_id_3
FROM
  team_skill t0_
WHERE
  t0_.team_id = ?
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.level AS level_1, t0_.team_id AS team_id_2, t0_.skill_id AS skill_id_3 FROM team_skill t0_ WHERE t0_.team_id = 1 ORDER BY t0_.id 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 60)
7	App\Repository\TeamSkillRepository->findByTeamField (line 36)
8	App\Controller\TeamController->teamShow (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.42 ms
(14.81%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.job AS job_3, t0.image_file_name AS image_file_name_4, t0.slogan AS slogan_5, t0.description AS description_6, t0.experience AS experience_7, t0.slug AS slug_8, t0.summary AS summary_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.pinterest AS pinterest_12, t0.instagram AS instagram_13, t0.updated_at AS updated_at_14 FROM team t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "guillaume"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.job AS job_3,
  t0.image_file_name AS image_file_name_4,
  t0.slogan AS slogan_5,
  t0.description AS description_6,
  t0.experience AS experience_7,
  t0.slug AS slug_8,
  t0.summary AS summary_9,
  t0.twitter AS twitter_10,
  t0.facebook AS facebook_11,
  t0.pinterest AS pinterest_12,
  t0.instagram AS instagram_13,
  t0.updated_at AS updated_at_14
FROM
  team t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.job AS job_3, t0.image_file_name AS image_file_name_4, t0.slogan AS slogan_5, t0.description AS description_6, t0.experience AS experience_7, t0.slug AS slug_8, t0.summary AS summary_9, t0.twitter AS twitter_10, t0.facebook AS facebook_11, t0.pinterest AS pinterest_12, t0.instagram AS instagram_13, t0.updated_at AS updated_at_14 FROM team t0 WHERE t0.slug = 'guillaume' 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 80)
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 90)
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)

0.31 ms
(10.89%)

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM categories c0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  categories c0_

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM categories c0_;

#	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 189)
12	Symfony\Component\Form\ChoiceList\Factory\CachingFactoryDecorator->createView (line 458)
13	Symfony\Component\Form\Extension\Core\Type\ChoiceType->createChoiceListView (line 82)
14	Symfony\Component\Form\Extension\Core\Type\ChoiceType->buildForm (line 96)
15	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
16	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 94)
17	Symfony\Component\Form\ResolvedFormType->buildForm (line 73)
18	Symfony\Component\Form\Extension\DataCollector\Proxy\ResolvedTypeDataCollectorProxy->buildForm (line 56)
19	Symfony\Component\Form\FormFactory->createNamedBuilder (line 80)
20	Symfony\Component\Form\FormBuilder->create (line 207)
21	Symfony\Component\Form\FormBuilder->resolveChildren (line 160)
22	Symfony\Component\Form\FormBuilder->getForm (line 26)
23	Symfony\Component\Form\FormFactory->create (line 323)
24	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->createForm (line 125)
25	App\Controller\HomeController->newsletters (line 183)
26	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
27	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
28	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
29	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
30	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
31	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
32	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 319)
33	__TwigTemplate_1c32d4f13ab873b09e932fef90d3b17e->doDisplay (line 387)
34	Twig\Template->yield (line 54)
35	__TwigTemplate_4846fa74212d28c7f48ca0b50ac0e594->doDisplay (line 387)
36	Twig\Template->yield (line 343)
37	Twig\Template->display (line 358)
38	Twig\Template->render (line 51)
39	Twig\TemplateWrapper->render (line 320)
40	Twig\Environment->render (line 431)
41	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
42	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
43	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 37)
44	App\Controller\TeamController->teamShow (line 183)
45	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
46	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
47	Symfony\Component\HttpKernel\Kernel->handle (line 35)
48	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
49	require_once (line 5)

0.28 ms
(9.98%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_file_name AS image_file_name_3, t0.icon AS icon_4, t0.description AS description_5, t0.flyers_file_name AS flyers_file_name_6, t0.slug AS slug_7, t0.slogan AS slogan_8, t0.summary AS summary_9, t0.updated_at AS updated_at_10, t0.benefit_id AS benefit_id_11 FROM services 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.image_file_name AS image_file_name_3,
  t0.icon AS icon_4,
  t0.description AS description_5,
  t0.flyers_file_name AS flyers_file_name_6,
  t0.slug AS slug_7,
  t0.slogan AS slogan_8,
  t0.summary AS summary_9,
  t0.updated_at AS updated_at_10,
  t0.benefit_id AS benefit_id_11
FROM
  services t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.image_file_name AS image_file_name_3, t0.icon AS icon_4, t0.description AS description_5, t0.flyers_file_name AS flyers_file_name_6, t0.slug AS slug_7, t0.slogan AS slogan_8, t0.summary AS summary_9, t0.updated_at AS updated_at_10, t0.benefit_id AS benefit_id_11 FROM services t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 938)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 114)
6	App\Controller\HomeController->footer (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 86)
9	Symfony\Component\HttpKernel\HttpCache\SubRequestHandler::handle (line 75)
10	Symfony\Component\HttpKernel\Fragment\InlineFragmentRenderer->render (line 81)
11	Symfony\Component\HttpKernel\Fragment\FragmentHandler->render (line 46)
12	Symfony\Component\HttpKernel\DependencyInjection\LazyLoadingFragmentHandler->render (line 41)
13	Symfony\Bridge\Twig\Extension\HttpKernelRuntime->renderFragment (line 301)
14	__TwigTemplate_1c32d4f13ab873b09e932fef90d3b17e->doDisplay (line 387)
15	Twig\Template->yield (line 54)
16	__TwigTemplate_4846fa74212d28c7f48ca0b50ac0e594->doDisplay (line 387)
17	Twig\Template->yield (line 343)
18	Twig\Template->display (line 358)
19	Twig\Template->render (line 51)
20	Twig\TemplateWrapper->render (line 320)
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 37)
25	App\Controller\TeamController->teamShow (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)

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.

Entities Mapping

Class	Mapping errors
App\Entity\Team	No errors.
App\Entity\TeamSkill	No errors.
App\Entity\Skill	No errors.
App\Entity\Parameter	No errors.
App\Entity\Leading	No errors.
App\Entity\Newsletters\Categories	No errors.
App\Entity\Newsletters\Newsletters	No errors.
App\Entity\Newsletters\Users	No errors.
App\Entity\Services	No errors.
App\Entity\ServicesDetails	No errors.
App\Entity\Feature	No errors.
App\Entity\Brand	No errors.
App\Entity\ChallengeProgress	No errors.
App\Entity\Project	No errors.
App\Entity\Category	No errors.
App\Entity\BenefitPoints	No errors.
App\Entity\QualityWork	No errors.
App\Entity\User	No errors.
App\Entity\Faq	No errors.
App\Entity\ResetPasswordRequest	No errors.
App\Entity\ProjectDetailsPoints	No errors.
App\Entity\Company	No errors.
App\Entity\Contact	No errors.
App\Entity\Benefit	No errors.
App\Entity\Tag	No errors.
App\Entity\Clients	No errors.
App\Entity\Post	No errors.
App\Entity\Comment	No errors.
App\Entity\MainSlider	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://www.site.karisma-studio.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CHomeController%253A%253Anewsletters

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping