All Latest
6a1e9a6cf1432: POST https://beta.jinchangxiao.com/vue/source/save-new at 2026-06-02 04:55:08 pm by 221.216.117.119

Performance Profiling

Total processing time: 53 ms; Peak memory: 4.207 MB. Show Profiling Timeline

总计50条数据
TimeDurationCategoryInfo
  
16:55:09.0144.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=391) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:55:09.0333.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (587, '21', 220648, 5299), (587, '21', 220648, 5079), (587, '21', 220648, 5023), (587, '21', 220648, 5062), (587, '21', 220648, 1029), (587, '21', 220648, 5411), (587, '21', 220648, 5088), (587, '21', 220648, 1030), (587, '21', 220648, 5409), (587, '21', 220648, 5303), (587, '21', 220648, 5126), (587, '21', 220648, 5078), (587, '21', 220648, 5043), (587, '21', 220648, 1000), (587, '21', 220648, 5065), (587, '21', 220648, 5123), (587, '21', 220648, 5032), (587, '21', 220648, 5093), (587, '21', 220648, 1002), (587, '21', 220648, 5359), (587, '21', 220648, 1009), (587, '21', 220648, 5300), (587, '21', 220648, 5048), (587, '21', 220648, 5329), (587, '21', 220648, 5304), (587, '21', 220648, 5037), (587, '21', 220648, 5356), (587, '21', 220648, 5259), (587, '21', 220648, 5094), (587, '21', 220648, 5044), (587, '21', 220648, 5230), (587, '21', 220648, 5073), (587, '21', 220648, 5124), (587, '21', 220648, 5229), (587, '21', 220648, 5297), (587, '21', 220648, 5358), (587, '21', 220648, 1025), (587, '21', 220648, 1003), (587, '21', 220648, 5311), (587, '21', 220648, 5030), (587, '21', 220648, 5089), (587, '21', 220648, 5086), (587, '21', 220648, 1013), (587, '21', 220648, 5135), (587, '21', 220648, 5332), (587, '21', 220648, 5413), (587, '21', 220648, 5031), (587, '21', 220648, 5128), (587, '21', 220648, 5209), (587, '21', 220648, 5029), (587, '21', 220648, 5022), (587, '21', 220648, 5250), (587, '21', 220648, 5294), (587, '21', 220648, 5087), (587, '21', 220648, 5333), (587, '21', 220648, 5072), (587, '21', 220648, 5069), (587, '21', 220648, 5412), (587, '21', 220648, 5357), (587, '21', 220648, 5026), (587, '21', 220648, 5476), (587, '21', 220648, 5448), (587, '21', 220648, 5364), (587, '21', 220648, 5015), (587, '21', 220648, 5305), (587, '21', 220648, 5070), (587, '21', 220648, 5049), (587, '21', 220648, 5404), (587, '21', 220648, 1011), (587, '21', 220648, 5293), (587, '21', 220648, 1006), (587, '21', 220648, 5016), (587, '21', 220648, 5445), (587, '21', 220648, 5075), (587, '21', 220648, 1008), (587, '21', 220648, 5025), (587, '21', 220648, 5302), (587, '21', 220648, 1005), (587, '21', 220648, 5096), (587, '21', 220648, 5420), (587, '21', 220648, 5393), (587, '21', 220648, 5301), (587, '21', 220648, 5063), (587, '21', 220648, 1004), (587, '21', 220648, 5066), (587, '21', 220648, 5467), (587, '21', 220648, 1012), (587, '21', 220648, 5449), (587, '21', 220648, 5027), (587, '21', 220648, 5203), (587, '21', 220648, 5104), (587, '21', 220648, 5295), (587, '21', 220648, 1026), (587, '21', 220648, 5351), (587, '21', 220648, 5045), (587, '21', 220648, 5064), (587, '21', 220648, 5208), (587, '21', 220648, 5047), (587, '21', 220648, 5309), (587, '21', 220648, 5083), (587, '21', 220648, 5076), (587, '21', 220648, 5033), (587, '21', 220648, 5095)
16:55:08.9942.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391'
16:55:09.0021.9 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_sources" ("client_id", "client_name", "client_industry", "client_type", "client_class", "telephone", "telephone_area_code", "telephone_extension_number", "company_nature", "project_description", "from_contact", "project_status", "sales_rep", "contact_mobile", "contact_sex", "contact_name", "contact_id", "created_by", "status") VALUES (391, '北京特种机械研究所(8359)-S', 20, 1, 43, '', '', '', 3, '544 5', NULL, 2, NULL, '13693264768', 'M', '陈康', 896, 1001, 0) RETURNING "id"
16:55:09.0121.9 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=391
16:55:09.0311.5 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\Comments', 220648, 'a:1:{s:9:"is_system";b:1;}', '', 1001, '221.216.117.119')
16:55:09.0281.3 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\Comments', 220648, 'a:11:{s:2:"id";i:220648;s:9:"object_id";i:587;s:11:"object_type";s:2:"21";s:6:"parent";N;s:11:"description";s:30:"有一条销售线索待分配";s:10:"created_by";i:1001;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:0;s:8:"for_user";N;s:12:"description2";s:5:"544 5";}', '', 1001, '221.216.117.119')
16:55:09.0041.0 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\Sources', 587, 'a:26:{s:2:"id";i:587;s:11:"client_name";s:35:"北京特种机械研究所(8359)-S";s:12:"contact_name";s:6:"陈康";s:11:"contact_sex";s:1:"M";s:14:"contact_mobile";s:11:"13693264768";s:9:"telephone";s:0:"";s:19:"telephone_area_code";s:0:"";s:26:"telephone_extension_number";s:0:"";s:19:"project_description";s:5:"544 5";s:25:"projects_opportunity_from";N;s:9:"sales_rep";s:0:"";s:10:"project_id";N;s:9:"client_id";s:3:"391";s:10:"contact_id";s:3:"896";s:13:"distribute_by";N;s:13:"distribute_at";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:14:"company_nature";s:1:"3";s:6:"status";i:0;s:12:"from_contact";s:0:"";s:11:"client_type";s:1:"1";s:15:"client_industry";s:2:"20";s:12:"client_class";s:2:"43";s:14:"project_status";s:1:"2";}', '', 1001, '221.216.117.119')
16:55:09.0081.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 587, 21, 1001, '2026-06-02 16:55:09', '{"id":587,"client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","contact_name":"\u9648\u5eb7","contact_sex":"M","contact_mobile":"13693264768","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"544 5","projects_opportunity_from":null,"sales_rep":null,"project_id":null,"client_id":391,"contact_id":896,"distribute_by":null,"distribute_at":null,"created_by":1001,"created_at":"2026-06-02 16:55:09","updated_at":"2026-06-02 16:55:09","company_nature":3,"status":0,"from_contact":null,"client_type":1,"client_industry":20,"client_class":43,"project_status":2}', '{"id":587,"client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","contact_name":"\u9648\u5eb7","contact_sex":"M","contact_mobile":"13693264768","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"544 5","projects_opportunity_from":null,"sales_rep":null,"project_id":null,"client_id":391,"contact_id":896,"distribute_by":null,"distribute_at":null,"created_by":1001,"created_at":"2026-06-02 16:55:09","updated_at":"2026-06-02 16:55:09","company_nature":3,"status":0,"from_contact":null,"client_type":1,"client_industry":20,"client_class":43,"project_status":2}', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":[]}') RETURNING "id"
16:55:09.0271.0 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "description2", "is_system") VALUES (1001, '21', 587, '有一条销售线索待分配', '544 5', FALSE) RETURNING "id"
16:55:09.0070.9 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_source_product_types" ("product_type_id", "name", "source_id") VALUES (2, '服务器', 587)
16:55:09.0200.8 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (391, NULL, 'now()', NULL) RETURNING "id"
16:55:09.0390.8 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/source/save-new', '{"Sources":{"id":"","client_id":"391","client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","client_industry":"20","client_type":"1","client_class":"43","telephone":"","telephone_area_code":"","telephone_extension_number":"","company_nature":"3","project_description":"544 5 ","from_contact_name":"","from_contact":"","sourceProductTypes":["2"],"project_status":"2","sales_rep":"","contact_mobile":"13693264768","contact_sex":"M","contact_name":"\u9648\u5eb7","contact_id":"896"},"web_access_token":"RxNsgwK6AoRe247CZ3IJbk6VpAgcDvb0"}', '{"code":2000,"result":{"id":587},"status":1,"msg":[{"name":"success","success":"\u65b0\u9500\u552e\u7ebf\u7d22\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-02 16:55:09', 50318848) RETURNING "id"
16:55:09.0230.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 (1, 'create', 391, 10, 587, 21, 1001, '[587]', '[587]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":["544 5"]}') RETURNING "id"
16:55:09.0300.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_comments" SET "is_system"=TRUE WHERE "id"=220648
16:55:09.0180.7 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_client_am_change_logs" SET "end_at"='now()' WHERE "id"=152456
16:55:09.0100.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', 640935, 'a:13:{s:2:"id";i:640935;s:9:"object_id";i:587;s:11:"object_type";i:21;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:625:"{"id":587,"client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","contact_name":"\u9648\u5eb7","contact_sex":"M","contact_mobile":"13693264768","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"544 5","projects_opportunity_from":null,"sales_rep":null,"project_id":null,"client_id":391,"contact_id":896,"distribute_by":null,"distribute_at":null,"created_by":1001,"created_at":"2026-06-02 16:55:09","updated_at":"2026-06-02 16:55:09","company_nature":3,"status":0,"from_contact":null,"client_type":1,"client_industry":20,"client_class":43,"project_status":2}";s:9:"new_value";s:625:"{"id":587,"client_name":"\u5317\u4eac\u7279\u79cd\u673a\u68b0\u7814\u7a76\u6240(8359)-S","contact_name":"\u9648\u5eb7","contact_sex":"M","contact_mobile":"13693264768","telephone":"","telephone_area_code":"","telephone_extension_number":"","project_description":"544 5","projects_opportunity_from":null,"sales_rep":null,"project_id":null,"client_id":391,"contact_id":896,"distribute_by":null,"distribute_at":null,"created_by":1001,"created_at":"2026-06-02 16:55:09","updated_at":"2026-06-02 16:55:09","company_nature":3,"status":0,"from_contact":null,"client_type":1,"client_industry":20,"client_class":43,"project_status":2}";s:11:"description";s:93:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":[]}";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2026-06-02 16:55:09";s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
16:55:09.0190.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\ClientAmChangeLogs', 152456, 'a:1:{s:6:"end_at";s:19:"1970-01-01 08:00:00";}', '', 1001, '221.216.117.119')
16:55:09.0210.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\ClientAmChangeLogs', 199813, 'a:5:{s:2:"id";i:199813;s:9:"client_id";i:391;s:9:"sales_rep";N;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1001, '221.216.117.119')
16:55:09.0220.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', 391, 'a:0:{}', '', 1001, '221.216.117.119')
16:55:09.0240.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', 640936, 'a:13:{s:2:"id";i:640936;s:9:"object_id";i:391;s:11:"object_type";i:10;s:9:"target_id";i:587;s:18:"target_object_type";i:21;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:5:"[587]";s:9:"new_value";s:5:"[587]";s:11:"description";s:100:"{"d1":"\u5218\u4eba\u8bda","d2":"\u521b\u5efa\u4e86","d3":"\u9500\u552e\u7ebf\u7d22","d4":["544 5"]}";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1001, '221.216.117.119')
16:55:08.9900.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:55:09.0250.5 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name" IN ('AccountManager', 'Admin', 'Dispatcher', 'GM', 'SalesManager', '电话销售', '运营总监') GROUP BY "user_id"
16:55:09.0250.5 msyii\db\Command::querySELECT "parent" FROM "a57be577deb434"."tbl_auth_item_child" WHERE "child"='distributeSource' GROUP BY "parent"
16:55:09.0370.4 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (5299, 5079, 5023, 5062, 1029, 5411, 5088, 1030, 5409, 5303, 5126, 5078, 5043, 1000, 5065, 5123, 5032, 5093, 1002, 5359, 1009, 5300, 5048, 5329, 5304, 5037, 5356, 5259, 5094, 5044, 5230, 5073, 5124, 5229, 5297, 5358, 1025, 1003, 5311, 5030, 5089, 5086, 1013, 5135, 5332, 5413, 5031, 5128, 5209, 5029, 5022, 5250, 5294, 5087, 5333, 5072, 5069, 5412, 5357, 5026, 5476, 5448, 5364, 5015, 5305, 5070, 5049, 5404, 1011, 5293, 1006, 5016, 5445, 5075, 1008, 5025, 5302, 1005, 5096, 5420, 5393, 5301, 5063, 1004, 5066, 5467, 1012, 5449, 5027, 5203, 5104, 5295, 1026, 5351, 5045, 5064, 5208, 5047, 5309, 5083, 5076, 5033, 5095, 1001)) AND ("id" != 1001) AND (channel_id IS NOT NULL)
16:55:08.9980.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='896')
16:55:08.9910.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:55:09.0000.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391')
16:55:09.0080.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=587
16:55:09.0100.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=391
16:55:08.9890.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:55:08.9970.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391')
16:55:09.0060.2 msyii\db\Command::executeDELETE FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=587
16:55:09.0270.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:55:09.0260.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=587
16:55:09.0000.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='896')
16:55:09.0300.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:55:08.9980.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:55:09.0010.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)
16:55:08.9970.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='3')
16:55:09.0060.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"='2'
16:55:08.9990.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='20')
16:55:08.9990.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
16:55:08.9990.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43')
16:55:09.0020.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2')
16:55:09.0010.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43')
16:55:09.0000.2 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='3')
16:55:09.0010.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='20')
16:55:08.9990.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1')
16:55:09.0020.1 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1')