Performance Profiling

Total processing time: 92 ms; Peak memory: 5.663 MB. Show Profiling Timeline

总计20条数据

Time	Duration	Category	Info

19:29:29.073	18.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_user_role_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
19:29:29.112	13.8 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_groups' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
19:29:29.067	6.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_user_role_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
19:29:29.108	3.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_groups' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
19:29:29.095	3.3 ms	yii\db\Command::query	SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-07-12 19:29:29') AND ("bargain_date" <= '2026-07-12 19:29:29') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005)) GROUP BY "created_by"
19:29:29.131	2.8 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/analysis/project-data-get-filter', '[]', '{"code":2000,"result":{"filter":{"client_industry":{"key":"client_industry","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"},{"key":59,"name":"\u8d38\u6613"}],"default":""},"client_type":{"key":"client_type","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u5168\u8d44\u8d28\uff09"},{"key":6,"name":"\u836f\u54c1\u6279\u53d1\u4f01\u4e1a\uff08\u666e\u901a\uff09"},{"key":5,"name":"\u836f\u54c1\u96f6\u552e\u4f01\u4e1a\uff08\u5355\u4f53\uff09"},{"key":3,"name":"\u4e2a\u4eba\u6d88\u8d39\u8005"}]},"projectProductTypes":{"key":"projectProductTypes","name":"\u5546\u673a\u7c7b\u578b","value":[{"key":2,"name":"\u670d\u52a1\u5668"},{"key":3,"name":"\u5b58\u50a8\u8bbe\u5907"},{"key":4,"name":"\u7f51\u7edc\u8bbe\u5907 "},{"key":5,"name":"\u5b89\u5168\u8bbe\u5907"},{"key":88,"name":"\u79c1\u6709\u4e91"},{"key":8,"name":"\u4e91\u684c\u9762"},{"key":7,"name":"\u8f6f\u4ef6"},{"key":10,"name":"\u56fe\u5f62\u5de5\u4f5c\u7ad9"},{"key":69,"name":"\u5907\u4efd"},{"key":11,"name":"\u4e2a\u4eba\u8ba1\u7b97\u673a"},{"key":12,"name":"\u7b14\u8bb0\u672c"},{"key":13,"name":"\u6253\u5370\u673a"},{"key":14,"name":"UPS"},{"key":16,"name":"\u8fd0\u7ef4\u670d\u52a1"},{"key":17,"name":"\u5de5\u63a7\u673a"},{"key":18,"name":"\u673a\u623f\u8bbe\u5907"},{"key":19,"name":"\u6280\u672f\u670d\u52a1"},{"key":20,"name":"\u529e\u516c\u8bbe\u5907"},{"key":21,"name":"\u6570\u7801\u8bbe\u5907"},{"key":22,"name":"\u670d\u52a1"},{"key":23,"name":"\u793c\u54c1"},{"key":75,"name":"\u8f6f\u4ef6\u5f00\u53d1"},{"key":106,"name":"\u516c\u6709\u4e91"}]},"project_status":{"key":"project_status","name":"\u5546\u673a\u72b6\u6001","value":[{"key":1,"name":"\u9690\u6027\u9700\u6c42"},{"key":2,"name":"\u660e\u786e\u9700\u6c42"},{"key":3,"name":"\u5546\u673a\u6210\u4ea4"},{"key":4,"name":"\u5546\u673a\u5931\u8d25"},{"key":5,"name":"\u5546\u673a\u6401\u7f6e"},{"key":-1,"name":"\u6536\u6b3e\u5b8c\u6210"}]},"purchaseType":{"key":"purchaseType","name":"\u91c7\u8d2d\u65b9\u5f0f","value":[{"id":128,"key":128,"name":"\u516c\u5f00\u62db\u6807"},{"id":129,"key":129,"name":"\u7279\u7ea6\u9080\u6807"},{"id":130,"key":130,"name":"\u7ade\u4e89\u8c08\u5224"},{"id":164,"key":164,"name":"\u591a\u5bb6\u6bd4\u4ef7"},{"id":165,"key":165,"name":"\u534f\u8bae\u4f9b\u8d27"},{"id":182,"key":182,"name":"\u56f4\u6807"}]},"dataUserId":{"key":"dataUserId","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"id":0,"key":"1001,1004,1005,1013,5087,5295,5300,5311,5332,5476,5499,5500","name":"\u5168\u90e8","child":[]},{"id":80,"key":"1004,1005,1013,5087","name":"\u5408\u4f19\u4eba","child":[{"key":5087,"name":"\u5218\u5fae"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"}]},{"id":1,"key":"1001,5295,5300,5311","name":"\u5218\u4eba\u8bda\u7ec4","child":[{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5300,"name":"\u82cf\u6e05\u4e91"},{"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"}]},{"id":81,"key":"5332","name":"\u4f0a\u5cfb\u8fb0\u7ec4","child":[{"key":5332,"name":"\u970d\u536b\u8d85"}]},{"id":83,"key":"5476,5499,5500","name":"\u91d1\u7545\u900d","child":[{"key":5500,"name":"\u6d4b\u8bd5"},{"key":5499,"name":"\u9648\u8c46\u8c46"},{"key":5476,"name":"\u6768\u5dcd"}]}],"default":1001,"itemKey":"dataUserId","groupKey":"group"}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"66.249.66.8","ua":"Mozilla\/5.0 (Linux; Android 6.0.1; Nexus 5X Build\/MMB29P) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/150.0.7871.46 Mobile Safari\/537.36 (compatible; GoogleOther)"}', FALSE, '2026-07-12 19:29:29', 83190016) RETURNING "id"
19:29:29.065	1.5 ms	yii\db\Command::query	SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-07-12 19:29:29, 2026-07-12 19:29:29]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
19:29:29.128	1.3 ms	yii\db\Command::query	SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-07-12 19:29:29') AND ("bargain_date" <= '2026-07-12 19:29:29') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005)) GROUP BY "created_by"
19:29:29.106	1.2 ms	yii\db\Command::query	SELECT g.id, g.name, string_agg( sgr.sales_id::varchar, ',') AS list FROM "a57be577deb434"."tbl_groups" "g" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.group_id = g.id WHERE "sgr"."sales_id" IN (5500, 5499, 5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005) GROUP BY "g"."id" ORDER BY "sort"
19:29:29.100	1.2 ms	yii\db\Command::query	SELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2026-07-12 19:29:29') AND ("bargain_date" <= '2026-07-12 19:29:29') AND ("project_status"=3) AND ("created_by" NOT IN (5500, 5499, 5332, 1001, 5087, 5300, 5311, 5295, 1013, 5476, 1004, 1005)) GROUP BY "created_by"
19:29:29.099	1.1 ms	yii\db\Command::query	SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-07-12 19:29:29, 2026-07-12 19:29:29]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
19:29:29.059	1.0 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "is_delete"=FALSE ORDER BY "order"
19:29:29.052	1.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
19:29:29.126	0.9 ms	yii\db\Command::query	SELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-07-12 19:29:29, 2026-07-12 19:29:29]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
19:29:29.062	0.8 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id"
19:29:29.055	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
19:29:29.061	0.6 ms	yii\db\Command::query	SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "is_delete"=FALSE ORDER BY "order"
19:29:29.064	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
19:29:29.063	0.6 ms	yii\db\Command::query	SELECT "id" AS "key", "project_status" AS "name" FROM "a57be577deb434"."tbl_project_statuses" ORDER BY "order"
19:29:29.052	0.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta