Symfony Profiler

Query Metrics

2 Database Queries

2 Different statements

11.59 ms Query time

0 Invalid entities

0 Managed entities

#▲	Time	Info
1	4.91 ms	SELECT DISTINCT i0_.id AS id_0 FROM icecat_data i0_ LIMIT 30 OFFSET 38790 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT i0_.id AS id_0 FROM icecat_data i0_ LIMIT 30 OFFSET 38790 SELECT DISTINCT i0_.id AS id_0 FROM icecat_data i0_ LIMIT 30 OFFSET 38790;
2	6.69 ms	SELECT count() AS sclr_0 FROM icecat_data i0_ Parameters: [] View formatted query View runnable query Explain query SELECT count() AS sclr_0 FROM icecat_data i0_ SELECT count(*) AS sclr_0 FROM icecat_data i0_;

#▲

Time

Info

4.91 ms

SELECT DISTINCT i0_.id AS id_0 FROM icecat_data i0_ LIMIT 30 OFFSET 38790

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT i0_.id AS id_0
FROM
  icecat_data i0_
LIMIT
  30
OFFSET
  38790

SELECT DISTINCT i0_.id AS id_0 FROM icecat_data i0_ LIMIT 30 OFFSET 38790;

6.69 ms

SELECT count(*) AS sclr_0 FROM icecat_data i0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  count(*) AS sclr_0
FROM
  icecat_data i0_

SELECT count(*) AS sclr_0 FROM icecat_data i0_;

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\IcecatData	No errors.