Symfony Profiler

Query Metrics

907 Database Queries

8 Different statements

463.38 ms Query time

0 Invalid entities

903 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

274.04 ms
(59.14%)

561

SELECT p0_.id AS id_0, p0_.pt_part AS pt_part_1, p0_.pt_desc AS pt_desc_2, p0_.pt_domain AS pt_domain_3, p0_.pt_prod_line AS pt_prod_line_4, p0_.pt_dsgn_grp AS pt_dsgn_grp_5, p0_.pt_group AS pt_group_6, p0_.pt_rev AS pt_rev_7, p0_.pt_um AS pt_um_8, p0_.pt_vend AS pt_vend_9, p0_.pt_article AS pt_article_10 FROM product p0_ WHERE p0_.pt_part = ? AND p0_.pt_domain = ? AND p0_.pt_vend = ?

Parameters:

[
  "AR000001"
  "TRENDY"
  "77965620"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.pt_part AS pt_part_1,
  p0_.pt_desc AS pt_desc_2,
  p0_.pt_domain AS pt_domain_3,
  p0_.pt_prod_line AS pt_prod_line_4,
  p0_.pt_dsgn_grp AS pt_dsgn_grp_5,
  p0_.pt_group AS pt_group_6,
  p0_.pt_rev AS pt_rev_7,
  p0_.pt_um AS pt_um_8,
  p0_.pt_vend AS pt_vend_9,
  p0_.pt_article AS pt_article_10
FROM
  product p0_
WHERE
  p0_.pt_part = ?
  AND p0_.pt_domain = ?
  AND p0_.pt_vend = ?

SELECT p0_.id AS id_0, p0_.pt_part AS pt_part_1, p0_.pt_desc AS pt_desc_2, p0_.pt_domain AS pt_domain_3, p0_.pt_prod_line AS pt_prod_line_4, p0_.pt_dsgn_grp AS pt_dsgn_grp_5, p0_.pt_group AS pt_group_6, p0_.pt_rev AS pt_rev_7, p0_.pt_um AS pt_um_8, p0_.pt_vend AS pt_vend_9, p0_.pt_article AS pt_article_10 FROM product p0_ WHERE p0_.pt_part = 'AR000001' AND p0_.pt_domain = 'TRENDY' AND p0_.pt_vend = '77965620';

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 737)
6	App\Repository\ProductRepository->findByCompositeKey (line 125)
7	App\Service\InventorySyncService->replaceCompanyInventory (line 113)
8	App\Service\InventorySyncService->syncCompany (line 67)
9	App\Service\InventorySyncService->syncAllCompanies (line 37)
10	App\Controller\Admin\InventoryController->index (line 28)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
13	Symfony\Component\HttpKernel\Kernel->handle (line 193)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
15	require_once (line 32)
16	require_once (line 5)

166.18 ms
(35.86%)

340

INSERT INTO inventory (product_description, sku, quantity, location, ld_part, ld_domain, ld_site, ld_status, ld_loc, ld_lot, ld_expire, ld_qty_oh, ld_ref, created_at, updated_at, company_id, product_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "PAPA 12mm 2,5kg"
  "AR000001"
  84
  "C2R10011"
  "AR000001"
  "TRENDY"
  "300"
  "REVISION"
  "C2R10011"
  "FS03042028"
  "2028-04-02"
  "84"
  "14213059"
  "2026-10-15 16:45:47"
  "2026-10-15 16:45:47"
  5
  568
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO inventory (
  product_description, sku, quantity,
  location, ld_part, ld_domain, ld_site,
  ld_status, ld_loc, ld_lot, ld_expire,
  ld_qty_oh, ld_ref, created_at, updated_at,
  company_id, product_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?
  )

INSERT INTO inventory (product_description, sku, quantity, location, ld_part, ld_domain, ld_site, ld_status, ld_loc, ld_lot, ld_expire, ld_qty_oh, ld_ref, created_at, updated_at, company_id, product_id) VALUES ('PAPA 12mm 2,5kg', 'AR000001', 84, 'C2R10011', 'AR000001', 'TRENDY', '300', 'REVISION', 'C2R10011', 'FS03042028', '2028-04-02', '84', '14213059', '2026-10-15 16:45:47', '2026-10-15 16:45:47', 5, 568);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 133)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1060)
4	Doctrine\ORM\UnitOfWork->commit (line 403)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Service\InventorySyncService->replaceCompanyInventory (line 161)
7	App\Service\InventorySyncService->syncCompany (line 67)
8	App\Service\InventorySyncService->syncAllCompanies (line 37)
9	App\Controller\Admin\InventoryController->index (line 28)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

