Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

41.15 ms Query time

0 Invalid entities

Time▼	Count	Info
26.25 ms (63.78%)	1	SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_ Parameters: [] View formatted query View runnable query Explain query SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_ SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_;
14.90 ms (36.22%)	1	SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 93030 Parameters: [] View formatted query View runnable query Explain query SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 93030 SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 93030;

Time▼

Count

Info

26.25 ms
(63.78%)

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(DISTINCT b0_.id) AS sclr_0
FROM
  business_information b0_

SELECT COUNT(DISTINCT b0_.id) AS sclr_0 FROM business_information b0_;

14.90 ms
(36.22%)

SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 93030

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DISTINCT b0_.id AS id_0
FROM
  business_information b0_
LIMIT
  21 OFFSET 93030

SELECT DISTINCT b0_.id AS id_0 FROM business_information b0_ LIMIT 21 OFFSET 93030;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\BusinessInformation	No errors.