Symfony Profiler

Query Metrics

13 Database Queries

6 Different statements

4.87 ms Query time

0 Invalid entities

29 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

3.34 ms
(68.56%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM extra_data t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "about_me"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  extra_data t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM extra_data t0 WHERE t0.name = 'about_me' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\ExtraDataRepository->getAboutMeData (line 50)
5	App\Controller\PageController->home (line 34)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 182)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.34 ms
(7.06%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.school AS school_3, t0.begin_date AS begin_date_4, t0.end_date AS end_date_5, t0.description AS description_6 FROM education 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.school AS school_3,
  t0.begin_date AS begin_date_4,
  t0.end_date AS end_date_5,
  t0.description AS description_6
FROM
  education t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.school AS school_3, t0.begin_date AS begin_date_4, t0.end_date AS end_date_5, t0.description AS description_6 FROM education t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
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\SchoolParserService->getSortedEducation (line 17)
6	App\Controller\PageController->home (line 40)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.33 ms
(6.71%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.color AS color_4, t0.type AS type_5, t0.level AS level_6 FROM skills 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.icon AS icon_3,
  t0.color AS color_4,
  t0.type AS type_5,
  t0.level AS level_6
FROM
  skills t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.color AS color_4, t0.type AS type_5, t0.level AS level_6 FROM skills t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
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\ParseSkills->getGrouppedSkills (line 18)
6	App\Controller\PageController->home (line 39)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.31 ms
(6.46%)

SELECT t0.id AS id_1, t0.company AS company_2, t0.name AS name_3, t0.url AS url_4, t0.date AS date_5 FROM certificates t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.company AS company_2,
  t0.name AS name_3,
  t0.url AS url_4,
  t0.date AS date_5
FROM
  certificates t0

SELECT t0.id AS id_1, t0.company AS company_2, t0.name AS name_3, t0.url AS url_4, t0.date AS date_5 FROM certificates t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
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\CertificatesParserService->GetAllCertificates (line 17)
6	App\Controller\PageController->home (line 41)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.28 ms
(5.67%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.tech AS tech_3, t0.description AS description_4 FROM projects 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.tech AS tech_3,
  t0.description AS description_4
FROM
  projects t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.tech AS tech_3, t0.description AS description_4 FROM projects t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
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\ProjectParserService->getAllProjects (line 17)
6	App\Controller\PageController->home (line 44)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.27 ms
(5.54%)

SELECT t0.id AS id_1, t0.seat AS seat_2, t0.company AS company_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6 FROM experience t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.seat AS seat_2,
  t0.company AS company_3,
  t0.start_date AS start_date_4,
  t0.end_date AS end_date_5,
  t0.description AS description_6
FROM
  experience t0

SELECT t0.id AS id_1, t0.seat AS seat_2, t0.company AS company_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.description AS description_6 FROM experience t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 942)
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\ExperienceParserService->getExperienceArray (line 16)
6	App\Controller\PageController->home (line 42)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 182)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	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\Skills	14
App\Entity\ExtraData	8
App\Entity\Education	2
App\Entity\Certificates	2
App\Entity\Experience	2
App\Entity\Projects	1

Entities Mapping

Class	Mapping errors
App\Entity\ExtraData	No errors.
App\Entity\Skills	No errors.
App\Entity\Education	No errors.
App\Entity\Certificates	No errors.
App\Entity\Experience	No errors.
App\Entity\Projects	No errors.

Symfony Profiler

GET http://172.18.0.2/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping