Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

8.29 ms Query time

4 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

4.14 ms
(49.93%)

SELECT t0.id AS id_1, t0.landing_page_title AS landing_page_title_2, t0.page_code AS page_code_3, t0.landing_page_text_block AS landing_page_text_block_4, t0.services_title AS services_title_5, t0.about_us_title AS about_us_title_6, t0.about_us_points AS about_us_points_7, t0.about_us_img AS about_us_img_8, t0.updated_at AS updated_at_9, t0.contact_residence_name AS contact_residence_name_10, t0.contact_residence_street_house_number AS contact_residence_street_house_number_11, t0.contact_residence_city AS contact_residence_city_12, t0.contact_residence_cin AS contact_residence_cin_13, t0.contact_residence_vat AS contact_residence_vat_14, t0.contact_residence_reg AS contact_residence_reg_15, t0.contact_residence_ds AS contact_residence_ds_16, t0.contact_main_branch_name AS contact_main_branch_name_17, t0.contact_main_branch_street_house_number AS contact_main_branch_street_house_number_18, t0.contact_main_branch_city AS contact_main_branch_city_19, t0.contact_second_branch_name AS contact_second_branch_name_20, t0.contact_second_branch_street_house_number AS contact_second_branch_street_house_number_21, t0.contact_second_branch_city AS contact_second_branch_city_22 FROM landing_page t0 WHERE t0.page_code = ? LIMIT 1

Parameters:

[
  "homepage"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.landing_page_title AS landing_page_title_2,
  t0.page_code AS page_code_3,
  t0.landing_page_text_block AS landing_page_text_block_4,
  t0.services_title AS services_title_5,
  t0.about_us_title AS about_us_title_6,
  t0.about_us_points AS about_us_points_7,
  t0.about_us_img AS about_us_img_8,
  t0.updated_at AS updated_at_9,
  t0.contact_residence_name AS contact_residence_name_10,
  t0.contact_residence_street_house_number AS contact_residence_street_house_number_11,
  t0.contact_residence_city AS contact_residence_city_12,
  t0.contact_residence_cin AS contact_residence_cin_13,
  t0.contact_residence_vat AS contact_residence_vat_14,
  t0.contact_residence_reg AS contact_residence_reg_15,
  t0.contact_residence_ds AS contact_residence_ds_16,
  t0.contact_main_branch_name AS contact_main_branch_name_17,
  t0.contact_main_branch_street_house_number AS contact_main_branch_street_house_number_18,
  t0.contact_main_branch_city AS contact_main_branch_city_19,
  t0.contact_second_branch_name AS contact_second_branch_name_20,
  t0.contact_second_branch_street_house_number AS contact_second_branch_street_house_number_21,
  t0.contact_second_branch_city AS contact_second_branch_city_22
FROM
  landing_page t0
WHERE
  t0.page_code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.landing_page_title AS landing_page_title_2, t0.page_code AS page_code_3, t0.landing_page_text_block AS landing_page_text_block_4, t0.services_title AS services_title_5, t0.about_us_title AS about_us_title_6, t0.about_us_points AS about_us_points_7, t0.about_us_img AS about_us_img_8, t0.updated_at AS updated_at_9, t0.contact_residence_name AS contact_residence_name_10, t0.contact_residence_street_house_number AS contact_residence_street_house_number_11, t0.contact_residence_city AS contact_residence_city_12, t0.contact_residence_cin AS contact_residence_cin_13, t0.contact_residence_vat AS contact_residence_vat_14, t0.contact_residence_reg AS contact_residence_reg_15, t0.contact_residence_ds AS contact_residence_ds_16, t0.contact_main_branch_name AS contact_main_branch_name_17, t0.contact_main_branch_street_house_number AS contact_main_branch_street_house_number_18, t0.contact_main_branch_city AS contact_main_branch_city_19, t0.contact_second_branch_name AS contact_second_branch_name_20, t0.contact_second_branch_street_house_number AS contact_second_branch_street_house_number_21, t0.contact_second_branch_city AS contact_second_branch_city_22 FROM landing_page t0 WHERE t0.page_code = 'homepage' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 28)
5	App\Controller\Api\WebLandingPageController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.91 ms
(10.95%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.img AS img_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM partner t0 WHERE t0.landing_page_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,
  t0.url AS url_3,
  t0.img AS img_4,
  t0.updated_at AS updated_at_5,
  t0.landing_page_id AS landing_page_id_6
FROM
  partner t0
WHERE
  t0.landing_page_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.img AS img_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM partner t0 WHERE t0.landing_page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 167)
8	Symfony\Component\Serializer\Serializer->normalize (line 223)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 49)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
11	Symfony\Component\Serializer\Serializer->normalize (line 129)
12	Symfony\Component\Serializer\Serializer->serialize (line 43)
13	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 39)
15	App\Controller\Api\WebLandingPageController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.87 ms
(10.50%)

