Symfony Profiler

Query Metrics

11 Database Queries

8 Different statements

21.80 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

9.06 ms
(41.57%)

SELECT p0_.name AS name_0, p0_.ble_id AS ble_id_1, p0_.shared_key AS shared_key_2, p0_.model_identifier AS model_identifier_3, p0_.firmware_version AS firmware_version_4, p0_.new_firmware_version AS new_firmware_version_5, p0_.manufacturer AS manufacturer_6, p0_.beta AS beta_7, p0_.client_identifier AS client_identifier_8, p0_.serial_number AS serial_number_9, p0_.installation_orientation AS installation_orientation_10, p0_.installation_at AS installation_at_11, p0_.wall_type AS wall_type_12, p0_.reset_at AS reset_at_13, p0_.status AS status_14, p0_.heating_mode AS heating_mode_15, p0_.backup AS backup_16, p0_.id AS id_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.scaleway_id AS scaleway_id_20, p0_.scaleway_key AS scaleway_key_21, p0_.scaleway_cert AS scaleway_cert_22, p0_.scaleway_p12 AS scaleway_p12_23, p0_.additional_scaleway_id AS additional_scaleway_id_24, p0_.additional_scaleway_key AS additional_scaleway_key_25, p0_.additional_scaleway_cert AS additional_scaleway_cert_26, p0_.additional_scaleway_p12 AS additional_scaleway_p12_27, p0_.img_boost_id AS img_boost_id_28, p0_.img_box_id AS img_box_id_29, p0_.site_id AS site_id_30 FROM product p0_ WHERE p0_.serial_number = ?

Parameters:

[
  "25010055"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.name AS name_0,
  p0_.ble_id AS ble_id_1,
  p0_.shared_key AS shared_key_2,
  p0_.model_identifier AS model_identifier_3,
  p0_.firmware_version AS firmware_version_4,
  p0_.new_firmware_version AS new_firmware_version_5,
  p0_.manufacturer AS manufacturer_6,
  p0_.beta AS beta_7,
  p0_.client_identifier AS client_identifier_8,
  p0_.serial_number AS serial_number_9,
  p0_.installation_orientation AS installation_orientation_10,
  p0_.installation_at AS installation_at_11,
  p0_.wall_type AS wall_type_12,
  p0_.reset_at AS reset_at_13,
  p0_.status AS status_14,
  p0_.heating_mode AS heating_mode_15,
  p0_.backup AS backup_16,
  p0_.id AS id_17,
  p0_.created_at AS created_at_18,
  p0_.updated_at AS updated_at_19,
  p0_.scaleway_id AS scaleway_id_20,
  p0_.scaleway_key AS scaleway_key_21,
  p0_.scaleway_cert AS scaleway_cert_22,
  p0_.scaleway_p12 AS scaleway_p12_23,
  p0_.additional_scaleway_id AS additional_scaleway_id_24,
  p0_.additional_scaleway_key AS additional_scaleway_key_25,
  p0_.additional_scaleway_cert AS additional_scaleway_cert_26,
  p0_.additional_scaleway_p12 AS additional_scaleway_p12_27,
  p0_.img_boost_id AS img_boost_id_28,
  p0_.img_box_id AS img_box_id_29,
  p0_.site_id AS site_id_30
FROM
  product p0_
WHERE
  p0_.serial_number = ?

SELECT p0_.name AS name_0, p0_.ble_id AS ble_id_1, p0_.shared_key AS shared_key_2, p0_.model_identifier AS model_identifier_3, p0_.firmware_version AS firmware_version_4, p0_.new_firmware_version AS new_firmware_version_5, p0_.manufacturer AS manufacturer_6, p0_.beta AS beta_7, p0_.client_identifier AS client_identifier_8, p0_.serial_number AS serial_number_9, p0_.installation_orientation AS installation_orientation_10, p0_.installation_at AS installation_at_11, p0_.wall_type AS wall_type_12, p0_.reset_at AS reset_at_13, p0_.status AS status_14, p0_.heating_mode AS heating_mode_15, p0_.backup AS backup_16, p0_.id AS id_17, p0_.created_at AS created_at_18, p0_.updated_at AS updated_at_19, p0_.scaleway_id AS scaleway_id_20, p0_.scaleway_key AS scaleway_key_21, p0_.scaleway_cert AS scaleway_cert_22, p0_.scaleway_p12 AS scaleway_p12_23, p0_.additional_scaleway_id AS additional_scaleway_id_24, p0_.additional_scaleway_key AS additional_scaleway_key_25, p0_.additional_scaleway_cert AS additional_scaleway_cert_26, p0_.additional_scaleway_p12 AS additional_scaleway_p12_27, p0_.img_boost_id AS img_boost_id_28, p0_.img_box_id AS img_box_id_29, p0_.site_id AS site_id_30 FROM product p0_ WHERE p0_.serial_number = '25010055';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 935)
4	Doctrine\ORM\AbstractQuery->execute (line 891)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 738)
6	App\Repository\ProductRepository->fetchBySerial (line 36)
7	App\Manager\ProductManager->fetchBySerial (line 258)
8	App\Manager\ProductDataManager->dispatch (line 79)
9	App\Controller\ProductDataController->dispatch (line 41)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 197)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 29)
15	require_once (line 5)

