Performance Profiling

Total processing time: 315 ms; Peak memory: 5.663 MB. Show Profiling Timeline

总计33条数据
TimeDurationCategoryInfo
  
14:46:57.39155.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=9) AND ("object_id" IN (17349, 17561, 17459, 17438)) GROUP BY "object_id"
14:46:57.47336.4 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=9) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (17349, 17561, 17459, 17438)) GROUP BY "object_id"
14:46:57.4675.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_descriptions" WHERE "schedule_id" IN (17349, 17561, 17459, 17438) ORDER BY "created_at" DESC
14:46:57.4565.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_head_of_rels" WHERE "schedule_id" IN (17349, 17561, 17459, 17438)
14:46:57.4474.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id" IN (17349, 17561, 17459, 17438))
14:46:57.4633.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=32) AND ("object_id" IN (17349, 17561, 17459, 17438))
14:46:57.3812.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC) "c"
14:46:57.5222.5 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/schedule/of-client', '{"ScheduleSearch":{"department_id":"","created_by":""},"page":"1","id":"3303","web_access_token":"ukNwOz-BjUcQL9I3n8iWo2JcLwCMuHVk"}', '{"code":2000,"result":{"list":[{"id":17349,"client_id":3303,"schedule_title":"\u9500\u552e\u9636\u6bb5\uff1a\u6536\u6b3e\u4e2d\n\u76ee\u7684\uff1a\u50ac\u6b3e\n\u52a8\u4f5c\uff1a\u627e\u795e\u7801\u52a9\u7406\u67e5\u770b\u6d41\u7a0b\u3002","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":1004,"created_at":"2024-09-17 17:16:39","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-09-30 18:00:00","is_public":1,"system_calendar_id":"","creator":1004,"project_id":3655,"updated_at":"2024-09-17 17:16:39","set_top_at":"","sort":2,"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17349,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"project":{"id":3655,"key":3655,"name":"\u963f\u91cc\u4e91\u8fc1\u79fb\u670d\u52a1","project_status":3,"budget":"169600","collected":"169600","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"2024-09-30 18:00","end_at_display2":"","is_self":false,"is_overdue":true,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":""},{"id":17561,"client_id":3303,"schedule_title":"\u76ee\u7684\uff1a\u672c\u6708\u5e95\u56de\u5168\u6b3e\u3002","description":"","schedule_week":"","start_at":"","complete_at":"","complete_description":"","is_complete":false,"alarm_before":"","created_by":1004,"created_at":"2024-12-22 16:18:48","is_closed":false,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-12-31 18:00:00","is_public":1,"system_calendar_id":"","creator":1004,"project_id":3740,"updated_at":"2024-12-22 16:18:48","set_top_at":"","sort":2,"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17561,"comment":1},"attachmentRelationships":[],"scheduleCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"project":{"id":3740,"key":3740,"name":"\u516c\u6709\u4e91\u8fc1\u79fb\u670d\u52a12","project_status":3,"budget":"42400","collected":"42400","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status":2,"schedule_status_display":"\u5df2\u903e\u671f","complete_at_display":"","complete_at_display2":"","end_at_display":"2024-12-31 18:00","end_at_display2":"","is_self":false,"is_overdue":true,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#e5000a","can_create_project":true,"start_at_display":""},{"id":17459,"client_id":3303,"schedule_title":"\u5546\u673a\u9636\u6bb5\uff1a\u5546\u52a1\u62a5\u4ef7\n\u76ee\u7684\uff1a\u786e\u8ba4\u62a5\u4ef7\u53ca\u7b7e\u5408\u540c\u65f6\u95f4\n\u52a8\u4f5c\uff1a\u8ddf\u738b\u603b\u5177\u4f53\u6c9f\u901a\u3002","description":"","schedule_week":"","start_at":"","complete_at":"2024-11-10 17:02:12","complete_description":"","is_complete":true,"alarm_before":"","created_by":1004,"created_at":"2024-11-04 11:02:07","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-11-08 18:00:00","is_public":1,"system_calendar_id":"","creator":1004,"project_id":3709,"updated_at":"2024-11-04 11:02:07","set_top_at":"","sort":3,"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"createdBy":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":17459,"comment":5},"attachmentRelationships":[],"scheduleCreator":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}},"project":{"id":3709,"key":3709,"name":"\u7535\u79d1\u592a\u529b\u4fe1\u606f\u4e2d\u5fc3\u673a\u623f\u642c\u8fc1","project_status":3,"budget":"305280","collected":"305280","projectStatus":{"id":3,"key":3,"name":"\u5546\u673a\u6210\u4ea4","color":"#53cd02"},"project_status_display":"\u6536\u6b3e\u5b8c\u6210","bgcolor":"#6200fe"},"headUsers":[{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0","sex":"M","department_id":1,"avatar":{"id":10,"user_id":1004,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1004.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[{"id":10144,"schedule_id":17459,"description":"\u9884\u8ba120\u65e5\u524d\u6536\u5230\u5168\u6b3e\u3002","created_at":"2024-11-10 17:02:12","created_at_display":"2024-11-10 17:02"},{"id":10094,"schedule_id":17459,"description":"\u5ba2\u6237\u81ea\u5df1\u63d0\u4f9b\u7968\u636e","created_at":"2024-11-04 18:34:45","created_at_display":"2024-11-04 18:34"},{"id":10093,"schedule_id":17459,"description":"\u4e0a\u5468\u5408\u540c\u4ee5\u786e\u8ba4\u5e76\u7b7e\u597d\u3002\u672c\u5468\u63d0\u53d1\u7968\u7533\u8bf7\u8d70\u4ed8\u6b3e\u3002","created_at":"2024-11-04 11:02:48","created_at_display":"2024-11-04 11:02"}],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-11-10 17:02","complete_at_display2":"","end_at_display":"2024-11-08 18:00","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""},{"id":17438,"client_id":3303,"schedule_title":"\u795e\u5dde\u90a6\u90a6305280 \u5408\u540c\u5728\u6253\u5176\u4ed6\u6536\u5165\u7684\u65f6\u5019\uff0c\u4ee5\u4e0b\u56fe\u7247\u7684\u4fe1\u606f\u62530\u51fa\u5e93","description":"","schedule_week":"","start_at":"2024-10-30 10:00:00","complete_at":"2024-11-05 09:20:34","complete_description":"","is_complete":true,"alarm_before":"","created_by":5413,"created_at":"2024-10-25 17:31:29","is_closed":true,"is_remind":false,"time_type":"","schedule_end":"","repeat_id":"","end_at":"2024-10-31 16:00:00","is_public":0,"system_calendar_id":"","creator":5413,"project_id":"","updated_at":"2024-10-25 17:31:29","set_top_at":"","sort":3,"client":{"id":3303,"key":3303,"name":"\u5317\u4eac\u795e\u5dde\u90a6\u90a6\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8(\u8fc7\u5355)","sales_rep":1004,"logo":"","salesRep":{"id":1004,"key":1004,"name":"\u4f0a\u5cfb\u8fb0"}},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"},"createdBy":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","department_id":9,"avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"},"department":{"id":9,"key":9,"name":"\u9879\u76ee\u90e8"}},"commentCount":{"object_id":17438,"comment":2},"attachmentRelationships":[{"id":29604,"object_type":9,"object_id":17438,"attachment_id":22226,"attachment":{"id":22226,"key":22226,"name":"2694faee-dfd2-3e77-98a4-4eed741fe105","extension":"png","path":"\/vue\/attachment\/view\/2694faee-dfd2-3e77-98a4-4eed741fe105\/WechatIMG735.png","orig_name":"WechatIMG735.png"}}],"scheduleCreator":{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"}},"project":"","headUsers":[{"id":5413,"key":5413,"name":"\u8096\u6167\u4e3d","sex":"F","department_id":9,"avatar":{"id":159,"user_id":5413,"name":"\/files\/cdn\/a57be577deb434\/avatar\/ca02da0e-7d82-3904-be85-f050ca37c3c5.jpg"}}],"files":[],"scheduleCarbonCopyRels":[],"scheduleDescriptions":[],"unreadComments":{},"schedule_status_display":"\u5df2\u5b8c\u6210","schedule_status":1,"complete_at_display":"2024-11-05 09:20","complete_at_display2":"","end_at_display":"2024-10-31 16:00","end_at_display2":"","is_self":false,"is_overdue":false,"alarm_before_display":"\u65e0","can_update":true,"can_delete":true,"can_report":false,"unread":0,"bgcolor":"#53cd02","can_create_project":true,"start_at_display":""}],"thisUser":"","countStatus0":0,"countStatus1":2,"countStatus2":2,"countStatusTop":0,"can_create":true,"pagenation":{"totalcount":4,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:152.0) Gecko\/20100101 Firefox\/152.0"}', FALSE, '2026-07-07 14:46:57', 294699008) RETURNING "id"
14:46:57.5141.6 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) AND (set_top_at is null and is_complete = false and (end_at > now() or end_at is null)) GROUP BY "s"."id") "c"
14:46:57.5161.4 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) AND (set_top_at is null and is_complete = true) GROUP BY "s"."id") "c"
14:46:57.3841.4 msyii\db\Command::querySELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) GROUP BY "s"."id" ORDER BY set_top_at DESC nulls last, sort ASC, case when is_complete = true then complete_at END desc, case when is_complete = false then end_at END asc, s.created_at DESC LIMIT 20
14:46:57.4521.1 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5413, 1004))
14:46:57.5181.1 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) AND (set_top_at is null and is_complete = false and end_at <= now()) GROUP BY "s"."id") "c"
14:46:57.4620.9 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5413, 1004))
14:46:57.3680.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:46:57.5190.9 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT s.*, CASE WHEN is_complete = true then 3 WHEN is_complete = false and end_at <= NOW() then 2 else 1 END AS sort FROM "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON c.id = s.client_id LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (1=1) AND ("s"."client_id"=3303) AND (set_top_at is not null) GROUP BY "s"."id") "c"
14:46:57.4540.8 msyii\db\Command::querySELECT "id", "id" AS "key", "project_title" AS "name", "project_status", "budget", "collected" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3655, 3740, 3709)
14:46:57.3700.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
14:46:57.3750.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='3303') AND ("deleted"=FALSE)
14:46:57.3720.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
14:46:57.4550.5 msyii\db\Command::querySELECT "id", "id" AS "key", "project_status" AS "name", "color" FROM "a57be577deb434"."tbl_project_statuses" WHERE "id"=3
14:46:57.3670.5 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:46:57.3880.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5413)
14:46:57.4510.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=22226
14:46:57.4670.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_schedule_carbon_copy_rels" WHERE "schedule_id" IN (17349, 17561, 17459, 17438)
14:46:57.4520.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5413)
14:46:57.3870.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=3303
14:46:57.3900.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5413, 1004))
14:46:57.4610.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5413)
14:46:57.3880.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
14:46:57.3890.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1004, 5413)
14:46:57.3890.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 1)
14:46:57.3900.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (9, 1)