Symfony Profiler

Query Metrics

10 Database Queries

10 Different statements

18.38 ms Query time

1 Invalid entities

7 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

8.34 ms
(45.37%)

SELECT COUNT(id) AS invoiceCount
        FROM invoice
        WHERE label LIKE :yearMonth
          AND sales_id = :salesId

Parameters:

[
  "yearMonth" => "2026/JUN/%"
  "salesId" => 4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(id) AS invoiceCount
FROM
  invoice
WHERE
  label LIKE :yearMonth
  AND sales_id = :salesId

SELECT COUNT(id) AS invoiceCount
        FROM invoice
        WHERE label LIKE '2026/JUN/%'
          AND sales_id = 4
    ;

#	File/Call
1	Doctrine\DBAL\Statement->executeQuery (line 224)
2	App\Repository\InvoiceRepository->generateSequenceNumbers (line 131)
3	App\Controller\PurchaseController->addpurchase (line 126)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

2.22 ms
(12.07%)

SELECT t0.id AS id_1, t0.item_number AS item_number_2, t0.carton_number AS carton_number_3, t0.totalitemvalue AS totalitemvalue_4, t0.totalctnsvalue AS totalctnsvalue_5, t0.totalvalue AS totalvalue_6, t0.box_number AS box_number_7, t0.bottle_number AS bottle_number_8, t0.totalboxvalue AS totalboxvalue_9, t0.sac_number AS sac_number_10, t0.totalsacvalue AS totalsacvalue_11, t0.totalbottlevalue AS totalbottlevalue_12, t0.pricectn AS pricectn_13, t0.pricesac AS pricesac_14, t0.pricebtl AS pricebtl_15, t0.pricebox AS pricebox_16, t0.priceitem AS priceitem_17, t0.id_brand_id AS id_brand_id_18, t0.invoice_id AS invoice_id_19, t0.id_brand_cashvan_id AS id_brand_cashvan_id_20 FROM purchase t0 WHERE t0.id_brand_id = ? AND t0.invoice_id = ? LIMIT 1

Parameters:

[
  76
  null
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.item_number AS item_number_2,
  t0.carton_number AS carton_number_3,
  t0.totalitemvalue AS totalitemvalue_4,
  t0.totalctnsvalue AS totalctnsvalue_5,
  t0.totalvalue AS totalvalue_6,
  t0.box_number AS box_number_7,
  t0.bottle_number AS bottle_number_8,
  t0.totalboxvalue AS totalboxvalue_9,
  t0.sac_number AS sac_number_10,
  t0.totalsacvalue AS totalsacvalue_11,
  t0.totalbottlevalue AS totalbottlevalue_12,
  t0.pricectn AS pricectn_13,
  t0.pricesac AS pricesac_14,
  t0.pricebtl AS pricebtl_15,
  t0.pricebox AS pricebox_16,
  t0.priceitem AS priceitem_17,
  t0.id_brand_id AS id_brand_id_18,
  t0.invoice_id AS invoice_id_19,
  t0.id_brand_cashvan_id AS id_brand_cashvan_id_20
FROM
  purchase t0
WHERE
  t0.id_brand_id = ?
  AND t0.invoice_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.item_number AS item_number_2, t0.carton_number AS carton_number_3, t0.totalitemvalue AS totalitemvalue_4, t0.totalctnsvalue AS totalctnsvalue_5, t0.totalvalue AS totalvalue_6, t0.box_number AS box_number_7, t0.bottle_number AS bottle_number_8, t0.totalboxvalue AS totalboxvalue_9, t0.sac_number AS sac_number_10, t0.totalsacvalue AS totalsacvalue_11, t0.totalbottlevalue AS totalbottlevalue_12, t0.pricectn AS pricectn_13, t0.pricesac AS pricesac_14, t0.pricebtl AS pricebtl_15, t0.pricebox AS pricebox_16, t0.priceitem AS priceitem_17, t0.id_brand_id AS id_brand_id_18, t0.invoice_id AS invoice_id_19, t0.id_brand_cashvan_id AS id_brand_cashvan_id_20 FROM purchase t0 WHERE t0.id_brand_id = 76 AND t0.invoice_id = NULL LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Controller\PurchaseController->addpurchase (line 185)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (line 29)
10	require_once (line 5)

1.91 ms
(10.37%)

INSERT INTO purchase (item_number, carton_number, totalitemvalue, totalctnsvalue, totalvalue, box_number, bottle_number, totalboxvalue, sac_number, totalsacvalue, totalbottlevalue, pricectn, pricesac, pricebtl, pricebox, priceitem, id_brand_id, invoice_id, id_brand_cashvan_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "400"
  "0"
  188000.0
  0.0
  188000.0
  "0"
  "0"
  "0"
  "0"
  0.0
  0.0
  451200.0
  0.0
  0.0
  0.0
  470.0
  76
  24522
  null
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO purchase (
  item_number, carton_number, totalitemvalue,
  totalctnsvalue, totalvalue, box_number,
  bottle_number, totalboxvalue, sac_number,
  totalsacvalue, totalbottlevalue,
  pricectn, pricesac, pricebtl, pricebox,
  priceitem, id_brand_id, invoice_id,
  id_brand_cashvan_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

INSERT INTO purchase (item_number, carton_number, totalitemvalue, totalctnsvalue, totalvalue, box_number, bottle_number, totalboxvalue, sac_number, totalsacvalue, totalbottlevalue, pricectn, pricesac, pricebtl, pricebox, priceitem, id_brand_id, invoice_id, id_brand_cashvan_id) VALUES ('400', '0', 188000, 0, 188000, '0', '0', '0', '0', 0, 0, 451200, 0, 0, 0, 470, 76, 24522, NULL);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PurchaseController->addpurchase (line 245)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.54 ms
(8.40%)

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.brand = ? LIMIT 1

Parameters:

[
  " Rasoir Dorco ( TD702-NV 1 Pcs) (960 Pcs)"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.pricectns AS pricectns_3,
  t0.pricebox AS pricebox_4,
  t0.pricebottle AS pricebottle_5,
  t0.priceitem AS priceitem_6,
  t0.pricesac AS pricesac_7
FROM
  goods t0
WHERE
  t0.brand = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.pricectns AS pricectns_3, t0.pricebox AS pricebox_4, t0.pricebottle AS pricebottle_5, t0.priceitem AS priceitem_6, t0.pricesac AS pricesac_7 FROM goods t0 WHERE t0.brand = ' Rasoir Dorco ( TD702-NV 1 Pcs) (960 Pcs)' LIMIT 1;

#	File/Call
1	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 738)
2	Doctrine\ORM\EntityRepository->findOneBy (line 125)
3	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 81)
4	App\Repository\PurchaseRepository->findGoodByName (line 167)
5	App\Controller\PurchaseController->addpurchase (line 181)
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)

1.24 ms
(6.74%)

SELECT t0.id AS id_1, t0.section AS section_2, t0.location AS location_3, t0.shop_name AS shop_name_4, t0.phone AS phone_5, t0.credit_limit AS credit_limit_6, t0.credit_days AS credit_days_7, t0.name_manager_shop AS name_manager_shop_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.sales_men_id AS sales_men_id_11, t0.city_id AS city_id_12 FROM shop t0 WHERE t0.id = ?

Parameters:

[
  3665
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.section AS section_2,
  t0.location AS location_3,
  t0.shop_name AS shop_name_4,
  t0.phone AS phone_5,
  t0.credit_limit AS credit_limit_6,
  t0.credit_days AS credit_days_7,
  t0.name_manager_shop AS name_manager_shop_8,
  t0.longitude AS longitude_9,
  t0.latitude AS latitude_10,
  t0.sales_men_id AS sales_men_id_11,
  t0.city_id AS city_id_12
FROM
  shop t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.section AS section_2, t0.location AS location_3, t0.shop_name AS shop_name_4, t0.phone AS phone_5, t0.credit_limit AS credit_limit_6, t0.credit_days AS credit_days_7, t0.name_manager_shop AS name_manager_shop_8, t0.longitude AS longitude_9, t0.latitude AS latitude_10, t0.sales_men_id AS sales_men_id_11, t0.city_id AS city_id_12 FROM shop t0 WHERE t0.id = 3665;

#	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	App\Controller\PurchaseController->addpurchase (line 120)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

1.19 ms
(6.46%)

"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\Controller\PurchaseController->addpurchase (line 245)
4	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
5	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
6	Symfony\Component\HttpKernel\Kernel->handle (line 197)
7	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
8	require_once (line 29)
9	require_once (line 5)

0.66 ms
(3.60%)

SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.contact AS contact_6, t0.city AS city_7 FROM user t0 WHERE t0.id = ?

Parameters:

[
  9
]

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,
  t0.email AS email_5,
  t0.contact AS contact_6,
  t0.city AS city_7
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, t0.email AS email_5, t0.contact AS contact_6, t0.city AS city_7 FROM user t0 WHERE t0.id = 9;

#	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 214)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 131)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 46)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 26)
11	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 60)
12	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 80)
13	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 95)
14	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 116)
15	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
17	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 139)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
20	Symfony\Component\HttpKernel\Kernel->handle (line 197)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
22	require_once (line 29)
23	require_once (line 5)

