Symfony Profiler

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

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;

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

SELECT
  t0.id AS id_1,
  t0.cleared_date AS cleared_date_2,
  t0.vat_challan_no AS vat_challan_no_3,
  t0.be_no AS be_no_4,
  t0.be_date AS be_date_5,
  t0.awb_no AS awb_no_6,
  t0.packages AS packages_7,
  t0.weight AS weight_8,
  t0.goods_description AS goods_description_9,
  t0.created_at AS created_at_10,
  t0.modified_at AS modified_at_11,
  t0.custom_value AS custom_value_12,
  t0.remarks AS remarks_13,
  t0.entry_date AS entry_date_14,
  t0.document_path AS document_path_15,
  t0.hs_code AS hs_code_16,
  t0.serial_no AS serial_no_17,
  t0.invoice_value AS invoice_value_18,
  t0.ip_no AS ip_no_19,
  t0.mawb_no AS mawb_no_20,
  t0.supplier AS supplier_21,
  t0.customer_id AS customer_id_22,
  t0.carrier_type_id AS carrier_type_id_23,
  t0.created_by_id AS created_by_id_24,
  t0.modified_by_id AS modified_by_id_25,
  t0.user_company_id AS user_company_id_26,
  t0.department_id AS department_id_27,
  t0.currency_id AS currency_id_28,
  t0.candf_agent_id AS candf_agent_id_29
FROM
  candf_shipment t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.cleared_date AS cleared_date_2, t0.vat_challan_no AS vat_challan_no_3, t0.be_no AS be_no_4, t0.be_date AS be_date_5, t0.awb_no AS awb_no_6, t0.packages AS packages_7, t0.weight AS weight_8, t0.goods_description AS goods_description_9, t0.created_at AS created_at_10, t0.modified_at AS modified_at_11, t0.custom_value AS custom_value_12, t0.remarks AS remarks_13, t0.entry_date AS entry_date_14, t0.document_path AS document_path_15, t0.hs_code AS hs_code_16, t0.serial_no AS serial_no_17, t0.invoice_value AS invoice_value_18, t0.ip_no AS ip_no_19, t0.mawb_no AS mawb_no_20, t0.supplier AS supplier_21, t0.customer_id AS customer_id_22, t0.carrier_type_id AS carrier_type_id_23, t0.created_by_id AS created_by_id_24, t0.modified_by_id AS modified_by_id_25, t0.user_company_id AS user_company_id_26, t0.department_id AS department_id_27, t0.currency_id AS currency_id_28, t0.candf_agent_id AS candf_agent_id_29 FROM candf_shipment t0 WHERE t0.id = '4667';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.symbol AS symbol_3
FROM
  currency t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.symbol AS symbol_3 FROM currency t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.full_name AS full_name_2,
  t0.short_name AS short_name_3
FROM
  department t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.full_name AS full_name_2, t0.short_name AS short_name_3 FROM department t0 WHERE t0.id = 1;

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.account_no AS account_no_6
FROM
  candf_agent t0
WHERE
  t0.id = ?

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.account_no AS account_no_6 FROM candf_agent t0 WHERE t0.id = 3;

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 ('55') 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 (?)
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 ('44') 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;

SELECT
  d0_.id AS id_0,
  d0_.full_name AS full_name_1,
  d0_.short_name AS short_name_2
FROM
  department d0_
WHERE
  d0_.id IN (?)
ORDER BY
  d0_.full_name ASC

SELECT d0_.id AS id_0, d0_.full_name AS full_name_1, d0_.short_name AS short_name_2 FROM department d0_ WHERE d0_.id IN ('1') ORDER BY d0_.full_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 (?)
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 ('3') ORDER BY c0_.name ASC;