Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.72 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.72 ms
(100.00%)

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.link AS link_2, s0_.icon AS icon_3, s0_.position AS position_4, s0_.is_active AS is_active_5, s0_.site AS site_6 FROM site_social s0_ WHERE s0_.is_active = ? AND ((s0_.site = ? OR s0_.site = ?)) ORDER BY s0_.position ASC, s0_.id ASC

Parameters:

[
  1
  "both"
  "idioma"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.type AS type_1,
  s0_.link AS link_2,
  s0_.icon AS icon_3,
  s0_.position AS position_4,
  s0_.is_active AS is_active_5,
  s0_.site AS site_6
FROM
  site_social s0_
WHERE
  s0_.is_active = ?
  AND (
    (
      s0_.site = ?
      OR s0_.site = ?
    )
  )
ORDER BY
  s0_.position ASC,
  s0_.id ASC

SELECT s0_.id AS id_0, s0_.type AS type_1, s0_.link AS link_2, s0_.icon AS icon_3, s0_.position AS position_4, s0_.is_active AS is_active_5, s0_.site AS site_6 FROM site_social s0_ WHERE s0_.is_active = 1 AND ((s0_.site = 'both' OR s0_.site = 'idioma')) ORDER BY s0_.position ASC, s0_.id 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 33)
7	App\Repository\SiteSocialRepository->findActiveForSite (line 24)
8	App\State\Site\SiteSocialCollectionProvider->provide (line 43)
9	ApiPlatform\State\CallableProvider->provide (line 80)
10	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
11	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 103)
12	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
13	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
14	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 39)
15	ApiPlatform\State\Provider\SecurityParameterProvider->provide (line 95)
16	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 115)
17	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
18	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
19	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
20	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 10)

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\SiteSocial	No errors.

Symfony Profiler

GET https://api.idioma.international/api/site-socials?site=idioma

Configuration Settings

Theme