Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

1.45 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.99 ms	SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ?) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1 Parameters: [`"https://www.stores-faber.fr/_profiler/open" "forward"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE ( t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ? ) AND ( t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa' ) LIMIT 1 SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = 'https://www.stores-faber.fr/_profiler/open' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;
2	0.46 ms	SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ?) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1 Parameters: [`"/_profiler/open" "forward"`] View formatted query View runnable query Explain query SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE ( t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ? ) AND ( t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa' ) LIMIT 1 SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '/_profiler/open' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;

#▲

Time

Info

0.99 ms

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ?) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1

Parameters:

[
  "https://www.stores-faber.fr/_profiler/open"
  "forward"
]

View formatted query View runnable query Explain query

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FA'
    AND t0_.mac_app = 'fa'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = 'https://www.stores-faber.fr/_profiler/open' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;

0.46 ms

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = ? AND t0_.enabled = 1 AND t0_.type = ?) AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1

Parameters:

[
  "/_profiler/open"
  "forward"
]

View formatted query View runnable query Explain query

SELECT
  t0_.id AS id_0,
  t0_.original_route AS original_route_1,
  t0_.from_url AS from_url_2,
  t0_.to_url AS to_url_3,
  t0_.type AS type_4
FROM
  _route t0_
WHERE
  (
    t0_.to_url = ?
    AND t0_.enabled = 1
    AND t0_.type = ?
  )
  AND (
    t0_.mac_brand = 'FA'
    AND t0_.mac_app = 'fa'
  )
LIMIT
  1

SELECT t0_.id AS id_0, t0_.original_route AS original_route_1, t0_.from_url AS from_url_2, t0_.to_url AS to_url_3, t0_.type AS type_4 FROM _route t0_ WHERE (t0_.to_url = '/_profiler/open' AND t0_.enabled = 1 AND t0_.type = 'forward') AND (t0_.mac_brand = 'FA' AND t0_.mac_app = 'fa') LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
Mac\CoreBundle\Entity\Core\Route	No errors.
Mac\CoreBundle\Entity\QB\Query	No errors.

Symfony Profiler

http://www.stores-faber.fr/_fragment

Configuration Settings

Theme