Total processing time: 223 ms; Peak memory: 5.670 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 14:43:17.300 | 104.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096) |
| 14:43:17.220 | 16.9 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 14:43:17.278 | 15.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_projects' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum |
| 14:43:17.237 | 11.2 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:43:17.268 | 8.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_projects' and d.nspname = 'a57be577deb434' ORDER BY a.attnum; |
| 14:43:17.425 | 5.3 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":"2553","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"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":[{"tips":[{"name":"\u5546\u673a\u540d\u79f0","value":"\u6a21\u5757\u91c7\u8d2d"},{"name":"\u5ba2\u6237\u7ecf\u7406","value":"\u5218\u4eba\u8bda"},{"name":"\u5546\u673a\u72b6\u6001","value":"\u5546\u673a\u6210\u4ea4"},{"name":"\u5546\u673a\u91d1\u989d","value":"\uffe51 400.00\u5143"},{"name":"\u5408\u540c\u7c7b\u578b","value":"\u4ea7\u54c1\u9500\u552e"},{"name":"\u9500\u552e\u9636\u6bb5","value":"\u7b7e\u8ba2\u5408\u540c"},{"name":"\u9500\u552e\u9884\u6d4b","value":"\u5382\u5546\u8fc7\u5355"},{"name":"\u91c7\u8d2d\u65b9\u5f0f","value":"\u534f\u8bae\u4f9b\u8d27"},{"name":"\u5546\u673a\u6765\u6e90","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u552e\u524d\u652f\u6301","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u6210\u4ea4\u65e5\u671f","value":"2026-01-12"},{"name":"\u5546\u673a\u5185\u5bb9","value":"(\u672a\u8bbe\u7f6e)"}],"color":"#53cd02"}],"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":[{"tips":[{"name":"\u5546\u673a\u540d\u79f0","value":"PA440 ATP\/AWF\/ADVURL \u6388\u6743\u65b0\u8d2d\u9879\u76ee"},{"name":"\u5ba2\u6237\u7ecf\u7406","value":"\u5218\u4eba\u8bda"},{"name":"\u5546\u673a\u72b6\u6001","value":"\u5546\u673a\u6210\u4ea4"},{"name":"\u5546\u673a\u91d1\u989d","value":"\uffe587 000.00\u5143"},{"name":"\u5408\u540c\u7c7b\u578b","value":"\u4ea7\u54c1\u9500\u552e"},{"name":"\u9500\u552e\u9636\u6bb5","value":"\u7b7e\u8ba2\u5408\u540c"},{"name":"\u9500\u552e\u9884\u6d4b","value":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},{"name":"\u91c7\u8d2d\u65b9\u5f0f","value":"\u591a\u5bb6\u6bd4\u4ef7"},{"name":"\u5546\u673a\u6765\u6e90","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u552e\u524d\u652f\u6301","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u6210\u4ea4\u65e5\u671f","value":"2024-12-25"},{"name":"\u5546\u673a\u5185\u5bb9","value":"(\u672a\u8bbe\u7f6e)"}],"color":"#7b33c5"},{"tips":[{"name":"\u5546\u673a\u540d\u79f0","value":"10\u53f0 PA445 \u8bbe\u5907\u91c7\u8d2d\u9879\u76ee\uff08\u6c99\u7279\u9879\u76ee\uff09"},{"name":"\u5ba2\u6237\u7ecf\u7406","value":"\u5218\u4eba\u8bda"},{"name":"\u5546\u673a\u72b6\u6001","value":"\u5546\u673a\u6210\u4ea4"},{"name":"\u5546\u673a\u91d1\u989d","value":"\uffe5885 300.00\u5143"},{"name":"\u5408\u540c\u7c7b\u578b","value":"\u4ea7\u54c1\u9500\u552e"},{"name":"\u9500\u552e\u9636\u6bb5","value":"\u7b7e\u8ba2\u5408\u540c"},{"name":"\u9500\u552e\u9884\u6d4b","value":"\u6211\u4e0e\u5382\u5546\u8054\u624b"},{"name":"\u91c7\u8d2d\u65b9\u5f0f","value":"\u56f4\u6807"},{"name":"\u5546\u673a\u6765\u6e90","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u552e\u524d\u652f\u6301","value":"(\u672a\u8bbe\u7f6e)"},{"name":"\u6210\u4ea4\u65e5\u671f","value":"2025-07-21"},{"name":"\u5546\u673a\u5185\u5bb9","value":"(\u672a\u8bbe\u7f6e)"}],"color":"#53cd02"}],"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":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 14:43:17', 209474048) RETURNING "id" |
| 14:43:17.254 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:43:17.262 | 1.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2553' |
| 14:43:17.266 | 1.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "client_id"=2553 ORDER BY "bargain_date" |
| 14:43:17.296 | 1.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_product_types" WHERE "project_id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096) |
| 14:43:17.405 | 1.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=13) AND ("id" IN (2, 1, 215, 167, 5, 164, 172, 135, 140, 196, 204, 184, 189, 340, 165, 181, 182, 226, 232, 349, 356, 369, 324)) ORDER BY "sort" |
| 14:43:17.265 | 1.0 ms | yii\db\Command::query | SELECT *, "id" AS "key", "description" AS "value" FROM "a57be577deb434"."tbl_client_product_types" WHERE "client_id"=2553 |
| 14:43:17.414 | 0.9 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id") "c" |
| 14:43:17.252 | 0.8 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 14:43:17.298 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_progresses" WHERE "id" IN (9, 7, 6) |
| 14:43:17.411 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_architects" WHERE "project_id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096) |
| 14:43:17.408 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096) |
| 14:43:17.409 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3251, 3424, 3591, 3644, 3752, 3751, 4096) |
| 14:43:17.409 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=9) AND ("id" IN (2, 1, 215, 167, 5, 164, 172, 135, 140, 196, 204, 184, 189, 340, 165, 181, 182, 226, 232, 349, 356, 369, 324)) ORDER BY "sort" |
| 14:43:17.412 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3 |
| 14:43:17.413 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 14:43:17.410 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=10) AND ("id" IN (2, 1, 215, 167, 5, 164, 172, 135, 140, 196, 204, 184, 189, 340, 165, 181, 182, 226, 232, 349, 356, 369, 324)) ORDER BY "sort" |
| 14:43:17.415 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "is_delete"=FALSE ORDER BY "order", "id" |