Query Metrics

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

Queries

Group similar statements

# Time Info
1 2.83 ms
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 1.13 ms
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:
[]
3 1.41 ms
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"
]
4 1.00 ms
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
]
5 0.80 ms
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:
[
  2
]
6 0.94 ms
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:
[
  3
]
7 1.66 ms
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
]

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.