ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1e7e228f19d: POST https://beta.jinchangxiao.com/vue/tax/sales-invoice-save-edit at 2026-06-02 02:54:26 pm by 221.216.117.119

Performance Profiling

Total processing time: 57 ms; Peak memory: 5.862 MB. Show Profiling Timeline

总计61条数据
TimeDurationCategoryInfo
  
14:54:26.5932.9 msyii\db\Command::querySELECT "sip".*, sum(inventory) as inventory_count FROM "a57be577deb434"."tbl_sales_invoice_products" "sip" LEFT JOIN "a57be577deb434"."tbl_inventory_products" "ip" ON lower(ip.title) = lower(sip.title) AND lower(ip.description) = lower(sip.description) WHERE "sip"."sales_invoice_id"=2326 GROUP BY "sip"."id"
14:54:26.6022.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=2326)
14:54:26.6042.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20) AND ("object_id"=2326)
14:54:26.6061.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=2326)
14:54:26.6081.9 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=102) AND ("object_id"=2326)
14:54:26.6321.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (1001, '7', 4484, TRUE, '刘人诚编辑了：2026-06-01-001发票信息2026-06-02￥-88221', '商机：测试工单人工成本问题；客户：北京华辰悦科技有限公司') RETURNING "id"
14:54:26.6370.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_invoices" ("project_id", "created_by", "amount", "client_id") VALUES (4173, 1001, '88221', 3311), (4173, 1001, '-88221', 3311)
14:54:26.5990.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'from_date', 2326, 107, 1001, 'now()', '["2026-06-02"]', '[null]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5f00\u7968\u65e5\u671f","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 2026-06-02"]}'), (2, 'invoice_num', 2326, 107, 1001, 'now()', '["88221"]', '[""]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u53f7\u7801","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> 88221"]}')
14:54:26.6280.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 4173, 1, 2326, 107, 1001, '2326', '2326', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:54:26.6000.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "contract_id"=4484, "from_date"='2026-06-02', "amount"='-88221', "invoice_num"='88221', "invoice_type"=-1, "tax_amount"='0', "excluding_tax"='-88221', "updated_at"='now()' WHERE "id"=2326
14:54:26.6250.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 4173, 1, 2326, 107, 1001, '[2326]', '[2326]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:54:26.6400.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/sales-invoice-save-edit', '{"SalesContractInvoices":{"id":"2326","invoice_num":"88221","invoice_type":"-1","from_date":"2026-06-02","contract_id":"4484","description":"","contract_name":"2026-06-01-001","client_id":"3311","client_name":"\u5317\u4eac\u534e\u8fb0\u60a6\u79d1\u6280\u6709\u9650\u516c\u53f8","salesInvoiceReminders":"","files":"","attachmentFiles":""},"web_access_token":"eLSqRe8hqEgPBX_zWO9QINJWKjv2Vvg4"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u53d1\u7968\u4fe1\u606f\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 14:54:26', 53501952) RETURNING "id"
14:54:26.6210.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '107', 2326, '刘人诚编辑销售发票', TRUE, '销售发票：88221') RETURNING "id"
14:54:26.6110.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_invoice_amounts" WHERE "sales_invoice_id"=2326
14:54:26.6260.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 640897, 'a:13:{s:2:"id";i:640897;s:9:"object_id";i:4173;s:11:"object_type";i:1;s:9:"target_id";i:2326;s:18:"target_object_type";i:107;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[2326]";s:9:"new_value";s:6:"[2326]";s:11:"description";s:95:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
14:54:26.6350.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4173
14:54:26.6230.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3311, 10, 4484, 7, 1001, '[4484]', '[4484]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-01-001"]}') RETURNING "id"
14:54:26.6380.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 4484, 7, 2326, 107, 1001, '[2326]', '[2326]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:54:26.6010.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContractInvoices', 2326, 'a:2:{s:9:"from_date";s:10:"2026-06-02";s:11:"invoice_num";s:5:"88221";}', '', 1001, '221.216.117.119')
14:54:26.6160.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "match_tax_amount"='0', "simple_match_tax_amount"='0' WHERE "id"=2326
14:54:26.6120.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_sales_invoice_amounts" ("sales_invoice_id", "amount", "tax_rate") VALUES (2326, '-88221', 13)
14:54:26.6290.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 171852, 'a:15:{s:2:"id";i:171852;s:9:"object_id";i:4173;s:11:"object_type";i:1;s:9:"target_id";i:2326;s:18:"target_object_type";i:107;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:4:"2326";s:9:"new_value";s:4:"2326";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1001, '221.216.117.119')
14:54:26.6150.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesInvoiceProducts', 1280, 'a:0:{}', '', 1001, '221.216.117.119')
14:54:26.6170.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContractInvoices', 2326, 'a:0:{}', '', 1001, '221.216.117.119')
14:54:26.6140.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_invoice_products" SET "outbound"='0' WHERE "id"=1280
14:54:26.6390.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 640898, 'a:13:{s:2:"id";i:640898;s:9:"object_id";s:4:"4484";s:11:"object_type";i:7;s:9:"target_id";i:2326;s:18:"target_object_type";i:107;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[2326]";s:9:"new_value";s:6:"[2326]";s:11:"description";s:95:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
14:54:26.6240.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 640896, 'a:13:{s:2:"id";i:640896;s:9:"object_id";i:3311;s:11:"object_type";i:10;s:9:"target_id";i:4484;s:18:"target_object_type";i:7;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4484]";s:9:"new_value";s:6:"[4484]";s:11:"description";s:134:"{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-06-01-001"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
14:54:26.6340.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220641, 'a:11:{s:2:"id";i:220641;s:9:"object_id";i:4484;s:11:"object_type";s:1:"7";s:6:"parent";N;s:11:"description";s:66:"刘人诚编辑了：2026-06-01-001发票信息2026-06-02￥-88221";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:84:"商机：测试工单人工成本问题；客户：北京华辰悦科技有限公司";}', '', 1001, '221.216.117.119')
14:54:26.6210.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 220640, 'a:11:{s:2:"id";i:220640;s:9:"object_id";i:2326;s:11:"object_type";s:3:"107";s:6:"parent";N;s:11:"description";s:27:"刘人诚编辑销售发票";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:20:"销售发票：88221";}', '', 1001, '221.216.117.119')
14:54:26.5880.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:54:26.5970.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "red_invoice_id"=2326
14:54:26.5890.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:54:26.6270.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
14:54:26.6360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4484
14:54:26.6300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
14:54:26.6310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3311
14:54:26.6300.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4484
14:54:26.5910.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"='2326'
14:54:26.6350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
14:54:26.6230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4484'
14:54:26.6130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_products" WHERE "sales_invoice_id"=2326
14:54:26.6310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4173
14:54:26.6140.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2326
14:54:26.6140.3 msyii\db\Command::querySELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=1280
14:54:26.6130.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=1280
14:54:26.6200.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
14:54:26.5980.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4484')
14:54:26.6200.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"=2326
14:54:26.6320.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
14:54:26.6000.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4484')
14:54:26.6120.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"=2326
14:54:26.6180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"=2326
14:54:26.5920.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:54:26.5920.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
14:54:26.5870.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:54:26.6340.2 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1001) AND ("id" != 1001) AND (channel_id IS NOT NULL)
14:54:26.5930.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
14:54:26.5930.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2326
14:54:26.6180.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2326
14:54:26.6220.1 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL)
14:54:26.6100.1 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2326