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

Query Metrics

9 Database Queries
3 Different statements
2.41 ms Query time
3 Invalid entities
14 Managed entities

Queries

Group similar statements

# Time Info
1 0.32 ms
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:
[
  "966577469276"
]
2 0.52 ms
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
  3690
  "captains"
  "all"
]
3 0.33 ms
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:
[
  132
]
4 0.18 ms
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:
[
  131
]
5 0.19 ms
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:
[
  130
]
6 0.31 ms
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:
[
  129
]
7 0.21 ms
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:
[
  128
]
8 0.17 ms
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:
[
  127
]
9 0.18 ms
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:
[
  126
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\AdminNotificationToUsersEntity 7
App\Entity\AnnouncementImageEntity 6
App\Entity\UserEntity 1

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.