Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

11.12 ms Query time

0 Invalid entities

0 Managed entities

#▲	Time	Info
1	5.60 ms	SELECT DISTINCT c0_.id AS id_0, c0_.sku AS sku_1 FROM category c0_ ORDER BY c0_.sku ASC LIMIT 20 OFFSET 36840 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT c0_.id AS id_0, c0_.sku AS sku_1 FROM category c0_ ORDER BY c0_.sku ASC LIMIT 20 OFFSET 36840 SELECT DISTINCT c0_.id AS id_0, c0_.sku AS sku_1 FROM category c0_ ORDER BY c0_.sku ASC LIMIT 20 OFFSET 36840;
2	5.52 ms	SELECT count() AS sclr_0 FROM category c0_ Parameters: [] View formatted query View runnable query Explain query SELECT count() AS sclr_0 FROM category c0_ SELECT count(*) AS sclr_0 FROM category c0_;

#▲

Time

Info

5.60 ms

SELECT DISTINCT c0_.id AS id_0, c0_.sku AS sku_1 FROM category c0_ ORDER BY c0_.sku ASC LIMIT 20 OFFSET 36840

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.sku AS sku_1
FROM
  category c0_
ORDER BY
  c0_.sku ASC
LIMIT
  20
OFFSET
  36840

SELECT DISTINCT c0_.id AS id_0, c0_.sku AS sku_1 FROM category c0_ ORDER BY c0_.sku ASC LIMIT 20 OFFSET 36840;

5.52 ms

SELECT count(*) AS sclr_0 FROM category c0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(*) AS sclr_0
FROM
  category c0_

SELECT count(*) AS sclr_0 FROM category c0_;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Amount of managed objects

Class	Mapping errors
App\Entity\Category	No errors.