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.is_pass_change_needed, account.first_name, account.last_name, account.password, account.phone, account.barcode, account.cell_key, account.code, account.date_created, account.jobtitle, account.linked_delivery_point_id, account.patronymic, account.pinfl, account.warehouse_id, account.zone_id, account.role_wms_id, account.language_code, account.profile_pic, account.cabinet_type, account.company_id FROM account WHERE account.first_name = %(first_name_1)s AND account.last_name = %(last_name_1)s AND account.barcode = %(barcode_1)s ORDER BY random() LIMIT %(param_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00015s] {'first_name_1': , 'last_name_1': , 'barcode_1': , 'param_1': 1} 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.00010s] {'barcode': , 'wms_id_1': 10028} INFO sqlalchemy.engine.Engine:base.py:1846 SELECT account.wms_id AS account_wms_id, account.is_active AS account_is_active, account.is_pass_change_needed AS account_is_pass_change_needed, 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.barcode AS account_barcode, account.cell_key AS account_cell_key, account.code AS account_code, account.date_created AS account_date_created, account.jobtitle AS account_jobtitle, account.linked_delivery_point_id AS account_linked_delivery_point_id, account.patronymic AS account_patronymic, account.pinfl AS account_pinfl, account.warehouse_id AS account_warehouse_id, account.zone_id AS account_zone_id, account.role_wms_id AS account_role_wms_id, account.language_code AS account_language_code, account.profile_pic AS account_profile_pic, account.cabinet_type AS account_cabinet_type, account.company_id AS account_company_id FROM account WHERE account.wms_id = %(pk_1)s INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00009s] {'pk_1': 10028} 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 shaded_id.external AS external_sku_id, barcode_info.barcode, sku.name, sku.description, sku_picture.url AS photo_url, CAST(sku.purchase_price AS FLOAT) AS purchase_price, sku.weight, sku.length, sku.width, sku.height FROM sku JOIN shaded_id ON sku.shaded_id_id = shaded_id.id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN sku_picture ON sku.id = sku_picture.sku_id WHERE shaded_id.external IN (%(external_1_1)s, %(external_1_2)s) ORDER BY shaded_id.external INFO sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00019s] {'external_1_1': 751561051874545, 'external_1_2': 4851503561475532}