Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

3.39 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

1.54 ms

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `lang_id`,
  `code`,
  `name`,
  `icon`
FROM
  `lang`

SELECT `lang_id`, `code`, `name`, `icon` FROM `lang`;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 34)
2	App\Language\Model\LanguageResolver->init (line 25)
3	App\Language\Model\LanguageResolver->__construct (line 1198)
4	ContainerZpBicIx\App_KernelDevDebugContainer::getLanguageResolverService (line 1188)
5	ContainerZpBicIx\App_KernelDevDebugContainer::getCookieLangSwitcherService (line 896)
6	ContainerZpBicIx\App_KernelDevDebugContainer::ContainerZpBicIx\{closure} (line 221)
7	Symfony\Component\EventDispatcher\EventDispatcher->sortListeners (line 70)
8	Symfony\Component\EventDispatcher\EventDispatcher->getListeners (line 252)
9	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->preProcess (line 116)
10	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
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)

1.85 ms

SELECT `query`, `searched_num`, `blocked`, MATCH (`query`) AGAINST (?) AS `relevance` FROM search_log WHERE MATCH (`query`) AGAINST (?) ORDER BY `searched_num` desc LIMIT 1000

Parameters:

[
  ""
  ""
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  `query`,
  `searched_num`,
  `blocked`,
  MATCH (`query`) AGAINST (?) AS `relevance`
FROM
  search_log
WHERE
  MATCH (`query`) AGAINST (?)
ORDER BY
  `searched_num` desc
LIMIT
  1000

SELECT `query`, `searched_num`, `blocked`, MATCH (`query`) AGAINST ('') AS `relevance` FROM search_log WHERE MATCH (`query`) AGAINST ('') ORDER BY `searched_num` desc LIMIT 1000;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 305)
2	Doctrine\DBAL\Query\QueryBuilder->executeQuery (line 42)
3	App\SearchLog\Controller\Http\LogOverview\ActionController->__invoke (line 183)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
6	Symfony\Component\HttpKernel\Kernel->handle (line 35)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
8	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

No loaded entities.

Symfony Profiler

GET https://search.jues.net/search-log/overview/

Configuration Settings

Theme