Performance Profiling

Total processing time: 389 ms; Peak memory: 5.273 MB. Show Profiling Timeline

总计53条数据

Time	Duration	Category	Info

18:14:26.765	88.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" WHERE "erp_bank_id"=8)
18:14:26.980	11.0 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=105
18:14:27.007	8.6 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_erp_bank_change_logs" ("created_by", "description") VALUES (1001, '删除了:22222222') RETURNING "id"
18:14:26.754	7.9 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_banks' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:14:26.855	7.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.902	6.2 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_ledger_banks' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:14:26.863	6.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.973	6.1 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_account_captions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:14:26.728	6.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:14:27.001	5.7 ms	yii\db\Command::query	select ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_erp_bank_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:14:26.949	4.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_erp_banks" SET "sort"="sort" - 1 WHERE ("sort" > 8)
18:14:26.750	4.1 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_banks' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:14:26.969	3.9 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_account_captions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:14:26.965	3.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=105
18:14:26.997	3.4 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_erp_bank_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:14:26.899	3.3 ms	yii\db\Command::query	SELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /int2/ THEN 16 WHEN 23 /int4/ THEN 32 WHEN 20 /int8/ THEN 64 WHEN 1700 /numeric/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /float4/ THEN 24 /FLT_MANT_DIG/ WHEN 701 /float8/ THEN 53 /DBL_MANT_DIG/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_ledger_banks' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:14:26.876	3.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" WHERE "erp_bank_id"=8)
18:14:26.883	2.7 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.944	2.6 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\LedgerAccountCaptions', 174, 'a:0:{}', '', 1001, '221.216.117.25')
18:14:26.938	2.6 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\LedgerBanks', 9, 'a:0:{}', '', 1001, '221.216.117.25')
18:14:26.994	2.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 ('DELETE', 'app\models\ErpBanks', 8, '', '', 1001, '221.216.117.25')
18:14:26.942	2.2 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_ledger_account_captions" SET "is_delete"=TRUE, "updated_at"='2026-06-29 18:14:26' WHERE "id"=174
18:14:26.992	1.9 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 ('DELETE', 'app\models\ErpAccountCaptions', 105, '', '', 1001, '221.216.117.25')
18:14:27.019	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/setting/delete-erp-bank', '{"id":"8","web_access_token":"G2-mdsiVx4ajd063Zd6C9RL7pLl9o1cd"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u94f6\u884c\u8d26\u6237\u5728\u62a5\u7a0e\u7cfb\u7edf\u540c\u6b65\u6210\u529f!","error":""}],"mod":0,"ip":"221.216.117.25","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-06-29 18:14:27', 372611072) RETURNING "id"
18:14:26.870	1.7 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:27.016	1.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 ('INSERT', 'app\models\ErpBankChangeLogs', 29, 'a:5:{s:2:"id";i:29;s:11:"erp_bank_id";N;s:11:"description";s:18:"删除了:22222222";s:10:"created_by";i:1001;s:10:"created_at";N;}', '', 1001, '221.216.117.25')
18:14:26.947	1.5 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\LedgerBanks', 9, 'a:0:{}', '', 1001, '221.216.117.25')
18:14:26.932	1.5 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_ledger_banks" SET "is_delete"=TRUE, "updated_at"='2026-06-29 18:14:26' WHERE "id"=9
18:14:26.922	1.4 ms	yii\db\Command::query	SELECT "i"."ledger_account_caption_id", COALESCE(sum(i.debit_amount), 0) AS "debit_amount", COALESCE(sum(i.credit_amount), 0) AS "credit_amount" FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" LEFT JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE (("t"."ledger_id"=1) AND ("t"."status"=1)) AND ("i"."ledger_account_caption_id"=174) GROUP BY "i"."ledger_account_caption_id"
18:14:26.879	1.0 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.748	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='8'
18:14:26.915	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"=174
18:14:26.894	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "is_stop"=FALSE ORDER BY "id"
18:14:26.923	0.7 ms	yii\db\Command::query	SELECT "id", "parent_id", "direction", "amount", "year_debit_amount", "year_credit_amount" FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "ledger_id"=1 ORDER BY "id"
18:14:26.741	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:14:26.728	0.7 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:14:26.898	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE ("ledger_id"=1) AND ("erp_bank_id"=8)
18:14:26.917	0.6 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE (("ledger_id"=1) AND ("title"='22222222')) AND ("id" != 9))
18:14:26.887	0.6 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.927	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT "i".* FROM "a57be577deb434"."tbl_ledger_ticket_items" "i" LEFT JOIN "a57be577deb434"."tbl_ledger_tickets" "t" ON i.ledger_ticket_id = t.id WHERE ("t"."ledger_id"=1) AND ("t"."status"=0) AND ("i"."ledger_account_caption_id"=174))
18:14:26.874	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.881	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.873	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" WHERE "erp_bank_id"=8)
18:14:26.763	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" WHERE "erp_bank_id"=8)
18:14:26.875	0.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.888	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" WHERE "erp_bank_id"=8)
18:14:26.941	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE ("ledger_id"=1) AND ("serial_no"='1002')
18:14:26.931	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledgers" WHERE "id"=1)
18:14:26.929	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE ("ledger_id"=1) AND ("id" != 9) AND ("title"='22222222'))
18:14:26.930	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_banks" WHERE ("ledger_id"=1) AND ("id" != 9) AND ("serial_no"='100204'))
18:14:26.931	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_ledger_account_captions" WHERE "id"=174)
18:14:26.932	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
18:14:26.994	0.2 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=8