INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT shaded_id.external, barcode_info.barcode, cart_item.quantity, CAST(cart_item.purchase_price AS FLOAT) AS purchase_price 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_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.00025s] {'external_1_1': 7434666987614670, 'external_1_2': 146482731010}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.invoice_number, invoice.invoice_status 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id 
WHERE shaded_id.external = %(external_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [generated in 0.00011s] {'external_1': 7434666987614670}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.invoice_number, invoice.invoice_status 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id 
WHERE shaded_id.external = %(external_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.00488s ago] {'external_1': 7434666987614670}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT shaded_id.external, barcode_info.barcode, cart_item.quantity, CAST(cart_item.purchase_price AS FLOAT) AS purchase_price 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_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 [cached since 0.8142s ago] {'external_1_1': 379175332247, 'external_1_2': 2664887542}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.invoice_number, invoice.invoice_status 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id 
WHERE shaded_id.external = %(external_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8136s ago] {'external_1': 379175332247}
INFO     sqlalchemy.engine.Engine:base.py:1846 SELECT invoice.invoice_number, invoice.invoice_status 
FROM shaded_id JOIN sku ON shaded_id.id = sku.shaded_id_id JOIN barcode_info ON sku.id = barcode_info.sku_id JOIN cart_item ON barcode_info.id = cart_item.barcode_info_id JOIN cart ON cart.id = cart_item.cart_id JOIN invoice ON invoice.id = cart.invoice_id 
WHERE shaded_id.external = %(external_1)s
INFO     sqlalchemy.engine.Engine:base.py:1846 [cached since 0.8187s ago] {'external_1': 379175332247}
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 [cached since 16.36s ago] {'barcode': <AutotestUser.barcode_free: 'FREE'>, 'wms_id_1': 10175}