Query Metrics
5
Database Queries
5
Different statements
43.02 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info | ||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 3.68 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 | 37.56 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 | 0.66 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 | 0.61 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.50 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
]
|
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. |