INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sort_plan.id, sort_plan.name, sort_plan.inbound_plan_id, sort_plan.sort_key, sort_plan.dispatch_zone_id, sort_plan.created_at, sort_plan.updated_at, sort_plan.packing_zone_id, sort_plan.updated_by, sort_plan.inspection_zone_id, sort_plan.extra_inspection_zone_id 
FROM sort_plan 
WHERE sort_plan.id = %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.592s ago] {'id_1': 83}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT inbound_plan.id, inbound_plan.hub_id, inbound_plan.name, inbound_plan.destination_code, inbound_plan.inbound_prefix, inbound_plan.created_at, inbound_plan.updated_at, inbound_plan.plan_color, inbound_plan.updated_by, inbound_plan.additional_color, inbound_plan.transit_country, inbound_plan.inbound_zone_id, inbound_plan.post_code, inbound_plan.registration_type 
FROM inbound_plan 
WHERE inbound_plan.id = %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.592s ago] {'id_1': 35}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sort_plan.id AS sort_plan_id, sort_plan.name AS sort_plan_name, sort_plan.inbound_plan_id AS sort_plan_inbound_plan_id, sort_plan.sort_key AS sort_plan_sort_key, sort_plan.dispatch_zone_id AS sort_plan_dispatch_zone_id, sort_plan.created_at AS sort_plan_created_at, sort_plan.updated_at AS sort_plan_updated_at, sort_plan.packing_zone_id AS sort_plan_packing_zone_id, sort_plan.updated_by AS sort_plan_updated_by, sort_plan.inspection_zone_id AS sort_plan_inspection_zone_id, sort_plan.extra_inspection_zone_id AS sort_plan_extra_inspection_zone_id 
FROM sort_plan 
WHERE sort_plan.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.59s ago] {'pk_1': 83}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT workstation.id, workstation.barcode, workstation.hub_id, workstation.name, workstation.inbound_plan_id, workstation.created_at, workstation.updated_at, workstation.updated_by 
FROM workstation 
WHERE workstation.inbound_plan_id = %(inbound_plan_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.588s ago] {'inbound_plan_id_1': 35}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sort_plan.id AS sort_plan_id, sort_plan.name AS sort_plan_name, sort_plan.inbound_plan_id AS sort_plan_inbound_plan_id, sort_plan.sort_key AS sort_plan_sort_key, sort_plan.dispatch_zone_id AS sort_plan_dispatch_zone_id, sort_plan.created_at AS sort_plan_created_at, sort_plan.updated_at AS sort_plan_updated_at, sort_plan.packing_zone_id AS sort_plan_packing_zone_id, sort_plan.updated_by AS sort_plan_updated_by, sort_plan.inspection_zone_id AS sort_plan_inspection_zone_id, sort_plan.extra_inspection_zone_id AS sort_plan_extra_inspection_zone_id 
FROM sort_plan 
WHERE sort_plan.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.592s ago] {'pk_1': 83}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id, zone.barcode, zone.hub_id, zone.name, zone.type, zone.created_at, zone.updated_at, zone.updated_by 
FROM zone 
WHERE zone.id = %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.579s ago] {'id_1': 90}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT sort_plan.id AS sort_plan_id, sort_plan.name AS sort_plan_name, sort_plan.inbound_plan_id AS sort_plan_inbound_plan_id, sort_plan.sort_key AS sort_plan_sort_key, sort_plan.dispatch_zone_id AS sort_plan_dispatch_zone_id, sort_plan.created_at AS sort_plan_created_at, sort_plan.updated_at AS sort_plan_updated_at, sort_plan.packing_zone_id AS sort_plan_packing_zone_id, sort_plan.updated_by AS sort_plan_updated_by, sort_plan.inspection_zone_id AS sort_plan_inspection_zone_id, sort_plan.extra_inspection_zone_id AS sort_plan_extra_inspection_zone_id 
FROM sort_plan 
WHERE sort_plan.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.594s ago] {'pk_1': 83}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id, zone.barcode, zone.hub_id, zone.name, zone.type, zone.created_at, zone.updated_at, zone.updated_by 
FROM zone 
WHERE zone.id = %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.581s ago] {'id_1': 89}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT air_way_bill.id, air_way_bill.awb_number, air_way_bill.flight_number, air_way_bill.flight_departure_datetime, air_way_bill.airport_from, air_way_bill.airport_to, air_way_bill.created_at, air_way_bill.updated_at, air_way_bill.flight_arrival_datetime, air_way_bill.air_way_bill_source, air_way_bill.warehouse_id, air_way_bill.is_deleted, air_way_bill.arrival_terminal, air_way_bill.weight_gross_gr, air_way_bill.weight_chargeable_gr, air_way_bill.cargo_space_number, air_way_bill.awb_scan, air_way_bill.actual_flight_arrival_datetime, air_way_bill.actual_flight_departure_datetime, air_way_bill.customs_broker_id, air_way_bill.airline_name, air_way_bill.route 
FROM air_way_bill 
WHERE air_way_bill.awb_number = %(awb_number_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.046s ago] {'awb_number_1': '7042136230'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.501s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT package.id, package.logistic_order_code, package.tracking_number, package.destination_code, package.inbound_prefix, package.sort_key, package.state, package.type, package.weight_gr, package.created_at, package.updated_at, package.is_deleted, package.mail_class, package.registration_type, package.tracking_type, package.danger_type, package.sender, package.receiver, package.logistic_order_id, package.phone, package.postal_tracking_number, package.partner_id, package.template_id, package.transit_country, package.pre_sort_plan_id, package.post_code, package.clone_package_id, package.length_mm, package.width_mm, package.height_mm, package.price, package.defect_reason 
FROM package 
WHERE package.tracking_number = %(tracking_number_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 2.984s ago] {'tracking_number_1': 'GBS-70421361328761088'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT package.id, package.logistic_order_code, package.tracking_number, package.destination_code, package.inbound_prefix, package.sort_key, package.state, package.type, package.weight_gr, package.created_at, package.updated_at, package.is_deleted, package.mail_class, package.registration_type, package.tracking_type, package.danger_type, package.sender, package.receiver, package.logistic_order_id, package.phone, package.postal_tracking_number, package.partner_id, package.template_id, package.transit_country, package.pre_sort_plan_id, package.post_code, package.clone_package_id, package.length_mm, package.width_mm, package.height_mm, package.price, package.defect_reason 
FROM package 
WHERE package.tracking_number = %(tracking_number_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 3.075s ago] {'tracking_number_1': 'GBS-70421361399743232'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT package.id, package.logistic_order_code, package.tracking_number, package.destination_code, package.inbound_prefix, package.sort_key, package.state, package.type, package.weight_gr, package.created_at, package.updated_at, package.is_deleted, package.mail_class, package.registration_type, package.tracking_type, package.danger_type, package.sender, package.receiver, package.logistic_order_id, package.phone, package.postal_tracking_number, package.partner_id, package.template_id, package.transit_country, package.pre_sort_plan_id, package.post_code, package.clone_package_id, package.length_mm, package.width_mm, package.height_mm, package.price, package.defect_reason 
FROM package 
WHERE package.tracking_number = %(tracking_number_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 3.178s ago] {'tracking_number_1': 'GBS-70421361446910208'}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.859s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.86s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.966s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 9.967s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 10.07s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT big_bag.id, big_bag.cargo_barcode, big_bag.external_type, big_bag.state, big_bag.hub_id, big_bag.is_deleted, big_bag.created_at, big_bag.updated_at, big_bag.external_id, big_bag.weight_gr, big_bag.has_battery, big_bag.awb_number, big_bag.template_id, big_bag.remove_customs_packages_on_accept, big_bag.shipment_id 
FROM big_bag 
WHERE big_bag.cargo_barcode = %(cargo_barcode_1)s AND big_bag.hub_id = %(hub_id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 10.28s ago] {'cargo_barcode_1': 'GBS-70421361502550528', 'hub_id_1': 3}