Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.designation AS designation_1,
  s0_.customer AS customer_2,
  s0_.address AS address_3,
  s0_.subject AS subject_4,
  s0_.cover_letter_one AS cover_letter_one_5,
  s0_.cover_letter_two AS cover_letter_two_6,
  s0_.cover_letter_three AS cover_letter_three_7,
  s0_.fedex_covid AS fedex_covid_8,
  s0_.dhl_covid AS dhl_covid_9,
  s0_.ups_covid AS ups_covid_10,
  s0_.offer_date AS offer_date_11,
  s0_.account_no AS account_no_12,
  s0_.ref_id AS ref_id_13,
  s0_.effective_date AS effective_date_14,
  s0_.expiry_date AS expiry_date_15,
  s0_.ups_covid_two AS ups_covid_two_16,
  s0_.offer_type AS offer_type_17,
  s0_.created_at AS created_at_18,
  s0_.modified_at AS modified_at_19,
  s0_.rate_type AS rate_type_20,
  s0_.zone_rate_flag AS zone_rate_flag_21,
  s0_.country_rate_flag AS country_rate_flag_22,
  s0_.courier_id AS courier_id_23,
  s0_.final_customer_id AS final_customer_id_24,
  s0_.created_by_id AS created_by_id_25,
  s0_.modified_by_id AS modified_by_id_26,
  s0_.user_company_id AS user_company_id_27
FROM
  sales_offer s0_
WHERE
  s0_.user_company_id = ?
  AND s0_.offer_type = ?
  AND (
    s0_.customer LIKE ?
    OR s0_.address LIKE ?
    OR s0_.subject LIKE ?
  )
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.customer AS customer_2, s0_.address AS address_3, s0_.subject AS subject_4, s0_.cover_letter_one AS cover_letter_one_5, s0_.cover_letter_two AS cover_letter_two_6, s0_.cover_letter_three AS cover_letter_three_7, s0_.fedex_covid AS fedex_covid_8, s0_.dhl_covid AS dhl_covid_9, s0_.ups_covid AS ups_covid_10, s0_.offer_date AS offer_date_11, s0_.account_no AS account_no_12, s0_.ref_id AS ref_id_13, s0_.effective_date AS effective_date_14, s0_.expiry_date AS expiry_date_15, s0_.ups_covid_two AS ups_covid_two_16, s0_.offer_type AS offer_type_17, s0_.created_at AS created_at_18, s0_.modified_at AS modified_at_19, s0_.rate_type AS rate_type_20, s0_.zone_rate_flag AS zone_rate_flag_21, s0_.country_rate_flag AS country_rate_flag_22, s0_.courier_id AS courier_id_23, s0_.final_customer_id AS final_customer_id_24, s0_.created_by_id AS created_by_id_25, s0_.modified_by_id AS modified_by_id_26, s0_.user_company_id AS user_company_id_27 FROM sales_offer s0_ WHERE s0_.user_company_id = 1 AND s0_.offer_type = 1 AND (s0_.customer LIKE '%%' OR s0_.address LIKE '%%' OR s0_.subject LIKE '%%') AND s0_.id IN (31, 30, 28, 26, 25, 24, 23, 22, 21, 20, 19, 17, 16, 11, 10) ORDER BY s0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.weight AS weight_2,
  t0.rate AS rate_3,
  t0.ending_weight AS ending_weight_4,
  t0.type AS type_5,
  t0.created_at AS created_at_6,
  t0.modified_at AS modified_at_7,
  t0.customer_id AS customer_id_8,
  t0.courier_id AS courier_id_9,
  t0.zone_id AS zone_id_10,
  t0.product_type_id AS product_type_id_11,
  t0.created_by_id AS created_by_id_12,
  t0.modified_by_id AS modified_by_id_13,
  t0.user_company_id AS user_company_id_14
FROM
  zone_wise_sales_rate t0
WHERE
  t0.type = ?
  AND t0.customer_id = ?
  AND t0.courier_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.weight AS weight_2, t0.rate AS rate_3, t0.ending_weight AS ending_weight_4, t0.type AS type_5, t0.created_at AS created_at_6, t0.modified_at AS modified_at_7, t0.customer_id AS customer_id_8, t0.courier_id AS courier_id_9, t0.zone_id AS zone_id_10, t0.product_type_id AS product_type_id_11, t0.created_by_id AS created_by_id_12, t0.modified_by_id AS modified_by_id_13, t0.user_company_id AS user_company_id_14 FROM zone_wise_sales_rate t0 WHERE t0.type = 1 AND t0.customer_id = 7 AND t0.courier_id = 4 LIMIT 1;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.designation AS designation_1,
          s0_.customer AS customer_2,
          s0_.address AS address_3,
          s0_.subject AS subject_4,
          s0_.cover_letter_one AS cover_letter_one_5,
          s0_.cover_letter_two AS cover_letter_two_6,
          s0_.cover_letter_three AS cover_letter_three_7,
          s0_.fedex_covid AS fedex_covid_8,
          s0_.dhl_covid AS dhl_covid_9,
          s0_.ups_covid AS ups_covid_10,
          s0_.offer_date AS offer_date_11,
          s0_.account_no AS account_no_12,
          s0_.ref_id AS ref_id_13,
          s0_.effective_date AS effective_date_14,
          s0_.expiry_date AS expiry_date_15,
          s0_.ups_covid_two AS ups_covid_two_16,
          s0_.offer_type AS offer_type_17,
          s0_.created_at AS created_at_18,
          s0_.modified_at AS modified_at_19,
          s0_.rate_type AS rate_type_20,
          s0_.zone_rate_flag AS zone_rate_flag_21,
          s0_.country_rate_flag AS country_rate_flag_22
        FROM
          sales_offer s0_
        WHERE
          s0_.user_company_id = ?
          AND s0_.offer_type = ?
          AND (
            s0_.customer LIKE ?
            OR s0_.address LIKE ?
            OR s0_.subject LIKE ?
          )
        ORDER BY
          s0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.customer AS customer_2, s0_.address AS address_3, s0_.subject AS subject_4, s0_.cover_letter_one AS cover_letter_one_5, s0_.cover_letter_two AS cover_letter_two_6, s0_.cover_letter_three AS cover_letter_three_7, s0_.fedex_covid AS fedex_covid_8, s0_.dhl_covid AS dhl_covid_9, s0_.ups_covid AS ups_covid_10, s0_.offer_date AS offer_date_11, s0_.account_no AS account_no_12, s0_.ref_id AS ref_id_13, s0_.effective_date AS effective_date_14, s0_.expiry_date AS expiry_date_15, s0_.ups_covid_two AS ups_covid_two_16, s0_.offer_type AS offer_type_17, s0_.created_at AS created_at_18, s0_.modified_at AS modified_at_19, s0_.rate_type AS rate_type_20, s0_.zone_rate_flag AS zone_rate_flag_21, s0_.country_rate_flag AS country_rate_flag_22 FROM sales_offer s0_ WHERE s0_.user_company_id = 1 AND s0_.offer_type = 1 AND (s0_.customer LIKE '%%' OR s0_.address LIKE '%%' OR s0_.subject LIKE '%%') ORDER BY s0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.designation AS designation_1,
          s0_.customer AS customer_2,
          s0_.address AS address_3,
          s0_.subject AS subject_4,
          s0_.cover_letter_one AS cover_letter_one_5,
          s0_.cover_letter_two AS cover_letter_two_6,
          s0_.cover_letter_three AS cover_letter_three_7,
          s0_.fedex_covid AS fedex_covid_8,
          s0_.dhl_covid AS dhl_covid_9,
          s0_.ups_covid AS ups_covid_10,
          s0_.offer_date AS offer_date_11,
          s0_.account_no AS account_no_12,
          s0_.ref_id AS ref_id_13,
          s0_.effective_date AS effective_date_14,
          s0_.expiry_date AS expiry_date_15,
          s0_.ups_covid_two AS ups_covid_two_16,
          s0_.offer_type AS offer_type_17,
          s0_.created_at AS created_at_18,
          s0_.modified_at AS modified_at_19,
          s0_.rate_type AS rate_type_20,
          s0_.zone_rate_flag AS zone_rate_flag_21,
          s0_.country_rate_flag AS country_rate_flag_22
        FROM
          sales_offer s0_
        WHERE
          s0_.user_company_id = ?
          AND s0_.offer_type = ?
          AND (
            s0_.customer LIKE ?
            OR s0_.address LIKE ?
            OR s0_.subject LIKE ?
          )
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  15 OFFSET 60

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.designation AS designation_1, s0_.customer AS customer_2, s0_.address AS address_3, s0_.subject AS subject_4, s0_.cover_letter_one AS cover_letter_one_5, s0_.cover_letter_two AS cover_letter_two_6, s0_.cover_letter_three AS cover_letter_three_7, s0_.fedex_covid AS fedex_covid_8, s0_.dhl_covid AS dhl_covid_9, s0_.ups_covid AS ups_covid_10, s0_.offer_date AS offer_date_11, s0_.account_no AS account_no_12, s0_.ref_id AS ref_id_13, s0_.effective_date AS effective_date_14, s0_.expiry_date AS expiry_date_15, s0_.ups_covid_two AS ups_covid_two_16, s0_.offer_type AS offer_type_17, s0_.created_at AS created_at_18, s0_.modified_at AS modified_at_19, s0_.rate_type AS rate_type_20, s0_.zone_rate_flag AS zone_rate_flag_21, s0_.country_rate_flag AS country_rate_flag_22 FROM sales_offer s0_ WHERE s0_.user_company_id = 1 AND s0_.offer_type = 1 AND (s0_.customer LIKE '%%' OR s0_.address LIKE '%%' OR s0_.subject LIKE '%%')) dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 15 OFFSET 60;

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.created_by_id AS created_by_id_23,
  t0.modified_by_id AS modified_by_id_24,
  t0.user_company_id AS user_company_id_25
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.created_by_id AS created_by_id_23, t0.modified_by_id AS modified_by_id_24, t0.user_company_id AS user_company_id_25 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.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 = 16;

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.created_by_id AS created_by_id_19,
  t0.modified_by_id AS modified_by_id_20,
  t0.user_company_id AS user_company_id_21,
  t0.account_name_id AS account_name_id_22,
  t0.expense_account_name_id AS expense_account_name_id_23
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.created_by_id AS created_by_id_19, t0.modified_by_id AS modified_by_id_20, t0.user_company_id AS user_company_id_21, t0.account_name_id AS account_name_id_22, t0.expense_account_name_id AS expense_account_name_id_23 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.phone AS phone_6,
  t0.website AS website_7,
  t0.logo_path AS logo_path_8,
  t0.bin_no AS bin_no_9,
  t0.payment_note AS payment_note_10,
  t0.logo_height AS logo_height_11,
  t0.heading_size AS heading_size_12,
  t0.short_name AS short_name_13,
  t0.tinno AS tinno_14,
  t0.remittence_account AS remittence_account_15,
  t0.invoice_enquery AS invoice_enquery_16,
  t0.customer_rate AS customer_rate_17,
  t0.cash_shipment AS cash_shipment_18,
  t0.company_courier_id AS company_courier_id_19
FROM
  user_company 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.phone AS phone_6, t0.website AS website_7, t0.logo_path AS logo_path_8, t0.bin_no AS bin_no_9, t0.payment_note AS payment_note_10, t0.logo_height AS logo_height_11, t0.heading_size AS heading_size_12, t0.short_name AS short_name_13, t0.tinno AS tinno_14, t0.remittence_account AS remittence_account_15, t0.invoice_enquery AS invoice_enquery_16, t0.customer_rate AS customer_rate_17, t0.cash_shipment AS cash_shipment_18, t0.company_courier_id AS company_courier_id_19 FROM user_company t0 WHERE t0.id = 1;

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;