Symfony Profiler

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
  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
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.rateid AS rateid_2,
  p0_.type AS type_3,
  p0_.serial AS serial_4
FROM
  product_type p0_
WHERE
  p0_.type = 1
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.rateid AS rateid_2, p0_.type AS type_3, p0_.serial AS serial_4 FROM product_type p0_ WHERE p0_.type = 1 ORDER BY p0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.short_name AS short_name_2,
  c0_.code AS code_3,
  c0_.master_expedite_rate AS master_expedite_rate_4,
  c0_.expedite_weight AS expedite_weight_5
FROM
  country c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.short_name AS short_name_2, c0_.code AS code_3, c0_.master_expedite_rate AS master_expedite_rate_4, c0_.expedite_weight AS expedite_weight_5 FROM country c0_ 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 = 1
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 = 1 ORDER BY c0_.name ASC;

SELECT
  d0_.id AS id_0,
  d0_.name AS name_1,
  d0_.product_type_id AS product_type_id_2
FROM
  describe_shipment d0_
ORDER BY
  d0_.name ASC

SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.product_type_id AS product_type_id_2 FROM describe_shipment d0_ ORDER BY d0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1
FROM
  services s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1 FROM services s0_ ORDER BY s0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  pickup_shipment p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM pickup_shipment p0_ ORDER BY p0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1
FROM
  phone_type p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1 FROM phone_type p0_ ORDER BY p0_.name ASC;

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1
FROM
  unit u0_
ORDER BY
  u0_.name ASC

SELECT u0_.id AS id_0, u0_.name AS name_1 FROM unit u0_ ORDER BY u0_.name ASC;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.symbol AS symbol_2
FROM
  currency c0_
ORDER BY
  c0_.name ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.symbol AS symbol_2 FROM currency c0_ ORDER BY c0_.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.length AS length_2,
  p0_.width AS width_3,
  p0_.height AS height_4,
  p0_.courier_id AS courier_id_5
FROM
  packaging p0_
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.length AS length_2, p0_.width AS width_3, p0_.height AS height_4, p0_.courier_id AS courier_id_5 FROM packaging p0_ ORDER BY p0_.name ASC;