Performance Profiling

Total processing time: 73 ms; Peak memory: 5.193 MB. Show Profiling Timeline

总计36条数据

Time	Duration	Category	Info

10:41:38.289	20.2 ms	yii\db\Command::query	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20013) AND ("object_id"=374) GROUP BY "object_id"
10:41:38.309	17.1 ms	yii\db\Command::query	SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20013) AND (remind_user_id = 5252 AND is_read = false) AND ("object_id"=374) GROUP BY "object_id"
10:41:38.263	2.3 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5252
10:41:38.261	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:41:38.266	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
10:41:38.285	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20021) AND ("object_id"=374)
10:41:38.274	1.6 ms	yii\db\Command::query	SELECT sub.* FROM (SELECT ROW_NUMBER() OVER (ORDER BY created_at DESC) as idx, sub.* FROM (SELECT r.* FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id WHERE ("r"."created_by"=5252) OR ("rvr"."user_id"=5252) OR (0=1) GROUP BY "r"."id") "sub") "sub" WHERE "id"='374'
10:41:38.272	1.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT r. FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id WHERE ("r"."created_by"=5252) OR ("rvr"."user_id"=5252) OR (0=1) GROUP BY "r"."id") "c"
10:41:38.271	1.4 ms	yii\db\Command::query	SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_erp_collect_ticket_visibles" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5252) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
10:41:38.287	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20022) AND ("object_id"=374)
10:41:38.329	1.2 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', 5252, 5, 'vue/erp-collect-ticket/get-edit', '{"id":"374","web_access_token":"Q2GVCf176c7Vlog0hO6aJo3ZEkjcIMKK"}', '{"code":500,"result":{},"status":0,"msg":[{"name":"error","success":"","error":"\u60a8\u65e0\u6743\u8bbf\u95ee\u6b64\u6536\u6b3e\u5355"}],"mod":0}', FALSE, '2025-08-04 10:41:38') RETURNING "id"
10:41:38.328	0.6 ms	yii\db\Command::query	SELECT EXISTS(SELECT r.* FROM "a57be577deb434"."tbl_erp_collect_tickets" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" "rvr" ON rvr.erp_collect_ticket_id = r.id LEFT JOIN "a57be577deb434"."tbl_erp_collect_ticket_carbon_copy_rels" "rccr" ON rccr.erp_collect_ticket_id = r.id WHERE ((0=1) OR ("rccr"."user_id"=5252) OR ("rvr"."user_id"=5252)) AND ("r"."id"=374) GROUP BY "r"."id")
10:41:38.327	0.5 ms	yii\db\Command::query	SELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_erp_collect_ticket_visibles" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5252) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
10:41:38.284	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" WHERE "erp_collect_ticket_id"=374 ORDER BY "id"
10:41:38.280	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" AS "name" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4046
10:41:38.277	0.5 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"=1013)
10:41:38.279	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2182
10:41:38.288	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27128
10:41:38.278	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=7
10:41:38.282	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE "erp_collect_ticket_id"=374 ORDER BY "id"
10:41:38.283	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_collect_ticket_id"=374 ORDER BY "id"
10:41:38.284	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_payments" WHERE "erp_collect_ticket_id"=374 ORDER BY "id"
10:41:38.277	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
10:41:38.276	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_tickets" WHERE "id"='374'
10:41:38.285	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no", "created_at" FROM "a57be577deb434"."tbl_sales_contracts" WHERE "id"=4046
10:41:38.280	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_carbon_copy_rels" WHERE "erp_collect_ticket_id"=374
10:41:38.281	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=374) ORDER BY "id"
10:41:38.283	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status" = 0) AND ("user_id"=5252) AND ("erp_collect_ticket_id"=374)
10:41:38.282	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status"=0) AND ("erp_collect_ticket_id"=374) ORDER BY "id"
10:41:38.281	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_collect_ticket_id"=374) ORDER BY "id"
10:41:38.278	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
10:41:38.279	0.2 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"=5300)
10:41:38.281	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE "erp_collect_ticket_id"=374 ORDER BY "id"
10:41:38.283	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_stop_verify_rels" WHERE ("status" != 0) AND ("erp_collect_ticket_id"=374) ORDER BY "id"
10:41:38.279	0.2 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
10:41:38.282	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_verify_rels" WHERE ("status" = 0) AND ("user_id"=5252) AND ("erp_collect_ticket_id"=374)