Total processing time: 53 ms; Peak memory: 4.207 MB. Show Profiling Timeline
| Time | Duration | Category | Info |
|---|---|---|---|
| 16:55:09.014 | 4.2 ms | yii\db\Command::query | SELECT * 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.033 | 3.9 ms | yii\db\Command::execute | INSERT 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.994 | 2.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391' |
| 16:55:09.002 | 1.9 ms | yii\db\Command::query | INSERT 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.012 | 1.9 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=391 |
| 16:55:09.031 | 1.5 ms | yii\db\Command::execute | INSERT 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.028 | 1.3 ms | yii\db\Command::execute | INSERT 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.004 | 1.0 ms | yii\db\Command::execute | INSERT 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.008 | 1.0 ms | yii\db\Command::query | INSERT 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.027 | 1.0 ms | yii\db\Command::query | INSERT 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.007 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_source_product_types" ("product_type_id", "name", "source_id") VALUES (2, '服务器', 587) |
| 16:55:09.020 | 0.8 ms | yii\db\Command::query | INSERT 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.039 | 0.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/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.023 | 0.8 ms | yii\db\Command::query | INSERT 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.030 | 0.8 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_comments" SET "is_system"=TRUE WHERE "id"=220648 |
| 16:55:09.018 | 0.7 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_client_am_change_logs" SET "end_at"='now()' WHERE "id"=152456 |
| 16:55:09.010 | 0.7 ms | yii\db\Command::execute | INSERT 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.019 | 0.7 ms | yii\db\Command::execute | INSERT 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.021 | 0.7 ms | yii\db\Command::execute | INSERT 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.022 | 0.7 ms | yii\db\Command::execute | INSERT 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.024 | 0.7 ms | yii\db\Command::execute | INSERT 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.990 | 0.7 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:55:09.025 | 0.5 ms | yii\db\Command::query | SELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name" IN ('AccountManager', 'Admin', 'Dispatcher', 'GM', 'SalesManager', '电话销售', '运营总监') GROUP BY "user_id" |
| 16:55:09.025 | 0.5 ms | yii\db\Command::query | SELECT "parent" FROM "a57be577deb434"."tbl_auth_item_child" WHERE "child"='distributeSource' GROUP BY "parent" |
| 16:55:09.037 | 0.4 ms | yii\db\Command::query | SELECT "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.998 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='896') |
| 16:55:08.991 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:55:09.000 | 0.4 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391') |
| 16:55:09.008 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=587 |
| 16:55:09.010 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=391 |
| 16:55:08.989 | 0.3 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 16:55:08.997 | 0.3 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='391') |
| 16:55:09.006 | 0.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_source_product_types" WHERE "source_id"=587 |
| 16:55:09.027 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:55:09.026 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_sources" WHERE "id"=587 |
| 16:55:09.000 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"='896') |
| 16:55:09.030 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:55:08.998 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:55:09.001 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:55:08.997 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='3') |
| 16:55:09.006 | 0.2 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_product_types" WHERE "id"='2' |
| 16:55:08.999 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='20') |
| 16:55:08.999 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2') |
| 16:55:08.999 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43') |
| 16:55:09.002 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"='2') |
| 16:55:09.001 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_classes" WHERE "id"='43') |
| 16:55:09.000 | 0.2 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_company_natures" WHERE "id"='3') |
| 16:55:09.001 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_industries" WHERE "id"='20') |
| 16:55:08.999 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1') |
| 16:55:09.002 | 0.1 ms | yii\db\Command::query | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_client_types" WHERE "id"='1') |