Symfony Profiler

Query Metrics

49 Database Queries

23 Different statements

18.41 ms Query time

20 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

2.76 ms
(14.99%)

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.type = ? LIMIT 1

Parameters:

[
  "about"
]

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.type = ?
LIMIT
  1

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.type = 'about' 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 113)
5	App\Twig\AppExtension->getPageByType (line 51)
6	__TwigTemplate_c0f7413163e158a456d841abd967a421->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 92)
9	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
10	Twig\Template->displayBlock (line 369)
11	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
12	Twig\Template->displayWithErrorHandling (line 367)
13	Twig\Template->display (line 49)
14	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 379)
17	Twig\Template->render (line 38)
18	Twig\TemplateWrapper->render (line 280)
19	Twig\Environment->render (line 448)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
23	App\Controller\HomeController->welcome (line 181)
24	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
25	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
26	Symfony\Component\HttpKernel\Kernel->handle (line 35)
27	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
28	require_once (line 6)

2.67 ms
(14.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 150)
5	App\Twig\AppExtension->getSettings (line 285)
6	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 49)
9	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->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 235)
18	App\Controller\HomeController->welcome (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)

1.53 ms
(8.34%)

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.google_id AS google_id_3, u0_.first_name_ar AS first_name_ar_4, u0_.last_name_ar AS last_name_ar_5, u0_.address AS address_6, u0_.is_active AS is_active_7, u0_.email AS email_8, u0_.mobile AS mobile_9, u0_.gender AS gender_10, u0_.preferred_unit AS preferred_unit_11, u0_.current_weight AS current_weight_12, u0_.target_weight AS target_weight_13, u0_.height AS height_14, u0_.password AS password_15, u0_.last_seen AS last_seen_16, u0_.country AS country_17, u0_.city AS city_18, u0_.date_of_birth AS date_of_birth_19, u0_.avatar AS avatar_20, u0_.description AS description_21, u0_.description_ar AS description_ar_22, u0_.is_approved AS is_approved_23, u0_.is_available_for_request AS is_available_for_request_24, u0_.accepted_terms AS accepted_terms_25, u0_.reset_token AS reset_token_26, u0_.facebook_id AS facebook_id_27, u0_.created_at AS created_at_28, u0_.updated_at AS updated_at_29, u0_.role_id AS role_id_30, u0_.physical_activity_id AS physical_activity_id_31, u0_.diet_goal_id AS diet_goal_id_32, u0_.custom_role_id AS custom_role_id_33 FROM user u0_ LEFT JOIN role r1_ ON u0_.role_id = r1_.id INNER JOIN program p2_ ON u0_.id = p2_.created_by_id WHERE r1_.type = ? AND u0_.id <> ? AND u0_.is_active = ? LIMIT 3

Parameters:

[
  "ROLE_EXPERT"
  3
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  u0_.id AS id_0,
  u0_.first_name AS first_name_1,
  u0_.last_name AS last_name_2,
  u0_.google_id AS google_id_3,
  u0_.first_name_ar AS first_name_ar_4,
  u0_.last_name_ar AS last_name_ar_5,
  u0_.address AS address_6,
  u0_.is_active AS is_active_7,
  u0_.email AS email_8,
  u0_.mobile AS mobile_9,
  u0_.gender AS gender_10,
  u0_.preferred_unit AS preferred_unit_11,
  u0_.current_weight AS current_weight_12,
  u0_.target_weight AS target_weight_13,
  u0_.height AS height_14,
  u0_.password AS password_15,
  u0_.last_seen AS last_seen_16,
  u0_.country AS country_17,
  u0_.city AS city_18,
  u0_.date_of_birth AS date_of_birth_19,
  u0_.avatar AS avatar_20,
  u0_.description AS description_21,
  u0_.description_ar AS description_ar_22,
  u0_.is_approved AS is_approved_23,
  u0_.is_available_for_request AS is_available_for_request_24,
  u0_.accepted_terms AS accepted_terms_25,
  u0_.reset_token AS reset_token_26,
  u0_.facebook_id AS facebook_id_27,
  u0_.created_at AS created_at_28,
  u0_.updated_at AS updated_at_29,
  u0_.role_id AS role_id_30,
  u0_.physical_activity_id AS physical_activity_id_31,
  u0_.diet_goal_id AS diet_goal_id_32,
  u0_.custom_role_id AS custom_role_id_33
FROM
  user u0_
  LEFT JOIN role r1_ ON u0_.role_id = r1_.id
  INNER JOIN program p2_ ON u0_.id = p2_.created_by_id
WHERE
  r1_.type = ?
  AND u0_.id <> ?
  AND u0_.is_active = ?
LIMIT
  3

SELECT u0_.id AS id_0, u0_.first_name AS first_name_1, u0_.last_name AS last_name_2, u0_.google_id AS google_id_3, u0_.first_name_ar AS first_name_ar_4, u0_.last_name_ar AS last_name_ar_5, u0_.address AS address_6, u0_.is_active AS is_active_7, u0_.email AS email_8, u0_.mobile AS mobile_9, u0_.gender AS gender_10, u0_.preferred_unit AS preferred_unit_11, u0_.current_weight AS current_weight_12, u0_.target_weight AS target_weight_13, u0_.height AS height_14, u0_.password AS password_15, u0_.last_seen AS last_seen_16, u0_.country AS country_17, u0_.city AS city_18, u0_.date_of_birth AS date_of_birth_19, u0_.avatar AS avatar_20, u0_.description AS description_21, u0_.description_ar AS description_ar_22, u0_.is_approved AS is_approved_23, u0_.is_available_for_request AS is_available_for_request_24, u0_.accepted_terms AS accepted_terms_25, u0_.reset_token AS reset_token_26, u0_.facebook_id AS facebook_id_27, u0_.created_at AS created_at_28, u0_.updated_at AS updated_at_29, u0_.role_id AS role_id_30, u0_.physical_activity_id AS physical_activity_id_31, u0_.diet_goal_id AS diet_goal_id_32, u0_.custom_role_id AS custom_role_id_33 FROM user u0_ LEFT JOIN role r1_ ON u0_.role_id = r1_.id INNER JOIN program p2_ ON u0_.id = p2_.created_by_id WHERE r1_.type = 'ROLE_EXPERT' AND u0_.id <> 3 AND u0_.is_active = 1 LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 97)
7	App\Repository\UserRepository->findDisplayedExpert (line 217)
8	App\Controller\HomeController->welcome (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 6)

1.22 ms
(6.62%)

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.content_ar AS content_ar_7, t0.image AS image_8, t0.published AS published_9, t0.meta_tags AS meta_tags_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.blog_category_id AS blog_category_id_13 FROM blog t0 ORDER BY t0.created_at DESC LIMIT 3

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.content_ar AS content_ar_7,
  t0.image AS image_8,
  t0.published AS published_9,
  t0.meta_tags AS meta_tags_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.blog_category_id AS blog_category_id_13
FROM
  blog t0
ORDER BY
  t0.created_at DESC
LIMIT
  3

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.content_ar AS content_ar_7, t0.image AS image_8, t0.published AS published_9, t0.meta_tags AS meta_tags_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.blog_category_id AS blog_category_id_13 FROM blog t0 ORDER BY t0.created_at DESC LIMIT 3;

#	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 216)
5	App\Controller\HomeController->welcome (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 6)

1.06 ms
(5.78%)

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 = ? LIMIT 1

Parameters:

[
  "OMR"
]

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 = ?
LIMIT
  1

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 = 'OMR' 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 48)
4	App\Helper\CurrencyPriceHelper->getCurrentCurrency (line 212)
5	App\Twig\AppExtension->getDefaultCurrency (line 193)
6	App\Twig\AppExtension->getCurrentCurrency (line 99)
7	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 357)
10	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
22	App\Controller\HomeController->welcome (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 6)

0.98 ms
(5.30%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_ar AS title_ar_2, p0_.short_description AS short_description_3, p0_.short_description_ar AS short_description_ar_4, p0_.description AS description_5, p0_.description_ar AS description_ar_6, p0_.meta_description AS meta_description_7, p0_.meta_description_ar AS meta_description_ar_8, p0_.age_from AS age_from_9, p0_.age_to AS age_to_10, p0_.ideal_gender AS ideal_gender_11, p0_.period_months AS period_months_12, p0_.image AS image_13, p0_.status AS status_14, p0_.daily_target_calories AS daily_target_calories_15, p0_.daily_target_carbs AS daily_target_carbs_16, p0_.daily_target_fat AS daily_target_fat_17, p0_.daily_target_protein AS daily_target_protein_18, p0_.is_featured AS is_featured_19, p0_.published_at AS published_at_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, AVG(r1_.rate) AS sclr_23, COUNT(r1_.id) AS sclr_24, p0_.created_by_id AS created_by_id_25 FROM program p0_ LEFT JOIN rate r1_ ON p0_.id = r1_.program_id LEFT JOIN restaurant_program_prices r2_ ON (r2_.program_id = p0_.id) WHERE r2_.id IS NOT NULL GROUP BY p0_.id ORDER BY sclr_23 DESC, sclr_24 DESC LIMIT 3

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.title_ar AS title_ar_2,
  p0_.short_description AS short_description_3,
  p0_.short_description_ar AS short_description_ar_4,
  p0_.description AS description_5,
  p0_.description_ar AS description_ar_6,
  p0_.meta_description AS meta_description_7,
  p0_.meta_description_ar AS meta_description_ar_8,
  p0_.age_from AS age_from_9,
  p0_.age_to AS age_to_10,
  p0_.ideal_gender AS ideal_gender_11,
  p0_.period_months AS period_months_12,
  p0_.image AS image_13,
  p0_.status AS status_14,
  p0_.daily_target_calories AS daily_target_calories_15,
  p0_.daily_target_carbs AS daily_target_carbs_16,
  p0_.daily_target_fat AS daily_target_fat_17,
  p0_.daily_target_protein AS daily_target_protein_18,
  p0_.is_featured AS is_featured_19,
  p0_.published_at AS published_at_20,
  p0_.created_at AS created_at_21,
  p0_.updated_at AS updated_at_22,
  AVG(r1_.rate) AS sclr_23,
  COUNT(r1_.id) AS sclr_24,
  p0_.created_by_id AS created_by_id_25
FROM
  program p0_
  LEFT JOIN rate r1_ ON p0_.id = r1_.program_id
  LEFT JOIN restaurant_program_prices r2_ ON (r2_.program_id = p0_.id)
WHERE
  r2_.id IS NOT NULL
GROUP BY
  p0_.id
ORDER BY
  sclr_23 DESC,
  sclr_24 DESC
LIMIT
  3

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_ar AS title_ar_2, p0_.short_description AS short_description_3, p0_.short_description_ar AS short_description_ar_4, p0_.description AS description_5, p0_.description_ar AS description_ar_6, p0_.meta_description AS meta_description_7, p0_.meta_description_ar AS meta_description_ar_8, p0_.age_from AS age_from_9, p0_.age_to AS age_to_10, p0_.ideal_gender AS ideal_gender_11, p0_.period_months AS period_months_12, p0_.image AS image_13, p0_.status AS status_14, p0_.daily_target_calories AS daily_target_calories_15, p0_.daily_target_carbs AS daily_target_carbs_16, p0_.daily_target_fat AS daily_target_fat_17, p0_.daily_target_protein AS daily_target_protein_18, p0_.is_featured AS is_featured_19, p0_.published_at AS published_at_20, p0_.created_at AS created_at_21, p0_.updated_at AS updated_at_22, AVG(r1_.rate) AS sclr_23, COUNT(r1_.id) AS sclr_24, p0_.created_by_id AS created_by_id_25 FROM program p0_ LEFT JOIN rate r1_ ON p0_.id = r1_.program_id LEFT JOIN restaurant_program_prices r2_ ON (r2_.program_id = p0_.id) WHERE r2_.id IS NOT NULL GROUP BY p0_.id ORDER BY sclr_23 DESC, sclr_24 DESC LIMIT 3;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 29)
2	Doctrine\ORM\Query\Exec\SingleSelectExecutor->execute (line 284)
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 249)
7	App\Repository\ProgramRepository->findTopRatedWithMostRates (line 226)
8	App\Controller\HomeController->welcome (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 6)

0.96 ms
(5.22%)

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 94)
5	App\Twig\AppExtension->getAllPages (line 53)
6	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 49)
12	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->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 235)
21	App\Controller\HomeController->welcome (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.94 ms
(5.08%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0 WHERE t0.id = ?

Parameters:

[
  5
]

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
FROM
  blog_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM blog_category t0 WHERE t0.id = 5;

#	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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
6	Proxies\__CG__\App\Entity\BlogCategory->__get (line 101)
7	App\Entity\BlogCategory->getLocalizedTitle (line 1635)
8	twig_get_attribute (line 55)
9	__TwigTemplate_892ce373b1160237dda8bf4f158e658f->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 89)
12	__TwigTemplate_c2b25eb1ba7a37cee7306755e2d965f6->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 110)
15	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
16	Twig\Template->displayBlock (line 369)
17	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 49)
20	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
29	App\Controller\HomeController->welcome (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 6)

0.71 ms
(3.85%)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_message AS last_message_2,
  t0.last_message_date AS last_message_date_3,
  t0.status AS status_4,
  t0.see AS see_5,
  t0.created_by_id AS created_by_id_6,
  t0.contact_with_id AS contact_with_id_7
FROM
  chat t0
WHERE
  t0.created_by_id IN (?, ?)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (107, 108);

#	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 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 168)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 97)
10	App\Repository\UserRepository->findDisplayedExpert (line 217)
11	App\Controller\HomeController->welcome (line 181)
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.70 ms
(3.79%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.gender AS gender_11, t0.preferred_unit AS preferred_unit_12, t0.current_weight AS current_weight_13, t0.target_weight AS target_weight_14, t0.height AS height_15, t0.password AS password_16, t0.last_seen AS last_seen_17, t0.country AS country_18, t0.city AS city_19, t0.date_of_birth AS date_of_birth_20, t0.avatar AS avatar_21, t0.description AS description_22, t0.description_ar AS description_ar_23, t0.is_approved AS is_approved_24, t0.is_available_for_request AS is_available_for_request_25, t0.accepted_terms AS accepted_terms_26, t0.reset_token AS reset_token_27, t0.facebook_id AS facebook_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.role_id AS role_id_31, t0.physical_activity_id AS physical_activity_id_32, t0.diet_goal_id AS diet_goal_id_33, t0.custom_role_id AS custom_role_id_34 FROM user t0 WHERE t0.id = ?

Parameters:

[
  3
]

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.google_id AS google_id_4,
  t0.first_name_ar AS first_name_ar_5,
  t0.last_name_ar AS last_name_ar_6,
  t0.address AS address_7,
  t0.is_active AS is_active_8,
  t0.email AS email_9,
  t0.mobile AS mobile_10,
  t0.gender AS gender_11,
  t0.preferred_unit AS preferred_unit_12,
  t0.current_weight AS current_weight_13,
  t0.target_weight AS target_weight_14,
  t0.height AS height_15,
  t0.password AS password_16,
  t0.last_seen AS last_seen_17,
  t0.country AS country_18,
  t0.city AS city_19,
  t0.date_of_birth AS date_of_birth_20,
  t0.avatar AS avatar_21,
  t0.description AS description_22,
  t0.description_ar AS description_ar_23,
  t0.is_approved AS is_approved_24,
  t0.is_available_for_request AS is_available_for_request_25,
  t0.accepted_terms AS accepted_terms_26,
  t0.reset_token AS reset_token_27,
  t0.facebook_id AS facebook_id_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.role_id AS role_id_31,
  t0.physical_activity_id AS physical_activity_id_32,
  t0.diet_goal_id AS diet_goal_id_33,
  t0.custom_role_id AS custom_role_id_34
FROM
  user 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.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.gender AS gender_11, t0.preferred_unit AS preferred_unit_12, t0.current_weight AS current_weight_13, t0.target_weight AS target_weight_14, t0.height AS height_15, t0.password AS password_16, t0.last_seen AS last_seen_17, t0.country AS country_18, t0.city AS city_19, t0.date_of_birth AS date_of_birth_20, t0.avatar AS avatar_21, t0.description AS description_22, t0.description_ar AS description_ar_23, t0.is_approved AS is_approved_24, t0.is_available_for_request AS is_available_for_request_25, t0.accepted_terms AS accepted_terms_26, t0.reset_token AS reset_token_27, t0.facebook_id AS facebook_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.role_id AS role_id_31, t0.physical_activity_id AS physical_activity_id_32, t0.diet_goal_id AS diet_goal_id_33, t0.custom_role_id AS custom_role_id_34 FROM user t0 WHERE t0.id = 3;

#	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 221)
4	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
5	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
6	Proxies\__CG__\App\Entity\User->__get (line 551)
7	App\Entity\User->getAvatar (line 1635)
8	twig_get_attribute (line 147)
9	__TwigTemplate_2a9479ba559c7a4dbb1e6b7b1a8228db->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 85)
12	__TwigTemplate_d8a93fecc93fea03b20c3bafac69fb95->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 95)
15	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
16	Twig\Template->displayBlock (line 369)
17	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 49)
20	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
21	Twig\Template->displayWithErrorHandling (line 367)
22	Twig\Template->display (line 379)
23	Twig\Template->render (line 38)
24	Twig\TemplateWrapper->render (line 280)
25	Twig\Environment->render (line 448)
26	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
29	App\Controller\HomeController->welcome (line 181)
30	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
31	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
32	Symfony\Component\HttpKernel\Kernel->handle (line 35)
33	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
34	require_once (line 6)

0.59 ms
(3.19%)

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.gender AS gender_11, t0.preferred_unit AS preferred_unit_12, t0.current_weight AS current_weight_13, t0.target_weight AS target_weight_14, t0.height AS height_15, t0.password AS password_16, t0.last_seen AS last_seen_17, t0.country AS country_18, t0.city AS city_19, t0.date_of_birth AS date_of_birth_20, t0.avatar AS avatar_21, t0.description AS description_22, t0.description_ar AS description_ar_23, t0.is_approved AS is_approved_24, t0.is_available_for_request AS is_available_for_request_25, t0.accepted_terms AS accepted_terms_26, t0.reset_token AS reset_token_27, t0.facebook_id AS facebook_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.role_id AS role_id_31, t0.physical_activity_id AS physical_activity_id_32, t0.diet_goal_id AS diet_goal_id_33, t0.custom_role_id AS custom_role_id_34 FROM user t0 WHERE t0.role_id = ? LIMIT 1

