Symfony Profiler

Query Metrics

8 Database Queries

8 Different statements

217.37 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

108.90 ms
(50.10%)

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)

102.78 ms
(47.29%)

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_ LEFT JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id = ?

Parameters:

[
  6299
]

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_
  LEFT JOIN site s1_ ON e0_.site_id = s1_.id
  LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id
WHERE
  e0_.id = ?

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_ LEFT JOIN site s1_ ON e0_.site_id = s1_.id LEFT JOIN campaign c2_ ON e0_.campaign_id = c2_.id WHERE e0_.id = 6299;

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 76)
9	ApiPlatform\State\Provider\ReadProvider->provide (line 87)
10	ApiPlatform\Symfony\Validator\State\ParameterValidatorProvider->provide (line 99)
11	ApiPlatform\State\Provider\ParameterProvider->provide (line 50)
12	ApiPlatform\Symfony\Bundle\SwaggerUi\SwaggerUiProvider->provide (line 62)
13	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 95)
14	ApiPlatform\Symfony\EventListener\ReadListener->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

1.51 ms
(0.69%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->doCommit (line 1423)
2	Doctrine\DBAL\Connection->commit (line 476)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 104)
5	ApiPlatform\Doctrine\Common\State\PersistProcessor->process (line 52)
6	ApiPlatform\State\CallableProcessor->process (line 54)
7	ApiPlatform\State\Processor\WriteProcessor->process (line 107)
8	ApiPlatform\Symfony\EventListener\WriteListener->onKernelView (line 116)
9	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
10	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
11	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
12	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

1.15 ms
(0.53%)

UPDATE evapo_transpiration SET day_at = ?, evapo_bac = ?, eto = ?, evapo_bac_prev = ?, eto_prev = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "2019-04-12"
  "6.2"
  "4.2"
  "6.3"
  "5.1"
  "2024-09-21 04:38:24"
  6299
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  evapo_transpiration
SET
  day_at = ?,
  evapo_bac = ?,
  eto = ?,
  evapo_bac_prev = ?,
  eto_prev = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE evapo_transpiration SET day_at = '2019-04-12', evapo_bac = '6.2', eto = '4.2', evapo_bac_prev = '6.3', eto_prev = '5.1', updated_at = '2024-09-21 04:38:24' WHERE id = 6299;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 533)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 419)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1275)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 452)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 104)
7	ApiPlatform\Doctrine\Common\State\PersistProcessor->process (line 52)
8	ApiPlatform\State\CallableProcessor->process (line 54)
9	ApiPlatform\State\Processor\WriteProcessor->process (line 107)
10	ApiPlatform\Symfony\EventListener\WriteListener->onKernelView (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.92 ms
(0.42%)

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.identifiant AS identifiant_3, s0_.name AS name_4, s0_.slug AS slug_5 FROM site s0_ WHERE s0_.id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.id AS id_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.identifiant AS identifiant_3,
  s0_.name AS name_4,
  s0_.slug AS slug_5
FROM
  site s0_
WHERE
  s0_.id = ?

SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.identifiant AS identifiant_3, s0_.name AS name_4, s0_.slug AS slug_5 FROM site s0_ WHERE s0_.id = 1;

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 109)
9	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 583)
10	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 930)
11	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 879)
12	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 502)
13	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 379)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 258)
15	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 72)
16	ApiPlatform\Serializer\ItemNormalizer->denormalize (line 75)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 238)
18	Symfony\Component\Serializer\Serializer->denormalize (line 143)
19	Symfony\Component\Serializer\Serializer->deserialize (line 58)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 93)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 108)
23	ApiPlatform\Symfony\EventListener\DeserializeListener->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.87 ms
(0.40%)

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.identifiant AS identifiant_3, c0_.name AS name_4, c0_.slug AS slug_5, c0_.started_at AS started_at_6, c0_.ended_at AS ended_at_7, c0_.site_id AS site_id_8 FROM campaign c0_ WHERE c0_.id = ?

Parameters:

