GET https://prod-api.callme4d.com/v1/notificationfromadmin/notificationsfromadminforcaptain/199

Query Metrics

9 Database Queries
3 Different statements
5.84 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.74 ms
(47.02%)
7
SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.admin_notification_to_user_id AS admin_notification_to_user_id_5 FROM announcement_image_entity t0 WHERE t0.admin_notification_to_user_id = ?
Parameters:
[
  116
]
2.57 ms
(44.00%)
1
SELECT t0.id AS id_1, t0.app_type AS app_type_2, t0.title AS title_3, t0.msg AS msg_4, t0.user_id AS user_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM admin_notification_to_users_entity t0 WHERE t0.user_id IN (?, ?) AND t0.app_type IN (?, ?) ORDER BY t0.id DESC LIMIT 7
Parameters:
[
  0
  866
  "captains"
  "all"
]
0.52 ms
(8.98%)
1
SELECT t0.id AS id_1, t0.user_id AS user_id_2, t0.roles AS roles_3, t0.password AS password_4, t0.verification_status AS verification_status_5, t0.status AS status_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM user_entity t0 WHERE t0.user_id = ? LIMIT 1
Parameters:
[
  "966555786384"
]

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\UserEntity No errors.
App\Entity\RateEntity
  • The mappings App\Entity\RateEntity#rated and App\Entity\UserEntity#rateEntities are inconsistent with each other.
App\Entity\VerificationEntity No errors.
App\Entity\ResetPasswordOrderEntity No errors.
App\Entity\NotificationFirebaseTokenEntity No errors.
App\Entity\AdminNotificationToUsersEntity
  • The mappings App\Entity\AdminNotificationToUsersEntity#announcementImageEntities and App\Entity\AnnouncementImageEntity#AdminNotificationToUser are inconsistent with each other.
App\Entity\AnnouncementImageEntity
  • The association App\Entity\AnnouncementImageEntity#AdminNotificationToUser refers to the inverse side field App\Entity\AdminNotificationToUsersEntity#adminAnnouncementImageEntities which does not exist.