PUT https://prod-api.callme4d.com/v1/admin/captain/unseensupportmsgcount/1878

Query Metrics

5 Database Queries
5 Different statements
5.22 ms Query time
4 Invalid entities
3 Managed entities

Queries

Group similar statements

# Time Info
1 0.43 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:
[
  "966551111113"
]
2 0.70 ms
SELECT t0.id AS id_1, t0.captain_id AS captain_id_2, t0.captain_name AS captain_name_3, t0.location AS location_4, t0.age AS age_5, t0.car AS car_6, t0.salary AS salary_7, t0.status AS status_8, t0.bounce AS bounce_9, t0.phone AS phone_10, t0.is_online AS is_online_11, t0.bank_name AS bank_name_12, t0.bank_account_number AS bank_account_number_13, t0.stc_pay AS stc_pay_14, t0.complete_account_status AS complete_account_status_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.address AS address_18, t0.city AS city_19, t0.release_version AS release_version_20, t0.platform_os AS platform_os_21, t0.deleted_at AS deleted_at_22, t0.room_id AS room_id_23, t0.last_support_msg_date AS last_support_msg_date_24, t0.un_seen_support_msg_count AS un_seen_support_msg_count_25, t0.cities AS cities_26, t0.car_type AS car_type_27, t0.deleted_by_id AS deleted_by_id_28, t0.city_id_id AS city_id_id_29 FROM captain_entity t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1878
]
3 0.28 ms
"START TRANSACTION"
Parameters:
[]
4 0.71 ms
UPDATE captain_entity SET un_seen_support_msg_count = ?, updated_at = ? WHERE id = ?
Parameters:
[
  0
  "2025-12-17 10:30:09"
  1878
]
5 3.10 ms
"COMMIT"
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\UserEntity 1
App\Entity\CaptainEntity 1
App\Entity\CityEntity 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\CaptainEntity
  • The mappings App\Entity\CaptainEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#captainProfile are inconsistent with each other.
  • The association App\Entity\CaptainEntity#deletedBy refers to the inverse side field App\Entity\AdminProfileEntity#deletedCaptainsProfiles which does not exist.
  • The mappings App\Entity\CaptainEntity#cityId and App\Entity\CityEntity#captains are inconsistent with each other.
App\Entity\AdminProfileEntity No errors.
App\Entity\CityEntity
  • The association App\Entity\CityEntity#captains refers to the owning side field App\Entity\CaptainEntity#cityEntity which does not exist.
  • The association App\Entity\CityEntity#stores refers to the owning side field App\Entity\StoreOwnerProfileEntity#cityEntity which does not exist.
App\Entity\OrderTimeLineEntity
  • The association App\Entity\OrderTimeLineEntity#orderId refers to the inverse side field App\Entity\OrderEntity#OrderTimeLineEntity which does not exist.
  • The association App\Entity\OrderTimeLineEntity#captainProfile refers to the inverse side field App\Entity\CaptainEntity#OrderTimeLineEntity which does not exist.
  • The association App\Entity\OrderTimeLineEntity#storeOwnerProfile refers to the inverse side field App\Entity\StoreOwnerProfileEntity#OrderTimeLineEntity which does not exist.
  • The association App\Entity\OrderTimeLineEntity#storeOwnerBranch refers to the inverse side field App\Entity\StoreOwnerBranchEntity#OrderTimeLineEntity which does not exist.
App\Entity\CaptainPaymentEntity No errors.
App\Entity\CaptainFinancialSystemDetailEntity No errors.
App\Entity\CaptainFinancialDuesEntity No errors.
App\Entity\CaptainAmountFromOrderCashEntity No errors.
App\Entity\OrderLogEntity No errors.
App\Entity\CaptainFinancialDemandEntity No errors.
App\Entity\CaptainOrderFinancialEntity No errors.
App\Entity\CaptainPresenceEntity No errors.
App\Entity\OrderStatusEntity No errors.