Symfony Profiler

Query Metrics

5 Database Queries

5 Different statements

1.83 ms Query time

0 Invalid entities

9 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.60 ms
(32.96%)

SELECT u0_.id AS id_0, u0_.view_permission AS view_permission_1, u0_.add_permission AS add_permission_2, u0_.edit_permission AS edit_permission_3, u0_.delete_permission AS delete_permission_4, u0_.function_id AS function_id_5, u0_.user_id AS user_id_6 FROM user_permission u0_ LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id WHERE u1_.user_id = ? AND f2_.function_id = ? ORDER BY u0_.id ASC LIMIT 1

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.view_permission AS view_permission_1,
  u0_.add_permission AS add_permission_2,
  u0_.edit_permission AS edit_permission_3,
  u0_.delete_permission AS delete_permission_4,
  u0_.function_id AS function_id_5,
  u0_.user_id AS user_id_6
FROM
  user_permission u0_
  LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id
  LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id
WHERE
  u1_.user_id = ?
  AND f2_.function_id = ?
ORDER BY
  u0_.id ASC
LIMIT
  1

SELECT u0_.id AS id_0, u0_.view_permission AS view_permission_1, u0_.add_permission AS add_permission_2, u0_.edit_permission AS edit_permission_3, u0_.delete_permission AS delete_permission_4, u0_.function_id AS function_id_5, u0_.user_id AS user_id_6 FROM user_permission u0_ LEFT JOIN user u1_ ON u0_.user_id = u1_.user_id LEFT JOIN `function` f2_ ON u0_.function_id = f2_.function_id WHERE u1_.user_id = 6 AND f2_.function_id = 29 ORDER BY u0_.id ASC LIMIT 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 36)
7	App\Repository\PermisoUsuarioRepository->BuscarPermisoUsuario (line 179)
8	App\Service\Admin\AdminAccessService->buscarPermisosMismoBase (line 159)
9	App\Service\Admin\AdminAccessService->primeraFilaPermiso (line 95)
10	App\Service\Admin\AdminAccessService->usuarioPuedeVer (line 57)
11	App\Service\Admin\AdminAccessService->requirePermission (line 48)
12	App\EventSubscriber\RequireAdminPermissionSubscriber->onKernelController (line 115)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 171)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.41 ms
(22.15%)

SELECT t0.user_id AS user_id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.status AS status_7, t0.estimator AS estimator_8, t0.bond AS bond_9, t0.retainage AS retainage_10, t0.chat AS chat_11, t0.final_qty_approver AS final_qty_approver_12, t0.manage_contacts AS manage_contacts_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.player_id AS player_id_16, t0.push_token AS push_token_17, t0.plataforma AS plataforma_18, t0.imagen AS imagen_19, t0.preferred_lang AS preferred_lang_20, t0.sidebar_color AS sidebar_color_21, t0.rol_id AS rol_id_22 FROM user t0 WHERE t0.user_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.user_id AS user_id_1,
  t0.name AS name_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.password AS password_6,
  t0.status AS status_7,
  t0.estimator AS estimator_8,
  t0.bond AS bond_9,
  t0.retainage AS retainage_10,
  t0.chat AS chat_11,
  t0.final_qty_approver AS final_qty_approver_12,
  t0.manage_contacts AS manage_contacts_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.player_id AS player_id_16,
  t0.push_token AS push_token_17,
  t0.plataforma AS plataforma_18,
  t0.imagen AS imagen_19,
  t0.preferred_lang AS preferred_lang_20,
  t0.sidebar_color AS sidebar_color_21,
  t0.rol_id AS rol_id_22
FROM
  user t0
WHERE
  t0.user_id = ?

SELECT t0.user_id AS user_id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.phone AS phone_5, t0.password AS password_6, t0.status AS status_7, t0.estimator AS estimator_8, t0.bond AS bond_9, t0.retainage AS retainage_10, t0.chat AS chat_11, t0.final_qty_approver AS final_qty_approver_12, t0.manage_contacts AS manage_contacts_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.player_id AS player_id_16, t0.push_token AS push_token_17, t0.plataforma AS plataforma_18, t0.imagen AS imagen_19, t0.preferred_lang AS preferred_lang_20, t0.sidebar_color AS sidebar_color_21, t0.rol_id AS rol_id_22 FROM user t0 WHERE t0.user_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 92)
7	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 212)
8	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 129)
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 61)
12	Symfony\Bundle\SecurityBundle\Security\LazyFirewallContext->__invoke (line 91)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 92)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 115)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 206)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 122)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 159)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.36 ms
(19.51%)

SELECT t0.estimate_id AS estimate_id_1, t0.project_id AS project_id_2, t0.name AS name_3, t0.bid_deadline AS bid_deadline_4, t0.county AS county_5, t0.priority AS priority_6, t0.bid_no AS bid_no_7, t0.work_hour AS work_hour_8, t0.phone AS phone_9, t0.email AS email_10, t0.bid_description AS bid_description_11, t0.bid_instructions AS bid_instructions_12, t0.plan_link AS plan_link_13, t0.quote_received AS quote_received_14, t0.job_walk AS job_walk_15, t0.rfi_due_date AS rfi_due_date_16, t0.project_start AS project_start_17, t0.project_end AS project_end_18, t0.submitted_date AS submitted_date_19, t0.awarded_date AS awarded_date_20, t0.lost_date AS lost_date_21, t0.location AS location_22, t0.sector AS sector_23, t0.creation_mode AS creation_mode_24, t0.addon_label AS addon_label_25, t0.modality_description AS modality_description_26, t0.modality_date AS modality_date_27, t0.call_order AS call_order_28, t0.prevailing_wage AS prevailing_wage_29, t0.result AS result_30, t0.result_date AS result_date_31, t0.parent_estimate_id AS parent_estimate_id_32, t0.project_stage_id AS project_stage_id_33, t0.proposal_type_id AS proposal_type_id_34, t0.status_id AS status_id_35, t0.county_id AS county_id_36, t0.city_id AS city_id_37, t0.district_id AS district_id_38, t0.company_id AS company_id_39, t0.contact_id AS contact_id_40, t0.plan_downloading_id AS plan_downloading_id_41 FROM estimate t0 WHERE t0.estimate_id = ?

Parameters:

