Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.consignment_no AS consignment_no_1,
          s0_.shipper_account AS shipper_account_2,
          s0_.ref_no AS ref_no_3,
          s0_.courier_awb_no AS courier_awb_no_4,
          s0_.type AS type_5,
          s0_.pieces AS pieces_6,
          s0_.weight AS weight_7,
          s0_.ship_content AS ship_content_8,
          s0_.booking_date AS booking_date_9,
          s0_.shiper_company AS shiper_company_10,
          s0_.shiper_address AS shiper_address_11,
          s0_.shiper_city AS shiper_city_12,
          s0_.shiper_state AS shiper_state_13,
          s0_.shiper_zip_code AS shiper_zip_code_14,
          s0_.sender_name AS sender_name_15,
          s0_.shiper_tel_no AS shiper_tel_no_16,
          s0_.shiper_mp AS shiper_mp_17,
          s0_.consigne_company AS consigne_company_18,
          s0_.consigne_adress AS consigne_adress_19,
          s0_.consigne_city AS consigne_city_20,
          s0_.consigne_state AS consigne_state_21,
          s0_.consigne_zip_code AS consigne_zip_code_22,
          s0_.recipent_name AS recipent_name_23,
          s0_.consigne_tel_no AS consigne_tel_no_24,
          s0_.consigne_mp AS consigne_mp_25,
          s0_.remarks AS remarks_26,
          s0_.height AS height_27,
          s0_.width AS width_28,
          s0_.length AS length_29,
          s0_.pickupby AS pickupby_30,
          s0_.pickup_date AS pickup_date_31,
          s0_.total_amount AS total_amount_32,
          s0_.collect_amount AS collect_amount_33,
          s0_.third_party_amount AS third_party_amount_34,
          s0_.cheque_no AS cheque_no_35,
          s0_.account_no AS account_no_36,
          s0_.note AS note_37,
          s0_.deliverystatus AS deliverystatus_38,
          s0_.trackingstatus AS trackingstatus_39,
          s0_.nid AS nid_40,
          s0_.payment_mode AS payment_mode_41,
          s0_.consigne_nid AS consigne_nid_42,
          s0_.nid_path AS nid_path_43,
          s0_.awb_path AS awb_path_44,
          s0_.invoice_path AS invoice_path_45,
          s0_.other_path AS other_path_46
        FROM
          shipment s0_
        WHERE
          s0_.consignment_no LIKE ?
          OR s0_.shipper_account LIKE ?
          OR s0_.shiper_company LIKE ?
          OR s0_.courier_awb_no LIKE ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT s0_.id AS id_0, s0_.consignment_no AS consignment_no_1, s0_.shipper_account AS shipper_account_2, s0_.ref_no AS ref_no_3, s0_.courier_awb_no AS courier_awb_no_4, s0_.type AS type_5, s0_.pieces AS pieces_6, s0_.weight AS weight_7, s0_.ship_content AS ship_content_8, s0_.booking_date AS booking_date_9, s0_.shiper_company AS shiper_company_10, s0_.shiper_address AS shiper_address_11, s0_.shiper_city AS shiper_city_12, s0_.shiper_state AS shiper_state_13, s0_.shiper_zip_code AS shiper_zip_code_14, s0_.sender_name AS sender_name_15, s0_.shiper_tel_no AS shiper_tel_no_16, s0_.shiper_mp AS shiper_mp_17, s0_.consigne_company AS consigne_company_18, s0_.consigne_adress AS consigne_adress_19, s0_.consigne_city AS consigne_city_20, s0_.consigne_state AS consigne_state_21, s0_.consigne_zip_code AS consigne_zip_code_22, s0_.recipent_name AS recipent_name_23, s0_.consigne_tel_no AS consigne_tel_no_24, s0_.consigne_mp AS consigne_mp_25, s0_.remarks AS remarks_26, s0_.height AS height_27, s0_.width AS width_28, s0_.length AS length_29, s0_.pickupby AS pickupby_30, s0_.pickup_date AS pickup_date_31, s0_.total_amount AS total_amount_32, s0_.collect_amount AS collect_amount_33, s0_.third_party_amount AS third_party_amount_34, s0_.cheque_no AS cheque_no_35, s0_.account_no AS account_no_36, s0_.note AS note_37, s0_.deliverystatus AS deliverystatus_38, s0_.trackingstatus AS trackingstatus_39, s0_.nid AS nid_40, s0_.payment_mode AS payment_mode_41, s0_.consigne_nid AS consigne_nid_42, s0_.nid_path AS nid_path_43, s0_.awb_path AS awb_path_44, s0_.invoice_path AS invoice_path_45, s0_.other_path AS other_path_46 FROM shipment s0_ WHERE s0_.consignment_no LIKE '%%' OR s0_.shipper_account LIKE '%%' OR s0_.shiper_company LIKE '%%' OR s0_.courier_awb_no LIKE '%%') dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 10;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4
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 FROM user t0 WHERE t0.id = 5;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          s0_.id AS id_0,
          s0_.consignment_no AS consignment_no_1,
          s0_.shipper_account AS shipper_account_2,
          s0_.ref_no AS ref_no_3,
          s0_.courier_awb_no AS courier_awb_no_4,
          s0_.type AS type_5,
          s0_.pieces AS pieces_6,
          s0_.weight AS weight_7,
          s0_.ship_content AS ship_content_8,
          s0_.booking_date AS booking_date_9,
          s0_.shiper_company AS shiper_company_10,
          s0_.shiper_address AS shiper_address_11,
          s0_.shiper_city AS shiper_city_12,
          s0_.shiper_state AS shiper_state_13,
          s0_.shiper_zip_code AS shiper_zip_code_14,
          s0_.sender_name AS sender_name_15,
          s0_.shiper_tel_no AS shiper_tel_no_16,
          s0_.shiper_mp AS shiper_mp_17,
          s0_.consigne_company AS consigne_company_18,
          s0_.consigne_adress AS consigne_adress_19,
          s0_.consigne_city AS consigne_city_20,
          s0_.consigne_state AS consigne_state_21,
          s0_.consigne_zip_code AS consigne_zip_code_22,
          s0_.recipent_name AS recipent_name_23,
          s0_.consigne_tel_no AS consigne_tel_no_24,
          s0_.consigne_mp AS consigne_mp_25,
          s0_.remarks AS remarks_26,
          s0_.height AS height_27,
          s0_.width AS width_28,
          s0_.length AS length_29,
          s0_.pickupby AS pickupby_30,
          s0_.pickup_date AS pickup_date_31,
          s0_.total_amount AS total_amount_32,
          s0_.collect_amount AS collect_amount_33,
          s0_.third_party_amount AS third_party_amount_34,
          s0_.cheque_no AS cheque_no_35,
          s0_.account_no AS account_no_36,
          s0_.note AS note_37,
          s0_.deliverystatus AS deliverystatus_38,
          s0_.trackingstatus AS trackingstatus_39,
          s0_.nid AS nid_40,
          s0_.payment_mode AS payment_mode_41,
          s0_.consigne_nid AS consigne_nid_42,
          s0_.nid_path AS nid_path_43,
          s0_.awb_path AS awb_path_44,
          s0_.invoice_path AS invoice_path_45,
          s0_.other_path AS other_path_46
        FROM
          shipment s0_
        WHERE
          s0_.consignment_no LIKE ?
          OR s0_.shipper_account LIKE ?
          OR s0_.shiper_company LIKE ?
          OR s0_.courier_awb_no 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_.consignment_no AS consignment_no_1, s0_.shipper_account AS shipper_account_2, s0_.ref_no AS ref_no_3, s0_.courier_awb_no AS courier_awb_no_4, s0_.type AS type_5, s0_.pieces AS pieces_6, s0_.weight AS weight_7, s0_.ship_content AS ship_content_8, s0_.booking_date AS booking_date_9, s0_.shiper_company AS shiper_company_10, s0_.shiper_address AS shiper_address_11, s0_.shiper_city AS shiper_city_12, s0_.shiper_state AS shiper_state_13, s0_.shiper_zip_code AS shiper_zip_code_14, s0_.sender_name AS sender_name_15, s0_.shiper_tel_no AS shiper_tel_no_16, s0_.shiper_mp AS shiper_mp_17, s0_.consigne_company AS consigne_company_18, s0_.consigne_adress AS consigne_adress_19, s0_.consigne_city AS consigne_city_20, s0_.consigne_state AS consigne_state_21, s0_.consigne_zip_code AS consigne_zip_code_22, s0_.recipent_name AS recipent_name_23, s0_.consigne_tel_no AS consigne_tel_no_24, s0_.consigne_mp AS consigne_mp_25, s0_.remarks AS remarks_26, s0_.height AS height_27, s0_.width AS width_28, s0_.length AS length_29, s0_.pickupby AS pickupby_30, s0_.pickup_date AS pickup_date_31, s0_.total_amount AS total_amount_32, s0_.collect_amount AS collect_amount_33, s0_.third_party_amount AS third_party_amount_34, s0_.cheque_no AS cheque_no_35, s0_.account_no AS account_no_36, s0_.note AS note_37, s0_.deliverystatus AS deliverystatus_38, s0_.trackingstatus AS trackingstatus_39, s0_.nid AS nid_40, s0_.payment_mode AS payment_mode_41, s0_.consigne_nid AS consigne_nid_42, s0_.nid_path AS nid_path_43, s0_.awb_path AS awb_path_44, s0_.invoice_path AS invoice_path_45, s0_.other_path AS other_path_46 FROM shipment s0_ WHERE s0_.consignment_no LIKE '%%' OR s0_.shipper_account LIKE '%%' OR s0_.shiper_company LIKE '%%' OR s0_.courier_awb_no LIKE '%%' ORDER BY s0_.id DESC) dctrn_result) dctrn_table;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.mobileno AS mobileno_4,
  t0.email AS email_5,
  t0.full_url AS full_url_6,
  t0.remarks AS remarks_7,
  t0.first_url AS first_url_8,
  t0.last_url AS last_url_9
