Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.80 ms Query time

1 Invalid entities

205 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.13 ms
(76.06%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities 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.slug AS slug_3,
  t0.is_active AS is_active_4,
  t0.sort_order AS sort_order_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.region_id AS region_id_8
FROM
  cities t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.is_active AS is_active_4, t0.sort_order AS sort_order_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.region_id AS region_id_8 FROM cities 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\SearchQueryParser->loadCityNames (line 27)
6	App\Service\SearchQueryParser->__construct (line 22)
7	ContainerZEx6nBQ\getMainControllerService->do (line 30)
8	ContainerZEx6nBQ\App_KernelDevDebugContainer::load (line 573)
9	Symfony\Component\DependencyInjection\Container->make (line 221)
10	Symfony\Component\DependencyInjection\Container::get (line 203)
11	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 38)
12	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 25)
13	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 127)
14	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 95)
15	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 33)
16	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 166)
17	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
18	Symfony\Component\HttpKernel\Kernel->handle (line 182)
19	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
20	require_once (line 29)
21	require_once (line 5)

0.67 ms
(23.94%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.icon AS icon_7, t0.sort_order AS sort_order_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10 FROM categories 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.slug AS slug_3,
  t0.description AS description_4,
  t0.keywords AS keywords_5,
  t0.synonyms AS synonyms_6,
  t0.icon AS icon_7,
  t0.sort_order AS sort_order_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10
FROM
  categories t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4, t0.keywords AS keywords_5, t0.synonyms AS synonyms_6, t0.icon AS icon_7, t0.sort_order AS sort_order_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10 FROM categories 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\Controller\MainController->getCategories (line 176)
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)

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\City	163
App\Entity\Region	31
App\Entity\Category	11

Entities Mapping

Class	Mapping errors
App\Entity\City	No errors.
App\Entity\Region	No errors.
App\Entity\Category	No errors.
App\Entity\Specialist	The field 'App\Entity\Specialist#rating' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Skill	No errors.

Symfony Profiler

GET https://pro-uslugi.ru/api/categories

Configuration Settings

Theme

Page Width