Performance Profiling

Total processing time: 125 ms; Peak memory: 5.214 MB. Show Profiling Timeline

总计27条数据

Time	Duration	Category	Info

11:12:57.142	15.4 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
11:12:57.163	14.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_progresses' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
11:12:57.117	11.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_client_product_types' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
11:12:57.177	7.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1111, 1018)
11:12:57.111	5.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_client_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
11:12:57.137	4.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_project_product_types' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
11:12:57.158	4.0 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;
11:12:57.201	3.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id") "c"
11:12:57.107	3.0 ms	yii\db\Command::query	SELECT *, "id" AS "key", "description" AS "value" FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id"=982
11:12:57.097	2.9 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
11:12:57.187	2.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (94, 2, 100, 128, 167, 140, 181, 205, 204, 319, 359, 8, 228, 304, 45, 171, 172, 159)) ORDER BY "sort"
11:12:57.195	2.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1016, 1023, 5074)
11:12:57.094	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:12:57.193	1.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id" IN (1111, 1018)
11:12:57.101	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
11:12:57.212	1.5 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/client/sandbox', '{"id":"982","web_access_token":"er_liQPTz011rRwTshQzixBLTwcD6PCJ"}', '{"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":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}","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":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}","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":"{\"name\":\"\",\"time\":\"\",\"content\":\"\\u65e0\"}","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":[]}],"can_edit":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-04 11:12:57') RETURNING "id"
11:12:57.135	1.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (1111, 1018)
11:12:57.129	1.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "client_id"=982 ORDER BY "bargain_date"
11:12:57.104	1.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='982'
11:12:57.191	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (94, 2, 100, 128, 167, 140, 181, 205, 204, 319, 359, 8, 228, 304, 45, 171, 172, 159)) ORDER BY "sort"
11:12:57.158	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (49, 4)
11:12:57.199	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1003, 1001)
11:12:57.198	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id" IN (3, 5)
11:12:57.193	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (94, 2, 100, 128, 167, 140, 181, 205, 204, 319, 359, 8, 228, 304, 45, 171, 172, 159)) ORDER BY "sort"
11:12:57.204	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
11:12:57.190	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1111, 1018)
11:12:57.192	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (1111, 1018)