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.00040s] {'external_1_1': 451997676855598, 'external_1_2': 473658691440}
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.00016s] {'external_1': 451997676855598}
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.005525s ago] {'external_1': 451997676855598}
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.5677s ago] {'external_1_1': 3524938350609339, 'external_1_2': 492344229273145}
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.5663s ago] {'external_1': 3524938350609339}
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.5718s ago] {'external_1': 3524938350609339}
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 6.037s ago] {'barcode': <AutotestUser.barcode_free: 'FREE'>, 'wms_id_1': 10287}