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': 87228363845229, 'external_1_2': 8080720068806794}
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': 87228363845229}
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.006172s ago] {'external_1': 87228363845229}
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.7856s ago] {'external_1_1': 6311579089, 'external_1_2': 394272297452}
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.7849s ago] {'external_1': 6311579089}
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.7894s ago] {'external_1': 6311579089}
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 26.39s ago] {'barcode': <AutotestUser.barcode_free: 'FREE'>, 'wms_id_1': 10284}