Symfony Profiler

Query Metrics

18 Database Queries

7 Different statements

6.45 ms Query time

10 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.74 ms
(42.53%)

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.site_name AS site_name_2,
  t0.site_name_ar AS site_name_ar_3,
  t0.description AS description_4,
  t0.description_ar AS description_ar_5,
  t0.favicon AS favicon_6,
  t0.logo AS logo_7,
  t0.logo_ar AS logo_ar_8,
  t0.header_tag AS header_tag_9,
  t0.header_tag_ar AS header_tag_ar_10,
  t0.copyright AS copyright_11,
  t0.copyright_ar AS copyright_ar_12,
  t0.social_link AS social_link_13,
  t0.contact_details AS contact_details_14,
  t0.meal_calories_approx AS meal_calories_approx_15,
  t0.earning_percentage AS earning_percentage_16,
  t0.earning_percentage_expert AS earning_percentage_expert_17,
  t0.earning_percentage_restaurant AS earning_percentage_restaurant_18,
  t0.account_approval_method AS account_approval_method_19,
  t0.favicon_ar AS favicon_ar_20,
  t0.contact_us_image AS contact_us_image_21,
  t0.max_delivery_distance AS max_delivery_distance_22,
  t0.cancel_duration_allowance AS cancel_duration_allowance_23,
  t0.program_commission AS program_commission_24,
  t0.restaurant_commission AS restaurant_commission_25,
  t0.platform_administrative_commission AS platform_administrative_commission_26
FROM
  setting t0
LIMIT
  1

SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_name_ar AS site_name_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.favicon AS favicon_6, t0.logo AS logo_7, t0.logo_ar AS logo_ar_8, t0.header_tag AS header_tag_9, t0.header_tag_ar AS header_tag_ar_10, t0.copyright AS copyright_11, t0.copyright_ar AS copyright_ar_12, t0.social_link AS social_link_13, t0.contact_details AS contact_details_14, t0.meal_calories_approx AS meal_calories_approx_15, t0.earning_percentage AS earning_percentage_16, t0.earning_percentage_expert AS earning_percentage_expert_17, t0.earning_percentage_restaurant AS earning_percentage_restaurant_18, t0.account_approval_method AS account_approval_method_19, t0.favicon_ar AS favicon_ar_20, t0.contact_us_image AS contact_us_image_21, t0.max_delivery_distance AS max_delivery_distance_22, t0.cancel_duration_allowance AS cancel_duration_allowance_23, t0.program_commission AS program_commission_24, t0.restaurant_commission AS restaurant_commission_25, t0.platform_administrative_commission AS platform_administrative_commission_26 FROM setting t0 LIMIT 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 734)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 125)
3	Doctrine\ORM\EntityRepository->findOneBy (line 80)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findOneBy (line 209)
5	App\Twig\AppExtension->getSettings (line 285)
6	__TwigTemplate_cb8b11b0deae1c6f739671b4ce97cea4->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 50)
9	__TwigTemplate_34e894e0c6c92b9abd847c3c75e859c6->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 379)
12	Twig\Template->render (line 38)
13	Twig\TemplateWrapper->render (line 280)
14	Twig\Environment->render (line 448)
15	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
16	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
17	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 183)
18	App\Controller\ProgramController->show (line 181)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 6)

0.98 ms
(15.20%)

SELECT t0.id AS id_1, t0.slot_number AS slot_number_2, t0.notes AS notes_3, t0.average_calories AS average_calories_4, t0.average_protein AS average_protein_5, t0.average_carbs AS average_carbs_6, t0.average_fat AS average_fat_7, t0.program_id AS program_id_8, t0.meal_category_id AS meal_category_id_9 FROM program_daily_meals t0 WHERE t0.program_id = ?

Parameters:

[
  123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.slot_number AS slot_number_2,
  t0.notes AS notes_3,
  t0.average_calories AS average_calories_4,
  t0.average_protein AS average_protein_5,
  t0.average_carbs AS average_carbs_6,
  t0.average_fat AS average_fat_7,
  t0.program_id AS program_id_8,
  t0.meal_category_id AS meal_category_id_9
FROM
  program_daily_meals t0
WHERE
  t0.program_id = ?

SELECT t0.id AS id_1, t0.slot_number AS slot_number_2, t0.notes AS notes_3, t0.average_calories AS average_calories_4, t0.average_protein AS average_protein_5, t0.average_carbs AS average_carbs_6, t0.average_fat AS average_fat_7, t0.program_id AS program_id_8, t0.meal_category_id AS meal_category_id_9 FROM program_daily_meals t0 WHERE t0.program_id = 123;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1803)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1748)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2708)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 627)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 396)
8	Doctrine\ORM\PersistentCollection->count (line 146)
9	App\Controller\ProgramController->show (line 181)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 6)

0.67 ms
(10.43%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_ar AS title_ar_3,
  t0.description AS description_4,
  t0.description_ar AS description_ar_5,
  t0.content AS content_6,
  t0.type AS type_7,
  t0.content_ar AS content_ar_8,
  t0.for_role AS for_role_9,
  t0.video AS video_10,
  t0.video_ar AS video_ar_11
FROM
  PAGE t0
WHERE
  t0.for_role IS NULL

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.description AS description_4, t0.description_ar AS description_ar_5, t0.content AS content_6, t0.type AS type_7, t0.content_ar AS content_ar_8, t0.for_role AS for_role_9, t0.video AS video_10, t0.video_ar AS video_ar_11 FROM PAGE t0 WHERE t0.for_role IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 153)
5	App\Twig\AppExtension->getAllPages (line 53)
6	__TwigTemplate_0e686f75d36b02abf41aec87b59ad325->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_cb8b11b0deae1c6f739671b4ce97cea4->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 50)
12	__TwigTemplate_34e894e0c6c92b9abd847c3c75e859c6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 183)
21	App\Controller\ProgramController->show (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 6)

0.62 ms
(9.57%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = ?

Parameters:

[
  "USD"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.minor_units AS minor_units_3,
  t0.symbol AS symbol_4,
  t0.active AS active_5
FROM
  currencies t0
WHERE
  t0.code = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0 WHERE t0.code = 'USD';

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 40)
6	App\Helper\CurrencyPriceHelper->getCurrentCurrency (line 87)
7	App\Helper\CurrencyPriceHelper->getCurrentCurrencyCode (line 75)
8	App\Controller\ProgramController->__construct (line 24)
9	ContainerL2JyHMW\getProgramController3Service::do (line 651)
10	ContainerL2JyHMW\App_KernelDevDebugContainer->load (line 229)
11	Symfony\Component\DependencyInjection\Container::make (line 211)
12	Symfony\Component\DependencyInjection\Container->get (line 40)
13	Symfony\Component\HttpKernel\Controller\ContainerControllerResolver->instantiateController (line 26)
14	Symfony\Bundle\FrameworkBundle\Controller\ControllerResolver->instantiateController (line 128)
15	Symfony\Component\HttpKernel\Controller\ControllerResolver->createController (line 96)
16	Symfony\Component\HttpKernel\Controller\ControllerResolver->getController (line 36)
17	Symfony\Component\HttpKernel\Controller\TraceableControllerResolver->getController (line 164)
18	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
19	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
20	Symfony\Component\HttpKernel\Kernel->handle (line 35)
21	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
22	require_once (line 6)

0.58 ms
(8.96%)

SELECT t0.id AS id_1, t0.interval_name AS interval_name_2, t0.unit_amount_minor AS unit_amount_minor_3, t0.program_id AS program_id_4, t0.price_list_id AS price_list_id_5 FROM program_prices t0 WHERE t0.program_id IN (?)

Parameters:

[
  123
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.interval_name AS interval_name_2,
  t0.unit_amount_minor AS unit_amount_minor_3,
  t0.program_id AS program_id_4,
  t0.price_list_id AS price_list_id_5
FROM
  program_prices t0
WHERE
  t0.program_id IN (?)

SELECT t0.id AS id_1, t0.interval_name AS interval_name_2, t0.unit_amount_minor AS unit_amount_minor_3, t0.program_id AS program_id_4, t0.price_list_id AS price_list_id_5 FROM program_prices t0 WHERE t0.program_id IN (123);

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 2656)
3	Doctrine\ORM\UnitOfWork->eagerLoadCollections (line 2632)
4	Doctrine\ORM\UnitOfWork->triggerEagerLoads (line 62)
5	Doctrine\ORM\Internal\Hydration\SimpleObjectHydrator->hydrateAllData (line 166)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 742)
7	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 752)
8	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 357)
9	Doctrine\ORM\EntityManager->find (line 86)
10	Doctrine\ORM\EntityRepository->find (line 60)
11	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
12	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
13	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
14	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
15	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
16	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 6)

0.50 ms
(7.71%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.short_description AS short_description_4, t0.short_description_ar AS short_description_ar_5, t0.description AS description_6, t0.description_ar AS description_ar_7, t0.meta_description AS meta_description_8, t0.meta_description_ar AS meta_description_ar_9, t0.age_from AS age_from_10, t0.age_to AS age_to_11, t0.ideal_gender AS ideal_gender_12, t0.period_months AS period_months_13, t0.image AS image_14, t0.status AS status_15, t0.daily_target_calories AS daily_target_calories_16, t0.daily_target_carbs AS daily_target_carbs_17, t0.daily_target_fat AS daily_target_fat_18, t0.daily_target_protein AS daily_target_protein_19, t0.is_featured AS is_featured_20, t0.published_at AS published_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24 FROM program t0 WHERE t0.id = ?

Parameters:

[
  "123"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_ar AS title_ar_3,
  t0.short_description AS short_description_4,
  t0.short_description_ar AS short_description_ar_5,
  t0.description AS description_6,
  t0.description_ar AS description_ar_7,
  t0.meta_description AS meta_description_8,
  t0.meta_description_ar AS meta_description_ar_9,
  t0.age_from AS age_from_10,
  t0.age_to AS age_to_11,
  t0.ideal_gender AS ideal_gender_12,
  t0.period_months AS period_months_13,
  t0.image AS image_14,
  t0.status AS status_15,
  t0.daily_target_calories AS daily_target_calories_16,
  t0.daily_target_carbs AS daily_target_carbs_17,
  t0.daily_target_fat AS daily_target_fat_18,
  t0.daily_target_protein AS daily_target_protein_19,
  t0.is_featured AS is_featured_20,
  t0.published_at AS published_at_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.created_by_id AS created_by_id_24
FROM
  program t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.short_description AS short_description_4, t0.short_description_ar AS short_description_ar_5, t0.description AS description_6, t0.description_ar AS description_ar_7, t0.meta_description AS meta_description_8, t0.meta_description_ar AS meta_description_ar_9, t0.age_from AS age_from_10, t0.age_to AS age_to_11, t0.ideal_gender AS ideal_gender_12, t0.period_months AS period_months_13, t0.image AS image_14, t0.status AS status_15, t0.daily_target_calories AS daily_target_calories_16, t0.daily_target_carbs AS daily_target_carbs_17, t0.daily_target_fat AS daily_target_fat_18, t0.daily_target_protein AS daily_target_protein_19, t0.is_featured AS is_featured_20, t0.published_at AS published_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.created_by_id AS created_by_id_24 FROM program t0 WHERE t0.id = '123';

#	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 357)
4	Doctrine\ORM\EntityManager->find (line 86)
5	Doctrine\ORM\EntityRepository->find (line 60)
6	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->find (line 116)
7	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->find (line 63)
8	Symfony\Bridge\Doctrine\ArgumentResolver\EntityValueResolver->resolve (line 60)
9	Symfony\Component\HttpKernel\Controller\ArgumentResolver\TraceableValueResolver->resolve (line 91)
10	Symfony\Component\HttpKernel\Controller\ArgumentResolver->getArguments (line 40)
11	Symfony\Component\HttpKernel\Controller\TraceableArgumentResolver->getArguments (line 173)
12	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
13	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
14	Symfony\Component\HttpKernel\Kernel->handle (line 35)
15	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
16	require_once (line 6)

0.36 ms
(5.60%)

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.minor_units AS minor_units_3,
  t0.symbol AS symbol_4,
  t0.active AS active_5
FROM
  currencies t0

SELECT t0.code AS code_1, t0.name AS name_2, t0.minor_units AS minor_units_3, t0.symbol AS symbol_4, t0.active AS active_5 FROM currencies t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 908)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 110)
3	Doctrine\ORM\EntityRepository->findBy (line 96)
4	Doctrine\ORM\EntityRepository->findAll (line 246)
5	App\Twig\AppExtension->getAllCurrencies (line 117)
6	__TwigTemplate_0e686f75d36b02abf41aec87b59ad325->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_cb8b11b0deae1c6f739671b4ce97cea4->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 50)
12	__TwigTemplate_34e894e0c6c92b9abd847c3c75e859c6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 379)
15	Twig\Template->render (line 38)
16	Twig\TemplateWrapper->render (line 280)
17	Twig\Environment->render (line 448)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 183)
21	App\Controller\ProgramController->show (line 181)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 6)

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\Currency	No errors.
App\Entity\Program	The mappings App\Entity\Program#programCategories and App\Entity\ProgramCategory#programs are inconsistent with each other. If association App\Entity\Program#programCategories is many-to-many, then the inversed side App\Entity\ProgramCategory#programs has to be many-to-many as well. The field App\Entity\Program#programPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProgramPrice#program does not contain the required 'inversedBy="programPrices"' attribute. The field App\Entity\Program#restaurantProgramPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RestaurantProgramPrice#program does not contain the required 'inversedBy="restaurantProgramPrices"' attribute. The mappings App\Entity\Program#programDiets and App\Entity\ProgramDiet#programs are inconsistent with each other. If association App\Entity\Program#programDiets is many-to-many, then the inversed side App\Entity\ProgramDiet#programs has to be many-to-many as well.
App\Entity\User	The mappings App\Entity\User#role and App\Entity\Role#users are inconsistent with each other. The field App\Entity\User#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Order#user does not contain the required 'inversedBy="orders"' attribute. The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which is not defined as association, but as field. The association App\Entity\User#testimonials refers to the owning side field App\Entity\Testimonial#user which does not exist.
App\Entity\ProgramCategory	The association App\Entity\ProgramCategory#programs refers to the owning side field App\Entity\Program#programCategory which does not exist. The mappings App\Entity\ProgramCategory#programsMany and App\Entity\Program#programCategories are inconsistent with each other. The association App\Entity\ProgramCategory#requests refers to the owning side field App\Entity\Request#programCategory which does not exist.
App\Entity\ProgramPrice	The field 'App\Entity\ProgramPrice#unitAmountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Request	No errors.
App\Entity\Product	The field App\Entity\Product#productPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ProductPrice#product does not contain the required 'inversedBy="productPrices"' attribute.
App\Entity\RestaurantProgramPrice	The field 'App\Entity\RestaurantProgramPrice#unitAmountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Faq	No errors.
App\Entity\ProgramDiet	The association App\Entity\ProgramDiet#programs refers to the owning side field App\Entity\Program#programDiet which does not exist. The mappings App\Entity\ProgramDiet#programsMany and App\Entity\Program#programDiets are inconsistent with each other.
App\Entity\Disease	No errors.
App\Entity\ProgramDailyMeal	The field 'App\Entity\ProgramDailyMeal#id' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Rate	The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Entity\ProgramField	No errors.
App\Entity\PriceList	No errors.
App\Entity\MealCategory	The association App\Entity\MealCategory#requests refers to the owning side field App\Entity\Request#mealCategories which does not exist.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.

Symfony Profiler

GET https://www.badnii.com/index.php/en/programs/123

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping