Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

18.85 ms Query time

1 Invalid entities

Time▼	Count	Info
18.67 ms (99.05%)	1	SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.identificator AS identificator_2, s0_.value AS value_3 FROM settings s0_ Parameters: [] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.identificator AS identificator_2, s0_.value AS value_3 FROM settings s0_ SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.identificator AS identificator_2, s0_.value AS value_3 FROM settings s0_;
0.18 ms (0.95%)	1	SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.created_at AS created_at_2 FROM black_ip b0_ WHERE b0_.ip = ? Parameters: [`"216.73.216.110"`] View formatted query View runnable query Explain query SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.created_at AS created_at_2 FROM black_ip b0_ WHERE b0_.ip = ? SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.created_at AS created_at_2 FROM black_ip b0_ WHERE b0_.ip = '216.73.216.110';

Time▼

Count

Info

18.67 ms
(99.05%)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.identificator AS identificator_2, s0_.value AS value_3 FROM settings s0_

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.identificator AS identificator_2,
  s0_.value AS value_3
FROM
  settings s0_

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.identificator AS identificator_2, s0_.value AS value_3 FROM settings s0_;

0.18 ms
(0.95%)

SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.created_at AS created_at_2 FROM black_ip b0_ WHERE b0_.ip = ?

Parameters:

[
  "216.73.216.110"
]

View formatted query View runnable query Explain query

SELECT
  b0_.id AS id_0,
  b0_.ip AS ip_1,
  b0_.created_at AS created_at_2
FROM
  black_ip b0_
WHERE
  b0_.ip = ?

SELECT b0_.id AS id_0, b0_.ip AS ip_1, b0_.created_at AS created_at_2 FROM black_ip b0_ WHERE b0_.ip = '216.73.216.110';

No database queries were performed.

Name	Service
default	doctrine.dbal.default_connection
release	doctrine.dbal.release_connection

Name	Service
default	doctrine.orm.default_entity_manager
release	doctrine.orm.release_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
CoreBundle\Entity\BlackIp	No errors.
CoreBundle\Entity\Settings	No errors.
FOS\UserBundle\Model\User	No errors.
CoreBundle\Entity\User	The field CoreBundle\Entity\User#replenishRequests is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity CoreBundle\Entity\ReplenishRequest#user does not contain the required 'inversedBy="replenishRequests"' attribute.
CoreBundle\Entity\LanguageSettings	No errors.

No loaded entities.