4.89 ms
(22.42%)

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = ?

Parameters:

[
  "8db1334a6607c86f741d48fee57d4113b517d673458a9cd0c6ae9a8a1ae16049f36916bd9f102c71"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.identifier AS identifier_1,
  t0.expiry AS expiry_2,
  t0.user_identifier AS user_identifier_3,
  t0.scopes AS scopes_4,
  t0.revoked AS revoked_5,
  t0.client AS client_6
FROM
  oauth2_access_token t0
WHERE
  t0.identifier = ?

SELECT t0.identifier AS identifier_1, t0.expiry AS expiry_2, t0.user_identifier AS user_identifier_3, t0.scopes AS scopes_4, t0.revoked AS revoked_5, t0.client AS client_6 FROM oauth2_access_token t0 WHERE t0.identifier = '8db1334a6607c86f741d48fee57d4113b517d673458a9cd0c6ae9a8a1ae16049f36916bd9f102c71';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 758)
3	Doctrine\ORM\EntityManager->find (line 366)
4	League\Bundle\OAuth2ServerBundle\Manager\Doctrine\AccessTokenManager->find (line 34)
5	League\Bundle\OAuth2ServerBundle\Repository\AccessTokenRepository->isAccessTokenRevoked (line 93)
6	League\OAuth2\Server\AuthorizationValidators\BearerTokenValidator->validateAuthorization (line 122)
7	League\OAuth2\Server\ResourceServer->validateAuthenticatedRequest (line 84)
8	League\Bundle\OAuth2ServerBundle\Security\Authenticator\OAuth2Authenticator->doAuthenticate (line 72)
9	League\Bundle\OAuth2ServerBundle\Security\Authenticator\OAuth2Authenticator->authenticate (line 26)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator->authenticate (line 70)
11	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticator (line 176)
12	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->executeAuthenticators (line 158)
13	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->authenticateRequest (line 140)
14	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->authenticate (line 40)
15	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->authenticate (line 68)
16	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
17	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
18	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 83)
19	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
20	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
21	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
22	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
23	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
26	Symfony\Component\HttpKernel\Kernel->handle (line 197)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
28	require_once (line 29)
29	require_once (line 5)

