ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a1963517a243: POST https://beta.jinchangxiao.com/vue/client/get-edit at 2026-05-29 05:58:41 pm by 43.224.72.82

Performance Profiling

Total processing time: 59 ms; Peak memory: 4.180 MB. Show Profiling Timeline

总计56条数据
TimeDurationCategoryInfo
  
17:58:41.54011.5 msyii\db\Command::queryselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_visit_object_histories' and ns.nspname='o6a13e2c574d5a' order by fns.nspname, fc.relname, a.attnum
17:58:41.5225.6 msyii\db\Command::querySELECT final.id, final.name, final.sales_rep, final.status3_budgets, final.status3_profits, final.status3_count, final.status3_pct, final.status1_budgets, final.status1_count, final.status2_budgets, final.status2_count, final.pscount, final.ircount, (final.pstime + final.irtime) AS service_time, (final.pscount + final.ircount) AS service_count, (now() - created_at) AS sales_rep_time, final.created_at, final.work_time, final.work_count, final.last_bargain_date, final.reimbursement_amount, final.points, CASE WHEN final.cooperated IS NULL THEN false ELSE true END AS cooperated, final.client_industry, final.client_industry_id FROM (SELECT c.id, c.name, c.sales_rep, c.created_at, CASE WHEN tmp1.budgets IS NULL THEN 0 ELSE tmp1.budgets END AS status3_budgets, CASE WHEN tmp1.profits IS NULL THEN 0 ELSE tmp1.profits END AS status3_profits, CASE WHEN tmp1.budgets IS NULL OR tmp1.budgets = 0 THEN 0 ELSE tmp1.profits / tmp1.budgets END AS status3_pct, CASE WHEN tmp1.count IS NULL THEN 0 ELSE tmp1.count END AS status3_count, CASE WHEN tmp2.budgets IS NULL THEN 0 ELSE tmp2.budgets END AS status1_budgets, CASE WHEN tmp2.count IS NULL THEN 0 ELSE tmp2.count END AS status1_count, CASE WHEN tmp3.budgets IS NULL THEN 0 ELSE tmp3.budgets END AS status2_budgets, CASE WHEN tmp3.count IS NULL THEN 0 ELSE tmp3.count END AS status2_count, CASE WHEN tmp4.pre_sales_counts IS NULL THEN 0 ELSE tmp4.pre_sales_counts END AS pscount, CASE WHEN tmp5.implement_counts IS NULL THEN 0 ELSE tmp5.implement_counts END AS ircount, CASE WHEN tmp4.pre_sales_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp4.pre_sales_times)/3600 ELSE 0 END AS pstime, CASE WHEN tmp5.implement_times IS NOT NULL THEN EXTRACT(EPOCH FROM tmp5.implement_times)/3600 ELSE 0 END AS irtime, CASE WHEN tmp6.sales_rep_time IS NOT NULL THEN EXTRACT(EPOCH FROM tmp6.sales_rep_time )/3600 ELSE 0 END AS sales_rep_time, CASE WHEN tmp7.work_times IS NOT NULL THEN tmp7.work_times ELSE '00:00:00'::interval END AS work_time, CASE WHEN tmp7.work_count IS NOT NULL THEN tmp7.work_count ELSE 0 END AS work_count, CASE WHEN tmp8.reimbursement_amount IS NOT NULL THEN tmp8.reimbursement_amount ELSE 0 END AS reimbursement_amount, tmp1.last_bargain_date, CASE WHEN tmp9.points IS NOT NULL THEN tmp9.points ELSE 0 END AS points, tmp1.count AS cooperated, ci.name as client_industry, ci.id as client_industry_id, ct.name as client_type, ct.id as client_type_id FROM "o6a13e2c574d5a"."tbl_clients" "c" LEFT JOIN (SELECT sub1.client_id, sum(sub1.budget) AS budgets, sum(sub1.budget * sub1.profit_pct / 100) AS profits, max(sub1.bargain_date) AS last_bargain_date, count(sub1.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" "p" WHERE p.project_status = 3) "sub1" GROUP BY "sub1"."client_id") "tmp1" ON tmp1.client_id = c.id LEFT JOIN (SELECT sub2.client_id, sum(sub2.budget) AS budgets, count(sub2.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" "p" WHERE p.project_status = 1) "sub2" GROUP BY "sub2"."client_id") "tmp2" ON tmp2.client_id = c.id LEFT JOIN (SELECT sub3.client_id, sum(sub3.budget) AS budgets, count(sub3.id) as count FROM (SELECT "p"."id", "p"."client_id", "p"."budget", "p"."profit_pct", "p"."bargain_date" FROM "o6a13e2c574d5a"."tbl_projects" "p" WHERE p.project_status = 2) "sub3" GROUP BY "sub3"."client_id") "tmp3" ON tmp3.client_id = c.id LEFT JOIN (SELECT sub4.client_id, count(sub4.id) as pre_sales_counts, sum(sub4.pre_sales_time) as pre_sales_times FROM (SELECT "ps"."id", "ps"."client_id", (ps.end_at - ps.start_at) as pre_sales_time FROM "o6a13e2c574d5a"."tbl_pre_sales" "ps" WHERE "ps"."is_draft"=FALSE) "sub4" GROUP BY "sub4"."client_id") "tmp4" ON tmp4.client_id = c.id LEFT JOIN (SELECT sub5.client_id, count(sub5.id) as implement_counts, sum(sub5.implement_time) as implement_times FROM (SELECT "ir"."id", "ir"."client_id", (ir.left_at - ir.arrived_at) as implement_time FROM "o6a13e2c574d5a"."tbl_implement_records" "ir" WHERE "ir"."is_draft"=FALSE) "sub5" GROUP BY "sub5"."client_id") "tmp5" ON tmp5.client_id = c.id LEFT JOIN (SELECT csrr.client_id, csrr.sales_rep, (now() - csrr.start_at) as sales_rep_time FROM "o6a13e2c574d5a"."tbl_client_sales_rep_rels" "csrr" WHERE "id" IN (SELECT max(csrrs.id) FROM "o6a13e2c574d5a"."tbl_client_sales_rep_rels" "csrrs" WHERE csrrs.end_at is null GROUP BY "csrrs"."client_id")) "tmp6" ON tmp6.client_id = c.id and tmp6.sales_rep = c.sales_rep LEFT JOIN (SELECT sub7.client_id, count(sub7.id) as work_count, sum(sub7.work_time) as work_times FROM (SELECT "wl"."id", "wl"."client_id", (wl.end_at - wl.start_at) as work_time FROM "o6a13e2c574d5a"."tbl_work_logs" "wl" WHERE ("wl"."is_draft"=FALSE) AND ("wl"."location_in_id" IS NOT NULL) AND ("wl"."location_out_id" IS NOT NULL) AND ("wl"."client_id" IS NOT NULL)) "sub7" GROUP BY "sub7"."client_id") "tmp7" ON tmp7.client_id = c.id LEFT JOIN (SELECT sub8.client_id, sum(sub8.reimbursement_amount) as reimbursement_amount FROM (SELECT "r"."client_id", "r"."amount" AS "reimbursement_amount" FROM "o6a13e2c574d5a"."tbl_reimbursements" "r" WHERE "r"."status" IN (2, 3)) "sub8" GROUP BY "sub8"."client_id") "tmp8" ON tmp8.client_id = c.id LEFT JOIN (SELECT sub9.client_id, sum(sub9.points) as points FROM (SELECT "c"."client_id", sum(ca.points) as points FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN "o6a13e2c574d5a"."tbl_case_assignments" "ca" ON ca.case_id = c.id GROUP BY "c"."id") "sub9" GROUP BY "sub9"."client_id") "tmp9" ON tmp9.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_client_industries" "ci" ON "ci"."id" = "c"."client_industry" LEFT JOIN "o6a13e2c574d5a"."tbl_client_types" "ct" ON "ct"."id" = "c"."client_type") "final" WHERE "final"."id"=1
17:58:41.5522.8 msyii\db\Command::queryINSERT INTO "o6a13e2c574d5a"."tbl_visit_object_histories" ("user_id", "object_type", "object_id", "last_visit_at") VALUES (5495, 10, 1, 'now()') RETURNING "id"
17:58:41.5382.6 msyii\db\Command::querySELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_visit_object_histories' and d.nspname = 'o6a13e2c574d5a' ORDER BY a.attnum;
17:58:41.5322.2 msyii\db\Command::querySELECT product_type_id, product_type_id as key, name, count(it.id) as value FROM "o6a13e2c574d5a"."tbl_implement_product_types" "it" WHERE "implement_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_implement_records" WHERE ("is_draft"=FALSE) AND ("client_id"=1)) GROUP BY "product_type_id", "name"
17:58:41.5052.0 msyii\db\Command::querySELECT c.*, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE c.sales_rep END AS sales_rep, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, extract(epoch from (now() - max(sl.end_at))) / 86400 AS lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, max(sl.end_at) as last_contact, max(arrive.end_at) as last_arrive, cc.notice_days AS notice_days, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cc.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cc.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cc.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cc.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 149::float END) / cc.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 149::float END) / cc.visit_base::float) END) ELSE 20 END) + (CASE WHEN cc.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cc.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cc.cooperate_base END) ELSE 20 END) + (CASE WHEN cc.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cc.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cc.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cc.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cc.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cc.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "o6a13e2c574d5a"."tbl_clients" "c" LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN "o6a13e2c574d5a"."tbl_work_logs" "sl" ON sl.client_id = c.id LEFT JOIN "o6a13e2c574d5a"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE ("c"."id"='1') AND ("deleted"=FALSE) GROUP BY "c"."id", "cc"."id"
17:58:41.5281.4 msyii\db\Command::querySELECT SUM(uncollected) FROM (SELECT sc.*, scp.collected, (sc.amount - scp.collected) as uncollected FROM "o6a13e2c574d5a"."tbl_sales_contracts" "sc" LEFT JOIN "o6a13e2c574d5a"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "o6a13e2c574d5a"."tbl_sales_contracts" "t0" WHERE t0.need_analysis = true GROUP BY "t0"."id") "scp" ON scp.contract_id = sc.id WHERE (sc.need_analysis = true) AND (("sales_rep"=5493) OR ("sales_rep" IS NULL)) AND ("c"."id"=1) GROUP BY "sc"."id", "scp"."collected" ORDER BY "signed_at" DESC) "sub"
17:58:41.5561.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/client/get-edit', '{"id":"1","web_access_token":"LtdoQWPnIHveoR2dE9dLuCNO9f4Azx_q"}', '{"code":2000,"result":{"model":{"id":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","abbr":"","pinyin_shortcut":"ljcsxsht","description":"","corp_rep":"","website":"","capital":"","established_at":"","headcount":"","reg_address":"","working_address":"","telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"0.0","purchase_freq":"0","company_nature":4,"client_class":1,"client_industry":20,"client_type":1,"sales_rep":5493,"main_contact":"","created_by":5495,"created_at":"2026-05-27 17:25:00","updated_at":"2026-05-27 17:32:47","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"","en_name":"","pick_at":"2026-05-27 17:25:00","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":0,"client_key_info_count":0,"contact_count":0,"visit_count":0,"cooperate_count":1,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":false,"from_contact":"","tax_no":"","is_public":1,"lost_contact_days":"","last_arrive_days":"","last_contact":"","last_arrive":"","notice_days":10,"score":"6","workingAddress":"","clientType":{"id":1,"key":1,"name":"\u6700\u7ec8\u7528\u6237"},"clientClass":{"id":1,"key":1,"name":"A\u7ea7\u5ba2\u6237","notice_days":10,"color":"#D2456D","visit_base":7},"companyNature":{"id":4,"key":4,"name":"\u79c1\u8425\u4f01\u4e1a"},"clientIndustry":{"id":20,"key":20,"name":"\u5176\u4ed6"},"salesRep":{"id":5493,"key":5493,"name":"97289742","sex":"M","client_lock":false,"avatar":{}},"clientFrom":{},"unCloseCases":[],"createdBy":{"id":5495,"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","sex":"F","department_id":4,"avatar":{},"department":{"id":4,"key":4,"name":"\u5546\u52a1\u90e8"}},"workLogCount":"","caseCount":"","salesTimeCount":"","implementTimeCount":"","presalesTimeCount":"","engineerTimeCount":"","reimbursementAmountSum":"","addresses":[],"contacts":[{"id":1,"name":"1","email":"","pinyin_shortcut":"1","sex":"F","birth_date":"","department":"","job_position":"","mobile":"11111111111","telephone":"","client_id":1,"supplier_id":"","created_by":5495,"created_at":"2026-05-27 17:25:00","updated_at":"2026-05-27 17:25:00","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"","pinyin2":"","pinyin3":"","pinyin4":"","namecut1":"1","namecut2":"","namecut3":"","namecut4":"","is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5495,"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","sex":"F","user_status":"1"},"mobiles":[{"id":1,"contact_id":1,"mobile":"11111111111","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""}],"commentCount":{},"unreadComments":{},"fromContact":"","workingAddresses":[],"schedules":[],"cooperatedProjects":[{"id":1,"client_id":1}],"unread":0,"lost_contact_days_display":"","last_arrive_days_display":"","bgcolor":"#D2456D","overdue_display":"","last_arrive_overdue_display":"","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"object_type":10,"cooperated":true,"counts":{"id":1,"name":"\u903b\u8f91\u6d4b\u8bd5-\u9500\u552e\u5408\u540c","sales_rep":5493,"status3_budgets":"10000","status3_profits":"6000.0000000000000000","status3_count":1,"status3_pct":60,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":0,"ircount":0,"service_time":"0","service_count":0,"sales_rep_time":"2\u5929","created_at":"2026-05-27 17:25:00","work_time":0,"work_count":0,"last_bargain_date":"2026-05-27","reimbursement_amount":0,"points":0,"cooperated":true,"client_industry":"\u5176\u4ed6","client_industry_id":20,"sales_rep_display":"97289742","uncollected":"10000"},"budgetCounts":[{"product_type_id":1,"key":1,"name":"\u9632\u706b\u5899","sum_budget":"10000","sum_profit":"6000","y":100}],"implementTimes":[],"salesTimes":[],"extra":0,"can_view_implement":true,"can_view_work_log":true,"can_view_poejct":true},"options":{"Clients[sales_rep]":{"key":"Clients[sales_rep]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5493,"name":"97289742"},{"key":"0","name":"\u516c\u6d77\u5ba2\u6237"}],"default":""},"Clients[client_industry]":{"key":"Clients[client_industry]","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":1,"name":"\u653f\u5e9c"},{"key":2,"name":"\u6559\u80b2"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"}]},"Clients[company_nature]":{"key":"Clients[company_nature]","name":"\u516c\u53f8\u6027\u8d28","value":[{"key":1,"name":"\u56fd\u6709\u4f01\u4e1a"},{"key":2,"name":"\u4e8b\u4e1a\u5355\u4f4d"},{"key":3,"name":"\u519b\u5de5\u4f01\u4e1a"},{"key":4,"name":"\u79c1\u8425\u4f01\u4e1a"},{"key":5,"name":"\u4e0a\u5e02\u516c\u53f8"},{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},"Clients[client_class]":{"key":"Clients[client_class]","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":1,"name":"A\u7ea7\u5ba2\u6237"},{"key":2,"name":"B\u7ea7\u5ba2\u6237"},{"key":3,"name":"C\u7ea7\u5ba2\u6237"}]},"Clients[client_type]":{"key":"Clients[client_type]","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u6700\u7ec8\u7528\u6237"},{"key":2,"name":"\u8f6f\u4ef6\u5382\u5546"},{"key":3,"name":"\u786c\u4ef6\u5382\u5546"},{"key":4,"name":"\u8f6f\u4ef6\u5f00\u53d1\u5546"},{"key":5,"name":"\u7cfb\u7edf\u96c6\u6210\u5546"},{"key":6,"name":"\u4ea7\u54c1\u4ee3\u7406\u5546"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"43.224.72.82","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-05-29 17:58:41', 55579904) RETURNING "id"
17:58:41.5300.6 msyii\db\Command::querySELECT product_type_id, product_type_id as key, name, sum(budget) as sum_budget, sum(budget * pct / 100) as sum_profit FROM "o6a13e2c574d5a"."tbl_project_product_types" "pt" WHERE "project_id" IN (SELECT "id" FROM "o6a13e2c574d5a"."tbl_projects" WHERE ("project_status"=3) AND ("client_id"=1)) GROUP BY "product_type_id", "name"
17:58:41.5020.6 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=5495
17:58:41.5190.5 msyii\db\Command::querySELECT s.id, client_id, project_id, schedule_title, complete_at, start_at, end_at, created_by, is_complete, is_closed, complete_description, set_top_at, CASE WHEN is_complete = true THEN 3 WHEN is_complete = false AND end_at <= NOW() THEN 2 ELSE 1 END AS sort FROM "o6a13e2c574d5a"."tbl_schedules" "s" LEFT JOIN "o6a13e2c574d5a"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2026-05-15')) AND ((("is_public"=1) AND ("created_by" != 5495)) OR ("created_by"=5495) OR ("ccr"."user_id"=5495)) AND ("s"."client_id"=1) ORDER BY set_top_at DESC nulls last, sort ASC, CASE when is_complete = true then complete_at END desc, CASE when is_complete = false then end_at END asc, end_at DESC
17:58:41.5130.5 msyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."client_id"=1) GROUP BY "c"."client_id"
17:58:41.5350.5 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE ("id"=5493) AND ("user_status"='1') AND ("client_lock"=FALSE) 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
17:58:41.5120.4 msyii\db\Command::querySELECT "client_id", count(id) as count FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=1) GROUP BY "client_id"
17:58:41.5140.4 msyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "o6a13e2c574d5a"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."client_id"=1) GROUP BY "c"."client_id"
17:58:41.5030.4 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
17:58:41.5170.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"
17:58:41.5200.4 msyii\db\Command::querySELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_clients" "c" WHERE (("c"."sales_rep"=5493) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "o6a13e2c574d5a"."tbl_user_visit_clients" WHERE "user_id"=5495))) AND ("c"."id"=1))
17:58:41.5340.4 msyii\db\Command::querySELECT w.scenario_option_id, w.scenario_option_id as key, wso.name, count(w.id) as value FROM "o6a13e2c574d5a"."tbl_work_logs" "w" LEFT JOIN "o6a13e2c574d5a"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND ("w"."scenario_id"=1) AND ("w"."client_id"=1) GROUP BY "w"."scenario_option_id", "wso"."name"
17:58:41.5200.3 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
17:58:41.5130.3 msyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("client_id"=1) GROUP BY "client_id"
17:58:41.5140.3 msyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "o6a13e2c574d5a"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=1) GROUP BY "client_id"
17:58:41.5350.2 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_types" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order"
17:58:41.5100.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"
17:58:41.5010.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:58:41.5080.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_types" WHERE "id"=1
17:58:41.5370.2 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_visit_object_histories" WHERE ("user_id"=5495) AND ("object_type"=10) AND ("object_id"='1')
17:58:41.5550.2 msyii\db\Command::querySELECT "id" FROM "o6a13e2c574d5a"."tbl_visit_object_histories" WHERE "user_id"=5495 ORDER BY "last_visit_at" DESC LIMIT 10
17:58:41.5170.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (61, 162, 2100000000, 71, 93)) ORDER BY "sort"
17:58:41.5150.2 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_contacts" WHERE "client_id"=1
17:58:41.5360.2 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_company_natures" WHERE ("is_delete"=FALSE) OR ("id"=4) ORDER BY "order"
17:58:41.5360.2 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_classes" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order"
17:58:41.5110.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
17:58:41.5110.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5495)
17:58:41.5360.2 msyii\db\Command::querySELECT "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_industries" WHERE ("is_delete"=FALSE) OR ("id"=20) ORDER BY "order"
17:58:41.5100.2 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5493)
17:58:41.5160.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
17:58:41.5150.2 msyii\db\Command::querySELECT "client_id", sum(amount) AS sum FROM "o6a13e2c574d5a"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id"=1) GROUP BY "client_id"
17:58:41.5180.2 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "o6a13e2c574d5a"."tbl_unread_comments" WHERE ("object_type"=10) AND (("remind_user_id"=5495) AND ("is_read"=FALSE)) AND ("object_id"=1) GROUP BY "object_id"
17:58:41.5160.2 msyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "o6a13e2c574d5a"."tbl_contact_statuses" WHERE "id"=2
17:58:41.5090.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "o6a13e2c574d5a"."tbl_client_classes" WHERE "id"=1
17:58:41.5120.2 msyii\db\Command::querySELECT "client_id", count(id) as count FROM "o6a13e2c574d5a"."tbl_cases" WHERE "client_id"=1 GROUP BY "client_id"
17:58:41.5190.2 msyii\db\Command::querySELECT "id", "client_id" FROM "o6a13e2c574d5a"."tbl_projects" WHERE ("project_status"='3') AND ("client_id"=1)
17:58:41.5160.2 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1
17:58:41.5180.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "o6a13e2c574d5a"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=1) GROUP BY "object_id"
17:58:41.5100.2 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1
17:58:41.5170.2 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_term_taxonomy_relationships" WHERE "object_id"=1
17:58:41.5100.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5493
17:58:41.5110.2 msyii\db\Command::querySELECT "id", "client_id" FROM "o6a13e2c574d5a"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=1)
17:58:41.5560.1 msyii\db\Command::executeDELETE FROM "o6a13e2c574d5a"."tbl_visit_object_histories" WHERE ("id" NOT IN (13, 12, 11, 1, 8, 5, 4, 2)) AND ("user_id"=5495)
17:58:41.5120.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" WHERE "id"=4
17:58:41.5090.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_company_natures" WHERE "id"=4
17:58:41.5090.1 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_client_industries" WHERE "id"=20
17:58:41.5150.1 msyii\db\Command::querySELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "o6a13e2c574d5a"."tbl_client_addresses" WHERE "client_id"=1
17:58:41.5160.1 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_contact_mobiles" WHERE "contact_id"=1
17:58:41.5180.1 msyii\db\Command::querySELECT * FROM "o6a13e2c574d5a"."tbl_client_address_rels" WHERE "client_id"=1