Database Queries

总计9条数据

Time	Duration	Type	Query

10:22:56.121	3.5 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 /var/www/beta/models/Login.php:64 /var/www/beta/vendor/uranus/web/User.php:173 /var/www/beta/modules/vue/controllers/CommonController.php:106 [+] Explain
10:22:56.128	2.9 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 /var/www/beta/modules/vue/controllers/CommonController.php:122 /var/www/beta/modules/vue/controllers/ChangeLogController.php:31 [+] Explain
10:22:56.132	80.3 ms	SELECT	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='17563') AND ("object_type"='9') ORDER BY "created_at" DESC) "c" /var/www/beta/modules/vue/controllers/ChangeLogController.php:238 [+] Explain
10:22:56.213	105.1 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_object_change_logs" WHERE ("object_id"='17563') AND ("object_type"='9') ORDER BY "created_at" DESC LIMIT 20 /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
10:22:56.318	0.4 ms	SELECT	SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
10:22:56.319	1.0 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) /var/www/beta/modules/vue/controllers/ChangeLogController.php:240 [+] Explain
10:22:56.322	2.1 ms	INSERT	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/change-log/of-object', '{"object_type":"9","object_id":"17563","page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":507433,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":["\u4e0a\u5468\u5728\u822a\u7a7a\u822a\u5929\u6570\u5b57\u5316 \u5efa\u8bbe\u5408\u4f5c\u5cf0\u4f1a\u89c1\u9762\uff0c\u672c\u5468\u7ea6\u5403\u996d\u3002"],"new_value":["\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-03-16 08:40:02","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"03\u670816\u65e5 08:40"},{"id":507430,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u5728\u822a\u7a7a\u822a\u5929\u6570\u5b57\u5316 \u5efa\u8bbe\u5408\u4f5c\u5cf0\u4f1a\u89c1\u9762\uff0c\u672c\u5468\u7ea6\u5403\u996d\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-03-16 08:39:19","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"03\u670816\u65e5 08:39"},{"id":505560,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u89c1\u9762\uff0c\u672c\u5468\u65e0\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-03-09 09:10:07","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"03\u670809\u65e5 09:10"},{"id":505557,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":["\u4e0a\u5468\u4e3b\u4efb\u5fd9\uff0c\u672c\u5468\u7ea6\u89c1\u9762\uff0c\u4e86\u89e3deepseek\u79c1\u6709\u5316\u90e8\u7f72\u3002"],"new_value":["\u4e0a\u5468\u4e3b\u4efb\u5fd9\uff0c\u672c\u5468\u7ea6\u89c1\u9762\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-03-09 09:09:44","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"03\u670809\u65e5 09:09"},{"id":503520,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u4e3b\u4efb\u5fd9\uff0c\u672c\u5468\u7ea6\u89c1\u9762\uff0c\u4e86\u89e3deepseek\u79c1\u6709\u5316\u90e8\u7f72\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-03-03 00:09:01","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"03\u670803\u65e5 00:09"},{"id":501252,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u8054\u7cfb\u5218\u4e3b\u4efb\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-02-23 22:32:00","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"02\u670823\u65e5 22:32"},{"id":498998,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u8054\u7cfb\u5218\u4e3b\u4efb"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-02-16 23:15:06","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"02\u670816\u65e5 23:15"},{"id":496903,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0 \uff0c\u672c\u5468\u65e0"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-02-09 22:57:44","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"02\u670809\u65e5 22:57"},{"id":494149,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-01-19 08:45:05","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"01\u670819\u65e5 08:45"},{"id":489433,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0 \uff0c\u672c\u5468\u65e0\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2025-01-05 22:09:44","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"01\u670805\u65e5 22:09"},{"id":487093,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"schedule_title","old_value":["\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355\uff081+4\uff09"],"new_value":["\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u5f85\u529e\u4e8b\u9879\u5185\u5bb9","d4":["\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355\uff081+4\uff09 <b>\u53d8\u4e3a<\/b> \u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355"]},"created_by":5087,"created_at":"2024-12-30 09:56:53","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":false,"created_at_display":"2024\u5e7412\u670830\u65e5"},{"id":486975,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"scheduleDescriptions","old_value":[[]],"new_value":["\u4e0a\u5468\u65e0\uff0c\u672c\u5468\u65e0\u3002"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u603b\u7ed3","d4":[""]},"created_by":5087,"created_at":"2024-12-29 22:30:09","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"2024\u5e7412\u670829\u65e5"},{"id":486957,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":2,"attribute":"end_at","old_value":["2024-12-28 00:00:00"],"new_value":["2025-08-31 00:00:00"],"description":{"d1":"\u5218\u5fae","d2":"\u66f4\u65b0\u4e86","d3":"\u622a\u6b62\u65f6\u95f4","d4":["2024-12-28 00:00:00 <b>\u53d8\u4e3a<\/b> 2025-08-31 00:00:00"]},"created_by":5087,"created_at":"2024-12-29 21:43:38","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":false,"created_at_display":"2024\u5e7412\u670829\u65e5"},{"id":484437,"object_id":17563,"object_type":9,"target_id":"","target_object_type":"","act":1,"attribute":"create","old_value":{"id":17563,"client_id":2526,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355\uff081+4\uff09","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5087,"created_at":"2024-12-22 22:39:04","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-12-28 00:00:00","is_public":1,"system_calendar_id":"","creator":5087,"project_id":3743,"updated_at":"2024-12-22 22:39:04","set_top_at":""},"new_value":{"id":17563,"client_id":2526,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u6536\u6b3e\n\u52a8\u4f5c\uff1a\u8054\u7cfb\u90d1\u5b87\u6850\u7b7e\u670d\u52a1\u5355\uff081+4\uff09","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":5087,"created_at":"2024-12-22 22:39:04","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-12-28 00:00:00","is_public":1,"system_calendar_id":"","creator":5087,"project_id":3743,"updated_at":"2024-12-22 22:39:04","set_top_at":""},"description":{"d1":"\u5218\u5fae","d2":"\u521b\u5efa\u4e86","d3":"\u5f85\u529e\u4e8b\u9879","d4":[]},"created_by":5087,"created_at":"2024-12-22 22:39:04","is_delete":false,"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","avatar":{"id":62,"user_id":5087,"name":"\/files\/cdn\/a57be577deb434\/avatar\/06f75b3a-7b6c-37a8-81c0-b2934104daa7.png"}},"need_hidden":true,"created_at_display":"2024\u5e7412\u670822\u65e5"}],"pagenation":{"totalcount":14,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-24 10:22:56') RETURNING "id" /var/www/beta/modules/vue/controllers/CommonController.php:628 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ChangeLogController.php:273 [+] Explain
10:22:56.331	7.3 ms	SELECT	SELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/605.1.15 (KHTML, like Gecko) Version/18.2 Safari/605.1.15' /var/www/beta/modules/vue/controllers/CommonController.php:653 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ChangeLogController.php:273 [+] Explain
10:22:56.339	0.3 ms	UPDATE	UPDATE "global"."tbl_browser_ua_statistics" SET "counter"=1300 WHERE "id"=87 /var/www/beta/modules/vue/controllers/CommonController.php:668 /var/www/beta/modules/vue/controllers/CommonController.php:363 /var/www/beta/modules/vue/controllers/ChangeLogController.php:273 [+] Explain

[+] Explain all