Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.attention_name AS attention_name_4,
  t0.attention_mobileno AS attention_mobileno_5,
  t0.email AS email_6,
  t0.account_no AS account_no_7,
  t0.invoice_no AS invoice_no_8,
  t0.opening_dues AS opening_dues_9,
  t0.invoice_period AS invoice_period_10,
  t0.rate_type AS rate_type_11,
  t0.fsc AS fsc_12,
  t0.currency AS currency_13,
  t0.rate_currency AS rate_currency_14,
  t0.customer_invoice AS customer_invoice_15,
  t0.credit_limit AS credit_limit_16,
  t0.created_at AS created_at_17,
  t0.modified_at AS modified_at_18,
  t0.dti_automation_charge AS dti_automation_charge_19,
  t0.customer_type AS customer_type_20,
  t0.last_received_amount AS last_received_amount_21,
  t0.previous_dues_amount AS previous_dues_amount_22,
  t0.receive_type AS receive_type_23,
  t0.import_fsc AS import_fsc_24,
  t0.weight_perkg_rate AS weight_perkg_rate_25,
  t0.passbook_weight AS passbook_weight_26,
  t0.short_name AS short_name_27,
  t0.sales_rate AS sales_rate_28,
  t0.candf_vat AS candf_vat_29,
  t0.created_by_id AS created_by_id_30,
  t0.modified_by_id AS modified_by_id_31,
  t0.user_company_id AS user_company_id_32
FROM
  customer t0
WHERE
  t0.user_company_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.attention_name AS attention_name_4, t0.attention_mobileno AS attention_mobileno_5, t0.email AS email_6, t0.account_no AS account_no_7, t0.invoice_no AS invoice_no_8, t0.opening_dues AS opening_dues_9, t0.invoice_period AS invoice_period_10, t0.rate_type AS rate_type_11, t0.fsc AS fsc_12, t0.currency AS currency_13, t0.rate_currency AS rate_currency_14, t0.customer_invoice AS customer_invoice_15, t0.credit_limit AS credit_limit_16, t0.created_at AS created_at_17, t0.modified_at AS modified_at_18, t0.dti_automation_charge AS dti_automation_charge_19, t0.customer_type AS customer_type_20, t0.last_received_amount AS last_received_amount_21, t0.previous_dues_amount AS previous_dues_amount_22, t0.receive_type AS receive_type_23, t0.import_fsc AS import_fsc_24, t0.weight_perkg_rate AS weight_perkg_rate_25, t0.passbook_weight AS passbook_weight_26, t0.short_name AS short_name_27, t0.sales_rate AS sales_rate_28, t0.candf_vat AS candf_vat_29, t0.created_by_id AS created_by_id_30, t0.modified_by_id AS modified_by_id_31, t0.user_company_id AS user_company_id_32 FROM customer t0 WHERE t0.user_company_id = 1 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.mobile_no AS mobile_no_4,
  t0.email AS email_5,
  t0.fsc AS fsc_6,
  t0.weight_perkg AS weight_perkg_7,
  t0.covid_charge_applicable AS covid_charge_applicable_8,
  t0.weight_perkg_rate AS weight_perkg_rate_9,
  t0.first_url AS first_url_10,
  t0.last_url AS last_url_11,
  t0.logo AS logo_12,
  t0.created_at AS created_at_13,
  t0.modified_at AS modified_at_14,
  t0.rate_type AS rate_type_15,
  t0.expedite AS expedite_16,
  t0.sro AS sro_17,
  t0.sro_charge AS sro_charge_18,
  t0.zone_rate_type AS zone_rate_type_19,
  t0.import_zone_rate_type AS import_zone_rate_type_20,
  t0.import_country_rate_type AS import_country_rate_type_21,
  t0.export_country_rate AS export_country_rate_22,
  t0.import_country_rate AS import_country_rate_23,
  t0.courier_master_rate AS courier_master_rate_24,
  t0.courier_type AS courier_type_25,
  t0.created_by_id AS created_by_id_26,
  t0.modified_by_id AS modified_by_id_27,
  t0.user_company_id AS user_company_id_28,
  t0.account_name_id AS account_name_id_29,
  t0.expense_account_name_id AS expense_account_name_id_30
FROM
  courier t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.mobile_no AS mobile_no_4, t0.email AS email_5, t0.fsc AS fsc_6, t0.weight_perkg AS weight_perkg_7, t0.covid_charge_applicable AS covid_charge_applicable_8, t0.weight_perkg_rate AS weight_perkg_rate_9, t0.first_url AS first_url_10, t0.last_url AS last_url_11, t0.logo AS logo_12, t0.created_at AS created_at_13, t0.modified_at AS modified_at_14, t0.rate_type AS rate_type_15, t0.expedite AS expedite_16, t0.sro AS sro_17, t0.sro_charge AS sro_charge_18, t0.zone_rate_type AS zone_rate_type_19, t0.import_zone_rate_type AS import_zone_rate_type_20, t0.import_country_rate_type AS import_country_rate_type_21, t0.export_country_rate AS export_country_rate_22, t0.import_country_rate AS import_country_rate_23, t0.courier_master_rate AS courier_master_rate_24, t0.courier_type AS courier_type_25, t0.created_by_id AS created_by_id_26, t0.modified_by_id AS modified_by_id_27, t0.user_company_id AS user_company_id_28, t0.account_name_id AS account_name_id_29, t0.expense_account_name_id AS expense_account_name_id_30 FROM courier t0;

"COMMIT"

"COMMIT";

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.attention_name AS attention_name_3,
  c0_.attention_mobileno AS attention_mobileno_4,
  c0_.email AS email_5,
  c0_.account_no AS account_no_6,
  c0_.invoice_no AS invoice_no_7,
  c0_.opening_dues AS opening_dues_8,
  c0_.invoice_period AS invoice_period_9,
  c0_.rate_type AS rate_type_10,
  c0_.fsc AS fsc_11,
  c0_.currency AS currency_12,
  c0_.rate_currency AS rate_currency_13,
  c0_.customer_invoice AS customer_invoice_14,
  c0_.credit_limit AS credit_limit_15,
  c0_.created_at AS created_at_16,
  c0_.modified_at AS modified_at_17,
  c0_.dti_automation_charge AS dti_automation_charge_18,
  c0_.customer_type AS customer_type_19,
  c0_.last_received_amount AS last_received_amount_20,
  c0_.previous_dues_amount AS previous_dues_amount_21,
  c0_.receive_type AS receive_type_22,
  c0_.import_fsc AS import_fsc_23,
  c0_.weight_perkg_rate AS weight_perkg_rate_24,
  c0_.passbook_weight AS passbook_weight_25,
  c0_.short_name AS short_name_26,
  c0_.sales_rate AS sales_rate_27,
  c0_.candf_vat AS candf_vat_28,
  c0_.created_by_id AS created_by_id_29,
  c0_.modified_by_id AS modified_by_id_30,
  c0_.user_company_id AS user_company_id_31
FROM
  customer c0_
WHERE
  c0_.user_company_id = 1
  AND c0_.id IN (?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.attention_name AS attention_name_3, c0_.attention_mobileno AS attention_mobileno_4, c0_.email AS email_5, c0_.account_no AS account_no_6, c0_.invoice_no AS invoice_no_7, c0_.opening_dues AS opening_dues_8, c0_.invoice_period AS invoice_period_9, c0_.rate_type AS rate_type_10, c0_.fsc AS fsc_11, c0_.currency AS currency_12, c0_.rate_currency AS rate_currency_13, c0_.customer_invoice AS customer_invoice_14, c0_.credit_limit AS credit_limit_15, c0_.created_at AS created_at_16, c0_.modified_at AS modified_at_17, c0_.dti_automation_charge AS dti_automation_charge_18, c0_.customer_type AS customer_type_19, c0_.last_received_amount AS last_received_amount_20, c0_.previous_dues_amount AS previous_dues_amount_21, c0_.receive_type AS receive_type_22, c0_.import_fsc AS import_fsc_23, c0_.weight_perkg_rate AS weight_perkg_rate_24, c0_.passbook_weight AS passbook_weight_25, c0_.short_name AS short_name_26, c0_.sales_rate AS sales_rate_27, c0_.candf_vat AS candf_vat_28, c0_.created_by_id AS created_by_id_29, c0_.modified_by_id AS modified_by_id_30, c0_.user_company_id AS user_company_id_31 FROM customer c0_ WHERE c0_.user_company_id = 1 AND c0_.id IN ('56') ORDER BY c0_.name ASC;

INSERT INTO candf_shipment (
  cleared_date, vat_challan_no, be_no,
  be_date, awb_no, packages, weight,
  goods_description, created_at, modified_at,
  custom_value, remarks, entry_date,
  document_path, hs_code, serial_no,
  invoice_value, ip_no, mawb_no, supplier,
  customer_id, carrier_type_id, created_by_id,
  modified_by_id, user_company_id,
  department_id, currency_id, candf_agent_id
)
VALUES
  (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

INSERT INTO candf_shipment (cleared_date, vat_challan_no, be_no, be_date, awb_no, packages, weight, goods_description, created_at, modified_at, custom_value, remarks, entry_date, document_path, hs_code, serial_no, invoice_value, ip_no, mawb_no, supplier, customer_id, carrier_type_id, created_by_id, modified_by_id, user_company_id, department_id, currency_id, candf_agent_id) VALUES ('2026-07-08', '0', '668722', '2026-07-06', '7569504342', '1', 0.13, 'FABRIC SWATCH', '2026-07-14 09:27:35', NULL, 5, NULL, '2026-07-06', NULL, '52082100', 13, 0.8, '0', NULL, 'HALLENSTEIN PROUCTION ,NZ', 56, 36, 15, NULL, 1, NULL, 1, 2);

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.full_name AS full_name_5,
  t0.mobile_no AS mobile_no_6,
  t0.designation AS designation_7,
  t0.department AS department_8,
  t0.password_hint AS password_hint_9,
  t0.user_code AS user_code_10,
  t0.user_company_id AS user_company_id_11,
  t0.customer_id AS customer_id_12
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.full_name AS full_name_5, t0.mobile_no AS mobile_no_6, t0.designation AS designation_7, t0.department AS department_8, t0.password_hint AS password_hint_9, t0.user_code AS user_code_10, t0.user_company_id AS user_company_id_11, t0.customer_id AS customer_id_12 FROM user t0 WHERE t0.id = 15;

SELECT
  count(s0_.id) AS sclr_0
FROM
  shipment s0_
  LEFT JOIN user u1_ ON s0_.created_by_id = u1_.id
WHERE
  s0_.accepted = 0

SELECT count(s0_.id) AS sclr_0 FROM shipment s0_ LEFT JOIN user u1_ ON s0_.created_by_id = u1_.id WHERE s0_.accepted = 0;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.mobile_no AS mobile_no_3,
  c0_.email AS email_4,
  c0_.fsc AS fsc_5,
  c0_.weight_perkg AS weight_perkg_6,
  c0_.covid_charge_applicable AS covid_charge_applicable_7,
  c0_.weight_perkg_rate AS weight_perkg_rate_8,
  c0_.first_url AS first_url_9,
  c0_.last_url AS last_url_10,
  c0_.logo AS logo_11,
  c0_.created_at AS created_at_12,
  c0_.modified_at AS modified_at_13,
  c0_.rate_type AS rate_type_14,
  c0_.expedite AS expedite_15,
  c0_.sro AS sro_16,
  c0_.sro_charge AS sro_charge_17,
  c0_.zone_rate_type AS zone_rate_type_18,
  c0_.import_zone_rate_type AS import_zone_rate_type_19,
  c0_.import_country_rate_type AS import_country_rate_type_20,
  c0_.export_country_rate AS export_country_rate_21,
  c0_.import_country_rate AS import_country_rate_22,
  c0_.courier_master_rate AS courier_master_rate_23,
  c0_.courier_type AS courier_type_24,
  c0_.created_by_id AS created_by_id_25,
  c0_.modified_by_id AS modified_by_id_26,
  c0_.user_company_id AS user_company_id_27,
  c0_.account_name_id AS account_name_id_28,
  c0_.expense_account_name_id AS expense_account_name_id_29
FROM
  courier c0_
WHERE
  c0_.user_company_id = 1
  AND c0_.courier_type = 2
  AND c0_.id IN (?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.mobile_no AS mobile_no_3, c0_.email AS email_4, c0_.fsc AS fsc_5, c0_.weight_perkg AS weight_perkg_6, c0_.covid_charge_applicable AS covid_charge_applicable_7, c0_.weight_perkg_rate AS weight_perkg_rate_8, c0_.first_url AS first_url_9, c0_.last_url AS last_url_10, c0_.logo AS logo_11, c0_.created_at AS created_at_12, c0_.modified_at AS modified_at_13, c0_.rate_type AS rate_type_14, c0_.expedite AS expedite_15, c0_.sro AS sro_16, c0_.sro_charge AS sro_charge_17, c0_.zone_rate_type AS zone_rate_type_18, c0_.import_zone_rate_type AS import_zone_rate_type_19, c0_.import_country_rate_type AS import_country_rate_type_20, c0_.export_country_rate AS export_country_rate_21, c0_.import_country_rate AS import_country_rate_22, c0_.courier_master_rate AS courier_master_rate_23, c0_.courier_type AS courier_type_24, c0_.created_by_id AS created_by_id_25, c0_.modified_by_id AS modified_by_id_26, c0_.user_company_id AS user_company_id_27, c0_.account_name_id AS account_name_id_28, c0_.expense_account_name_id AS expense_account_name_id_29 FROM courier c0_ WHERE c0_.user_company_id = 1 AND c0_.courier_type = 2 AND c0_.id IN ('36') ORDER BY c0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2
FROM
  currency c0_
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2 FROM currency c0_ WHERE c0_.id IN ('1') ORDER BY c0_.name ASC;

"START TRANSACTION"

"START TRANSACTION";

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.address AS address_2,
  c0_.mobile_no AS mobile_no_3,
  c0_.email AS email_4,
  c0_.account_no AS account_no_5
FROM
  candf_agent c0_
WHERE
  c0_.id IN (?)
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.address AS address_2, c0_.mobile_no AS mobile_no_3, c0_.email AS email_4, c0_.account_no AS account_no_5 FROM candf_agent c0_ WHERE c0_.id IN ('2') ORDER BY c0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.step AS step_3
FROM
  tracking_status t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.step AS step_3 FROM tracking_status t0;