Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

0.84 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.33 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.challenge_title AS challenge_title_4, t0.challenge_text AS challenge_text_5, t0.image_file_name AS image_file_name_6, t0.result_title AS result_title_7, t0.result_text AS result_text_8, t0.slug AS slug_9, t0.image_detail_file_name AS image_detail_file_name_10, t0.updated_at AS updated_at_11 FROM project t0 WHERE t0.slug = ? LIMIT 1

Parameters:

[
  "itaque"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.subtitle AS subtitle_3,
  t0.challenge_title AS challenge_title_4,
  t0.challenge_text AS challenge_text_5,
  t0.image_file_name AS image_file_name_6,
  t0.result_title AS result_title_7,
  t0.result_text AS result_text_8,
  t0.slug AS slug_9,
  t0.image_detail_file_name AS image_detail_file_name_10,
  t0.updated_at AS updated_at_11
FROM
  project t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.challenge_title AS challenge_title_4, t0.challenge_text AS challenge_text_5, t0.image_file_name AS image_file_name_6, t0.result_title AS result_title_7, t0.result_text AS result_text_8, t0.slug AS slug_9, t0.image_detail_file_name AS image_detail_file_name_10, t0.updated_at AS updated_at_11 FROM project t0 WHERE t0.slug = 'itaque' 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.28 ms

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.challenge_title AS challenge_title_3, p0_.challenge_text AS challenge_text_4, p0_.image_file_name AS image_file_name_5, p0_.result_title AS result_title_6, p0_.result_text AS result_text_7, p0_.slug AS slug_8, p0_.image_detail_file_name AS image_detail_file_name_9, p0_.updated_at AS updated_at_10 FROM project p0_ WHERE p0_.id <> ? ORDER BY p0_.id DESC LIMIT 3

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.subtitle AS subtitle_2,
  p0_.challenge_title AS challenge_title_3,
  p0_.challenge_text AS challenge_text_4,
  p0_.image_file_name AS image_file_name_5,
  p0_.result_title AS result_title_6,
  p0_.result_text AS result_text_7,
  p0_.slug AS slug_8,
  p0_.image_detail_file_name AS image_detail_file_name_9,
  p0_.updated_at AS updated_at_10
FROM
  project p0_
WHERE
  p0_.id <> ?
ORDER BY
  p0_.id DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.subtitle AS subtitle_2, p0_.challenge_title AS challenge_title_3, p0_.challenge_text AS challenge_text_4, p0_.image_file_name AS image_file_name_5, p0_.result_title AS result_title_6, p0_.result_text AS result_text_7, p0_.slug AS slug_8, p0_.image_detail_file_name AS image_detail_file_name_9, p0_.updated_at AS updated_at_10 FROM project p0_ WHERE p0_.id <> 4 ORDER BY p0_.id DESC LIMIT 3;

#	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 52)
7	App\Repository\ProjectRepository->findOtherProject (line 42)
8	App\Controller\ProjectController->projectShow (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.23 ms

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_35e04957e0d69e8c4ee5d81ac8b0360f->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 43)
24	App\Controller\ProjectController->projectShow (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)

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\Project	No errors.
App\Entity\ChallengeProgress	No errors.
App\Entity\ProjectDetailsPoints	No errors.
App\Entity\Clients	No errors.
App\Entity\Category	No errors.
App\Entity\Services	No errors.
App\Entity\Parameter	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping