Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

2.38 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.38 ms
(100.00%)

SELECT s0_.id AS id_0, s0_.phone AS phone_1, s0_.email AS email_2, s0_.address AS address_3, s0_.site AS site_4, s0_.is_active AS is_active_5 FROM site_contact s0_ WHERE s0_.is_active = ? AND ((s0_.site = ? OR s0_.site = ?))

Parameters:

[
  1
  "both"
  "idioma"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.phone AS phone_1,
  s0_.email AS email_2,
  s0_.address AS address_3,
  s0_.site AS site_4,
  s0_.is_active AS is_active_5
FROM
  site_contact s0_
WHERE
  s0_.is_active = ?
  AND (
    (
      s0_.site = ?
      OR s0_.site = ?
    )
  )

SELECT s0_.id AS id_0, s0_.phone AS phone_1, s0_.email AS email_2, s0_.address AS address_3, s0_.site AS site_4, s0_.is_active AS is_active_5 FROM site_contact s0_ WHERE s0_.is_active = 1 AND ((s0_.site = 'both' OR s0_.site = 'idioma'));

#	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 31)
7	App\Repository\SiteContactRepository->findActiveForSite (line 24)
8	App\State\Site\SiteContactCollectionProvider->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\SiteContact	No errors.

Symfony Profiler

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

Configuration Settings

Theme