Symfony Profiler

Query Metrics

6 Database Queries

6 Different statements

2.67 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.78 ms
(29.38%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.username AS username_2,
  t0.roles AS roles_3,
  t0.password AS password_4
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 207)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 127)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 77)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 154)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.67 ms
(25.27%)

INSERT INTO crossdocking_audit (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "update"
  "38415"
  null
  "d0b849a8d08d41bc5522fc189f214544d210b8f9"
  "{"isReady":{"old":false,"new":true}}"
  "2"
  "antonio"
  "DH\Auditor\User\User"
  "main"
  "188.80.55.240"
  "2026-04-09 14:01:00.238080"
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO crossdocking_audit (
  TYPE, object_id, discriminator, transaction_hash,
  diffs, blame_id, blame_user, blame_user_fqdn,
  blame_user_firewall, ip, created_at
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO crossdocking_audit (TYPE, object_id, discriminator, transaction_hash, diffs, blame_id, blame_user, blame_user_fqdn, blame_user_firewall, ip, created_at) VALUES ('update', '38415', NULL, 'd0b849a8d08d41bc5522fc189f214544d210b8f9', '{\"isReady\":{\"old\":false,\"new\":true}}', '2', 'antonio', 'DH\\Auditor\\User\\User', 'main', '188.80.55.240', '2026-04-09 14:01:00.238080');

#	File/Call
1	Doctrine\DBAL\Statement->execute (line 249)
2	Doctrine\DBAL\Statement->executeStatement (line 152)
3	DH\Auditor\Provider\Doctrine\DoctrineProvider->persist (line 33)
4	DH\Auditor\EventSubscriber\AuditEventSubscriber->onAuditEvent (line 116)
5	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
6	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
7	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 127)
8	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 48)
9	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionProcessor->notify (line 232)
10	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionProcessor->audit (line 83)
11	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionProcessor->update (line 147)
12	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionProcessor->processUpdates (line 39)
13	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionProcessor->process (line 32)
14	DH\Auditor\Provider\Doctrine\Auditing\Transaction\TransactionManager->process (line 56)
15	DH\Auditor\Provider\Doctrine\Auditing\Event\DoctrineSubscriber->DH\Auditor\Provider\Doctrine\Auditing\Event\{closure} (line 24)
16	DH\Auditor\Provider\Doctrine\Auditing\DBAL\Middleware\AuditorConnection->commit (line 1469)
17	Doctrine\DBAL\Connection->doCommit (line 1427)
18	Doctrine\DBAL\Connection->commit (line 476)
19	Doctrine\ORM\UnitOfWork->commit (line 403)
20	Doctrine\ORM\EntityManager->flush (line 131)
21	App\Controller\CrossdockingController->ready (line 178)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.51 ms
(19.16%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->commit (line 29)
2	DH\Auditor\Provider\Doctrine\Auditing\DBAL\Middleware\AuditorConnection->commit (line 1469)
3	Doctrine\DBAL\Connection->doCommit (line 1427)
4	Doctrine\DBAL\Connection->commit (line 476)
5	Doctrine\ORM\UnitOfWork->commit (line 403)
6	Doctrine\ORM\EntityManager->flush (line 131)
7	App\Controller\CrossdockingController->ready (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.30 ms
(11.30%)

UPDATE crossdocking SET is_ready = ? WHERE id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

UPDATE
  crossdocking
SET
  is_ready = ?
WHERE
  id = ?

UPDATE crossdocking SET is_ready = 1 WHERE id = 38415;

#	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 131)
7	App\Controller\CrossdockingController->ready (line 178)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.26 ms
(9.66%)

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_at AS created_at_3, t0.qty AS qty_4, t0.price AS price_5, t0.description AS description_6, t0.is_ready AS is_ready_7, t0.preparation_at AS preparation_at_8, t0.separate_at AS separate_at_9, t0.product_id AS product_id_10, t0.store_order_id AS store_order_id_11, t0.order_line_id AS order_line_id_12, t0.partial_line_track_id AS partial_line_track_id_13 FROM crossdocking t0 WHERE t0.id = ?

Parameters:

[
  "38415"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.created_at AS created_at_3,
  t0.qty AS qty_4,
  t0.price AS price_5,
  t0.description AS description_6,
  t0.is_ready AS is_ready_7,
  t0.preparation_at AS preparation_at_8,
  t0.separate_at AS separate_at_9,
  t0.product_id AS product_id_10,
  t0.store_order_id AS store_order_id_11,
  t0.order_line_id AS order_line_id_12,
  t0.partial_line_track_id AS partial_line_track_id_13
FROM
  crossdocking t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.created_at AS created_at_3, t0.qty AS qty_4, t0.price AS price_5, t0.description AS description_6, t0.is_ready AS is_ready_7, t0.preparation_at AS preparation_at_8, t0.separate_at AS separate_at_9, t0.product_id AS product_id_10, t0.store_order_id AS store_order_id_11, t0.order_line_id AS order_line_id_12, t0.partial_line_track_id AS partial_line_track_id_13 FROM crossdocking t0 WHERE t0.id = '38415';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 776)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 794)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 521)
4	Doctrine\ORM\EntityManager->find (line 197)
5	Doctrine\ORM\EntityRepository->find (line 116)
6	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
8	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 87)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 36)
10	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 170)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.14 ms
(5.24%)

"START TRANSACTION"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"START TRANSACTION"

"START TRANSACTION";

#	File/Call
1	Doctrine\DBAL\Driver\Middleware\AbstractConnectionMiddleware->beginTransaction (line 1365)
2	Doctrine\DBAL\Connection->beginTransaction (line 428)
3	Doctrine\ORM\UnitOfWork->commit (line 403)
4	Doctrine\ORM\EntityManager->flush (line 131)
5	App\Controller\CrossdockingController->ready (line 178)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
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.

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\OrderStatus	No errors.
App\Entity\Order	No errors.
App\Entity\UserPreparationOrder	No errors.
App\Entity\LogScanning	No errors.
App\Entity\OrderInvoiceDoc	No errors.
App\Entity\LogDelete	No errors.
App\Entity\Crossdocking	No errors.
App\Entity\Product	No errors.
App\Entity\OrderLine	The field 'App\Entity\OrderLine#discount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\PartialLineTrack	No errors.
App\Entity\Status	No errors.
App\Entity\Store	No errors.
App\Entity\ShipProvider	No errors.
App\Entity\MarketStore	No errors.
App\Entity\StoreShipProvider	No errors.
App\Entity\OrderShipProviderStatus	No errors.
App\Entity\ShipProviderStatus	No errors.
App\Entity\OrderRma	No errors.
App\Entity\LogProduct	No errors.
App\Entity\InvoiceProvider	No errors.
App\Entity\InvoiceProviderStore	No errors.
App\Entity\Inventory	No errors.
App\Entity\TrackingInventory	No errors.
App\Entity\SupplierInvoiceLine	No errors.
App\Entity\ProductMarketStore	No errors.
App\Entity\ProductSync	No errors.
App\Entity\Tax	No errors.
App\Entity\OrderRmaLine	No errors.
App\Entity\ProductInvoiceStore	No errors.
App\Entity\AutoInvoiceRule	No errors.
App\Entity\SectionType	No errors.
App\Entity\ShipInvoiceStore	No errors.
App\Entity\Supplier	No errors.
App\Entity\SupplierInvoice	No errors.
App\Entity\Location	No errors.
App\Entity\Section	No errors.
App\Entity\Settings	No errors.
App\Entity\ExpenseName	No errors.
App\Entity\Zone	No errors.
App\Entity\Market	No errors.
App\Entity\StoreRate	No errors.
App\Entity\StoreRateLine	No errors.
App\Entity\Center	No errors.
App\Entity\LogHandler	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

GET https://tudoestaqui.pt/crossdocking/38415/ready

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping