SQL (0.139206) DROP TABLE invoices SQL (0.119057) CREATE TABLE invoices (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `subtotal` decimal, `total` decimal, `paid` decimal, `due` decimal, `tax` decimal) ENGINE=InnoDB SQL (0.255608) DROP TABLE line_items SQL (0.156956) CREATE TABLE line_items (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.303859) DROP TABLE payments SQL (0.061323) CREATE TABLE payments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.000000) Mysql::Error: Table 'schema_info' already exists: CREATE TABLE schema_info (version int(11)) SQL (0.000650) SHOW FIELDS FROM schema_info SQL (0.079441) UPDATE schema_info SET version = 1 SQL (0.000202) BEGIN Invoice Load (0.000662) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Invoice Columns (0.000540) SHOW FIELDS FROM invoices LineItem Load (0.000848) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  LineItem Columns (0.000379) SHOW FIELDS FROM line_items Payment Load (0.000762) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000933) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.000568) INSERT INTO line_items (`invoice_id`, `total`) VALUES(1, 5.0) Invoice Update (0.000698) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000626) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000573) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 SQL (0.161411) ROLLBACK SQL (0.000211) BEGIN Invoice Load (0.000686) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000641) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.001509) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000602) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000618) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  Payment Load (0.000589) SELECT * FROM payments WHERE (payments.invoice_id = 2)  Payment Columns (0.000370) SHOW FIELDS FROM payments SQL (0.000321) ROLLBACK SQL (0.000194) BEGIN Invoice Load (0.000678) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Payment Load (0.000589) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000575) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 Payment Load (0.000510) SELECT * FROM payments WHERE (payments.invoice_id = 2)  SQL (0.000298) ROLLBACK SQL (0.000189) BEGIN Invoice Load (0.000599) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000598) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000543) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000862) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 LineItem Load (0.000646) SELECT * FROM line_items WHERE (line_items.id = 1) LIMIT 1 LineItem Update (0.000606) UPDATE line_items SET invoice_id = NULL WHERE (invoice_id = 1 AND id IN (1))  Invoice Update (0.000655) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000592) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000589) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 SQL (0.053543) ROLLBACK SQL (0.000246) BEGIN Invoice Load (0.000634) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000574) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000652) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000551) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000299) ROLLBACK SQL (0.000172) BEGIN Invoice Load (0.000680) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000693) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.001610) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.001054) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.051534) ROLLBACK SQL (0.000223) BEGIN Invoice Load (0.000679) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000648) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  SQL (0.000340) ROLLBACK SQL (0.000201) BEGIN Invoice Load (0.000699) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000629) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.004050) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000720) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000319) ROLLBACK SQL (0.266483) DROP TABLE invoices SQL (0.139284) CREATE TABLE invoices (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `subtotal` decimal, `total` decimal, `paid` decimal, `due` decimal, `tax` decimal) ENGINE=InnoDB SQL (0.154916) DROP TABLE line_items SQL (0.095382) CREATE TABLE line_items (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.228907) DROP TABLE payments SQL (0.088620) CREATE TABLE payments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.000000) Mysql::Error: Table 'schema_info' already exists: CREATE TABLE schema_info (version int(11)) SQL (0.000689) SHOW FIELDS FROM schema_info SQL (0.127561) UPDATE schema_info SET version = 1 SQL (0.000258) BEGIN Invoice Load (0.000749) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Invoice Columns (0.000622) SHOW FIELDS FROM invoices LineItem Load (0.000785) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  LineItem Columns (0.000487) SHOW FIELDS FROM line_items Payment Load (0.000800) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.001107) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.000557) INSERT INTO line_items (`invoice_id`, `total`) VALUES(1, 5.0) Invoice Update (0.001553) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000593) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000557) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 SQL (0.044591) ROLLBACK SQL (0.000197) BEGIN Invoice Load (0.000750) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.002124) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.001103) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.001575) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000599) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  Payment Load (0.000648) SELECT * FROM payments WHERE (payments.invoice_id = 2)  Payment Columns (0.000382) SHOW FIELDS FROM payments SQL (0.000310) ROLLBACK SQL (0.000196) BEGIN Invoice Load (0.000699) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Payment Load (0.000548) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000561) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 Payment Load (0.000515) SELECT * FROM payments WHERE (payments.invoice_id = 2)  SQL (0.000292) ROLLBACK SQL (0.000187) BEGIN Invoice Load (0.000595) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000853) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.001109) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000827) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 LineItem Load (0.000705) SELECT * FROM line_items WHERE (line_items.id = 1) LIMIT 1 LineItem Update (0.000620) UPDATE line_items SET invoice_id = NULL WHERE (invoice_id = 1 AND id IN (1))  Invoice Update (0.000659) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000578) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000602) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 SQL (0.198581) ROLLBACK SQL (0.000221) BEGIN Invoice Load (0.000652) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000569) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000699) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000570) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000378) ROLLBACK SQL (0.000203) BEGIN Invoice Load (0.000618) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000688) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000548) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000807) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.057107) ROLLBACK SQL (0.000296) BEGIN Invoice Load (0.003888) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000655) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  SQL (0.000330) ROLLBACK SQL (0.000183) BEGIN Invoice Load (0.000685) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000688) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000627) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.003635) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000370) ROLLBACK SQL (0.126632) DROP TABLE invoices SQL (0.249425) CREATE TABLE invoices (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `subtotal` decimal, `total` decimal, `paid` decimal, `due` decimal, `tax` decimal) ENGINE=InnoDB SQL (0.127114) DROP TABLE line_items SQL (0.078766) CREATE TABLE line_items (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.155950) DROP TABLE payments SQL (0.079419) CREATE TABLE payments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.000000) Mysql::Error: Table 'schema_info' already exists: CREATE TABLE schema_info (version int(11)) SQL (0.000656) SHOW FIELDS FROM schema_info SQL (0.000742) UPDATE schema_info SET version = 1 SQL (0.000235) BEGIN Invoice Load (0.000669) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Invoice Columns (0.000547) SHOW FIELDS FROM invoices LineItem Load (0.005025) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  LineItem Columns (0.000461) SHOW FIELDS FROM line_items Payment Load (0.000748) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000814) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.000579) INSERT INTO line_items (`invoice_id`, `total`) VALUES(1, 5.0) Invoice Update (0.000744) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.001095) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000580) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 SQL (0.049766) ROLLBACK SQL (0.000399) BEGIN Invoice Load (0.000640) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000597) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000657) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000655) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.002065) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  Payment Load (0.000578) SELECT * FROM payments WHERE (payments.invoice_id = 2)  Payment Columns (0.000375) SHOW FIELDS FROM payments SQL (0.001894) ROLLBACK SQL (0.000262) BEGIN Invoice Load (0.000696) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Payment Load (0.000566) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000576) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 Payment Load (0.000525) SELECT * FROM payments WHERE (payments.invoice_id = 2)  SQL (0.000347) ROLLBACK SQL (0.000196) BEGIN Invoice Load (0.000614) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000590) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000516) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000750) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 LineItem Load (0.000627) SELECT * FROM line_items WHERE (line_items.id = 1) LIMIT 1 LineItem Update (0.000614) UPDATE line_items SET invoice_id = NULL WHERE (invoice_id = 1 AND id IN (1))  Invoice Update (0.000710) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000647) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000602) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 SQL (0.057572) ROLLBACK SQL (0.000230) BEGIN Invoice Load (0.000642) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000750) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000646) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000556) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000311) ROLLBACK SQL (0.000212) BEGIN Invoice Load (0.000622) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000673) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000684) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000783) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.050956) ROLLBACK SQL (0.000289) BEGIN Invoice Load (0.000650) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000576) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  SQL (0.000314) ROLLBACK SQL (0.000200) BEGIN Invoice Load (0.000622) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000574) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000685) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000792) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000331) ROLLBACK SQL (0.126486) DROP TABLE invoices SQL (0.095926) CREATE TABLE invoices (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `subtotal` decimal, `total` decimal, `paid` decimal, `due` decimal, `tax` decimal) ENGINE=InnoDB SQL (0.198544) DROP TABLE line_items SQL (0.086939) CREATE TABLE line_items (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.154589) DROP TABLE payments SQL (0.084895) CREATE TABLE payments (`id` int(11) DEFAULT NULL auto_increment PRIMARY KEY, `invoice_id` int(11), `total` decimal) ENGINE=InnoDB SQL (0.000000) Mysql::Error: Table 'schema_info' already exists: CREATE TABLE schema_info (version int(11)) SQL (0.115493) SHOW FIELDS FROM schema_info SQL (0.003481) UPDATE schema_info SET version = 1 SQL (0.000282) BEGIN Invoice Load (0.085476) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Invoice Columns (0.000822) SHOW FIELDS FROM invoices LineItem Load (0.000984) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  LineItem Columns (0.000551) SHOW FIELDS FROM line_items Payment Load (0.000881) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.011030) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.010646) INSERT INTO line_items (`invoice_id`, `total`) VALUES(1, 5.0) Invoice Update (0.000857) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000701) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 Invoice Update (0.000694) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 15.0, `total` = 15.0, `subtotal` = 15.0 WHERE id = 1 SQL (0.040869) ROLLBACK SQL (0.000282) BEGIN Invoice Load (0.000815) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000760) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000714) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000822) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000763) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  Payment Load (0.000738) SELECT * FROM payments WHERE (payments.invoice_id = 2)  Payment Columns (0.000568) SHOW FIELDS FROM payments SQL (0.000378) ROLLBACK SQL (0.000308) BEGIN Invoice Load (0.000879) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 Payment Load (0.000700) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Load (0.000763) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 Payment Load (0.000684) SELECT * FROM payments WHERE (payments.invoice_id = 2)  SQL (0.000422) ROLLBACK SQL (0.000260) BEGIN Invoice Load (0.000800) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000823) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000687) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000975) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 LineItem Load (0.000835) SELECT * FROM line_items WHERE (line_items.id = 1) LIMIT 1 LineItem Update (0.025256) UPDATE line_items SET invoice_id = NULL WHERE (invoice_id = 1 AND id IN (1))  Invoice Update (0.000886) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000715) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 Invoice Update (0.000705) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 5.0, `total` = 5.0, `subtotal` = 5.0 WHERE id = 1 SQL (0.041005) ROLLBACK SQL (0.000278) BEGIN Invoice Load (0.000835) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000775) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000894) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.003611) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000397) ROLLBACK SQL (0.000267) BEGIN Invoice Load (0.000862) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.003872) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Payment Load (0.000791) SELECT * FROM payments WHERE (payments.invoice_id = 1)  Invoice Update (0.000781) UPDATE invoices SET `paid` = 0.0, `tax` = 0.0, `due` = 10.0, `total` = 10.0, `subtotal` = 10.0 WHERE id = 1 SQL (0.043910) ROLLBACK SQL (0.000213) BEGIN Invoice Load (0.000660) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000568) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  SQL (0.000280) ROLLBACK SQL (0.000241) BEGIN Invoice Load (0.000683) SELECT * FROM invoices WHERE (invoices.id = 1) LIMIT 1 LineItem Load (0.000677) SELECT * FROM line_items WHERE (line_items.invoice_id = 1)  Invoice Load (0.000606) SELECT * FROM invoices WHERE (invoices.id = 2) LIMIT 1 LineItem Load (0.000548) SELECT * FROM line_items WHERE (line_items.invoice_id = 2)  SQL (0.000279) ROLLBACK