[
  16
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.identifiant AS identifiant_3,
  c0_.name AS name_4,
  c0_.slug AS slug_5,
  c0_.started_at AS started_at_6,
  c0_.ended_at AS ended_at_7,
  c0_.site_id AS site_id_8
FROM
  campaign c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.identifiant AS identifiant_3, c0_.name AS name_4, c0_.slug AS slug_5, c0_.started_at AS started_at_6, c0_.ended_at AS ended_at_7, c0_.site_id AS site_id_8 FROM campaign c0_ WHERE c0_.id = 16;

#	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 953)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 87)
7	ApiPlatform\Doctrine\Orm\State\ItemProvider->provide (line 43)
8	ApiPlatform\State\CallableProvider->provide (line 109)
9	ApiPlatform\Symfony\Routing\IriConverter->getResourceFromIri (line 583)
10	ApiPlatform\Serializer\AbstractItemNormalizer->denormalizeRelation (line 930)
11	ApiPlatform\Serializer\AbstractItemNormalizer->createAndValidateAttributeValue (line 879)
12	ApiPlatform\Serializer\AbstractItemNormalizer->createAttributeValue (line 502)
13	ApiPlatform\Serializer\AbstractItemNormalizer->setAttributeValue (line 379)
14	Symfony\Component\Serializer\Normalizer\AbstractObjectNormalizer->denormalize (line 258)
15	ApiPlatform\Serializer\AbstractItemNormalizer->denormalize (line 72)
16	ApiPlatform\Serializer\ItemNormalizer->denormalize (line 75)
17	Symfony\Component\Serializer\Debug\TraceableNormalizer->denormalize (line 238)
18	Symfony\Component\Serializer\Serializer->denormalize (line 143)
19	Symfony\Component\Serializer\Serializer->deserialize (line 58)
20	Symfony\Component\Serializer\Debug\TraceableSerializer->deserialize (line 93)
21	ApiPlatform\State\Provider\DeserializeProvider->provide (line 62)
22	ApiPlatform\Symfony\Security\State\AccessCheckerProvider->provide (line 108)
23	ApiPlatform\Symfony\EventListener\DeserializeListener->onKernelRequest (line 116)
24	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
25	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
26	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
27	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
28	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
29	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
30	Symfony\Component\HttpKernel\Kernel->handle (line 35)
31	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
32	require_once (line 5)

0.78 ms
(0.36%)

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.identifiant AS identifiant_4, t0.name AS name_5, t0.slug AS slug_6, t0.day_at AS day_at_7, t0.evapo_bac AS evapo_bac_8, t0.eto AS eto_9, t0.evapo_bac_prev AS evapo_bac_prev_10, t0.eto_prev AS eto_prev_11, t0.site_id AS site_id_12, t0.campaign_id AS campaign_id_13 FROM evapo_transpiration t0 WHERE t0.id = ?

Parameters:

[
  6299
]

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.identifiant AS identifiant_4,
  t0.name AS name_5,
  t0.slug AS slug_6,
  t0.day_at AS day_at_7,
  t0.evapo_bac AS evapo_bac_8,
  t0.eto AS eto_9,
  t0.evapo_bac_prev AS evapo_bac_prev_10,
  t0.eto_prev AS eto_prev_11,
  t0.site_id AS site_id_12,
  t0.campaign_id AS campaign_id_13
FROM
  evapo_transpiration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.identifiant AS identifiant_4, t0.name AS name_5, t0.slug AS slug_6, t0.day_at AS day_at_7, t0.evapo_bac AS evapo_bac_8, t0.eto AS eto_9, t0.evapo_bac_prev AS evapo_bac_prev_10, t0.eto_prev AS eto_prev_11, t0.site_id AS site_id_12, t0.campaign_id AS campaign_id_13 FROM evapo_transpiration t0 WHERE t0.id = 6299;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 889)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->refresh (line 2474)
3	Doctrine\ORM\UnitOfWork->doRefresh (line 2437)
4	Doctrine\ORM\UnitOfWork->refresh (line 719)
5	Doctrine\ORM\EntityManager->refresh (line 105)
6	ApiPlatform\Doctrine\Common\State\PersistProcessor->process (line 52)
7	ApiPlatform\State\CallableProcessor->process (line 54)
8	ApiPlatform\State\Processor\WriteProcessor->process (line 107)
9	ApiPlatform\Symfony\EventListener\WriteListener->onKernelView (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 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.45 ms
(0.21%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Connection->beginTransaction (line 428)
2	Doctrine\ORM\UnitOfWork->commit (line 403)
3	Doctrine\ORM\EntityManager->flush (line 104)
4	ApiPlatform\Doctrine\Common\State\PersistProcessor->process (line 52)
5	ApiPlatform\State\CallableProcessor->process (line 54)
6	ApiPlatform\State\Processor\WriteProcessor->process (line 107)
7	ApiPlatform\Symfony\EventListener\WriteListener->onKernelView (line 116)
8	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
9	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
10	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
11	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	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
Gesdinet\JWTRefreshTokenBundle\Entity\RefreshToken	No errors.
App\Entity\RefreshToken	No errors.
App\Entity\User	No errors.
App\Entity\EvapoTranspiration	No errors.
App\Entity\Site	No errors.
App\Entity\Campaign	No errors.

Symfony Profiler

PATCH https://api.sii.varicap-corporate.com/evapo_transpirations/6299

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping