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 23.59s ago] {'pk_1': 87}
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 23.6s ago] {'id_1': 87}
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 23.6s ago] {'id_1': 40}
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 23.6s ago] {'id_1': 97}
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 23.59s ago] {'pk_1': 87}
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 23.6s ago] {'id_1': 109}
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 23.6s ago] {'pk_1': 87}
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 23.6s ago] {'id_1': 111}
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 23.6s ago] {'pk_1': 87}
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 23.6s ago] {'id_1': 105}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id AS zone_id, zone.barcode AS zone_barcode, zone.hub_id AS zone_hub_id, zone.name AS zone_name, zone.type AS zone_type, zone.created_at AS zone_created_at, zone.updated_at AS zone_updated_at, zone.updated_by AS zone_updated_by 
FROM zone 
WHERE zone.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 23.59s ago] {'pk_1': 97}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id AS zone_id, zone.barcode AS zone_barcode, zone.hub_id AS zone_hub_id, zone.name AS zone_name, zone.type AS zone_type, zone.created_at AS zone_created_at, zone.updated_at AS zone_updated_at, zone.updated_by AS zone_updated_by 
FROM zone 
WHERE zone.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 23.59s ago] {'pk_1': 109}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT shipment.id, shipment.created_at, shipment.updated_at, shipment.is_deleted, shipment.barcode, shipment.state, shipment.inbound_zone_barcode, shipment.dispatch_zone_barcode, shipment.hub_id, shipment.inspection_officer_id, shipment.extra_inspection_officer_id, shipment.external_id, shipment.processing, shipment.packages_count, shipment.date_arrival, shipment.receiving_item_barcode, shipment.shipment_flow 
FROM shipment 
WHERE shipment.external_id = %(external_id_1)s AND shipment.hub_id = %(hub_id_1)s AND shipment.state = %(state_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 23.35s ago] {'external_id_1': '70248570703315200', 'hub_id_1': 4, 'state_1': <CptShipmentState.Created: 'Created'>}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE senior_receiving_staff SET user_id=%(user_id)s WHERE senior_receiving_staff.user_id = %(user_id_1)s AND senior_receiving_staff.finished_at IS NULL
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 22.71s ago] {'user_id': None, 'user_id_1': 16}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE shipment SET state=%(state)s WHERE shipment.inbound_zone_barcode = %(inbound_zone_barcode_1)s AND shipment.id != %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 22.71s ago] {'state': <CptShipmentState.Finished: 'Finished'>, 'inbound_zone_barcode_1': 'IG0000004', 'id_1': 3560}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id AS zone_id, zone.barcode AS zone_barcode, zone.hub_id AS zone_hub_id, zone.name AS zone_name, zone.type AS zone_type, zone.created_at AS zone_created_at, zone.updated_at AS zone_updated_at, zone.updated_by AS zone_updated_by 
FROM zone 
WHERE zone.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 24.21s ago] {'pk_1': 111}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT customs_officer.id, customs_officer.barcode, customs_officer.full_name, customs_officer.created_at, customs_officer.updated_at, customs_officer.is_deleted, customs_officer.updated_by 
FROM customs_officer
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00019s] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT customs_officer.id, customs_officer.barcode, customs_officer.full_name, customs_officer.created_at, customs_officer.updated_at, customs_officer.is_deleted, customs_officer.updated_by 
FROM customs_officer
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.09871s ago] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT zone.id AS zone_id, zone.barcode AS zone_barcode, zone.hub_id AS zone_hub_id, zone.name AS zone_name, zone.type AS zone_type, zone.created_at AS zone_created_at, zone.updated_at AS zone_updated_at, zone.updated_by AS zone_updated_by 
FROM zone 
WHERE zone.id = %(pk_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 25.1s ago] {'pk_1': 109}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT shipment.id, shipment.created_at, shipment.updated_at, shipment.is_deleted, shipment.barcode, shipment.state, shipment.inbound_zone_barcode, shipment.dispatch_zone_barcode, shipment.hub_id, shipment.inspection_officer_id, shipment.extra_inspection_officer_id, shipment.external_id, shipment.processing, shipment.packages_count, shipment.date_arrival, shipment.receiving_item_barcode, shipment.shipment_flow 
FROM shipment 
WHERE shipment.external_id = %(external_id_1)s AND shipment.hub_id = %(hub_id_1)s AND shipment.state = %(state_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 24.95s ago] {'external_id_1': '70248570703315200', 'hub_id_1': 4, 'state_1': <CptShipmentState.Finished: 'Finished'>}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE senior_receiving_staff SET user_id=%(user_id)s WHERE senior_receiving_staff.shipment_id = %(shipment_id_1)s AND senior_receiving_staff.finished_at IS NULL
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 19.48s ago] {'user_id': None, 'shipment_id_1': 3560}
INFO     sqlalchemy.engine.Engine:base.py:1846 UPDATE shipment SET state=%(state)s WHERE shipment.id = %(id_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 19.48s ago] {'state': <CptShipmentState.Finished: 'Finished'>, 'id_1': 3560}