GET https://prod-api.callme4d.com/v1/order/closestorders

Query Metrics

5 Database Queries
5 Different statements
48.69 ms Query time
5 Invalid entities
1 Managed entities

Queries

Group similar statements

# Time Info
1 0.40 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:
[
  "966570649726"
]
2 11.91 ms
SELECT o0_.id AS id_0, o0_.primary_order_id AS sclr_1 FROM order_entity o0_ WHERE o0_.primary_order_id <> ? ORDER BY o0_.id DESC
Parameters:
[
  ""
]
3 2.05 ms
SELECT c0_.status AS status_0, c0_.is_online AS is_online_1, c0_.cities AS cities_2, c1_.id AS id_3 FROM captain_entity c0_ LEFT JOIN city_entity c1_ ON (c1_.id = c0_.city_id_id) WHERE c0_.captain_id = ?
Parameters:
[
  4145
]
4 1.44 ms
SELECT c0_.status AS status_0, c0_.captain_financial_system_type AS captain_financial_system_type_1, c0_.captain_financial_system_id AS captain_financial_system_id_2, c1_.id AS id_3 FROM captain_entity c1_ LEFT JOIN captain_financial_system_detail_entity c0_ ON (c0_.captain_id = c1_.id) WHERE c1_.captain_id = ? ORDER BY c0_.id DESC LIMIT 1
Parameters:
[
  4145
]
5 32.88 ms
SELECT DISTINCT o0_.id AS id_0, o0_.payment AS payment_1, o0_.order_cost AS order_cost_2, o0_.order_type AS order_type_3, o0_.note AS note_4, o0_.state AS state_5, o0_.order_is_main AS order_is_main_6, o0_.created_at AS created_at_7, s1_.id AS id_8, s1_.name AS name_9, c2_.id AS id_10, o3_.store_branch_to_client_duration AS store_branch_to_client_duration_11, o3_.store_branch_to_client_distance AS store_branch_to_client_distance_12, o3_.captain_to_store_branch_duration AS captain_to_store_branch_duration_13, o3_.captain_to_store_branch_distance AS captain_to_store_branch_distance_14, o3_.dest_lat AS dest_lat_15, o3_.dest_lon AS dest_lon_16, o3_.dest_link AS dest_link_17, o3_.source_lat AS source_lat_18, o3_.source_lon AS source_lon_19, o4_.status AS status_20 FROM order_entity o0_ LEFT JOIN order_status_entity o4_ ON (o4_.order_id_id = o0_.id) LEFT JOIN order_geo_entity o3_ ON (o3_.order_id_id = o0_.id) LEFT JOIN store_order_details_entity s5_ ON (o0_.id = s5_.order_id_id) LEFT JOIN store_owner_branch_entity s1_ ON (s1_.id = s5_.branch_id) LEFT JOIN city_entity c2_ ON (c2_.id = s1_.city_id_id) WHERE o0_.state = ? AND o4_.is_hide = ? AND (o0_.delivery_date <= ?) AND o0_.visibility LIKE ? AND ((s1_.city_id_id IS NULL) OR (s1_.city_id_id IN (?))) ORDER BY o0_.id DESC
Parameters:
[
  "pending"
  2
  "2025-12-16 16:13:04"
  "%1%"
  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.

Managed Entities

default entity manager

Class Amount of managed objects
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\OrderEntity
  • The mappings App\Entity\OrderEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#orderId are inconsistent with each other.
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\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\CaptainFinancialSystemDetailEntity No errors.
App\Entity\OrderStatusEntity No errors.
App\Entity\OrderGeoEntity No errors.
App\Entity\StoreOrderDetailsEntity No errors.
App\Entity\StoreOwnerBranchEntity
  • The mappings App\Entity\StoreOwnerBranchEntity#orderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerBranch are inconsistent with each other.
  • The mappings App\Entity\StoreOwnerBranchEntity#cityId and App\Entity\CityEntity#stores are inconsistent with each other.