Database Queries

总计11条数据

Time	Duration	Type	Query

17:38:33.018	2.2 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 /var/www/beta/models/Login.php:65 /var/www/beta/vendor/uranus/web/User.php:201 /var/www/beta/modules/vue/controllers/CommonController.php:213 [+] Explain
17:38:33.021	0.6 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 /var/www/beta/models/Login.php:65 /var/www/beta/modules/vue/controllers/CommonController.php:214 /var/www/beta/modules/vue/controllers/CommonController.php:101 [+] Explain
17:38:33.022	1.4 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 /var/www/beta/modules/vue/controllers/CommonController.php:118 /var/www/beta/modules/vue/controllers/CommentController.php:101 [+] Explain
17:38:33.024	22.9 ms	SELECT	SELECT COUNT(*) FROM "a57be577deb434"."tbl_comments" WHERE object_type = '101' AND object_id = '1600' /var/www/beta/modules/vue/controllers/CommentController.php:246 [+] Explain
17:38:33.047	19.5 ms	SELECT	SELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE object_type = '101' AND object_id = '1600' AND remind_user_id = 1001 /var/www/beta/modules/vue/controllers/CommentController.php:256 [+] Explain
17:38:33.067	17.7 ms	UPDATE	UPDATE "a57be577deb434"."tbl_unread_comments" SET "is_read"=TRUE WHERE ("object_type"='101') AND ("object_id"='1600') AND ("remind_user_id"=1001) /var/www/beta/modules/vue/controllers/CommentController.php:258 [+] Explain
17:38:33.085	21.8 ms	SELECT	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='101') AND ("object_id"='1600') ORDER BY "created_at" DESC) "c" /var/www/beta/modules/vue/controllers/CommentController.php:297 [+] Explain
17:38:33.107	22.1 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_comments" WHERE ("parent" IS NULL) AND ("object_type"='101') AND ("object_id"='1600') ORDER BY "created_at" DESC LIMIT 20 /var/www/beta/modules/vue/controllers/CommentController.php:299 [+] Explain
17:38:33.130	20.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_comments" WHERE "parent" IN (202051, 202044, 202040, 202037, 202034, 202030, 202026, 202022, 202018, 202014, 202010) ORDER BY "created_at" /var/www/beta/modules/vue/controllers/CommentController.php:299 [+] Explain
17:38:33.151	2.4 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=310) AND ("object_id" IN (202051, 202044, 202040, 202037, 202034, 202030, 202026, 202022, 202018, 202014, 202010)) /var/www/beta/modules/vue/controllers/CommentController.php:299 [+] Explain
17:38:33.155	1.4 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/comment/list', '{"object_type":"101","object_id":"1600","page":"1","web_access_token":"yb8YvQDqCxvGUQWSJnYL2S9XtkD7pVRr"}', '{"code":2000,"result":{"list":[{"id":202051,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 17:01:26","reply_to":"","is_system":true,"for_user":"","description2":"\u6e05\u535517\u53f7\u5f53\u5929\u903e\u671f\u63d0\u9192","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202044,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 16:06:47","reply_to":"","is_system":true,"for_user":"","description2":"\u6e05\u535517\u53f7\u5f53\u5929\u903e\u671f\u63d0\u9192","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202040,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 16:02:06","reply_to":"","is_system":true,"for_user":"","description2":"\u6e05\u535517\u53f7\u5f53\u5929\u903e\u671f\u63d0\u9192","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202037,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 16:01:17","reply_to":"","is_system":true,"for_user":"","description2":"\u6e05\u535517\u53f7\u5f53\u5929\u903e\u671f\u63d0\u9192","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202034,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:53:07","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202030,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:52:29","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202026,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:51:39","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202022,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:41:10","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202018,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:40:46","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202014,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u4efb\u52a1\u5c06\u8981\u903e\u671f","created_by":"","created_at":"2025-12-17 15:23:39","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false},{"id":202010,"object_id":1600,"object_type":"101","parent":{},"description":"\u60a8\u6709\u4e00\u4e2a\u9879\u76ee\u5c06\u8981\u903e\u671f:\u4efb\u52a1\u5185\u5bb9\u9879\u76ee","created_by":"","created_at":"2025-12-17 15:16:46","reply_to":"","is_system":true,"for_user":"","description2":"\u9879\u76ee","comments":[],"attachmentRelationships":[],"createdBy":{"id":"","key":"","name":"\u7cfb\u7edf","sex":"M","userMetas":[{"user_id":"","avatar":"\/files\/cdn\/a57be577deb434\/2021\/01\/51931101-63c0-36db-8e97-e68282eef06c.png"}]},"can_delete":false}],"unread":11,"count":11,"pagenation":{"totalcount":11,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"59.108.56.210","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit\/605.1.15 (KHTML, like Gecko) Version\/18.5 Safari\/605.1.15"}', FALSE, '2025-12-18 17:38:33') RETURNING "id" /var/www/beta/modules/vue/controllers/CommonController.php:668 /var/www/beta/modules/vue/controllers/CommonController.php:352 /var/www/beta/modules/vue/controllers/CommentController.php:360 [+] Explain

[+] Explain all