ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c90d7e223f0: POST https://beta.jinchangxiao.com/vue/sales-order-item/save-edit at 2025-09-16 03:10:54 pm by 114.244.128.96

Performance Profiling

Total processing time: 97 ms; Peak memory: 4.185 MB. Show Profiling Timeline

总计58条数据
TimeDurationCategoryInfo
  
15:10:54.18922.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2136) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:10:54.1744.2 msyii\db\Command::queryselect 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_sales_order_item_remind_receivers' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:10:54.1704.2 msyii\db\Command::querySELECT 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_sales_order_item_remind_receivers' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:10:54.1803.5 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sales_order_item_remind_receivers" ("sales_order_item_id", "user_id") VALUES (13292, 5087) RETURNING "id"
15:10:54.1432.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1011
15:10:54.1612.2 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_sales_order_items" SET "product_id"=2112, "supplier_id"=723, "updated_at"='now()', "software_from"=NULL, "maintenance_from"=NULL, "software_to"=NULL, "maintenance_to"=NULL, "client_id"=2136, "project_id"=3951, "renew_to_sales_order_item_id"=NULL, "need_sn"=FALSE WHERE "id"=13292
15:10:54.1652.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id"=13292)
15:10:54.1411.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:10:54.1671.8 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=27) AND ("object_id"=13292)
15:10:54.2261.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "project_id"=3951
15:10:54.2201.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3951) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:10:54.1471.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:10:54.1581.3 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'need_sn', 13292, 34, 1011, 'now()', '["\u5426"]', '["\u5426"]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u662f\u5426\u9700\u8981SN","d4":["\u5426 <b>\u53d8\u4e3a<\/b> \u5426"]}')
15:10:54.2291.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3951) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
15:10:54.2121.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2136, 5087, 'now()', NULL) RETURNING "id"
15:10:54.1881.1 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2136
15:10:54.2341.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1011, 5, 'vue/sales-order-item/save-edit', '{"SalesOrderItems":{"id":"13292","client_id":"2136","client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240 59\u6240","project_id":"3951","project_name":"\u8bfb\u5361\u5668\u91c7\u8d2d","sales_date":"2025-08-25","hardware_from":"2025-08-25","hardware_to":"2026-08-25","software_from":"","software_to":"","maintenance_from":"","maintenance_to":"","salesOrderItemRemindReceivers":["5087"],"product_id":"2112","product_name":"\u975e\u63a5\u89e6\u8bfb\u5361\u5668","pn":"","sn":"","amount":"460","cost":"258.00","supplier_id":"723","description":"","renew_to_sales_order_item_id":"","renew_to_sales_order_item_name":"","salesOrerProject_name":"","salesOrerProject_id":"","run_is_renew":"false","need_sn":"0","supplier_name":"\u5317\u4eac\u65ed\u65e5\u5b89\u6cf0\u79d1\u6280\u6709\u9650\u516c\u53f8","files":""},"web_access_token":"18_8RvXePAHKXb4kC8IN2O6XIdrtwTnd"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9500\u552e\u8bb0\u5f55\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-16 15:10:54') RETURNING "id"
15:10:54.1641.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesOrderItems', 13292, 'a:0:{}', '', 1011, '114.244.128.96')
15:10:54.2191.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3951
15:10:54.1791.0 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id"=13292
15:10:54.1520.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2136'
15:10:54.1500.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "id"='13292'
15:10:54.2240.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 565562, 'a:13:{s:2:"id";i:565562;s:9:"object_id";s:4:"3951";s:11:"object_type";i:1;s:9:"target_id";i:13292;s:18:"target_object_type";i:34;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[13292]";s:9:"new_value";s:7:"[13292]";s:11:"description";s:131:"{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}";s:10:"created_by";i:1011;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1011, '114.244.128.96')
15:10:54.2160.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 2136, 10, 13292, 34, 1011, '[13292]', '[13292]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}') RETURNING "id"
15:10:54.2320.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 723, 12, 13292, 34, 1011, '[13292]', '[13292]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}') RETURNING "id"
15:10:54.2140.8 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 180881, 'a:5:{s:2:"id";i:180881;s:9:"client_id";i:2136;s:9:"sales_rep";i:5087;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1011, '114.244.128.96')
15:10:54.2230.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 3951, 1, 13292, 34, 1011, '[13292]', '[13292]', '{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}') RETURNING "id"
15:10:54.1830.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\SalesOrderItemRemindReceivers', 11978, 'a:3:{s:2:"id";i:11978;s:19:"sales_order_item_id";i:13292;s:7:"user_id";s:4:"5087";}', '', 1011, '114.244.128.96')
15:10:54.1850.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\SalesOrderItems', 13292, 'a:0:{}', '', 1011, '114.244.128.96')
15:10:54.2310.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3951, 'a:0:{}', '', 1011, '114.244.128.96')
15:10:54.2170.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 565561, 'a:13:{s:2:"id";i:565561;s:9:"object_id";s:4:"2136";s:11:"object_type";i:10;s:9:"target_id";i:13292;s:18:"target_object_type";i:34;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[13292]";s:9:"new_value";s:7:"[13292]";s:11:"description";s:131:"{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}";s:10:"created_by";i:1011;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1011, '114.244.128.96')
15:10:54.2140.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2136, 'a:0:{}', '', 1011, '114.244.128.96')
15:10:54.2220.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3951, 'a:0:{}', '', 1011, '114.244.128.96')
15:10:54.2330.7 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 565563, 'a:13:{s:2:"id";i:565563;s:9:"object_id";s:3:"723";s:11:"object_type";i:12;s:9:"target_id";i:13292;s:18:"target_object_type";i:34;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[13292]";s:9:"new_value";s:7:"[13292]";s:11:"description";s:131:"{"d1":"\u97e9\u96c5\u82b3","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u8bb0\u5f55","d4":["\u975e\u63a5\u89e6\u8bfb\u5361\u5668"]}";s:10:"created_by";i:1011;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1011, '114.244.128.96')
15:10:54.1540.6 msyii\db\Command::querySELECT min(hardware_from) as min_hardware_from, min(software_from) as min_software_from, min(maintenance_from) as min_maintenance_from FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id"=13292 GROUP BY "sales_order_item_id"
15:10:54.2260.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_product_rels" WHERE "project_id"=3951
15:10:54.1690.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_item_remind_receivers" WHERE "sales_order_item_id"=13292
15:10:54.2180.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3951'
15:10:54.1530.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2112'
15:10:54.1550.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3951')
15:10:54.1560.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='723')
15:10:54.1850.3 msyii\db\Command::querySELECT max(hardware_to) as new_hardware_deadline, max(software_to) as new_software_deadline, max(maintenance_to) as new_maintenance_deadline FROM "a57be577deb434"."tbl_sales_order_item_renew_logs" WHERE "sales_order_item_id"=13292 GROUP BY "sales_order_item_id"
15:10:54.2310.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2136
15:10:54.2230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2136
15:10:54.1860.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2136'
15:10:54.1550.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2136')
15:10:54.1840.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sales_order_items" WHERE "id"=13292
15:10:54.2250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3951
15:10:54.1590.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2136')
15:10:54.1570.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
15:10:54.1570.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
15:10:54.1610.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5087)
15:10:54.1560.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2112')
15:10:54.2150.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2112'
15:10:54.1600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1011)
15:10:54.1590.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3951')
15:10:54.1600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_products" WHERE "id"='2112')
15:10:54.1600.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='723')