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 17.21s ago] {'id_1': 107} 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 17.21s ago] {'id_1': 11} 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 17.21s ago] {'pk_1': 107} 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 17.21s ago] {'inbound_plan_id_1': 11} 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 17.21s ago] {'pk_1': 107} 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 17.21s ago] {'id_1': 62} 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 17.22s ago] {'pk_1': 107} 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 17.21s ago] {'id_1': 61} 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 17.22s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 16.74s ago] {'awb_number_1': '7059416158'} 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 17.25s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.36s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.36s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.46s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.46s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.56s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1} 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 17.82s ago] {'cargo_barcode_1': 'JM000000239DM', 'hub_id_1': 1}