Performance Profiling

Total processing time: 767 ms; Peak memory: 5.523 MB. Show Profiling Timeline

总计23条数据

Time	Duration	Category	Info

18:08:11.234	25.3 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_project_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:08:11.269	15.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_project_statuses' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
18:08:11.226	7.6 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_project_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:08:11.198	6.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
18:08:11.218	4.0 ms	yii\db\Command::query	SELECT *, "id" AS "key", "description" AS "value" FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id"=3464
18:08:11.265	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_project_statuses' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
18:08:11.205	3.5 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
18:08:11.210	2.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:08:11.291	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/client/sandbox', '{"id":"3464","web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"list":[{"id":2,"name":"\u670d\u52a1\u5668","order":1,"description":"","created_by":1013,"created_at":"2017-02-08 16:29:14","updated_at":"2017-02-08 16:29:14","pinyin_shortcut":"fwq","is_delete":false,"productType":"","little":[{"tips":[{"name":"\u5546\u673a\u540d\u79f0","value":"\u9500\u552e\u7ebf\u7d22\u751f\u621020260602003"},{"name":"\u5ba2\u6237\u7ecf\u7406","value":"\u5218\u4eba\u8bda"},{"name":"\u5546\u673a\u72b6\u6001","value":"\u9690\u6027\u9700\u6c42"},{"name":"\u5408\u540c\u7c7b\u578b","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u9500\u552e\u9636\u6bb5","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u9500\u552e\u9884\u6d4b","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u91c7\u8d2d\u65b9\u5f0f","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u5546\u673a\u6765\u6e90","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u552e\u524d\u652f\u6301","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u6210\u4ea4\u65e5\u671f","value":""},{"name":"\u5546\u673a\u5185\u5bb9","value":"(\u672a\u8bbe\u7f6e)"}],"color":"#ffc000"}],"color":"#ffc000"},{"id":3,"name":"\u5b58\u50a8\u8bbe\u5907","order":2,"description":"","created_by":1013,"created_at":"2017-02-08 16:29:31","updated_at":"2024-10-17 09:50:31","pinyin_shortcut":"ccsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":4,"name":"\u7f51\u7edc\u8bbe\u5907 ","order":3,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:03","updated_at":"2017-02-08 16:30:03","pinyin_shortcut":"wlsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":5,"name":"\u5b89\u5168\u8bbe\u5907","order":4,"description":"","created_by":1013,"created_at":"2017-02-08 16:30:31","updated_at":"2024-10-17 09:55:20","pinyin_shortcut":"aqsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":88,"name":"\u79c1\u6709\u4e91","order":5,"description":"","created_by":1000,"created_at":"2024-10-16 16:56:48","updated_at":"2024-10-17 09:55:44","pinyin_shortcut":"syy","is_delete":false,"productType":"","little":[],"color":[]},{"id":8,"name":"\u4e91\u684c\u9762","order":6,"description":"","created_by":1013,"created_at":"2017-02-08 16:31:44","updated_at":"2024-10-17 09:56:16","pinyin_shortcut":"yzm","is_delete":false,"productType":"","little":[],"color":[]},{"id":7,"name":"\u8f6f\u4ef6","order":7,"description":"","created_by":1013,"created_at":"2017-02-08 16:31:21","updated_at":"2017-02-08 16:31:21","pinyin_shortcut":"rj","is_delete":false,"productType":"","little":[],"color":[]},{"id":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9","order":8,"description":"","created_by":1013,"created_at":"2017-02-08 16:33:04","updated_at":"2024-10-17 09:55:00","pinyin_shortcut":"txgzz","is_delete":false,"productType":"","little":[],"color":[]},{"id":69,"name":"\u5907\u4efd","order":9,"description":"","created_by":1000,"created_at":"2024-10-16 16:56:48","updated_at":"2024-10-17 09:54:19","pinyin_shortcut":"bf","is_delete":false,"productType":"","little":[],"color":[]},{"id":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a","order":10,"description":"","created_by":1013,"created_at":"2017-02-08 16:33:16","updated_at":"2024-10-17 09:54:46","pinyin_shortcut":"grjsj","is_delete":false,"productType":"","little":[],"color":[]},{"id":12,"name":"\u7b14\u8bb0\u672c","order":11,"description":"","created_by":1013,"created_at":"2017-02-08 16:33:26","updated_at":"2017-02-08 16:33:26","pinyin_shortcut":"bjb","is_delete":false,"productType":"","little":[],"color":[]},{"id":13,"name":"\u6253\u5370\u673a","order":12,"description":"","created_by":1013,"created_at":"2017-02-08 16:33:36","updated_at":"2017-02-08 16:33:36","pinyin_shortcut":"dyj","is_delete":false,"productType":"","little":[],"color":[]},{"id":14,"name":"UPS","order":13,"description":"","created_by":1013,"created_at":"2017-02-08 16:37:52","updated_at":"2017-02-08 16:37:59","pinyin_shortcut":"UPS","is_delete":false,"productType":"","little":[],"color":[]},{"id":16,"name":"\u8fd0\u7ef4\u670d\u52a1","order":14,"description":"","created_by":1013,"created_at":"2021-07-20 10:00:58","updated_at":"2021-07-20 10:00:58","pinyin_shortcut":"ywfw","is_delete":false,"productType":"","little":[],"color":[]},{"id":17,"name":"\u5de5\u63a7\u673a","order":15,"description":"","created_by":1013,"created_at":"2022-03-25 10:31:27","updated_at":"2022-03-25 10:31:27","pinyin_shortcut":"gkj","is_delete":false,"productType":"","little":[],"color":[]},{"id":18,"name":"\u673a\u623f\u8bbe\u5907","order":16,"description":"","created_by":1013,"created_at":"2022-07-26 10:51:31","updated_at":"2022-07-26 10:51:31","pinyin_shortcut":"jfsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":19,"name":"\u6280\u672f\u670d\u52a1","order":17,"description":"","created_by":1013,"created_at":"2023-08-03 09:19:54","updated_at":"2023-08-03 09:19:54","pinyin_shortcut":"jsfw","is_delete":false,"productType":"","little":[],"color":[]},{"id":20,"name":"\u529e\u516c\u8bbe\u5907","order":18,"description":"","created_by":1013,"created_at":"2023-08-11 17:13:29","updated_at":"2023-08-11 17:13:29","pinyin_shortcut":"bgsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":21,"name":"\u6570\u7801\u8bbe\u5907","order":19,"description":"","created_by":1013,"created_at":"2023-11-13 10:46:10","updated_at":"2023-11-13 10:46:10","pinyin_shortcut":"smsb","is_delete":false,"productType":"","little":[],"color":[]},{"id":22,"name":"\u670d\u52a1","order":20,"description":"","created_by":1013,"created_at":"2024-01-09 14:43:35","updated_at":"2024-01-09 14:43:35","pinyin_shortcut":"fw","is_delete":false,"productType":"","little":[],"color":[]},{"id":23,"name":"\u793c\u54c1","order":21,"description":"","created_by":1013,"created_at":"2024-01-10 18:13:20","updated_at":"2024-01-10 18:13:20","pinyin_shortcut":"lp","is_delete":false,"productType":"","little":[],"color":[]},{"id":75,"name":"\u8f6f\u4ef6\u5f00\u53d1","order":22,"description":"","created_by":1000,"created_at":"2024-10-16 16:56:48","updated_at":"2024-10-17 09:52:47","pinyin_shortcut":"rjkf","is_delete":false,"productType":"","little":[],"color":[]},{"id":106,"name":"\u516c\u6709\u4e91","order":63,"description":"","created_by":1005,"created_at":"2026-02-28 10:32:15","updated_at":"2026-02-28 10:32:15","pinyin_shortcut":"gyy","is_delete":false,"productType":"","little":[],"color":[]}],"can_edit":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 18:08:11', 762215168) RETURNING "id"
18:08:11.215	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='3464'
18:08:11.222	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "client_id"=3464 ORDER BY "bargain_date"
18:08:11.262	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 184, 189, 349)) ORDER BY "sort"
18:08:11.225	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id"=4176
18:08:11.285	0.8 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id") "c"
18:08:11.260	0.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 184, 189, 349)) ORDER BY "sort"
18:08:11.259	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4176
18:08:11.263	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id"=4176
18:08:11.284	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
18:08:11.264	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1
18:08:11.286	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
18:08:11.262	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 184, 189, 349)) ORDER BY "sort"
18:08:11.261	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4176
18:08:11.262	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=4176