ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a2bc03c35c09: POST https://beta.jinchangxiao.com/v2/schedule/fulfill at 2026-06-12 04:15:56 pm by 223.104.41.38

Performance Profiling

Total processing time: 221 ms; Peak memory: 6.149 MB. Show Profiling Timeline

总计80条数据
TimeDurationCategoryInfo
  
16:15:56.34934.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id"=18364) GROUP BY "object_id"
16:15:56.25932.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=982) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:15:56.38426.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id"=18364) GROUP BY "object_id"
16:15:56.41915.7 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/schedule/fulfill', '{"ScheduleDescriptions":{"description":"\u6062\u590d\u540e\u5c31\u653e\u5047","schedule_id":"18364"},"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","posttime":"1781252096","token":"ad4fc02a037fb49fd47ee0a88bd2f021","version_code":"1159"}', '{"code":200,"data":{"model":{"id":18364,"client_id":982,"schedule_title":"\u65b0\u5efa\u4ee3\u529e\u4e8b\u9879","description":null,"schedule_week":null,"start_at":"2026-06-12 16:14:00","complete_at":"2026-06-12 16:15:56","complete_description":null,"is_complete":true,"alarm_before":null,"created_by":1000,"created_at":"2026-06-12 16:15:14","is_closed":true,"is_remind":false,"time_type":null,"schedule_end":null,"repeat_id":null,"end_at":"2026-06-12 18:00:00","is_public":1,"system_calendar_id":null,"creator":1000,"project_id":4184,"updated_at":"2026-06-12 16:15:30","set_top_at":null,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240","sales_rep":1001,"logo":null,"salesRep":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"}},"project":{"id":4184,"key":4184,"name":"\u560e\u560e\u560e","project_status":1,"budget":"0","collected":"0","projectStatus":{"id":1,"key":1,"name":"\u9690\u6027\u9700\u6c42","color":"#ffc000"},"project_status_display":"\u9690\u6027\u9700\u6c42","bgcolor":"#ffc000"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"scheduleCreator":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}},"headUsers":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/\/avatar\/618545c1-a2ce-3918-9d51-25924baf6d6f.jpg"}}],"attachmentRelationships":[{"id":57698,"object_type":9,"object_id":18364,"attachment_id":32713,"attachment":{"id":32713,"key":32713,"name":"8871557a-c0b6-35ac-b951-69ddd138558f","extension":"png","path":"\/v2\/attachment\/view\/R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC\/8871557a-c0b6-35ac-b951-69ddd138558f\/20260612161504.png","orig_name":"20260612161504.png"}}],"scheduleCarbonCopyRels":[{"id":1015,"schedule_id":18364,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"scheduleDescriptions":[{"id":21068,"schedule_id":18364,"description":"\u6062\u590d\u540e\u5c31\u653e\u5047","created_at":"2026-06-12 16:15:56","created_at_display":"06-12 (\u4eca\u5929) 16:15"},{"id":21067,"schedule_id":18364,"description":"\u597d\u6210\u7ee9","created_at":"2026-06-12 16:15:48","created_at_display":"06-12 (\u4eca\u5929) 16:15"},{"id":21066,"schedule_id":18364,"description":"\u4e0d\u7b26\u5408\u54c8\u54c8","created_at":"2026-06-12 16:15:40","created_at_display":"06-12 (\u4eca\u5929) 16:15"}],"commentCount":{"object_id":18364,"comment":6},"unreadComments":null,"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"06-12 (\u4eca\u5929) 16:15","complete_at_display2":"","end_at_display":"2026-06-12 18:00:00+08","end_at_display2":"","is_self":true,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":"2026-06-12 16:14:00+08"},"options":[{"key":"Schedules[headUsers]","name":"Creator","value":[{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f"},{"id":5250,"key":5250,"name":"\u8463\u8363"},{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633"},{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3"},{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633"},{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85"},{"id":5446,"key":5446,"name":"\u5218\u5a1f"},{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda"},{"id":5087,"key":5087,"name":"\u5218\u5fae"},{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91"},{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280"},{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11"},{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"id":5248,"key":5248,"name":"\u6587\u4f73\u9f99"},{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"id":1015,"key":1015,"name":"\u5434\u660a"},{"id":5461,"key":5461,"name":"\u8096\u5e05"},{"id":1022,"key":1022,"name":"\u5f90\u7855"},{"id":5476,"key":5476,"name":"\u6768\u5dcd"},{"id":5064,"key":5064,"name":"\u59da\u96ea\u7eaf"},{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3"},{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09"},{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065"}]},{"key":"Schedules[alarm_before]","name":"\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u4e0d\u63d0\u9192"},{"key":"00:05:00","name":"\u63d0\u524d5\u5206\u949f"},{"key":"00:15:00","name":"\u63d0\u524d15\u5206\u949f"},{"key":"00:30:00","name":"\u63d0\u524d30\u5206\u949f"},{"key":"01:00:00","name":"\u63d0\u524d1\u5c0f\u65f6"},{"key":"02:00:00","name":"\u63d0\u524d2\u5c0f\u65f6"},{"key":"24:00:00","name":"\u63d0\u524d1\u5929"},{"key":"48:00:00","name":"\u63d0\u524d2\u5929"}]}]},"status":1,"msg":[{"name":"success","success":"\u5f85\u529e\u4e8b\u9879\u5df2\u6210\u529f\u6c47\u62a5","error":""}],"ip":"223.104.41.38","ua":"jinchangxiao\/2.3.156 (iPhone 12; iOS 26.5; Scale\/3.00)"}', FALSE, '2026-06-12 16:15:56', 198349056) RETURNING "id"
16:15:56.3413.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=18364)
16:15:56.2322.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_schedule_descriptions" ("description", "schedule_id", "created_at") VALUES ('恢复后就放假', 18364, 'now()') RETURNING "id"
16:15:56.3472.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id"=18364 ORDER BY "created_at" DESC
16:15:56.3082.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=4184) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1
16:15:56.2921.7 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (982, 1001, 'now()', NULL) RETURNING "id"
16:15:56.3261.6 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '9', 18364, '曹永生完成了一条待办事项', TRUE, '新建代办事项') RETURNING "id"
16:15:56.2571.6 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=982
16:15:56.2481.5 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (18364, '9', 220864, 5016)
16:15:56.2941.4 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', 199976, 'a:5:{s:2:"id";i:199976;s:9:"client_id";i:982;s:9:"sales_rep";i:1001;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1000, '223.104.41.38')
16:15:56.3311.4 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'is_closed', 18364, 9, NULL, NULL, 1000, 'now()', '[false]', '[true]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}'), (2, 'is_closed', 982, 10, 18364, 9, 1000, 'now()', '[false]', '[true]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}'), (2, 'is_closed', 4184, 1, 18364, 9, 1000, 'now()', '[false]', '[true]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5b8c\u6210\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]}')
16:15:56.3021.4 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 982, 10, 18364, 9, 1000, '18364', '18364', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"
16:15:56.2381.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, 'scheduleDescriptions', 18364, 9, 1000, 'now()', '["\u6062\u590d\u540e\u5c31\u653e\u5047"]', '[[]]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]}')
16:15:56.2351.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\ScheduleDescriptions', 21068, 'a:4:{s:2:"id";i:21068;s:11:"schedule_id";s:5:"18364";s:11:"description";s:18:"恢复后就放假";s:10:"created_at";s:19:"1970-01-01 08:00:00";}', '', 1000, '223.104.41.38')
16:15:56.3071.3 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=4184
16:15:56.3381.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id"=18364
16:15:56.2451.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1000, '9', 18364, '曹永生更新了一条待办事项', TRUE, '新建代办事项') RETURNING "id"
16:15:56.2951.2 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', 982, 'a:0:{}', '', 1000, '223.104.41.38')
16:15:56.2471.2 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', 220864, 'a:11:{s:2:"id";i:220864;s:9:"object_id";i:18364;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"曹永生更新了一条待办事项";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:18:"新建代办事项";}', '', 1000, '223.104.41.38')
16:15:56.2971.1 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', 982, 10, 18364, 9, 1000, '[18364]', '[18364]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"
16:15:56.3031.1 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\UserActionLogs', 172013, 'a:15:{s:2:"id";i:172013;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.41.38')
16:15:56.3151.1 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', 641890, 'a:13:{s:2:"id";i:641890;s:9:"object_id";i:4184;s:11:"object_type";i:1;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[18364]";s:9:"new_value";s:7:"[18364]";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.38')
16:15:56.3141.1 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', 4184, 1, 18364, 9, 1000, '[18364]', '[18364]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"
16:15:56.3181.1 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 4184, 1, 18364, 9, 1000, '18364', '18364', array[1001], '{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}') RETURNING "id"
16:15:56.3111.1 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', 4184, 'a:0:{}', '', 1000, '223.104.41.38')
16:15:56.3211.0 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_schedules" SET "complete_at"='now()', "is_complete"=TRUE, "is_closed"=TRUE WHERE "id"=18364
16:15:56.2991.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\ObjectChangeLogs', 641889, 'a:13:{s:2:"id";i:641889;s:9:"object_id";i:982;s:11:"object_type";i:10;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:7:"[18364]";s:9:"new_value";s:7:"[18364]";s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.38')
16:15:56.3281.0 msyii\db\Command::executeINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (18364, '9', 220865, 5016)
16:15:56.3190.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\UserActionLogs', 172014, 'a:15:{s:2:"id";i:172014;s:9:"object_id";i:4184;s:11:"object_type";i:1;s:9:"target_id";i:18364;s:18:"target_object_type";i:9;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:5:"18364";s:9:"new_value";s:5:"18364";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1001]";s:6:"params";a:0:{}}s:11:"description";s:95:"{"d1":"\u66f9\u6c38\u751f","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[""]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1000, '223.104.41.38')
16:15:56.3220.9 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\Schedules', 18364, 'a:3:{s:8:"start_at";s:19:"2026-06-12 16:14:00";s:6:"end_at";s:19:"2026-06-12 18:00:00";s:11:"complete_at";s:5:"now()";}', '', 1000, '223.104.41.38')
16:15:56.2240.8 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'
16:15:56.3270.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\Comments', 220865, 'a:11:{s:2:"id";i:220865;s:9:"object_id";i:18364;s:11:"object_type";s:1:"9";s:6:"parent";N;s:11:"description";s:36:"曹永生完成了一条待办事项";s:10:"created_by";i:1000;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:18:"新建代办事项";}', '', 1000, '223.104.41.38')
16:15:56.2540.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
16:15:56.4120.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5446, 5461, 5476)) 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
16:15:56.2260.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.4120.5 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:15:56.3050.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184
16:15:56.2300.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364'
16:15:56.2370.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.2310.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364')
16:15:56.2970.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3010.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3170.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
16:15:56.3000.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
16:15:56.2430.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=18364
16:15:56.3120.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
16:15:56.3170.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3130.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3200.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.2440.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
16:15:56.2500.4 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5016) AND ("id" != 1000) AND (channel_id IS NOT NULL)
16:15:56.3240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3360.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.2400.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=18364
16:15:56.2320.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364'
16:15:56.3340.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=982
16:15:56.3330.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"='18364'
16:15:56.3460.3 msyii\db\Command::querySELECT "id", "id" AS "key", CASE WHEN user_status = '-1' THEN name || '(已离职)' ELSE name END AS name, "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
16:15:56.3160.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184
16:15:56.3250.3 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
16:15:56.3300.3 msyii\db\Command::querySELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5016) AND ("id" != 1000) AND (channel_id IS NOT NULL)
16:15:56.2230.3 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:15:56.3370.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
16:15:56.3240.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedules" WHERE "id"=18364
16:15:56.3450.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=32713
16:15:56.3230.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=18364
16:15:56.3350.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id"=4184
16:15:56.3400.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
16:15:56.3380.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
16:15:56.3360.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3450.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id"=18364
16:15:56.3350.3 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=1
16:15:56.3460.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
16:15:56.3400.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3370.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
16:15:56.3340.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:15:56.3360.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10