Total processing time: 331 ms; Peak memory: 8.381 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 14:18:34.634 | 7.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:4:{s:12:"remind_ahead";s:5:"0 day";s:19:"expire_remind_ahead";s:5:"0 day";s:6:"amount";d:385200;s:11:"expire_date";s:10:"2026-07-16";}', '', 1001, '114.244.130.25') |
| 14:18:34.758 | 6.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505) |
| 14:18:34.765 | 5.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=105) AND ("object_id"=4505) |
| 14:18:34.504 | 4.2 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:18:34.621 | 4.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE ("project_id"=4183) AND (erp_sales_outbound_id is not null) |
| 14:18:34.689 | 3.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.812 | 3.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=105)) |
| 14:18:34.741 | 3.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.806 | 3.0 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=106)) |
| 14:18:34.809 | 2.9 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_id"=4505) AND ("object_type"=107)) |
| 14:18:34.695 | 2.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.508 | 2.4 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1013 |
| 14:18:34.698 | 2.4 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.686 | 2.3 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 14:18:34.587 | 2.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.604 | 2.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.718 | 1.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.626 | 1.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.674 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.708 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.802 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.794 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4183) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 14:18:34.514 | 1.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.617 | 1.7 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_version_rels" ("project_product_version_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1390, 2171, '18000', 1, '18000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1390, 2267, '42000', 2, '84000', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1390, 2267, '99600', 1, '99600', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1390, 868, '42000', 2, '84000', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1390, 2232, '99600', 1, '99600', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 14:18:34.821 | 1.7 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/sales-contract/save-edit', '{"SalesContracts":{"id":"4505","client_id":"3465","project_id":"4183","project_name":"\u96f6\u552e001","amount":"201600","contract_scan":"","receipt_scan":"","contract_type":"1","serial_no":"TSKJ&KTJT20260626001","signed_at":"2026-06-26","budget":"201600","profit":"38520","profit_pct":"10.00","description":"","expire_date":"2026-07-16","expire_remind_ahead":"","project_product_version_id":"1386","salesContractPayments":{"new":[""]},"salesContractPaymentCollectionRemindDates":{"2026-06-09":"18000"},"payment_collection_remind_ahead":"1 day","salesContractPaymentCollectionRemindReceivers":["1001"],"sla":"","including_tax":"1","remind_ahead":"","contractFileList":{"32809":"xs.pdf"},"contractScans":["32809"],"is_draft":"0","is_settle":"0","is_deliver":"0","is_outbound":"0","client_name":"\u96f6\u552e001","projectContactPoints":"","projectContactPointRels":"","serviceContractRemindDates":"","salesSupplierRels":"","projectProductRels":{"12178":{"product_id":"2171","amount":"18000","total_amount":"18000","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12179":{"product_id":"2267","amount":"42000","total_amount":"84000","number":"2","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"12180":{"product_id":"2267","amount":"99600","total_amount":"99600","number":"1","description":"","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"new":{"1":{"product_id":"868","amount":"42000","total_amount":"84000","number":"2","description":"GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""},"0":{"product_id":"2232","amount":"99600","total_amount":"99600","number":"1","description":"W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee","hardware_from":"","hardware_to":"","maintenance_from":"","maintenance_to":"","software_from":"","software_to":"","supplier_id":""}}},"salesContractInvoices":"","projectProductTypes":{"7":{"budget":"18000","profit":"1800","pct":"10"},"23":{"budget":"183600","profit":"18360","pct":"10"},"5":{"budget":"183600","profit":"18360","pct":"10"}},"salesContractRemindReceivers":"","serviceContractRemindReceivers":""},"web_access_token":"8xqSDHkpxFShwMjatgql1iJNjJHyfMBa"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u5408\u540c\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0,"ip":"114.244.130.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-16 14:18:34', 321997056) RETURNING "id" |
| 14:18:34.649 | 1.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_stop_products" ("erp_sales_order_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1721, 2259, 2171, '18000', '18000', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2273, 2267, '42000', '84000', '2', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, 2274, 2267, '99600', '99600', '1', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 868, '42000', '84000', '2', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (1721, NULL, 2232, '99600', '99600', '1', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 14:18:34.541 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.711 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4183 ORDER BY "created_at" DESC |
| 14:18:34.602 | 1.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "project_product_version_id"=1390 WHERE "id"=4183 |
| 14:18:34.525 | 1.2 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "serial_no"='TSKJ&KTJT20260626001' LIMIT 2 |
| 14:18:34.571 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 14:18:34.684 | 1.2 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5)) |
| 14:18:34.682 | 1.1 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 14:18:34.540 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4183, 1, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%;"]}') |
| 14:18:34.519 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"='4505' |
| 14:18:34.555 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 14:18:34.643 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 14:18:34.779 | 1.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.583 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "product_id", "amount", "number", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4183, 868, '42000', 2, '84000', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2232, '99600', 1, '99600', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 14:18:34.749 | 0.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_invoices" WHERE "project_id"=4183 |
| 14:18:34.757 | 0.9 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "project_id"=4183 |
| 14:18:34.533 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183 |
| 14:18:34.679 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_edit_verify"=FALSE WHERE "id"=4505 |
| 14:18:34.672 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_rels" ("project_id", "erp_sales_order_product_id", "product_id", "amount", "total_amount", "number", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (4183, 2259, 2171, '18000', '18000', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2273, 2267, '42000', '84000', 2, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2274, 2267, '99600', '99600', 1, '', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2285, 868, '42000', '84000', 2, 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL), (4183, 2286, 2232, '99600', '99600', 1, 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) |
| 14:18:34.733 | 0.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2286 |
| 14:18:34.750 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 14:18:34.771 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (105, 4505, 32809) |
| 14:18:34.545 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProductTypes', 4183, 1, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5546\u673a\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%;"]}') |
| 14:18:34.783 | 0.9 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 14:18:34.551 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_project_product_types" ("project_id", "product_type_id", "name", "budget", "pct", "profit") VALUES (4183, 7, '软件', '18000', 10, '1800'), (4183, 23, '礼品', '183600', 10, '18360'), (4183, 5, '安全设备', '183600', 10, '18360') |
| 14:18:34.782 | 0.9 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5)) |
| 14:18:34.776 | 0.9 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" ("contract_id", "user_id") VALUES (4505, 1001) RETURNING "id" |
| 14:18:34.785 | 0.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.753 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "is_outbound"=FALSE WHERE "id"=4505 |
| 14:18:34.647 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "stop_at"='now()' WHERE "id"=1721 |
| 14:18:34.786 | 0.8 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.740 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "contract_type"=1 WHERE "id"=4183 |
| 14:18:34.772 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.596 | 0.8 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_product_versions" ("project_id", "created_by", "created_at") VALUES (4183, 1001, '2026-07-16 14:18:34') RETURNING "id" |
| 14:18:34.756 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505 |
| 14:18:34.579 | 0.8 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12178, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.722 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4505) AND (amount > paid_amount) ORDER BY "remind_date" |
| 14:18:34.702 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.724 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_outbound_products" WHERE "erp_sales_order_product_id" IN (2259, 2273, 2274, 2285, 2286) |
| 14:18:34.619 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 14:18:34.788 | 0.7 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.586 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "budget"='385200', "profit_pct"='10', "project_product_version_id"=1386 WHERE "id"=4183 |
| 14:18:34.703 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='385200', "erp_all_settle_amount"='0' WHERE "id"=4505 |
| 14:18:34.532 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.569 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 14:18:34.527 | 0.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465') |
| 14:18:34.726 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2259 |
| 14:18:34.557 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2171 |
| 14:18:34.529 | 0.7 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183') |
| 14:18:34.774 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.513 | 0.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:18:34.746 | 0.7 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505 |
| 14:18:34.656 | 0.7 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20007', 1721, '刘人诚通过了这个审批', TRUE, 'XSDD-20260609-00001') RETURNING "id" |
| 14:18:34.630 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.752 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721) |
| 14:18:34.667 | 0.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1721, 868, '2', '42000', '84000', 'GB10/4TB SSD/128GB/WIFI/原厂1年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 14:18:34.707 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4183 |
| 14:18:34.694 | 0.6 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.789 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "erp_settle_amount"='0', "erp_un_settle_amount"='385200', "erp_all_settle_amount"='0' WHERE "id"=4505 |
| 14:18:34.715 | 0.6 ms | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 14:18:34.629 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "sales_contract_id"=4505 ORDER BY "id" DESC |
| 14:18:34.591 | 0.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_project_change_logs" ("project_id", "project_status", "budget", "profit_pct", "collected", "start_from", "end_at") VALUES (4183, 3, '385200', '10', '0', 'now()', NULL) RETURNING "id" |
| 14:18:34.714 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4505 |
| 14:18:34.728 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2273 |
| 14:18:34.781 | 0.6 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (2, 5)) |
| 14:18:34.732 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2285 |
| 14:18:34.567 | 0.6 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProducts', 4183, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 14:18:34.730 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "cost"=NULL, "total_cost"=NULL WHERE "erp_sales_order_product_id"=2274 |
| 14:18:34.633 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contracts" SET "client_id"=3465, "amount"='385200', "updated_at"='now()', "contract_scan"=NULL, "receipt_scan"=NULL, "contract_type"=1, "project_id"=4183, "expire_date"='2026-07-16', "remind_ahead"='0 day', "expire_remind_ahead"='0 day', "including_tax"=TRUE, "is_settle"=FALSE, "is_deliver"=FALSE, "is_outbound"=FALSE, "is_draft"=FALSE, "is_edit_verify"=TRUE WHERE "id"=4505 |
| 14:18:34.793 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_projects" SET "collected"='0' WHERE "id"=4183 |
| 14:18:34.553 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183 |
| 14:18:34.548 | 0.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4183 |
| 14:18:34.660 | 0.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "updated_at"='now()' WHERE "id"=1721 |
| 14:18:34.536 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 14:18:34.651 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_verify_processes" WHERE "id"=6 |
| 14:18:34.784 | 0.5 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.788 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.797 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_status_logs" WHERE "project_id"=4183 ORDER BY "created_at" DESC |
| 14:18:34.777 | 0.5 ms | yii\db\Command::query | SELECT "remind_date" FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE "contract_id"=4505 |
| 14:18:34.576 | 0.5 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'erpSalesOrderProducts', 1721, 20007, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 14:18:34.787 | 0.5 ms | yii\db\Command::query | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."is_payment_settle"=TRUE) AND ("t"."status" IN (1, 2, 5)) |
| 14:18:34.773 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.750 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "contract_id"=4505 |
| 14:18:34.799 | 0.5 ms | yii\db\Command::query | SELECT r.amount, t.wrote_date as created_at FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 14:18:34.670 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE ("id" NOT IN (2259, 2273, 2274, 2285, 2286)) AND ("erp_sales_order_id"=1721) |
| 14:18:34.736 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.723 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.737 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.552 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183 |
| 14:18:34.594 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 ORDER BY "id" |
| 14:18:34.568 | 0.5 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "users", "description") VALUES (2, 'projectProducts', 4183, 1, 1001, 'now()', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', '[["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -","\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -"]]', array[1001], '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6e05\u5355","d4":["\u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -; <b>\u53d8\u4e3a<\/b> \u91d1\u7545\u900dCRM\u8f6f\u4ef6\u670d\u52a1:\u5408\u540c\u5355\u4ef7 18000\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;\u98de\u5229\u6d66\u667a\u80fd\u8bed\u97f3\u7535\u52a8\u7259\u5237HX5681:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u4e2a\u5143 \u5907\u6ce8:- \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;LIS-F1000-AK-URL-1Y:\u5408\u540c\u5355\u4ef7 42000\u5143 \u6570\u91cf 2\u5e74\u5143 \u5907\u6ce8:GB10\/4TB SSD\/128GB\/WIFI\/\u539f\u53821\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;PAN-SVC-BKLN-3440-3YR:\u5408\u540c\u5355\u4ef7 99600\u5143 \u6570\u91cf 1\u5957\u5143 \u5907\u6ce8:W7-3465X32G*4 4TSSD RTXPRO5000-48G\u5929\u65e0\u7ebf\u84dd\u72591400W3\u5e74\u4fdd\u4fee \u4f9b\u5e94\u5546 - \u786c\u4ef6\u8d28\u4fdd - \u8f6f\u4ef6\u8d28\u4fdd - \u8fd0\u7ef4\u670d\u52a1 -;"]}') |
| 14:18:34.780 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 14:18:34.745 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.757 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_supplier_rels" WHERE "contract_id"=4505 |
| 14:18:34.645 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_verify_rels" SET "status"=3 WHERE ("erp_sales_order_id"=1721) AND ("status"=0) |
| 14:18:34.646 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.754 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465' |
| 14:18:34.775 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.539 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.618 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.544 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.805 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE ("contract_id"=4505) AND (amount > paid_amount) ORDER BY "remind_date" |
| 14:18:34.671 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.798 | 0.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4505 |
| 14:18:34.597 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.717 | 0.5 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4505 |
| 14:18:34.528 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contract_types" WHERE "id"='1') |
| 14:18:34.566 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.738 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.548 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'projectProductTypes', 4505, 7, 1001, 'now()', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%","\u5b89\u5168\u8bbe\u5907:183600\u5143 10%"]]', '[["\u8f6f\u4ef6:18000\u5143 10%","\u793c\u54c1:183600\u5143 10%"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5408\u540c\u91d1\u989d","d4":["\u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%; <b>\u53d8\u4e3a<\/b> \u8f6f\u4ef6:18000\u5143 10%;\u793c\u54c1:183600\u5143 10%;\u5b89\u5168\u8bbe\u5907:183600\u5143 10%;"]}') |
| 14:18:34.715 | 0.4 ms | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 14:18:34.577 | 0.4 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 |
| 14:18:34.689 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status"=1)) |
| 14:18:34.632 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_orders" SET "number"='7', "amount"='385200' WHERE "id"=1721 |
| 14:18:34.662 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2259 |
| 14:18:34.558 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 14:18:34.677 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.546 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4183 |
| 14:18:34.568 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.681 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.575 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.642 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3465' |
| 14:18:34.629 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.737 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.678 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 14:18:34.668 | 0.4 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_erp_sales_order_products" ("erp_sales_order_id", "product_id", "number", "amount", "total_amount", "description", "supplier_id", "hardware_from", "software_from", "maintenance_from", "hardware_to", "software_to", "maintenance_to") VALUES (1721, 2232, '1', '99600', '99600', 'W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修', NULL, NULL, NULL, NULL, NULL, NULL, NULL) RETURNING "id" |
| 14:18:34.593 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.631 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'number', 1721, 20007, 1001, 'now()', '[7]', '["4"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u6570\u91cf","d4":["4 <b>\u53d8\u4e3a<\/b> 7"]}'), (2, 'amount', 1721, 20007, 1001, 'now()', '[385200]', '["201600"]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4ea7\u54c1\u91d1\u989d","d4":["201600 <b>\u53d8\u4e3a<\/b> 385200"]}') |
| 14:18:34.628 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.748 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.606 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.547 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.721 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.672 | 0.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=4183 |
| 14:18:34.755 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183' |
| 14:18:34.681 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.561 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2171' |
| 14:18:34.791 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.727 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2273 |
| 14:18:34.816 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.704 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.633 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:2:{s:6:"number";d:7;s:6:"amount";d:385200;}', '', 1001, '114.244.130.25') |
| 14:18:34.600 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.653 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_carbon_copy_rels" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.600 | 0.4 ms | yii\db\Command::query | INSERT 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 (1, 'create', 4505, 7, 4183, 112, 1001, '[4183]', '[4183]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 14:18\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 14:18:34.739 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (11, 'status', 1721, 20007, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u7f16\u8f91\u4e86","d3":"\u9500\u552e\u8ba2\u5355\u7533\u8bf7","d4":""}') |
| 14:18:34.599 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "from_project"=4183 |
| 14:18:34.732 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2286 |
| 14:18:34.777 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesContractPaymentCollectionRemindReceivers', 10184, 'a:3:{s:2:"id";i:10184;s:11:"contract_id";i:4505;s:7:"user_id";s:4:"1001";}', '', 1001, '114.244.130.25') |
| 14:18:34.799 | 0.4 ms | yii\db\Command::query | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_sales_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."sales_contract_id"=4505) AND ("t"."status" IN (2, 5, 1)) |
| 14:18:34.652 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:18:34.735 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.658 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.713 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 14:18:34.745 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.791 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.721 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.646 | 0.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.710 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.735 | 0.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.590 | 0.4 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_change_logs" SET "end_at"='now()' WHERE "id"=17892 |
| 14:18:34.725 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2259, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.676 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.754 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.727 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2273, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.796 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.731 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2285 |
| 14:18:34.562 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 14:18:34.729 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2274 |
| 14:18:34.591 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectChangeLogs', 17892, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '114.244.130.25') |
| 14:18:34.598 | 0.3 ms | yii\db\Command::query | INSERT 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 (1, 'create', 4183, 1, 1390, 112, 1001, '[1390]', '[1390]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 14:18\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}') RETURNING "id" |
| 14:18:34.536 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 14:18:34.804 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3465 |
| 14:18:34.529 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:18:34.801 | 0.3 ms | yii\db\Command::query | SELECT SUM(amount) FROM "a57be577deb434"."tbl_sales_contract_payment_collection_remind_dates" WHERE "contract_id"=4505 |
| 14:18:34.578 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2171, "amount"='18000', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12178 |
| 14:18:34.704 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:1:{s:20:"erp_un_settle_amount";s:6:"201600";}', '', 1001, '114.244.130.25') |
| 14:18:34.581 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12179, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.531 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183) |
| 14:18:34.747 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 14:18:34.648 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:1:{s:7:"stop_at";s:5:"now()";}', '', 1001, '114.244.130.25') |
| 14:18:34.592 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectChangeLogs', 17897, 'a:8:{s:2:"id";i:17897;s:10:"project_id";i:4183;s:14:"project_status";i:3;s:6:"budget";d:385200;s:10:"profit_pct";d:10;s:9:"collected";s:1:"0";s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '114.244.130.25') |
| 14:18:34.549 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 14:18:34.643 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='4183' |
| 14:18:34.655 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_orders" WHERE "id"=1721 |
| 14:18:34.680 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.798 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4505 |
| 14:18:34.816 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.817 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.657 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 221103, 'a:11:{s:2:"id";i:221103;s:9:"object_id";i:1721;s:11:"object_type";s:5:"20007";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";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:19:"XSDD-20260609-00001";}', '', 1001, '114.244.130.25') |
| 14:18:34.594 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.550 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 14:18:34.530 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:18:34.593 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:1:{s:6:"budget";d:385200;}', '', 1001, '114.244.130.25') |
| 14:18:34.565 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=8 |
| 14:18:34.716 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.656 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 14:18:34.606 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:1:{s:26:"project_product_version_id";i:1390;}', '', 1001, '114.244.130.25') |
| 14:18:34.563 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267' |
| 14:18:34.550 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 14:18:34.659 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.664 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='2', "last_amount"='42000', "last_total_amount"='84000' WHERE "id"=2273 |
| 14:18:34.666 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2274, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.564 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='868' |
| 14:18:34.652 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("erp_sales_order_id"=1721) AND ("status"=0) ORDER BY "id" |
| 14:18:34.583 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ProjectProductRels', 12180, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.705 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.710 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.790 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesContracts', 4505, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.537 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=7 |
| 14:18:34.663 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2259, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.560 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 14:18:34.565 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2232' |
| 14:18:34.800 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.537 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=5 |
| 14:18:34.577 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12178 |
| 14:18:34.559 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267 |
| 14:18:34.562 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2267' |
| 14:18:34.661 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.725 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "outbound"='0' WHERE "id"=2259 |
| 14:18:34.658 | 0.3 ms | yii\db\Command::query | SELECT "channel_id" FROM "global"."tbl_logins" WHERE (0=1) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 14:18:34.705 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.792 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4183 |
| 14:18:34.729 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2274, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.582 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='99600', "number"=1, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12180 |
| 14:18:34.731 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2285, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.560 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 14:18:34.804 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.553 | 0.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_contact_points" WHERE "project_id"=4183 |
| 14:18:34.796 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 4183, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.665 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2274 |
| 14:18:34.668 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2285, 'a:21:{s:2:"id";i:2285;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:868;s:11:"description";s:40:"GB10/4TB SSD/128GB/WIFI/原厂1年保修";s:6:"number";s:1:"2";s:8:"outbound";N;s:6:"amount";s:5:"42000";s:12:"total_amount";s:5:"84000";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 14:18:34.597 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ProjectProductVersions', 1390, 'a:4:{s:2:"id";i:1390;s:10:"project_id";i:4183;s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-07-16 14:18:34";}', '', 1001, '114.244.130.25') |
| 14:18:34.538 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"=23 |
| 14:18:34.733 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2286, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.581 | 0.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_project_product_rels" SET "product_id"=2267, "amount"='42000', "number"=2, "supplier_id"=NULL, "hardware_from"=NULL, "software_from"=NULL, "maintenance_from"=NULL, "hardware_to"=NULL, "software_to"=NULL, "maintenance_to"=NULL WHERE "id"=12179 |
| 14:18:34.665 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrderProducts', 2273, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.564 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 14:18:34.664 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_products" WHERE "id"=2273 |
| 14:18:34.669 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\ErpSalesOrders', 1721, 'a:0:{}', '', 1001, '114.244.130.25') |
| 14:18:34.662 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.669 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ErpSalesOrderProducts', 2286, 'a:21:{s:2:"id";i:2286;s:18:"erp_sales_order_id";i:1721;s:12:"erp_store_id";N;s:10:"product_id";i:2232;s:11:"description";s:64:"W7-3465X32G*4 4TSSD RTXPRO5000-48G天无线蓝牙1400W3年保修";s:6:"number";s:1:"1";s:8:"outbound";N;s:6:"amount";s:5:"99600";s:12:"total_amount";s:5:"99600";s:11:"last_number";N;s:11:"last_amount";N;s:17:"last_total_amount";N;s:4:"cost";N;s:10:"total_cost";N;s:11:"supplier_id";N;s:13:"hardware_from";N;s:13:"software_from";N;s:16:"maintenance_from";N;s:11:"hardware_to";N;s:11:"software_to";N;s:14:"maintenance_to";N;}', '', 1001, '114.244.130.25') |
| 14:18:34.560 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"=2267 |
| 14:18:34.599 | 0.3 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643529, 'a:13:{s:2:"id";i:643529;s:9:"object_id";i:4183;s:11:"object_type";i:1;s:9:"target_id";i:1390;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1390]";s:9:"new_value";s:6:"[1390]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 14:18\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 14:18:34.566 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=2 |
| 14:18:34.666 | 0.2 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_erp_sales_order_products" SET "last_number"='1', "last_amount"='99600', "last_total_amount"='99600' WHERE "id"=2274 |
| 14:18:34.601 | 0.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 643530, 'a:13:{s:2:"id";i:643530;s:9:"object_id";i:4505;s:11:"object_type";i:7;s:9:"target_id";i:4183;s:18:"target_object_type";i:112;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[4183]";s:9:"new_value";s:6:"[4183]";s:11:"description";s:183:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355","d4":["2026-07-16 14:18\u4ea7\u54c1\u5386\u53f2\u62a5\u4ef7\u6e05\u5355"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '114.244.130.25') |
| 14:18:34.563 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_units" WHERE "id"=3 |
| 14:18:34.580 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12179 |
| 14:18:34.780 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_receivers" WHERE "contract_id"=4505 |
| 14:18:34.654 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_verify_rels" WHERE "erp_sales_order_id"=1721 ORDER BY "id" |
| 14:18:34.653 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_erp_sales_order_stop_verify_rels" WHERE ("status"=0) AND ("erp_sales_order_id"=1721) ORDER BY "id" |
| 14:18:34.582 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "id"=12180 |
| 14:18:34.554 | 0.2 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE "project_id"=4183 |
| 14:18:34.747 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE 0=1 |
| 14:18:34.778 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_service_contract_remind_dates" WHERE ("contract_id"=4505) AND (0=1) |
| 14:18:34.671 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_erp_sales_order_stop_products" WHERE "erp_sales_order_id"=1721 |
| 14:18:34.554 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_contact_point_rels" WHERE 0=1 |
| 14:18:34.584 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_project_product_rels" WHERE 0=1 |