Symfony Profiler

Query Metrics

8 Database Queries

6 Different statements

2.72 ms Query time

2 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼

Count

Info

0.66 ms
(24.09%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.vat_number AS vat_number_4, t0.is_tax_payer AS is_tax_payer_5, t0.analytic_account AS analytic_account_6, t0.registration_number AS registration_number_7, t0.address AS address_8, t0.phone AS phone_9, t0.email AS email_10, t0.bank_account AS bank_account_11, t0.bank AS bank_12, t0.administrator AS administrator_13, t0.publicity_tax_included AS publicity_tax_included_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.supplier_id AS supplier_id_17, t0.locality_id AS locality_id_18 FROM client t0 WHERE t0.id = ?

Parameters:

[
  58
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.vat_number AS vat_number_4,
  t0.is_tax_payer AS is_tax_payer_5,
  t0.analytic_account AS analytic_account_6,
  t0.registration_number AS registration_number_7,
  t0.address AS address_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.bank_account AS bank_account_11,
  t0.bank AS bank_12,
  t0.administrator AS administrator_13,
  t0.publicity_tax_included AS publicity_tax_included_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.supplier_id AS supplier_id_17,
  t0.locality_id AS locality_id_18
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.vat_number AS vat_number_4, t0.is_tax_payer AS is_tax_payer_5, t0.analytic_account AS analytic_account_6, t0.registration_number AS registration_number_7, t0.address AS address_8, t0.phone AS phone_9, t0.email AS email_10, t0.bank_account AS bank_account_11, t0.bank AS bank_12, t0.administrator AS administrator_13, t0.publicity_tax_included AS publicity_tax_included_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.supplier_id AS supplier_id_17, t0.locality_id AS locality_id_18 FROM client t0 WHERE t0.id = 58;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Client::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Client->__get (line 109)
8	App\Entity\Client->getName (line 616)
9	App\Entity\Order->presentAsArray (line 235)
10	App\Controller\Admin\AbstractListController->getPageList (line 141)
11	App\Controller\Admin\OrderController->orderList (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.58 ms
(21.14%)

SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ WHERE o0_.responsible_id = ? ORDER BY o0_.id DESC LIMIT 10

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT o0_.id AS id_0,
  o0_.id AS id_1
FROM
  `order` o0_
WHERE
  o0_.responsible_id = ?
ORDER BY
  o0_.id DESC
LIMIT
  10

SELECT DISTINCT o0_.id AS id_0, o0_.id AS id_1 FROM `order` o0_ WHERE o0_.responsible_id = 2 ORDER BY o0_.id DESC LIMIT 10;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 153)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 71)
8	App\Pagination\Paginator->paginate (line 64)
9	App\Repository\OrderRepository->findPageItems (line 206)
10	App\Controller\Admin\AbstractListController->getPageList (line 141)
11	App\Controller\Admin\OrderController->orderList (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.54 ms
(19.79%)

SELECT t0.id AS id_1, t0.number AS number_2, t0.brand AS brand_3, t0.date AS date_4, t0.due_days AS due_days_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.client_id AS client_id_8, t0.user_id AS user_id_9, t0.responsible_id AS responsible_id_10 FROM contract t0 WHERE t0.id = ?

Parameters:

[
  44
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.number AS number_2,
  t0.brand AS brand_3,
  t0.date AS date_4,
  t0.due_days AS due_days_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.client_id AS client_id_8,
  t0.user_id AS user_id_9,
  t0.responsible_id AS responsible_id_10
FROM
  contract t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.number AS number_2, t0.brand AS brand_3, t0.date AS date_4, t0.due_days AS due_days_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.client_id AS client_id_8, t0.user_id AS user_id_9, t0.responsible_id AS responsible_id_10 FROM contract t0 WHERE t0.id = 44;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 365)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 472)
5	Proxies\__CG__\App\Entity\Contract::Doctrine\ORM\Proxy\{closure} (line 100)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 184)
7	Proxies\__CG__\App\Entity\Contract->__get (line 107)
8	App\Entity\Contract->getNumber (line 615)
9	App\Entity\Order->presentAsArray (line 235)
10	App\Controller\Admin\AbstractListController->getPageList (line 141)
11	App\Controller\Admin\OrderController->orderList (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.46 ms
(17.00%)

SELECT o0_.id AS id_0, o0_.brand AS brand_1, o0_.number AS number_2, o0_.date_from AS date_from_3, o0_.date_to AS date_to_4, o0_.formula AS formula_5, o0_.po AS po_6, o0_.status AS status_7, o0_.currency_name AS currency_name_8, o0_.currency_symbol AS currency_symbol_9, o0_.currency_iso_code AS currency_iso_code_10, o0_.tax_value AS tax_value_11, o0_.publicity_tax_cost AS publicity_tax_cost_12, o0_.services_cost AS services_cost_13, o0_.net_cost AS net_cost_14, o0_.tax_cost AS tax_cost_15, o0_.cost AS cost_16, o0_.client_name AS client_name_17, o0_.client_administrator AS client_administrator_18, o0_.client_county_name AS client_county_name_19, o0_.client_registration_number AS client_registration_number_20, o0_.client_publicity_tax_included AS client_publicity_tax_included_21, o0_.supplier_name AS supplier_name_22, o0_.supplier_administrator AS supplier_administrator_23, o0_.supplier_county_name AS supplier_county_name_24, o0_.supplier_registration_number AS supplier_registration_number_25, o0_.contract_number AS contract_number_26, o0_.contract_date AS contract_date_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, o0_.contract_id AS contract_id_30, o0_.user_id AS user_id_31, o0_.responsible_id AS responsible_id_32, o0_.contract_annex_number_id AS contract_annex_number_id_33, o0_.currency_id AS currency_id_34, o0_.tax_id AS tax_id_35 FROM `order` o0_ WHERE o0_.responsible_id = ? AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY o0_.id DESC

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  o0_.id AS id_0,
  o0_.brand AS brand_1,
  o0_.number AS number_2,
  o0_.date_from AS date_from_3,
  o0_.date_to AS date_to_4,
  o0_.formula AS formula_5,
  o0_.po AS po_6,
  o0_.status AS status_7,
  o0_.currency_name AS currency_name_8,
  o0_.currency_symbol AS currency_symbol_9,
  o0_.currency_iso_code AS currency_iso_code_10,
  o0_.tax_value AS tax_value_11,
  o0_.publicity_tax_cost AS publicity_tax_cost_12,
  o0_.services_cost AS services_cost_13,
  o0_.net_cost AS net_cost_14,
  o0_.tax_cost AS tax_cost_15,
  o0_.cost AS cost_16,
  o0_.client_name AS client_name_17,
  o0_.client_administrator AS client_administrator_18,
  o0_.client_county_name AS client_county_name_19,
  o0_.client_registration_number AS client_registration_number_20,
  o0_.client_publicity_tax_included AS client_publicity_tax_included_21,
  o0_.supplier_name AS supplier_name_22,
  o0_.supplier_administrator AS supplier_administrator_23,
  o0_.supplier_county_name AS supplier_county_name_24,
  o0_.supplier_registration_number AS supplier_registration_number_25,
  o0_.contract_number AS contract_number_26,
  o0_.contract_date AS contract_date_27,
  o0_.created_at AS created_at_28,
  o0_.updated_at AS updated_at_29,
  o0_.contract_id AS contract_id_30,
  o0_.user_id AS user_id_31,
  o0_.responsible_id AS responsible_id_32,
  o0_.contract_annex_number_id AS contract_annex_number_id_33,
  o0_.currency_id AS currency_id_34,
  o0_.tax_id AS tax_id_35
FROM
  `order` o0_
WHERE
  o0_.responsible_id = ?
  AND o0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  o0_.id DESC

SELECT o0_.id AS id_0, o0_.brand AS brand_1, o0_.number AS number_2, o0_.date_from AS date_from_3, o0_.date_to AS date_to_4, o0_.formula AS formula_5, o0_.po AS po_6, o0_.status AS status_7, o0_.currency_name AS currency_name_8, o0_.currency_symbol AS currency_symbol_9, o0_.currency_iso_code AS currency_iso_code_10, o0_.tax_value AS tax_value_11, o0_.publicity_tax_cost AS publicity_tax_cost_12, o0_.services_cost AS services_cost_13, o0_.net_cost AS net_cost_14, o0_.tax_cost AS tax_cost_15, o0_.cost AS cost_16, o0_.client_name AS client_name_17, o0_.client_administrator AS client_administrator_18, o0_.client_county_name AS client_county_name_19, o0_.client_registration_number AS client_registration_number_20, o0_.client_publicity_tax_included AS client_publicity_tax_included_21, o0_.supplier_name AS supplier_name_22, o0_.supplier_administrator AS supplier_administrator_23, o0_.supplier_county_name AS supplier_county_name_24, o0_.supplier_registration_number AS supplier_registration_number_25, o0_.contract_number AS contract_number_26, o0_.contract_date AS contract_date_27, o0_.created_at AS created_at_28, o0_.updated_at AS updated_at_29, o0_.contract_id AS contract_id_30, o0_.user_id AS user_id_31, o0_.responsible_id AS responsible_id_32, o0_.contract_annex_number_id AS contract_annex_number_id_33, o0_.currency_id AS currency_id_34, o0_.tax_id AS tax_id_35 FROM `order` o0_ WHERE o0_.responsible_id = 2 AND o0_.id IN (19, 18, 17, 16, 15, 14, 13, 12, 11, 10) ORDER BY o0_.id DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 171)
7	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 71)
8	App\Pagination\Paginator->paginate (line 64)
9	App\Repository\OrderRepository->findPageItems (line 206)
10	App\Controller\Admin\AbstractListController->getPageList (line 141)
11	App\Controller\Admin\OrderController->orderList (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

0.29 ms
(10.54%)

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.roles AS roles_7, t0.show_records_from_others AS show_records_from_others_8 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.full_name AS full_name_2,
  t0.username AS username_3,
  t0.email AS email_4,
  t0.password AS password_5,
  t0.active AS active_6,
  t0.roles AS roles_7,
  t0.show_records_from_others AS show_records_from_others_8
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.active AS active_6, t0.roles AS roles_7, t0.show_records_from_others AS show_records_from_others_8 FROM user t0 WHERE t0.id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 781)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 799)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
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 60)
10	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 80)
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 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.20 ms
(7.45%)

SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.responsible_id = ?

Parameters:

[
  2
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(o0_.id) AS sclr_0
FROM
  `order` o0_
WHERE
  o0_.responsible_id = ?

SELECT count(o0_.id) AS sclr_0 FROM `order` o0_ WHERE o0_.responsible_id = 2;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 943)
6	Doctrine\ORM\AbstractQuery->getScalarResult (line 120)
7	Doctrine\ORM\Tools\Pagination\Paginator->count (line 72)
8	App\Pagination\Paginator->paginate (line 64)
9	App\Repository\OrderRepository->findPageItems (line 206)
10	App\Controller\Admin\AbstractListController->getPageList (line 141)
11	App\Controller\Admin\OrderController->orderList (line 181)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection
audit	doctrine.dbal.audit_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\Order	No errors.
App\Entity\Contract	The field App\Entity\Contract#contractAnnexNumbers is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ContractAnnexNumber#contract does not contain the required 'inversedBy="contractAnnexNumbers"' attribute.
App\Entity\ContractAnnexNumber	No errors.
App\Entity\Currency	No errors.
App\Entity\Tax	No errors.
App\Entity\OrderLine	The mappings App\Entity\OrderLine#orderLineIntervals and App\Entity\OrderLineInterval#orderLine are inconsistent with each other.
App\Entity\Client	No errors.
App\Entity\Supplier	No errors.
App\Entity\Locality	No errors.

Symfony Profiler

GET https://anexe.revoidea.com/admin/order/order-list/ajax/1?_=1764959323830

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping