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_template.id, package_template.template_id, package_template.template_name, package_template.init_state, package_template.channel_type, package_template.package_type, package_template.is_manifest_generation_required, package_template.created_at, package_template.updated_at, package_template.is_deleted, package_template.is_weighing_needed, package_template.hub_id, package_template.generate_tracking_number_type, package_template.is_sent_to_cds, package_template.is_pre_sort_plan_workflow, package_template.is_cod, package_template.partner_id, package_template.first_mile_provider_id, package_template.cargo_prefix, package_template.first_mile_tracking_type, package_template.last_mile_tracking_type, package_template.commercial_provider_id, package_template.callback_directions, package_template.transit_country_override, package_template.static_sender, package_template.manifest_provider, package_template.last_mile_provider, package_template.destination_code 
FROM package_template
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00024s] {}
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 [generated in 0.00022s] {'id_1': 53}
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 [generated in 0.00017s] {'id_1': 27}
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 [generated in 0.00014s] {'pk_1': 53}
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 [generated in 0.00013s] {'inbound_plan_id_1': 27}
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 0.002634s ago] {'pk_1': 53}
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 [generated in 0.00011s] {'id_1': 74}
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 0.005846s ago] {'pk_1': 53}
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 0.002096s ago] {'id_1': 73}
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 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 [generated in 0.00017s] {'cargo_barcode_1': 'BB-70507830836809216', 'hub_id_1': 3}