Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.item_code AS item_code_3,
  t0.name AS name_4,
  t0.slug AS slug_5,
  t0.sku AS sku_6,
  t0.hsn_code AS hsn_code_7,
  t0.description AS description_8,
  t0.size AS size_9,
  t0.unit AS unit_10,
  t0.rate AS rate_11,
  t0.purchase_rate AS purchase_rate_12,
  t0.combo_product AS combo_product_13,
  t0.taxable AS taxable_14,
  t0.stock_on_hand AS stock_on_hand_15,
  t0.available_stock AS available_stock_16,
  t0.actual_available_stock AS actual_available_stock_17,
  t0.committed_stock AS committed_stock_18,
  t0.actual_committed_stock AS actual_committed_stock_19,
  t0.available_for_sale_stock AS available_for_sale_stock_20,
  t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21,
  t0.active AS active_22,
  t0.imported AS imported_23,
  t0.meta_title AS meta_title_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.featured AS featured_27,
  t0.trending AS trending_28,
  t0.show_in_portal AS show_in_portal_29,
  t0.gender AS gender_30,
  t0.created_at AS created_at_31,
  t0.updated_at AS updated_at_32,
  t0.category_id AS category_id_33,
  t0.group_id AS group_id_34,
  t0.grade_id AS grade_id_35,
  t0.intra_tax_id AS intra_tax_id_36,
  t0.inter_tax_id AS inter_tax_id_37,
  t0.created_by AS created_by_38,
  t0.updated_by AS updated_by_39
FROM
  item t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.item_code AS item_code_3, t0.name AS name_4, t0.slug AS slug_5, t0.sku AS sku_6, t0.hsn_code AS hsn_code_7, t0.description AS description_8, t0.size AS size_9, t0.unit AS unit_10, t0.rate AS rate_11, t0.purchase_rate AS purchase_rate_12, t0.combo_product AS combo_product_13, t0.taxable AS taxable_14, t0.stock_on_hand AS stock_on_hand_15, t0.available_stock AS available_stock_16, t0.actual_available_stock AS actual_available_stock_17, t0.committed_stock AS committed_stock_18, t0.actual_committed_stock AS actual_committed_stock_19, t0.available_for_sale_stock AS available_for_sale_stock_20, t0.actual_available_for_sale_stock AS actual_available_for_sale_stock_21, t0.active AS active_22, t0.imported AS imported_23, t0.meta_title AS meta_title_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.featured AS featured_27, t0.trending AS trending_28, t0.show_in_portal AS show_in_portal_29, t0.gender AS gender_30, t0.created_at AS created_at_31, t0.updated_at AS updated_at_32, t0.category_id AS category_id_33, t0.group_id AS group_id_34, t0.grade_id AS grade_id_35, t0.intra_tax_id AS intra_tax_id_36, t0.inter_tax_id AS inter_tax_id_37, t0.created_by AS created_by_38, t0.updated_by AS updated_by_39 FROM item t0 WHERE t0.id = 3726;

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 = 363;

INSERT INTO transaction (
  amount, fee, tax, name, email, mobile,
  address, address1, state, city, pincode,
  billing_same, billing_name, billing_phone,
  billing_address, billing_street,
  billing_state, billing_city, billing_pincode,
  pan, razorpay_payment_id, razorpay_order_id,
  razorpay_signature, transaction_date,
  payment_mode, currency, cart, response,
  attachment, offline, status, created_at,
  updated_at, order_id, ship_address_id,
  bill_address_id, created_by, updated_by
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO transaction (amount, fee, tax, name, email, mobile, address, address1, state, city, pincode, billing_same, billing_name, billing_phone, billing_address, billing_street, billing_state, billing_city, billing_pincode, pan, razorpay_payment_id, razorpay_order_id, razorpay_signature, transaction_date, payment_mode, currency, cart, response, attachment, offline, status, created_at, updated_at, order_id, ship_address_id, bill_address_id, created_by, updated_by) VALUES (983611.15, 0, 0, 'Bomis Primary Pathargama', 'maakali9400@gmail.com', '8002415856', 'AT KASIYATARI, PO PATHARGAMA, PS PATHARGAMA', 'OPPOSITE OF HP PETROL PUMP', 'Jharkhand', 'Godda', '814147', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'order_SPlhaHMuQxuAfQ', NULL, NULL, NULL, NULL, '{\"subtotal\":972741.7999999998,\"tax\":10869.345000000001,\"shipping\":0,\"total\":983611.15,\"taxes\":{\"GST0\":0.0,\"IGST0\":0.0,\"IGST5\":10869.345000000001},\"items\":[{\"id\":3726,\"qty\":30},{\"id\":3727,\"qty\":30},{\"id\":3728,\"qty\":30},{\"id\":3682,\"qty\":30},{\"id\":3681,\"qty\":30},{\"id\":3684,\"qty\":30},{\"id\":3683,\"qty\":30},{\"id\":3686,\"qty\":20},{\"id\":3685,\"qty\":20},{\"id\":3688,\"qty\":20},{\"id\":3687,\"qty\":20},{\"id\":3690,\"qty\":20},{\"id\":3689,\"qty\":20},{\"id\":3692,\"qty\":20}]}', NULL, NULL, 0, NULL, '2026-03-11 08:51:57', '2026-03-11 08:51:57', NULL, 69883, NULL, 363, 363);

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.composite_item_id AS composite_item_id_3,
  t0.item_id AS item_id_4
FROM
  composite_item t0
WHERE
  t0.composite_item_id = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.composite_item_id AS composite_item_id_3, t0.item_id AS item_id_4 FROM composite_item t0 WHERE t0.composite_item_id = 3726;

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.name AS name_3,
  t0.percent AS percent_4,
  t0.specification AS specification_5,
  t0.active AS active_6,
  t0.imported AS imported_7
FROM
  tax t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.percent AS percent_4, t0.specification AS specification_5, t0.active AS active_6, t0.imported AS imported_7 FROM tax t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.name AS name_3,
  t0.address AS address_4,
  t0.street AS street_5,
  t0.city AS city_6,
  t0.state AS state_7,
  t0.state_code AS state_code_8,
  t0.pincode AS pincode_9,
  t0.phone AS phone_10,
  t0.`default` AS default_11,
  t0.active AS active_12,
  t0.user_id AS user_id_13
FROM
  address t0
WHERE
  t0.id = ?
  AND t0.user_id = ?
ORDER BY
  t0.`default` DESC,
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.address AS address_4, t0.street AS street_5, t0.city AS city_6, t0.state AS state_7, t0.state_code AS state_code_8, t0.pincode AS pincode_9, t0.phone AS phone_10, t0.`default` AS default_11, t0.active AS active_12, t0.user_id AS user_id_13 FROM address t0 WHERE t0.id = '69883' AND t0.user_id = 363 ORDER BY t0.`default` DESC, t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.quantity AS quantity_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.item_id AS item_id_5,
  t0.parent_id AS parent_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8
FROM
  cart t0
WHERE
  t0.created_by = ?

SELECT t0.id AS id_1, t0.quantity AS quantity_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.item_id AS item_id_5, t0.parent_id AS parent_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM cart t0 WHERE t0.created_by = 363;

"START TRANSACTION"

"START TRANSACTION";

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.zoho_id AS zoho_id_2,
  t0.name AS name_3,
  t0.percent AS percent_4,
  t0.specification AS specification_5,
  t0.active AS active_6,
  t0.imported AS imported_7
FROM
  tax t0
WHERE
  t0.specification = ?
  AND t0.percent = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.zoho_id AS zoho_id_2, t0.name AS name_3, t0.percent AS percent_4, t0.specification AS specification_5, t0.active AS active_6, t0.imported AS imported_7 FROM tax t0 WHERE t0.specification = 'inter' AND t0.percent = 18 LIMIT 1;