Performance Profiling

Total processing time: 50 ms; Peak memory: 3.777 MB. Show Profiling Timeline

总计48条数据

Time	Duration	Category	Info

16:45:26.997	3.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=10004) AND ("visit_date"='2025-08-19')
16:45:26.968	2.7 ms	yii\db\Command::query	SELECT "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"=2115 GROUP BY "sip"."id"
16:45:26.958	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:45:26.956	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:45:26.961	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:45:26.984	1.3 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_invoice_products" SET "outbound"='3', "inventory"='13' WHERE "id"=63
16:45:26.975	1.1 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\SalesInvoiceProducts', 812, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:27.002	1.0 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/tax/sales-invoice-cancel-match', '{"id":"2115","web_access_token":"239qcuu_ToIhJtTt60gp-9_fllLTtTgq"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u64cd\u4f5c\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-19 16:45:27') RETURNING "id"
16:45:26.996	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 (23, 'status', 2115, 107, 1001, 'now()', '["\u5218\u4eba\u8bda"]', '[]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u53d6\u6d88\u6838\u9500\u4e86","d3":"\u9500\u552e\u53d1\u7968","d4":[""]}')
16:45:26.974	0.9 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_sales_invoice_products" SET "outbound"='0' WHERE "id"=812
16:45:26.981	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\InventoryProducts', 63, 'a:1:{s:9:"inventory";s:2:"11";}', '', 1001, '223.104.44.8')
16:45:26.980	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_inventory_products" SET "inventory"='16' WHERE "id"=63
16:45:26.986	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_purchase_contract_invoices" SET "paid_amount"='35.43' WHERE "id"=1828
16:45:26.983	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\InventoryProducts', 63, 'a:2:{s:8:"outbound";s:1:"3";s:9:"inventory";i:13;}', '', 1001, '223.104.44.8')
16:45:26.989	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "is_match"=FALSE, "is_used"=FALSE WHERE "id"=2115
16:45:26.986	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\PurchaseInvoiceProducts', 63, 'a:2:{s:8:"outbound";s:1:"3";s:9:"inventory";i:13;}', '', 1001, '223.104.44.8')
16:45:26.987	0.7 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\PurchaseContractInvoices', 1828, 'a:1:{s:11:"paid_amount";d:35.43;}', '', 1001, '223.104.44.8')
16:45:27.001	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=110, "last_visit_at"='now()' WHERE "id"=55336
16:45:26.966	0.7 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
16:45:26.990	0.7 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\SalesContractInvoices', 2115, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:26.994	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_sales_contract_invoices" SET "match_tax_amount"='0', "simple_match_tax_amount"='0' WHERE "id"=2115
16:45:26.977	0.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.993	0.7 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\SalesInvoiceProducts', 812, 'a:0:{}', '', 1001, '223.104.44.8')
16:45:26.982	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_inventory_products" SET "outbound"='3', "inventory"='13' WHERE "id"=63
16:45:26.995	0.7 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\SalesContractInvoices', 2115, 'a:1:{s:16:"match_tax_amount";s:4:"0.23";}', '', 1001, '223.104.44.8')
16:45:26.992	0.7 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_sales_invoice_products" SET "outbound"='0' WHERE "id"=812
16:45:26.965	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"='2115'
16:45:26.979	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_invoice_products" WHERE "purchase_invoice_id"=1828
16:45:26.973	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.971	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.967	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=6
16:45:26.980	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "purchase_product_id"=63
16:45:26.972	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "id"=63
16:45:26.995	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:45:26.982	0.3 ms	yii\db\Command::query	SELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "inventory_product_id"=63
16:45:26.988	0.3 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_inventory_products" WHERE ("purchase_invoice_id"=1828) AND ("purchase_product_id"<>63)
16:45:26.966	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
16:45:26.968	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_invoice_reminders" WHERE "sales_invoice_id"=2115
16:45:26.974	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.978	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.991	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_invoice_products" WHERE "sales_invoice_id"=2115
16:45:26.990	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_sales_contract_invoices" WHERE "id"=2115
16:45:26.978	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_invoices" WHERE "id"=1828
16:45:26.991	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.991	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.992	0.2 ms	yii\db\Command::query	SELECT SUM(outbound) FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_product_id"=812
16:45:26.977	0.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_inventory_product_spents" WHERE "sales_invoice_id"=2115
16:45:26.978	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_inventory_products" WHERE "id"=63