Symfony Profiler

Query Metrics

9 Database Queries

7 Different statements

4.81 ms Query time

0 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.20 ms
(45.72%)

"ROLLBACK"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"ROLLBACK"

"ROLLBACK";

#	File/Call
1	Doctrine\DBAL\Connection->rollBack (line 448)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 1297)
4	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->onAutre (line 180)
5	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.69 ms
(14.33%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "HIBOUTIK_ACCOUNT"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  setting t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM setting t0 WHERE t0.name = 'HIBOUTIK_ACCOUNT' LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 34)
5	App\Service\POS\HiboutikService->getSetting (line 45)
6	App\Service\POS\HiboutikService->cfg (line 59)
7	App\Service\POS\HiboutikService->headersForm (line 116)
8	App\Service\POS\HiboutikService->createSale (line 1291)
9	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->onAutre (line 180)
10	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.56 ms
(11.69%)

UPDATE `order` SET hiboutik_id = ? WHERE id = ?

Parameters:

[
  "10"
  12185
]

View formatted query View runnable query Explain query View query backtrace

UPDATE
  `order`
SET
  hiboutik_id = ?
WHERE
  id = ?

UPDATE `order` SET hiboutik_id = '10' WHERE id = 12185;

#	File/Call
1	Doctrine\DBAL\Connection->executeStatement (line 492)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->updateTable (line 376)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->update (line 1130)
4	Doctrine\ORM\UnitOfWork->executeUpdates (line 406)
5	Doctrine\ORM\UnitOfWork->commit (line 264)
6	Doctrine\ORM\EntityManager->flush (line 1297)
7	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->onAutre (line 180)
8	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.38 ms
(7.96%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = ?

Parameters:

[
  14
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.username AS username_3,
  t0.roles AS roles_4,
  t0.password AS password_5
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5 FROM user t0 WHERE t0.id = 14;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 60)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 5)

0.38 ms
(7.82%)

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.product_name AS product_name_3, t0.unit_price AS unit_price_4, t0.qty AS qty_5, t0.options AS options_6, t0.comment AS comment_7, t0.meta AS meta_8, t0.valid_creneau AS valid_creneau_9, t0.unit_price_ht AS unit_price_ht_10, t0.vat_rate AS vat_rate_11, t0.line_ht AS line_ht_12, t0.line_vat AS line_vat_13, t0.line_ttc AS line_ttc_14, t0.order_ref_id AS order_ref_id_15 FROM order_line t0 WHERE t0.order_ref_id = ?

Parameters:

[
  12185
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.product_name AS product_name_3,
  t0.unit_price AS unit_price_4,
  t0.qty AS qty_5,
  t0.options AS options_6,
  t0.comment AS comment_7,
  t0.meta AS meta_8,
  t0.valid_creneau AS valid_creneau_9,
  t0.unit_price_ht AS unit_price_ht_10,
  t0.vat_rate AS vat_rate_11,
  t0.line_ht AS line_ht_12,
  t0.line_vat AS line_vat_13,
  t0.line_ttc AS line_ttc_14,
  t0.order_ref_id AS order_ref_id_15
FROM
  order_line t0
WHERE
  t0.order_ref_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.product_name AS product_name_3, t0.unit_price AS unit_price_4, t0.qty AS qty_5, t0.options AS options_6, t0.comment AS comment_7, t0.meta AS meta_8, t0.valid_creneau AS valid_creneau_9, t0.unit_price_ht AS unit_price_ht_10, t0.vat_rate AS vat_rate_11, t0.line_ht AS line_ht_12, t0.line_vat AS line_vat_13, t0.line_ttc AS line_ttc_14, t0.order_ref_id AS order_ref_id_15 FROM order_line t0 WHERE t0.order_ref_id = 12185;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1848)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1793)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2709)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 600)
8	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->computeEffectiveUnitTtcByLine (line 1287)
9	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->onAutre (line 180)
10	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.37 ms
(7.74%)

SELECT t0.id AS id_1, t0.status AS status_2, t0.customer_name AS customer_name_3, t0.customer_phone AS customer_phone_4, t0.comment AS comment_5, t0.service AS service_6, t0.service_date AS service_date_7, t0.slot AS slot_8, t0.created_at AS created_at_9, t0.locked AS locked_10, t0.validated_at_utc AS validated_at_utc_11, t0.subtotal_ttc AS subtotal_ttc_12, t0.discount_amount AS discount_amount_13, t0.discount_label AS discount_label_14, t0.total_ttc AS total_ttc_15, t0.prev_hash AS prev_hash_16, t0.entry_hash AS entry_hash_17, t0.signature AS signature_18, t0.key_id AS key_id_19, t0.hiboutik_id AS hiboutik_id_20, t0.uber_id AS uber_id_21, t0.cancel_origin_id AS cancel_origin_id_22, t0.gift_code_id AS gift_code_id_23 FROM `order` t0 WHERE t0.id = ?

Parameters:

[
  12185
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.customer_name AS customer_name_3,
  t0.customer_phone AS customer_phone_4,
  t0.comment AS comment_5,
  t0.service AS service_6,
  t0.service_date AS service_date_7,
  t0.slot AS slot_8,
  t0.created_at AS created_at_9,
  t0.locked AS locked_10,
  t0.validated_at_utc AS validated_at_utc_11,
  t0.subtotal_ttc AS subtotal_ttc_12,
  t0.discount_amount AS discount_amount_13,
  t0.discount_label AS discount_label_14,
  t0.total_ttc AS total_ttc_15,
  t0.prev_hash AS prev_hash_16,
  t0.entry_hash AS entry_hash_17,
  t0.signature AS signature_18,
  t0.key_id AS key_id_19,
  t0.hiboutik_id AS hiboutik_id_20,
  t0.uber_id AS uber_id_21,
  t0.cancel_origin_id AS cancel_origin_id_22,
  t0.gift_code_id AS gift_code_id_23
FROM
  `order` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.customer_name AS customer_name_3, t0.customer_phone AS customer_phone_4, t0.comment AS comment_5, t0.service AS service_6, t0.service_date AS service_date_7, t0.slot AS slot_8, t0.created_at AS created_at_9, t0.locked AS locked_10, t0.validated_at_utc AS validated_at_utc_11, t0.subtotal_ttc AS subtotal_ttc_12, t0.discount_amount AS discount_amount_13, t0.discount_label AS discount_label_14, t0.total_ttc AS total_ttc_15, t0.prev_hash AS prev_hash_16, t0.entry_hash AS entry_hash_17, t0.signature AS signature_18, t0.key_id AS key_id_19, t0.hiboutik_id AS hiboutik_id_20, t0.uber_id AS uber_id_21, t0.cancel_origin_id AS cancel_origin_id_22, t0.gift_code_id AS gift_code_id_23 FROM `order` t0 WHERE t0.id = 12185;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 736)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 754)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 63)
7	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.23 ms
(4.74%)

"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 380)
2	Doctrine\ORM\UnitOfWork->commit (line 264)
3	Doctrine\ORM\EntityManager->flush (line 1297)
4	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->onAutre (line 180)
5	App\Controller\Admin\Cash\Scenario2\Api\PaymentController->addPayment (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	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

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Order	No errors.
App\Entity\GiftCode	No errors.
App\Entity\OrderLine	No errors.
App\Entity\Setting	No errors.

Symfony Profiler

POST https://www.gamechange.fr/add-payment

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping