ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68cd007c0ee6a: POST https://beta.jinchangxiao.com/vue/punch/export at 2025-09-19 03:04:28 pm by 223.104.42.140

Performance Profiling

Total processing time: 1,045 ms; Peak memory: 9.359 MB. Show Profiling Timeline

总计236条数据
TimeDurationCategoryInfo
  
15:04:28.21220.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60096) GROUP BY "object_id"
15:04:28.72520.5 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60097) GROUP BY "object_id"
15:04:28.44019.8 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60095) GROUP BY "object_id"
15:04:28.67419.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60102) GROUP BY "object_id"
15:04:28.30919.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60101) GROUP BY "object_id"
15:04:28.59719.5 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id" IN (60099, 60109, 60110, 60111, 60108, 60112, 60113, 60114, 60117)) GROUP BY "object_id"
15:04:28.93019.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id" IN (60098, 60116, 60118, 60119, 60120, 60122)) GROUP BY "object_id"
15:04:28.98319.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60103) GROUP BY "object_id"
15:04:28.36019.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60104) GROUP BY "object_id"
15:04:28.49219.1 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60094) GROUP BY "object_id"
15:04:28.54318.9 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60106) GROUP BY "object_id"
15:04:28.87918.8 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60093) GROUP BY "object_id"
15:04:28.82818.7 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60100) GROUP BY "object_id"
15:04:28.77818.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60105) GROUP BY "object_id"
15:04:28.23317.1 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60096) GROUP BY "object_id"
15:04:28.51117.0 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60094) GROUP BY "object_id"
15:04:28.61616.9 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (60099, 60109, 60110, 60111, 60108, 60112, 60113, 60114, 60117)) GROUP BY "object_id"
15:04:28.95016.9 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id" IN (60098, 60116, 60118, 60119, 60120, 60122)) GROUP BY "object_id"
15:04:28.84716.9 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60100) GROUP BY "object_id"
15:04:29.00316.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60103) GROUP BY "object_id"
15:04:28.69316.8 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60102) GROUP BY "object_id"
15:04:28.89816.7 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60093) GROUP BY "object_id"
15:04:28.38016.7 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60104) GROUP BY "object_id"
15:04:28.74616.7 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60097) GROUP BY "object_id"
15:04:28.46016.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60095) GROUP BY "object_id"
15:04:28.32916.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60101) GROUP BY "object_id"
15:04:28.56216.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60106) GROUP BY "object_id"
15:04:28.79716.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=16) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=60105) GROUP BY "object_id"
15:04:28.2019.3 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1001 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1001 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.9748.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5064 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5064 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.9218.1 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1000 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1000 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.4838.0 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1011 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1011 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.8198.0 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5016 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5016 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.7697.9 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1013 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1013 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.7177.8 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5252 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5252 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.8707.7 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5250 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5250 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.5357.7 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5360 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5360 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.4107.6 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5085 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5085 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.3527.6 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1004 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1004 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.2897.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5087 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5087 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.3017.3 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1005 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1005 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.1365.0 msyii\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_punch_strategies' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:04:28.1414.1 msyii\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_punch_strategies' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:04:28.6413.9 msyii\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_punch_overtimes' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:04:28.6503.8 msyii\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_punch_overtime_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:04:28.1973.7 msyii\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_department_positions' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:04:28.1903.5 msyii\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_departments' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum
15:04:28.6383.0 msyii\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_punch_overtimes' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:04:28.6702.7 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5388 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5388 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.1872.6 msyii\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_departments' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:04:28.2612.5 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5300 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5300 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.2752.5 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5332 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5332 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.4032.5 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5248 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5248 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.4372.5 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1015 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1015 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.1942.4 msyii\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_department_positions' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:04:28.4222.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1022 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1022 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.5852.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5311 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5311 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.4302.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 1023 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 1023 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.2682.4 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5295 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5295 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.6482.3 msyii\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_punch_overtime_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;
15:04:28.0642.2 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
15:04:28.5922.2 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5446 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5446 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.2502.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60096)
15:04:28.6331.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id" IN (60099, 60109, 60110, 60111, 60108, 60112, 60113, 60114, 60117))
15:04:28.9671.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id" IN (60098, 60116, 60118, 60119, 60120, 60122))
15:04:28.0621.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
15:04:28.2821.9 msyii\db\Command::querySELECT date(dt) as edate, p.*, CASE WHEN p.in_status IS NULL and p.need_work = true THEN 2 ELSE p.in_status END AS in_status, CASE WHEN p.out_status IS NULL and p.need_work = true THEN 2 ELSE p.out_status END AS out_status, CASE WHEN p.user_id IS NULL THEN 5449 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5449 LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = p.user_id GROUP BY "tt"."dt", "p"."day_at", "p"."user_id" ORDER BY "edate"
15:04:28.3461.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60101)
15:04:28.5281.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60094)
15:04:28.9151.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60093)
15:04:28.5791.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60106)
15:04:28.8641.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60100)
15:04:29.0201.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60103)
15:04:28.7631.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60097)
15:04:28.7101.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60102)
15:04:28.4771.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60095)
15:04:28.3971.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60104)
15:04:28.8131.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60105)
15:04:28.6461.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=10 ORDER BY "id"
15:04:28.1311.5 msyii\db\Command::querySELECT "u"."id" FROM "a57be577deb434"."tbl_punch" "p" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON p.user_id = u.id WHERE ((p.in_at IS NOT NULL) OR (p.out_at IS NOT NULL)) AND ("day_at" >= '20250901') AND ("day_at" <= '20250919') AND ("u"."user_status"='-1') GROUP BY "u"."id"
15:04:28.0671.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:04:28.1331.5 msyii\db\Command::querySELECT "u".* FROM "a57be577deb434"."tbl_users" "u" LEFT JOIN "a57be577deb434"."tbl_departments" "d" ON u.department_id = d.id WHERE (("user_status"='1') OR (0=1)) AND ("u"."id" IN ('1001', '5332', '5087', '5300', '5295', '1004', '1005', '5449', '5085', '5248', '1015', '1022', '1023', '1011', '5360', '5311', '5446', '5252', '5388', '1013', '1000', '5250', '5016', '5064')) ORDER BY "d"."order", "u"."department_id", "u"."department_position_id"
15:04:28.1291.0 msyii\db\Command::querySELECT date(dt) as edate FROM generate_series(date_trunc('day', to_date('20250901', 'yyyymmdd')), date_trunc('day', to_date('20250919', 'yyyymmdd')), '1 day') tt(dt) GROUP BY "tt"."dt" ORDER BY "edate"
15:04:28.9690.6 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1000 GROUP BY "ps"."id"
15:04:28.1360.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_strategies" WHERE "id" IN (1, 2, 35)
15:04:28.2120.5 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
15:04:28.1940.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (7, 2, 5, 3, 6, 18, 60, 23, 61, 16, 17, 21, 22, 25)
15:04:28.4790.5 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1015 GROUP BY "ps"."id"
15:04:28.2530.5 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1001 GROUP BY "ps"."id"
15:04:28.2530.5 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1001) AND ("status"=2)
15:04:28.6360.5 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5446 GROUP BY "ps"."id"
15:04:28.3480.5 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1005 GROUP BY "ps"."id"
15:04:28.8150.5 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1013 GROUP BY "ps"."id"
15:04:28.3990.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1004 GROUP BY "ps"."id"
15:04:29.0220.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5064 GROUP BY "ps"."id"
15:04:28.7650.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5252 GROUP BY "ps"."id"
15:04:28.9170.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5250 GROUP BY "ps"."id"
15:04:28.5810.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5360 GROUP BY "ps"."id"
15:04:28.7120.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5388 GROUP BY "ps"."id"
15:04:28.5300.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1011 GROUP BY "ps"."id"
15:04:28.8660.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5016 GROUP BY "ps"."id"
15:04:28.4190.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5085 GROUP BY "ps"."id"
15:04:28.6370.4 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-01 00:00:00') AND ("overtime_start" <= '2025-09-01 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.4060.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5248 GROUP BY "ps"."id"
15:04:28.4330.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1023 GROUP BY "ps"."id"
15:04:28.5890.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5311 GROUP BY "ps"."id"
15:04:28.2850.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5449 GROUP BY "ps"."id"
15:04:28.2970.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5087 GROUP BY "ps"."id"
15:04:28.4260.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=1022 GROUP BY "ps"."id"
15:04:28.1350.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_strategy_resource_rels" WHERE "user_id" IN (1001, 5300, 5295, 5332, 5449, 5087, 1005, 1004, 5248, 5085, 1022, 1023, 1015, 1011, 5360, 5311, 5446, 5388, 5252, 1013, 5016, 5250, 1000, 5064)
15:04:28.2640.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5300 GROUP BY "ps"."id"
15:04:28.2710.4 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5295 GROUP BY "ps"."id"
15:04:28.1860.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)
15:04:28.6650.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-08 00:00:00') AND ("overtime_start" <= '2025-09-08 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.2790.3 msyii\db\Command::querySELECT "ps".* FROM "a57be577deb434"."tbl_punch_strategies" "ps" LEFT JOIN "a57be577deb434"."tbl_punch_strategy_resource_rels" "psrr" ON psrr.punch_strategy_id = ps.id WHERE "psrr"."user_id"=5332 GROUP BY "ps"."id"
15:04:28.6550.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-01 00:00:00') AND ("overtime_start" <= '2025-09-01 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6580.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-02 00:00:00') AND ("overtime_start" <= '2025-09-02 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6610.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-03 00:00:00') AND ("overtime_start" <= '2025-09-03 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6670.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-08 00:00:00') AND ("overtime_start" <= '2025-09-08 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6640.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-04 00:00:00') AND ("overtime_start" <= '2025-09-04 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6620.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-04 00:00:00') AND ("overtime_start" <= '2025-09-04 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6590.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-03 00:00:00') AND ("overtime_start" <= '2025-09-03 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.6570.3 msyii\db\Command::querySELECT *, overtime_end - overtime_start AS hours_spent FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("created_by"=5446) AND (("overtime_start" >= '2025-09-02 00:00:00') AND ("overtime_start" <= '2025-09-02 23:59:59')) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC
15:04:28.8160.3 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1013) AND ("status"=2)
15:04:28.6360.3 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5446) AND ("status"=2)
15:04:28.9180.3 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5250) AND ("status"=2)
15:04:28.2540.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1001) AND ("status"=2)
15:04:28.4180.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5085
15:04:29.0220.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5064) AND ("status"=2)
15:04:28.5820.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5360) AND ("status"=2)
15:04:28.8670.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5016) AND ("status"=2)
15:04:28.7130.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5388) AND ("status"=2)
15:04:28.3990.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1004) AND ("status"=2)
15:04:28.2110.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
15:04:28.5310.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1011) AND ("status"=2)
15:04:28.9700.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1000) AND ("status"=2)
15:04:28.3480.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1005) AND ("status"=2)
15:04:28.2780.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5332
15:04:28.4790.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1015) AND ("status"=2)
15:04:28.2720.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5295) AND ("status"=2)
15:04:28.2650.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5300) AND ("status"=2)
15:04:28.7650.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5252) AND ("status"=2)
15:04:28.5880.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311
15:04:28.4260.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1022) AND ("status"=2)
15:04:28.9820.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064
15:04:28.2860.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5449) AND ("status"=2)
15:04:28.4190.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5085) AND ("status"=2)
15:04:28.4910.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011
15:04:28.2790.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5332) AND ("status"=2)
15:04:28.6540.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.2980.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5087) AND ("status"=2)
15:04:28.4800.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1015) AND ("status"=2)
15:04:28.9300.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
15:04:28.4330.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1023) AND ("status"=2)
15:04:28.4070.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5248) AND ("status"=2)
15:04:28.5950.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.9180.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5250) AND ("status"=2)
15:04:28.5890.2 msyii\db\Command::querySELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5311) AND ("status"=2)
15:04:28.7770.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013
15:04:28.3080.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
15:04:28.7660.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5252) AND ("status"=2)
15:04:28.8280.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
15:04:28.9700.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1000) AND ("status"=2)
15:04:28.4050.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5248
15:04:28.5420.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360
15:04:28.4390.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
15:04:28.8780.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250
15:04:28.3600.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004
15:04:28.8160.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1013) AND ("status"=2)
15:04:28.4070.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5248) AND ("status"=2)
15:04:28.7250.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252
15:04:28.2720.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5295) AND ("status"=2)
15:04:28.6560.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=10 ORDER BY "id"
15:04:28.2650.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5300) AND ("status"=2)
15:04:28.2710.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
15:04:28.2640.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300
15:04:28.4250.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1022
15:04:28.6670.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=8 ORDER BY "id"
15:04:28.8670.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5016) AND ("status"=2)
15:04:28.2860.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5449) AND ("status"=2)
15:04:29.0230.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5064) AND ("status"=2)
15:04:28.6570.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.5820.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5360) AND ("status"=2)
15:04:28.6730.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5388
15:04:28.4320.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023
15:04:28.2840.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5449
15:04:28.2960.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087
15:04:28.5310.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1011) AND ("status"=2)
15:04:28.7130.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5388) AND ("status"=2)
15:04:28.2980.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5087) AND ("status"=2)
15:04:28.3490.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1005) AND ("status"=2)
15:04:28.6370.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5446) AND ("status"=2)
15:04:28.4270.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1022) AND ("status"=2)
15:04:28.5880.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311)
15:04:28.6590.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.6600.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=13 ORDER BY "id"
15:04:28.4000.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2024-09-19') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1004) AND ("status"=2)
15:04:28.8280.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)
15:04:28.2790.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5332) AND ("status"=2)
15:04:28.6640.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.9830.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064)
15:04:28.4190.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5085) AND ("status"=2)
15:04:28.5890.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=5311) AND ("status"=2)
15:04:28.6630.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.5430.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5360)
15:04:28.4340.2 msyii\db\Command::querySELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2025-09-19 23:59:59') AND ("created_by"=1023) AND ("status"=2)
15:04:28.6560.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.6660.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=8 ORDER BY "id"
15:04:28.6660.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.6640.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=15 ORDER BY "id"
15:04:28.8790.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)
15:04:28.6610.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=13 ORDER BY "id"
15:04:28.6590.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=11 ORDER BY "id"
15:04:28.7250.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)
15:04:28.4320.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1023)
15:04:28.9300.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)
15:04:28.6570.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=11 ORDER BY "id"
15:04:28.2780.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5332)
15:04:28.3090.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)
15:04:28.6600.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.6730.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5388)
15:04:28.2640.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)
15:04:28.3600.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004)
15:04:28.6680.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.4920.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)
15:04:28.4180.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5085)
15:04:28.6620.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=15 ORDER BY "id"
15:04:28.5950.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5446)
15:04:28.6620.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446
15:04:28.4250.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1022)
15:04:28.4400.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1015)
15:04:28.7770.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)
15:04:28.2710.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
15:04:28.4060.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5248)
15:04:28.2850.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5449)
15:04:28.2970.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)