Symfony Profiler

Query Metrics

9 Database Queries

8 Different statements

7.19 ms Query time

2 Invalid entities

4 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.94 ms
(26.97%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.priority AS priority_5, t0.estimated_cost AS estimated_cost_6, t0.actual_cost AS actual_cost_7, t0.estimated_duration AS estimated_duration_8, t0.actual_duration AS actual_duration_9, t0.labor_hours AS labor_hours_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.labor_cost AS labor_cost_13, t0.notes AS notes_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.current_workflow_step AS current_workflow_step_17, t0.has_workflow AS has_workflow_18, t0.vehicle_id AS vehicle_id_19, t0.customer_id AS customer_id_20, t21.id AS id_22, t21.status AS status_23, t21.started_at AS started_at_24, t21.completed_at AS completed_at_25, t21.overall_comments AS overall_comments_26, t21.approved AS approved_27, t21.rejection_reason AS rejection_reason_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30, t21.repair_id AS repair_id_31, t21.inspector_id AS inspector_id_32, t0.diagnostic_id AS diagnostic_id_33, t0.mechanic_id AS mechanic_id_34, t0.customer_delivery_id AS customer_delivery_id_35 FROM repair t0 LEFT JOIN quality_control t21 ON t21.repair_id = t0.id WHERE t0.id = ?

Parameters:

[
  "4"
]

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.status AS status_4,
  t0.priority AS priority_5,
  t0.estimated_cost AS estimated_cost_6,
  t0.actual_cost AS actual_cost_7,
  t0.estimated_duration AS estimated_duration_8,
  t0.actual_duration AS actual_duration_9,
  t0.labor_hours AS labor_hours_10,
  t0.start_date AS start_date_11,
  t0.end_date AS end_date_12,
  t0.labor_cost AS labor_cost_13,
  t0.notes AS notes_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.current_workflow_step AS current_workflow_step_17,
  t0.has_workflow AS has_workflow_18,
  t0.vehicle_id AS vehicle_id_19,
  t0.customer_id AS customer_id_20,
  t21.id AS id_22,
  t21.status AS status_23,
  t21.started_at AS started_at_24,
  t21.completed_at AS completed_at_25,
  t21.overall_comments AS overall_comments_26,
  t21.approved AS approved_27,
  t21.rejection_reason AS rejection_reason_28,
  t21.created_at AS created_at_29,
  t21.updated_at AS updated_at_30,
  t21.repair_id AS repair_id_31,
  t21.inspector_id AS inspector_id_32,
  t0.diagnostic_id AS diagnostic_id_33,
  t0.mechanic_id AS mechanic_id_34,
  t0.customer_delivery_id AS customer_delivery_id_35
FROM
  repair t0
  LEFT JOIN quality_control t21 ON t21.repair_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.status AS status_4, t0.priority AS priority_5, t0.estimated_cost AS estimated_cost_6, t0.actual_cost AS actual_cost_7, t0.estimated_duration AS estimated_duration_8, t0.actual_duration AS actual_duration_9, t0.labor_hours AS labor_hours_10, t0.start_date AS start_date_11, t0.end_date AS end_date_12, t0.labor_cost AS labor_cost_13, t0.notes AS notes_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.current_workflow_step AS current_workflow_step_17, t0.has_workflow AS has_workflow_18, t0.vehicle_id AS vehicle_id_19, t0.customer_id AS customer_id_20, t21.id AS id_22, t21.status AS status_23, t21.started_at AS started_at_24, t21.completed_at AS completed_at_25, t21.overall_comments AS overall_comments_26, t21.approved AS approved_27, t21.rejection_reason AS rejection_reason_28, t21.created_at AS created_at_29, t21.updated_at AS updated_at_30, t21.repair_id AS repair_id_31, t21.inspector_id AS inspector_id_32, t0.diagnostic_id AS diagnostic_id_33, t0.mechanic_id AS mechanic_id_34, t0.customer_delivery_id AS customer_delivery_id_35 FROM repair t0 LEFT JOIN quality_control t21 ON t21.repair_id = t0.id WHERE t0.id = '4';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 366)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 61)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 129)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 69)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 37)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 33)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 175)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 5)

1.52 ms
(21.18%)

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price AS unit_price_3, t0.total_price AS total_price_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.repair_id AS repair_id_8, t0.article_id AS article_id_9 FROM repair_part t0 WHERE t0.repair_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.unit_price AS unit_price_3,
  t0.total_price AS total_price_4,
  t0.notes AS notes_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.repair_id AS repair_id_8,
  t0.article_id AS article_id_9
FROM
  repair_part t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.unit_price AS unit_price_3, t0.total_price AS total_price_4, t0.notes AS notes_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.repair_id AS repair_id_8, t0.article_id AS article_id_9 FROM repair_part t0 WHERE t0.repair_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 942)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 235)
4	Doctrine\ORM\EntityRepository->resolveMagicCall (line 154)
5	Doctrine\ORM\EntityRepository->__call (line 95)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->__call (line 111)
7	App\Controller\RepairController->show (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.27 ms
(17.62%)

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.unit_price AS unit_price_3, r0_.quantity AS quantity_4, r0_.total_price AS total_price_5, r0_.category AS category_6, r0_.notes AS notes_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.repair_id AS repair_id_10 FROM repair_service r0_ WHERE r0_.repair_id = ? ORDER BY r0_.created_at ASC

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.description AS description_2,
  r0_.unit_price AS unit_price_3,
  r0_.quantity AS quantity_4,
  r0_.total_price AS total_price_5,
  r0_.category AS category_6,
  r0_.notes AS notes_7,
  r0_.created_at AS created_at_8,
  r0_.updated_at AS updated_at_9,
  r0_.repair_id AS repair_id_10
FROM
  repair_service r0_
WHERE
  r0_.repair_id = ?
ORDER BY
  r0_.created_at ASC

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.description AS description_2, r0_.unit_price AS unit_price_3, r0_.quantity AS quantity_4, r0_.total_price AS total_price_5, r0_.category AS category_6, r0_.notes AS notes_7, r0_.created_at AS created_at_8, r0_.updated_at AS updated_at_9, r0_.repair_id AS repair_id_10 FROM repair_service r0_ WHERE r0_.repair_id = 4 ORDER BY r0_.created_at ASC;

#	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 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 47)
7	App\Repository\RepairServiceRepository->findByRepair (line 110)
8	App\Controller\RepairController->show (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.59 ms
(8.26%)

SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.garage AS garage_2,
  t0.currency AS currency_3,
  t0.date_format AS date_format_4,
  t0.time_format AS time_format_5,
  t0.notifications AS notifications_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.logo AS logo_9
FROM
  app_settings t0
LIMIT
  1

SELECT t0.id AS id_1, t0.garage AS garage_2, t0.currency AS currency_3, t0.date_format AS date_format_4, t0.time_format AS time_format_5, t0.notifications AS notifications_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.logo AS logo_9 FROM app_settings t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 81)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 25)
5	App\Service\SettingsService->getSettings (line 99)
6	App\Service\SettingsService->getCurrency (line 104)
7	App\Service\SettingsService->getCurrencySymbol (line 71)
8	App\Twig\SettingsExtension->getCurrencySymbol (line 73)
9	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
10	Twig\Template->yield (line 54)
11	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->doDisplay (line 402)
12	Twig\Template->yield (line 358)
13	Twig\Template->display (line 373)
14	Twig\Template->render (line 51)
15	Twig\TemplateWrapper->render (line 333)
16	Twig\Environment->render (line 459)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
20	App\Controller\RepairController->show (line 183)
21	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
22	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
23	Symfony\Component\HttpKernel\Kernel->handle (line 35)
24	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
25	require_once (line 5)

0.57 ms
(7.87%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.nature AS nature_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM customer t0 WHERE t0.id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.address AS address_6,
  t0.city AS city_7,
  t0.postal_code AS postal_code_8,
  t0.nature AS nature_9,
  t0.notes AS notes_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12
FROM
  customer t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.address AS address_6, t0.city AS city_7, t0.postal_code AS postal_code_8, t0.nature AS nature_9, t0.notes AS notes_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM customer t0 WHERE t0.id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Customer::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Customer->__get (line 100)
8	App\Entity\Customer->getFirstName (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 328)
10	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->block_body (line 446)
11	Twig\Template->yieldBlock (line 177)
12	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
23	App\Controller\RepairController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.56 ms
(7.81%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit_price AS unit_price_4, t0.quantity AS quantity_5, t0.total_price AS total_price_6, t0.category AS category_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.repair_id AS repair_id_11 FROM repair_service t0 WHERE t0.repair_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.unit_price AS unit_price_4,
  t0.quantity AS quantity_5,
  t0.total_price AS total_price_6,
  t0.category AS category_7,
  t0.notes AS notes_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.repair_id AS repair_id_11
FROM
  repair_service t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.unit_price AS unit_price_4, t0.quantity AS quantity_5, t0.total_price AS total_price_6, t0.category AS category_7, t0.notes AS notes_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.repair_id AS repair_id_11 FROM repair_service t0 WHERE t0.repair_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 313)
7	Doctrine\Common\Collections\AbstractLazyCollection->getIterator (line 576)
8	App\Entity\Repair->getServicesCost (line 587)
9	App\Entity\Repair->getTotalCost (line 115)
10	App\Controller\RepairController->show (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.41 ms
(5.67%)

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.license_plate AS license_plate_5, t0.registration_number AS registration_number_6, t0.vin AS vin_7, t0.mileage AS mileage_8, t0.fuel_type AS fuel_type_9, t0.color AS color_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.customer_id AS customer_id_14 FROM vehicle t0 WHERE t0.id = ?

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.brand AS brand_2,
  t0.model AS model_3,
  t0.year AS year_4,
  t0.license_plate AS license_plate_5,
  t0.registration_number AS registration_number_6,
  t0.vin AS vin_7,
  t0.mileage AS mileage_8,
  t0.fuel_type AS fuel_type_9,
  t0.color AS color_10,
  t0.notes AS notes_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.customer_id AS customer_id_14
FROM
  vehicle t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand AS brand_2, t0.model AS model_3, t0.year AS year_4, t0.license_plate AS license_plate_5, t0.registration_number AS registration_number_6, t0.vin AS vin_7, t0.mileage AS mileage_8, t0.fuel_type AS fuel_type_9, t0.color AS color_10, t0.notes AS notes_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.customer_id AS customer_id_14 FROM vehicle t0 WHERE t0.id = 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 740)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 758)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 289)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 367)
5	Proxies\__CG__\App\Entity\Vehicle::Doctrine\ORM\Proxy\{closure} (line 60)
6	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 153)
7	Proxies\__CG__\App\Entity\Vehicle->__get (line 118)
8	App\Entity\Vehicle->getBrand (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 337)
10	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->block_body (line 446)
11	Twig\Template->yieldBlock (line 177)
12	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
23	App\Controller\RepairController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 5)

0.33 ms
(4.62%)

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.stage AS stage_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.repair_id AS repair_id_9 FROM repair_photo t0 WHERE t0.repair_id = ?

Parameters:

[
  4
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.stage AS stage_3,
  t0.description AS description_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.file_size AS file_size_7,
  t0.mime_type AS mime_type_8,
  t0.repair_id AS repair_id_9
FROM
  repair_photo t0
WHERE
  t0.repair_id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.stage AS stage_3, t0.description AS description_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.file_size AS file_size_7, t0.mime_type AS mime_type_8, t0.repair_id AS repair_id_9 FROM repair_photo t0 WHERE t0.repair_id = 4;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1845)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1790)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2722)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 636)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 237)
7	Doctrine\Common\Collections\AbstractLazyCollection->filter (line 817)
8	App\Entity\Repair->getPhotosByStage (line 1909)
9	Twig\Extension\CoreExtension::getAttribute (line 721)
10	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->block_body (line 446)
11	Twig\Template->yieldBlock (line 177)
12	__TwigTemplate_4a4c28ab13324a70cd0cca486178722d->doDisplay (line 402)
13	Twig\Template->yield (line 54)
14	__TwigTemplate_38104333089bfd185bc56fff93d4f38d->doDisplay (line 402)
15	Twig\Template->yield (line 358)
16	Twig\Template->display (line 373)
17	Twig\Template->render (line 51)
18	Twig\TemplateWrapper->render (line 333)
19	Twig\Environment->render (line 459)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 464)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 278)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 123)
23	App\Controller\RepairController->show (line 183)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	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\Repair	1
App\Entity\Vehicle	1
App\Entity\Customer	1
App\Entity\AppSettings	1

Entities Mapping

Class	Mapping 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\Vehicle	No errors.
App\Entity\Customer	No errors.
App\Entity\QualityControl	No errors.
App\Entity\Mechanic	No errors.
App\Entity\Diagnostic	No errors.
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\RepairPart	No errors.
App\Entity\RepairService	No errors.
App\Entity\RepairPhoto	No errors.
App\Entity\Invoice	No errors.
App\Entity\WorkflowStep	No errors.
App\Entity\Article	No errors.
App\Entity\AppSettings	No errors.
App\Entity\Appointment	No errors.
App\Entity\Quote	No errors.
App\Entity\VehiclePhoto	No errors.

Symfony Profiler

GET https://garage.farahtech.ma/repair/4

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping