Symfony Profiler

Query Metrics

1 Database Queries

1 Different statements

1291.57 ms Query time

0 Invalid entities

18 Cache hits

0 Cache misses

0 Cache puts

Time▼	Count	Info
1291.57 ms (100.00%)	1	SELECT u0_.ap_domain AS ap_domain_0 FROM "user" u0_ WHERE u0_.ap_domain IS NOT NULL GROUP BY u0_.ap_domain ORDER BY COUNT(u0_.id) DESC Parameters: [] View formatted query View runnable query Explain query SELECT u0_.ap_domain AS ap_domain_0 FROM "user" u0_ WHERE u0_.ap_domain IS NOT NULL GROUP BY u0_.ap_domain ORDER BY COUNT(u0_.id) DESC SELECT u0_.ap_domain AS ap_domain_0 FROM "user" u0_ WHERE u0_.ap_domain IS NOT NULL GROUP BY u0_.ap_domain ORDER BY COUNT(u0_.id) DESC;

Time▼

Count

Info

1291.57 ms
(100.00%)

SELECT u0_.ap_domain AS ap_domain_0 FROM "user" u0_ WHERE u0_.ap_domain IS NOT NULL GROUP BY u0_.ap_domain ORDER BY COUNT(u0_.id) DESC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  u0_.ap_domain AS ap_domain_0
FROM
  "user" u0_
WHERE
  u0_.ap_domain IS NOT NULL
GROUP BY
  u0_.ap_domain
ORDER BY
  COUNT(u0_.id) DESC

SELECT u0_.ap_domain AS ap_domain_0 FROM "user" u0_ WHERE u0_.ap_domain IS NOT NULL GROUP BY u0_.ap_domain ORDER BY COUNT(u0_.id) DESC;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

18 Hits

0 Misses

0 Puts

Region	Hits
app_entity_settings	16
app_entity_magazine	2

Class	Mapping errors
App\Entity\Settings	No errors.
App\Entity\User	No errors.
App\Entity\Magazine	No errors.
App\Entity\Image	No errors.
App\Entity\Moderator	No errors.
App\Entity\MagazineOwnershipRequest	No errors.
App\Entity\ModeratorRequest	No errors.
App\Entity\Entry	No errors.
App\Entity\Post	No errors.
App\Entity\MagazineSubscription	No errors.
App\Entity\MagazineBan	No errors.
App\Entity\Report	No errors.
App\Entity\Badge	No errors.
App\Entity\MagazineLog	No errors.
App\Entity\Award	No errors.
App\Entity\CategoryMagazine	No errors.