Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

2.78 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.17 ms

SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.identifier AS identifier_0,
  s0_.type AS type_1,
  s0_.label AS label_2,
  s0_.value AS value_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  system_config s0_

SELECT s0_.identifier AS identifier_0, s0_.type AS type_1, s0_.label AS label_2, s0_.value AS value_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM system_config s0_;

#	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 55)
7	WelshDev\DoctrineBaseRepository\BaseRepository->findFiltered (line 22)
8	App\Helper\ConfigHelper->__construct (line 1237)
9	Container0GFx49W\App_KernelDevDebugContainer::getConfigHelperService (line 1253)
10	Container0GFx49W\App_KernelDevDebugContainer::getUtilHelperService (line 2231)
11	Container0GFx49W\App_KernelDevDebugContainer::getTwigService (line 585)
12	Container0GFx49W\App_KernelDevDebugContainer::get_Container_Private_ProfilerService (line 1305)
13	Container0GFx49W\App_KernelDevDebugContainer::getAssetMapper_DevServerSubscriberService (line 994)
14	Container0GFx49W\App_KernelDevDebugContainer::Container0GFx49W\{closure} (line 221)
15	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
16	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.61 ms

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.name ASC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.name AS name_0,
  s0_.slug AS slug_1,
  s0_.description AS description_2,
  s0_.import_matches AS import_matches_3,
  s0_.id AS id_4,
  s0_.uuid AS uuid_5,
  s0_.created AS created_6,
  s0_.modified AS modified_7
FROM
  services_service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.name AS name_0, s0_.slug AS slug_1, s0_.description AS description_2, s0_.import_matches AS import_matches_3, s0_.id AS id_4, s0_.uuid AS uuid_5, s0_.created AS created_6, s0_.modified AS modified_7 FROM services_service s0_ ORDER BY s0_.name 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 55)
7	WelshDev\DoctrineBaseRepository\BaseRepository->findFiltered (line 140)
8	App\Controller\Frontend\Search\SearchController->search (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)

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\System\Config\Config	No errors.
App\Entity\Services\Service	No errors.
App\Entity\Listings\Listing	No errors.

Symfony Profiler

GET https://varsity.cwd-dev.com/search

Configuration Settings

Theme