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_template.id, big_bag_template.big_bag_template_id, big_bag_template.template_name, big_bag_template.big_bag_type, big_bag_template.init_state, big_bag_template.is_need_generate_barcode, big_bag_template.created_at, big_bag_template.updated_at, big_bag_template.is_deleted, big_bag_template.check_weight, big_bag_template.cargo_prefix, big_bag_template.remove_customs_packages_on_accept, big_bag_template.weight_deviation_percentage, big_bag_template.partner_id, big_bag_template.hub_id FROM big_bag_template INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00018s] {} 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.00023s] {'id_1': 17} 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.00012s] {'id_1': 10} 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.00013s] {'pk_1': 17} 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.00021s] {'inbound_plan_id_1': 10} 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.003101s ago] {'pk_1': 17} 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.00028s] {'id_1': 32} 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.006902s ago] {'pk_1': 17} 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.002903s ago] {'id_1': 44} 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.00018s] {'cargo_barcode_1': 'BB-70594145122793984', 'hub_id_1': 1} 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 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 [generated in 0.00014s] {'awb_number_1': '7059414594'} 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 0.05289s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.2261s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.2272s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.3143s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.3163s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.4378s ago] {'cargo_barcode_1': 'BB-70594145122793984', '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 0.7243s ago] {'cargo_barcode_1': 'BB-70594145122793984', 'hub_id_1': 1}