FROM
  courier t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.mobileno AS mobileno_4, t0.email AS email_5, t0.full_url AS full_url_6, t0.remarks AS remarks_7, t0.first_url AS first_url_8, t0.last_url AS last_url_9 FROM courier t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.remarks AS remarks_4
FROM
  destination_country t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM destination_country t0 WHERE t0.id = 11;

SELECT
  s0_.id AS id_0,
  s0_.consignment_no AS consignment_no_1,
  s0_.shipper_account AS shipper_account_2,
  s0_.ref_no AS ref_no_3,
  s0_.courier_awb_no AS courier_awb_no_4,
  s0_.type AS type_5,
  s0_.pieces AS pieces_6,
  s0_.weight AS weight_7,
  s0_.ship_content AS ship_content_8,
  s0_.booking_date AS booking_date_9,
  s0_.shiper_company AS shiper_company_10,
  s0_.shiper_address AS shiper_address_11,
  s0_.shiper_city AS shiper_city_12,
  s0_.shiper_state AS shiper_state_13,
  s0_.shiper_zip_code AS shiper_zip_code_14,
  s0_.sender_name AS sender_name_15,
  s0_.shiper_tel_no AS shiper_tel_no_16,
  s0_.shiper_mp AS shiper_mp_17,
  s0_.consigne_company AS consigne_company_18,
  s0_.consigne_adress AS consigne_adress_19,
  s0_.consigne_city AS consigne_city_20,
  s0_.consigne_state AS consigne_state_21,
  s0_.consigne_zip_code AS consigne_zip_code_22,
  s0_.recipent_name AS recipent_name_23,
  s0_.consigne_tel_no AS consigne_tel_no_24,
  s0_.consigne_mp AS consigne_mp_25,
  s0_.remarks AS remarks_26,
  s0_.height AS height_27,
  s0_.width AS width_28,
  s0_.length AS length_29,
  s0_.pickupby AS pickupby_30,
  s0_.pickup_date AS pickup_date_31,
  s0_.total_amount AS total_amount_32,
  s0_.collect_amount AS collect_amount_33,
  s0_.third_party_amount AS third_party_amount_34,
  s0_.cheque_no AS cheque_no_35,
  s0_.account_no AS account_no_36,
  s0_.note AS note_37,
  s0_.deliverystatus AS deliverystatus_38,
  s0_.trackingstatus AS trackingstatus_39,
  s0_.nid AS nid_40,
  s0_.payment_mode AS payment_mode_41,
  s0_.consigne_nid AS consigne_nid_42,
  s0_.nid_path AS nid_path_43,
  s0_.awb_path AS awb_path_44,
  s0_.invoice_path AS invoice_path_45,
  s0_.other_path AS other_path_46,
  s0_.courier_id AS courier_id_47,
  s0_.origin_country_id AS origin_country_id_48,
  s0_.destination_country_id AS destination_country_id_49,
  s0_.shipper_id AS shipper_id_50,
  s0_.consignee_id AS consignee_id_51
FROM
  shipment s0_
WHERE
  (
    s0_.consignment_no LIKE ?
    OR s0_.shipper_account LIKE ?
    OR s0_.shiper_company LIKE ?
    OR s0_.courier_awb_no LIKE ?
  )
  AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  s0_.id DESC

SELECT s0_.id AS id_0, s0_.consignment_no AS consignment_no_1, s0_.shipper_account AS shipper_account_2, s0_.ref_no AS ref_no_3, s0_.courier_awb_no AS courier_awb_no_4, s0_.type AS type_5, s0_.pieces AS pieces_6, s0_.weight AS weight_7, s0_.ship_content AS ship_content_8, s0_.booking_date AS booking_date_9, s0_.shiper_company AS shiper_company_10, s0_.shiper_address AS shiper_address_11, s0_.shiper_city AS shiper_city_12, s0_.shiper_state AS shiper_state_13, s0_.shiper_zip_code AS shiper_zip_code_14, s0_.sender_name AS sender_name_15, s0_.shiper_tel_no AS shiper_tel_no_16, s0_.shiper_mp AS shiper_mp_17, s0_.consigne_company AS consigne_company_18, s0_.consigne_adress AS consigne_adress_19, s0_.consigne_city AS consigne_city_20, s0_.consigne_state AS consigne_state_21, s0_.consigne_zip_code AS consigne_zip_code_22, s0_.recipent_name AS recipent_name_23, s0_.consigne_tel_no AS consigne_tel_no_24, s0_.consigne_mp AS consigne_mp_25, s0_.remarks AS remarks_26, s0_.height AS height_27, s0_.width AS width_28, s0_.length AS length_29, s0_.pickupby AS pickupby_30, s0_.pickup_date AS pickup_date_31, s0_.total_amount AS total_amount_32, s0_.collect_amount AS collect_amount_33, s0_.third_party_amount AS third_party_amount_34, s0_.cheque_no AS cheque_no_35, s0_.account_no AS account_no_36, s0_.note AS note_37, s0_.deliverystatus AS deliverystatus_38, s0_.trackingstatus AS trackingstatus_39, s0_.nid AS nid_40, s0_.payment_mode AS payment_mode_41, s0_.consigne_nid AS consigne_nid_42, s0_.nid_path AS nid_path_43, s0_.awb_path AS awb_path_44, s0_.invoice_path AS invoice_path_45, s0_.other_path AS other_path_46, s0_.courier_id AS courier_id_47, s0_.origin_country_id AS origin_country_id_48, s0_.destination_country_id AS destination_country_id_49, s0_.shipper_id AS shipper_id_50, s0_.consignee_id AS consignee_id_51 FROM shipment s0_ WHERE (s0_.consignment_no LIKE '%%' OR s0_.shipper_account LIKE '%%' OR s0_.shiper_company LIKE '%%' OR s0_.courier_awb_no LIKE '%%') AND s0_.id IN (6083, 6082, 6081, 6080, 6079, 6078, 6077, 6076, 6075, 6074) ORDER BY s0_.id DESC;