Performance Profiling

Total processing time: 327 ms; Peak memory: 5.508 MB. Show Profiling Timeline

总计28条数据

Time	Duration	Category	Info

10:54:35.981	60.8 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;
10:54:36.045	53.6 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
10:54:36.134	29.5 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_progresses' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:54:36.232	29.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_project_statuses' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:54:36.111	15.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id"=10
10:54:36.188	14.5 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_term_taxonomies' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:54:35.961	12.7 ms	yii\db\Command::query	SELECT *, "id" AS "key", "description" AS "value" FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id"=399
10:54:36.203	12.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_term_taxonomies' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:54:36.176	8.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (5, 8, 1, 100, 107, 130, 167, 142, 183, 188, 2100000000, 323, 369, 226, 45, 165, 179, 189, 319, 367, 359)) ORDER BY "sort"
10:54:36.168	5.1 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (262, 263)
10:54:36.220	4.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id" IN (262, 263)
10:54:36.128	4.2 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_progresses' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:54:36.227	3.5 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;
10:54:36.263	3.2 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id") "c"
10:54:35.957	3.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='399'
10:54:36.225	2.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
10:54:35.979	2.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (262, 263)
10:54:36.271	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", "duration") VALUES (200, 'a57be577deb434', 5064, 5, 'vue/client/sandbox', '{"id":"399","web_access_token":"jc18-MbwnQYXsQ0nIniVZCT_0yFv9PMr"}', '{"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":[],"color":[]},{"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":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/148.0.0.0 Safari\/537.36"}', FALSE, '2026-06-04 10:54:36', 322393856) RETURNING "id"
10:54:35.950	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5064
10:54:36.262	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:54:35.954	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
10:54:35.976	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "client_id"=399 ORDER BY "bargain_date"
10:54:36.218	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (5, 8, 1, 100, 107, 130, 167, 142, 183, 188, 2100000000, 323, 369, 226, 45, 165, 179, 189, 319, 367, 359)) ORDER BY "sort"
10:54:35.950	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:54:36.219	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (5, 8, 1, 100, 107, 130, 167, 142, 183, 188, 2100000000, 323, 369, 226, 45, 165, 179, 189, 319, 367, 359)) ORDER BY "sort"
10:54:36.267	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
10:54:36.219	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (262, 263)
10:54:36.217	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (262, 263)