0.56 ms
(3.06%)

INSERT INTO invoice (date, label, amount, latitude, longitude, cash_amount, credit_amount, etat, sales_id, shop_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Parameters:

[
  "2026-06-25 16:34:44"
  "2026/JUN/PARVEZ/283"
  188000.0
  -18.9081483
  47.518985
  0.0
  188000.0
  0
  4
  3665
]

View formatted query View runnable query Explain query View query backtrace

INSERT INTO invoice (
  date, label, amount, latitude, longitude,
  cash_amount, credit_amount, etat,
  sales_id, shop_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO invoice (date, label, amount, latitude, longitude, cash_amount, credit_amount, etat, sales_id, shop_id) VALUES ('2026-06-25 16:34:44', '2026/JUN/PARVEZ/283', 188000, -18.9081483, 47.518985, 0, 188000, 0, 4, 3665);

#	File/Call
1	Doctrine\DBAL\Statement->executeStatement (line 249)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->executeInserts (line 253)
3	Doctrine\ORM\UnitOfWork->executeInserts (line 1059)
4	Doctrine\ORM\UnitOfWork->commit (line 402)
5	Doctrine\ORM\EntityManager->flush (line 268)
6	App\Controller\PurchaseController->addpurchase (line 245)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.46 ms
(2.49%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact AS contact_3, t0.address AS address_4, t0.can_sell_cash AS can_sell_cash_5, t0.is_cashvan AS is_cashvan_6, t0.user_id AS user_id_7 FROM sales_men t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.contact AS contact_3,
  t0.address AS address_4,
  t0.can_sell_cash AS can_sell_cash_5,
  t0.is_cashvan AS is_cashvan_6,
  t0.user_id AS user_id_7
FROM
  sales_men t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.contact AS contact_3, t0.address AS address_4, t0.can_sell_cash AS can_sell_cash_5, t0.is_cashvan AS is_cashvan_6, t0.user_id AS user_id_7 FROM sales_men 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	App\Controller\PurchaseController->addpurchase (line 119)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
9	Symfony\Component\HttpKernel\Kernel->handle (line 197)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
11	require_once (line 29)
12	require_once (line 5)

0.26 ms
(1.43%)

"COMMIT"

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

"COMMIT"

"COMMIT";

#	File/Call
1	Doctrine\DBAL\Connection->commit (line 1454)
2	Doctrine\ORM\UnitOfWork->commit (line 432)
3	Doctrine\ORM\EntityManager->flush (line 268)
4	App\Controller\PurchaseController->addpurchase (line 245)
5	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
7	Symfony\Component\HttpKernel\Kernel->handle (line 197)
8	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
9	require_once (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
App\Entity\User	1
App\Entity\SalesMen	1
App\Entity\Shop	1
App\Entity\City	1
App\Entity\Goods	1
App\Entity\Invoice	1
App\Entity\Purchase	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\SalesMen	No errors.
App\Entity\Shop	No errors.
App\Entity\Invoice	No errors.
App\Entity\ShopSalesman	No errors.
App\Entity\ProductMove	No errors.
App\Entity\City	No errors.
App\Entity\Payment	No errors.
App\Entity\Purchase	No errors.
App\Entity\Goods	No errors.
App\Entity\Inventory	No errors.
App\Entity\MvtStock	No errors.
App\Entity\Promotion	No errors.
App\Entity\GoodsCashvan	No errors.
App\Entity\PromotionInvoice	The association App\Entity\PromotionInvoice#brand refers to the inverse side field App\Entity\Goods#promotionInvoices which does not exist.

Symfony Profiler

POST https://azima24.com/api/addpurchase

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping