Symfony Profiler

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.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 = 552;

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.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 = 546;

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.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 = 546;

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.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 = 68;

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.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 = 546;

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 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 (546, 545, 543, 540, 539, 538, 537, 536, 535, 534, 533, 532, 531, 530, 529, 528, 527, 526, 525, 524) ORDER BY s0_.id DESC;

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

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;

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 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 = 'ulkesh.purabia@birlaopenminds.com' LIMIT 1;

SELECT
  count(*) AS sclr_0
FROM
  sales_order s0_

SELECT count(*) AS sclr_0 FROM sales_order s0_;

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.id AS id_1
FROM
  sales_order s0_
ORDER BY
  s0_.id DESC
LIMIT
  20

SELECT DISTINCT s0_.id AS id_0, s0_.id AS id_1 FROM sales_order s0_ ORDER BY s0_.id DESC LIMIT 20;