ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b69ac5b686: POST https://beta.jinchangxiao.com/v2/calendar/list at 2025-06-25 11:14:52 am by 211.137.80.11

Performance Profiling

Total processing time: 850 ms; Peak memory: 4.927 MB. Show Profiling Timeline

总计31条数据
TimeDurationCategoryInfo
  
11:14:53.1929.9 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"=5295) AND ((("w"."start_at" >= '2025-06-25 00:00:00') AND ("w"."end_at" < '2025-06-25 23:59:59')) OR (("w"."start_at" <= '2025-06-25 00:00:00') AND ("w"."end_at" > '2025-06-25 00:00:00')) OR (("w"."start_at" <= '2025-06-25 23:59:59') AND ("w"."end_at" > '2025-06-25 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" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ((("s"."s_at" >= '2025-06-25 00:00:00') AND ("s"."e_at" < '2025-06-25 23:59:59')) OR (("s"."s_at" <= '2025-06-25 00:00:00') AND ("s"."e_at" > '2025-06-25 00:00:00')) OR (("s"."s_at" <= '2025-06-25 23:59:59') AND ("s"."e_at" > '2025-06-25 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" != 5295)) OR ("c"."created_by"=5295)) AND ((("c"."start_at" >= '2025-06-25 00:00:00') AND ("c"."end_at" < '2025-06-25 23:59:59')) OR (("c"."start_at" <= '2025-06-25 00:00:00') AND ("c"."end_at" > '2025-06-25 00:00:00')) OR (("c"."start_at" <= '2025-06-25 23:59:59') AND ("c"."end_at" > '2025-06-25 23:59:59'))) AND ("c"."created_by"=5295) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=1) AND ("s"."created_by"=5295) AND ((("s"."start_at" >= '2025-06-25 00:00:00') AND ("s"."end_at" < '2025-06-25 23:59:59')) OR (("s"."start_at" <= '2025-06-25 00:00:00') AND ("s"."end_at" > '2025-06-25 00:00:00')) OR (("s"."start_at" <= '2025-06-25 23:59:59') AND ("s"."end_at" > '2025-06-25 23:59:59'))) ORDER BY "s"."start_at") "c"
11:14:53.2038.9 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"=5295) AND ((("w"."start_at" >= '2025-06-25 00:00:00') AND ("w"."end_at" < '2025-06-25 23:59:59')) OR (("w"."start_at" <= '2025-06-25 00:00:00') AND ("w"."end_at" > '2025-06-25 00:00:00')) OR (("w"."start_at" <= '2025-06-25 23:59:59') AND ("w"."end_at" > '2025-06-25 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" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ((("s"."s_at" >= '2025-06-25 00:00:00') AND ("s"."e_at" < '2025-06-25 23:59:59')) OR (("s"."s_at" <= '2025-06-25 00:00:00') AND ("s"."e_at" > '2025-06-25 00:00:00')) OR (("s"."s_at" <= '2025-06-25 23:59:59') AND ("s"."e_at" > '2025-06-25 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" != 5295)) OR ("c"."created_by"=5295)) AND ((("c"."start_at" >= '2025-06-25 00:00:00') AND ("c"."end_at" < '2025-06-25 23:59:59')) OR (("c"."start_at" <= '2025-06-25 00:00:00') AND ("c"."end_at" > '2025-06-25 00:00:00')) OR (("c"."start_at" <= '2025-06-25 23:59:59') AND ("c"."end_at" > '2025-06-25 23:59:59'))) AND ("c"."created_by"=5295) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=1) AND ("s"."created_by"=5295) AND ((("s"."start_at" >= '2025-06-25 00:00:00') AND ("s"."end_at" < '2025-06-25 23:59:59')) OR (("s"."start_at" <= '2025-06-25 00:00:00') AND ("s"."end_at" > '2025-06-25 00:00:00')) OR (("s"."start_at" <= '2025-06-25 23:59:59') AND ("s"."end_at" > '2025-06-25 23:59:59'))) ORDER BY "s"."start_at"
11:14:53.1246.1 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:14:53.1794.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"=5295) 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"=5295)
11:14:53.1304.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
11:14:53.1883.1 msyii\db\Command::querySELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) 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"=5295) AND ("c"."created_by"=5295) AND (c.alarm_before is not null)
11:14:53.1702.4 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" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) 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"=5295)
11:14:53.1642.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE (("user_status"='1') AND ("department_id"=1)) AND ("id"=5295) 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
11:14:53.2152.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17669)
11:14:53.1592.2 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"
11:14:53.1762.2 msyii\db\Command::querySELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5295)) OR ("c"."created_by"=5295)) 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"=5295) AND ("c"."created_by"=5295)
11:14:53.1532.0 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.2191.7 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', 5295, 2, 1141, 'v2/calendar/list', '{"CalendarSearch":{"date":"2025-06-25","is_self":"1"},"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1750821248","token":"c69c2fe0c4de1b36facc2923bf1ee357","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":17669,"title":"\u9500\u552e\u9636\u6bb5\uff1a\u786e\u8ba4\u65b9\u6848\n\u76ee\u6807\uff1a\u8ddf\u5ba2\u6237\u786e\u8ba4\u7eed\u4fdd\u548c\u65b0\u8d2d\u7684\u5177\u4f53\u9700\u6c42\uff0c\u7ed9\u5ba2\u6237\u51fa\u62a5\u4ef7","client_id":2805,"created_by":5295,"start_at":"2025-03-09 00:00:00","end_at":"2025-06-25 11:14:53","type":2,"is_alarm":false,"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","department_id":1,"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"},"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"client":{"id":2805,"key":2805,"name":"\u5317\u4eac\u65e0\u95ee\u82af\u7a79\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u4e0a\u6d77\u65e0\u95ee\u82af\u7a79\u667a\u80fd\u79d1\u6280\u6709\u9650\u516c\u53f8\uff09(EDA)","sales_rep":5295,"logo":null},"start_at_display":"","end_at_display":"11:14","can_update":false,"can_delete":false,"attachmentRelationships":[]}],"point":[{"edate":"2025-06-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-03","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-04","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-05","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-06","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-07","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-08","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-09","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-10","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-11","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-12","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-13","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-14","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-15","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-16","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-17","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-18","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-19","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-20","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"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":true,"is_work_log_used":false},{"edate":"2025-06-24","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-25","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"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":false},{"edate":"2025-06-22","is_alarm":false},{"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":1,"thispage":1,"pagesize":-1},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 11:14:53') RETURNING "id"
11:14:53.1381.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:14:53.1851.6 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" != 5295)) OR ("s"."created_by"=5295) OR ("ccr"."user_id"=5295)) AND ("s"."created_by" IN (5300, 5295, 5295)) AND ("s"."created_by"=5295) AND (s.alarm_before is not null)
11:14:53.1571.4 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.1741.3 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.1551.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:14:53.1681.2 msyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id"=1) ORDER BY "name"
11:14:53.1690.8 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.1840.8 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.1870.7 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.1780.7 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"
11:14:53.1620.7 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=5295) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
11:14:53.2140.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2805
11:14:53.2130.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
11:14:53.2130.4 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
11:14:53.1620.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:14:53.2150.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)
11:14:53.2120.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
11:14:53.2180.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)