Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

10.69 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲

Time

Info

4.45 ms

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.username AS username_7, t0.is_active AS is_active_8 FROM "user" t0 WHERE t0.username = ? LIMIT 1

Parameters:

[
  "varicap"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.roles AS roles_6,
  t0.username AS username_7,
  t0.is_active AS is_active_8
FROM
  "user" t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.email AS email_4, t0.password AS password_5, t0.roles AS roles_6, t0.username AS username_7, t0.is_active AS is_active_8 FROM "user" t0 WHERE t0.username = 'varicap' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 241)
3	Doctrine\ORM\EntityRepository->findOneBy (line 54)
4	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->loadUserByIdentifier (line 251)
5	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->loadUser (line 132)
6	Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\JWTAuthenticator->Lexik\Bundle\JWTAuthenticationBundle\Security\Authenticator\{closure} (line 87)
7	Symfony\Component\Security\Http\Authenticator\Passport\Badge\UserBadge->getUser (line 56)
8	Symfony\Component\Security\Http\Authenticator\Passport\Passport->getUser (line 42)
9	Symfony\Component\Security\Http\EventListener\UserCheckerListener->preCheckCredentials (line 116)
10	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
11	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
12	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
13	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 180)
14	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 158)
15	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 140)
16	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 40)
17	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 68)
18	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 46)
19	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
20	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 80)
21	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
22	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
23	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
24	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
25	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
26	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
27	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
28	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
29	Symfony\Component\HttpKernel\Kernel->handle (line 35)
30	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
31	require_once (line 5)

6.24 ms

SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.identifiant AS identifiant_3, e0_.name AS name_4, e0_.slug AS slug_5, e0_.day_at AS day_at_6, e0_.evapo_bac AS evapo_bac_7, e0_.eto AS eto_8, e0_.evapo_bac_prev AS evapo_bac_prev_9, e0_.eto_prev AS eto_prev_10, s1_.id AS id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.identifiant AS identifiant_14, s1_.name AS name_15, s1_.slug AS slug_16, c2_.id AS id_17, c2_.created_at AS created_at_18, c2_.updated_at AS updated_at_19, c2_.identifiant AS identifiant_20, c2_.name AS name_21, c2_.slug AS slug_22, c2_.started_at AS started_at_23, c2_.ended_at AS ended_at_24, e0_.site_id AS site_id_25, e0_.campaign_id AS campaign_id_26, c2_.site_id AS site_id_27 FROM evapo_transpiration e0_ INNER JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id IN (SELECT e3_.id FROM evapo_transpiration e3_ INNER JOIN site s4_ ON e3_.site_id = s4_.id WHERE s4_.identifiant = ? AND e3_.day_at = ?) ORDER BY e0_.id ASC LIMIT 128

Parameters:

[
  "1"
  "2019-04-12"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  e0_.id AS id_0,
  e0_.created_at AS created_at_1,
  e0_.updated_at AS updated_at_2,
  e0_.identifiant AS identifiant_3,
  e0_.name AS name_4,
  e0_.slug AS slug_5,
  e0_.day_at AS day_at_6,
  e0_.evapo_bac AS evapo_bac_7,
  e0_.eto AS eto_8,
  e0_.evapo_bac_prev AS evapo_bac_prev_9,
  e0_.eto_prev AS eto_prev_10,
  s1_.id AS id_11,
  s1_.created_at AS created_at_12,
  s1_.updated_at AS updated_at_13,
  s1_.identifiant AS identifiant_14,
  s1_.name AS name_15,
  s1_.slug AS slug_16,
  c2_.id AS id_17,
  c2_.created_at AS created_at_18,
  c2_.updated_at AS updated_at_19,
  c2_.identifiant AS identifiant_20,
  c2_.name AS name_21,
  c2_.slug AS slug_22,
  c2_.started_at AS started_at_23,
  c2_.ended_at AS ended_at_24,
  e0_.site_id AS site_id_25,
  e0_.campaign_id AS campaign_id_26,
  c2_.site_id AS site_id_27
FROM
  evapo_transpiration e0_
  INNER JOIN site s1_ ON e0_.site_id = s1_.id
  LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id
WHERE
  e0_.id IN (
    SELECT
      e3_.id
    FROM
      evapo_transpiration e3_
      INNER JOIN site s4_ ON e3_.site_id = s4_.id
    WHERE
      s4_.identifiant = ?
      AND e3_.day_at = ?
  )
ORDER BY
  e0_.id ASC
LIMIT
  128

SELECT e0_.id AS id_0, e0_.created_at AS created_at_1, e0_.updated_at AS updated_at_2, e0_.identifiant AS identifiant_3, e0_.name AS name_4, e0_.slug AS slug_5, e0_.day_at AS day_at_6, e0_.evapo_bac AS evapo_bac_7, e0_.eto AS eto_8, e0_.evapo_bac_prev AS evapo_bac_prev_9, e0_.eto_prev AS eto_prev_10, s1_.id AS id_11, s1_.created_at AS created_at_12, s1_.updated_at AS updated_at_13, s1_.identifiant AS identifiant_14, s1_.name AS name_15, s1_.slug AS slug_16, c2_.id AS id_17, c2_.created_at AS created_at_18, c2_.updated_at AS updated_at_19, c2_.identifiant AS identifiant_20, c2_.name AS name_21, c2_.slug AS slug_22, c2_.started_at AS started_at_23, c2_.ended_at AS ended_at_24, e0_.site_id AS site_id_25, e0_.campaign_id AS campaign_id_26, c2_.site_id AS site_id_27 FROM evapo_transpiration e0_ INNER JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id IN (SELECT e3_.id FROM evapo_transpiration e3_ INNER JOIN site s4_ ON e3_.site_id = s4_.id WHERE s4_.identifiant = '1' AND e3_.day_at = '2019-04-12') ORDER BY e0_.id ASC LIMIT 128;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 33)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 327)
3	Doctrine\ORM\Query->_doExecute (line 1212)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1166)
5	Doctrine\ORM\AbstractQuery->execute (line 901)
6	Doctrine\ORM\AbstractQuery->getResult (line 177)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 69)
8	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 167)
9	Symfony\Component\Serializer\Serializer->normalize (line 129)
10	Symfony\Component\Serializer\Serializer->serialize (line 43)
11	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 79)
12	ApiPlatform\State\Processor\SerializeProcessor->process (line 102)
13	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	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\EvapoTranspiration	No errors.
App\Entity\Site	No errors.
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\Campaign	No errors.

Symfony Profiler

GET https://api.sii.varicap-corporate.com/evapo_transpirations?dayAt=2019-04-12&site.identifiant=1

Configuration Settings

Theme