Total processing time: 44 ms; Peak memory: 5.011 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
08:58:40.088 | 3.4 ms | yii\db\Command::query | SELECT 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"=5446) AND ((("w"."start_at" >= '2025-09-09 00:00:00') AND ("w"."end_at" < '2025-09-09 23:59:59')) OR (("w"."start_at" <= '2025-09-09 00:00:00') AND ("w"."end_at" > '2025-09-09 00:00:00')) OR (("w"."start_at" <= '2025-09-09 23:59:59') AND ("w"."end_at" > '2025-09-09 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" != 5446)) OR ("s"."created_by"=5446) OR ("ccr"."user_id"=5446)) AND ("s"."created_by"=5446) AND ((("s"."s_at" >= '2025-09-09 00:00:00') AND ("s"."e_at" < '2025-09-09 23:59:59')) OR (("s"."s_at" <= '2025-09-09 00:00:00') AND ("s"."e_at" > '2025-09-09 00:00:00')) OR (("s"."s_at" <= '2025-09-09 23:59:59') AND ("s"."e_at" > '2025-09-09 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" != 5446)) OR ("c"."created_by"=5446)) AND ((("c"."start_at" >= '2025-09-09 00:00:00') AND ("c"."end_at" < '2025-09-09 23:59:59')) OR (("c"."start_at" <= '2025-09-09 00:00:00') AND ("c"."end_at" > '2025-09-09 00:00:00')) OR (("c"."start_at" <= '2025-09-09 23:59:59') AND ("c"."end_at" > '2025-09-09 23:59:59'))) AND ("c"."created_by"=5446) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=8) AND ("s"."created_by"=5446) AND ((("s"."start_at" >= '2025-09-09 00:00:00') AND ("s"."end_at" < '2025-09-09 23:59:59')) OR (("s"."start_at" <= '2025-09-09 00:00:00') AND ("s"."end_at" > '2025-09-09 00:00:00')) OR (("s"."start_at" <= '2025-09-09 23:59:59') AND ("s"."end_at" > '2025-09-09 23:59:59'))) ORDER BY "s"."start_at") "c" |
08:58:40.092 | 2.8 ms | yii\db\Command::query | 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"=5446) AND ((("w"."start_at" >= '2025-09-09 00:00:00') AND ("w"."end_at" < '2025-09-09 23:59:59')) OR (("w"."start_at" <= '2025-09-09 00:00:00') AND ("w"."end_at" > '2025-09-09 00:00:00')) OR (("w"."start_at" <= '2025-09-09 23:59:59') AND ("w"."end_at" > '2025-09-09 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" != 5446)) OR ("s"."created_by"=5446) OR ("ccr"."user_id"=5446)) AND ("s"."created_by"=5446) AND ((("s"."s_at" >= '2025-09-09 00:00:00') AND ("s"."e_at" < '2025-09-09 23:59:59')) OR (("s"."s_at" <= '2025-09-09 00:00:00') AND ("s"."e_at" > '2025-09-09 00:00:00')) OR (("s"."s_at" <= '2025-09-09 23:59:59') AND ("s"."e_at" > '2025-09-09 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" != 5446)) OR ("c"."created_by"=5446)) AND ((("c"."start_at" >= '2025-09-09 00:00:00') AND ("c"."end_at" < '2025-09-09 23:59:59')) OR (("c"."start_at" <= '2025-09-09 00:00:00') AND ("c"."end_at" > '2025-09-09 00:00:00')) OR (("c"."start_at" <= '2025-09-09 23:59:59') AND ("c"."end_at" > '2025-09-09 23:59:59'))) AND ("c"."created_by"=5446) ) )) "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.created_by WHERE ("u"."department_id"=8) AND ("s"."created_by"=5446) AND ((("s"."start_at" >= '2025-09-09 00:00:00') AND ("s"."end_at" < '2025-09-09 23:59:59')) OR (("s"."start_at" <= '2025-09-09 00:00:00') AND ("s"."end_at" > '2025-09-09 00:00:00')) OR (("s"."start_at" <= '2025-09-09 23:59:59') AND ("s"."end_at" > '2025-09-09 23:59:59'))) ORDER BY "s"."start_at" |
08:58:40.073 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE (("user_status"='1') AND ("department_id"=8)) AND ("id"=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 |
08:58:40.059 | 2.6 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='uBgZ6_aS7N-FGUgxP5oGgAIB87vDODPX' |
08:58:40.080 | 2.0 ms | yii\db\Command::query | SELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5446)) OR ("c"."created_by"=5446)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-09-01 00:00:00') AND ("c"."end_at" < '2025-09-30 00:00:00')) OR (("c"."start_at" <= '2025-09-01 00:00:00') AND ("c"."end_at" > '2025-09-01 00:00:00')) OR (("c"."start_at" <= '2025-09-30 00:00:00') AND ("c"."end_at" > '2025-09-30 00:00:00'))) AND ("c"."created_by"=5446) AND ("c"."created_by"=5446) |
08:58:40.057 | 1.8 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
08:58:40.086 | 1.7 ms | yii\db\Command::query | SELECT c.id,start_at, end_at FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."is_public"=1) AND ("c"."created_by" != 5446)) OR ("c"."created_by"=5446)) AND ((c.start_at is not null) OR (c.end_at is not null)) AND ((("c"."start_at" >= '2025-09-01 00:00:00') AND ("c"."end_at" < '2025-09-30 00:00:00')) OR (("c"."start_at" <= '2025-09-01 00:00:00') AND ("c"."end_at" > '2025-09-01 00:00:00')) OR (("c"."start_at" <= '2025-09-30 00:00:00') AND ("c"."end_at" > '2025-09-30 00:00:00'))) AND ("c"."created_by"=5446) AND ("c"."created_by"=5446) AND (c.alarm_before is not null) |
08:58:40.062 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 |
08:58:40.076 | 1.3 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("user_status"='1') AND ("department_id"=8) ORDER BY "name" |
08:58:40.078 | 1.3 ms | yii\db\Command::query | SELECT 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" != 5446)) OR ("s"."created_by"=5446) OR ("ccr"."user_id"=5446)) AND ("s"."created_by"=5446) AND ((("s"."s_at" >= '2025-09-01 00:00:00') AND ("s"."e_at" < '2025-09-30 00:00:00')) OR (("s"."s_at" <= '2025-09-01 00:00:00') AND ("s"."e_at" > '2025-09-01 00:00:00')) OR (("s"."s_at" <= '2025-09-30 00:00:00') AND ("s"."e_at" > '2025-09-30 00:00:00'))) AND ("s"."created_by"=5446) |
08:58:40.096 | 1.2 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5446, 2, 1149, 'v2/calendar/list', '{"CalendarSearch":{"date":"2025-09-09","is_self":"1"},"access_token":"uBgZ6_aS7N-FGUgxP5oGgAIB87vDODPX","device_type":"2","posttime":"1757379584","token":"114344850ffa572d0497d08ca795f486","version_code":"1149"}', '{"code":200,"data":{"list":[],"point":[{"edate":"2025-09-01","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-10","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-12","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-09-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[{"edate":"2025-09-01","is_alarm":false},{"edate":"2025-09-02","is_alarm":false},{"edate":"2025-09-03","is_alarm":false},{"edate":"2025-09-04","is_alarm":false},{"edate":"2025-09-05","is_alarm":false},{"edate":"2025-09-06","is_alarm":false},{"edate":"2025-09-07","is_alarm":false},{"edate":"2025-09-08","is_alarm":false},{"edate":"2025-09-09","is_alarm":false},{"edate":"2025-09-10","is_alarm":false},{"edate":"2025-09-11","is_alarm":false},{"edate":"2025-09-12","is_alarm":false},{"edate":"2025-09-13","is_alarm":false},{"edate":"2025-09-14","is_alarm":false},{"edate":"2025-09-15","is_alarm":false},{"edate":"2025-09-16","is_alarm":false},{"edate":"2025-09-17","is_alarm":false},{"edate":"2025-09-18","is_alarm":false},{"edate":"2025-09-19","is_alarm":false},{"edate":"2025-09-20","is_alarm":false},{"edate":"2025-09-21","is_alarm":false},{"edate":"2025-09-22","is_alarm":false},{"edate":"2025-09-23","is_alarm":false},{"edate":"2025-09-24","is_alarm":false},{"edate":"2025-09-25","is_alarm":false},{"edate":"2025-09-26","is_alarm":false},{"edate":"2025-09-27","is_alarm":false},{"edate":"2025-09-28","is_alarm":false},{"edate":"2025-09-29","is_alarm":false},{"edate":"2025-09-30","is_alarm":false}],"pagenation":{"totalcount":0,"thispage":1,"pagesize":-1},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-09-09 08:58:40') RETURNING "id" |
08:58:40.068 | 1.2 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.070 | 0.7 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.071 | 0.6 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id" |
08:58:40.083 | 0.6 ms | yii\db\Command::query | SELECT 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"=5446) AND ((w.start_at is not null) OR (w.end_at is not null)) AND ((("w"."start_at" >= '2025-09-01 00:00:00') AND ("w"."end_at" < '2025-09-30 00:00:00')) OR (("w"."start_at" <= '2025-09-01 00:00:00') AND ("w"."end_at" > '2025-09-01 00:00:00')) OR (("w"."start_at" <= '2025-09-30 00:00:00') AND ("w"."end_at" > '2025-09-30 00:00:00'))) AND ("w"."created_by"=5446) |
08:58:40.085 | 0.6 ms | yii\db\Command::query | SELECT 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" != 5446)) OR ("s"."created_by"=5446) OR ("ccr"."user_id"=5446)) AND ("s"."created_by"=5446) AND ("s"."created_by"=5446) AND (s.alarm_before is not null) |
08:58:40.084 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.077 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.080 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.072 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.085 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name" |
08:58:40.082 | 0.5 ms | yii\db\Command::query | SELECT "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"=5446) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id" |
08:58:40.069 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 |
08:58:40.071 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 |
08:58:40.095 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1) |
08:58:40.095 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND (0=1) |
08:58:40.096 | 0.1 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1) |