Parameters:

[
  "ROLE_ADMIN"
]

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.google_id AS google_id_4,
  t0.first_name_ar AS first_name_ar_5,
  t0.last_name_ar AS last_name_ar_6,
  t0.address AS address_7,
  t0.is_active AS is_active_8,
  t0.email AS email_9,
  t0.mobile AS mobile_10,
  t0.gender AS gender_11,
  t0.preferred_unit AS preferred_unit_12,
  t0.current_weight AS current_weight_13,
  t0.target_weight AS target_weight_14,
  t0.height AS height_15,
  t0.password AS password_16,
  t0.last_seen AS last_seen_17,
  t0.country AS country_18,
  t0.city AS city_19,
  t0.date_of_birth AS date_of_birth_20,
  t0.avatar AS avatar_21,
  t0.description AS description_22,
  t0.description_ar AS description_ar_23,
  t0.is_approved AS is_approved_24,
  t0.is_available_for_request AS is_available_for_request_25,
  t0.accepted_terms AS accepted_terms_26,
  t0.reset_token AS reset_token_27,
  t0.facebook_id AS facebook_id_28,
  t0.created_at AS created_at_29,
  t0.updated_at AS updated_at_30,
  t0.role_id AS role_id_31,
  t0.physical_activity_id AS physical_activity_id_32,
  t0.diet_goal_id AS diet_goal_id_33,
  t0.custom_role_id AS custom_role_id_34
FROM
  user t0
WHERE
  t0.role_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.google_id AS google_id_4, t0.first_name_ar AS first_name_ar_5, t0.last_name_ar AS last_name_ar_6, t0.address AS address_7, t0.is_active AS is_active_8, t0.email AS email_9, t0.mobile AS mobile_10, t0.gender AS gender_11, t0.preferred_unit AS preferred_unit_12, t0.current_weight AS current_weight_13, t0.target_weight AS target_weight_14, t0.height AS height_15, t0.password AS password_16, t0.last_seen AS last_seen_17, t0.country AS country_18, t0.city AS city_19, t0.date_of_birth AS date_of_birth_20, t0.avatar AS avatar_21, t0.description AS description_22, t0.description_ar AS description_ar_23, t0.is_approved AS is_approved_24, t0.is_available_for_request AS is_available_for_request_25, t0.accepted_terms AS accepted_terms_26, t0.reset_token AS reset_token_27, t0.facebook_id AS facebook_id_28, t0.created_at AS created_at_29, t0.updated_at AS updated_at_30, t0.role_id AS role_id_31, t0.physical_activity_id AS physical_activity_id_32, t0.diet_goal_id AS diet_goal_id_33, t0.custom_role_id AS custom_role_id_34 FROM user t0 WHERE t0.role_id = 'ROLE_ADMIN' 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 220)
5	App\Controller\HomeController->welcome (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 6)

0.57 ms
(3.12%)

SELECT t0.id AS id_1, t0.question AS question_2, t0.question_ar AS question_ar_3, t0.answer AS answer_4, t0.answer_ar AS answer_ar_5, t0.published AS published_6, t0.created_by_id AS created_by_id_7, t0.program_id AS program_id_8 FROM faq t0 WHERE t0.created_by_id IS NULL AND t0.published = ? LIMIT 3

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.question AS question_2,
  t0.question_ar AS question_ar_3,
  t0.answer AS answer_4,
  t0.answer_ar AS answer_ar_5,
  t0.published AS published_6,
  t0.created_by_id AS created_by_id_7,
  t0.program_id AS program_id_8
FROM
  faq t0
WHERE
  t0.created_by_id IS NULL
  AND t0.published = ?
LIMIT
  3

SELECT t0.id AS id_1, t0.question AS question_2, t0.question_ar AS question_ar_3, t0.answer AS answer_4, t0.answer_ar AS answer_ar_5, t0.published AS published_6, t0.created_by_id AS created_by_id_7, t0.program_id AS program_id_8 FROM faq t0 WHERE t0.created_by_id IS NULL AND t0.published = 1 LIMIT 3;

#	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 222)
5	App\Controller\HomeController->welcome (line 181)
6	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
7	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
8	Symfony\Component\HttpKernel\Kernel->handle (line 35)
9	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
10	require_once (line 6)

0.54 ms
(2.96%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.image AS image_4 FROM program_category t0

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.image AS image_4
FROM
  program_category t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3, t0.image AS image_4 FROM program_category 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 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 166)
6	App\Twig\AppExtension->getProgramCategories (line 63)
7	__TwigTemplate_ff9893e9af5686371ddb278bf8a297bb->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 101)
10	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
11	Twig\Template->displayBlock (line 369)
12	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
24	App\Controller\HomeController->welcome (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 6)

0.41 ms
(2.25%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM diet_goal t0

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
FROM
  diet_goal t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM diet_goal 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 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 223)
6	App\Controller\HomeController->welcome (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 6)

0.39 ms
(2.10%)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (?, ?)

Parameters:

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_message AS last_message_2,
  t0.last_message_date AS last_message_date_3,
  t0.status AS status_4,
  t0.see AS see_5,
  t0.created_by_id AS created_by_id_6,
  t0.contact_with_id AS contact_with_id_7
FROM
  chat t0
WHERE
  t0.contact_with_id IN (?, ?)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (107, 108);

#	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 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 168)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 97)
10	App\Repository\UserRepository->findDisplayedExpert (line 217)
11	App\Controller\HomeController->welcome (line 181)
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.37 ms
(2.03%)

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.user AS user_3, t0.comment_ar AS comment_ar_4, t0.user_ar AS user_ar_5 FROM testimonial t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.comment AS comment_2,
  t0.user AS user_3,
  t0.comment_ar AS comment_ar_4,
  t0.user_ar AS user_ar_5
FROM
  testimonial t0

SELECT t0.id AS id_1, t0.comment AS comment_2, t0.user AS user_3, t0.comment_ar AS comment_ar_4, t0.user_ar AS user_ar_5 FROM testimonial 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 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 99)
6	App\Twig\AppExtension->getAllTestimonials (line 71)
7	__TwigTemplate_6962520ac69e74fc53de3acbcc51b1f1->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 107)
10	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
11	Twig\Template->displayBlock (line 369)
12	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
13	Twig\Template->displayWithErrorHandling (line 367)
14	Twig\Template->display (line 49)
15	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
16	Twig\Template->displayWithErrorHandling (line 367)
17	Twig\Template->display (line 379)
18	Twig\Template->render (line 38)
19	Twig\TemplateWrapper->render (line 280)
20	Twig\Environment->render (line 448)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
22	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
23	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
24	App\Controller\HomeController->welcome (line 181)
25	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
26	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
27	Symfony\Component\HttpKernel\Kernel->handle (line 35)
28	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
29	require_once (line 6)

0.36 ms
(1.94%)

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 187)
5	App\Twig\AppExtension->getAllCurrencies (line 117)
6	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
7	Twig\Template->displayWithErrorHandling (line 367)
8	Twig\Template->display (line 357)
9	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
10	Twig\Template->displayWithErrorHandling (line 367)
11	Twig\Template->display (line 49)
12	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->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 235)
21	App\Controller\HomeController->welcome (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.34 ms
(1.86%)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (?)

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_message AS last_message_2,
  t0.last_message_date AS last_message_date_3,
  t0.status AS status_4,
  t0.see AS see_5,
  t0.created_by_id AS created_by_id_6,
  t0.contact_with_id AS contact_with_id_7
FROM
  chat t0
WHERE
  t0.created_by_id IN (?)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.created_by_id IN (3);

#	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 221)
9	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
10	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
11	Proxies\__CG__\App\Entity\User->__get (line 551)
12	App\Entity\User->getAvatar (line 1635)
13	twig_get_attribute (line 147)
14	__TwigTemplate_2a9479ba559c7a4dbb1e6b7b1a8228db->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 85)
17	__TwigTemplate_d8a93fecc93fea03b20c3bafac69fb95->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 95)
20	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
21	Twig\Template->displayBlock (line 369)
22	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 49)
25	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 379)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 280)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
34	App\Controller\HomeController->welcome (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	require_once (line 6)

0.32 ms
(1.74%)

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:

[
  66
]

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 (66);

#	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 120)
5	Doctrine\ORM\Internal\Hydration\ObjectHydrator->cleanup (line 168)
6	Doctrine\ORM\Internal\Hydration\AbstractHydrator->hydrateAll (line 948)
7	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
8	Doctrine\ORM\AbstractQuery->execute (line 689)
9	Doctrine\ORM\AbstractQuery->getResult (line 249)
10	App\Repository\ProgramRepository->findTopRatedWithMostRates (line 226)
11	App\Controller\HomeController->welcome (line 181)
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.26 ms
(1.44%)

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM how_know_diet t0

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
FROM
  how_know_diet t0

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_ar AS title_ar_3 FROM how_know_diet 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 72)
4	Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepositoryProxy->findBy (line 96)
5	Doctrine\ORM\EntityRepository->findAll (line 224)
6	App\Controller\HomeController->welcome (line 181)
7	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
8	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
9	Symfony\Component\HttpKernel\Kernel->handle (line 35)
10	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
11	require_once (line 6)

0.25 ms
(1.36%)

SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.program_id = ?

Parameters:

[
  66
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.rate AS rate_2,
  t0.comment AS comment_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.added_by_id AS added_by_id_6,
  t0.product_id AS product_id_7,
  t0.program_id AS program_id_8,
  t0.expert_id AS expert_id_9,
  t0.restaurant_id AS restaurant_id_10
FROM
  rate t0
WHERE
  t0.program_id = ?

SELECT t0.id AS id_1, t0.rate AS rate_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.added_by_id AS added_by_id_6, t0.product_id AS product_id_7, t0.program_id AS program_id_8, t0.expert_id AS expert_id_9, t0.restaurant_id AS restaurant_id_10 FROM rate t0 WHERE t0.program_id = 66;

#	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 1127)
9	twig_length_filter (line 222)
10	__TwigTemplate_2a9479ba559c7a4dbb1e6b7b1a8228db->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 85)
13	__TwigTemplate_d8a93fecc93fea03b20c3bafac69fb95->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 95)
16	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
17	Twig\Template->displayBlock (line 369)
18	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
19	Twig\Template->displayWithErrorHandling (line 367)
20	Twig\Template->display (line 49)
21	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
22	Twig\Template->displayWithErrorHandling (line 367)
23	Twig\Template->display (line 379)
24	Twig\Template->render (line 38)
25	Twig\TemplateWrapper->render (line 280)
26	Twig\Environment->render (line 448)
27	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
28	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
29	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
30	App\Controller\HomeController->welcome (line 181)
31	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
32	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
33	Symfony\Component\HttpKernel\Kernel->handle (line 35)
34	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
35	require_once (line 6)

0.24 ms
(1.30%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists t0 WHERE t0.is_default = ? LIMIT 1

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.currency_code AS currency_code_3,
  t0.is_default AS is_default_4,
  t0.valid_from AS valid_from_5,
  t0.valid_to AS valid_to_6
FROM
  price_lists t0
WHERE
  t0.is_default = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.currency_code AS currency_code_3, t0.is_default AS is_default_4, t0.valid_from AS valid_from_5, t0.valid_to AS valid_to_6 FROM price_lists t0 WHERE t0.is_default = 1 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 47)
4	App\Helper\CurrencyPriceHelper->getCurrentCurrency (line 212)
5	App\Twig\AppExtension->getDefaultCurrency (line 193)
6	App\Twig\AppExtension->getCurrentCurrency (line 99)
7	__TwigTemplate_ee496810c6410e408aaae4b79cbe1382->doDisplay (line 394)
8	Twig\Template->displayWithErrorHandling (line 367)
9	Twig\Template->display (line 357)
10	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
11	Twig\Template->displayWithErrorHandling (line 367)
12	Twig\Template->display (line 49)
13	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
14	Twig\Template->displayWithErrorHandling (line 367)
15	Twig\Template->display (line 379)
16	Twig\Template->render (line 38)
17	Twig\TemplateWrapper->render (line 280)
18	Twig\Environment->render (line 448)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
21	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
22	App\Controller\HomeController->welcome (line 181)
23	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
24	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
25	Symfony\Component\HttpKernel\Kernel->handle (line 35)
26	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
27	require_once (line 6)

0.22 ms
(1.22%)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (?)

Parameters:

