ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c1432484f30: POST https://beta.jinchangxiao.com/v2/rating/list at 2025-09-10 05:21:40 pm by 114.246.239.150

Database Queries

总计5条数据
TimeDurationTypeQuery
  
17:21:40.5482.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om'

[+] Explain
17:21:40.5511.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
17:21:40.5561.8 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 =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC) "c"

[+] Explain
17:21:40.5581.1 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 =1000 LEFT JOIN "a57be577deb434"."tbl_rating_candidates" "rc" ON r.id = rc.rating_id AND rc.user_id =1000 ORDER BY "open_from" DESC, "created_at" DESC LIMIT 10 OFFSET 180

[+] Explain
17:21:40.5601.3 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 266, 'v2/rating/list', '{"access_token":"gIBfXHaGAAjf2tBIfgqsDfRNPly9E9om","device_type":"0","version_code":"266","page":"19","token":"0f73c34737d577c397544aaadb44c7d9","posttime":"1757496100"}', '{"code":200,"data":{"list":[{"id":77,"title":"2019\u5e747\u6708\u4efd \u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-08-01 08:00:00","close_at":"2019-08-01 14:47:50","created_by":1001,"created_at":"2019-07-23 10:55:06","updated_at":"2019-08-01 14:48:00","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":76,"title":"2019\u5e747\u6708\u4efd \u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-08-01 08:00:00","close_at":"2019-08-01 16:50:33","created_by":1001,"created_at":"2019-07-23 10:54:23","updated_at":"2019-08-01 16:50:43","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":75,"title":"6\u6708\u4efd\u7efc\u5408\u90e8\u4f18\u79c0\u5458\u5de5\u8bc4\u9009\u6295\u7968","open_from":"2019-07-01 16:00:00","close_at":"2019-07-01 17:21:06","created_by":1001,"created_at":"2019-07-01 16:56:46","updated_at":"2019-07-01 17:21:16","strategy_id":null,"description":null,"choice":0,"rating_type":2,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":74,"title":"2019\u5e746\u6708\u4efd \u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-07-01 00:00:00","close_at":"2019-07-01 16:53:50","created_by":1001,"created_at":"2019-06-26 11:01:08","updated_at":"2019-07-01 16:54:00","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":73,"title":"2019\u5e746\u6708\u4efd \u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-07-01 00:00:00","close_at":"2019-07-01 16:53:53","created_by":1001,"created_at":"2019-06-26 11:00:22","updated_at":"2019-07-01 16:54:03","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":72,"title":"2019\u5e746\u6708\u4efd \u9500\u552e\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-07-01 00:00:00","close_at":"2019-07-01 16:22:47","created_by":1001,"created_at":"2019-06-26 10:59:31","updated_at":"2019-07-01 16:22:57","strategy_id":10,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":71,"title":"2019\u5e745\u6708\u4efd \u9500\u552e\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-06-01 00:00:00","close_at":"2019-06-03 16:58:52","created_by":1001,"created_at":"2019-05-23 09:27:04","updated_at":"2019-06-03 16:59:02","strategy_id":10,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":70,"title":"2019\u5e745\u6708\u4efd \u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-06-01 00:00:00","close_at":"2019-06-03 16:58:53","created_by":1001,"created_at":"2019-05-23 09:25:51","updated_at":"2019-06-03 16:59:03","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":69,"title":"2019\u5e745\u6708\u4efd \u6280\u672f\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-06-01 00:00:00","close_at":"2019-06-03 16:58:56","created_by":1001,"created_at":"2019-05-23 09:24:40","updated_at":"2019-06-03 16:59:06","strategy_id":12,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false},{"id":67,"title":"2019\u5e744\u6708\u4efd \u7efc\u5408\u7ba1\u7406\u90e8\u6700\u4f18\u79c0\u5458\u5de5\u8bc4\u9009","open_from":"2019-05-01 00:00:00","close_at":"2019-05-05 13:21:04","created_by":1001,"created_at":"2019-04-25 18:21:45","updated_at":"2019-05-05 13:21:14","strategy_id":11,"description":null,"choice":null,"rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":false}],"pagenation":{"totalcount":234,"thispage":19,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-10 17:21:40') RETURNING "id"

[+] Explain