POST https://prod-api.callme4d.com/v1/geodistance/distanceanddeliverycostbymapurlandcoordinates

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.53 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:
[
  "966503172022"
]
2 1.65 ms
SELECT s0_.id AS id_0 FROM store_owner_profile_entity s0_ WHERE s0_.store_owner_id = ?
Parameters:
[
  3839
]
3 0.73 ms
SELECT s0_.package_id AS sclr_0, s0_.id AS id_1, s0_.status AS status_2, p1_.id AS id_3, p1_.name AS name_4, p1_.order_count AS order_count_5, p1_.type AS type_6, p1_.geographical_range AS geographical_range_7, p1_.extra_cost AS extra_cost_8, p1_.cost AS cost_9, p1_.opening_order_cost AS opening_order_cost_10, p1_.one_kilometer_cost AS one_kilometer_cost_11, p1_.tax_on AS tax_on_12, p1_.delivery_cost_type AS delivery_cost_type_13, p1_.order_cost_limit AS order_cost_limit_14, p1_.delivery_cost_fixed AS delivery_cost_fixed_15, s2_.remaining_orders AS remaining_orders_16, s2_.remaining_cars AS remaining_cars_17, s2_.status AS status_18 FROM subscription_entity s0_ INNER JOIN package_entity p1_ ON (p1_.id = s0_.package_id) INNER JOIN subscription_details_entity s2_ ON (s0_.id = s2_.last_subscription_id) WHERE s2_.store_owner_id = ?
Parameters:
[
  2799
]
4 4.97 ms
SELECT t0.id AS id_1, t0.store_owner_id AS store_owner_id_2, t0.store_owner_name AS store_owner_name_3, t0.images AS images_4, t0.status AS status_5, t0.city AS city_6, t0.store_category_id AS store_category_id_7, t0.phone AS phone_8, t0.opening_time AS opening_time_9, t0.closing_time AS closing_time_10, t0.commission AS commission_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.employee_count AS employee_count_15, t0.complete_account_status AS complete_account_status_16, t0.profit_margin AS profit_margin_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.opening_subscription_without_payment AS opening_subscription_without_payment_20, t0.release_version AS release_version_21, t0.platform_os AS platform_os_22, t0.store_name_english AS store_name_english_23, t0.deleted_at AS deleted_at_24, t0.tax_registration_number AS tax_registration_number_25, t0.commercial_register AS commercial_register_26, t0.room_id AS room_id_27, t0.last_support_msg_date AS last_support_msg_date_28, t0.un_seen_support_msg_count AS un_seen_support_msg_count_29, t0.alshrouq_token AS alshrouq_token_30, t0.district AS district_31, t0.street AS street_32, t0.postal_code AS postal_code_33, t0.building_number AS building_number_34, t0.is_vat_registered AS is_vat_registered_35, t36.id AS id_37, t36.subscription_cost_limit AS subscription_cost_limit_38, t36.created_at AS created_at_39, t36.updated_at AS updated_at_40, t36.auto_whatsapp_order AS auto_whatsapp_order_41, t36.tax_rate AS tax_rate_42, t36.group_id AS group_id_43, t36.template_cost AS template_cost_44, t36.fai_city AS fai_city_45, t36.store_owner_profile_id AS store_owner_profile_id_46, t0.deleted_by_id AS deleted_by_id_47, t48.id AS id_49, t48.tax_for AS tax_for_50, t48.tax_type AS tax_type_51, t48.tax_amount AS tax_amount_52, t48.extra_cost_for AS extra_cost_for_53, t48.extra_cost_type AS extra_cost_type_54, t48.extra_cost_amount AS extra_cost_amount_55, t48.created_at AS created_at_56, t48.updated_at AS updated_at_57, t48.store_id AS store_id_58 FROM store_owner_profile_entity t0 LEFT JOIN store_owner_preference_entity t36 ON t36.store_owner_profile_id = t0.id LEFT JOIN store_tax_entity t48 ON t48.store_id = t0.id WHERE t0.store_owner_id = ? LIMIT 1
Parameters:
[
  3839
]
5 0.48 ms
SELECT s0_.order_distance_limit AS order_distance_limit_0 FROM store_owner_branch_entity s0_ WHERE s0_.id = ?
Parameters:
[
  1138
]

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\StoreOwnerProfileEntity 1
App\Entity\StoreOwnerPreferenceEntity 1
App\Entity\StoreTaxEntity 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\StoreOwnerProfileEntity
  • The mappings App\Entity\StoreOwnerProfileEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerProfile are inconsistent with each other.
App\Entity\SubscriptionEntity No errors.
App\Entity\PackageEntity No errors.
App\Entity\SubscriptionDetailsEntity No errors.
App\Entity\StoreOwnerPreferenceEntity No errors.
App\Entity\AdminProfileEntity No errors.
App\Entity\StoreTaxEntity 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.
App\Entity\OrderEntity
  • The mappings App\Entity\OrderEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#orderId are inconsistent with each other.
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\StoreOwnerPaymentEntity No errors.
App\Entity\StoreOwnerDuesFromCashOrdersEntity No errors.
App\Entity\OrderLogEntity No errors.
App\Entity\EPaymentFromStoreEntity No errors.
App\Entity\EPaymentFromStoreLogEntity No errors.
App\Entity\AutoFinancialSystemEntity No errors.
App\Entity\TapBusinessEntity No errors.
App\Entity\StoreExpenseEntity No errors.
App\Entity\AutoClientAnalyticsEntity No errors.
App\Entity\CustomCategoryEntity No errors.
App\Entity\InvoiceEntity No errors.