ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
69427e8940aca: POST https://beta.jinchangxiao.com/v2/client/list-document at 2025-12-17 05:57:29 pm by 221.216.117.150

Log Messages

总计43条数据
TimeLevelCategoryMessage
 
17:57:29.264traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
17:57:29.264traceyii\base\Module::getModuleLoading module: debug
17:57:29.264traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
17:57:29.265traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
17:57:29.265traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
17:57:29.265traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.265traceyii\base\Module::getModuleLoading module: gii
17:57:29.265traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
17:57:29.265traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
17:57:29.265traceyii\web\Application::handleRequestRoute requested: 'v2/client/list-document'
17:57:29.265traceyii\base\Module::getModuleLoading module: v2
17:57:29.266infoyii\web\Session::openSession started
17:57:29.267infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:57:29.270infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG'
17:57:29.274traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.275traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:29.275traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.275traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:29.275infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
17:57:29.278traceyii\base\Controller::runActionRoute to run: v2/client/list-document
17:57:29.278traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.280traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
17:57:29.280traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\ClientController::actionListDocument()
17:57:29.280traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.281traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.282infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='518') AND ("deleted"=FALSE) AND (("sales_rep" IN (5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 1001, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL) OR ("id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=5064)))
17:57:29.286traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.286traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:29.287traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.287traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:29.288infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"='518' GROUP BY "cd"."id" ORDER BY "created_at" DESC) "c"
17:57:29.290infoyii\db\Command::querySELECT cd.* FROM "a57be577deb434"."tbl_client_documents" "cd" WHERE "client_id"='518' GROUP BY "cd"."id" ORDER BY "created_at" DESC LIMIT 10
17:57:29.294infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 1015, 5085)
17:57:29.295infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1015, 5085))
17:57:29.298infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id" IN (27322, 25462, 25461, 21290, 21276, 17091, 17090, 14271, 14270, 14049)
17:57:29.306infoyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=104) AND ("object_id" IN (989, 843, 842, 631, 630, 479, 478, 335, 334, 318)) GROUP BY "object_id"
17:57:29.334infoyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=104) AND (remind_user_id = 5064 AND is_read = false) AND ("object_id" IN (989, 843, 842, 631, 630, 479, 478, 335, 334, 318)) GROUP BY "object_id"
17:57:29.360infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=518
17:57:29.361infoyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3935, 3642, 3179, 3258)
17:57:29.362infoyii\db\Command::querySELECT "id", "id" AS "key", "case_no" AS "name" FROM "a57be577deb434"."tbl_cases" WHERE "id" IN (8398, 7759, 7752, 6449, 6361)
17:57:29.365traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
17:57:29.368traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
17:57:29.369infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5064, 2, 1153, 'v2/client/list-document', '{"access_token":"-seQeMPzRsLPhLztxjKAhwxnoPp3CRVG","device_type":"2","id":"518","page":"1","posttime":"1765965440","token":"44edb6bdb5469000372afbc0bef8f0a8","version_code":"1153"}', '{"code":200,"data":{"list":[{"id":989,"attachment_id":27322,"client_id":518,"title":"\u7b7e\u6536\u535520250807","description":"","created_by":1011,"created_at":"2025-08-07 16:40:59","updated_at":"2025-08-07 16:40:59","project_id":3935,"case_id":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachment":{"id":27322,"key":27322,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/08\/c0b9f438-8f68-3628-b308-37e4bf3c85d6.docx","extension":"docx","orig_name":"\u8d27\u7269\u7b7e\u6536\u5355\uff0d\u56fd\u79d1\u73af\u5b87.docx"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3935,"key":3935,"name":"\u65b0\u8d2d\u9632\u706b\u5899SSL VPN\u6388\u6743"},"case":null,"unread":0},{"id":843,"attachment_id":25462,"client_id":518,"title":"\u5fae\u4fe1\u56fe\u7247_20250509181404.jpg","description":"","created_by":1015,"created_at":"2025-05-09 18:14:45","updated_at":"2025-05-09 18:14:45","project_id":3642,"case_id":8398,"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachment":{"id":25462,"key":25462,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/05\/dce4fe4b-7948-3fd0-b608-eb656baa3984.jpg","extension":"jpg","orig_name":"\u5fae\u4fe1\u56fe\u7247_20250509181404.jpg"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d"},"case":{"id":8398,"key":8398,"name":"IM250509005"},"unread":0},{"id":842,"attachment_id":25461,"client_id":518,"title":"\u56fd\u79d1\u73af\u5b87.png","description":"","created_by":1015,"created_at":"2025-05-09 18:14:45","updated_at":"2025-05-09 18:14:45","project_id":3642,"case_id":8398,"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachment":{"id":25461,"key":25461,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/05\/2a70af96-04d1-3d5a-801f-b134449f2586.png","extension":"png","orig_name":"\u56fd\u79d1\u73af\u5b87.png"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d"},"case":{"id":8398,"key":8398,"name":"IM250509005"},"unread":0},{"id":631,"attachment_id":21290,"client_id":518,"title":"Fastone_IP.xlsx","description":"","created_by":1015,"created_at":"2024-09-05 18:16:56","updated_at":"2024-09-05 18:16:56","project_id":3642,"case_id":7759,"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachment":{"id":21290,"key":21290,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/b2ad8541-0711-36e2-9546-03d78147e36b.xlsx","extension":"xlsx","orig_name":"Fastone_IP.xlsx"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d"},"case":{"id":7759,"key":7759,"name":"IM240905005"},"unread":0},{"id":630,"attachment_id":21276,"client_id":518,"title":"\u56fd\u79d1\u73af\u5b87.png","description":"","created_by":1015,"created_at":"2024-09-04 18:04:24","updated_at":"2024-09-04 18:04:24","project_id":3642,"case_id":7752,"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachment":{"id":21276,"key":21276,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/09\/5405a300-c8b2-378e-b5f4-0d110e4b5cdb.png","extension":"png","orig_name":"\u56fd\u79d1\u73af\u5b87.png"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3642,"key":3642,"name":"\u901f\u77f3\u9ad8\u6027\u80fd\u5e73\u53f0+\u5b58\u50a8\u65b0\u8d2d"},"case":{"id":7752,"key":7752,"name":"IM240903005"},"unread":0},{"id":479,"attachment_id":17091,"client_id":518,"title":"USG6555F\u539f\u53823\u5e74\u670d\u52a1\u62a5\u4ef7\u5355","description":"","created_by":1011,"created_at":"2024-01-10 09:44:19","updated_at":"2024-01-10 09:44:19","project_id":null,"case_id":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachment":{"id":17091,"key":17091,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/01\/a146cdd0-61f1-398e-9019-9b1d6f482a36.xlsx","extension":"xlsx","orig_name":"USG6555F\u62a5\u4ef7\u5355202312060006_\u5ba2\u6237\u5316\u62a5\u4ef7\u4e66_\u5185\u90e8\u4ef7\u683c.xlsx"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":null,"case":null,"unread":0},{"id":478,"attachment_id":17090,"client_id":518,"title":"USG6555F\u62a5\u4ef7\u5355-\u6210\u672c","description":"","created_by":1011,"created_at":"2024-01-10 09:43:28","updated_at":"2024-01-10 09:43:28","project_id":null,"case_id":null,"createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachment":{"id":17090,"key":17090,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2024\/01\/a57a0355-e7b2-30f6-866a-87c996f3b96a.xlsx","extension":"xlsx","orig_name":"\u534e\u4e3a\u9632\u706b\u5899\u62a5\u4ef7\u535520240110.xlsx"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":null,"case":null,"unread":0},{"id":335,"attachment_id":14271,"client_id":518,"title":"\u56fd\u79d1\u73af\u5b87\u4e91\u684c\u9762\u6269\u5bb9\u9a8c\u6536.pdf","description":"","created_by":5085,"created_at":"2023-08-08 16:34:28","updated_at":"2023-08-08 16:34:28","project_id":3179,"case_id":6449,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},"attachment":{"id":14271,"key":14271,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2023\/08\/313ca71e-5db1-3af3-9af9-7ca1f56f4d68.pdf","extension":"pdf","orig_name":"\u56fd\u79d1\u73af\u5b87\u4e91\u684c\u9762\u6269\u5bb9\u9a8c\u6536.pdf"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3179,"key":3179,"name":"\u6df1\u4fe1\u670d\u684c\u9762\u4e91\u91c7\u8d2d\u4e8c\u671f-K"},"case":{"id":6449,"key":6449,"name":"IM230808004"},"unread":0},{"id":334,"attachment_id":14270,"client_id":518,"title":"\u56fd\u79d1\u73af\u5b87\u684c\u9762\u4e91\u6269\u5bb9\u5b9e\u65bd\u65b9\u6848.pdf","description":"","created_by":5085,"created_at":"2023-08-08 16:34:28","updated_at":"2023-08-08 16:34:28","project_id":3179,"case_id":6449,"createdBy":{"id":5085,"key":5085,"name":"\u970d\u4e1c\u9633","sex":"M","avatar":{"id":51,"user_id":5085,"name":"\/files\/cdn\/a57be577deb434\/avatar\/7423f9b0-25ce-3351-871b-15d81c0dcf0f.jpg"}},"attachment":{"id":14270,"key":14270,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2023\/08\/9924056e-0d96-33b5-82d4-b97a49ace205.pdf","extension":"pdf","orig_name":"\u56fd\u79d1\u73af\u5b87\u684c\u9762\u4e91\u6269\u5bb9\u5b9e\u65bd\u65b9\u6848.pdf"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3179,"key":3179,"name":"\u6df1\u4fe1\u670d\u684c\u9762\u4e91\u91c7\u8d2d\u4e8c\u671f-K"},"case":{"id":6449,"key":6449,"name":"IM230808004"},"unread":0},{"id":318,"attachment_id":14049,"client_id":518,"title":"ZStack\u79c1\u6709\u4e91\u4ea4\u4ed8\u9a8c\u6536\u62a5\u544a.docx","description":"","created_by":1015,"created_at":"2023-07-21 20:57:05","updated_at":"2023-07-21 20:57:05","project_id":3258,"case_id":6361,"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","avatar":{"id":12,"user_id":1015,"name":"\/files\/cdn\/a57be577deb434\/avatar\/d69b398a-5951-36e9-a92e-992fe938db26.jpg"}},"attachment":{"id":14049,"key":14049,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2023\/07\/3392e81e-64cc-3396-9d39-b8b9ad2bcfe3.docx","extension":"docx","orig_name":"ZStack\u79c1\u6709\u4e91\u4ea4\u4ed8\u9a8c\u6536\u62a5\u544a.docx"},"commentCount":null,"unreadComments":null,"client":{"id":518,"key":518,"name":"\u5317\u4eac\u56fd\u79d1\u73af\u5b87\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8\uff08EDA)\/\u53a6\u95e8\u6cc9\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"project":{"id":3258,"key":3258,"name":"\u65b0\u8d2d\u66d9\u5149\u670d\u52a1\u5668-K"},"case":{"id":6361,"key":6361,"name":"IM230721008"},"unread":0}],"pagenation":{"totalcount":23,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"221.216.117.150","ua":"jinchangxiao\/2.3.151 (iPhone 12; iOS 18.6.2; Scale\/3.00)"}', FALSE, '2025-12-17 17:57:29') RETURNING "id"