2.65 ms
(12.15%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 432)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\ProductRepository->save (line 20)
4	App\Manager\ProductDataManager->dispatch (line 99)
5	App\Controller\ProductDataController->dispatch (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

2.32 ms
(10.65%)

INSERT INTO product_data (id, timestamp, c_mode_fonctionnement, p_mode_ete_hiver, p_mode_ete_consigne_temperature_seuil_arret, p_mode_ete_consigne_temperature_declenchement, p_mode_hiver_consigne_temperature_seuil_arret, p_mode_hiver_consigne_temperature_declenchement, p_mode_defaut_mode, p_mode_defaut_reprise_auto, p_mode_defaut_reprise_time, p_mode_horloge_type, p_mode_silencieux_power, p_mode_silencieux_plus_power, p_mode_horloge_semaine, p_mode_horloge_jour_lundi, p_mode_horloge_jour_mardi, p_mode_horloge_jour_mercredi, p_mode_horloge_jour_jeudi, p_mode_horloge_jour_vendredi, p_mode_horloge_jour_samedi, p_mode_horloge_jour_dimanche, s_temperature_exterieur, s_temperature_interieur, s_temperature_souflage, s_mode_fonctionnement_courant, s_mode_ete_hiver_courant, s_etat_fonctionnement_courant, s_debit_soufflage, s_puissance_thermique_instantanee, s_puissance_thermique_total, product_id, site_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "1f12d7f5-0ab4-6b28-a2f0-13bfed765fe5"
  1775016026000
  null
  1
  195
  -27392
  185
  -7906
  0
  0
  300
  1
  50
  30
  "241881422418000055aa241881422418000055aa24188142"
  "7227d800ff55aae41b8d7227d800ff55aae41b8d72e41b8d"
  "00ff55aae41b8d7227d800ff55aae41b8d72e41b8d7227d8"
  "aae41b8d7227d800ff55aae41b8d72e41b8d7227d800ff55"
  "8d7227d800ff55aae41b8d72e41b8d7227d800ff55aae41b"
  "d800ff55aae41b8d72e41b8d7227d800ff55aae41b8d7227"
  "55aae41b8d72e41b8d7227d800ff55aae41b8d7227d800ff"
  "1b8d72e41b8d7227d800ff55aae41b8d7227d800ff55aae4"
  9
  0
  11
  2
  1
  2
  0
  0
  15694
  "1f122a18-cac6-6064-995f-d58fd032c1e0"
  "1f0b996d-1317-6b1c-b230-5952d7c14821"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO product_data (
  id, timestamp, c_mode_fonctionnement,
  p_mode_ete_hiver, p_mode_ete_consigne_temperature_seuil_arret,
  p_mode_ete_consigne_temperature_declenchement,
  p_mode_hiver_consigne_temperature_seuil_arret,
  p_mode_hiver_consigne_temperature_declenchement,
  p_mode_defaut_mode, p_mode_defaut_reprise_auto,
  p_mode_defaut_reprise_time, p_mode_horloge_type,
  p_mode_silencieux_power, p_mode_silencieux_plus_power,
  p_mode_horloge_semaine, p_mode_horloge_jour_lundi,
  p_mode_horloge_jour_mardi, p_mode_horloge_jour_mercredi,
  p_mode_horloge_jour_jeudi, p_mode_horloge_jour_vendredi,
  p_mode_horloge_jour_samedi, p_mode_horloge_jour_dimanche,
  s_temperature_exterieur, s_temperature_interieur,
  s_temperature_souflage, s_mode_fonctionnement_courant,
  s_mode_ete_hiver_courant, s_etat_fonctionnement_courant,
  s_debit_soufflage, s_puissance_thermique_instantanee,
  s_puissance_thermique_total, product_id,
  site_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

INSERT INTO product_data (id, timestamp, c_mode_fonctionnement, p_mode_ete_hiver, p_mode_ete_consigne_temperature_seuil_arret, p_mode_ete_consigne_temperature_declenchement, p_mode_hiver_consigne_temperature_seuil_arret, p_mode_hiver_consigne_temperature_declenchement, p_mode_defaut_mode, p_mode_defaut_reprise_auto, p_mode_defaut_reprise_time, p_mode_horloge_type, p_mode_silencieux_power, p_mode_silencieux_plus_power, p_mode_horloge_semaine, p_mode_horloge_jour_lundi, p_mode_horloge_jour_mardi, p_mode_horloge_jour_mercredi, p_mode_horloge_jour_jeudi, p_mode_horloge_jour_vendredi, p_mode_horloge_jour_samedi, p_mode_horloge_jour_dimanche, s_temperature_exterieur, s_temperature_interieur, s_temperature_souflage, s_mode_fonctionnement_courant, s_mode_ete_hiver_courant, s_etat_fonctionnement_courant, s_debit_soufflage, s_puissance_thermique_instantanee, s_puissance_thermique_total, product_id, site_id) VALUES ('1f12d7f5-0ab4-6b28-a2f0-13bfed765fe5', 1775016026000, NULL, 1, 195, -27392, 185, -7906, 0, 0, 300, 1, 50, 30, '241881422418000055aa241881422418000055aa24188142', '7227d800ff55aae41b8d7227d800ff55aae41b8d72e41b8d', '00ff55aae41b8d7227d800ff55aae41b8d72e41b8d7227d8', 'aae41b8d7227d800ff55aae41b8d72e41b8d7227d800ff55', '8d7227d800ff55aae41b8d72e41b8d7227d800ff55aae41b', 'd800ff55aae41b8d72e41b8d7227d800ff55aae41b8d7227', '55aae41b8d72e41b8d7227d800ff55aae41b8d7227d800ff', '1b8d72e41b8d7227d800ff55aae41b8d7227d800ff55aae4', 9, 0, 11, 2, 1, 2, 0, 0, 15694, '1f122a18-cac6-6064-995f-d58fd032c1e0', '1f0b996d-1317-6b1c-b230-5952d7c14821');

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 255)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Manager\ProductDataManager->processData (line 209)
7	App\Manager\ProductDataManager->add (line 126)
8	App\MessageHandler\ProductDataCreateMessageHandler->__invoke (line 27)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
10	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
11	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
12	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
13	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 61)
14	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
15	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
16	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
17	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
18	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
19	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 54)
20	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 58)
21	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
22	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
23	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
24	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
25	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
26	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
27	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
28	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
29	App\Manager\ProductDataManager->dispatch (line 101)
30	App\Controller\ProductDataController->dispatch (line 41)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
33	Symfony\Component\HttpKernel\Kernel->handle (line 197)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
35	require_once (line 29)
36	require_once (line 5)

