ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685e51ce48487: POST https://beta.jinchangxiao.com/v2/user/get-index at 2025-06-27 04:09:50 pm by 120.235.217.244

Log Messages

总计61条数据
TimeLevelCategoryMessage
 
16:09:50.295traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:09:50.295traceyii\base\Module::getModuleLoading module: debug
16:09:50.295traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:09:50.296traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:09:50.296traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:09:50.296traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.296traceyii\base\Module::getModuleLoading module: gii
16:09:50.296traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:09:50.296traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:09:50.296traceyii\web\Application::handleRequestRoute requested: 'v2/user/get-index'
16:09:50.296traceyii\base\Module::getModuleLoading module: v2
16:09:50.297infoyii\web\Session::openSession started
16:09:50.298infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:09:50.300infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='LpLquexa4MxJRClJNdb9gPVa_MzadLnu'
16:09:50.302traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.303traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:09:50.303traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.303traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:09:50.303infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:09:50.304traceyii\base\Controller::runActionRoute to run: v2/user/get-index
16:09:50.305traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\UserController::actionGetIndex()
16:09:50.305infoyii\db\Command::querySELECT * FROM "global"."tbl_logins" WHERE "id"=1001
16:09:50.305traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.305infoyii\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_logins' and d.nspname = 'global' ORDER BY a.attnum;
16:09:50.310infoyii\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_logins' and ns.nspname='global' order by fns.nspname, fc.relname, a.attnum
16:09:50.319traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:09:50.319traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
16:09:50.319infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "a".* FROM "global"."tbl_announcements" "a" LEFT JOIN "global"."tbl_read_announcement" "r" ON a.id = r.announcement_id AND r.user_id = 1001 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2017-02-06 13:05:08') ORDER BY "a"."created_at" DESC) "c"
16:09:50.320infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1001) AND ("is_read"=FALSE)
16:09:50.338infoyii\db\Command::querySELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1001) AND (is_read = false) GROUP BY "object_type"
16:09:50.353traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.354traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewCalendarMng
16:09:50.354traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Accountant
16:09:50.354traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
16:09:50.354traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
16:09:50.354traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.354traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.355infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:09:50.356infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:09:50.356infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:09:50.357infoyii\db\Command::querySELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id"
16:09:50.357infoyii\db\Command::querySELECT DISTINCT date(dt) AS edate, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_used, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_calendar_used, CASE WHEN count(sh.id) !=0 THEN true ELSE false END AS is_schedule_used, CASE WHEN count(wl.id) !=0 THEN true ELSE false END AS is_work_log_used FROM generate_series(date_trunc('day', to_date('20250601', 'yyyymmdd')), date_trunc('day', to_date('20250630', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_calendars" "c" WHERE (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by"=1001)) "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) LEFT JOIN (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)) "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.e_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.s_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.e_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.e_at ) ) AND sh.created_by = 1001 LEFT JOIN (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.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1001)) "wl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= wl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.end_at ) ) GROUP BY "tt"."dt" ORDER BY "edate" DESC
16:09:50.418traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.418infoyii\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_calendars' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
16:09:50.421infoyii\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_calendars' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
16:09:50.432traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:09:50.432traceyii\redis\Connection::executeCommandExecuting Redis Command: SET
16:09:50.432infoyii\db\Command::querySELECT DISTINCT date(dt) AS edate,CASE WHEN count(cl.alarm_before) !=0 or count(sh.alarm_before) !=0 THEN true ELSE false END AS is_alarm FROM generate_series(date_trunc('day', to_date('20250601', 'yyyymmdd')), date_trunc('day', to_date('20250630', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_calendars" "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) AND cl.created_by = 1001 LEFT JOIN "a57be577deb434"."tbl_schedules" "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.end_at ) ) AND sh.created_by = 1001 WHERE (cl.start_at - cl.alarm_before > '2025-06-27 04:09:50') OR (sh.start_at - sh.alarm_before > '2025-06-27 04:09:50') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC
16:09:50.487infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT * 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"."start_at" >= '2025-06-27 00:00:00') AND ("w"."end_at" < '2025-06-27 23:59:59')) OR (("w"."start_at" <= '2025-06-27 00:00:00') AND ("w"."end_at" > '2025-06-27 00:00:00')) OR (("w"."start_at" <= '2025-06-27 23:59:59') AND ("w"."end_at" > '2025-06-27 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1001) 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))) 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" WHERE ((("s"."s_at" >= '2025-06-27 00:00:00') AND ("s"."e_at" < '2025-06-27 23:59:59')) OR (("s"."s_at" <= '2025-06-27 00:00:00') AND ("s"."e_at" > '2025-06-27 00:00:00')) OR (("s"."s_at" <= '2025-06-27 23:59:59') AND ("s"."e_at" > '2025-06-27 23:59:59'))) AND ("s"."created_by"=1001) 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))) 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"."start_at" >= '2025-06-27 00:00:00') AND ("c"."end_at" < '2025-06-27 23:59:59')) OR (("c"."start_at" <= '2025-06-27 00:00:00') AND ("c"."end_at" > '2025-06-27 00:00:00')) OR (("c"."start_at" <= '2025-06-27 23:59:59') AND ("c"."end_at" > '2025-06-27 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) 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"=1001) ) )) "w" ORDER BY "start_at") "c"
16:09:50.491infoyii\db\Command::querySELECT * 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"."start_at" >= '2025-06-27 00:00:00') AND ("w"."end_at" < '2025-06-27 23:59:59')) OR (("w"."start_at" <= '2025-06-27 00:00:00') AND ("w"."end_at" > '2025-06-27 00:00:00')) OR (("w"."start_at" <= '2025-06-27 23:59:59') AND ("w"."end_at" > '2025-06-27 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1001) 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))) 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" WHERE ((("s"."s_at" >= '2025-06-27 00:00:00') AND ("s"."e_at" < '2025-06-27 23:59:59')) OR (("s"."s_at" <= '2025-06-27 00:00:00') AND ("s"."e_at" > '2025-06-27 00:00:00')) OR (("s"."s_at" <= '2025-06-27 23:59:59') AND ("s"."e_at" > '2025-06-27 23:59:59'))) AND ("s"."created_by"=1001) 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))) 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"."start_at" >= '2025-06-27 00:00:00') AND ("c"."end_at" < '2025-06-27 23:59:59')) OR (("c"."start_at" <= '2025-06-27 00:00:00') AND ("c"."end_at" > '2025-06-27 00:00:00')) OR (("c"."start_at" <= '2025-06-27 23:59:59') AND ("c"."end_at" > '2025-06-27 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) 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"=1001) ) )) "w" ORDER BY "start_at"
16:09:50.495infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:09:50.495infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
16:09:50.495infoyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
16:09:50.496infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sales_rep", "logo" FROM "a57be577deb434"."tbl_clients" WHERE "id"=2803
16:09:50.497infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)
16:09:50.497infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND ("object_id"=17684)
16:09:50.498infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "extension", "path" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24685
16:09:50.499infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)
16:09:50.499traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:09:50.499traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:09:50.499infoyii\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', 1001, 7, 165, 'v2/user/get-index', '{"posttime":"1751011789","access_token":"LpLquexa4MxJRClJNdb9gPVa_MzadLnu","device_type":"7","version_code":"165","token":"4c16f8d41ab4ac164fbeb62453b9bab7"}', '{"code":200,"data":{"announcementUnread":{"count":15},"unread":[{"key":"1","value":6},{"key":"18","value":2},{"key":"19","value":7}],"calendar":{"list":[{"id":17684,"title":"\u548c\u5f6d\u5ca9\u6c9f\u901a\u4e00\u4e0b\u62db\u8058\u4eba\u4e8b\u7684\u4e8b\u60c5\u3002","client_id":2803,"created_by":1001,"start_at":"2024-07-22 00:00:00","end_at":"2025-06-27 16:09:50","type":2,"is_alarm":false,"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"},"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"client":{"id":2803,"key":2803,"name":"\u62d3\u5b9e\u603b\u76d1\u4f1a","sales_rep":1001,"logo":null},"start_at_display":"","end_at_display":"16:09","can_update":false,"can_delete":false,"attachmentRelationships":[{"id":33039,"object_type":9,"object_id":17684,"attachment_id":24685,"attachment":{"id":24685,"key":24685,"name":"361111be-0dfd-3b97-a84e-0ce4936ec132","extension":"png","path":"\/var\/www\/beta\/web\/files\/protected\/a57be577deb434\/2025\/05\/"}}]}],"point":[{"edate":"2025-06-30","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-28","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":true,"is_work_log_used":false},{"edate":"2025-06-26","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-24","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-22","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-20","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-18","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-16","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-14","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-12","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-10","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-08","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-06","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-04","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-02","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false},{"edate":"2025-06-01","is_used":false,"is_calendar_used":false,"is_schedule_used":true,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":1,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-27 16:09:50') RETURNING "id"