SELECT t0.id AS id_1, t0.services_point AS services_point_2, t0.img AS img_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM service t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.services_point AS services_point_2,
  t0.img AS img_3,
  t0.position AS position_4,
  t0.updated_at AS updated_at_5,
  t0.landing_page_id AS landing_page_id_6
FROM
  service t0

SELECT t0.id AS id_1, t0.services_point AS services_point_2, t0.img AS img_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM service t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
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 33)
6	App\Controller\Api\WebLandingPageController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.82 ms
(9.93%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.phone AS phone_4, t0.email AS email_5, t0.email2 AS email2_6, t0.landing_page_id AS landing_page_id_7 FROM contact t0 WHERE t0.landing_page_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,
  t0.position AS position_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.email2 AS email2_6,
  t0.landing_page_id AS landing_page_id_7
FROM
  contact t0
WHERE
  t0.landing_page_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.phone AS phone_4, t0.email AS email_5, t0.email2 AS email2_6, t0.landing_page_id AS landing_page_id_7 FROM contact t0 WHERE t0.landing_page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 167)
8	Symfony\Component\Serializer\Serializer->normalize (line 223)
9	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->normalize (line 49)
10	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 150)
11	Symfony\Component\Serializer\Serializer->normalize (line 129)
12	Symfony\Component\Serializer\Serializer->serialize (line 43)
13	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 150)
14	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->json (line 39)
15	App\Controller\Api\WebLandingPageController->index (line 183)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
18	Symfony\Component\HttpKernel\Kernel->handle (line 35)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
20	require_once (line 5)

0.79 ms
(9.53%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.updated_at AS updated_at_4, t0.landing_page_id AS landing_page_id_5 FROM galery_image 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.img AS img_3,
  t0.updated_at AS updated_at_4,
  t0.landing_page_id AS landing_page_id_5
FROM
  galery_image t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.updated_at AS updated_at_4, t0.landing_page_id AS landing_page_id_5 FROM galery_image t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 936)
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 29)
6	App\Controller\Api\WebLandingPageController->index (line 183)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 5)

0.44 ms
(5.32%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.updated_at AS updated_at_4, t0.landing_page_id AS landing_page_id_5 FROM galery_image t0 WHERE t0.landing_page_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,
  t0.img AS img_3,
  t0.updated_at AS updated_at_4,
  t0.landing_page_id AS landing_page_id_5
FROM
  galery_image t0
WHERE
  t0.landing_page_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.img AS img_3, t0.updated_at AS updated_at_4, t0.landing_page_id AS landing_page_id_5 FROM galery_image t0 WHERE t0.landing_page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 68)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 338)
9	App\Entity\LandingPage->addGallery (line 31)
10	App\Controller\Api\WebLandingPageController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.32 ms
(3.85%)

SELECT t0.id AS id_1, t0.services_point AS services_point_2, t0.img AS img_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM service t0 WHERE t0.landing_page_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.services_point AS services_point_2,
  t0.img AS img_3,
  t0.position AS position_4,
  t0.updated_at AS updated_at_5,
  t0.landing_page_id AS landing_page_id_6
FROM
  service t0
WHERE
  t0.landing_page_id = ?

SELECT t0.id AS id_1, t0.services_point AS services_point_2, t0.img AS img_3, t0.position AS position_4, t0.updated_at AS updated_at_5, t0.landing_page_id AS landing_page_id_6 FROM service t0 WHERE t0.landing_page_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 68)
7	Doctrine\Common\Collections\AbstractLazyCollection->contains (line 361)
8	Doctrine\ORM\PersistentCollection->contains (line 367)
9	App\Entity\LandingPage->addServicePoint (line 35)
10	App\Controller\Api\WebLandingPageController->index (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	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\LandingPage	The mappings App\Entity\LandingPage#partners and App\Entity\Partner#landingPage are inconsistent with each other. The mappings App\Entity\LandingPage#gallery and App\Entity\GaleryImage#landingPage are inconsistent with each other. The mappings App\Entity\LandingPage#servicePoints and App\Entity\Service#landingPage are inconsistent with each other.
App\Entity\Partner	The association App\Entity\Partner#landingPage refers to the inverse side field App\Entity\LandingPage#Partners which does not exist.
App\Entity\Contact	No errors.
App\Entity\GaleryImage	The association App\Entity\GaleryImage#landingPage refers to the inverse side field App\Entity\LandingPage#galery which does not exist.
App\Entity\Service	The association App\Entity\Service#landingPage refers to the inverse side field App\Entity\LandingPage#sercicePoints which does not exist.

Symfony Profiler

GET http://cms.sves.cz/api/v1/static-page/web/homepage

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping