Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

49.44 ms Query time

3 Invalid entities

0 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

47.06 ms
(95.19%)

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM announcement a0_ INNER JOIN category c1_ ON a0_.category_id = c1_.id INNER JOIN user u2_ ON a0_.user_id = u2_.id INNER JOIN location l3_ ON a0_.location_id = l3_.id LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id LEFT JOIN category c7_ ON c1_.parent_id = c7_.id LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id LEFT JOIN user u12_ ON f11_.user_id = u12_.id LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id LEFT JOIN user u15_ ON r14_.customer_id = u15_.id LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id WHERE a0_.id IN (SELECT a17_.id FROM announcement a17_ INNER JOIN category c18_ ON a17_.category_id = c18_.id INNER JOIN user u19_ ON a17_.user_id = u19_.id WHERE a17_.returned_at >= ? AND a17_.active = ? AND c18_.name LIKE CONCAT('%', ?, '%') AND a17_.announcement_status = ?)

Parameters:

[
  "2026-06-01 00:00:00"
  1
  "Appartement"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  count(DISTINCT a0_.id) AS sclr_0
FROM
  announcement a0_
  INNER JOIN category c1_ ON a0_.category_id = c1_.id
  INNER JOIN user u2_ ON a0_.user_id = u2_.id
  INNER JOIN location l3_ ON a0_.location_id = l3_.id
  LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id
  LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id
  LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id
  LEFT JOIN category c7_ ON c1_.parent_id = c7_.id
  LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id
  LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id
  LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id
  LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id
  LEFT JOIN user u12_ ON f11_.user_id = u12_.id
  LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id
  LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id
  LEFT JOIN user u15_ ON r14_.customer_id = u15_.id
  LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id
WHERE
  a0_.id IN (
    SELECT
      a17_.id
    FROM
      announcement a17_
      INNER JOIN category c18_ ON a17_.category_id = c18_.id
      INNER JOIN user u19_ ON a17_.user_id = u19_.id
    WHERE
      a17_.returned_at >= ?
      AND a17_.active = ?
      AND c18_.name LIKE CONCAT('%', ?, '%')
      AND a17_.announcement_status = ?
  )

SELECT count(DISTINCT a0_.id) AS sclr_0 FROM announcement a0_ INNER JOIN category c1_ ON a0_.category_id = c1_.id INNER JOIN user u2_ ON a0_.user_id = u2_.id INNER JOIN location l3_ ON a0_.location_id = l3_.id LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id LEFT JOIN category c7_ ON c1_.parent_id = c7_.id LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id LEFT JOIN user u12_ ON f11_.user_id = u12_.id LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id LEFT JOIN user u15_ ON r14_.customer_id = u15_.id LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id WHERE a0_.id IN (SELECT a17_.id FROM announcement a17_ INNER JOIN category c18_ ON a17_.category_id = c18_.id INNER JOIN user u19_ ON a17_.user_id = u19_.id WHERE a17_.returned_at >= '2026-06-01 00:00:00' AND a17_.active = 1 AND c18_.name LIKE CONCAT('%', 'Appartement', '%') AND a17_.announcement_status = '1');

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->count (line 120)
7	ApiPlatform\Doctrine\Orm\Paginator->getTotalItems (line 49)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getPaginationData (line 71)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 102)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 56)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 95)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 79)
17	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 102)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	require_once (line 5)

2.38 ms
(4.81%)

SELECT DISTINCT a0_.id AS id_0, a0_.rate AS rate_1, a0_.created_at AS created_at_2 FROM announcement a0_ INNER JOIN category c1_ ON a0_.category_id = c1_.id INNER JOIN user u2_ ON a0_.user_id = u2_.id INNER JOIN location l3_ ON a0_.location_id = l3_.id LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id LEFT JOIN category c7_ ON c1_.parent_id = c7_.id LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id LEFT JOIN user u12_ ON f11_.user_id = u12_.id LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id LEFT JOIN user u15_ ON r14_.customer_id = u15_.id LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id WHERE a0_.id IN (SELECT a17_.id FROM announcement a17_ INNER JOIN category c18_ ON a17_.category_id = c18_.id INNER JOIN user u19_ ON a17_.user_id = u19_.id WHERE a17_.returned_at >= ? AND a17_.active = ? AND c18_.name LIKE CONCAT('%', ?, '%') AND a17_.announcement_status = ?) ORDER BY a0_.rate DESC, a0_.created_at DESC LIMIT 20

Parameters:

[
  "2026-06-01 00:00:00"
  1
  "Appartement"
  "1"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  DISTINCT a0_.id AS id_0,
  a0_.rate AS rate_1,
  a0_.created_at AS created_at_2
FROM
  announcement a0_
  INNER JOIN category c1_ ON a0_.category_id = c1_.id
  INNER JOIN user u2_ ON a0_.user_id = u2_.id
  INNER JOIN location l3_ ON a0_.location_id = l3_.id
  LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id
  LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id
  LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id
  LEFT JOIN category c7_ ON c1_.parent_id = c7_.id
  LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id
  LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id
  LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id
  LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id
  LEFT JOIN user u12_ ON f11_.user_id = u12_.id
  LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id
  LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id
  LEFT JOIN user u15_ ON r14_.customer_id = u15_.id
  LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id
WHERE
  a0_.id IN (
    SELECT
      a17_.id
    FROM
      announcement a17_
      INNER JOIN category c18_ ON a17_.category_id = c18_.id
      INNER JOIN user u19_ ON a17_.user_id = u19_.id
    WHERE
      a17_.returned_at >= ?
      AND a17_.active = ?
      AND c18_.name LIKE CONCAT('%', ?, '%')
      AND a17_.announcement_status = ?
  )
ORDER BY
  a0_.rate DESC,
  a0_.created_at DESC
LIMIT
  20

SELECT DISTINCT a0_.id AS id_0, a0_.rate AS rate_1, a0_.created_at AS created_at_2 FROM announcement a0_ INNER JOIN category c1_ ON a0_.category_id = c1_.id INNER JOIN user u2_ ON a0_.user_id = u2_.id INNER JOIN location l3_ ON a0_.location_id = l3_.id LEFT JOIN booking b4_ ON a0_.id = b4_.announcement_id LEFT JOIN announcement_media a5_ ON a0_.id = a5_.announcement_id LEFT JOIN proof_type p6_ ON a5_.proof_type_id = p6_.id LEFT JOIN category c7_ ON c1_.parent_id = c7_.id LEFT JOIN vehicle v8_ ON a0_.vehicle_id = v8_.id LEFT JOIN apartment a9_ ON a0_.property_id = a9_.id LEFT JOIN avatar a10_ ON u2_.avatar_id = a10_.id LEFT JOIN favorite f11_ ON a0_.id = f11_.announcement_id LEFT JOIN user u12_ ON f11_.user_id = u12_.id LEFT JOIN avatar a13_ ON u12_.avatar_id = a13_.id LEFT JOIN review r14_ ON a0_.id = r14_.announcement_id LEFT JOIN user u15_ ON r14_.customer_id = u15_.id LEFT JOIN avatar a16_ ON u15_.avatar_id = a16_.id WHERE a0_.id IN (SELECT a17_.id FROM announcement a17_ INNER JOIN category c18_ ON a17_.category_id = c18_.id INNER JOIN user u19_ ON a17_.user_id = u19_.id WHERE a17_.returned_at >= '2026-06-01 00:00:00' AND a17_.active = 1 AND c18_.name LIKE CONCAT('%', 'Appartement', '%') AND a17_.announcement_status = '1') ORDER BY a0_.rate DESC, a0_.created_at DESC LIMIT 20;

#	File/Call
1	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 31)
2	Doctrine\ORM\Query->_doExecute (line 330)
3	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1213)
4	Doctrine\ORM\AbstractQuery->execute (line 1167)
5	Doctrine\ORM\AbstractQuery->getScalarResult (line 942)
6	Doctrine\ORM\Tools\Pagination\Paginator->getIterator (line 153)
7	ApiPlatform\Doctrine\Orm\AbstractPaginator->getIterator (line 69)
8	ApiPlatform\Hydra\Serializer\CollectionNormalizer->getItemsData (line 90)
9	ApiPlatform\Serializer\AbstractCollectionNormalizer->normalize (line 109)
10	ApiPlatform\Hydra\Serializer\PartialCollectionViewNormalizer->normalize (line 56)
11	ApiPlatform\Hydra\Serializer\CollectionFiltersNormalizer->normalize (line 95)
12	Symfony\Component\Serializer\Debug\TraceableNormalizer->normalize (line 50)
13	Symfony\Component\Serializer\Serializer->normalize (line 152)
14	Symfony\Component\Serializer\Serializer->serialize (line 131)
15	Symfony\Component\Serializer\Debug\TraceableSerializer->serialize (line 44)
16	ApiPlatform\State\Processor\SerializeProcessor->process (line 79)
17	ApiPlatform\Symfony\EventListener\SerializeListener->onKernelView (line 102)
18	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 115)
19	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 206)
20	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 56)
21	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 129)
22	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 188)
23	Symfony\Component\HttpKernel\HttpKernel->handle (line 76)
24	Symfony\Component\HttpKernel\Kernel->handle (line 193)
25	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 35)
26	require_once (line 32)
27	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

Entities Mapping

Class	Mapping errors
App\Entity\Announcement	No errors.
App\Entity\Category	No errors.
App\Entity\User	The association App\Entity\User#transactions refers to the owning side field App\Entity\Transaction#user which does not exist.
App\Entity\Location	No errors.
App\Entity\Booking	The association App\Entity\Booking#user refers to the inverse side field App\Entity\User#bookings which does not exist. The field App\Entity\Booking#disputes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Booking\Dispute#booking does not contain the required 'inversedBy="disputes"' attribute.
App\Entity\AnnouncementMedia	No errors.
App\Entity\Favorite	No errors.
App\Entity\Review	No errors.
App\Entity\ProofType	No errors.
App\Entity\Vehicle	The association App\Entity\Vehicle#color refers to the inverse side field App\Entity\Color#vehicles which does not exist. The association App\Entity\Vehicle#gearboxType refers to the inverse side field App\Entity\GearboxType#vehicles which does not exist.
App\Entity\Apartment	No errors.
App\Entity\User\Avatar	No errors.

Symfony Profiler

GET https://test.app.zdeal.cm/api/announcements?active=true&announcementStatus=1&category.name=Appartement&page=1&returnedAt%5Bafter%5D=2026-06-01&user.id=

Configuration Settings

Theme

Page Width