Query Metrics

141 Database Queries
8 Different statements
37.40 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
28.77 ms
(76.92%)
134
SELECT t0.id AS id_1, t0.is_viewed AS is_viewed_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.notification_type_id AS notification_type_id_5, t0.user_id AS user_id_6 FROM notification t0 WHERE t0.id = ?
Parameters:
[
  75299
]
3.32 ms
(8.87%)
1
SELECT n0_.criticity AS criticity_0, n0_.name AS name_1, n0_.content_text AS content_text_2, n1_.created_at AS created_at_3, n1_.id AS id_4, n1_.updated_at AS updated_at_5 FROM notification n1_ INNER JOIN notification_type n0_ ON n1_.notification_type_id = n0_.id WHERE n1_.user_id = ? AND n0_.is_app = 1 AND n1_.is_viewed = 0 AND n0_.deleted_at IS NULL ORDER BY n1_.created_at DESC
Parameters:
[
  40
]
1.33 ms
(3.56%)
1
SELECT e0_.id AS id_0, e0_.title AS title_1, e0_.content AS content_2, e0_.status AS status_3, e0_.deleted_at AS deleted_at_4, e0_.created_at AS created_at_5, e0_.updated_at AS updated_at_6, e0_.event_id AS event_id_7, e0_.event_group_id AS event_group_id_8, e0_.deleted_by_id AS deleted_by_id_9, e0_.created_by_id AS created_by_id_10, e0_.updated_by_id AS updated_by_id_11 FROM event_post e0_ WHERE e0_.event_id = ?
Parameters:
[
  1
]
0.90 ms
(2.41%)
1
SELECT t0.id AS id_4, t0.gender AS gender_5, t0.email AS email_6, t0.roles AS roles_7, t0.password AS password_8, t0.last_logged_at AS last_logged_at_9, t0.firstname AS firstname_10, t0.lastname AS lastname_11, t0.active AS active_12, t0.phone AS phone_13, t0.deleted_at AS deleted_at_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.image_id AS image_id_17, t0.address_id AS address_id_18, t0.type, t3.is_visible AS is_visible_19, t3.cabinet_id AS cabinet_id_20 FROM user t0 LEFT JOIN user_administrator t1 ON t0.id = t1.id LEFT JOIN user_member t2 ON t0.id = t2.id LEFT JOIN user_broker t3 ON t0.id = t3.id WHERE t0.id = ?
Parameters:
[
  230
]
0.81 ms
(2.17%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.visible AS visible_4, t0.start_at AS start_at_5, t0.end_at AS end_at_6, t0.registration AS registration_7, t0.end_subscription_at AS end_subscription_at_8, t0.meet_link AS meet_link_9, t0.max_brokers AS max_brokers_10, t0.max_guests AS max_guests_11, t0.available_place AS available_place_12, t0.duration AS duration_13, t0.theme AS theme_14, t0.deleted_at AS deleted_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.category_id AS category_id_18, t0.address_id AS address_id_19, t0.event_group_id AS event_group_id_20, t0.deleted_by_id AS deleted_by_id_21, t0.created_by_id AS created_by_id_22, t0.updated_by_id AS updated_by_id_23 FROM event t0 WHERE t0.id = ?
Parameters:
[
  "1"
]
0.79 ms
(2.10%)
1
SELECT t0.id AS id_1, t0.participate AS participate_2, t0.present AS present_3, t0.comment AS comment_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.event_id AS event_id_8, t0.broker_id AS broker_id_9, t0.deleted_by_id AS deleted_by_id_10, t0.created_by_id AS created_by_id_11, t0.updated_by_id AS updated_by_id_12 FROM event_broker t0 WHERE t0.event_id = ? AND t0.broker_id = ? AND t0.participate = ? LIMIT 1
Parameters:
[
  1
  40
  1
]
0.78 ms
(2.08%)
1
SELECT t1.id AS id_2, t1.gender AS gender_3, t1.email AS email_4, t1.roles AS roles_5, t1.password AS password_6, t1.last_logged_at AS last_logged_at_7, t1.firstname AS firstname_8, t1.lastname AS lastname_9, t1.active AS active_10, t1.phone AS phone_11, t1.deleted_at AS deleted_at_12, t1.created_at AS created_at_13, t1.updated_at AS updated_at_14, t0.is_visible AS is_visible_15, t1.image_id AS image_id_16, t1.address_id AS address_id_17, t0.cabinet_id AS cabinet_id_18, t1.type FROM user_broker t0 INNER JOIN user t1 ON t0.id = t1.id WHERE t1.id = ?
Parameters:
[
  40
]
0.71 ms
(1.90%)
1
SELECT e0_.id AS id_0, e1_.participate AS participate_1 FROM event_broker e1_ INNER JOIN event e0_ ON e1_.event_id = e0_.id WHERE e1_.broker_id = ? AND e1_.deleted_at IS NULL AND e0_.visible = 1 AND e0_.deleted_at IS NULL AND (e0_.start_at >= ? OR e0_.end_at >= ?)
Parameters:
[
  40
  "2025-09-23 19:08:07"
  "2025-09-23 19:08:07"
]

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\User No errors.
App\Entity\User\Broker No errors.
App\Entity\Image No errors.
App\Entity\Address No errors.
App\Entity\Cabinet No errors.
App\Entity\Settings\Notification No errors.
App\Entity\Settings\NotificationType No errors.
App\Entity\Question\Question No errors.
App\Entity\Event\EventBroker No errors.
App\Entity\Event\Event
  • The mappings App\Entity\Event\Event#category and App\Entity\Event\EventCategory#events are inconsistent with each other.
App\Entity\Event\EventCategory
  • The association App\Entity\Event\EventCategory#events refers to the owning side field App\Entity\Event\Event#categoy which does not exist.
App\Entity\Event\EventGroup No errors.
Vich\UploaderBundle\Entity\File No errors.
App\Entity\Document\Document No errors.
App\Entity\Event\EventOption No errors.
App\Entity\Event\EventPost No errors.
App\Entity\User\Administrator No errors.
App\Entity\User\Member No errors.
App\Entity\Event\EventBrokerOption No errors.
App\Entity\Event\EventBrokerGuest No errors.