Symfony Profiler

Query Metrics

4 Database Queries

4 Different statements

2.20 ms Query time

0 Invalid entities

33 Managed entities

Queries

Group similar statements

#▲

Time

Info

0.59 ms

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar_name AS avatar_name_7, t0.google_avatar AS google_avatar_8, t0.points AS points_9, t0.preferences AS preferences_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_login_at AS last_login_at_13, t0.location_city AS location_city_14, t0.location_latitude AS location_latitude_15, t0.location_longitude AS location_longitude_16, t0.google_id AS google_id_17, t0.allergies AS allergies_18 FROM user t0 WHERE t0.id = ?

Parameters:

[
  b"<ºÌžF$K¾¶ÏUA„\f®ä"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.avatar_name AS avatar_name_7,
  t0.google_avatar AS google_avatar_8,
  t0.points AS points_9,
  t0.preferences AS preferences_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.last_login_at AS last_login_at_13,
  t0.location_city AS location_city_14,
  t0.location_latitude AS location_latitude_15,
  t0.location_longitude AS location_longitude_16,
  t0.google_id AS google_id_17,
  t0.allergies AS allergies_18
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.avatar_name AS avatar_name_7, t0.google_avatar AS google_avatar_8, t0.points AS points_9, t0.preferences AS preferences_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.last_login_at AS last_login_at_13, t0.location_city AS location_city_14, t0.location_latitude AS location_latitude_15, t0.location_longitude AS location_longitude_16, t0.google_id AS google_id_17, t0.allergies AS allergies_18 FROM user t0 WHERE t0.id = 0x3CBACC9E46244BBEB6CF5541840CAEE4;

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

0.89 ms

SELECT r0_.id AS id_0, r0_.score AS score_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.moderation_status AS moderation_status_4, r1_.id AS id_5, r1_.price AS price_6, r1_.currency AS currency_7, r1_.is_available AS is_available_8, r1_.display_order AS display_order_9, r1_.average_rating AS average_rating_10, r1_.ratings_count AS ratings_count_11, r1_.chef_note AS chef_note_12, r1_.image_name AS image_name_13, r1_.created_at AS created_at_14, r1_.updated_at AS updated_at_15, r1_.contribution_status AS contribution_status_16, r1_.is_image_ai_generated AS is_image_ai_generated_17, r1_.image_ai_provider AS image_ai_provider_18, r1_.image_generated_at AS image_generated_at_19, r1_.unavailable_reports_count AS unavailable_reports_count_20, r1_.archived_at AS archived_at_21, r2_.id AS id_22, r2_.name AS name_23, r2_.slug AS slug_24, r2_.description AS description_25, r2_.is_vegetarian AS is_vegetarian_26, r2_.is_vegan AS is_vegan_27, r2_.is_gluten_free AS is_gluten_free_28, r2_.image_name AS image_name_29, r2_.average_price AS average_price_30, r2_.global_rating AS global_rating_31, r2_.restaurant_count AS restaurant_count_32, r2_.created_at AS created_at_33, r2_.updated_at AS updated_at_34, r3_.id AS id_35, r3_.name AS name_36, r3_.slug AS slug_37, r3_.description AS description_38, r3_.address AS address_39, r3_.city AS city_40, r3_.postal_code AS postal_code_41, r3_.country AS country_42, r3_.latitude AS latitude_43, r3_.longitude AS longitude_44, r3_.phone AS phone_45, r3_.email AS email_46, r3_.website AS website_47, r3_.logo AS logo_48, r3_.cover_image AS cover_image_49, r3_.opening_hours AS opening_hours_50, r3_.is_active AS is_active_51, r3_.is_verified AS is_verified_52, r3_.subscription_type AS subscription_type_53, r3_.subscription_expires_at AS subscription_expires_at_54, r3_.created_at AS created_at_55, r3_.updated_at AS updated_at_56, r3_.source_provider AS source_provider_57, r3_.source_external_id AS source_external_id_58, r3_.imported_at AS imported_at_59, r3_.contribution_status AS contribution_status_60, r0_.user_id AS user_id_61, r0_.restaurant_dish_id AS restaurant_dish_id_62, r1_.restaurant_id AS restaurant_id_63, r1_.menu_id AS menu_id_64, r1_.recipe_id AS recipe_id_65, r2_.category_id AS category_id_66, r3_.owner_id AS owner_id_67, r3_.contributed_by_id AS contributed_by_id_68 FROM rating r0_ LEFT JOIN restaurant_dish r1_ ON r0_.restaurant_dish_id = r1_.id LEFT JOIN recipe r2_ ON r1_.recipe_id = r2_.id LEFT JOIN restaurant r3_ ON r1_.restaurant_id = r3_.id WHERE r0_.user_id = ? AND r0_.restaurant_dish_id IS NOT NULL ORDER BY r0_.created_at DESC LIMIT 50

Parameters:

[
  b"<ºÌžF$K¾¶ÏUA„\f®ä"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.id AS id_0,
  r0_.score AS score_1,
  r0_.comment AS comment_2,
  r0_.created_at AS created_at_3,
  r0_.moderation_status AS moderation_status_4,
  r1_.id AS id_5,
  r1_.price AS price_6,
  r1_.currency AS currency_7,
  r1_.is_available AS is_available_8,
  r1_.display_order AS display_order_9,
  r1_.average_rating AS average_rating_10,
  r1_.ratings_count AS ratings_count_11,
  r1_.chef_note AS chef_note_12,
  r1_.image_name AS image_name_13,
  r1_.created_at AS created_at_14,
  r1_.updated_at AS updated_at_15,
  r1_.contribution_status AS contribution_status_16,
  r1_.is_image_ai_generated AS is_image_ai_generated_17,
  r1_.image_ai_provider AS image_ai_provider_18,
  r1_.image_generated_at AS image_generated_at_19,
  r1_.unavailable_reports_count AS unavailable_reports_count_20,
  r1_.archived_at AS archived_at_21,
  r2_.id AS id_22,
  r2_.name AS name_23,
  r2_.slug AS slug_24,
  r2_.description AS description_25,
  r2_.is_vegetarian AS is_vegetarian_26,
  r2_.is_vegan AS is_vegan_27,
  r2_.is_gluten_free AS is_gluten_free_28,
  r2_.image_name AS image_name_29,
  r2_.average_price AS average_price_30,
  r2_.global_rating AS global_rating_31,
  r2_.restaurant_count AS restaurant_count_32,
  r2_.created_at AS created_at_33,
  r2_.updated_at AS updated_at_34,
  r3_.id AS id_35,
  r3_.name AS name_36,
  r3_.slug AS slug_37,
  r3_.description AS description_38,
  r3_.address AS address_39,
  r3_.city AS city_40,
  r3_.postal_code AS postal_code_41,
  r3_.country AS country_42,
  r3_.latitude AS latitude_43,
  r3_.longitude AS longitude_44,
  r3_.phone AS phone_45,
  r3_.email AS email_46,
  r3_.website AS website_47,
  r3_.logo AS logo_48,
  r3_.cover_image AS cover_image_49,
  r3_.opening_hours AS opening_hours_50,
  r3_.is_active AS is_active_51,
  r3_.is_verified AS is_verified_52,
  r3_.subscription_type AS subscription_type_53,
  r3_.subscription_expires_at AS subscription_expires_at_54,
  r3_.created_at AS created_at_55,
  r3_.updated_at AS updated_at_56,
  r3_.source_provider AS source_provider_57,
  r3_.source_external_id AS source_external_id_58,
  r3_.imported_at AS imported_at_59,
  r3_.contribution_status AS contribution_status_60,
  r0_.user_id AS user_id_61,
  r0_.restaurant_dish_id AS restaurant_dish_id_62,
  r1_.restaurant_id AS restaurant_id_63,
  r1_.menu_id AS menu_id_64,
  r1_.recipe_id AS recipe_id_65,
  r2_.category_id AS category_id_66,
  r3_.owner_id AS owner_id_67,
  r3_.contributed_by_id AS contributed_by_id_68
FROM
  rating r0_
  LEFT JOIN restaurant_dish r1_ ON r0_.restaurant_dish_id = r1_.id
  LEFT JOIN recipe r2_ ON r1_.recipe_id = r2_.id
  LEFT JOIN restaurant r3_ ON r1_.restaurant_id = r3_.id
WHERE
  r0_.user_id = ?
  AND r0_.restaurant_dish_id IS NOT NULL
ORDER BY
  r0_.created_at DESC
LIMIT
  50

SELECT r0_.id AS id_0, r0_.score AS score_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.moderation_status AS moderation_status_4, r1_.id AS id_5, r1_.price AS price_6, r1_.currency AS currency_7, r1_.is_available AS is_available_8, r1_.display_order AS display_order_9, r1_.average_rating AS average_rating_10, r1_.ratings_count AS ratings_count_11, r1_.chef_note AS chef_note_12, r1_.image_name AS image_name_13, r1_.created_at AS created_at_14, r1_.updated_at AS updated_at_15, r1_.contribution_status AS contribution_status_16, r1_.is_image_ai_generated AS is_image_ai_generated_17, r1_.image_ai_provider AS image_ai_provider_18, r1_.image_generated_at AS image_generated_at_19, r1_.unavailable_reports_count AS unavailable_reports_count_20, r1_.archived_at AS archived_at_21, r2_.id AS id_22, r2_.name AS name_23, r2_.slug AS slug_24, r2_.description AS description_25, r2_.is_vegetarian AS is_vegetarian_26, r2_.is_vegan AS is_vegan_27, r2_.is_gluten_free AS is_gluten_free_28, r2_.image_name AS image_name_29, r2_.average_price AS average_price_30, r2_.global_rating AS global_rating_31, r2_.restaurant_count AS restaurant_count_32, r2_.created_at AS created_at_33, r2_.updated_at AS updated_at_34, r3_.id AS id_35, r3_.name AS name_36, r3_.slug AS slug_37, r3_.description AS description_38, r3_.address AS address_39, r3_.city AS city_40, r3_.postal_code AS postal_code_41, r3_.country AS country_42, r3_.latitude AS latitude_43, r3_.longitude AS longitude_44, r3_.phone AS phone_45, r3_.email AS email_46, r3_.website AS website_47, r3_.logo AS logo_48, r3_.cover_image AS cover_image_49, r3_.opening_hours AS opening_hours_50, r3_.is_active AS is_active_51, r3_.is_verified AS is_verified_52, r3_.subscription_type AS subscription_type_53, r3_.subscription_expires_at AS subscription_expires_at_54, r3_.created_at AS created_at_55, r3_.updated_at AS updated_at_56, r3_.source_provider AS source_provider_57, r3_.source_external_id AS source_external_id_58, r3_.imported_at AS imported_at_59, r3_.contribution_status AS contribution_status_60, r0_.user_id AS user_id_61, r0_.restaurant_dish_id AS restaurant_dish_id_62, r1_.restaurant_id AS restaurant_id_63, r1_.menu_id AS menu_id_64, r1_.recipe_id AS recipe_id_65, r2_.category_id AS category_id_66, r3_.owner_id AS owner_id_67, r3_.contributed_by_id AS contributed_by_id_68 FROM rating r0_ LEFT JOIN restaurant_dish r1_ ON r0_.restaurant_dish_id = r1_.id LEFT JOIN recipe r2_ ON r1_.recipe_id = r2_.id LEFT JOIN restaurant r3_ ON r1_.restaurant_id = r3_.id WHERE r0_.user_id = 0x3CBACC9E46244BBEB6CF5541840CAEE4 AND r0_.restaurant_dish_id IS NOT NULL ORDER BY r0_.created_at DESC LIMIT 50;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getResult (line 688)
6	App\Repository\RatingRepository->findByUserForRestaurantDishes (line 175)
7	App\Controller\ProfileController->publicProfile (line 75)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
10	Symfony\Component\HttpKernel\Kernel->handle (line 182)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
12	require_once (line 29)
13	require_once (line 5)

0.40 ms

SELECT COUNT(r0_.id) AS sclr_0 FROM rating r0_ WHERE r0_.user_id = ?

Parameters:

[
  b"<ºÌžF$K¾¶ÏUA„\f®ä"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.user_id = ?

SELECT COUNT(r0_.id) AS sclr_0 FROM rating r0_ WHERE r0_.user_id = 0x3CBACC9E46244BBEB6CF5541840CAEE4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\RatingRepository->countByUser (line 82)
8	App\Controller\ProfileController->publicProfile (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

0.33 ms

SELECT AVG(r0_.score) AS sclr_0 FROM rating r0_ WHERE r0_.user_id = ?

Parameters:

[
  b"<ºÌžF$K¾¶ÏUA„\f®ä"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  AVG(r0_.score) AS sclr_0
FROM
  rating r0_
WHERE
  r0_.user_id = ?

SELECT AVG(r0_.score) AS sclr_0 FROM rating r0_ WHERE r0_.user_id = 0x3CBACC9E46244BBEB6CF5541840CAEE4;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 27)
2	Doctrine\ORM\Query->_doExecute (line 296)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 930)
4	Doctrine\ORM\AbstractQuery->execute (line 886)
5	Doctrine\ORM\AbstractQuery->getSingleResult (line 772)
6	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 801)
7	App\Repository\RatingRepository->getAverageScoreByUser (line 92)
8	App\Controller\ProfileController->publicProfile (line 77)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
11	Symfony\Component\HttpKernel\Kernel->handle (line 182)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
13	require_once (line 29)
14	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Rating	7
App\Entity\RestaurantDish	7
App\Entity\Recipe	6
App\Entity\Category	4
App\Entity\User	3
App\Entity\Menu	3
App\Entity\Restaurant	3

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Rating	No errors.
App\Entity\RestaurantDish	No errors.
App\Entity\Recipe	No errors.
App\Entity\Restaurant	No errors.
App\Entity\Menu	No errors.
App\Entity\Category	No errors.
App\Entity\Ingredient	No errors.
App\Entity\RestaurantEnrichment	No errors.

Symfony Profiler

GET https://foodan.app/utilisateur/3cbacc9e-4624-4bbe-b6cf-5541840caee4

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping