68ae7c79e196d: POST https://beta.jinchangxiao.com/vue/client/get-edit at 2025-08-27 11:33:13 am by 124.64.23.198
Database Queries
总计54条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 11:33:13.927 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 11:33:13.930 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:33:13.935 | 3.8 ms | SELECT | SELECT 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 239::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 239::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 "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_work_logs" "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_client_classes" "cc" ON cc.id = c.client_class WHERE ("c"."id"='399') AND ("deleted"=FALSE) GROUP BY "c"."id", "cc"."id" |
| 11:33:13.940 | 0.5 ms | SELECT | SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE "id"=634 |
| 11:33:13.940 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1 |
| 11:33:13.940 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=43 |
| 11:33:13.941 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=1 |
| 11:33:13.941 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=1 |
| 11:33:13.941 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=1005 |
| 11:33:13.942 | 0.5 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1005) |
| 11:33:13.943 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=399 |
| 11:33:13.943 | 0.5 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (208, 226, 101, 114, 142, 205, 206, 317, 373, 330)) ORDER BY "sort" |
| 11:33:13.944 | 1.1 ms | SELECT | SELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=399) |
| 11:33:13.945 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 11:33:13.945 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 11:33:13.946 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 11:33:13.946 | 0.3 ms | SELECT | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=399) GROUP BY "client_id" |
| 11:33:13.946 | 0.8 ms | SELECT | SELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id"=399 GROUP BY "client_id" |
| 11:33:13.947 | 0.4 ms | SELECT | SELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."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"=399) GROUP BY "client_id" |
| 11:33:13.948 | 5.6 ms | SELECT | SELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."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"=399) GROUP BY "c"."client_id" |
| 11:33:13.954 | 2.3 ms | SELECT | SELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."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"=399) GROUP BY "c"."client_id" |
| 11:33:13.956 | 0.3 ms | SELECT | SELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=399) GROUP BY "client_id" |
| 11:33:13.957 | 1.3 ms | SELECT | SELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (2, 3)) AND ("client_id"=399) GROUP BY "client_id" |
| 11:33:13.958 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id"=399 |
| 11:33:13.959 | 1.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=399 |
| 11:33:13.960 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1) |
| 11:33:13.960 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1016, 1001) |
| 11:33:13.961 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (941, 914, 1259, 1260, 915, 1258) |
| 11:33:13.961 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (941, 914, 1259, 1260, 915, 1258) |
| 11:33:13.962 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (129, 180, 142, 184, 189, 213, 6, 7, 97, 46, 101, 102, 128, 167, 181, 130, 170, 174, 94, 165, 131, 175, 212, 226, 93, 5, 1, 2, 210, 227, 185, 191, 197, 199, 231, 207, 229, 8, 135, 139, 136, 156, 153, 157, 349, 322, 316, 320, 319, 2100000000, 369, 377, 340, 327, 367, 359)) ORDER BY "sort" |
| 11:33:13.963 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (941, 914, 1259, 1260, 915, 1258) |
| 11:33:13.963 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (129, 180, 142, 184, 189, 213, 6, 7, 97, 46, 101, 102, 128, 167, 181, 130, 170, 174, 94, 165, 131, 175, 212, 226, 93, 5, 1, 2, 210, 227, 185, 191, 197, 199, 231, 207, 229, 8, 135, 139, 136, 156, 153, 157, 349, 322, 316, 320, 319, 2100000000, 369, 377, 340, 327, 367, 359)) ORDER BY "sort" |
| 11:33:13.964 | 20.3 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=399) GROUP BY "object_id" |
| 11:33:13.984 | 16.8 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=399) GROUP BY "object_id" |
| 11:33:14.001 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id"=399 |
| 11:33:14.002 | 0.4 ms | SELECT | SELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id"=634) |
| 11:33:14.002 | 1.3 ms | SELECT | SELECT 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 "a57be577deb434"."tbl_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_schedule_carbon_copy_rels" "ccr" ON ccr.schedule_id = s.id WHERE (("is_complete"=FALSE) OR ("complete_at" >= '2025-08-13')) AND ((("is_public"=1) AND ("created_by" != 1001)) OR ("created_by"=1001) OR ("ccr"."user_id"=1001)) AND ("s"."client_id"=399) 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 |
| 11:33:14.004 | 0.5 ms | SELECT | SELECT "id", "client_id" FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"='3') AND ("client_id"=399) |
| 11:33:14.005 | 0.7 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" "c" WHERE (("c"."sales_rep" 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("c"."sales_rep" IS NULL) OR ("c"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND ("c"."id"=399)) |
| 11:33:14.006 | 9.2 ms | SELECT | SELECT 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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."tbl_client_sales_rep_rels" "csrr" WHERE "id" IN (SELECT max(csrrs.id) FROM "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."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 "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."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 "a57be577deb434"."tbl_client_industries" "ci" ON "ci"."id" = "c"."client_industry" LEFT JOIN "a57be577deb434"."tbl_client_types" "ct" ON "ct"."id" = "c"."client_type") "final" WHERE "final"."id"=399 |
| 11:33:14.016 | 2.6 ms | SELECT | SELECT SUM(uncollected) FROM (SELECT sc.*, scp.collected, (sc.amount - scp.collected) as uncollected FROM "a57be577deb434"."tbl_sales_contracts" "sc" LEFT JOIN "a57be577deb434"."tbl_clients" "c" ON sc.client_id = c.id LEFT JOIN (SELECT t0.id AS contract_id, t0.erp_settle_amount AS collected FROM "a57be577deb434"."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" 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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("sales_rep" IS NULL)) AND ("c"."id"=399) GROUP BY "sc"."id", "scp"."collected" ORDER BY "signed_at" DESC) "sub" |
| 11:33:14.019 | 1.1 ms | SELECT | SELECT product_type_id, product_type_id as key, name, sum(budget) as sum_budget, sum(budget * pct / 100) as sum_profit FROM "a57be577deb434"."tbl_project_product_types" "pt" WHERE "project_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_projects" WHERE ("project_status"=3) AND ("client_id"=399)) GROUP BY "product_type_id", "name" |
| 11:33:14.020 | 2.0 ms | SELECT | SELECT product_type_id, product_type_id as key, name, count(it.id) as value FROM "a57be577deb434"."tbl_implement_product_types" "it" WHERE "implement_id" IN (SELECT "id" FROM "a57be577deb434"."tbl_implement_records" WHERE ("is_draft"=FALSE) AND ("client_id"=399)) GROUP BY "product_type_id", "name" |
| 11:33:14.022 | 0.6 ms | SELECT | SELECT w.scenario_option_id, 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_id"=1) AND ("w"."client_id"=399) GROUP BY "w"."scenario_option_id", "wso"."name" |
| 11:33:14.024 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE ("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, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) 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 |
| 11:33:14.025 | 0.3 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order" |
| 11:33:14.025 | 0.2 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE ("is_delete"=FALSE) OR ("id"=43) ORDER BY "order" |
| 11:33:14.025 | 0.2 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order" |
| 11:33:14.026 | 0.2 ms | SELECT | SELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE ("is_delete"=FALSE) OR ("id"=1) ORDER BY "order" |
| 11:33:14.027 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("user_id"=1001) AND ("object_type"=10) AND ("object_id"='399') |
| 11:33:14.028 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_object_histories" SET "last_visit_at"='now()' WHERE "id"=183976 |
| 11:33:14.029 | 0.3 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_visit_object_histories" WHERE "user_id"=1001 ORDER BY "last_visit_at" DESC LIMIT 10 |
| 11:33:14.029 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("id" NOT IN (183976, 183962, 183975, 183968, 183967, 183974, 183973, 183972, 183971, 183970)) AND ("user_id"=1001) |
| 11:33:14.029 | 2.1 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/client/get-edit', '{"id":"399","web_access_token":"GwzcwQPxiTG2B3PUDaCrV_Wl4I70m3do"}', '{"code":2000,"result":{"model":{"id":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","abbr":"","pinyin_shortcut":"gabdyyjszdgdgs","description":"","corp_rep":"\u9648\u671d\u6b66","website":"","capital":"18000","established_at":"1992-06-23","headcount":"","reg_address":"","working_address":634,"telephone":"","fax":"","scale":"","branch":"","purchase_scale_per_yr":"","purchase_freq":"","company_nature":1,"client_class":43,"client_industry":1,"client_type":1,"sales_rep":1005,"main_contact":"","created_by":1001,"created_at":"2017-07-04 15:14:12","updated_at":"2025-02-18 16:09:39","main_business":"","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":"\/files\/cdn\/a57be577deb434\/logo\/6fc2ad20-226c-311c-9f64-96f95d6c6bdd.png","en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"","deployment_mode":"","it_per_num":"","public_relations_difficulty":"","it_status":"","decision_process":"","coach":"","competitor":"","peers":"","supplier":"","main_product":"","client_base_info_count":4,"client_key_info_count":0,"contact_count":4,"visit_count":0,"cooperate_count":0,"case_pre_sales_count":0,"case_implement_count":0,"is_overdue_remind":true,"from_contact":"","tax_no":"","is_public":1,"lost_contact_days":"2126.03974464215","last_arrive_days":"","last_contact":"2019-11-01 10:36:00","last_arrive":"","notice_days":60,"score":"21","workingAddress":{"id":634,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","address1":"","address2":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.325307,39.937349)","created_by":5064,"created_at":"2017-09-05 09:16:56","updated_at":"2024-06-27 15:32:14","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.325307","lat":"39.937349"},"clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":43,"key":43,"name":"\u6f5c\u529b\u5ba2\u6237","notice_days":60,"color":"#1EE6DC","visit_base":15},"companyNature":{"id":1,"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},"clientIndustry":{"id":1,"key":1,"name":"\u653f\u5e9c"},"salesRep":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","client_lock":false,"avatar":{"id":16,"user_id":1005,"name":"\/files\/cdn\/a57be577deb434\/avatar\/56876dde-37eb-39fc-853a-47eaef6510e5.png"}},"clientFrom":{},"unCloseCases":[],"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"workLogCount":{"client_id":399,"count":11},"caseCount":{"client_id":399,"count":11},"salesTimeCount":"","implementTimeCount":{"client_id":399,"sum":"22.25","times":"10"},"presalesTimeCount":{"client_id":399,"sum":"7","times":"1"},"engineerTimeCount":{"client_id":399,"hours":"0.5","times":1},"reimbursementAmountSum":"","addresses":[{"id":510,"key":510,"name":"\u5317\u4eac\u5e02\u6d77\u6dc0\u533a\u7518\u5bb6\u53e3\u8857\u9053\u9996\u90fd\u4f53\u80b2\u9986\u5357\u8def\u9996\u4f53\u5357\u8def","client_id":399},{"id":1884,"key":1884,"name":"\u6d4b\u8bd5","client_id":399}],"contacts":[{"id":941,"name":"\u5b89\u6770","email":"","pinyin_shortcut":"aj","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1016,"created_at":"2017-07-11 15:58:21","updated_at":"2022-03-14 10:45:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"an","pinyin2":"jie","pinyin3":"","pinyin4":"","namecut1":"\u5b89","namecut2":"\u6770","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[{"id":933,"contact_id":941,"mobile":"13522582788","mp_open_id":""}],"contactKeyRoles":[],"contactAttitude":""},{"id":914,"name":"\u90b1\u65ed\u534e","email":"","pinyin_shortcut":"qxh","sex":"M","birth_date":"","department":"\u4e92\u8054\u7f51","job_position":"\u603b\u76d1","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1001,"created_at":"2017-07-04 15:15:07","updated_at":"2022-03-14 10:45:37","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"qiu","pinyin2":"xu","pinyin3":"hua","pinyin4":"","namecut1":"\u90b1","namecut2":"\u65ed","namecut3":"\u534e","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":4391,"contact_id":914,"mobile":"13501108670","mp_open_id":""}],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1259,"name":"\u738b\u6652","email":"","pinyin_shortcut":"ws","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1001,"created_at":"2017-11-06 20:45:09","updated_at":"2022-03-14 10:45:37","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"shai","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u6652","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":""},{"id":1260,"name":"\u738b\u6652","email":"","pinyin_shortcut":"ws","sex":"M","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1001,"created_at":"2017-11-06 20:45:15","updated_at":"2022-03-14 10:45:37","user_status":2,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"shai","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u6652","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":""},{"id":915,"name":"\u738b\u96f7","email":"45695619@qq.com","pinyin_shortcut":"wl","sex":"M","birth_date":"","department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u4e13\u5458","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1001,"created_at":"2017-07-04 15:16:02","updated_at":"2022-03-14 10:45:37","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"lei","pinyin3":"","pinyin4":"","namecut1":"\u738b","namecut2":"\u96f7","namecut3":"","namecut4":"","is_mp_bind":"","contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":1225,"contact_id":915,"mobile":"18701542393","mp_open_id":""}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"}},{"id":1258,"name":"\u738b\u662d\u541b","email":"","pinyin_shortcut":"wzj","sex":"F","birth_date":"","department":"","job_position":"","mobile":"","telephone":"","client_id":399,"supplier_id":"","created_by":1001,"created_at":"2017-11-06 20:44:00","updated_at":"2022-03-14 10:45:37","user_status":1,"description":"","contact_type":"1","contact_attitude":"","telephone_area_code":"","telephone_extension_number":"","mp_open_id":"","pinyin1":"wang","pinyin2":"zhao","pinyin3":"jun","pinyin4":"","namecut1":"\u738b","namecut2":"\u662d","namecut3":"\u541b","namecut4":"","is_mp_bind":"","contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":""}],"commentCount":{"object_id":399,"comment":4},"unreadComments":{},"fromContact":"","workingAddresses":[{"id":634,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","address1":"","address2":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d77\u6dc0\u533a","zip":"","country":"\u4e2d\u56fd","geolocation":"(116.325307,39.937349)","created_by":5064,"created_at":"2017-09-05 09:16:56","updated_at":"2024-06-27 15:32:14","state_id":110000,"city_id":110100,"region_id":110108,"country_id":1,"lng":"116.325307","lat":"39.937349"}],"schedules":[],"cooperatedProjects":[{"id":263,"client_id":399},{"id":262,"client_id":399}],"unread":0,"lost_contact_days_display":"5\u5e74\u524d","last_arrive_days_display":"","bgcolor":"#1EE6DC","overdue_display":"\u903e\u671f2067\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f2961\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":true,"can_update":true,"can_delete":false,"can_give_up":true,"can_create_contact":true,"can_edit_contact":true,"cooperated":true,"counts":{"id":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)","sales_rep":1005,"status3_budgets":"1297925","status3_profits":"99443.250000000000","status3_count":2,"status3_pct":7.66,"status1_budgets":"0","status1_count":0,"status2_budgets":"0","status2_count":0,"pscount":1,"ircount":10,"service_time":"29.25","service_count":11,"sales_rep_time":"8\u5e741\u4e2a\u670822\u5929","created_at":"2017-07-04 15:14:12","work_time":0,"work_count":0,"last_bargain_date":"2017-06-21","reimbursement_amount":0,"points":"60","cooperated":true,"client_industry":"\u653f\u5e9c","client_industry_id":1,"sales_rep_display":"\u8d75\u6657\u7131","uncollected":0},"budgetCounts":[{"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","sum_budget":"1297925","sum_profit":"99443.25","y":100}],"implementTimes":[{"product_type_id":3,"key":3,"name":"\u5b58\u50a8\u8bbe\u5907","value":3,"y":27.27},{"product_type_id":86,"key":86,"name":"\u8ba1\u7b97","value":3,"y":27.27},{"product_type_id":69,"key":69,"name":"\u5907\u4efd","value":2,"y":18.18},{"product_type_id":78,"key":78,"name":"VMware\u79c1\u6709\u4e91","value":1,"y":9.09},{"product_type_id":85,"key":85,"name":"\u7f51\u7edc","value":1,"y":9.09},{"product_type_id":94,"key":94,"name":"\u6df1\u4fe1\u670dAdesk","value":1,"y":9.09}],"salesTimes":[{"scenario_option_id":2,"key":2,"name":"\u5ba2\u6237\u7535\u8bdd\u6c9f\u901a","value":6,"y":60},{"scenario_option_id":14,"key":14,"name":"\u5ba2\u6237\u6c99\u9f99\u4f1a","value":2,"y":20},{"scenario_option_id":3,"key":3,"name":"\u5ba2\u6237\u89c1\u9762\u6c9f\u901a","value":1,"y":10},{"scenario_option_id":4,"key":4,"name":"\u5ba2\u6237\u5403\u996d","value":1,"y":10}],"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":5332,"name":"\u970d\u536b\u8d85"},{"key":1001,"name":"\u5218\u4eba\u8bda"},{"key":5087,"name":"\u5218\u5fae"},{"key":1013,"name":"\u7fc1\u5bb6\u6210"},{"key":1004,"name":"\u4f0a\u5cfb\u8fb0"},{"key":1005,"name":"\u8d75\u6657\u7131"},{"key":5449,"name":"\u5468\u4e3d\u98de"},{"key":"0","name":"\u516c\u6d77\u5ba2\u6237"}],"default":1001},"Clients[client_industry]":{"key":"Clients[client_industry]","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"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\u4e0a\u5e02"},{"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},{"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},{"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},"Clients[client_class]":{"key":"Clients[client_class]","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},{"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},{"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},{"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"}]},"Clients[client_type]":{"key":"Clients[client_type]","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u653f\u5e9c"},{"key":6,"name":"\u592e\u4f01"},{"key":5,"name":"\u5546\u4e1a"},{"key":3,"name":"\u5916\u4f01"}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-27 11:33:14') RETURNING "id" |