ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
69438ef0cf9a4: POST https://beta.jinchangxiao.com/vue/analysis/sales-status-counts at 2025-12-18 01:19:44 pm by 223.72.15.22

Performance Profiling

Total processing time: 89 ms; Peak memory: 5.241 MB. Show Profiling Timeline

总计30条数据
TimeDurationCategoryInfo
  
13:19:44.9288.0 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_browser_ua_statistics' and ns.nspname='global' order by fns.nspname, fc.relname, a.attnum
13:19:44.9176.5 msyii\db\Command::querySELECT * FROM "global"."tbl_browser_ua_statistics" "b" WHERE "user_agent"='Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko/20100101 Firefox/146.0'
13:19:44.8715.7 msyii\db\Command::querySELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-01-01 00:00:00') AND (start_at < timestamp '2025-12-31 23:59:59' + interval '1 second') AND ("w"."created_by" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
13:19:44.8615.4 msyii\db\Command::querySELECT sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then 1 else 0 end) count1new, sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then p.budget else 0 end) count1newsum, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then 1 else 0 end) count1in, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then p.budget else 0 end) count1insum, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then 1 else 0 end) count1out, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then p.budget else 0 end) count1outsum, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then 1 else 0 end) count2new, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then p.budget else 0 end) count2newsum, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then 1 else 0 end) count2in, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then p.budget else 0 end) count2insum, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then 1 else 0 end) count2out, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then p.budget else 0 end) count2outsum, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then 1 else 0 end) count3new, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then p.budget else 0 end) count3newsum, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then 1 else 0 end) count3in, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then p.budget else 0 end) count3insum, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then 1 else 0 end) count3out, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then p.budget else 0 end) count3outsum, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then 1 else 0 end) count4new, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then p.budget else 0 end) count4newsum, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then 1 else 0 end) count4in, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then p.budget else 0 end) count4insum, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then 1 else 0 end) count4out, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then p.budget else 0 end) count4outsum, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then 1 else 0 end) count5new, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then p.budget else 0 end) count5newsum, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then 1 else 0 end) count5in, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then p.budget else 0 end) count5insum, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then 1 else 0 end) count5out, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then p.budget else 0 end) count5outsum, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then 1 else 0 end) count0new, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then p.budget else 0 end) count0newsum, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then 1 else 0 end) count0in, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then p.budget else 0 end) count0insum, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then 1 else 0 end) count0out, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then p.budget else 0 end) count0outsum FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT min(subpsl.id) AS min_id, max(subpsl.id) AS max_id, project_id FROM "a57be577deb434"."tbl_project_status_logs" "subpsl" WHERE subpsl.created_at >= '2025-01-01 00:00:00' AND subpsl.created_at < timestamp '2025-12-31 23:59:59' + interval '1 second' GROUP BY "subpsl"."project_id") "sub" ON sub.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "minpsl" ON sub.min_id = minpsl.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "maxpsl" ON sub.max_id = maxpsl.id WHERE ("p"."created_by"='1001') AND (sub.min_id is not null and sub.max_id is not null)
13:19:44.8824.9 msyii\db\Command::querySELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-01-01 00:00:00') AND ("ir"."arrived_at" <= '2025-12-31 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
13:19:44.8774.6 msyii\db\Command::querySELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from"='1001') AND ("ir"."arrived_at" >= '2025-01-01 00:00:00') AND ("ir"."arrived_at" <= '2025-12-31 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from"='1001') AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"
13:19:44.9244.2 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_browser_ua_statistics' and d.nspname = 'global' ORDER BY a.attnum;
13:19:44.9083.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-12-18')
13:19:44.8963.4 msyii\db\Command::querySELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from"='1001') AND ("c"."closed_at" >= '2025-01-01 00:00:00') AND ("c"."closed_at" <= '2025-12-31 23:59:59')
13:19:44.8892.9 msyii\db\Command::querySELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-01-01 00:00:00') AND ("ir"."arrived_at" <= '2025-12-31 23:59:59') AND ("ir"."is_draft"=FALSE)
13:19:44.8542.3 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
13:19:44.8871.9 msyii\db\Command::querySELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from"='1001') AND ("ir"."arrived_at" >= '2025-01-01 00:00:00') AND ("ir"."arrived_at" <= '2025-12-31 23:59:59') AND ("ir"."is_draft"=FALSE)
13:19:44.8521.9 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:19:44.8991.8 msyii\db\Command::querySELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("c"."closed_at" >= '2025-01-01 00:00:00') AND ("c"."closed_at" <= '2025-12-31 23:59:59')
13:19:44.8941.7 msyii\db\Command::querySELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND ("ps"."is_draft"=FALSE)
13:19:44.8571.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
13:19:44.8671.4 msyii\db\Command::querySELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (daterange(start_from::date, end_at::date, '[)') && '[2025-01-01 00:00:00, 2025-12-31 23:59:59]'::daterange) AND ("user_id" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:19:44.9131.2 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-status-counts', '{"period":"currentfascalyear","dataUserId":"1001","to":"","from":"","alert":"false"}', '{"code":2000,"result":{"statusCounts":[{"id":"1","key":"\u9690\u6027\u9700\u6c42","value":{"new":2,"new_sum":"333","in":0,"in_sum":"0","out":2,"out_sum":"333"}},{"id":"2","key":"\u660e\u786e\u9700\u6c42","value":{"new":12,"new_sum":"1436167.99","in":0,"in_sum":"0","out":13,"out_sum":"2643792.05"}},{"id":"3","key":"\u5546\u673a\u6210\u4ea4","value":{"new":5,"new_sum":"3241268","in":5,"in_sum":"1661137.05","out":9,"out_sum":"3893737.45"}},{"id":"0","key":"\u6536\u6b3e\u5b8c\u6210","value":{"new":0,"new_sum":"0","in":18,"in_sum":"4841425.45","out":0,"out_sum":"0"}},{"id":"4","key":"\u5546\u673a\u5931\u8d25","value":{"new":0,"new_sum":"0","in":0,"in_sum":"0","out":0,"out_sum":"0"}},{"id":"5","key":"\u5546\u673a\u6401\u7f6e","value":{"new":0,"new_sum":"0","in":1,"in_sum":"35300","out":0,"out_sum":"0"}}],"workCount":{"workTimeList":{"sum":0,"avg":42.07},"clientVisitList":{"sum":0,"avg":36.54},"engineerSpentList":{"sum":14.27,"avg":224.05},"implementTimes":{"sum":6,"avg":58.54},"preSalesTimes":{"sum":0,"avg":7.62},"deductedPoint":{"sum":"281","avg":4407.31},"operationDatas":{"sum":0,"avg":0}},"chart":{"salesTimes":[],"salesTimesCounts":0,"schedules":[{"status":0,"value":1,"name":"\u8fdb\u884c\u4e2d","y":100}],"schedulesCounts":1,"statusCounts":[{"key":3,"projects":18,"name":"\u5546\u673a\u6210\u4ea4","y":94.74},{"key":5,"projects":1,"name":"\u5546\u673a\u6401\u7f6e","y":5.26}],"projectCounts":19}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"223.72.15.22","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:146.0) Gecko\/20100101 Firefox\/146.0"}', FALSE, '2025-12-18 13:19:44') RETURNING "id"
13:19:44.8921.2 msyii\db\Command::querySELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from"='1001') AND ("ps"."start_at" >= '2025-01-01 00:00:00') AND ("ps"."start_at" <= '2025-12-31 23:59:59') AND ("ps"."is_draft"=FALSE)
13:19:44.9011.2 msyii\db\Command::querySELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of"='1001') AND ("otc"."complete_at" >= '2025-01-01 00:00:00') AND ("otc"."complete_at" <= '2025-12-31 23:59:59')
13:19:44.9030.9 msyii\db\Command::querySELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("otc"."complete_at" >= '2025-01-01 00:00:00') AND ("otc"."complete_at" <= '2025-12-31 23:59:59')
13:19:44.8700.9 msyii\db\Command::querySELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-01-01 00:00:00') AND (start_at < timestamp '2025-12-31 23:59:59' + interval '1 second') AND ("w"."created_by"='1001') AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)
13:19:44.9120.8 msyii\db\Command::executeUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=5, "last_visit_at"='now()' WHERE "id"=59594
13:19:44.8690.8 msyii\db\Command::querySELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2025-01-01 00:00:00') AND ("bargain_date" <= '2025-12-31 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5329, 5332, 5448, 5420, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) GROUP BY "created_by"
13:19:44.9050.8 msyii\db\Command::querySELECT sub.status, count(sub.id) as value FROM (SELECT id, created_by, CASE WHEN complete_at IS NOT NULL THEN complete_at ELSE end_at END as day_at, CASE WHEN is_complete = TRUE THEN 1 WHEN ( ( ( "is_complete" = FALSE ) AND ( "end_at" < '2025-12-18 13:19:44' ) ) ) THEN 2 ELSE 0 END as status FROM "a57be577deb434"."tbl_schedules" WHERE "is_public"=1) "sub" WHERE ("sub"."created_by"='1001') AND ("sub"."status" IN (0, 2)) GROUP BY "sub"."status"
13:19:44.9040.6 msyii\db\Command::querySELECT w.scenario_option_id as key, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by"='1001') AND (("w"."start_at" >= '2025-01-01 00:00:00') AND ("w"."start_at" <= '2025-12-31 23:59:59')) GROUP BY "w"."scenario_option_id", "wso"."name"
13:19:44.9070.4 msyii\db\Command::querySELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT p.id, p.project_status FROM "a57be577deb434"."tbl_projects" "p" WHERE ("p"."created_by"='1001') AND (project_status != 1) AND ("p"."bargain_date" >= '2025-01-01 00:00:00') AND ("p"."bargain_date" <= '2025-12-31 23:59:59')) "sub" GROUP BY "sub"."project_status"
13:19:44.9050.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND ("w"."created_by"='1001') AND (("w"."start_at" >= '2025-01-01 00:00:00') AND ("w"."start_at" <= '2025-12-31 23:59:59'))
13:19:44.9060.3 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE ("created_by"='1001') AND ("is_public"=1) AND ("is_complete"=FALSE)
13:19:44.9370.3 msyii\db\Command::executeUPDATE "global"."tbl_browser_ua_statistics" SET "counter"=7600 WHERE "id"=206