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 8.339s 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 8.347s 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 8.347s 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 8.345s 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 8.344s 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 8.347s 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 8.345s 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 8.349s 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 8.347s 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 8.351s 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 8.344s 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 8.345s 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 8.195s ago] {'external_id_1': '70162180747076608', '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 6.747s 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 6.746s ago] {'state': <CptShipmentState.Finished: 'Finished'>, 'inbound_zone_barcode_1': 'IG0000004', 'id_1': 3385}
INFO     sqlalchemy.engine.Engine:base.py:1846 select pg_catalog.version()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 select current_schema()
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:1846 show standard_conforming_strings
INFO     sqlalchemy.engine.Engine:base.py:1846 [raw sql] {}
INFO     sqlalchemy.engine.Engine:base.py:2710 BEGIN (implicit; DBAPI should not BEGIN due to autocommit mode)
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 [generated in 0.00012s] {'tracking_number_1': 'FF-70162180878581248'}
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 0.002111s ago] {'tracking_number_1': 'FF-70162180878584320'}
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 0.002883s ago] {'tracking_number_1': 'FF-70162180878585856'}
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 0.003604s ago] {'tracking_number_1': 'FF-70162180878586880'}
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 [generated in 0.00010s] {'user_id': None, 'shipment_id_1': 3385}
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 [generated in 0.00009s] {'state': <CptShipmentState.Finished: 'Finished'>, 'id_1': 3385}