Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

3.58 ms Query time

6 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.45 ms
(40.58%)

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.measurement_unit AS measurement_unit_5, m0_.conformity_declaration AS conformity_declaration_6, m0_.internal_code AS internal_code_7, m0_.company_id AS company_id_8 FROM material m0_ WHERE m0_.company_id = ? AND m0_.deleted_at IS NULL AND m0_.id = ?

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  m0_.created_at AS created_at_0,
  m0_.updated_at AS updated_at_1,
  m0_.deleted_at AS deleted_at_2,
  m0_.id AS id_3,
  m0_.name AS name_4,
  m0_.measurement_unit AS measurement_unit_5,
  m0_.conformity_declaration AS conformity_declaration_6,
  m0_.internal_code AS internal_code_7,
  m0_.company_id AS company_id_8
FROM
  material m0_
WHERE
  m0_.company_id = ?
  AND m0_.deleted_at IS NULL
  AND m0_.id = ?

SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.deleted_at AS deleted_at_2, m0_.id AS id_3, m0_.name AS name_4, m0_.measurement_unit AS measurement_unit_5, m0_.conformity_declaration AS conformity_declaration_6, m0_.internal_code AS internal_code_7, m0_.company_id AS company_id_8 FROM material m0_ WHERE m0_.company_id = 4 AND m0_.deleted_at IS NULL AND m0_.id = 311;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 49)
7	App\Repository\MaterialRepository->get_material_by_id (line 149)
8	App\Service\material\MaterialService->getMaterialSuppliers (line 197)
9	App\Controller\api\ApiMaterialsController->getMaterialSuppliers (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.67 ms
(18.60%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.email AS email_5,
  t0.roles AS roles_6,
  t0.username AS username_7,
  t0.password AS password_8,
  t0.last_access AS last_access_9
FROM
  sys_user t0
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.email AS email_5, t0.roles AS roles_6, t0.username AS username_7, t0.password AS password_8, t0.last_access AS last_access_9 FROM sys_user t0 WHERE t0.id = 6;

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

0.51 ms
(14.22%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.price AS price_5, t0.minimum_order AS minimum_order_6, t0.currency AS currency_7, t0.material_supplier_code AS material_supplier_code_8, t0.material_id AS material_id_9, t0.supplier_id AS supplier_id_10 FROM coll_material_supplier t0 WHERE t0.material_id = ?

Parameters:

[
  311
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.price AS price_5,
  t0.minimum_order AS minimum_order_6,
  t0.currency AS currency_7,
  t0.material_supplier_code AS material_supplier_code_8,
  t0.material_id AS material_id_9,
  t0.supplier_id AS supplier_id_10
FROM
  coll_material_supplier t0
WHERE
  t0.material_id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.price AS price_5, t0.minimum_order AS minimum_order_6, t0.currency AS currency_7, t0.material_supplier_code AS material_supplier_code_8, t0.material_id AS material_id_9, t0.supplier_id AS supplier_id_10 FROM coll_material_supplier t0 WHERE t0.material_id = 311;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 154)
8	App\Service\material\MaterialService->getMaterialSuppliers (line 197)
9	App\Controller\api\ApiMaterialsController->getMaterialSuppliers (line 178)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.49 ms
(13.61%)

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.notes AS notes_18, t0.company_id AS company_id_19, t0.type FROM registry t0 WHERE t0.id = ? AND t0.type IN ('4')

Parameters:

[
  540
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.name AS name_5,
  t0.cf AS cf_6,
  t0.role AS role_7,
  t0.road AS road_8,
  t0.house_number AS house_number_9,
  t0.city AS city_10,
  t0.cap AS cap_11,
  t0.province AS province_12,
  t0.email AS email_13,
  t0.telephone AS telephone_14,
  t0.cellphone AS cellphone_15,
  t0.p_iva AS p_iva_16,
  t0.state AS state_17,
  t0.notes AS notes_18,
  t0.company_id AS company_id_19,
  t0.type
FROM
  registry t0
WHERE
  t0.id = ?
  AND t0.type IN ('4')

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.name AS name_5, t0.cf AS cf_6, t0.role AS role_7, t0.road AS road_8, t0.house_number AS house_number_9, t0.city AS city_10, t0.cap AS cap_11, t0.province AS province_12, t0.email AS email_13, t0.telephone AS telephone_14, t0.cellphone AS cellphone_15, t0.p_iva AS p_iva_16, t0.state AS state_17, t0.notes AS notes_18, t0.company_id AS company_id_19, t0.type FROM registry t0 WHERE t0.id = 540 AND t0.type IN ('4');

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 220)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 286)
5	Proxies\__CG__\App\Entity\Supplier::Doctrine\ORM\Proxy\{closure} (line 61)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 120)
7	Proxies\__CG__\App\Entity\Supplier->__get (line 98)
8	App\Entity\Registry->getName (line 157)
9	App\Service\material\MaterialService->getMaterialSuppliers (line 197)
10	App\Controller\api\ApiMaterialsController->getMaterialSuppliers (line 178)
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.47 ms
(12.99%)

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  s0_.created_at AS created_at_0,
  s0_.updated_at AS updated_at_1,
  s0_.deleted_at AS deleted_at_2,
  s0_.id AS id_3,
  s0_.name AS name_4,
  s0_.road AS road_5,
  s0_.house_number AS house_number_6,
  s0_.city AS city_7,
  s0_.cap AS cap_8,
  s0_.province AS province_9,
  s0_.state AS state_10,
  s0_.country AS country_11,
  s0_.company_type AS company_type_12,
  s0_.phone AS phone_13,
  s0_.mail AS mail_14
FROM
  sys_company s0_
WHERE
  s0_.id = ?

SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.deleted_at AS deleted_at_2, s0_.id AS id_3, s0_.name AS name_4, s0_.road AS road_5, s0_.house_number AS house_number_6, s0_.city AS city_7, s0_.cap AS cap_8, s0_.province AS province_9, s0_.state AS state_10, s0_.country AS country_11, s0_.company_type AS company_type_12, s0_.phone AS phone_13, s0_.mail AS mail_14 FROM sys_company s0_ WHERE s0_.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 738)
6	Doctrine\ORM\AbstractQuery->getOneOrNullResult (line 26)
7	App\Repository\SysCompanyRepository->get_company_by_id (line 45)
8	App\Service\CompanySessionService->getCompanyObject (line 25)
9	App\Repository\MaterialRepository->createQueryBuilder (line 44)
10	App\Repository\MaterialRepository->get_material_by_id (line 149)
11	App\Service\material\MaterialService->getMaterialSuppliers (line 197)
12	App\Controller\api\ApiMaterialsController->getMaterialSuppliers (line 178)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	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\BaseEntity	No errors.
App\Entity\SysUser	The mappings App\Entity\SysUser#sysRoles and App\Entity\CollSysUserSysCompany#user are inconsistent with each other.
App\Entity\CollSysUserSysCompany	The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which is not defined as association. The association App\Entity\CollSysUserSysCompany#user refers to the inverse side field App\Entity\SysUser#roles which does not exist.
App\Entity\Material	No errors.
App\Entity\SysCompany	No errors.
App\Entity\Registry	No errors.
App\Entity\SysCompanyAddresses	No errors.
App\Entity\CollMaterialSupplier	No errors.
App\Entity\CollJobMaterial	No errors.
App\Entity\OrderItem	The field 'App\Entity\OrderItem#quantity' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\OrderItem#unitPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\OrderItem#vatPercentage' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\OrderItem#unitPriceWithVat' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\OrderItem#totalPriceNet' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field 'App\Entity\OrderItem#totalPriceGross' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Supplier	The field App\Entity\Supplier#jobMaterials is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollJobMaterial#supplier does not contain the required 'inversedBy="jobMaterials"' attribute. The field App\Entity\Supplier#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#supplier does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Implant	The field App\Entity\Implant#jobs is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Job#implant does not contain the required 'inversedBy="jobs"' attribute.
App\Entity\Order	The field 'App\Entity\Order#totalAmount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Order#jobMaterials is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollJobMaterial#order does not contain the required 'inversedBy="jobMaterials"' attribute.

Symfony Profiler

POST http://rc.liftapp.it/api/materials/get_material_supplier

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping