PUT https://prod-api.callme4d.com/v1/whatsapp/client/ischatseen

Query Metrics

2 Database Queries
2 Different statements
1.12 ms Query time
2 Invalid 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:
[
  "966566405643"
]
2 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.phone AS phone_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.status AS status_6, t0.location AS location_7, t0.support AS support_8, t0.client_last_action AS client_last_action_9, t0.bot_last_action AS bot_last_action_10, t0.client_last_intent AS client_last_intent_11, t0.is_last_bot_action_succeeded AS is_last_bot_action_succeeded_12, t0.store_branch_phone AS store_branch_phone_13, t0.last_sent_message_date AS last_sent_message_date_14, t0.is_chat_seen AS is_chat_seen_15, t0.has_ongoing_chat_request AS has_ongoing_chat_request_16, t0.support_started_by AS support_started_by_17, t0.is_support_requested AS is_support_requested_18, t0.email AS email_19, t0.customer_id AS customer_id_20, t0.language AS language_21, t0.last_client_msg_date AS last_client_msg_date_22, t23.id AS id_24, t23.branches AS branches_25, t23.has_no_order AS has_no_order_26, t23.max_distance AS max_distance_27, t23.cash_payment AS cash_payment_28, t23.card_payment AS card_payment_29, t23.mada_card AS mada_card_30, t23.visa_card AS visa_card_31, t23.delivery AS delivery_32, t23.pickup AS pickup_33, t23.completed AS completed_34, t23.unconfirmed_by_client AS unconfirmed_by_client_35, t23.ongoing AS ongoing_36, t23.cancelled_by_client AS cancelled_by_client_37, t23.cancelled_by_store AS cancelled_by_store_38, t23.cancelled AS cancelled_39, t23.total_order AS total_order_40, t23.cart_avg AS cart_avg_41, t23.minimum_cart AS minimum_cart_42, t23.maximum_cart AS maximum_cart_43, t23.first_completed_order AS first_completed_order_44, t23.last_completed_order AS last_completed_order_45, t23.last_gift AS last_gift_46, t23.consumed_gift AS consumed_gift_47, t23.first_contact AS first_contact_48, t23.last_contact AS last_contact_49, t23.created_at AS created_at_50, t23.updated_at AS updated_at_51, t23.delivery_resettable AS delivery_resettable_52, t23.pickup_resettable AS pickup_resettable_53, t23.unconfirmed_by_client_resettable AS unconfirmed_by_client_resettable_54, t23.cancelled_by_client_resettable AS cancelled_by_client_resettable_55, t23.cancelled_by_store_resettable AS cancelled_by_store_resettable_56, t23.whatsapp_client_id AS whatsapp_client_id_57, t23.store_id AS store_id_58 FROM whatsapp_client_entity t0 LEFT JOIN auto_client_analytics_entity t23 ON t23.whatsapp_client_id = t0.id WHERE t0.id = ? LIMIT 1
Parameters:
[
  7189
]

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\WhatsappClientEntity No errors.
App\Entity\AutoClientAnalyticsEntity No errors.
App\Entity\StoreOwnerProfileEntity
  • The mappings App\Entity\StoreOwnerProfileEntity#OrderLogsEntity and App\Entity\OrderTimeLineEntity#storeOwnerProfile are inconsistent with each other.
App\Entity\WhatsappOrderDetailsEntity No errors.
App\Entity\ClientToStorePaymentEntity No errors.
App\Entity\AutoClientPromotionEntity No errors.