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 INSERT INTO packing_table (barcode, warehouse_id, date_updated, big_bag_barcode, worker_id, workplace_id, box_barcode) VALUES (%(barcode)s, %(warehouse_id)s, %(date_updated)s, %(big_bag_barcode)s, %(worker_id)s, %(workplace_id)s, %(box_barcode)s) RETURNING packing_table.id INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00017s] {'barcode': 'UP-QA-70335013216388096', 'warehouse_id': 1693627, 'date_updated': None, 'big_bag_barcode': None, 'worker_id': None, 'workplace_id': None, 'box_barcode': None} INFO sqlalchemy.engine.Engine:base.py:2716 COMMIT using DBAPI connection.commit(), has no effect due to autocommit mode 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 packing_table.id AS packing_table_id, packing_table.barcode AS packing_table_barcode, packing_table.warehouse_id AS packing_table_warehouse_id, packing_table.date_updated AS packing_table_date_updated, packing_table.big_bag_barcode AS packing_table_big_bag_barcode, packing_table.worker_id AS packing_table_worker_id, packing_table.workplace_id AS packing_table_workplace_id, packing_table.box_barcode AS packing_table_box_barcode FROM packing_table WHERE packing_table.id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00021s] {'pk_1': 98500} 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 account.wms_id, account.is_active, account.first_name, account.last_name, account.password, account.phone, account.is_pass_change_needed, account.code, account.date_created, account.linked_delivery_point_id, account.patronymic, account.zone_id, account.role_wms_id, account.warehouse_id, account.barcode, account.cell_key, account.jobtitle, account.pinfl FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s AND account.warehouse_id = %(warehouse_id_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00024s] {'first_name_1': 'Phantom', 'last_name_1': 'Lancer', 'barcode_1': , 'warehouse_id_1': 1693627, 'param_1': 1} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.first_name AS account_first_name, account.last_name AS account_last_name, account.password AS account_password, account.phone AS account_phone, account.is_pass_change_needed AS account_is_pass_change_needed, account.code AS account_code, account.date_created AS account_date_created, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.warehouse_id AS account_warehouse_id, account.barcode AS account_barcode, account.cell_key AS account_cell_key, account.jobtitle AS account_jobtitle, account.pinfl AS account_pinfl FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00025s] {'pk_1': 100309} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE account SET barcode=%(barcode)s WHERE account.wms_id = %(wms_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00026s] {'barcode': , 'wms_id_1': 100309} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00022s] {'barcode_1': 'UP-QA-70335013216388096'} INFO sqlalchemy.engine.Engine:base.py:1846 UPDATE packing_table SET worker_id=%(worker_id)s WHERE packing_table.barcode = %(barcode_1)s AND packing_table.warehouse_id = %(warehouse_id_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] {'worker_id': 100309, 'barcode_1': 'UP-QA-70335013216388096', 'warehouse_id_1': 1693627} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.003629s ago] {'barcode_1': 'UP-QA-70335013216388096'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.0541s ago] {'barcode_1': 'UP-QA-70335013216388096'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1018s ago] {'barcode_1': 'UP-QA-70335013216388096'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1388s ago] {'barcode_1': 'UP-QA-70335013216388096'} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT packing_table.id, packing_table.barcode, packing_table.warehouse_id, packing_table.date_updated, packing_table.big_bag_barcode, packing_table.worker_id, packing_table.workplace_id, packing_table.box_barcode FROM packing_table WHERE packing_table.barcode = %(barcode_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [cached since 0.1824s ago] {'barcode_1': 'UP-QA-70335013216388096'}