1.85 ms
(8.48%)

UPDATE product SET backup = ?, updated_at = ? WHERE id = ?

Parameters:

[
  "{"data":{"F7C30101-4177-46B9-986B-0148F74380A5":"0200","F7C30102-4177-46B9-986B-0148F74380A5":"01C3000095B9001EE10000050001321E01","F7C30103-4177-46B9-986B-0148F74380A5":"570000006600520000004E3D0000","F7C30104-4177-46B9-986B-0148F74380A5":"241881422418000055AA241881422418000055AA24188142","F7C30105-4177-46B9-986B-0148F74380A5":"7227D800FF55AAE41B8D7227D800FF55AAE41B8D72E41B8D","F7C30106-4177-46B9-986B-0148F74380A5":"00FF55AAE41B8D7227D800FF55AAE41B8D72E41B8D7227D8","F7C30107-4177-46B9-986B-0148F74380A5":"AAE41B8D7227D800FF55AAE41B8D72E41B8D7227D800FF55","F7C30108-4177-46B9-986B-0148F74380A5":"8D7227D800FF55AAE41B8D72E41B8D7227D800FF55AAE41B","F7C30109-4177-46B9-986B-0148F74380A5":"D800FF55AAE41B8D72E41B8D7227D800FF55AAE41B8D7227","F7C3010A-4177-46B9-986B-0148F74380A5":"55AAE41B8D72E41B8D7227D800FF55AAE41B8D7227D800FF","F7C3010B-4177-46B9-986B-0148F74380A5":"1B8D72E41B8D7227D800FF55AAE41B8D7227D800FF55AAE4"}}"
  "2026-04-01 04:00:26"
  "1f122a18-cac6-6064-995f-d58fd032c1e0"
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  product
SET
  backup = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE product SET backup = '{\"data\":{\"F7C30101-4177-46B9-986B-0148F74380A5\":\"0200\",\"F7C30102-4177-46B9-986B-0148F74380A5\":\"01C3000095B9001EE10000050001321E01\",\"F7C30103-4177-46B9-986B-0148F74380A5\":\"570000006600520000004E3D0000\",\"F7C30104-4177-46B9-986B-0148F74380A5\":\"241881422418000055AA241881422418000055AA24188142\",\"F7C30105-4177-46B9-986B-0148F74380A5\":\"7227D800FF55AAE41B8D7227D800FF55AAE41B8D72E41B8D\",\"F7C30106-4177-46B9-986B-0148F74380A5\":\"00FF55AAE41B8D7227D800FF55AAE41B8D72E41B8D7227D8\",\"F7C30107-4177-46B9-986B-0148F74380A5\":\"AAE41B8D7227D800FF55AAE41B8D72E41B8D7227D800FF55\",\"F7C30108-4177-46B9-986B-0148F74380A5\":\"8D7227D800FF55AAE41B8D72E41B8D7227D800FF55AAE41B\",\"F7C30109-4177-46B9-986B-0148F74380A5\":\"D800FF55AAE41B8D72E41B8D7227D800FF55AAE41B8D7227\",\"F7C3010A-4177-46B9-986B-0148F74380A5\":\"55AAE41B8D72E41B8D7227D800FF55AAE41B8D7227D800FF\",\"F7C3010B-4177-46B9-986B-0148F74380A5\":\"1B8D72E41B8D7227D800FF55AAE41B8D7227D800FF55AAE4\"}}', updated_at = '2026-04-01 04:00:26' WHERE id = '1f122a18-cac6-6064-995f-d58fd032c1e0';

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 496)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 380)
3	Doctrine\ORM\UnitOfWork->executeUpdates (line 1139)
4	Doctrine\ORM\UnitOfWork->commit (line 407)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Repository\ProductRepository->save (line 20)
7	App\Manager\ProductDataManager->dispatch (line 99)
8	App\Controller\ProductDataController->dispatch (line 41)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 197)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.58 ms
(2.65%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 381)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Repository\ProductRepository->save (line 20)
4	App\Manager\ProductDataManager->dispatch (line 99)
5	App\Controller\ProductDataController->dispatch (line 41)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
8	Symfony\Component\HttpKernel\Kernel->handle (line 197)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
10	require_once (line 29)
11	require_once (line 5)

