Symfony Profiler

Query Metrics

8 Database Queries

5 Different statements

3.95 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼

Count

Info

1.78 ms
(45.12%)

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.main_image AS main_image_2, p0_.description AS description_3, p0_.is_active AS is_active_4, p0_.price AS price_5, p0_.pricing_type AS pricing_type_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sort_order AS sort_order_9, p0_.views_count AS views_count_10, p0_.likes_count AS likes_count_11, p0_.purchases_count AS purchases_count_12, p0_.comments_count AS comments_count_13, p1_.id AS id_14, p1_.locale AS locale_15, p1_.title AS title_16, p1_.description AS description_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, c2_.id AS id_20, c2_.title AS title_21, c2_.image AS image_22, c2_.is_active AS is_active_23, c2_.created_at AS created_at_24, c2_.updated_at AS updated_at_25, c2_.sort_order AS sort_order_26, c3_.id AS id_27, c3_.locale AS locale_28, c3_.title AS title_29, c3_.description AS description_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, s4_.id AS id_33, s4_.name AS name_34, s4_.price AS price_35, s4_.type AS type_36, s4_.is_active AS is_active_37, s4_.is_public AS is_public_38, s4_.description AS description_39, s4_.sort_order AS sort_order_40, s4_.created_at AS created_at_41, s4_.updated_at AS updated_at_42, p1_.photo_id AS photo_id_43, c3_.category_id AS category_id_44 FROM photo p0_ LEFT JOIN photo_translation p1_ ON p0_.id = p1_.photo_id AND (p1_.locale = ?) LEFT JOIN photo_categories p5_ ON p0_.id = p5_.photo_id LEFT JOIN category c2_ ON c2_.id = p5_.category_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id AND (c3_.locale = ?) LEFT JOIN photo_subscriptions p6_ ON p0_.id = p6_.photo_id LEFT JOIN subscriptions s4_ ON s4_.id = p6_.subscription_id WHERE p0_.is_active = 1 ORDER BY p0_.sort_order ASC, p0_.created_at DESC

Parameters:

[
  "fr"
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.main_image AS main_image_2,
  p0_.description AS description_3,
  p0_.is_active AS is_active_4,
  p0_.price AS price_5,
  p0_.pricing_type AS pricing_type_6,
  p0_.created_at AS created_at_7,
  p0_.updated_at AS updated_at_8,
  p0_.sort_order AS sort_order_9,
  p0_.views_count AS views_count_10,
  p0_.likes_count AS likes_count_11,
  p0_.purchases_count AS purchases_count_12,
  p0_.comments_count AS comments_count_13,
  p1_.id AS id_14,
  p1_.locale AS locale_15,
  p1_.title AS title_16,
  p1_.description AS description_17,
  p1_.created_at AS created_at_18,
  p1_.updated_at AS updated_at_19,
  c2_.id AS id_20,
  c2_.title AS title_21,
  c2_.image AS image_22,
  c2_.is_active AS is_active_23,
  c2_.created_at AS created_at_24,
  c2_.updated_at AS updated_at_25,
  c2_.sort_order AS sort_order_26,
  c3_.id AS id_27,
  c3_.locale AS locale_28,
  c3_.title AS title_29,
  c3_.description AS description_30,
  c3_.created_at AS created_at_31,
  c3_.updated_at AS updated_at_32,
  s4_.id AS id_33,
  s4_.name AS name_34,
  s4_.price AS price_35,
  s4_.type AS type_36,
  s4_.is_active AS is_active_37,
  s4_.is_public AS is_public_38,
  s4_.description AS description_39,
  s4_.sort_order AS sort_order_40,
  s4_.created_at AS created_at_41,
  s4_.updated_at AS updated_at_42,
  p1_.photo_id AS photo_id_43,
  c3_.category_id AS category_id_44
FROM
  photo p0_
  LEFT JOIN photo_translation p1_ ON p0_.id = p1_.photo_id
  AND (p1_.locale = ?)
  LEFT JOIN photo_categories p5_ ON p0_.id = p5_.photo_id
  LEFT JOIN category c2_ ON c2_.id = p5_.category_id
  LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id
  AND (c3_.locale = ?)
  LEFT JOIN photo_subscriptions p6_ ON p0_.id = p6_.photo_id
  LEFT JOIN subscriptions s4_ ON s4_.id = p6_.subscription_id
WHERE
  p0_.is_active = 1
ORDER BY
  p0_.sort_order ASC,
  p0_.created_at DESC

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.main_image AS main_image_2, p0_.description AS description_3, p0_.is_active AS is_active_4, p0_.price AS price_5, p0_.pricing_type AS pricing_type_6, p0_.created_at AS created_at_7, p0_.updated_at AS updated_at_8, p0_.sort_order AS sort_order_9, p0_.views_count AS views_count_10, p0_.likes_count AS likes_count_11, p0_.purchases_count AS purchases_count_12, p0_.comments_count AS comments_count_13, p1_.id AS id_14, p1_.locale AS locale_15, p1_.title AS title_16, p1_.description AS description_17, p1_.created_at AS created_at_18, p1_.updated_at AS updated_at_19, c2_.id AS id_20, c2_.title AS title_21, c2_.image AS image_22, c2_.is_active AS is_active_23, c2_.created_at AS created_at_24, c2_.updated_at AS updated_at_25, c2_.sort_order AS sort_order_26, c3_.id AS id_27, c3_.locale AS locale_28, c3_.title AS title_29, c3_.description AS description_30, c3_.created_at AS created_at_31, c3_.updated_at AS updated_at_32, s4_.id AS id_33, s4_.name AS name_34, s4_.price AS price_35, s4_.type AS type_36, s4_.is_active AS is_active_37, s4_.is_public AS is_public_38, s4_.description AS description_39, s4_.sort_order AS sort_order_40, s4_.created_at AS created_at_41, s4_.updated_at AS updated_at_42, p1_.photo_id AS photo_id_43, c3_.category_id AS category_id_44 FROM photo p0_ LEFT JOIN photo_translation p1_ ON p0_.id = p1_.photo_id AND (p1_.locale = 'fr') LEFT JOIN photo_categories p5_ ON p0_.id = p5_.photo_id LEFT JOIN category c2_ ON c2_.id = p5_.category_id LEFT JOIN category_translation c3_ ON c2_.id = c3_.category_id AND (c3_.locale = 'fr') LEFT JOIN photo_subscriptions p6_ ON p0_.id = p6_.photo_id LEFT JOIN subscriptions s4_ ON s4_.id = p6_.subscription_id WHERE p0_.is_active = 1 ORDER BY p0_.sort_order ASC, p0_.created_at DESC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 52)
7	App\Controller\PhotoViewController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

1.02 ms
(25.96%)

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt AS alt_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.photo_id AS photo_id_6 FROM photo_gallery t0 WHERE t0.photo_id = ? ORDER BY t0.sort_order ASC

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.alt AS alt_3,
  t0.sort_order AS sort_order_4,
  t0.created_at AS created_at_5,
  t0.photo_id AS photo_id_6
FROM
  photo_gallery t0
WHERE
  t0.photo_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.alt AS alt_3, t0.sort_order AS sort_order_4, t0.created_at AS created_at_5, t0.photo_id AS photo_id_6 FROM photo_gallery t0 WHERE t0.photo_id = 1 ORDER BY t0.sort_order ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1831)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getOneToManyStatement (line 1776)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadOneToManyCollection (line 2706)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 622)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 186)
6	Doctrine\ORM\PersistentCollection->initialize (line 39)
7	Doctrine\Common\Collections\AbstractLazyCollection->count (line 391)
8	Doctrine\ORM\PersistentCollection->count (line 154)
9	App\Controller\PhotoViewController->index (line 183)
10	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
11	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
12	Symfony\Component\HttpKernel\Kernel->handle (line 35)
13	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
14	require_once (line 5)

0.43 ms
(10.93%)

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.image AS image_2, c0_.is_active AS is_active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.title AS title_9, c1_.description AS description_10, c1_.created_at AS created_at_11, c1_.updated_at AS updated_at_12, c1_.category_id AS category_id_13 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id AND (c1_.locale = ?) WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.title ASC

Parameters:

[
  "fr"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.image AS image_2,
  c0_.is_active AS is_active_3,
  c0_.created_at AS created_at_4,
  c0_.updated_at AS updated_at_5,
  c0_.sort_order AS sort_order_6,
  c1_.id AS id_7,
  c1_.locale AS locale_8,
  c1_.title AS title_9,
  c1_.description AS description_10,
  c1_.created_at AS created_at_11,
  c1_.updated_at AS updated_at_12,
  c1_.category_id AS category_id_13
FROM
  category c0_
  LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id
  AND (c1_.locale = ?)
WHERE
  c0_.is_active = 1
ORDER BY
  c0_.sort_order ASC,
  c0_.title ASC

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.image AS image_2, c0_.is_active AS is_active_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.sort_order AS sort_order_6, c1_.id AS id_7, c1_.locale AS locale_8, c1_.title AS title_9, c1_.description AS description_10, c1_.created_at AS created_at_11, c1_.updated_at AS updated_at_12, c1_.category_id AS category_id_13 FROM category c0_ LEFT JOIN category_translation c1_ ON c0_.id = c1_.category_id AND (c1_.locale = 'fr') WHERE c0_.is_active = 1 ORDER BY c0_.sort_order ASC, c0_.title ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 689)
6	Doctrine\ORM\AbstractQuery->getResult (line 63)
7	App\Controller\PhotoViewController->index (line 183)
8	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
9	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
10	Symfony\Component\HttpKernel\Kernel->handle (line 35)
11	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
12	require_once (line 5)

0.41 ms
(10.29%)

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= ?

Parameters:

[
  "2026-01-22 00:00:00"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  comments c0_
WHERE
  c0_.created_at >= ?

SELECT COUNT(c0_.id) AS sclr_0 FROM comments c0_ WHERE c0_.created_at >= '2026-01-22 00:00:00';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 93)
8	App\Service\AdminNotificationService->getTodayCommentsCount (line 76)
9	App\Service\AdminNotificationService->getAdminBadges (line 18)
10	App\Twig\AdminExtension->getGlobals (line 330)
11	Twig\ExtensionSet->getGlobals (line 838)
12	Twig\Environment->getGlobals (line 383)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 184)
21	App\Controller\PhotoViewController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	require_once (line 5)

0.30 ms
(7.70%)

SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = ?

Parameters:

[
  0
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  contact_message c0_
WHERE
  c0_.is_read = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM contact_message c0_ WHERE c0_.is_read = 0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 27)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 296)
3	Doctrine\ORM\Query->_doExecute (line 935)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 891)
5	Doctrine\ORM\AbstractQuery->execute (line 773)
6	Doctrine\ORM\AbstractQuery->getSingleResult (line 802)
7	Doctrine\ORM\AbstractQuery->getSingleScalarResult (line 36)
8	App\Repository\ContactMessageRepository->countUnreadMessages (line 77)
9	App\Service\AdminNotificationService->getAdminBadges (line 18)
10	App\Twig\AdminExtension->getGlobals (line 330)
11	Twig\ExtensionSet->getGlobals (line 838)
12	Twig\Environment->getGlobals (line 383)
13	Twig\Template->yield (line 343)
14	Twig\Template->display (line 358)
15	Twig\Template->render (line 35)
16	Twig\TemplateWrapper->render (line 320)
17	Twig\Environment->render (line 431)
18	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRenderView (line 436)
19	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->doRender (line 250)
20	Symfony\Bundle\FrameworkBundle\Controller\AbstractController->render (line 184)
21	App\Controller\PhotoViewController->index (line 183)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 182)
24	Symfony\Component\HttpKernel\Kernel->handle (line 35)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
26	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.

Entities Mapping

Class	Mapping errors
App\Entity\Photo	No errors.
App\Entity\PhotoTranslation	No errors.
App\Entity\Category	No errors.
App\Entity\CategoryTranslation	No errors.
App\Entity\Subscription	No errors.
App\Entity\PhotoGallery	No errors.
App\Entity\Video	No errors.
App\Entity\SubscriptionTranslation	No errors.
App\Entity\Comment	No errors.
App\Entity\ContactMessage	No errors.

Symfony Profiler

GET https://kinkyclub.e-world-france.fr/galeries/

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping