Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

8.70 ms Query time

1 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	8.70 ms	SELECT c.id, COUNT(m.id) AS countMandate FROM public.mandate AS m JOIN public.property AS p ON m.property_id = p.id JOIN public.abstract_collaborator AS c ON p.collaborator_id = c.id GROUP BY c.id ORDER BY countMandate DESC LIMIT 5; Parameters: [] View formatted query View runnable query Explain query SELECT c.id, COUNT(m.id) AS countMandate FROM public.mandate AS m JOIN public.property AS p ON m.property_id = p.id JOIN public.abstract_collaborator AS c ON p.collaborator_id = c.id GROUP BY c.id ORDER BY countMandate DESC LIMIT 5; SELECT c.id, COUNT(m.id) AS countMandate FROM public.mandate AS m JOIN public.property AS p ON m.property_id = p.id JOIN public.abstract_collaborator AS c ON p.collaborator_id = c.id GROUP BY c.id ORDER BY countMandate DESC LIMIT 5;;

#▲

Time

Info

8.70 ms

SELECT  c.id, COUNT(m.id) AS countMandate 
                  FROM public.mandate AS m
                  JOIN public.property AS p
                    ON m.property_id = p.id
                  JOIN public.abstract_collaborator AS c
                    ON p.collaborator_id = c.id
                  GROUP BY c.id
                  ORDER BY countMandate DESC
                  LIMIT 5;

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  c.id,
  COUNT(m.id) AS countMandate
FROM
  public.mandate AS m
  JOIN public.property AS p ON m.property_id = p.id
  JOIN public.abstract_collaborator AS c ON p.collaborator_id = c.id
GROUP BY
  c.id
ORDER BY
  countMandate DESC
LIMIT
  5;

SELECT  c.id, COUNT(m.id) AS countMandate 
                  FROM public.mandate AS m
                  JOIN public.property AS p
                    ON m.property_id = p.id
                  JOIN public.abstract_collaborator AS c
                    ON p.collaborator_id = c.id
                  GROUP BY c.id
                  ORDER BY countMandate DESC
                  LIMIT 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\AbstractCollaborator	No errors.
App\Entity\Agent	The mappings App\Entity\Agent#prescriberProperties and App\Entity\Property#prescriber are inconsistent with each other.

Symfony Profiler

https://api-demo.web.milkiya.ma/api/internal/best/agent

Configuration Settings

Theme