15.86 ms
(3.42%)

DELETE FROM inventory WHERE company_id = ?

Parameters:

[
  5
]

View formatted query View runnable query Explain query View query backtrace

DELETE FROM
  inventory
WHERE
  company_id = ?

DELETE FROM inventory WHERE company_id = 5;

#	File/Call
1	Doctrine\ORM\Query\Exec\SingleTableDeleteUpdateExecutor->execute (line 38)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	App\Repository\InventoryRepository->deleteByCompany (line 93)
6	App\Service\InventorySyncService->replaceCompanyInventory (line 86)
7	App\Service\InventorySyncService->syncCompany (line 67)
8	App\Service\InventorySyncService->syncAllCompanies (line 37)
9	App\Controller\Admin\InventoryController->index (line 28)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
12	Symfony\Component\HttpKernel\Kernel->handle (line 193)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
14	require_once (line 32)
15	require_once (line 5)

2.94 ms
(0.63%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\ORM\UnitOfWork->commit (line 433)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\InventorySyncService->replaceCompanyInventory (line 161)
4	App\Service\InventorySyncService->syncCompany (line 67)
5	App\Service\InventorySyncService->syncAllCompanies (line 37)
6	App\Controller\Admin\InventoryController->index (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

2.43 ms
(0.52%)

SELECT i0_.id AS id_0, i0_.product_description AS product_description_1, i0_.sku AS sku_2, i0_.quantity AS quantity_3, i0_.location AS location_4, i0_.ld_part AS ld_part_5, i0_.ld_domain AS ld_domain_6, i0_.ld_site AS ld_site_7, i0_.ld_status AS ld_status_8, i0_.ld_loc AS ld_loc_9, i0_.ld_lot AS ld_lot_10, i0_.ld_expire AS ld_expire_11, i0_.ld_qty_oh AS ld_qty_oh_12, i0_.ld_ref AS ld_ref_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.company_id AS company_id_16, i0_.product_id AS product_id_17 FROM inventory i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id LEFT JOIN product p2_ ON i0_.product_id = p2_.id ORDER BY i0_.ld_part ASC LIMIT 50

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.id AS id_0,
  i0_.product_description AS product_description_1,
  i0_.sku AS sku_2,
  i0_.quantity AS quantity_3,
  i0_.location AS location_4,
  i0_.ld_part AS ld_part_5,
  i0_.ld_domain AS ld_domain_6,
  i0_.ld_site AS ld_site_7,
  i0_.ld_status AS ld_status_8,
  i0_.ld_loc AS ld_loc_9,
  i0_.ld_lot AS ld_lot_10,
  i0_.ld_expire AS ld_expire_11,
  i0_.ld_qty_oh AS ld_qty_oh_12,
  i0_.ld_ref AS ld_ref_13,
  i0_.created_at AS created_at_14,
  i0_.updated_at AS updated_at_15,
  i0_.company_id AS company_id_16,
  i0_.product_id AS product_id_17
FROM
  inventory i0_
  INNER JOIN company c1_ ON i0_.company_id = c1_.id
  LEFT JOIN product p2_ ON i0_.product_id = p2_.id
ORDER BY
  i0_.ld_part ASC
LIMIT
  50

SELECT i0_.id AS id_0, i0_.product_description AS product_description_1, i0_.sku AS sku_2, i0_.quantity AS quantity_3, i0_.location AS location_4, i0_.ld_part AS ld_part_5, i0_.ld_domain AS ld_domain_6, i0_.ld_site AS ld_site_7, i0_.ld_status AS ld_status_8, i0_.ld_loc AS ld_loc_9, i0_.ld_lot AS ld_lot_10, i0_.ld_expire AS ld_expire_11, i0_.ld_qty_oh AS ld_qty_oh_12, i0_.ld_ref AS ld_ref_13, i0_.created_at AS created_at_14, i0_.updated_at AS updated_at_15, i0_.company_id AS company_id_16, i0_.product_id AS product_id_17 FROM inventory i0_ INNER JOIN company c1_ ON i0_.company_id = c1_.id LEFT JOIN product p2_ ON i0_.product_id = p2_.id ORDER BY i0_.ld_part ASC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Service\Search->getResults (line 266)
7	App\Repository\InventoryRepository->getFilterResults (line 46)
8	App\Controller\Admin\InventoryController->index (line 43)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 193)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 32)
14	require_once (line 5)

0.73 ms
(0.16%)

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.last_login AS last_login_7, t0.is_new AS is_new_8, t0.position AS position_9, t0.is_company_admin AS is_company_admin_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.status AS status_6,
  t0.last_login AS last_login_7,
  t0.is_new AS is_new_8,
  t0.position AS position_9,
  t0.is_company_admin AS is_company_admin_10,
  t0.company_id AS company_id_11
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.status AS status_6, t0.last_login AS last_login_7, t0.is_new AS is_new_8, t0.position AS position_9, t0.is_company_admin AS is_company_admin_10, t0.company_id AS company_id_11 FROM `user` t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 756)
3	Doctrine\ORM\EntityManager->find (line 366)
4	Doctrine\ORM\EntityRepository->find (line 86)
5	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 61)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 99)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 129)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->authenticate (line 70)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 94)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 93)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 126)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 159)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
19	Symfony\Component\HttpKernel\Kernel->handle (line 193)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
21	require_once (line 32)
22	require_once (line 5)

0.66 ms
(0.14%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.contact_person AS contact_person_7, t0.status AS status_8, t0.max_daily_requests AS max_daily_requests_9, t0.created_at AS created_at_10 FROM company t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.tax_id AS tax_id_3,
  t0.address AS address_4,
  t0.phone AS phone_5,
  t0.email AS email_6,
  t0.contact_person AS contact_person_7,
  t0.status AS status_8,
  t0.max_daily_requests AS max_daily_requests_9,
  t0.created_at AS created_at_10
FROM
  company t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.tax_id AS tax_id_3, t0.address AS address_4, t0.phone AS phone_5, t0.email AS email_6, t0.contact_person AS contact_person_7, t0.status AS status_8, t0.max_daily_requests AS max_daily_requests_9, t0.created_at AS created_at_10 FROM company t0;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 963)
2	Doctrine\ORM\EntityRepository->findBy (line 110)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 73)
4	Doctrine\ORM\EntityRepository->findAll (line 96)
5	App\Service\InventorySyncService->syncAllCompanies (line 36)
6	App\Controller\Admin\InventoryController->index (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	require_once (line 5)

0.54 ms
(0.12%)

"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 382)
2	Doctrine\ORM\EntityManager->flush (line 268)
3	App\Service\InventorySyncService->replaceCompanyInventory (line 161)
4	App\Service\InventorySyncService->syncCompany (line 67)
5	App\Service\InventorySyncService->syncAllCompanies (line 37)
6	App\Controller\Admin\InventoryController->index (line 28)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 193)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 32)
12	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
App\Entity\Product	561
App\Entity\Inventory	340
App\Entity\User	1
App\Entity\Company	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Company	No errors.
App\Entity\PalletRequest	No errors.
App\Entity\Inventory	No errors.
App\Entity\Transaction	No errors.
App\Entity\Product	No errors.

Symfony Profiler

GET https://logistics.trendy.cl/admin/inventory/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping