Symfony Profiler

Query Metrics

3 Database Queries

3 Different statements

2.61 ms Query time

2 Invalid entities

8 Managed entities

Queries

Group similar statements

#▲

Time

Info

1.49 ms

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.diagnostic_type AS diagnostic_type_4, t0.result AS result_5, t0.estimated_repair_cost AS estimated_repair_cost_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vehicle_id AS vehicle_id_9, t0.customer_id AS customer_id_10, t0.mechanic_id AS mechanic_id_11, t12.id AS id_13, t12.title AS title_14, t12.description AS description_15, t12.status AS status_16, t12.priority AS priority_17, t12.estimated_cost AS estimated_cost_18, t12.actual_cost AS actual_cost_19, t12.estimated_duration AS estimated_duration_20, t12.actual_duration AS actual_duration_21, t12.labor_hours AS labor_hours_22, t12.start_date AS start_date_23, t12.end_date AS end_date_24, t12.labor_cost AS labor_cost_25, t12.notes AS notes_26, t12.created_at AS created_at_27, t12.updated_at AS updated_at_28, t12.current_workflow_step AS current_workflow_step_29, t12.has_workflow AS has_workflow_30, t12.vehicle_id AS vehicle_id_31, t12.customer_id AS customer_id_32, t12.diagnostic_id AS diagnostic_id_33, t12.mechanic_id AS mechanic_id_34, t12.customer_delivery_id AS customer_delivery_id_35 FROM diagnostic t0 LEFT JOIN repair t12 ON t12.diagnostic_id = t0.id ORDER BY t0.created_at DESC

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.diagnostic_type AS diagnostic_type_4,
  t0.result AS result_5,
  t0.estimated_repair_cost AS estimated_repair_cost_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.vehicle_id AS vehicle_id_9,
  t0.customer_id AS customer_id_10,
  t0.mechanic_id AS mechanic_id_11,
  t12.id AS id_13,
  t12.title AS title_14,
  t12.description AS description_15,
  t12.status AS status_16,
  t12.priority AS priority_17,
  t12.estimated_cost AS estimated_cost_18,
  t12.actual_cost AS actual_cost_19,
  t12.estimated_duration AS estimated_duration_20,
  t12.actual_duration AS actual_duration_21,
  t12.labor_hours AS labor_hours_22,
  t12.start_date AS start_date_23,
  t12.end_date AS end_date_24,
  t12.labor_cost AS labor_cost_25,
  t12.notes AS notes_26,
  t12.created_at AS created_at_27,
  t12.updated_at AS updated_at_28,
  t12.current_workflow_step AS current_workflow_step_29,
  t12.has_workflow AS has_workflow_30,
  t12.vehicle_id AS vehicle_id_31,
  t12.customer_id AS customer_id_32,
  t12.diagnostic_id AS diagnostic_id_33,
  t12.mechanic_id AS mechanic_id_34,
  t12.customer_delivery_id AS customer_delivery_id_35
FROM
  diagnostic t0
  LEFT JOIN repair t12 ON t12.diagnostic_id = t0.id
ORDER BY
  t0.created_at DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.diagnostic_type AS diagnostic_type_4, t0.result AS result_5, t0.estimated_repair_cost AS estimated_repair_cost_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vehicle_id AS vehicle_id_9, t0.customer_id AS customer_id_10, t0.mechanic_id AS mechanic_id_11, t12.id AS id_13, t12.title AS title_14, t12.description AS description_15, t12.status AS status_16, t12.priority AS priority_17, t12.estimated_cost AS estimated_cost_18, t12.actual_cost AS actual_cost_19, t12.estimated_duration AS estimated_duration_20, t12.actual_duration AS actual_duration_21, t12.labor_hours AS labor_hours_22, t12.start_date AS start_date_23, t12.end_date AS end_date_24, t12.labor_cost AS labor_cost_25, t12.notes AS notes_26, t12.created_at AS created_at_27, t12.updated_at AS updated_at_28, t12.current_workflow_step AS current_workflow_step_29, t12.has_workflow AS has_workflow_30, t12.vehicle_id AS vehicle_id_31, t12.customer_id AS customer_id_32, t12.diagnostic_id AS diagnostic_id_33, t12.mechanic_id AS mechanic_id_34, t12.customer_delivery_id AS customer_delivery_id_35 FROM diagnostic t0 LEFT JOIN repair t12 ON t12.diagnostic_id = t0.id ORDER BY t0.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 73)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 22)
5	App\Controller\DiagnosticController->index (line 183)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 5)

0.59 ms

SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.completed_at AS completed_at_4, t0.overall_comments AS overall_comments_5, t0.approved AS approved_6, t0.rejection_reason AS rejection_reason_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.repair_id AS repair_id_10, t0.inspector_id AS inspector_id_11 FROM quality_control t0 WHERE t0.repair_id = ?

Parameters:

[
  6
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.status AS status_2,
  t0.started_at AS started_at_3,
  t0.completed_at AS completed_at_4,
  t0.overall_comments AS overall_comments_5,
  t0.approved AS approved_6,
  t0.rejection_reason AS rejection_reason_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.repair_id AS repair_id_10,
  t0.inspector_id AS inspector_id_11
FROM
  quality_control t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.status AS status_2, t0.started_at AS started_at_3, t0.completed_at AS completed_at_4, t0.overall_comments AS overall_comments_5, t0.approved AS approved_6, t0.rejection_reason AS rejection_reason_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.repair_id AS repair_id_10, t0.inspector_id AS inspector_id_11 FROM quality_control t0 WHERE t0.repair_id = 6;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 839)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToOneEntity (line 2457)
4	Doctrine\ORM\UnitOfWork->createEntity (line 268)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->getEntity (line 442)
6	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateRowData (line 147)
7	Doctrine\ORM\Internal\Hydration\ObjectHydrator->hydrateAllData (line 171)
8	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 946)
9	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
10	Doctrine\ORM\EntityRepository->findBy (line 73)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 22)
12	App\Controller\DiagnosticController->index (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.52 ms

SELECT COUNT(d0_.id) AS sclr_0 FROM diagnostic d0_

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(d0_.id) AS sclr_0
FROM
  diagnostic d0_

SELECT COUNT(d0_.id) AS sclr_0 FROM diagnostic d0_;

#	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 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 89)
8	App\Repository\DiagnosticRepository->getStatistics (line 23)
9	App\Controller\DiagnosticController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
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.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Diagnostic	4
App\Entity\Vehicle	1
App\Entity\Customer	1
App\Entity\Repair	1
App\Entity\QualityControl	1

Entities Mapping

Class	Mapping errors
App\Entity\Diagnostic	No errors.
App\Entity\Vehicle	No errors.
App\Entity\Customer	No errors.
App\Entity\Mechanic	No errors.
App\Entity\Repair	The field App\Entity\Repair#customerDelivery is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\CustomerDelivery#repair does not contain the required 'mappedBy: "customerDelivery"' attribute.
App\Entity\CustomerDelivery	The field App\Entity\CustomerDelivery#repair is on the owning side of a bi-directional relationship, but the specified inversedBy association on the target-entity App\Entity\Repair#customerDelivery does not contain the required 'mappedBy: "repair"' attribute.
App\Entity\DiagnosticIssue	No errors.
App\Entity\VehiclePhoto	No errors.
App\Entity\RepairPart	No errors.
App\Entity\RepairService	No errors.
App\Entity\RepairPhoto	No errors.
App\Entity\Invoice	No errors.
App\Entity\QualityControl	No errors.
App\Entity\QualityControlTest	No errors.
App\Entity\WorkflowStep	No errors.

Symfony Profiler

GET https://garage.farahtech.ma/diagnostic/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping