Query Metrics
2
Database Queries
2
Different statements
1.12 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
0.72 ms (64.19%) |
1 |
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
]
|
0.40 ms (35.81%) |
1 |
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"
]
|
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 |
|
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 |
|
App\Entity\WhatsappOrderDetailsEntity | No errors. |
App\Entity\ClientToStorePaymentEntity | No errors. |
App\Entity\AutoClientPromotionEntity | No errors. |