Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

1 Different statements

0.92 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection

#▲	Time	Info
1	0.42 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 Parameters: [`"stripe_secret_key" 7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_secret_key' AND t0.`type` = 7 LIMIT 1;
2	0.19 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 Parameters: [`"stripe_publish_key" 7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_publish_key' AND t0.`type` = 7 LIMIT 1;
3	0.31 ms	SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 Parameters: [`"stripe_env" 7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1 SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_env' AND t0.`type` = 7 LIMIT 1;

#▲

Time

Info

0.42 ms

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1

Parameters:

[
  "stripe_secret_key"
  7
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.description AS description_4,
  t0.`type` AS type_5,
  t0.tags AS tags_6,
  t0.end_date AS end_date_7,
  t0.start_date AS start_date_8,
  t0.picture AS picture_9
FROM
  `settings` t0
WHERE
  t0.`key` = ?
  AND t0.`type` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_secret_key' AND t0.`type` = 7 LIMIT 1;

0.19 ms

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1

Parameters:

[
  "stripe_publish_key"
  7
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.description AS description_4,
  t0.`type` AS type_5,
  t0.tags AS tags_6,
  t0.end_date AS end_date_7,
  t0.start_date AS start_date_8,
  t0.picture AS picture_9
FROM
  `settings` t0
WHERE
  t0.`key` = ?
  AND t0.`type` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_publish_key' AND t0.`type` = 7 LIMIT 1;

0.31 ms

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = ? AND t0.`type` = ? LIMIT 1

Parameters:

[
  "stripe_env"
  7
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.`key` AS key_2,
  t0.`value` AS value_3,
  t0.description AS description_4,
  t0.`type` AS type_5,
  t0.tags AS tags_6,
  t0.end_date AS end_date_7,
  t0.start_date AS start_date_8,
  t0.picture AS picture_9
FROM
  `settings` t0
WHERE
  t0.`key` = ?
  AND t0.`type` = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.`key` AS key_2, t0.`value` AS value_3, t0.description AS description_4, t0.`type` AS type_5, t0.tags AS tags_6, t0.end_date AS end_date_7, t0.start_date AS start_date_8, t0.picture AS picture_9 FROM `settings` t0 WHERE t0.`key` = 'stripe_env' AND t0.`type` = 7 LIMIT 1;

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	No errors.
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://devus1.ctlf.co.uk/

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