ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b58ffb0737: POST https://beta.jinchangxiao.com/v2/calendar/list at 2025-06-25 10:03:43 am by 211.137.80.11

Performance Profiling

Total processing time: 44 ms; Peak memory: 4.906 MB. Show Profiling Timeline

总计32条数据
TimeDurationCategoryInfo
  
10:03:43.7504.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "s".* FROM ((SELECT w.id, wlso.name AS title, w.client_id, w.created_by, start_at, end_at, 3 AS type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((("w"."start_at" >= '2025-06-22 00:00:00') AND ("w"."end_at" < '2025-06-22 23:59:59')) OR (("w"."start_at" <= '2025-06-22 00:00:00') AND ("w"."end_at" > '2025-06-22 00:00:00')) OR (("w"."start_at" <= '2025-06-22 23:59:59') AND ("w"."end_at" > '2025-06-22 23:59:59')))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((("s"."s_at" >= '2025-06-22 00:00:00') AND ("s"."e_at" < '2025-06-22 23:59:59')) OR (("s"."s_at" <= '2025-06-22 00:00:00') AND ("s"."e_at" > '2025-06-22 00:00:00')) OR (("s"."s_at" <= '2025-06-22 23:59:59') AND ("s"."e_at" > '2025-06-22 23:59:59')))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 AS type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 1000)) OR ("c"."created_by"=1000)) AND ((("c"."start_at" >= '2025-06-22 00:00:00') AND ("c"."end_at" < '2025-06-22 23:59:59')) OR (("c"."start_at" <= '2025-06-22 00:00:00') AND ("c"."end_at" > '2025-06-22 00:00:00')) OR (("c"."start_at" <= '2025-06-22 23:59:59') AND ("c"."end_at" > '2025-06-22 23:59:59'))) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=10) AND ("s"."created_by"=1000) AND ((("s"."start_at" >= '2025-06-22 00:00:00') AND ("s"."end_at" < '2025-06-22 23:59:59')) OR (("s"."start_at" <= '2025-06-22 00:00:00') AND ("s"."end_at" > '2025-06-22 00:00:00')) OR (("s"."start_at" <= '2025-06-22 23:59:59') AND ("s"."end_at" > '2025-06-22 23:59:59'))) ORDER BY "s"."start_at") "c"
10:03:43.7553.2 msyii\db\Command::querySELECT "s".* FROM ((SELECT w.id, wlso.name AS title, w.client_id, w.created_by, start_at, end_at, 3 AS type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((("w"."start_at" >= '2025-06-22 00:00:00') AND ("w"."end_at" < '2025-06-22 23:59:59')) OR (("w"."start_at" <= '2025-06-22 00:00:00') AND ("w"."end_at" > '2025-06-22 00:00:00')) OR (("w"."start_at" <= '2025-06-22 23:59:59') AND ("w"."end_at" > '2025-06-22 23:59:59')))) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((("s"."s_at" >= '2025-06-22 00:00:00') AND ("s"."e_at" < '2025-06-22 23:59:59')) OR (("s"."s_at" <= '2025-06-22 00:00:00') AND ("s"."e_at" > '2025-06-22 00:00:00')) OR (("s"."s_at" <= '2025-06-22 23:59:59') AND ("s"."e_at" > '2025-06-22 23:59:59')))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 AS type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 1000)) OR ("c"."created_by"=1000)) AND ((("c"."start_at" >= '2025-06-22 00:00:00') AND ("c"."end_at" < '2025-06-22 23:59:59')) OR (("c"."start_at" <= '2025-06-22 00:00:00') AND ("c"."end_at" > '2025-06-22 00:00:00')) OR (("c"."start_at" <= '2025-06-22 23:59:59') AND ("c"."end_at" > '2025-06-22 23:59:59'))) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=10) AND ("s"."created_by"=1000) AND ((("s"."start_at" >= '2025-06-22 00:00:00') AND ("s"."end_at" < '2025-06-22 23:59:59')) OR (("s"."start_at" <= '2025-06-22 00:00:00') AND ("s"."end_at" > '2025-06-22 00:00:00')) OR (("s"."start_at" <= '2025-06-22 23:59:59') AND ("s"."end_at" > '2025-06-22 23:59:59'))) ORDER BY "s"."start_at"
10:03:43.7262.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
10:03:43.7422.3 msyii\db\Command::querySELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 1000)) OR ("c"."created_by"=1000)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-06-01 00:00:00') AND ("c"."end_at" < '2025-06-30 00:00:00')) OR (("c"."start_at" <= '2025-06-01 00:00:00') AND ("c"."end_at" > '2025-06-01 00:00:00')) OR (("c"."start_at" <= '2025-06-30 00:00:00') AND ("c"."end_at" > '2025-06-30 00:00:00'))) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ("c"."created_by"=1000)
10:03:43.7241.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:03:43.7481.8 msyii\db\Command::querySELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 1000)) OR ("c"."created_by"=1000)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-06-01 00:00:00') AND ("c"."end_at" < '2025-06-30 00:00:00')) OR (("c"."start_at" <= '2025-06-01 00:00:00') AND ("c"."end_at" > '2025-06-01 00:00:00')) OR (("c"."start_at" <= '2025-06-30 00:00:00') AND ("c"."end_at" > '2025-06-30 00:00:00'))) AND ("c"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ("c"."created_by"=1000) AND (c.alarm_before is not null)
10:03:43.7391.5 msyii\db\Command::querySELECT s.id, s_at as start_at, e_at as end_at FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((("s"."s_at" >= '2025-06-01 00:00:00') AND ("s"."e_at" < '2025-06-30 00:00:00')) OR (("s"."s_at" <= '2025-06-01 00:00:00') AND ("s"."e_at" > '2025-06-01 00:00:00')) OR (("s"."s_at" <= '2025-06-30 00:00:00') AND ("s"."e_at" > '2025-06-30 00:00:00'))) AND ("s"."created_by"=1000)
10:03:43.7631.3 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 2, 1141, 'v2/calendar/list', '{"CalendarSearch":{"date":"2025-06-22","is_self":"1"},"access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"2","posttime":"1750817024","token":"08700b12a9b0e30af462a16ae2d83ca9","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":17698,"title":"\u624d\u80fd\u5065\u5eb7","client_id":2815,"created_by":1000,"start_at":"2025-06-21 19:32:00","end_at":"2025-06-22 18:00:00","type":2,"is_alarm":true,"createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"},"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e1ebc7f0-3c0e-38f8-a847-b9169d50c361.jpg"}},"client":{"id":2815,"key":2815,"name":"\u4e2d\u56fd\u9ec4\u91d1","sales_rep":1004,"logo":null},"start_at_display":"","end_at_display":"18:00","can_update":false,"can_delete":false,"attachmentRelationships":[{"id":33138,"object_type":9,"object_id":17698,"attachment_id":24762,"attachment":{"id":24762,"key":24762,"name":"e75e4188-f8ee-32f1-a052-0c19adfa9de6","extension":"png","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/06\/"}}]}],"point":[{"edate":"2025-06-01","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-10","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-12","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-21","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-22","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":true},{"edate":"2025-06-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-06-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[{"edate":"2025-06-01","is_alarm":false},{"edate":"2025-06-02","is_alarm":false},{"edate":"2025-06-03","is_alarm":false},{"edate":"2025-06-04","is_alarm":false},{"edate":"2025-06-05","is_alarm":false},{"edate":"2025-06-06","is_alarm":false},{"edate":"2025-06-07","is_alarm":false},{"edate":"2025-06-08","is_alarm":false},{"edate":"2025-06-09","is_alarm":false},{"edate":"2025-06-10","is_alarm":false},{"edate":"2025-06-11","is_alarm":false},{"edate":"2025-06-12","is_alarm":false},{"edate":"2025-06-13","is_alarm":false},{"edate":"2025-06-14","is_alarm":false},{"edate":"2025-06-15","is_alarm":false},{"edate":"2025-06-16","is_alarm":false},{"edate":"2025-06-17","is_alarm":false},{"edate":"2025-06-18","is_alarm":false},{"edate":"2025-06-19","is_alarm":false},{"edate":"2025-06-20","is_alarm":false},{"edate":"2025-06-21","is_alarm":true},{"edate":"2025-06-22","is_alarm":true},{"edate":"2025-06-23","is_alarm":false},{"edate":"2025-06-24","is_alarm":false},{"edate":"2025-06-25","is_alarm":false},{"edate":"2025-06-26","is_alarm":false},{"edate":"2025-06-27","is_alarm":false},{"edate":"2025-06-28","is_alarm":false},{"edate":"2025-06-29","is_alarm":false},{"edate":"2025-06-30","is_alarm":false}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":-1},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 10:03:43') RETURNING "id"
10:03:43.7611.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17698)
10:03:43.7301.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:03:43.7460.8 msyii\db\Command::querySELECT s.id, s_at as start_at, e_at as end_at FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE (start_at is not null) OR (end_at is not null)) "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE ((("s"."is_public"=1) AND ("s"."created_by" != 1000)) OR ("s"."created_by"=1000) OR ("ccr"."user_id"=1000)) AND ("s"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ("s"."created_by"=1000) AND (s.alarm_before is not null)
10:03:43.7440.8 msyii\db\Command::querySELECT w.id, start_at, end_at FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ("w"."is_draft"=FALSE) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) AND ((w.start_at is not null) OR (w.end_at is not null)) AND ((("w"."start_at" >= '2025-06-01 00:00:00') AND ("w"."end_at" < '2025-06-30 00:00:00')) OR (("w"."start_at" <= '2025-06-01 00:00:00') AND ("w"."end_at" > '2025-06-01 00:00:00')) OR (("w"."start_at" <= '2025-06-30 00:00:00') AND ("w"."end_at" > '2025-06-30 00:00:00'))) AND ("w"."created_by"=1000)
10:03:43.7340.7 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7370.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE (("user_status"='1') AND ("department_id"=10)) AND ("id" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445, 5446)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
10:03:43.7600.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815
10:03:43.7370.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:03:43.7620.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24762
10:03:43.7350.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:03:43.7590.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
10:03:43.7460.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7590.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=10
10:03:43.7360.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7380.3 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id"=10) ORDER BY "name"
10:03:43.7410.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7470.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7360.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7390.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)
10:03:43.7440.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7370.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
10:03:43.7580.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
10:03:43.7630.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)