[
  3
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.last_message AS last_message_2,
  t0.last_message_date AS last_message_date_3,
  t0.status AS status_4,
  t0.see AS see_5,
  t0.created_by_id AS created_by_id_6,
  t0.contact_with_id AS contact_with_id_7
FROM
  chat t0
WHERE
  t0.contact_with_id IN (?)

SELECT t0.id AS id_1, t0.last_message AS last_message_2, t0.last_message_date AS last_message_date_3, t0.status AS status_4, t0.see AS see_5, t0.created_by_id AS created_by_id_6, t0.contact_with_id AS contact_with_id_7 FROM chat t0 WHERE t0.contact_with_id IN (3);

#	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 221)
9	Doctrine\ORM\Proxy\ProxyFactory::Doctrine\ORM\Proxy\{closure} (line 100)
10	Symfony\Component\VarExporter\Internal\LazyObjectState->initialize (line 176)
11	Proxies\__CG__\App\Entity\User->__get (line 551)
12	App\Entity\User->getAvatar (line 1635)
13	twig_get_attribute (line 147)
14	__TwigTemplate_2a9479ba559c7a4dbb1e6b7b1a8228db->doDisplay (line 394)
15	Twig\Template->displayWithErrorHandling (line 367)
16	Twig\Template->display (line 85)
17	__TwigTemplate_d8a93fecc93fea03b20c3bafac69fb95->doDisplay (line 394)
18	Twig\Template->displayWithErrorHandling (line 367)
19	Twig\Template->display (line 95)
20	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->block_body (line 171)
21	Twig\Template->displayBlock (line 369)
22	__TwigTemplate_695896b719a6f68d53dda397c2f6d652->doDisplay (line 394)
23	Twig\Template->displayWithErrorHandling (line 367)
24	Twig\Template->display (line 49)
25	__TwigTemplate_41db5b782a487f645183ee4ca32c72b0->doDisplay (line 394)
26	Twig\Template->displayWithErrorHandling (line 367)
27	Twig\Template->display (line 379)
28	Twig\Template->render (line 38)
29	Twig\TemplateWrapper->render (line 280)
30	Twig\Environment->render (line 448)
31	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 453)
32	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 253)
33	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 235)
34	App\Controller\HomeController->welcome (line 181)
35	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
36	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
37	Symfony\Component\HttpKernel\Kernel->handle (line 35)
38	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
39	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\Blog	No errors.
App\Entity\BlogCategory	No errors.
App\Entity\Tag	No errors.
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\Role	The association App\Entity\Role#users refers to the owning side field App\Entity\User#Role which does not exist.
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\PhysicalActivity	No errors.
App\Entity\dietGoal	No errors.
App\Entity\CustomRole	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\MasterMenuItem	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Rate	The mappings App\Entity\Rate#expert and App\Entity\User#rates are inconsistent with each other.
App\Embeddable\AddressSnapshot	No errors.
App\Entity\Order	The field 'App\Entity\Order#subtotalProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#subtotalProgramRestaurantMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#adminFeeExclusiveMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#discountProductsMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#deliveryFeeProgramRestMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Order#grandTotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Subscription	The association App\Entity\Subscription#program refers to the inverse side field App\Entity\Program#subscriptions which does not exist.
App\Entity\MealMaker	The association App\Entity\MealMaker#program refers to the inverse side field App\Entity\Program#mealMakers which does not exist.
App\Entity\Request	No errors.
App\Entity\MealMakerDay	The association App\Entity\MealMakerDay#program refers to the inverse side field App\Entity\Program#mealMakerDays which does not exist.
App\Entity\Message	The mappings App\Entity\Message#sentBy and App\Entity\User#messages are inconsistent with each other.
App\Entity\ProfileSetting	No errors.
App\Entity\RateFood	No errors.
App\Entity\Cart	The field 'App\Entity\Cart#productsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Cart#subscriptionsSubtotalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Cart#discountMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Cart#shippingFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Cart#deliveryFeeMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type. The field 'App\Entity\Cart#totalMinor' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Favorite	No errors.
App\Entity\CollectionList	No errors.
App\Entity\RecuringFood	No errors.
App\Entity\Chat	No errors.
App\Entity\Adresse	No errors.
App\Entity\Coupon	The field 'App\Entity\Coupon#discountValue' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type. The field App\Entity\Coupon#carts is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Cart#coupon does not contain the required 'inversedBy="carts"' attribute. The association App\Entity\Coupon#orders refers to the owning side field App\Entity\Order#coupon which does not exist.
App\Entity\Notification	No errors.
App\Entity\UserDocument	No errors.
App\Entity\Faq	No errors.
App\Entity\Testimonial	No errors.
App\Entity\IndividualTransactions	The association App\Entity\IndividualTransactions#currency refers to the inverse side field App\Entity\Currency#individualTransactions which does not exist.
App\Entity\HowKnowDiet	No errors.
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\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\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\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\ProgramField	No errors.
App\Entity\PriceList	No errors.
App\Entity\Setting	No errors.
App\Entity\Page	No errors.
App\Entity\Currency	No errors.
App\Embeddable\BankInfo	No errors.
App\Entity\Restaurant	The association App\Entity\Restaurant#programs refers to the owning side field App\Entity\Program#restaurants which does not exist. The field App\Entity\Restaurant#restaurantProgramPrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\RestaurantProgramPrice#restaurant does not contain the required 'inversedBy="restaurantProgramPrices"' attribute.

Symfony Profiler

GET https://dev.badnii.com/robots.txt

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping