Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

1 Different statements

0.60 ms Query time

1 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.39 ms	SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ? Parameters: [`"favicon" 9`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ? SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = 'favicon' AND s0_.`type` = 9;
2	0.20 ms	SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ? Parameters: [`"login_cover" 9`] View formatted query View runnable query Explain query SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ? SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = 'login_cover' AND s0_.`type` = 9;

#▲

Time

Info

0.39 ms

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ?

Parameters:

[
  "favicon"
  9
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2,
  s0_.description AS description_3,
  s0_.`type` AS type_4,
  s0_.tags AS tags_5,
  s0_.end_date AS end_date_6,
  s0_.start_date AS start_date_7,
  s0_.picture AS picture_8
FROM
  `settings` s0_
WHERE
  s0_.`key` = ?
  AND s0_.`type` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = 'favicon' AND s0_.`type` = 9;

0.20 ms

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = ? AND s0_.`type` = ?

Parameters:

[
  "login_cover"
  9
]

View formatted query View runnable query Explain query

SELECT
  s0_.id AS id_0,
  s0_.`key` AS key_1,
  s0_.`value` AS value_2,
  s0_.description AS description_3,
  s0_.`type` AS type_4,
  s0_.tags AS tags_5,
  s0_.end_date AS end_date_6,
  s0_.start_date AS start_date_7,
  s0_.picture AS picture_8
FROM
  `settings` s0_
WHERE
  s0_.`key` = ?
  AND s0_.`type` = ?

SELECT s0_.id AS id_0, s0_.`key` AS key_1, s0_.`value` AS value_2, s0_.description AS description_3, s0_.`type` AS type_4, s0_.tags AS tags_5, s0_.end_date AS end_date_6, s0_.start_date AS start_date_7, s0_.picture AS picture_8 FROM `settings` s0_ WHERE s0_.`key` = 'login_cover' AND s0_.`type` = 9;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
paf	doctrine.dbal.paf_connection
paf_us	doctrine.dbal.paf_us_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
paf	doctrine.orm.paf_entity_manager
paf_us	doctrine.orm.paf_us_entity_manager
auto_mapping	doctrine.orm.auto_mapping_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
AdminBundle\Entity\Area	No errors.
AdminBundle\Entity\Booking	The association AdminBundle\Entity\Booking#tickets refers to the owning side field AdminBundle\Entity\Ticket#booking which is not defined as association, but as field. The association AdminBundle\Entity\Booking#tickets refers to the owning side field AdminBundle\Entity\Ticket#booking which does not exist.
AdminBundle\Entity\BookingExtra	No errors.
AdminBundle\Entity\BookingRequest	No errors.
AdminBundle\Entity\CarType	No errors.
AdminBundle\Entity\CarTypeAreaPrice	No errors.
AdminBundle\Entity\CarTypePrice	No errors.
AdminBundle\Entity\Driver	No errors.
AdminBundle\Entity\PeriodSettings	No errors.
AdminBundle\Entity\Settings	No errors.
Sonata\UserBundle\Entity\BaseUser	No errors.
AdminBundle\Entity\User	No errors.
AdminBundle\Entity\Tours	No errors.
AdminBundle\Entity\Zone	No errors.
AdminBundle\Entity\DriverHistoryQueue	No errors.

paf entity manager

No loaded entities.

paf_us entity manager

No loaded entities.

auto_mapping entity manager

No loaded entities.

Symfony Profiler

https://dev25.ctlf.co.uk/client/login

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

default entity manager

paf entity manager

paf_us entity manager

auto_mapping entity manager