Query Metrics

7 Database Queries
5 Different statements
9.77 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.83 ms
(29.00%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.duration AS duration_4, t0.is_visible AS is_visible_5 FROM plan t0 WHERE t0.is_visible = ?
Parameters:
[
  1
]
2.74 ms
(28.04%)
3
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0 INNER JOIN plan_option ON t0.id = plan_option.option_id WHERE plan_option.plan_id = ?
Parameters:
[
  1
]
1.66 ms
(16.95%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.is_visible AS is_visible_4, t0.joined_at AS joined_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.thumbnail_id AS thumbnail_id_8 FROM cms_partner t0 WHERE t0.is_visible = ?
Parameters:
[
  1
]
1.41 ms
(14.45%)
1
SELECT t0.id AS id_1, t0.type AS type_2, t0.title AS title_3, t0.sub_title AS sub_title_4, t0.content AS content_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.direction AS direction_8, t0.is_public AS is_public_9, t0.path AS path_10, t0.url AS url_11, t0.is_menu AS is_menu_12, t0.background_id AS background_id_13, t0.image_id AS image_id_14, t0.created_by_id AS created_by_id_15, t0.parent_id AS parent_id_16 FROM cms t0 WHERE t0.is_menu = ? AND t0.is_public = ? AND t0.type = ?
Parameters:
[
  1
  1
  "Page"
]
1.13 ms
(11.56%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.price AS price_4 FROM `option` t0
Parameters:
[]

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
App\Entity\Plan No errors.
App\Entity\Option No errors.
App\Entity\Cms No errors.
App\Entity\Attachment No errors.
App\Entity\User
  • The field 'App\Entity\User#bannedAt' has the property type 'DateTimeInterface' that differs from the metadata field type 'string' returned by the 'string' DBAL type.
App\Entity\CmsPartner No errors.