ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a44d43a1096c: GET https://beta.jinchangxiao.com/vue/punch/export at 2026-07-01 04:47:54 pm by 66.249.68.3

Database Queries

总计207条数据
TimeDurationTypeQuery
  
16:47:54.0830.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
16:47:54.0860.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.1351.1 msSELECTSELECT date(dt) as edate FROM generate_series(date_trunc('day', to_date('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', 'yyyymmdd')), '1 day') tt(dt) GROUP BY "tt"."dt" ORDER BY "edate"

[+] Explain
16:47:54.1404.2 msSELECTSELECT "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" >= '20260701') AND ("day_at" <= '20260701') AND ("u"."user_status"='-1') GROUP BY "u"."id"

[+] Explain
16:47:54.1451.2 msSELECTSELECT "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) ORDER BY "d"."order", "u"."department_id", "u"."department_position_id"

[+] Explain
16:47:54.1470.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_strategy_resource_rels" WHERE "user_id" IN (1001, 5300, 5295, 5332, 5087, 5476, 1004, 1005, 5085, 1022, 5248, 1023, 1015, 1011, 5360, 5500, 5499, 5311, 5446, 5252, 1013, 5250, 5016, 1000, 5064, 5461)

[+] Explain
16:47:54.1482.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_strategies" WHERE "id" IN (1, 2)

[+] Explain
16:47:54.1506.3 msSELECTSELECT 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;

[+] Explain
16:47:54.1578.5 msSELECTselect 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

[+] Explain
16:47:54.1660.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10)

[+] Explain
16:47:54.1672.7 msSELECTSELECT 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;

[+] Explain
16:47:54.1707.4 msSELECTselect 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

[+] Explain
16:47:54.1800.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (7, 2, 5, 3, 6, 18, 60, 19, 23, 61, 16, 17, 21, 22, 25, 62)

[+] Explain
16:47:54.1812.7 msSELECTSELECT 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;

[+] Explain
16:47:54.1847.9 msSELECTselect 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

[+] Explain
16:47:54.19335.5 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.2297.4 msSELECTSELECT 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' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
16:47:54.2379.3 msSELECTselect 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' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
16:47:54.2470.4 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.2480.6 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)

[+] Explain
16:47:54.24970.0 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=62934) GROUP BY "object_id"

[+] Explain
16:47:54.32034.1 msSELECTSELECT "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"=62934) GROUP BY "object_id"

[+] Explain
16:47:54.3543.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=62934)

[+] Explain
16:47:54.3580.8 msSELECTSELECT "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"

[+] Explain
16:47:54.3601.6 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1001) AND ("status"=2)

[+] Explain
16:47:54.3621.6 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1001) AND ("status"=2)

[+] Explain
16:47:54.3641.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=1001) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1)) OR (("leave_start" != '2026-07-01') AND ("leave_end"='2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_start_time" IS NOT NULL) AND ("leave_start_time" < '13:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.3653.7 msSELECTSELECT 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_leaves' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
16:47:54.3698.7 msSELECTselect 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_leaves' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
16:47:54.3802.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=179 ORDER BY "id"

[+] Explain
16:47:54.3822.8 msSELECTSELECT 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_leave_verify_rels' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

[+] Explain
16:47:54.3857.6 msSELECTselect 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_leave_verify_rels' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

[+] Explain
16:47:54.3940.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.3940.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=1001) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_end"='2026-07-01') AND ("leave_end_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1) AND ("leave_end" != '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_end_time" IS NOT NULL) AND ("leave_end_time" > '12:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.3950.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=179 ORDER BY "id"

[+] Explain
16:47:54.3960.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.4040.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=1001) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1)) OR (("leave_start" != '2026-07-01') AND ("leave_end"='2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_start_time" IS NOT NULL) AND ("leave_start_time" < '13:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.4040.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=179 ORDER BY "id"

[+] Explain
16:47:54.4050.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.4060.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=1001) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_end"='2026-07-01') AND ("leave_end_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1) AND ("leave_end" != '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_end_time" IS NOT NULL) AND ("leave_end_time" > '12:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.4060.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=179 ORDER BY "id"

[+] Explain
16:47:54.4070.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
16:47:54.4089.2 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4170.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300

[+] Explain
16:47:54.4170.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300)

[+] Explain
16:47:54.4180.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4190.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5300) AND ("status"=2)

[+] Explain
16:47:54.4190.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5300) AND ("status"=2)

[+] Explain
16:47:54.4203.0 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4240.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
16:47:54.4240.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)

[+] Explain
16:47:54.4250.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4250.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5295) AND ("status"=2)

[+] Explain
16:47:54.4260.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5295) AND ("status"=2)

[+] Explain
16:47:54.4273.2 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4300.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5332

[+] Explain
16:47:54.4310.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5332)

[+] Explain
16:47:54.4310.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4320.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5332) AND ("status"=2)

[+] Explain
16:47:54.4320.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5332) AND ("status"=2)

[+] Explain
16:47:54.43313.6 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4470.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087

[+] Explain
16:47:54.4480.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087)

[+] Explain
16:47:54.4480.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4490.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5087) AND ("status"=2)

[+] Explain
16:47:54.4490.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5087) AND ("status"=2)

[+] Explain
16:47:54.4502.3 msSELECTSELECT 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 5476 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5476 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"

[+] Explain
16:47:54.4530.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5476

[+] Explain
16:47:54.4530.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5476)

[+] Explain
16:47:54.4540.5 msSELECTSELECT "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"=5476 GROUP BY "ps"."id"

[+] Explain
16:47:54.4540.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5476) AND ("status"=2)

[+] Explain
16:47:54.4550.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5476) AND ("status"=2)

[+] Explain
16:47:54.45613.2 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4690.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
16:47:54.4700.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004)

[+] Explain
16:47:54.4700.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4710.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1004) AND ("status"=2)

[+] Explain
16:47:54.4710.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1004) AND ("status"=2)

[+] Explain
16:47:54.47212.7 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4850.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005

[+] Explain
16:47:54.4860.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005)

[+] Explain
16:47:54.4860.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4870.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1005) AND ("status"=2)

[+] Explain
16:47:54.4870.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1005) AND ("status"=2)

[+] Explain
16:47:54.4883.5 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4920.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5085

[+] Explain
16:47:54.4930.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5085)

[+] Explain
16:47:54.4930.5 msSELECTSELECT "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"

[+] Explain
16:47:54.4940.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5085) AND ("status"=2)

[+] Explain
16:47:54.4940.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5085) AND ("status"=2)

[+] Explain
16:47:54.4952.9 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.4980.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1022

[+] Explain
16:47:54.4990.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1022)

[+] Explain
16:47:54.4990.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5000.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1022) AND ("status"=2)

[+] Explain
16:47:54.5010.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1022) AND ("status"=2)

[+] Explain
16:47:54.5022.8 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5050.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5248

[+] Explain
16:47:54.5050.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5248)

[+] Explain
16:47:54.5050.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5060.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5248) AND ("status"=2)

[+] Explain
16:47:54.5070.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5248) AND ("status"=2)

[+] Explain
16:47:54.5082.7 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5100.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023

[+] Explain
16:47:54.5110.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1023)

[+] Explain
16:47:54.5110.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5120.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1023) AND ("status"=2)

[+] Explain
16:47:54.5130.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1023) AND ("status"=2)

[+] Explain
16:47:54.5132.8 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5170.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1015

[+] Explain
16:47:54.5170.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1015)

[+] Explain
16:47:54.5170.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5180.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1015) AND ("status"=2)

[+] Explain
16:47:54.5190.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1015) AND ("status"=2)

[+] Explain
16:47:54.52013.3 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5330.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011

[+] Explain
16:47:54.5340.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011)

[+] Explain
16:47:54.5340.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5350.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1011) AND ("status"=2)

[+] Explain
16:47:54.5350.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1011) AND ("status"=2)

[+] Explain
16:47:54.53613.1 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5500.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360

[+] Explain
16:47:54.5500.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5360)

[+] Explain
16:47:54.5500.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5510.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5360) AND ("status"=2)

[+] Explain
16:47:54.5520.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5360) AND ("status"=2)

[+] Explain
16:47:54.5532.3 msSELECTSELECT 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 5500 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5500 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"

[+] Explain
16:47:54.5550.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5500

[+] Explain
16:47:54.5560.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5500)

[+] Explain
16:47:54.5560.4 msSELECTSELECT "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"=5500 GROUP BY "ps"."id"

[+] Explain
16:47:54.5570.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5500) AND ("status"=2)

[+] Explain
16:47:54.5570.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5500) AND ("status"=2)

[+] Explain
16:47:54.5582.2 msSELECTSELECT 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 5499 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5499 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"

[+] Explain
16:47:54.5610.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5499

[+] Explain
16:47:54.5610.2 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5499)

[+] Explain
16:47:54.5620.5 msSELECTSELECT "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"=5499 GROUP BY "ps"."id"

[+] Explain
16:47:54.5620.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5499) AND ("status"=2)

[+] Explain
16:47:54.5630.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5499) AND ("status"=2)

[+] Explain
16:47:54.5642.6 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5660.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311

[+] Explain
16:47:54.5670.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311)

[+] Explain
16:47:54.5670.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5680.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5311) AND ("status"=2)

[+] Explain
16:47:54.5680.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5311) AND ("status"=2)

[+] Explain
16:47:54.5692.5 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5720.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446

[+] Explain
16:47:54.5730.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5446)

[+] Explain
16:47:54.5730.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5740.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5446) AND ("status"=2)

[+] Explain
16:47:54.5740.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5446) AND ("status"=2)

[+] Explain
16:47:54.57513.1 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.5880.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
16:47:54.5890.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252)

[+] Explain
16:47:54.5890.5 msSELECTSELECT "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"

[+] Explain
16:47:54.5900.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5252) AND ("status"=2)

[+] Explain
16:47:54.5910.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5252) AND ("status"=2)

[+] Explain
16:47:54.59214.5 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.6060.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013

[+] Explain
16:47:54.6070.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013)

[+] Explain
16:47:54.6070.5 msSELECTSELECT "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"

[+] Explain
16:47:54.6080.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1013) AND ("status"=2)

[+] Explain
16:47:54.6080.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1013) AND ("status"=2)

[+] Explain
16:47:54.60912.1 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.6220.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
16:47:54.6220.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250)

[+] Explain
16:47:54.6230.5 msSELECTSELECT "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"

[+] Explain
16:47:54.6230.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5250) AND ("status"=2)

[+] Explain
16:47:54.6240.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5250) AND ("status"=2)

[+] Explain
16:47:54.62512.0 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.6370.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
16:47:54.6380.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016)

[+] Explain
16:47:54.6380.5 msSELECTSELECT "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"

[+] Explain
16:47:54.6390.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5016) AND ("status"=2)

[+] Explain
16:47:54.6390.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '1970-01-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5016) AND ("status"=2)

[+] Explain
16:47:54.64112.1 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.6530.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:47:54.6530.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000)

[+] Explain
16:47:54.6540.5 msSELECTSELECT "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"

[+] Explain
16:47:54.6550.3 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1000) AND ("status"=2)

[+] Explain
16:47:54.6550.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=1000) AND ("status"=2)

[+] Explain
16:47:54.65612.3 msSELECTSELECT 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('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', '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"

[+] Explain
16:47:54.6690.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064

[+] Explain
16:47:54.6690.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064)

[+] Explain
16:47:54.67030.7 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=63299) GROUP BY "object_id"

[+] Explain
16:47:54.70118.3 msSELECTSELECT "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"=63299) GROUP BY "object_id"

[+] Explain
16:47:54.7193.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=63299)

[+] Explain
16:47:54.7231.0 msSELECTSELECT "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"

[+] Explain
16:47:54.7250.4 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5064) AND ("status"=2)

[+] Explain
16:47:54.7250.6 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5064) AND ("status"=2)

[+] Explain
16:47:54.7260.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1)) OR (("leave_start" != '2026-07-01') AND ("leave_end"='2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_start_time" IS NOT NULL) AND ("leave_start_time" < '13:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.7270.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=177 ORDER BY "id"

[+] Explain
16:47:54.7280.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:47:54.7290.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_end"='2026-07-01') AND ("leave_end_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1) AND ("leave_end" != '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_end_time" IS NOT NULL) AND ("leave_end_time" > '12:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.7300.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=177 ORDER BY "id"

[+] Explain
16:47:54.7300.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:47:54.7320.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1)) OR (("leave_start" != '2026-07-01') AND ("leave_end"='2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_start_time" IS NOT NULL) AND ("leave_start_time" < '13:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.7320.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=177 ORDER BY "id"

[+] Explain
16:47:54.7330.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:47:54.7340.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leaves" WHERE ("created_by"=5064) AND ((("leave_start" < '2026-07-01') AND ("leave_end" > '2026-07-01')) OR (("leave_end"='2026-07-01') AND ("leave_end_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=2)) OR (("leave_start"='2026-07-01') AND ("leave_start_type"=1) AND ("leave_end" != '2026-07-01')) OR (("leave_start"='2026-07-01') AND ("leave_end"='2026-07-01') AND ("leave_end_time" IS NOT NULL) AND ("leave_end_time" > '12:00'))) AND ("status" IN (2, 5)) ORDER BY "verify_at" DESC

[+] Explain
16:47:54.7350.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_punch_leave_verify_rels" WHERE "punch_leave_id"=177 ORDER BY "id"

[+] Explain
16:47:54.7350.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:47:54.7363.0 msSELECTSELECT 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 5461 ELSE p.user_id END AS user_id FROM generate_series(date_trunc('day', to_date('20260701', 'yyyymmdd')), date_trunc('day', to_date('20260701', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_punch" "p" ON date(dt) = p.day_at AND p.user_id = 5461 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"

[+] Explain
16:47:54.7390.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5461

[+] Explain
16:47:54.7400.4 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5461)

[+] Explain
16:47:54.7410.8 msSELECTSELECT "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"=5461 GROUP BY "ps"."id"

[+] Explain
16:47:54.7420.5 msSELECTSELECT SUM(overtime_end - overtime_start) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5461) AND ("status"=2)

[+] Explain
16:47:54.7420.3 msSELECTSELECT SUM(minutes) FROM "a57be577deb434"."tbl_punch_overtimes" WHERE ("overtime_start" >= '2025-07-01') AND ("overtime_start" <= '2026-07-01 23:59:59') AND ("created_by"=5461) AND ("status"=2)

[+] Explain