Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.88 ms Query time

0 Invalid entities

Time▼	Count	Info
0.45 ms (50.63%)	1	SELECT DISTINCT o0_.domain AS domain_0 FROM openx.ox_ad_domains o0_ WHERE o0_.status = ? ORDER BY o0_.domain_id ASC Parameters: [`0`] View formatted query View runnable query Explain query SELECT DISTINCT o0_.domain AS domain_0 FROM openx.ox_ad_domains o0_ WHERE o0_.status = ? ORDER BY o0_.domain_id ASC SELECT DISTINCT o0_.domain AS domain_0 FROM openx.ox_ad_domains o0_ WHERE o0_.status = 0 ORDER BY o0_.domain_id ASC;
0.44 ms (49.37%)	1	SELECT t0.domain_pool AS domain_pool_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4 FROM domain_variation t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.domain_pool AS domain_pool_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4 FROM domain_variation t0 SELECT t0.domain_pool AS domain_pool_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4 FROM domain_variation t0;

Time▼

Count

Info

0.45 ms
(50.63%)

SELECT DISTINCT o0_.domain AS domain_0 FROM openx.ox_ad_domains o0_ WHERE o0_.status = ? ORDER BY o0_.domain_id ASC

Parameters:

[
  0
]

View formatted query View runnable query Explain query

SELECT
  DISTINCT o0_.domain AS domain_0
FROM
  openx.ox_ad_domains o0_
WHERE
  o0_.status = ?
ORDER BY
  o0_.domain_id ASC

SELECT DISTINCT o0_.domain AS domain_0 FROM openx.ox_ad_domains o0_ WHERE o0_.status = 0 ORDER BY o0_.domain_id ASC;

0.44 ms
(49.37%)

SELECT t0.domain_pool AS domain_pool_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4 FROM domain_variation t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.domain_pool AS domain_pool_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.updated AS updated_4
FROM
  domain_variation t0

SELECT t0.domain_pool AS domain_pool_1, t0.id AS id_2, t0.created AS created_3, t0.updated AS updated_4 FROM domain_variation t0;

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\AbstractBaseEntity	No errors.
App\Entity\DomainVariation	No errors.
App\Entity\GeoEdge\AdDomain	No errors.