Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

0.62 ms Query time

1 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼	Count	Info
0.39 ms (62.60%)	1	SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ WHERE c0_.name IN (?, ?) Parameters: [`"booking_non_returnable" "booking_non_returnable_off"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ WHERE c0_.name IN (?, ?) SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ WHERE c0_.name IN ('booking_non_returnable', 'booking_non_returnable_off');
0.23 ms (37.40%)	1	SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.label AS label_4, t0.description AS description_5, t0.value_type AS value_type_6, t0.value AS value_7, t0.iso AS iso_8, t0.is_api_available AS is_api_available_9, t0.asserts AS asserts_10, t0.options AS options_11, t0.sequence AS sequence_12, t0.is_collection AS is_collection_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM configuration t0 WHERE t0.name = ? LIMIT 1 Parameters: [`"booking_calendar_price"`] View formatted query View runnable query Explain query SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.label AS label_4, t0.description AS description_5, t0.value_type AS value_type_6, t0.value AS value_7, t0.iso AS iso_8, t0.is_api_available AS is_api_available_9, t0.asserts AS asserts_10, t0.options AS options_11, t0.sequence AS sequence_12, t0.is_collection AS is_collection_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM configuration t0 WHERE t0.name = ? LIMIT 1 SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.label AS label_4, t0.description AS description_5, t0.value_type AS value_type_6, t0.value AS value_7, t0.iso AS iso_8, t0.is_api_available AS is_api_available_9, t0.asserts AS asserts_10, t0.options AS options_11, t0.sequence AS sequence_12, t0.is_collection AS is_collection_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM configuration t0 WHERE t0.name = 'booking_calendar_price' LIMIT 1;

Time▼

Count

Info

0.39 ms
(62.60%)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ WHERE c0_.name IN (?, ?)

Parameters:

[
  "booking_non_returnable"
  "booking_non_returnable_off"
]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.value AS value_2
FROM
  configuration c0_
WHERE
  c0_.name IN (?, ?)

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.value AS value_2 FROM configuration c0_ WHERE c0_.name IN ('booking_non_returnable', 'booking_non_returnable_off');

0.23 ms
(37.40%)

SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.label AS label_4, t0.description AS description_5, t0.value_type AS value_type_6, t0.value AS value_7, t0.iso AS iso_8, t0.is_api_available AS is_api_available_9, t0.asserts AS asserts_10, t0.options AS options_11, t0.sequence AS sequence_12, t0.is_collection AS is_collection_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM configuration t0 WHERE t0.name = ? LIMIT 1

Parameters:

[
  "booking_calendar_price"
]

View formatted query View runnable query Explain query

SELECT
  t0.type AS type_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.label AS label_4,
  t0.description AS description_5,
  t0.value_type AS value_type_6,
  t0.value AS value_7,
  t0.iso AS iso_8,
  t0.is_api_available AS is_api_available_9,
  t0.asserts AS asserts_10,
  t0.options AS options_11,
  t0.sequence AS sequence_12,
  t0.is_collection AS is_collection_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15
FROM
  configuration t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.type AS type_1, t0.id AS id_2, t0.name AS name_3, t0.label AS label_4, t0.description AS description_5, t0.value_type AS value_type_6, t0.value AS value_7, t0.iso AS iso_8, t0.is_api_available AS is_api_available_9, t0.asserts AS asserts_10, t0.options AS options_11, t0.sequence AS sequence_12, t0.is_collection AS is_collection_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15 FROM configuration t0 WHERE t0.name = 'booking_calendar_price' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection
shuum	doctrine.dbal.shuum_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
shuum	doctrine.orm.shuum_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

default entity manager

Class	Mapping errors
AF\AdminBundle\Entity\OfferTrans	No errors.
App\Entity\App\OfferTrans	No errors.
AF\AdminBundle\Entity\EventTrans	No errors.
App\Entity\App\EventTrans	No errors.
AF\AdminBundle\Entity\Configuration	No errors.
App\Entity\App\Configuration	No errors.
AF\AdminBundle\Entity\Offer	No errors.
App\Entity\App\Offer	No errors.
AF\AdminBundle\Entity\Event	No errors.
App\Entity\App\Event	No errors.

shuum entity manager

Class	Mapping errors
AF\PHDatabase\Entity\PriceListCommodity	No errors.
AF\PHDatabase\Entity\PriceList	No errors.
AF\PHDatabase\Entity\Commodity	The field AF\PHDatabase\Entity\Commodity#billItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity AF\PHDatabase\Entity\BillItem#commodity does not contain the required 'inversedBy="billItems"' attribute.
AF\PHDatabase\Entity\RoomStandard	No errors.
AF\PHDatabase\Entity\BillItem	No errors.