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

Performance Profiling

Total processing time: 112 ms; Peak memory: 4.629 MB. Show Profiling Timeline

总计12条数据
TimeDurationCategoryInfo
  
10:42:47.20613.6 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_ratings' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
10:42:47.22413.6 msyii\db\Command::querySELECT 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"='1' 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"
10:42:47.1986.9 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_ratings' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
10:42:47.1756.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:42:47.2476.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=28) AND ("visit_date"='2025-06-30')
10:42:47.2544.3 msyii\db\Command::queryINSERT INTO "a57be577deb434"."tbl_visit_module_histories" ("user_id", "object_type", "visit_date", "num", "last_visit_at") VALUES (1001, 28, '2025-06-30', 1, 'now()') RETURNING "id"
10:42:47.1814.1 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
10:42:47.1893.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
10:42:47.2593.0 msyii\db\Command::queryINSERT 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":"1"},"page":"1","web_access_token":"IB4L4uAW8bjXvE6-5qxkaUjtqmmYbCm_"}', '{"code":2000,"result":{"list":[{"id":325,"title":"2025\u5e742\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-02-28 16:41:26","created_by":1001,"created_at":"2025-02-24 11:48:42","updated_at":"2025-02-28 16:41:36","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4534,"rating_id":325,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":324,"title":"2025\u5e742\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-03-03 08:55:09","created_by":1001,"created_at":"2025-02-24 11:47:46","updated_at":"2025-03-03 08:55:19","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4523,"rating_id":324,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":323,"title":"2025\u5e742\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-02-28 08:00:00","close_at":"2025-03-03 08:55:13","created_by":1001,"created_at":"2025-02-24 11:46:48","updated_at":"2025-03-03 08:55:23","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4510,"rating_id":323,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":322,"title":"2024\u5e7412\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:13","created_by":1001,"created_at":"2024-12-18 14:40:00","updated_at":"2025-01-03 17:11:23","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4471,"rating_id":322,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":321,"title":"2024\u5e7412\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:20","created_by":1001,"created_at":"2024-12-18 14:39:17","updated_at":"2025-01-03 17:11:30","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4485,"rating_id":321,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":320,"title":"2024\u5e7412\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2025-01-02 08:00:00","close_at":"2025-01-03 17:11:22","created_by":1001,"created_at":"2024-12-18 14:38:40","updated_at":"2025-01-03 17:11:32","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4497,"rating_id":320,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":319,"title":"2024\u5e7411\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 15:53:19","created_by":1001,"created_at":"2024-11-07 09:25:55","updated_at":"2024-11-29 15:53:29","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4418,"rating_id":319,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":318,"title":"2024\u5e7411\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 16:48:09","created_by":1001,"created_at":"2024-11-07 09:25:06","updated_at":"2024-11-29 16:48:19","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4406,"rating_id":318,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":317,"title":"2024\u5e7411\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-11-29 08:00:00","close_at":"2024-11-29 16:48:13","created_by":1001,"created_at":"2024-11-07 09:24:17","updated_at":"2024-11-29 16:48:23","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4393,"rating_id":317,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":316,"title":"2024\u5e7410\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:09","created_by":1001,"created_at":"2024-10-21 17:55:04","updated_at":"2024-11-01 16:15:19","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4379,"rating_id":316,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":315,"title":"2024\u5e7410\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:11","created_by":1001,"created_at":"2024-10-21 17:54:15","updated_at":"2024-11-01 16:15:21","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4369,"rating_id":315,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":314,"title":"2024\u5e7410\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-10-31 08:00:00","close_at":"2024-11-01 16:15:13","created_by":1001,"created_at":"2024-10-21 17:53:29","updated_at":"2024-11-01 16:15:23","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4358,"rating_id":314,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":313,"title":"2024\u5e749\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-09-30 08:00:00","close_at":"2024-10-08 09:00:29","created_by":1001,"created_at":"2024-09-10 17:09:48","updated_at":"2024-10-08 09:00:39","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4344,"rating_id":313,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":312,"title":"2024\u5e749\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-09-30 08:00:00","close_at":"2024-10-08 09:00:34","created_by":1001,"created_at":"2024-09-10 17:09:08","updated_at":"2024-10-08 09:00:44","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4334,"rating_id":312,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":311,"title":"2024\u5e749\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-09-30 08:00:00","close_at":"2024-10-08 09:00:39","created_by":1001,"created_at":"2024-09-10 17:08:19","updated_at":"2024-10-08 09:00:49","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4323,"rating_id":311,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":310,"title":"2024\u5e748\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-08-30 08:00:00","close_at":"2024-08-30 15:26:40","created_by":1001,"created_at":"2024-08-21 15:00:17","updated_at":"2024-08-30 15:26:50","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4310,"rating_id":310,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":309,"title":"2024\u5e748\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-08-30 08:00:00","close_at":"2024-08-30 15:26:42","created_by":1001,"created_at":"2024-08-21 14:59:33","updated_at":"2024-08-30 15:26:52","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4301,"rating_id":309,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":308,"title":"2024\u5e748\u6708-\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-08-30 08:00:00","close_at":"2024-08-30 15:26:44","created_by":1001,"created_at":"2024-08-21 14:58:53","updated_at":"2024-08-30 15:26:54","strategy_id":50,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4290,"rating_id":308,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":50,"name":"\u7efc\u5408\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:01:42","updated_at":"2022-10-08 16:01:42"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":307,"title":"2024\u5e747\u6708-\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-08-01 08:00:00","close_at":"2024-08-01 15:56:47","created_by":1001,"created_at":"2024-07-29 10:28:42","updated_at":"2024-08-01 15:56:57","strategy_id":52,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4277,"rating_id":307,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":52,"name":"\u9500\u552e\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:04:26","updated_at":"2022-10-08 16:04:26"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"},{"id":306,"title":"2024\u5e747\u6708-\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b","open_from":"2024-08-01 08:00:00","close_at":"2024-08-01 16:09:43","created_by":1001,"created_at":"2024-07-29 10:27:57","updated_at":"2024-08-01 16:09:53","strategy_id":51,"description":"","choice":"","rating_type":1,"is_notice":true,"is_public":false,"can_vote":false,"completed":true,"canVote":{"id":4267,"rating_id":306,"user_id":1001,"department_id":"","completed":true},"strategy":{"id":51,"name":"\u6280\u672f\u90e8\u5458\u5de5\u6708\u5ea6\u8bc4\u6d4b\ud83d\udc4d\ud83d\udc4d\ud83d\udc4d\uff01\uff01\uff01","description":"2022\u5e7410\u6708","created_by":1001,"created_at":"2022-10-08 16:03:22","updated_at":"2022-10-08 16:03:22"},"bgcolor":"#EB7567","isOpen":false,"isFinished":true,"can_update":true,"can_delete":true,"can_progress":false,"can_stop":false,"can_result":true,"rating_type_display":"\u8bc4\u6d4b","rating_status_display":"\u8bc4\u6d4b\u5df2\u505c\u6b62"}],"can_setting":true,"can_create":true,"pagenation":{"totalcount":185,"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:47') RETURNING "id"
10:42:47.2392.1 msyii\db\Command::querySELECT 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"='1' 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
10:42:47.2431.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_rating_strategies" WHERE "id" IN (52, 51, 50)
10:42:47.2420.8 msyii\db\Command::querySELECT "id", "rating_id", "user_id", "department_id", "completed" FROM "a57be577deb434"."tbl_rating_voters" WHERE ("user_id"=1001) AND ("rating_id" IN (325, 324, 323, 322, 321, 320, 319, 318, 317, 316, 315, 314, 313, 312, 311, 310, 309, 308, 307, 306))