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 = ?
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 = 2799 ;
Copy
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
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
Copy
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 = 3839 LIMIT 1 ;
Copy