Symfony Profiler

Query Metrics

101 Database Queries
10 Different statements
37.44 ms Query time
0 Invalid entities
Queries


SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.email = ? LIMIT 1
SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM sales_order s0_ ORDER BY s0_.id DESC LIMIT 20
SELECT s0_.id AS id_0, s0_.zoho_id AS zoho_id_1, s0_.so_number AS so_number_2, s0_.taxes AS taxes_3, s0_.subtotal AS subtotal_4, s0_.shipping AS shipping_5, s0_.discount AS discount_6, s0_.tax AS tax_7, s0_.total AS total_8, s0_.status AS status_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11, s0_.order_id AS order_id_12, s0_.created_by AS created_by_13, s0_.updated_by AS updated_by_14 FROM sales_order s0_ WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.id DESC
SELECT count(*) AS sclr_0 FROM sales_order s0_
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.shipping_name AS shipping_name_3, t0.shipping_phone AS shipping_phone_4, t0.shipping_address AS shipping_address_5, t0.shipping_street AS shipping_street_6, t0.shipping_state AS shipping_state_7, t0.shipping_city AS shipping_city_8, t0.shipping_pincode AS shipping_pincode_9, t0.billing_same AS billing_same_10, t0.billing_name AS billing_name_11, t0.billing_phone AS billing_phone_12, t0.billing_address AS billing_address_13, t0.billing_street AS billing_street_14, t0.billing_state AS billing_state_15, t0.billing_city AS billing_city_16, t0.billing_pincode AS billing_pincode_17, t0.subtotal AS subtotal_18, t0.tax AS tax_19, t0.shipping AS shipping_20, t0.discount AS discount_21, t0.total AS total_22, t0.status AS status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.customer_id AS customer_id_26, t0.ship_address_id AS ship_address_id_27, t0.bill_address_id AS bill_address_id_28, t29.id AS id_30, t29.amount AS amount_31, t29.fee AS fee_32, t29.tax AS tax_33, t29.name AS name_34, t29.email AS email_35, t29.mobile AS mobile_36, t29.address AS address_37, t29.address1 AS address1_38, t29.state AS state_39, t29.city AS city_40, t29.pincode AS pincode_41, t29.billing_same AS billing_same_42, t29.billing_name AS billing_name_43, t29.billing_phone AS billing_phone_44, t29.billing_address AS billing_address_45, t29.billing_street AS billing_street_46, t29.billing_state AS billing_state_47, t29.billing_city AS billing_city_48, t29.billing_pincode AS billing_pincode_49, t29.pan AS pan_50, t29.razorpay_payment_id AS razorpay_payment_id_51, t29.razorpay_order_id AS razorpay_order_id_52, t29.razorpay_signature AS razorpay_signature_53, t29.transaction_date AS transaction_date_54, t29.payment_mode AS payment_mode_55, t29.currency AS currency_56, t29.cart AS cart_57, t29.response AS response_58, t29.attachment AS attachment_59, t29.offline AS offline_60, t29.status AS status_61, t29.created_at AS created_at_62, t29.updated_at AS updated_at_63, t29.order_id AS order_id_64, t29.ship_address_id AS ship_address_id_65, t29.bill_address_id AS bill_address_id_66, t29.created_by AS created_by_67, t29.updated_by AS updated_by_68, t0.created_by AS created_by_69, t0.updated_by AS updated_by_70 FROM `order` t0 LEFT JOIN transaction t29 ON t29.order_id = t0.id WHERE t0.id = ?
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.mobile AS mobile_7, t0.avatar AS avatar_8, t0.token AS token_9, t0.token_date AS token_date_10, t0.last_login AS last_login_11, t0.email_verified AS email_verified_12, t0.mobile_verified AS mobile_verified_13, t0.enabled AS enabled_14, t0.date_of_birth AS date_of_birth_15, t0.gender AS gender_16, t0.zoho_id AS zoho_id_17, t0.display_name AS display_name_18, t0.company AS company_19, t0.location AS location_20, t0.type AS type_21, t0.phone AS phone_22, t0.pan AS pan_23, t0.gst_number AS gst_number_24, t0.gst_treatment AS gst_treatment_25, t0.place_of_contact AS place_of_contact_26, t0.imported AS imported_27, t0.additional_email AS additional_email_28, t0.offline_payment AS offline_payment_29, t0.logic_code AS logic_code_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.school_id AS school_id_33 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.price AS price_3, t0.sales_order_id AS sales_order_id_4, t0.item_id AS item_id_5 FROM sales_order_item t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.invoice_number AS invoice_number_3, t0.pdf AS pdf_4, t0.total AS total_5, t0.gst_invoice AS gst_invoice_6, t0.pushed AS pushed_7, t0.sent AS sent_8, t0.downloaded AS downloaded_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t0.created_by AS created_by_14, t0.updated_by AS updated_by_15 FROM invoice t0 WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.package_number AS package_number_3, t0.shipment_number AS shipment_number_4, t0.quantity AS quantity_5, t0.tracking_number AS tracking_number_6, t0.carrier AS carrier_7, t0.delivered AS delivered_8, t0.delivery_date AS delivery_date_9, t0.status AS status_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sales_order_id AS sales_order_id_13, t14.id AS id_15, t14.subject AS subject_16, t14.attachment AS attachment_17, t14.message AS message_18, t14.status AS status_19, t14.created_at AS created_at_20, t14.updated_at AS updated_at_21, t14.package_id AS package_id_22, t14.created_by AS created_by_23, t14.updated_by AS updated_by_24, t0.created_by AS created_by_25, t0.updated_by AS updated_by_26 FROM package t0 LEFT JOIN order_return t14 ON t14.package_id = t0.id WHERE t0.sales_order_id = ?
SELECT t0.id AS id_1, t0.logo AS logo_2, t0.tagline AS tagline_3, t0.logo_footer AS logo_footer_4, t0.footer_description AS footer_description_5, t0.facebook_link AS facebook_link_6, t0.x_link AS x_link_7, t0.instagram_link AS instagram_link_8, t0.linkedin_link AS linkedin_link_9, t0.whatsapp_link AS whatsapp_link_10, t0.contact_phone AS contact_phone_11, t0.contact_email AS contact_email_12, t0.address AS address_13, t0.map_link AS map_link_14, t0.home_banner_title AS home_banner_title_15, t0.home_banner_description AS home_banner_description_16, t0.home_banner_image AS home_banner_image_17, t0.trending_products_title AS trending_products_title_18, t0.trending_products_description AS trending_products_description_19, t0.combined_kit_title AS combined_kit_title_20, t0.combined_kit_description AS combined_kit_description_21, t0.how_works_title AS how_works_title_22, t0.how_works_description AS how_works_description_23, t0.contact_us_image AS contact_us_image_24, t0.contact_us_title AS contact_us_title_25, t0.contact_us_description AS contact_us_description_26, t0.contact_us_map AS contact_us_map_27, t0.google_analytics_id AS google_analytics_id_28, t0.google_tag_manager_code AS google_tag_manager_code_29, t0.google_site_verification_code AS google_site_verification_code_30, t0.zoho_token AS zoho_token_31, t0.zoho_token_created_at AS zoho_token_created_at_32, t0.safex_token AS safex_token_33, t0.safex_token_created_at AS safex_token_created_at_34, t0.blue_dart_token AS blue_dart_token_35, t0.blue_dart_token_created_at AS blue_dart_token_created_at_36, t0.invoice_cc AS invoice_cc_37, t0.meta_title AS meta_title_38, t0.meta_description AS meta_description_39, t0.meta_keywords AS meta_keywords_40 FROM setting t0 LIMIT 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.
Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\School	No errors.
App\Entity\Address	No errors.
App\Entity\SalesOrder	No errors.
App\Entity\Order	No errors.
App\Entity\Invoice	No errors.
App\Entity\Package	No errors.
App\Entity\SalesOrderItem	No errors.
App\Entity\Transaction	No errors.
App\Entity\OrderItem	No errors.
App\Entity\Item	No errors.
App\Entity\OrderReturn	No errors.
App\Entity\Setting	No errors.
App\Entity\KeyFeature	No errors.
App\Entity\HowWorks	No errors.
Symfony Profiler

GET https://innovineschoolshop.com/control/?crudAction=index&crudControllerFqcn=App%5CController%5CAdmin%5CSalesOrderCrudController

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