0.25 ms
(1.13%)

RELEASE SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

RELEASE SAVEPOINT DOCTRINE_2

RELEASE SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->releaseSavepoint (line 1191)
2	Doctrine\DBAL\Connection->commit (line 1084)
3	Doctrine\ORM\UnitOfWork->commit (line 432)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	App\Manager\ProductDataManager->processData (line 209)
6	App\Manager\ProductDataManager->add (line 126)
7	App\MessageHandler\ProductDataCreateMessageHandler->__invoke (line 27)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 61)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
15	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
16	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
17	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 54)
19	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 58)
20	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
21	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
22	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
23	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
24	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
25	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
26	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
27	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
28	App\Manager\ProductDataManager->dispatch (line 101)
29	App\Controller\ProductDataController->dispatch (line 41)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 197)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	require_once (line 5)

0.21 ms
(0.96%)

SAVEPOINT DOCTRINE_2

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SAVEPOINT DOCTRINE_2

SAVEPOINT DOCTRINE_2;

#	File/Call
1	Doctrine\DBAL\Connection->createSavepoint (line 1169)
2	Doctrine\DBAL\Connection->beginTransaction (line 1059)
3	Doctrine\ORM\UnitOfWork->commit (line 381)
4	Doctrine\ORM\EntityManager->flush (line 268)
5	App\Manager\ProductDataManager->processData (line 209)
6	App\Manager\ProductDataManager->add (line 126)
7	App\MessageHandler\ProductDataCreateMessageHandler->__invoke (line 27)
8	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->callHandler (line 152)
9	Symfony\Component\Messenger\Middleware\HandleMessageMiddleware->handle (line 91)
10	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 71)
11	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
12	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 61)
13	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
14	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
15	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
16	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
17	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
18	Symfony\Component\Messenger\RoutableMessageBus->dispatch (line 54)
19	Symfony\Component\Messenger\Transport\Sync\SyncTransport->send (line 58)
20	Symfony\Component\Messenger\Middleware\SendMessageMiddleware->handle (line 62)
21	Symfony\Component\Messenger\Middleware\FailedMessageProcessingMiddleware->handle (line 34)
22	Symfony\Component\Messenger\Middleware\DispatchAfterCurrentBusMiddleware->handle (line 68)
23	Symfony\Component\Messenger\Middleware\RejectRedeliveredMessageMiddleware->handle (line 41)
24	Symfony\Component\Messenger\Middleware\AddBusNameStampMiddleware->handle (line 37)
25	Symfony\Component\Messenger\Middleware\TraceableMiddleware->handle (line 40)
26	Symfony\Component\Messenger\MessageBus->dispatch (line 70)
27	Symfony\Component\Messenger\TraceableMessageBus->dispatch (line 38)
28	App\Manager\ProductDataManager->dispatch (line 101)
29	App\Controller\ProductDataController->dispatch (line 41)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
32	Symfony\Component\HttpKernel\Kernel->handle (line 197)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
34	require_once (line 29)
35	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.

Managed Entities

default entity manager

Class	Amount of managed objects
League\Bundle\OAuth2ServerBundle\Model\AccessToken	1
League\Bundle\OAuth2ServerBundle\Model\Client	1
App\Entity\Product	1
App\Entity\Site	1
App\Entity\ProductData	1

Entities Mapping

Class	Mapping errors
League\Bundle\OAuth2ServerBundle\Model\AccessToken	No errors.
League\Bundle\OAuth2ServerBundle\Model\AbstractClient	No errors.
League\Bundle\OAuth2ServerBundle\Model\Client	No errors.
App\Entity\Product	No errors.
App\Entity\Media	No errors.
App\Entity\Site	No errors.
App\Entity\ProductData	No errors.

Symfony Profiler

POST http://api.solar-boost.feelity.dev/api/v1/products/25010055/data

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping