ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6861f9aaed487: POST https://beta.jinchangxiao.com/vue/rating/list at 2025-06-30 10:42:50 am by 124.127.56.185

Database Queries

总计8条数据
TimeDurationTypeQuery
  
10:42:50.9752.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
10:42:50.9781.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
10:42:50.9821.9 msSELECTSELECT COUNT(*) FROM (SELECT r.*, CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1001 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1001 WHERE "rating_type"='2' ORDER BY ( case when open_from <= now() and close_at >= now() then 1 when open_from > now() then 2 else 3 end) ASC, "created_at" DESC) "c"

[+] Explain
10:42:50.9841.0 msSELECTSELECT r.*, CASE WHEN rvr.id IS NULL THEN false ELSE true END as can_vote, CASE WHEN rvr.completed IS NULL THEN false ELSE true END as completed FROM "a57be577deb434"."tbl_ratings" "r" LEFT JOIN "a57be577deb434"."tbl_rating_voters" "rvr" ON r.id = rvr.rating_id AND rvr.user_id =1001 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1001 WHERE "rating_type"='2' ORDER BY ( case when open_from <= now() and close_at >= now() then 1 when open_from > now() then 2 else 3 end) ASC, "created_at" DESC LIMIT 20

[+] Explain
10:42:50.9860.5 msSELECTSELECT "id", "rating_id", "user_id", "department_id", "completed" FROM "a57be577deb434"."tbl_rating_voters" WHERE ("user_id"=1001) AND ("rating_id" IN (238, 237, 236, 235, 234, 233, 232, 230, 229, 228, 227, 226, 225, 224, 223, 222, 221, 220, 219, 218))

[+] Explain
10:42:50.9873.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=28) AND ("visit_date"='2025-06-30')

[+] Explain
10:42:50.9910.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=2, "last_visit_at"='now()' WHERE "id"=49754

[+] Explain
10:42:50.9921.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/rating/list', '{"RatingSearch":{"rating_type":"2"},"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":238,"title":"\u6280\u672f\u90e8-9\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-09-29 09:00:00","close_at":"2022-09-29 13:13:56","created_by":1001,"created_at":"2022-09-20 13:58:33","updated_at":"2022-09-29 13:14:06","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3140,"rating_id":238,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":237,"title":"\u9500\u552e\u90e8-9\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-09-29 09:00:00","close_at":"2022-09-29 13:13:58","created_by":1001,"created_at":"2022-09-20 13:58:09","updated_at":"2022-09-29 13:14:08","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3152,"rating_id":237,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":236,"title":"\u7efc\u5408\u90e8-9\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-09-29 09:00:00","close_at":"2022-09-29 13:14:00","created_by":1001,"created_at":"2022-09-20 13:57:46","updated_at":"2022-09-29 13:14:10","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3166,"rating_id":236,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":235,"title":"\u6280\u672f\u90e8-8\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-08-31 09:00:00","close_at":"2022-09-01 09:17:58","created_by":1001,"created_at":"2022-08-30 09:11:31","updated_at":"2022-09-01 09:18:08","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3062,"rating_id":235,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":234,"title":"\u9500\u552e\u90e8-8\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-08-31 09:00:00","close_at":"2022-09-01 09:18:01","created_by":1001,"created_at":"2022-08-30 09:10:59","updated_at":"2022-09-01 09:18:11","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3048,"rating_id":234,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":233,"title":"\u7efc\u5408\u90e8-8\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-08-31 09:02:00","close_at":"2022-09-01 09:08:53","created_by":1001,"created_at":"2022-08-30 09:10:30","updated_at":"2022-09-01 09:09:03","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3035,"rating_id":233,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":232,"title":"\u5468\u5e74\u5e86\u53bb\u54ea\u91cc\u73a9\uff1f","open_from":"2022-08-16 17:30:00","close_at":"2022-08-17 00:00:00","created_by":5064,"created_at":"2022-08-16 17:32:32","updated_at":"2022-08-16 17:32:32","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":false,"canVote":{},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":230,"title":"\u7efc\u5408\u90e8-7\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-07-28 09:00:00","close_at":"2022-07-28 14:30:15","created_by":1001,"created_at":"2022-07-21 17:00:47","updated_at":"2022-07-28 14:30:25","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3006,"rating_id":230,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":229,"title":"\u9500\u552e\u90e8-7\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-07-28 09:00:00","close_at":"2022-07-28 14:30:17","created_by":1001,"created_at":"2022-07-21 17:00:21","updated_at":"2022-07-28 14:30:27","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":3019,"rating_id":229,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":228,"title":"\u6280\u672f\u90e8-7\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-07-28 09:00:00","close_at":"2022-07-28 12:28:32","created_by":1001,"created_at":"2022-07-21 16:59:12","updated_at":"2022-07-28 12:28:42","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2980,"rating_id":228,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":227,"title":"\u7efc\u5408\u90e8-6\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-06-30 09:00:00","close_at":"2022-06-30 14:19:19","created_by":1001,"created_at":"2022-06-22 14:09:36","updated_at":"2022-06-30 14:19:29","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2967,"rating_id":227,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":226,"title":"\u9500\u552e\u90e8-6\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-06-30 09:00:00","close_at":"2022-06-30 14:27:50","created_by":1001,"created_at":"2022-06-22 14:08:23","updated_at":"2022-06-30 14:28:00","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2953,"rating_id":226,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":225,"title":"\u6280\u672f\u90e8-6\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-06-30 09:00:00","close_at":"2022-06-30 14:27:52","created_by":1001,"created_at":"2022-06-22 14:07:17","updated_at":"2022-06-30 14:28:02","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2941,"rating_id":225,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":224,"title":"\u6280\u672f\u90e8-4\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-04-28 09:00:00","close_at":"2022-04-28 11:04:41","created_by":1001,"created_at":"2022-04-24 15:44:03","updated_at":"2022-04-28 11:04:51","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2929,"rating_id":224,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":223,"title":"\u9500\u552e\u90e8-4\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-04-28 09:00:00","close_at":"2022-04-28 11:06:23","created_by":1001,"created_at":"2022-04-24 15:40:00","updated_at":"2022-04-28 11:06:33","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2914,"rating_id":223,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":222,"title":"\u7efc\u5408\u90e8-4\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-04-28 09:00:00","close_at":"2022-04-28 11:06:18","created_by":1001,"created_at":"2022-04-24 15:39:01","updated_at":"2022-04-28 11:06:28","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2900,"rating_id":222,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":221,"title":"\u30102\u3011\u7efc\u5408\u90e8-3\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-03-31 17:58:00","close_at":"2022-03-31 18:51:17","created_by":1001,"created_at":"2022-03-31 18:01:03","updated_at":"2022-03-31 18:51:27","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2882,"rating_id":221,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":220,"title":"\u6280\u672f\u90e8-3\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-03-31 09:00:00","close_at":"2022-03-31 13:22:13","created_by":1001,"created_at":"2022-02-28 17:48:15","updated_at":"2022-03-31 13:22:23","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2870,"rating_id":220,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":219,"title":"\u9500\u552e\u90e8-3\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-03-31 09:00:00","close_at":"2022-03-31 12:34:59","created_by":1001,"created_at":"2022-02-28 17:46:45","updated_at":"2022-03-31 12:35:09","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2855,"rating_id":219,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"},{"id":218,"title":"\u7efc\u5408\u90e8-3\u6708\u4efd\u54ea\u4f4d\u540c\u4e8b\u8ba9\u4f60\u7684\u611f\u53d7\u6700\u597d\ud83c\udf39\ud83c\udf39\ud83c\udf39","open_from":"2022-03-31 09:00:00","close_at":"2022-03-31 13:22:15","created_by":1001,"created_at":"2022-02-28 17:45:06","updated_at":"2022-03-31 13:22:25","strategy_id":"","description":"","choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":2841,"rating_id":218,"user_id":1001,"department_id":"","completed":true},"strategy":"","bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u6295\u7968","rating_status_display":"\u6295\u7968\u5df2\u505c\u6b62"}],"can_setting":true,"can_create":true,"pagenation":{"totalcount":31,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-06-30 10:42:50') RETURNING "id"

[+] Explain