[
  548
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.estimate_id AS estimate_id_1,
  t0.project_id AS project_id_2,
  t0.name AS name_3,
  t0.bid_deadline AS bid_deadline_4,
  t0.county AS county_5,
  t0.priority AS priority_6,
  t0.bid_no AS bid_no_7,
  t0.work_hour AS work_hour_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.bid_description AS bid_description_11,
  t0.bid_instructions AS bid_instructions_12,
  t0.plan_link AS plan_link_13,
  t0.quote_received AS quote_received_14,
  t0.job_walk AS job_walk_15,
  t0.rfi_due_date AS rfi_due_date_16,
  t0.project_start AS project_start_17,
  t0.project_end AS project_end_18,
  t0.submitted_date AS submitted_date_19,
  t0.awarded_date AS awarded_date_20,
  t0.lost_date AS lost_date_21,
  t0.location AS location_22,
  t0.sector AS sector_23,
  t0.creation_mode AS creation_mode_24,
  t0.addon_label AS addon_label_25,
  t0.modality_description AS modality_description_26,
  t0.modality_date AS modality_date_27,
  t0.call_order AS call_order_28,
  t0.prevailing_wage AS prevailing_wage_29,
  t0.result AS result_30,
  t0.result_date AS result_date_31,
  t0.parent_estimate_id AS parent_estimate_id_32,
  t0.project_stage_id AS project_stage_id_33,
  t0.proposal_type_id AS proposal_type_id_34,
  t0.status_id AS status_id_35,
  t0.county_id AS county_id_36,
  t0.city_id AS city_id_37,
  t0.district_id AS district_id_38,
  t0.company_id AS company_id_39,
  t0.contact_id AS contact_id_40,
  t0.plan_downloading_id AS plan_downloading_id_41
FROM
  estimate t0
WHERE
  t0.estimate_id = ?

SELECT t0.estimate_id AS estimate_id_1, t0.project_id AS project_id_2, t0.name AS name_3, t0.bid_deadline AS bid_deadline_4, t0.county AS county_5, t0.priority AS priority_6, t0.bid_no AS bid_no_7, t0.work_hour AS work_hour_8, t0.phone AS phone_9, t0.email AS email_10, t0.bid_description AS bid_description_11, t0.bid_instructions AS bid_instructions_12, t0.plan_link AS plan_link_13, t0.quote_received AS quote_received_14, t0.job_walk AS job_walk_15, t0.rfi_due_date AS rfi_due_date_16, t0.project_start AS project_start_17, t0.project_end AS project_end_18, t0.submitted_date AS submitted_date_19, t0.awarded_date AS awarded_date_20, t0.lost_date AS lost_date_21, t0.location AS location_22, t0.sector AS sector_23, t0.creation_mode AS creation_mode_24, t0.addon_label AS addon_label_25, t0.modality_description AS modality_description_26, t0.modality_date AS modality_date_27, t0.call_order AS call_order_28, t0.prevailing_wage AS prevailing_wage_29, t0.result AS result_30, t0.result_date AS result_date_31, t0.parent_estimate_id AS parent_estimate_id_32, t0.project_stage_id AS project_stage_id_33, t0.proposal_type_id AS proposal_type_id_34, t0.status_id AS status_id_35, t0.county_id AS county_id_36, t0.city_id AS city_id_37, t0.district_id AS district_id_38, t0.company_id AS company_id_39, t0.contact_id AS contact_id_40, t0.plan_downloading_id AS plan_downloading_id_41 FROM estimate t0 WHERE t0.estimate_id = 548;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\Estimate::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\Estimate->__get (line 255)
8	App\Entity\Estimate->getProposalType (line 498)
9	App\Service\Admin\EstimateService->buildSpreadsheetForQuote (line 774)
10	App\Service\Admin\EstimateService->GenerarPdfQuote (line 957)
11	App\Service\Admin\EstimateService->ExportarExcelQuote (line 920)
12	App\Controller\Admin\EstimateController->exportarExcelQuote (line 183)
13	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
14	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
15	Symfony\Component\HttpKernel\Kernel->handle (line 35)
16	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
17	require_once (line 5)

0.28 ms
(15.37%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.estimate_id AS estimate_id_3 FROM estimate_quote t0 WHERE t0.id = ?

Parameters:

[
  655
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.estimate_id AS estimate_id_3
FROM
  estimate_quote t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.estimate_id AS estimate_id_3 FROM estimate_quote t0 WHERE t0.id = 655;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 362)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 493)
7	App\Service\Admin\EstimateService->buildSpreadsheetForQuote (line 774)
8	App\Service\Admin\EstimateService->GenerarPdfQuote (line 957)
9	App\Service\Admin\EstimateService->ExportarExcelQuote (line 920)
10	App\Controller\Admin\EstimateController->exportarExcelQuote (line 183)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.18 ms
(10.01%)

SELECT t0.type_id AS type_id_1, t0.description AS description_2, t0.status AS status_3 FROM proposal_type t0 WHERE t0.type_id = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.type_id AS type_id_1,
  t0.description AS description_2,
  t0.status AS status_3
FROM
  proposal_type t0
WHERE
  t0.type_id = ?

SELECT t0.type_id AS type_id_1, t0.description AS description_2, t0.status AS status_3 FROM proposal_type t0 WHERE t0.type_id = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 746)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 764)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 270)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 348)
5	Proxies\__CG__\App\Entity\ProposalType::Doctrine\ORM\Proxy\{closure} (line 59)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 146)
7	Proxies\__CG__\App\Entity\ProposalType->__get (line 34)
8	App\Entity\ProposalType->getDescription (line 721)
9	App\Service\Admin\EstimateService->ResolverPlantillaQuote (line 498)
10	App\Service\Admin\EstimateService->buildSpreadsheetForQuote (line 774)
11	App\Service\Admin\EstimateService->GenerarPdfQuote (line 957)
12	App\Service\Admin\EstimateService->ExportarExcelQuote (line 920)
13	App\Controller\Admin\EstimateController->exportarExcelQuote (line 183)
14	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
15	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
16	Symfony\Component\HttpKernel\Kernel->handle (line 35)
17	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
18	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\Usuario	1
App\Entity\Rol	1
App\Entity\PermisoUsuario	1
App\Entity\Funcion	1
App\Entity\EstimateQuote	1
App\Entity\Estimate	1
App\Entity\ProjectStage	1
App\Entity\ProposalType	1
App\Entity\District	1

Entities Mapping

Class	Mapping errors
App\Entity\Usuario	No errors.
App\Entity\Rol	No errors.
App\Entity\PermisoUsuario	No errors.
App\Entity\Funcion	No errors.
App\Entity\EstimateQuote	No errors.
App\Entity\Estimate	No errors.
App\Entity\ProjectStage	No errors.
App\Entity\ProposalType	No errors.
App\Entity\PlanStatus	No errors.
App\Entity\County	No errors.
App\Entity\District	No errors.
App\Entity\Company	No errors.
App\Entity\CompanyContact	No errors.
App\Entity\PlanDownloading	No errors.

Symfony Profiler

POST https://testing.cagconcrete.com/admin/estimate/exportarExcelQuote

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping