GET https://www.tpc-bd.org/track/link/5066033871/6066

Query Metrics

6 Database Queries
6 Different statements
625.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 20.54 ms
SELECT t0.id AS id_1, t0.consignment_no AS consignment_no_2, t0.shipper_account AS shipper_account_3, t0.ref_no AS ref_no_4, t0.courier_awb_no AS courier_awb_no_5, t0.type AS type_6, t0.pieces AS pieces_7, t0.weight AS weight_8, t0.ship_content AS ship_content_9, t0.booking_date AS booking_date_10, t0.shiper_company AS shiper_company_11, t0.shiper_address AS shiper_address_12, t0.shiper_city AS shiper_city_13, t0.shiper_state AS shiper_state_14, t0.shiper_zip_code AS shiper_zip_code_15, t0.sender_name AS sender_name_16, t0.shiper_tel_no AS shiper_tel_no_17, t0.shiper_mp AS shiper_mp_18, t0.consigne_company AS consigne_company_19, t0.consigne_adress AS consigne_adress_20, t0.consigne_city AS consigne_city_21, t0.consigne_state AS consigne_state_22, t0.consigne_zip_code AS consigne_zip_code_23, t0.recipent_name AS recipent_name_24, t0.consigne_tel_no AS consigne_tel_no_25, t0.consigne_mp AS consigne_mp_26, t0.remarks AS remarks_27, t0.height AS height_28, t0.width AS width_29, t0.length AS length_30, t0.pickupby AS pickupby_31, t0.pickup_date AS pickup_date_32, t0.total_amount AS total_amount_33, t0.collect_amount AS collect_amount_34, t0.third_party_amount AS third_party_amount_35, t0.cheque_no AS cheque_no_36, t0.account_no AS account_no_37, t0.note AS note_38, t0.deliverystatus AS deliverystatus_39, t0.trackingstatus AS trackingstatus_40, t0.nid AS nid_41, t0.payment_mode AS payment_mode_42, t0.consigne_nid AS consigne_nid_43, t0.nid_path AS nid_path_44, t0.awb_path AS awb_path_45, t0.invoice_path AS invoice_path_46, t0.other_path AS other_path_47, t0.courier_id AS courier_id_48, t0.origin_country_id AS origin_country_id_49, t0.destination_country_id AS destination_country_id_50, t0.shipper_id AS shipper_id_51, t0.consignee_id AS consignee_id_52 FROM shipment t0 WHERE t0.id = ?
Parameters:
[
  "6066"
]
2 561.81 ms
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 = ?
Parameters:
[
  "5066033871"
]
3 2.47 ms
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 = ?
Parameters:
[
  2
]
4 1.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.remarks AS remarks_4 FROM origin_country t0 WHERE t0.id = ?
Parameters:
[
  4
]
5 0.68 ms
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 = ?
Parameters:
[
  1
]
6 38.73 ms
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.email = ? LIMIT 1
Parameters:
[
  "theprofessionalcourier@outlook.com"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Shipment No errors.
App\Entity\Courier No errors.
App\Entity\OriginCountry No errors.
App\Entity\DestinationCountry No errors.
App\Entity\Shipper No errors.
App\Entity\Consignee No errors.
App\Entity\ShipmentDocuments No errors.
App\Entity\Booking No errors.
App\Entity\User No errors.