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 26.71s 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 26.72s 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 26.72s 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 26.72s 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 26.72s 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 26.72s 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 26.72s 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 26.72s 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 26.72s 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 26.73s 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 26.72s 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 26.72s 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 26.52s ago] {'external_id_1': '70507856635180800', 'hub_id_1': 4, 'state_1': } 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 25.93s 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 25.93s ago] {'state': , 'inbound_zone_barcode_1': 'IG0000004', 'id_1': 3893} 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 27.57s ago] {'pk_1': 111} 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 task.id, task.barcode, task.state, task.courier_company_name, task.created_at, task.updated_at, task.is_deleted, task.updated_by, task.return_user_id, task.dispatch_user_id FROM task WHERE task.id IN (%(id_1_1)s) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00020s] {'id_1_1': 53} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task.id, task.barcode, task.state, task.courier_company_name, task.created_at, task.updated_at, task.is_deleted, task.updated_by, task.return_user_id, task.dispatch_user_id FROM task WHERE task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00026s] {'id_1': 53} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task.id, task.barcode, task.state, task.courier_company_name, task.created_at, task.updated_at, task.is_deleted, task.updated_by, task.return_user_id, task.dispatch_user_id FROM task WHERE task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.2072s ago] {'id_1': 53} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT task.id, task.barcode, task.state, task.courier_company_name, task.created_at, task.updated_at, task.is_deleted, task.updated_by, task.return_user_id, task.dispatch_user_id FROM task WHERE task.id = %(id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.3464s ago] {'id_1': 53} 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 22.75s ago] {'user_id': None, 'shipment_id_1': 3893} 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 22.75s ago] {'state': , 'id_1': 3893} 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 22.76s ago] {'user_id': None, 'shipment_id_1': 3796} 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 22.76s ago] {'state': , 'id_1': 3796} 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 22.76s ago] {'user_id': None, 'shipment_id_1': 3801} 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 22.76s ago] {'state': , 'id_1': 3801} 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 22.76s ago] {'user_id': None, 'shipment_id_1': 3806} 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 22.76s ago] {'state': , 'id_1': 3806} 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 22.76s ago] {'user_id': None, 'shipment_id_1': 3811} 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 22.76s ago] {'state': , 'id_1': 3811} 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 22.77s ago] {'user_id': None, 'shipment_id_1': 3816} 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 22.77s ago] {'state': , 'id_1': 3816} 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 22.77s ago] {'user_id': None, 'shipment_id_1': 3825} 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 22.77s ago] {'state': , 'id_1': 3825} 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 22.77s ago] {'user_id': None, 'shipment_id_1': 3830} 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 22.77s ago] {'state': , 'id_1': 3830} 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 22.77s ago] {'user_id': None, 'shipment_id_1': 3835} 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 22.77s ago] {'state': , 'id_1': 3835} 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 22.77s ago] {'user_id': None, 'shipment_id_1': 3835} 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 22.77s ago] {'state': , 'id_1': 3835} 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 22.78s ago] {'user_id': None, 'shipment_id_1': 3835} 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 22.78s ago] {'state': , 'id_1': 3835} 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 22.78s ago] {'user_id': None, 'shipment_id_1': 3835} 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 22.78s ago] {'state': , 'id_1': 3835} 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 22.78s ago] {'user_id': None, 'shipment_id_1': 3841} 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 22.78s ago] {'state': , 'id_1': 3841} 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 22.78s ago] {'user_id': None, 'shipment_id_1': 3841} 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 22.78s ago] {'state': , 'id_1': 3841} 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 22.79s ago] {'user_id': None, 'shipment_id_1': 3841} 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 22.79s ago] {'state': , 'id_1': 3841} 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 22.79s ago] {'user_id': None, 'shipment_id_1': 3841} 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 22.79s ago] {'state': , 'id_1': 3841} 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 22.79s ago] {'user_id': None, 'shipment_id_1': 3847} 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 22.79s ago] {'state': , 'id_1': 3847} 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 22.79s ago] {'user_id': None, 'shipment_id_1': 3852} 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 22.79s ago] {'state': , 'id_1': 3852} 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 22.8s ago] {'user_id': None, 'shipment_id_1': 3852} 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 22.8s ago] {'state': , 'id_1': 3852} 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 22.8s ago] {'user_id': None, 'shipment_id_1': 3852} 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 22.8s ago] {'state': , 'id_1': 3852} 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 22.8s ago] {'user_id': None, 'shipment_id_1': 3852} 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 22.8s ago] {'state': , 'id_1': 3852} 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 22.8s ago] {'user_id': None, 'shipment_id_1': 3858} 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 22.8s ago] {'state': , 'id_1': 3858} 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 22.8s ago] {'user_id': None, 'shipment_id_1': 3858} 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 22.8s ago] {'state': , 'id_1': 3858} 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 22.81s ago] {'user_id': None, 'shipment_id_1': 3864} 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 22.81s ago] {'state': , 'id_1': 3864} 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 22.81s ago] {'user_id': None, 'shipment_id_1': 3864} 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 22.81s ago] {'state': , 'id_1': 3864} 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 22.81s ago] {'user_id': None, 'shipment_id_1': 3864} 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 22.81s ago] {'state': , 'id_1': 3864} 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 22.81s ago] {'user_id': None, 'shipment_id_1': 3870} 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 22.81s ago] {'state': , 'id_1': 3870} 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 22.82s ago] {'user_id': None, 'shipment_id_1': 3870} 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 22.82s ago] {'state': , 'id_1': 3870} 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 22.82s ago] {'user_id': None, 'shipment_id_1': 3870} 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 22.82s ago] {'state': , 'id_1': 3870} 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 22.82s ago] {'user_id': None, 'shipment_id_1': 3870} 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 22.82s ago] {'state': , 'id_1': 3870} 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 22.82s ago] {'user_id': None, 'shipment_id_1': 3876} 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 22.82s ago] {'state': , 'id_1': 3876} 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 22.83s ago] {'user_id': None, 'shipment_id_1': 3876} 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 22.82s ago] {'state': , 'id_1': 3876} 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 22.83s ago] {'user_id': None, 'shipment_id_1': 3876} 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 22.83s ago] {'state': , 'id_1': 3876} 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 22.83s ago] {'user_id': None, 'shipment_id_1': 3876} 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 22.83s ago] {'state': , 'id_1': 3876} 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 22.83s ago] {'user_id': None, 'shipment_id_1': 3882} 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 22.83s ago] {'state': , 'id_1': 3882} 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 22.84s ago] {'user_id': None, 'shipment_id_1': 3882} 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 22.84s ago] {'state': , 'id_1': 3882} 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 22.84s ago] {'user_id': None, 'shipment_id_1': 3882} 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 22.84s ago] {'state': , 'id_1': 3882} 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 22.84s ago] {'user_id': None, 'shipment_id_1': 3882} 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 22.84s ago] {'state': , 'id_1': 3882} 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 22.84s ago] {'user_id': None, 'shipment_id_1': 3888} 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 22.84s ago] {'state': , 'id_1': 3888} 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 22.84s ago] {'user_id': None, 'shipment_id_1': 3893} 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 22.84s ago] {'state': , 'id_1': 3893} 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 22.85s ago] {'user_id': None, 'shipment_id_1': 3893} 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 22.85s ago] {'state': , 'id_1': 3893} 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 22.85s ago] {'user_id': None, 'shipment_id_1': 3893} 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 22.85s ago] {'state': , 'id_1': 3893} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE task SET return_user_id=%(return_user_id)s, dispatch_user_id=%(dispatch_user_id)s WHERE task.id IN (%(id_1_1)s) INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00016s] {'return_user_id': None, 'dispatch_user_id': None, 'id_1_1': 53}