Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.23 ms Query time

4 Invalid entities

Queries

Group similar statements

#▲

Time

Info

0.45 ms

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:

[
  7
]

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 = 7;

#	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.55 ms

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:

[
  3
]

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 = 3;

#	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\ExtraordinaryJobRepository->createQueryBuilder (line 61)
10	App\Repository\ExtraordinaryJobRepository->get_extraordinary_job_by_id (line 218)
11	App\Service\jobs\JobPaymentService->getJobByType (line 33)
12	App\Service\jobs\JobPaymentService->getJobPayments (line 1205)
13	App\Controller\api\extraordinary_jobs\ApiExtraordinaryJobsController->getPayments (line 178)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 185)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	require_once (line 5)

0.71 ms

SELECT j0_.created_at AS created_at_0, j0_.updated_at AS updated_at_1, j0_.deleted_at AS deleted_at_2, j0_.id AS id_3, j0_.expected_man_hours AS expected_man_hours_4, j0_.price_man_hour AS price_man_hour_5, j0_.job_total_price AS job_total_price_6, j0_.total_advanced_payment AS total_advanced_payment_7, j0_.job_offer_price AS job_offer_price_8, j0_.total_work_price AS total_work_price_9, j0_.name AS name_10, j0_.description AS description_11, j0_.status AS status_12, j0_.offer_number AS offer_number_13, j0_.offer_date AS offer_date_14, j0_.job_total_price_material AS job_total_price_material_15, j0_.priority AS priority_16, j0_.offer_acceptance_date AS offer_acceptance_date_17, j0_.relief_enabled AS relief_enabled_18, j0_.installation_enabled AS installation_enabled_19, j0_.material_enabled AS material_enabled_20, j0_.documentation_enabled AS documentation_enabled_21, j0_.documentation_ready AS documentation_ready_22, j0_.order_ref AS order_ref_23, j0_.type AS type_24, j0_.company_id AS company_id_25, j0_.implant_id AS implant_id_26 FROM job j0_ WHERE (j0_.company_id = ? AND j0_.deleted_at IS NULL AND j0_.id = ?) AND j0_.type IN (1)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.created_at AS created_at_0,
  j0_.updated_at AS updated_at_1,
  j0_.deleted_at AS deleted_at_2,
  j0_.id AS id_3,
  j0_.expected_man_hours AS expected_man_hours_4,
  j0_.price_man_hour AS price_man_hour_5,
  j0_.job_total_price AS job_total_price_6,
  j0_.total_advanced_payment AS total_advanced_payment_7,
  j0_.job_offer_price AS job_offer_price_8,
  j0_.total_work_price AS total_work_price_9,
  j0_.name AS name_10,
  j0_.description AS description_11,
  j0_.status AS status_12,
  j0_.offer_number AS offer_number_13,
  j0_.offer_date AS offer_date_14,
  j0_.job_total_price_material AS job_total_price_material_15,
  j0_.priority AS priority_16,
  j0_.offer_acceptance_date AS offer_acceptance_date_17,
  j0_.relief_enabled AS relief_enabled_18,
  j0_.installation_enabled AS installation_enabled_19,
  j0_.material_enabled AS material_enabled_20,
  j0_.documentation_enabled AS documentation_enabled_21,
  j0_.documentation_ready AS documentation_ready_22,
  j0_.order_ref AS order_ref_23,
  j0_.type AS type_24,
  j0_.company_id AS company_id_25,
  j0_.implant_id AS implant_id_26
FROM
  job j0_
WHERE
  (
    j0_.company_id = ?
    AND j0_.deleted_at IS NULL
    AND j0_.id = ?
  )
  AND j0_.type IN (1)

SELECT j0_.created_at AS created_at_0, j0_.updated_at AS updated_at_1, j0_.deleted_at AS deleted_at_2, j0_.id AS id_3, j0_.expected_man_hours AS expected_man_hours_4, j0_.price_man_hour AS price_man_hour_5, j0_.job_total_price AS job_total_price_6, j0_.total_advanced_payment AS total_advanced_payment_7, j0_.job_offer_price AS job_offer_price_8, j0_.total_work_price AS total_work_price_9, j0_.name AS name_10, j0_.description AS description_11, j0_.status AS status_12, j0_.offer_number AS offer_number_13, j0_.offer_date AS offer_date_14, j0_.job_total_price_material AS job_total_price_material_15, j0_.priority AS priority_16, j0_.offer_acceptance_date AS offer_acceptance_date_17, j0_.relief_enabled AS relief_enabled_18, j0_.installation_enabled AS installation_enabled_19, j0_.material_enabled AS material_enabled_20, j0_.documentation_enabled AS documentation_enabled_21, j0_.documentation_ready AS documentation_ready_22, j0_.order_ref AS order_ref_23, j0_.type AS type_24, j0_.company_id AS company_id_25, j0_.implant_id AS implant_id_26 FROM job j0_ WHERE (j0_.company_id = 3 AND j0_.deleted_at IS NULL AND j0_.id = 278) AND j0_.type IN (1);

#	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 66)
7	App\Repository\ExtraordinaryJobRepository->get_extraordinary_job_by_id (line 218)
8	App\Service\jobs\JobPaymentService->getJobByType (line 33)
9	App\Service\jobs\JobPaymentService->getJobPayments (line 1205)
10	App\Controller\api\extraordinary_jobs\ApiExtraordinaryJobsController->getPayments (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.52 ms

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.payment_id AS payment_id_5, t0.job_id AS job_id_6 FROM coll_job_payment t0 WHERE t0.job_id = ?

Parameters:

[
  278
]

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.payment_id AS payment_id_5,
  t0.job_id AS job_id_6
FROM
  coll_job_payment t0
WHERE
  t0.job_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.payment_id AS payment_id_5, t0.job_id AS job_id_6 FROM coll_job_payment t0 WHERE t0.job_id = 278;

#	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 42)
8	App\Service\jobs\JobPaymentService->getJobPayments (line 1205)
9	App\Controller\api\extraordinary_jobs\ApiExtraordinaryJobsController->getPayments (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)

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\Job	No errors.
App\Entity\ExtraordinaryJob	No errors.
App\Entity\SysCompany	No errors.
App\Entity\Registry	No errors.
App\Entity\SysCompanyAddresses	No errors.
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\WorkOrder	No errors.
App\Entity\OnSiteJob	No errors.
App\Entity\Relief	No errors.
App\Entity\CollJobMaterial	No errors.
App\Entity\CollJobPayment	No errors.
App\Entity\Payment	The field App\Entity\Payment#jobPayments is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CollJobPayment#payment does not contain the required 'inversedBy="jobPayments"' attribute.

Symfony Profiler

POST http://rc.liftapp.it/api/extraordinary_jobs/get_payments

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping