Database Queries

总计235条数据

Time	Duration	Type	Query

15:04:28.064	2.2 ms	SELECT	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 /var/www/beta/models/Login.php:65 /var/www/beta/vendor/uranus/web/User.php:201 /var/www/beta/modules/vue/controllers/CommonController.php:106 [+] Explain
15:04:28.067	1.5 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 /var/www/beta/modules/vue/controllers/CommonController.php:122 /var/www/beta/modules/vue/controllers/PunchController.php:41 [+] Explain
15:04:28.129	1.0 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1339 [+] Explain
15:04:28.131	1.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1389 [+] Explain
15:04:28.133	1.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.135	0.4 ms	SELECT	SELECT * 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) /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.136	0.5 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_strategies" WHERE "id" IN (1, 2, 35) /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.136	5.0 ms	SELECT	SELECT 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; /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.141	4.1 ms	SELECT	select 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 /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.186	0.4 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (4, 1, 2, 3, 9, 8, 6, 7, 10) /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.187	2.6 ms	SELECT	SELECT 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; /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.190	3.5 ms	SELECT	select 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 /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.194	0.5 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_department_positions" WHERE "id" IN (7, 2, 5, 3, 6, 18, 60, 23, 61, 16, 17, 21, 22, 25) /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.194	2.4 ms	SELECT	SELECT 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; /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.197	3.7 ms	SELECT	select 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 /var/www/beta/modules/vue/controllers/PunchController.php:1401 [+] Explain
15:04:28.201	9.3 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.211	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.212	0.5 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.212	20.6 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60096) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.233	17.1 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.250	2.0 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60096) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.253	0.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.253	0.5 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.254	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.261	2.5 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.264	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5300 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.264	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5300) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.264	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.265	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.265	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.268	2.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.271	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.271	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.271	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.272	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.272	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.275	2.5 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.278	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5332 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.278	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5332) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.279	0.3 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.279	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.279	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.282	1.9 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.284	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5449 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.285	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5449) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.285	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.286	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.286	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.289	7.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.296	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5087 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.297	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5087) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.297	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.298	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.298	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.301	7.3 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.308	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.309	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.309	19.6 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60101) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.329	16.6 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.346	1.9 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60101) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.348	0.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.348	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.349	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.352	7.6 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.360	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.360	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1004) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.360	19.1 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60104) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.380	16.7 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.397	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60104) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.399	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.399	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.400	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.403	2.5 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.405	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5248 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.406	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5248) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.406	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.407	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.407	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.410	7.6 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.418	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5085 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.418	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5085) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.419	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.419	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.419	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.422	2.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.425	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1022 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.425	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1022) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.426	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.426	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.427	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.430	2.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.432	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1023 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.432	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1023) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.433	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.433	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.434	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.437	2.5 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.439	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1015 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.440	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1015) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.440	19.8 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60095) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.460	16.6 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.477	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60095) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.479	0.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.479	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.480	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.483	8.0 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.491	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1011 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.492	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1011) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.492	19.1 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60094) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.511	17.0 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.528	1.9 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60094) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.530	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.531	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.531	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.535	7.7 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.542	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5360 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.543	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5360) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.543	18.9 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60106) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.562	16.6 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.579	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60106) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.581	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.582	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.582	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.585	2.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.588	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5311 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.588	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5311) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.589	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.589	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.589	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.592	2.2 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.595	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.595	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5446) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.597	19.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.616	16.9 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.633	1.9 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id" IN (60099, 60109, 60110, 60111, 60108, 60112, 60113, 60114, 60117)) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.636	0.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.636	0.3 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.637	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.637	0.4 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.638	3.0 ms	SELECT	SELECT 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; /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.641	3.9 ms	SELECT	select 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.646	1.7 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=10 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.648	2.3 ms	SELECT	SELECT 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; /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.650	3.8 ms	SELECT	select 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.654	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.655	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.656	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=10 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.656	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.657	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.657	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=11 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.657	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.658	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.659	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=11 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.659	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.659	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.660	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=13 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.660	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.661	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.661	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=13 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.662	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.662	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.662	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=15 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.663	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.664	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.664	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=15 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.664	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.665	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.666	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=8 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.666	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2282 [+] Explain
15:04:28.667	0.3 ms	SELECT	SELECT *, 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 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.667	0.2 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_punch_overtime_verify_rels" WHERE "punch_overtime_id"=8 ORDER BY "id" /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.668	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5446 /var/www/beta/modules/vue/controllers/PunchController.php:2914 [+] Explain
15:04:28.670	2.7 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.673	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5388 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.673	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5388) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.674	19.6 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60102) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.693	16.8 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.710	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60102) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.712	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.713	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.713	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.717	7.8 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.725	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.725	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5252) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.725	20.5 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60097) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.746	16.7 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.763	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60097) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.765	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.765	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.766	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.769	7.9 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.777	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1013 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.777	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1013) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.778	18.6 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60105) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.797	16.6 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.813	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60105) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.815	0.5 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.816	0.3 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.816	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.819	8.0 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.828	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.828	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5016) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.828	18.7 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60100) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.847	16.9 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.864	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60100) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.866	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.867	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.867	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.870	7.7 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.878	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.879	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5250) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.879	18.8 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60093) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.898	16.7 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.915	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60093) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.917	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.918	0.3 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.918	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.921	8.1 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.930	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.930	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1000) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.930	19.1 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.950	16.9 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.967	1.9 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id" IN (60098, 60116, 60118, 60119, 60120, 60122)) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.969	0.6 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:28.970	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:28.970	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain
15:04:28.974	8.4 ms	SELECT	SELECT 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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.982	0.2 ms	SELECT	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_users" WHERE "id"=5064 /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.983	0.2 ms	SELECT	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5064) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:28.983	19.1 ms	SELECT	SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=16) AND ("object_id"=60103) GROUP BY "object_id" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:29.003	16.8 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:29.020	1.8 ms	SELECT	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=16) AND ("object_id"=60103) /var/www/beta/modules/vue/controllers/PunchController.php:1437 [+] Explain
15:04:29.022	0.4 ms	SELECT	SELECT "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" /var/www/beta/modules/vue/controllers/PunchController.php:1446 [+] Explain
15:04:29.022	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1486 [+] Explain
15:04:29.023	0.2 ms	SELECT	SELECT 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) /var/www/beta/modules/vue/controllers/PunchController.php:1498 [+] Explain

[+] Explain all