站管家 2026-09-02 DAS 剩余慢查询分析与优化排期

本文是当前调查草稿，目标是让研发、DBA和测试能回答三个问题：某条慢 SQL 服务什么业务、为什么扫描多、先改什么风险最低。文档只记录已经从 DAS 页面或当前代码确认的事实；无法由 SQL 指纹确定的 HTTP 入口会明确写成“业务族/待确认”。

1. 调查范围与证据边界

上一轮 55,344/686 的读数和本次页面 52,256/672 的读数是两个独立快照，不能混成一张排名表。当前页面已经可以读取第 1 页和第 2 页前 11 条的具体 SQL；但本文仍不能写成覆盖 672 个模板的全部明细。

1.1 这份清单如何使用

上一轮“当前剩余所有慢查询”读数为 686 个模板；本次页面读数为 672 个模板。DAS 明细最多展示 200 条，本稿对本次快照只逐条保留执行次数大于 200 的 61 条。每一行的“代码入口”只在代码确实出现对应表/字段/方法时填写；没有当前仓库实现的，明确标记为待确认。

1.2 当前页面复核（第二块屏幕）

本次重新打开的是 DAS 的“查询治理”页面，不是旧的“慢日志分析”页。页面显示时间范围为 2026-09-02 07:40:00～13:40:00（北京时间），统计为 52,256 次慢 SQL、672 个模板；每页设置为 50 条，共 4 页。按执行次数从高到低读取，执行次数大于 200 的模板共 61 条：第 1 页 50 条，加第 2 页前 11 条（第 2 页第 12 条已为 200 以下）。第 3 页最高约 91 次，因此不属于本次清单。

第二块屏幕的现场截图为 /tmp/das-second-screen-check.png，截图中可见第 2 页底部记录的次数为 109～91，证明分页和排序状态已经切换到当前 DAS 页面。随后已从页面 DOM 读取第 1 页 50 条和第 2 页前 11 条的 SQL 单元格；其中第 1 页第 7 条的单元格自身在 16,158 个字符处以 ... 结束，不能从页面声称已取到完整原文。

口径提醒：本节的 52,256/672/61 属于当前页面显示窗口 2026-09-02 07:40～13:40；上一轮 55,344/686 属于历史快照，不能直接混成一张排名表。SQL 中出现的 2026-09-03 是业务查询参数日期，不等于 DAS 慢 SQL 统计窗口日期。

2. 先看结论：哪些最适合先做

2.1 建议优先级

2.2 最重要的判断

平均耗时高不等于缺一个索引。当前数据中同时存在三种问题：

1. 中间结果过大：最终只返回 1～几百行，但付款派生表、复杂 JOIN 先扫描和聚合几十万到几百万行。
2. 业务确实返回很多行：应收、成本价、机器人会话等查询的返回行本身就很大，必须减少传输或改成汇总/分页。
3. 调用模型重复：COUNT 和列表各查一次；一个页面循环多次查同一客户或同一批商品；这些问题不能只靠 SQL 改写解决。

3. 第一页前 50 条分类总表

K 为 DAS 页面显示的千行单位。SQL 文本可能被页面截断，下面使用已识别的表、字段和业务特征，不补写页面没有提供的完整条件。

3.1 前 50 条逐条说明

下表中的“SQL 特征”来自 DAS 当前能读取到的模板摘要；DAS 页面会截断过长 SQL，因此没有把缺失的条件补写成完整 SQL。代码入口是已经在当前仓库或 www/saas 兄弟仓库中找到的入口；标记“待确认”的条目不能直接安排代码修改。

3.2 当前页面快照：执行次数大于 200 的 61 条

本节是当前页面的独立快照，不与上一轮 55,344/686 的历史读数混排。DAS 页面显示时间范围为 2026-09-02 07:40:00～13:40:00；页面显示 52,256 次慢 SQL、672 个模板；每页 50 条、共 4 页。按执行次数降序读取第 1 页 50 条和第 2 页前 11 条，第 61 条为 201 次，第 62 条已降为 178 次，因此本表的筛选边界为 count > 200，共 61 条。

下面的表只负责展示 61 条的指标和定位，不把它冒充成 SQL 原文。每条原文单独放在第 3.5 节；超长 IN 参数在共享文档中脱敏折叠。指标含义为“最大/平均耗时（秒）”“最大/平均扫描行”“最大/平均返回行”。

3.3 当前 61 条逐条场景、入口和处理建议

下表把“SQL 指纹”映射到实际业务。能在 DGJ2 或兄弟仓库找到代码的，列出文件和方法；只有 SQL 指纹而没有当前仓库入口的，明确标为“待确认”，不得直接开修改分支。验收统一要求：同一参数、同一数据快照下，先比旧/新结果，再比 EXPLAIN、扫描行、临时表和 P95/P99。

3.3.1 61 条 SQL 的接口、脚本、页面入口定位矩阵

这一节回答“这条慢 SQL 到底从哪里发起”。第 3.5 节 按排名保存了 SQL 结构；本节不重复整段 SQL，而是用表名、关键字段和 SQL 族做唯一定位。页面/View 是打开功能页面的入口，前端 JS/请求关键词是从浏览器 Network 找到请求源头的最短路径，Controller → Service → Model 是后端实际调用链。

证据级别必须这样理解：

• 已确认：当前代码中同时找到了 SQL 对应的方法和明确的接口、页面或任务入口。
• 业务族已确认：已经找到同一 Model/Service 或同一表族的多个调用方，但 DAS SQL 被归一化、截断或被多个场景复用，不能诚实地指定唯一页面。
• 待确认：当前 DGJ2 没有对应实现，或 SQL 属于 www/saas/外部服务，必须拿部署版本、完整 SQL 或请求日志继续确认。

#1～#20

#21～#40

#41～#61

3.3.2 从页面定位慢 SQL 请求源头

对于已确认的接口，可以按下面路径复现；“业务族已确认”和“待确认”条目必须先拿到真实请求参数，不能只看表名猜页面。

1. 打开矩阵中的页面 View，对应进入列表、查询、分页、详情或导出动作。
2. 浏览器按 F12 → Network，勾选 Preserve log 后刷新页面；只触发一个动作，避免把多个 SQL 族混在一起。
3. 在 Network 搜索接口关键词：getCustomerAccount、outBoundList、getSalesOrderListNew、getPdBarCode/getPdaSkusByBarcode、getLessReturnGoods、quotationList、fundBalance_detail、customerBalance_detail、salesDetail_detail、deliverSummary、get_receipt_detail_new。
4. 打开请求查看 Request URL、Query/Payload、Response 和 Initiator。重点记录 sid、分页 page/limit、客户/订单/商品 ID、日期、状态条件；这些参数决定了同一 SQL 族实际走哪一分支。
5. 根据 URL 回查 application/controllers，再沿 Controller → Service → Model 跟进。销售/应收优先查 InvSaService、ReceiptService、ReportService；采购查 PoOrderInfoSer；PDA 查 TakeStockSer；机器人查 RobotStat。
6. 在前端按矩阵中的关键词回查 public/js/page、public/js/api、statics/old/js/dist；Initiator 通常能直接显示触发请求的 JS 文件和行号。
7. 如果 Network 没有请求而 DAS 仍有 SQL，检查 application/controllers/tasks、Cron、Supervisor、MQ consumer 和任务日志。#28、#40、#60 属于这个路径；例如 #40 的可执行入口是 php index.php tasks/QuoteGoodsBase/initSettlePrice。
8. 最后用 SQL 的分表后缀、sid、表名和字段反向核对：分表后缀来自 sid 选择逻辑；同一 Model 被多个页面复用时，只能把归属写成“业务族已确认”，直到完整 SQL 参数或应用日志把它收敛到单一请求。

定位时要保留三个边界：DAS 提供的是 SQL 模板和统计指标，不保证带有完整调用栈；SQL 被截断或参数折叠时无法唯一反推页面；一个 Model 方法可以被接口、导出和定时任务共同调用。因此“业务族已确认/待确认”是证据等级，不是遗漏，也不能据此直接修改代码。

3.4 当前快照的优先级结论

3.5 61 条慢查询的具体 SQL 结构（页面原文逐条核对）

上一版只展示了指纹，确实不足以支撑逐条评审。本节根据当前 DAS 页面 DOM 读取到的 SQL 单元格逐条整理。为避免把大批量客户/商品/订单 ID 写入共享文档，长 IN 列表的参数值被折叠；其余 SELECT、FROM、JOIN、WHERE、GROUP BY、ORDER BY、LIMIT 和表达式均保留。这里必须区分“具体 SQL 结构”和“可直接复制执行的完整 SQL”：第 2、3、8、11、35、43、60 条的长参数值在文档中折叠；第 7 条则是 DAS 页面自身在约 16,158 个字符处返回 ...，页面没有提供其完整后半段，不能假装补齐。

#1（5384 次，最大/平均 10.597/1.627 秒）

SELECT a.buId, SUM( CASE WHEN p.stlId IS NULL THEN a.amount WHEN ABS(a.amount) <= ABS(IFNULL(p.amount, 0)) + ABS(IFNULL(p.diffAmount, 0)) THEN 0 ELSE a.amount - IFNULL(p.amount, 0) - IFNULL(p.diffAmount, 0) END ) AS rePayment FROM t_scm_sa_invoice_0_10 AS a LEFT JOIN ( SELECT stlId, SUM(amount) AS amount, SUM(diffAmount) AS diffAmount FROM t_scm_payment_info_10 WHERE isDelete = 0 AND transType IN (150601, 150602) AND buId = 260219 AND sid = 2058 AND billStatus <> 6 GROUP BY stlId ORDER BY NULL ) AS p ON p.stlId = a.id WHERE a.isDelete = 0 AND a.buId = 260219 AND a.sid = 2058 AND a.billStatus <> 6 GROUP BY a.buId

#2（2011 次，最大/平均 17.840/2.612 秒）

SELECT `bf`.`invId`, MAX(`bf`.`id`) AS id FROM t_scm_sa_invoice_info_0_0 AS `bf` LEFT JOIN t_scm_sa_invoice_0_0 AS `cf` ON `bf`.`iid` = `cf`.`id` WHERE bf.sid = 1088 and bf.isDelete = 0 and bf.transType = 150601 and bf.invId IN (/* 原始 SQL 已读取；此处折叠 120 个参数 */) and cf.billStatus<6 GROUP BY `bf`.`invId`

#3（1894 次，最大/平均 6.929/1.866 秒）

select buId, billType, billDate, sum(amount) as amount, sum(diffAmount) as discount, createTime from t_scm_payment_info_29 where isDelete = 0 and billStatus not IN (6) and transType IN (150601,150602) and billType IN ('SALE','RECEIPT') and billDate < "2026-09-01" and sid = 1277 AND buId IN (/* 原始 SQL 已读取；此处折叠 802 个参数 */) group by buId

#4（1720 次，最大/平均 30.711/3.584 秒）

SELECT a.*, c.amount as payment1, c.diffAmount as diffAmount1 FROM t_scm_sa_invoice_0_34 AS a LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_2 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1058 GROUP BY stlId) AS c ON c.stlId = a.id WHERE (a.isDelete=0) and (a.billType="SALE" or a.billType="RECEIPT") and a.buId=152812 and a.sid = 1058 and a.createTime>="2026-09-02 18:00:00" and a.createTime<="2026-09-03 17:59:59" and a.billStatus < 6 order by id

#5（1611 次，最大/平均 20.364/5.252 秒）

SELECT a.*, c.name AS buName, e.name as storeName FROM t_scm_sa_invoice_0_57 AS a LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.type = "-10" AND c.sid IN (1401,1) AND c.isDelete = 0 LEFT JOIN t_bs_store e ON a.storeId = e.id AND e.sid = 1401 WHERE a.isDelete = 0 and a.sid = 1401 and a.transType = 150601 and a.billStatus IN (0,1,2,3,4,5) order by a.createTime desc limit 0,50

#6（1598 次，最大/平均 82.392/3.368 秒）

SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_54 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1078,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1078,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_22 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1078 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_6 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) and (a.id=936104938352672768) and a.billType="SALE"

#7（1555 次，最大/平均 3.724/1.364 秒）

SELECT current.`invId`, current.`locationId`, current.`price` FROM t_bs_cost_price_day_6 AS current INNER JOIN ( SELECT `invId`, `locationId`, MAX(`id`) AS `id` FROM t_bs_cost_price_day_6 WHERE sid = 1078 AND ( invId IN (/* 原始 SQL 已读取；此处折叠 1000 个参数 */) OR invId IN (/* 原始 SQL 已读取；此处折叠 1000 个参数 */) OR invId IN (/* 原始 SQL 已读取；此处折叠 1000 个参数 */) OR invId IN (6284,6308,6317,6319,6320,6321,6322,6323,6324,6327,6328,6330,6331,6332,6333,6334,6335,6336,6337,6338,6339,6340,6341,6342,6343,6344,6349,6350,6352,6353,6354,6355,6356,6357,6358,6359,6360,6362,6364,6365,6366,6367,6368,6370,6371,6372,6373,6374,6375,6376,6378,6379,6380,6382,6383,6384,6385,6386,6387,6388,6390,6393,6394,6396,6397,6398,6399,6400,6401,6402,6404,6405,6407,6408,6411,6412,6413,6414,6416,6419,6420,6421,6423,6424,6425,6426,6427,6428,6430,6431,6432,6433,6434,6435,6436,6437,6438,6439,6440,6441,6442,6443,6444,6445,6446,6447,6448,6449,6450,6451,6452,6453,6454,6455,6456,6457,6458,6459,6460,6461,6462,6463,6464,6465,6467,6470,6472,6473,6474,6475,6476,6477,6478,6479,6480,6481,6482,6483,6484,6485,6486,6487,6488,6489,6490,6491,6492,6493,6494,6496,6497,6498,6499,6500,6501,6503,6505,6506,6508,6509,6510,6511,6512,6514,6515,6516,6518,6519,6520,6521,6522,6523,6524,6525,6526,6527,6528,6529,6531,6532,6534,6535,6537,6539,6540,6541,6542,6543,6544,6545,6548,6551,6552,6553,6554,6555,6556,6557,6558,6559,6560,6561,6562,6563,6564,6565,6566...

#8（1080 次，最大/平均 3.629/1.471 秒）

SELECT buId, billType, billDate, sum(amount) as amount, createTime FROM t_scm_pu_invoice_24 WHERE isDelete = 0 AND billType IN ('PUR', 'PAYMENT') and billDate < "2026-09-01" and sid = 1560 AND buId IN (/* 原始 SQL 已读取；此处折叠 486 个参数 */) group by buId

#9（990 次，最大/平均 16.292/3.703 秒）

SELECT count(1) count from( SELECT * FROM t_scm_sa_invoice_0_19 WHERE sid = 1043 and transType = 150601 and billStatus IN (1,2,3) and sourceType < 2 and isDelete = 0 and billDate <= "2026-09-03" ) count

#10（980 次，最大/平均 71.301/2.921 秒）

SELECT a.*, c.amount as payment1, c.diffAmount as diffAmount1 FROM t_scm_sa_invoice_0_54 AS a LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_22 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1078 GROUP BY stlId) AS c ON c.stlId = a.id WHERE (a.isDelete=0) and (a.billType="SALE" or a.billType="RECEIPT") and a.buId=100162 and a.sid = 1078 and a.billDate>="2026-08-01" and a.billDate<="2026-08-31" and a.billStatus < 6 order by id

#11（860 次，最大/平均 14.878/2.809 秒）

SELECT `sa`.`id` FROM `t_scm_sa_order_15` as `sa` LEFT JOIN `t_scm_sa_order_info_15` as `info` ON `info`.`iid` = `sa`.`id` WHERE `sa`.`sid` = '1263' AND `info`.`invId` IN (/* 原始 SQL 已读取；此处折叠 28 个参数 */) AND `billStatus` IN (0, 1) AND `sa`.`isDelete` =0 AND `sa`.`transType` = 170502 GROUP BY `sa`.`id`

#12（844 次，最大/平均 30.800/7.871 秒）

SELECT count(1) count from( SELECT a.*, c.name AS buName, IFNULL(d.payAmount,0) AS payAmount,IFNULL(d.diffAmount,0) AS diffAmount, e.name as storeName FROM t_scm_sa_invoice_0_19 AS a LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.type = "-10" AND c.sid IN (1171,1) AND c.isDelete = 0 LEFT JOIN (SELECT SQL_BIG_RESULT SUM(IFNULL(amount,0)) as payAmount,SUM(IFNULL(diffAmount,0)) as diffAmount,stlId FROM t_scm_payment_info_19 WHERE isDelete = 0 and billStatus <> 6 and sid = 1171 and transType IN (150601,150602) GROUP BY stlId order by null) AS d ON a.id = d.stlId LEFT JOIN t_bs_store e ON a.storeId = e.id AND e.sid = 1171 WHERE a.isDelete = 0 and a.sid = 1171 and a.buId = 425907 and a.billDate >="2026-08-01" and a.billDate <="2026-08-31" and a.transType = 150601 and a.billStatus IN (4,0) and (abs(a.amount) > (abs(d.payAmount)+abs(d.diffAmount)) || (abs(a.rpAmount) + abs(IFNULL(d.diffAmount,0)) + abs(IFNULL(d.payAmount,0))) = 0) ) count

#13（821 次，最大/平均 30.741/6.416 秒）

SELECT a.*, c.name AS buName, IFNULL(d.payAmount,0) AS payAmount,IFNULL(d.diffAmount,0) AS diffAmount, e.name as storeName FROM t_scm_sa_invoice_0_19 AS a LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.type = "-10" AND c.sid IN (1171,1) AND c.isDelete = 0 LEFT JOIN (SELECT SQL_BIG_RESULT SUM(IFNULL(amount,0)) as payAmount,SUM(IFNULL(diffAmount,0)) as diffAmount,stlId FROM t_scm_payment_info_19 WHERE isDelete = 0 and billStatus <> 6 and sid = 1171 and transType IN (150601,150602) GROUP BY stlId order by null) AS d ON a.id = d.stlId LEFT JOIN t_bs_store e ON a.storeId = e.id AND e.sid = 1171 WHERE a.isDelete = 0 and a.sid = 1171 and a.buId = 425907 and a.billDate >="2026-08-01" and a.billDate <="2026-08-31" and a.transType = 150601 and a.billStatus IN (4,0) and (abs(a.amount) > (abs(d.payAmount)+abs(d.diffAmount)) || (abs(a.rpAmount) + abs(IFNULL(d.diffAmount,0)) + abs(IFNULL(d.payAmount,0))) = 0) order by a.createTime desc limit 0,50

#14（819 次，最大/平均 8.591/2.600 秒）

select id,order_id,inv_id,sku_id,goods_name,goods_img,category_name,`number`,refund_number,price,location_area_id,create_time,modify_time from t_sale_order_detail where (231644 <= id AND id < 463287)

#15（819 次，最大/平均 7.879/2.322 秒）

select id,sid,contact_id,user_id,order_no,order_type,`status`,order_amount,order_number,refund_number,create_time,modify_time from t_sale_order where (231647 <= id AND id < 463290)

#16（794 次，最大/平均 6.018/1.426 秒）

SELECT * FROM t_scm_po_order_info_0 WHERE (sid = 1088 and srcOrderEntryId <>0)

#17（712 次，最大/平均 1.820/1.251 秒）

select count(*) as count from (SELECT a.barCode, a.itemCode, a.companyCode, a.quantityUM, b.id AS invId, b.number, b.brandName, b.skuId, b.productCode, b. NAME, b.spec, b.packSpec, b.unitName, b.minNum AS qty FROM t_bs_goods_barcode AS a LEFT JOIN t_bs_goods AS b ON a.itemCode = b.skuId WHERE b.sid = 1 /*AND a.companyCode = "1001"*/ and (a.barcode like '%75w-90%' or a.itemCode like '%75w-90%' or b.skuId like '%75w-90%' or b.number like '%75w-90%') GROUP BY b.id ) as a

#18（695 次，最大/平均 41.216/5.404 秒）

SELECT count(1) count from( SELECT a.*, a.invName AS goods, aa.orderType, aa.orderCate, b. NAME AS baseName, b.number AS invNumber, b.spec AS invSpec, b. STATUS AS goodsStatus, b.unitName AS mainUnit, b.minNum, b.packSpec, b.brandName, b.saleModel, b.categoryId, IFNULL(c.lockNum, 0) lockNum, IFNULL(d.inQty, 0) inQty, IFNULL(c.closeQty, 0) closeQty FROM t_scm_po_order_info_20 AS a LEFT JOIN t_scm_po_order AS aa ON a.iid = aa.id LEFT JOIN ( SELECT id, NAME, number, spec, skuId, unitName, minNum, packSpec, STATUS, brandName, categoryId, saleModel, productCode, isDelete, isBadReturn FROM t_bs_goods WHERE (isDelete = 0) AND sid = 1 ) AS b ON a.invId = b.id LEFT JOIN ( SELECT SUM(a.qty) AS lockNum,a.srcOrderEntryId,SUM(closeQty) AS closeQty FROM t_scm_po_order_info_20 AS a LEFT JOIN t_scm_po_order AS b ON b.id = a.iid and b.sid = 1140 and b.isDelete = 0 LEFT JOIN ( SELECT isGift, invId,iid, srcOrderId, abs(SUM(qty)) closeQty FROM t_scm_po_close_info WHERE (isDelete = 0) AND sid = 1140 AND qty < 0 GROUP BY isGift, srcOrderId, invId ) AS e ON a.invId = e.invId AND b.id = e.iid AND IFNULL(e.closeQty, 0) > 0 where a.sid = 1140 and a.isDelete = 0 and b.billStatus IN (1,2,3,5,11) and b.orderType !='30-Cxx-17' GROUP BY a.srcOrderEntryId ) AS c ON c.srcOrderEntryId = a.id LEFT JOIN ( SELECT isGift, invId, srcOrderId, SUM(qty) inQty FROM t_scm_pu_invoice_info_20 WHERE (isDelete = 0) AND sid = 1140 GROUP BY isGift, srcOrderId, invId ) AS d ON a.invId = d.invId AND a.iid = d.srcOrderId AND a.isGift = d.isGift WHERE (a.isDelete = 0 AND aa.sid = 1140) AND a.sid = 1140 AND a.transType = 170401 AND b.isDelete = 0 AND IFNULL(d.inQty, 0) > 0 and b.isBadReturn = 0 and a.skuId = "1211110171" and aa.orderType not IN ('30-01','30-Cxx-75') HAVING lockNum+inQty+closeQty>0 order by a.id desc ) count

#19（660 次，最大/平均 10.233/3.559 秒）

SELECT a.barCode, a.itemCode, a.companyCode, a.quantityUM, b.id AS invId, b.number, b.brandName, b.skuId, b.productCode, b. NAME, b.spec, b.packSpec, b.unitName, b.minNum AS qty FROM t_bs_goods_barcode AS a LEFT JOIN t_bs_goods AS b ON a.itemCode = b.skuId WHERE b.sid = 1 /*AND a.companyCode = "1001"*/ and (a.barcode like '%b102010609%' or a.itemCode like '%b102010609%' or b.skuId like '%b102010609%' or b.number like '%b102010609%') GROUP BY b.id limit 0,10

#20（621 次，最大/平均 41.652/4.956 秒）

SELECT a.*, a.invName AS goods, aa.orderType, aa.orderCate, b. NAME AS baseName, b.number AS invNumber, b.spec AS invSpec, b. STATUS AS goodsStatus, b.unitName AS mainUnit, b.minNum, b.packSpec, b.brandName, b.saleModel, b.categoryId, IFNULL(c.lockNum, 0) lockNum, IFNULL(d.inQty, 0) inQty, IFNULL(c.closeQty, 0) closeQty FROM t_scm_po_order_info_27 AS a LEFT JOIN t_scm_po_order AS aa ON a.iid = aa.id LEFT JOIN ( SELECT id, NAME, number, spec, skuId, unitName, minNum, packSpec, STATUS, brandName, categoryId, saleModel, productCode, isDelete, isBadReturn FROM t_bs_goods WHERE (isDelete = 0) AND sid = 1 ) AS b ON a.invId = b.id LEFT JOIN ( SELECT SUM(a.qty) AS lockNum,a.srcOrderEntryId,SUM(closeQty) AS closeQty FROM t_scm_po_order_info_27 AS a LEFT JOIN t_scm_po_order AS b ON b.id = a.iid and b.sid = 1915 and b.isDelete = 0 LEFT JOIN ( SELECT isGift, invId,iid, srcOrderId, abs(SUM(qty)) closeQty FROM t_scm_po_close_info WHERE (isDelete = 0) AND sid = 1915 AND qty < 0 GROUP BY isGift, srcOrderId, invId ) AS e ON a.invId = e.invId AND b.id = e.iid AND IFNULL(e.closeQty, 0) > 0 where a.sid = 1915 and a.isDelete = 0 and b.billStatus IN (1,2,3,5,11) and b.orderType !='30-Cxx-17' GROUP BY a.srcOrderEntryId ) AS c ON c.srcOrderEntryId = a.id LEFT JOIN ( SELECT isGift, invId, srcOrderId, SUM(qty) inQty FROM t_scm_pu_invoice_info_27 WHERE (isDelete = 0) AND sid = 1915 GROUP BY isGift, srcOrderId, invId ) AS d ON a.invId = d.invId AND a.iid = d.srcOrderId AND a.isGift = d.isGift WHERE (a.isDelete = 0 AND aa.sid = 1915) AND a.sid = 1915 AND a.transType = 170401 AND b.isDelete = 0 AND IFNULL(d.inQty, 0) > 0 and b.isBadReturn = 0 and a.skuId = "B101010665" and aa.orderType not IN ('30-01','30-Cxx-75') HAVING lockNum+inQty+closeQty>0 order by a.id desc limit 0,20

#21（604 次，最大/平均 1.671/1.081 秒）

SELECT a.barCode, a.quantityUM, a.itemCode, a.companyCode, b.id as invId, b.number, b.brandName, b.skuId, b. NAME, b.spec, b.productCode, b.categoryName, group_concat(distinct a.barCode) as barcodes, b.minNum as qty FROM t_bs_goods AS b LEFT JOIN t_bs_goods_barcode AS a ON a.itemCode = b.skuId /* AND b.isDelete = 0*/ WHERE b.sid = 1 /*and a.companyCode = '1001' */ and (a.barcode IN ('6941743530710','06941743530710') OR a.itemCode = '6941743530710') GROUP BY a.itemCode HAVING a.itemCode IS NOT NULL ORDER BY a.companyCode asc, a.itemCode DESC

#22（584 次，最大/平均 45.025/3.175 秒）

SELECT count(1) count from( SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_40 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (2792,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (2792,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_8 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 2792 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_8 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-09-01" AND a.billDate<="2026-09-03" AND a.sid = 2792 and a.billNo_type = 0 and a.transType=150602 ) count

#23（583 次，最大/平均 18.356/4.293 秒）

SELECT COUNT(DISTINCT a.buId) AS total FROM t_scm_sa_invoice_0_45 a LEFT JOIN (SELECT d.source_order_id FROM t_bs_statement_bill_detail_v2_45 d INNER JOIN t_bs_statement_bill_v2_45 b ON b.id = d.bill_id WHERE d.is_delete = 0 AND d.source_type IN ('150601', '150602') AND b.sid = 2861 AND b.is_delete = 0 AND b.robot_status = 1 AND b.start_time <= '2026-09-03 19:08:59' AND b.end_time >= '2026-09-02 17:30:00' GROUP BY d.source_order_id) already_sent ON already_sent.source_order_id = CAST(a.id AS CHAR) WHERE a.isDelete = 0 AND a.sid = 2861 AND (a.billType = 'SALE' OR a.billType = 'RECEIPT') AND a.billStatus <> 6 AND a.createTime >= '2026-09-02 17:30:00' AND a.createTime <= '2026-09-03 19:08:59' AND already_sent.source_order_id IS NULL

#24（539 次，最大/平均 21.463/3.932 秒）

SELECT a.buId AS contact_id FROM t_scm_sa_invoice_0_21 a LEFT JOIN (SELECT d.source_order_id FROM t_bs_statement_bill_detail_v2_21 d INNER JOIN t_bs_statement_bill_v2_21 b ON b.id = d.bill_id WHERE d.is_delete = 0 AND d.source_type IN ('150601', '150602') AND b.sid = 2517 AND b.is_delete = 0 AND b.robot_status = 1 AND b.start_time <= '2026-08-31 23:59:59' AND b.end_time >= '2026-08-01 00:00:00' GROUP BY d.source_order_id) already_sent ON already_sent.source_order_id = CAST(a.id AS CHAR) WHERE a.isDelete = 0 AND a.sid = 2517 AND (a.billType = 'SALE' OR a.billType = 'RECEIPT') AND a.billStatus <> 6 AND a.createTime >= '2026-08-01 00:00:00' AND a.createTime <= '2026-08-31 23:59:59' AND already_sent.source_order_id IS NULL GROUP BY a.buId ORDER BY a.buId ASC LIMIT 0, 100

#25（514 次，最大/平均 24.722/2.900 秒）

SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_19 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1171,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1171,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_19 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1171 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_3 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-09-01" AND a.billDate<="2026-09-03" AND a.sid = 1171 and a.billNo_type = 0 and a.transType=150602 order by a.id DESC limit 0,100

#26（503 次，最大/平均 21.866/3.151 秒）

SELECT count(1) count from( SELECT a.*,b.name AS contactName,b.number AS contactNumber,b.cCategory AS cCategory,b.cCategoryName AS cCategoryName,b.number as contactNo, e.srcOrderNo as nid, e.billNo as wid, e.outBillNo, c.amount as payment1 FROM t_scm_pu_invoice_17 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "10" AND b.sid IN (1489,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1489,1) AND d.isDelete = 0 LEFT JOIN (SELECT distinct(iid),srcOrderEntryId,srcOrderNo,invId,srcOrderId FROM t_scm_pu_invoice_info_17 where isDelete=0 and sid = 1489 group by iid) AS g ON g.iid=a.id LEFT JOIN t_scm_po_out_info_17 AS e ON e.id = g.srcOrderEntryId and g.invId = e.invId and e.sid = 1489 LEFT JOIN (SELECT sum(amount) as amount ,stlId FROM t_scm_payment_info_17 WHERE isDelete=0 and sid = 1489 and billType="PAYMENT" GROUP BY stlId) AS c ON c.stlId = a.id WHERE (a.isDelete=0) and a.billType="PUR" and a.sid = 1489 and a.billDate>="2026-09-01" and a.billDate<="2026-09-03" and a.transType=150501 ) count

#27（497 次，最大/平均 19.079/1.136 秒）

SELECT * FROM `t_scm_robot_conversation` WHERE `status` = 1

#28（489 次，最大/平均 1.973/1.146 秒）

UPDATE t_quote_goods_base_8 b JOIN tmp_guidance_batch x ON x.base_id=b.id SET b.low_price=x.target_price, b.guide_price=x.target_price WHERE b.guide_plan_id=0 AND b.sid=x.sid AND b.inv_id=x.inv_id AND b.sku_id=x.sku_id AND b.low_price=x.old_low AND b.guide_price=x.old_guide

#29（461 次，最大/平均 56.010/2.885 秒）

SELECT count(1) count from( SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_22 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1622,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1622,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_22 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1622 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_6 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-08-01" AND a.billDate<="2026-09-03" AND a.sid = 1622 and a.transType=150602 AND (b.name LIKE "%途虎工厂店%" OR a.description LIKE "%途虎工厂店%" OR a.userName LIKE "%途虎工厂店%" OR a.billNo LIKE "%途虎工厂店%") ) count

#30（428 次，最大/平均 52.119/2.864 秒）

SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_22 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1622,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1622,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_22 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1622 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_6 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-08-01" AND a.billDate<="2026-09-03" AND a.sid = 1622 and a.transType=150602 AND (b.name LIKE "%途虎工厂店%" OR a.description LIKE "%途虎工厂店%" OR a.userName LIKE "%途虎工厂店%" OR a.billNo LIKE "%途虎工厂店%") order by a.id DESC limit 0,100

#31（420 次，最大/平均 28.526/3.397 秒）

SELECT a.id,a.billNo,a.billDate,a.buId,a.transType,a.totalAmount,a.amount,IFNULL(a.billNo_type,0),b.wayId,b.reAmount,b.diffAmount, c.name AS buName, a.storeId, a.wayId as orderWayId,a.sourceType FROM t_scm_sa_invoice_0_43 AS a LEFT JOIN ( SELECT buId, stlId,wayId, sum(amount) reAmount, sum(diffAmount) diffAmount FROM t_scm_payment_info_11 WHERE sid = 1003 AND isDelete = 0 and transType IN (150601,150602) and billStatus <> 6 GROUP BY stlId,wayId ) as b on a.id = b.stlId LEFT JOIN t_bs_contact c ON a.buId = c.id where a.sid = 1003 and a.isDelete = 0 and a.billStatus < 6 and c.customType = 0 and a.buId=146433 and a.billDate>="2026-08-01" and a.billDate<="2026-08-31" ORDER BY a.billDate DESC

#32（388 次，最大/平均 22.294/2.934 秒）

SELECT a.*,b.name AS contactName,b.number AS contactNumber,b.cCategory AS cCategory,b.cCategoryName AS cCategoryName,b.number as contactNo, e.srcOrderNo as nid, e.billNo as wid, e.outBillNo, c.amount as payment1 FROM t_scm_pu_invoice_17 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "10" AND b.sid IN (1489,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1489,1) AND d.isDelete = 0 LEFT JOIN (SELECT distinct(iid),srcOrderEntryId,srcOrderNo,invId,srcOrderId FROM t_scm_pu_invoice_info_17 where isDelete=0 and sid = 1489 group by iid) AS g ON g.iid=a.id LEFT JOIN t_scm_po_out_info_17 AS e ON e.id = g.srcOrderEntryId and g.invId = e.invId and e.sid = 1489 LEFT JOIN (SELECT sum(amount) as amount ,stlId FROM t_scm_payment_info_17 WHERE isDelete=0 and sid = 1489 and billType="PAYMENT" GROUP BY stlId) AS c ON c.stlId = a.id WHERE (a.isDelete=0) and a.billType="PUR" and a.sid = 1489 and a.billDate>="2026-09-01" and a.billDate<="2026-09-03" and a.transType=150501 order by a.id desc limit 0,100

#33（384 次，最大/平均 69.512/2.841 秒）

SELECT count(1) count from( SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_24 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1560,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1560,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_24 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1560 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_8 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-09-01" AND a.billDate<="2026-09-03" AND a.sid = 1560 and a.transType=150602 ) count

#34（380 次，最大/平均 63.238/31.631 秒）

SELECT `id`, `sid`, `billNo`, `buId`, `storeId`, `sourceType`, `storeId`, `salesId`, `totalAmount`, `disAmount`, `billStatus`, `createTime`, `uid`, `delieverId`, `wayId`, `description`, `payType`, `isKzVip`, `hxStateCode`, `billNo_type`, `is_pay`, `vin`, `car_model`, `activity_id`, `pay_time`, `printing_times` FROM `t_scm_sa_order_11` WHERE `billType` = 'SALE' AND `transType` = '170502' AND `sid` = '3883' AND `billStatus` IN (0, 1, 2) AND `isDelete` =0 AND ( `billNo` LIKE '%XD3883202604070006%' ESCAPE '!' OR `description` LIKE '%XD3883202604070006%' ESCAPE '!' ) ORDER BY `id` desc LIMIT 50

#35（368 次，最大/平均 24.008/8.217 秒）

SELECT a.id, sum(b.amount) as sAmount, sum(c.reAmount) as reAmount, sum(c.diffAmount) as diffAmount FROM t_bs_contact as a LEFT JOIN t_scm_sa_invoice_0_19 AS b ON a.id = b.buId AND b.isDelete = 0 AND b.billStatus < 6 AND b.sid = 1171 LEFT JOIN ( SELECT buId, stlId, sum(amount) reAmount, sum(diffAmount) diffAmount FROM t_scm_payment_info_19 WHERE sid = 1171 AND isDelete = 0 and billStatus <> 6 and transType IN (150601,150602) and billDate>="2026-09-01" GROUP BY stlId ) as c on b.id = c.stlId WHERE a.sid = 1171 AND a.isDelete = 0 AND a.type = -10 AND a.customType = 0 and b.billDate>="2026-09-01" and a.id IN (/* 原始 SQL 已读取；此处折叠 636 个参数 */) GROUP BY a.id

#36（355 次，最大/平均 10.964/2.047 秒）

SELECT count(1) count from( SELECT a.*, c.name AS buName, IFNULL(d.payAmount,0) AS payAmount,IFNULL(d.diffAmount,0) AS diffAmount, e.name as storeName FROM t_scm_sa_invoice_0_17 AS a LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.type = "-10" AND c.sid IN (1553,1) AND c.isDelete = 0 LEFT JOIN (SELECT SQL_BIG_RESULT SUM(IFNULL(amount,0)) as payAmount,SUM(IFNULL(diffAmount,0)) as diffAmount,stlId FROM t_scm_payment_info_17 WHERE isDelete = 0 and billStatus <> 6 and sid = 1553 and transType IN (150601,150602) GROUP BY stlId order by null) AS d ON a.id = d.stlId LEFT JOIN t_bs_store e ON a.storeId = e.id AND e.sid = 1553 WHERE a.isDelete = 0 and a.sid = 1553 and a.buId = 170828 and a.billDate >="2026-08-01" and a.billDate <="2026-08-31" and abs(a.amount) > 0 and (abs(a.rpAmount) + abs(IFNULL(d.diffAmount,0)) + abs(IFNULL(d.payAmount,0))) = 0 and sourceType!=4 and a.transType = 150601 and a.billStatus IN (0,1,2,3,4,5) ) count

#37（343 次，最大/平均 57.660/2.674 秒）

SELECT a.*, b.name AS contactName, b.number AS contactNumber, b.cCategory AS cCategory, b.cCategoryName AS cCategoryName, b.number as contactNo, c.amount as payment1, c.diffAmount as diffAmount1, e.number AS salesNo, e.NAME AS salesName, f.NAME AS accountName, g.NAME as delieverName, h.NAME as storeName, i.id as saleOrId, i.billNo as saleOrNo FROM t_scm_sa_invoice_0_24 AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.type = "-10" AND b.sid IN (1560,1) AND b.isDelete = 0 LEFT JOIN t_bs_contact_ext AS d ON a.buId = d.contactId AND d.type = "10" AND d.sid IN (1560,1) AND d.isDelete = 0 LEFT JOIN (SELECT sum(amount) as amount ,sum(diffAmount) as diffAmount,stlId FROM t_scm_payment_info_24 WHERE isDelete=0 and transType IN (150601,150602) and billStatus <> 6 and sid = 1560 GROUP BY stlId) AS c ON c.stlId = a.id LEFT JOIN t_bs_staff e ON a.salesId = e.id LEFT JOIN t_bs_staff g ON a.delieverId = g.id LEFT JOIN t_bs_account f ON a.accId = f.id LEFT JOIN t_bs_store h ON a.storeId = h.id LEFT JOIN t_scm_sa_order_8 i ON a.srcOrderId = i.id WHERE (a.isDelete=0) AND a.billType="SALE" AND a.billDate>="2026-09-01" AND a.billDate<="2026-09-03" AND a.sid = 1560 and a.transType=150602 order by a.id DESC limit 0,100

#38（337 次，最大/平均 1.877/1.256 秒）

select count(*) as count from (SELECT a.barCode, a.itemCode, a.companyCode, a.quantityUM, b.id AS invId, b.number, b.brandName, b.skuId, b.productCode, b. NAME, b.spec, b.packSpec, b.unitName, b.minNum AS qty FROM t_bs_goods_barcode AS a LEFT JOIN t_bs_goods AS b ON a.itemCode = b.skuId WHERE b.sid = 1 /*AND a.companyCode = "1001"*/ and (a.barCode like '%BGT61140%' or a.itemCode like '%BGT61140%' or b.skuId like '%BGT61140%' or b.number like '%BGT61140%') GROUP BY b.id ) as a

#39（320 次，最大/平均 1.544/1.118 秒）

SELECT `id`, `bill_no`, `bill_status`, `apply_sid`, `deliver_sid`, `in_price`, `out_price`, `remark`, `u_id`, `u_name`, `create_time`, `in_time`, `out_time` FROM `t_scm_stf_apply` WHERE (`apply_sid` = 5609 or `deliver_sid` = 5609) AND `bill_no` like '%%' ORDER BY `create_time` desc LIMIT 20

#40（316 次，最大/平均 2.020/1.116 秒）

select sid from t_quote_goods_base_14 where last_settle_price = 0 and current_settle_price=0 and bi_id = 0 and create_time > '2026-09-03 21:55:01' and create_time < '2026-09-03 22:00:01'

#41（305 次，最大/平均 62.213/11.604 秒）

SELECT count(1) count from( SELECT a.id, a.number, a.name, b.* FROM t_bs_contact AS a INNER JOIN ( SELECT a.buId, sum(a.amount) AS amount, sum(a.reAmount) AS amount1, sum(a.diffAmount) AS diffAmount, sum(rePayment) AS rePayment /*客户欠款*/ , (sum(rePayment) + b.debt_amount) AS rePayment1 /*客户应收余额[+期初欠款]*/ FROM ( SELECT a.amount, a.transType, a.billStatus, b.amount AS reAmount, b.diffAmount, IF ( transType = 150601, ( abs(a.amount) - IFNULL(abs(b.amount), 0) - IFNULL(abs(b.diffAmount), 0) ), - ( abs(a.amount) - IFNULL(abs(b.amount), 0) - IFNULL(abs(b.diffAmount), 0) ) ) rePayment, a.buId FROM t_scm_sa_invoice_0_58 AS a LEFT JOIN ( SELECT sum(amount) amount, sum(diffAmount) AS diffAmount, stlId FROM t_scm_payment_info_26 WHERE isDelete = 0 AND sid = 1338 AND transType IN (150601, 150602) AND billStatus <> 6 GROUP BY stlId ) AS b ON a.id = b.stlId WHERE a.isDelete = 0 AND sid = 1338 AND a.billStatus <> 6 HAVING IFNULL(abs(a.amount), 0) > ( IFNULL(abs(b.amount), 0) + IFNULL(abs(b.diffAmount), 0) ) ) AS a LEFT JOIN t_bs_contact_ext AS b ON a.buId = b.contactId WHERE b.isDelete = 0 GROUP BY buId ) AS b ON b.buId = a.id where a.isDelete = 0 AND a.sid = 1338 AND a.type = - 10 ) count

#42（302 次，最大/平均 9.384/3.588 秒）

SELECT a.barCode, a.itemCode, a.companyCode, a.quantityUM, b.id AS invId, b.number, b.brandName, b.skuId, b.productCode, b. NAME, b.spec, b.packSpec, b.unitName, b.minNum AS qty FROM t_bs_goods_barcode AS a LEFT JOIN t_bs_goods AS b ON a.itemCode = b.skuId WHERE b.sid = 1 /*AND a.companyCode = "1001"*/ and (a.barCode like '%1201000313%' or a.itemCode like '%1201000313%' or b.skuId like '%1201000313%' or b.number like '%1201000313%') GROUP BY b.id limit 0,20

#43（302 次，最大/平均 11.647/3.281 秒）

select invId,sum(qty) as qty from t_scm_inventory_0_54 where isDelete = 0 and sid = 1078 and billDate >= '2026-09-02' and invId IN (/* 原始 SQL 已读取；此处折叠 314 个参数 */) and transType IN (150601,150602)group by invId

#44（288 次，最大/平均 5.287/2.612 秒）

select id,cv_key,cv_type,chat_group_id,wxid,wxname,sid,contact_id,contact_name,start_text,start_keyword,last_keyword,`status`,close_time,create_time,modify_time from t_scm_robot_conversation where (9573960 <= id AND id < 9687233)

#45（288 次，最大/平均 51.375/42.390 秒）

select id,cv_id,sid,station_name,contact_id,contact_name,chat_group_id,chat_group_name,wxid,wxname,headimgurl,role,source_content,source_type,`text`,text_flag,text_flag_order_type,keyword,`status`,create_time,modify_time,request_id from t_scm_robot_conversation_record where (63732885 <= id AND id < 64665842)

#46（275 次，最大/平均 10.856/2.117 秒）

SELECT count(id) as num, billStatus FROM t_scm_sa_invoice_0_3 AS a LEFT JOIN (SELECT SUM(IFNULL(amount,0)) as payAmount,SUM(IFNULL(diffAmount,0)) as diffAmount,stlId FROM t_scm_payment_info_3 WHERE isDelete = 0 and billStatus <> 6 and sid = 1347 and transType IN (150601,150602) GROUP BY stlId) AS d ON a.id = d.stlId WHERE a.isDelete = 0 and a.sid = 1347 AND a.billStatus IN (1,2,3) and a.buId = 111197 and a.billDate >="2026-08-30" and a.billDate <="2026-09-03" and abs(a.amount) > 0 and (abs(a.rpAmount) + abs(IFNULL(d.diffAmount,0)) + abs(IFNULL(d.payAmount,0))) = 0 and sourceType!=4 and a.transType = 150601 group by a.billStatus

#47（275 次，最大/平均 11.426/2.030 秒）

SELECT a.*, c.name AS buName, IFNULL(d.payAmount,0) AS payAmount,IFNULL(d.diffAmount,0) AS diffAmount, e.name as storeName FROM t_scm_sa_invoice_0_61 AS a LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.type = "-10" AND c.sid IN (1277,1) AND c.isDelete = 0 LEFT JOIN (SELECT SQL_BIG_RESULT SUM(IFNULL(amount,0)) as payAmount,SUM(IFNULL(diffAmount,0)) as diffAmount,stlId FROM t_scm_payment_info_29 WHERE isDelete = 0 and billStatus <> 6 and sid = 1277 and transType IN (150601,150602) GROUP BY stlId order by null) AS d ON a.id = d.stlId LEFT JOIN t_bs_store e ON a.storeId = e.id AND e.sid = 1277 WHERE a.isDelete = 0 and a.sid = 1277 and a.buId = 58213 and a.billDate >="2023-08-01" and a.billDate <="2026-09-03" and abs(a.amount) > 0 and (abs(a.rpAmount) + abs(IFNULL(d.diffAmount,0)) + abs(IFNULL(d.payAmount,0))) = 0 and sourceType!=4 and a.transType = 150601 and a.billStatus IN (0,1,2,3,4,5) order by a.createTime desc limit 0,50

#48（273 次，最大/平均 4.415/1.437 秒）

select id,cv_key,cv_type,chat_group_id,wxid,wxname,sid,contact_id,contact_name,start_text,start_keyword,last_keyword,`status`,close_time,create_time,modify_time from t_scm_robot_conversation_history where (8579229 <= id AND id < 8629683)

#49（272 次，最大/平均 3.830/1.662 秒）

SELECT count(1) count from( SELECT a.*, a.invName as goods,aa.orderType,aa.orderCate,aa.paymentType,aa.createTime,aa.buName,aa.buType,aa.is_exclusive, b.name AS baseName, b.number AS invNumber, b.spec AS invSpec, b.status As goodsStatus, b.unitName AS mainUnit, b.minNum, b.packSpec, b.brandName, b.saleModel,b.status,b.categoryId, aa.srcOrderType, aa.saleId,aa.billStatus,aa.document_type ,IFNULL(c.wmsNo,"") wmsNo,IFNULL(c.outQty,0) outQty, IFNULL(d.inQty,0) inQty, IFNULL(e.closeQty,0) closeQty, a.qty - IFNULL(d.inQty,0) - IFNULL(c.outQty,0) - IFNULL(e.closeQty,0) waitQty FROM t_scm_po_order_info_9 AS a LEFT JOIN t_scm_po_order AS aa ON a.iid = aa.id LEFT JOIN ( SELECT id, NAME, number, spec,skuId, unitName, minNum, packSpec, status, brandName, saleModel,categoryId FROM t_bs_goods WHERE (isDelete = 0) AND sid = 1) AS b ON a.invId = b.id LEFT JOIN ( SELECT isGift,invId, srcOrderId, wmsNo, SUM(qty) outQty FROM t_scm_po_out_info_9 WHERE (isDelete = 0) and billStatus = 0 and sid=3689 GROUP BY isGift,srcOrderId,invId ) AS c ON a.invId = c.invId and a.iid = c.srcOrderId and a.isGift = c.isGift LEFT JOIN ( SELECT x1.isGift,x1.invId, x1.srcOrderId, SUM(x1.qty) inQty FROM t_scm_pu_invoice_info_9 x1 force index(idx_search) JOIN ( SELECT a.invId,a.iid,a.isGift FROM t_scm_po_order_info_9 a JOIN t_scm_po_order aa ON a.iid = aa.id LEFT JOIN ( SELECT isGift, invId, srcOrderId, wmsNo, SUM(qty) AS outQty FROM t_scm_po_out_info_9 WHERE (isDelete = 0) AND billStatus = 0 AND sid = 3689 GROUP BY isGift, srcOrderId, invId ) c ON a.invId = c.invId AND a.iid = c.srcOrderId AND a.isGift = c.isGift WHERE a.sid = 3689 and aa.sid=3689 and a.transType = 170401 and aa.billStatus IN (3,4) and aa.billStatus > 1 ) x2 ON x2.invId=x1.invId AND x2.iid = x1.srcOrderId AND x2.isGift = x1.isGift WHERE (x1.isDelete = 0) and x1.sid=3689 GROUP BY x1.isGift,x1.srcOrderId,x1.invId ) AS d ON a.invId = d.invId and a.iid = d.srcOrderId and a.isGift = d.isGift LEFT JOIN ( SELECT x1.isGift,x1.invId, x1.srcOrderId, SUM(x1.qty) closeQty FROM t_scm_po_close_info x1 JOIN ( SELECT a.invId,a.iid,a.isGift FROM t_scm_po_order_info_9 a JOIN t_scm_po_order aa ON a.iid = aa.id LEFT JOIN ( SELECT isGift, invId, srcOrderId, wmsNo, SUM(qty) AS outQty FROM t_scm_po_out_info_9 WHERE (isDelete = 0) AND billStatus = 0 AND sid = 3689 GROUP BY isGift, srcOrderId, invId ) c ON a.invId = c.invId AND a.iid = c.srcOrderId AND a.isGift = c.isGift WHERE a.sid = 3689 and aa.sid=3689 and a.transType = 170401 and aa.billStatus IN (3,4) and aa.billStatus > 1 ) x2 ON x2.invId=x1.invId AND x2.iid = x1.srcOrderId AND x2.isGift = x1.isGift WHERE (x1.isDelete = 0) and x1.sid=3689 GROUP BY x1.isGift,x1.srcOrderId,x1.invId ) AS e ON a.invId = e.invId and a.iid = e.srcOrderId and a.isGift = e.isGift WHERE (a.isDelete = 0 and aa.sid = 3689) and a.sid = 3689 and aa.sid=3689 and a.transType = 170401 and aa.billStatus IN (3,4) and (a.qty - IFNULL(d.inQty,0) - IFNULL(c.outQty,0) - IFNULL(e.closeQty,0)) > 0 and aa.billStatus > 1 ) count

#50（264 次，最大/平均 60.999/11.846 秒）

SELECT a.id, a.number, a.name, b.* FROM t_bs_contact AS a INNER JOIN ( SELECT a.buId, sum(a.amount) AS amount, sum(a.reAmount) AS amount1, sum(a.diffAmount) AS diffAmount, sum(rePayment) AS rePayment /*客户欠款*/ , (sum(rePayment) + b.debt_amount) AS rePayment1 /*客户应收余额[+期初欠款]*/ FROM ( SELECT a.amount, a.transType, a.billStatus, b.amount AS reAmount, b.diffAmount, IF ( transType = 150601, ( abs(a.amount) - IFNULL(abs(b.amount), 0) - IFNULL(abs(b.diffAmount), 0) ), - ( abs(a.amount) - IFNULL(abs(b.amount), 0) - IFNULL(abs(b.diffAmount), 0) ) ) rePayment, a.buId FROM t_scm_sa_invoice_0_58 AS a LEFT JOIN ( SELECT sum(amount) amount, sum(diffAmount) AS diffAmount, stlId FROM t_scm_payment_info_26 WHERE isDelete = 0 AND sid = 1338 AND transType IN (150601, 150602) AND billStatus <> 6 GROUP BY stlId ) AS b ON a.id = b.stlId WHERE a.isDelete = 0 AND sid = 1338 AND a.billStatus <> 6 HAVING IFNULL(abs(a.amount), 0) > ( IFNULL(abs(b.amount), 0) + IFNULL(abs(b.diffAmount), 0) ) ) AS a LEFT JOIN t_bs_contact_ext AS b ON a.buId = b.contactId WHERE b.isDelete = 0 GROUP BY buId ) AS b ON b.buId = a.id where a.isDelete = 0 AND a.sid = 1338 AND a.type = - 10 order by b.rePayment1 desc,a.id asc limit 490,10

#51（262 次，最大/平均 22.860/2.589 秒）

SELECT count(1) count from( SELECT a.id, a.iid, a.billNo, a.billType, a.billDate, a.buId, a.invId, a.transTypeName, a.transType, a.price, a.locationId, a.salesId, a.qty, a.amount, a.deduction, a.disAmount, a.allCost, b.name AS invName, b.number AS invNumber, b.spec AS invSpec, b.unitName AS mainUnit, b.brandName, b.skuId, b.minNum, b.packSpec, b.categoryName, b.productCode, c.number AS contactNo, c.name AS contactName, d.name AS locationName, d.locationNo, e.number AS salesNo, e.name AS salesName FROM ( SELECT a.id, a.iid, a.billNo, a.billType, a.billDate, a.buId, a.invId, a.transTypeName, a.transType, a.locationId, a.salesId, a.price, sum(a.qty) AS qty, sum( CASE WHEN a.transType = 150601 THEN abs(a.qty * a.price) ELSE - abs(a.qty * a.price) END ) AS amount, sum( CASE WHEN a.transType = 150601 THEN a.deduction ELSE - a.deduction END ) AS deduction, sum( CASE WHEN a.disAmount = 0 THEN a.amount ELSE a.disAmount END ) AS disAmount, sum( CASE WHEN a.costPrice != 0 THEN - a.costPrice * a.qty WHEN b.price THEN - b.price * a.qty ELSE 0 END ) AS allCost FROM t_scm_sa_invoice_info_0_34 AS a LEFT JOIN (select sid,invId,locationId,price from t_bs_cost_price_day_2 as g inner join ( select max(id) maxId from t_bs_cost_price_day_2 where sid=3618 group by invId,locationId ) h on g.id=h.maxId) AS b ON a.invId = b.invId AND a.locationId = b.locationId AND a.sid = b.sid LEFT JOIN t_scm_sa_invoice_0_34 AS f ON a.iid = f.id AND f.sid = 3618 WHERE 1=1 AND a.isDelete = 0 AND f.billStatus <> 6 and a.billType="SALE" and a.sid = 3618 and f.billStatus < 6 and a.billDate>="2025-09-04" and a.billDate<="2026-09-03" group by a.invId, a.locationId ) AS a LEFT JOIN t_bs_goods AS b ON a.invId = b.id AND b.sid IN (3618, 1) AND b.isDelete = 0 LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.sid = 3618 AND c.isDelete = 0 LEFT JOIN t_bs_storage AS d ON a.locationId = d.id AND d.sid = 3618 AND d.isDelete = 0 LEFT JOIN t_bs_staff AS e ON a.salesId = e.id AND e.sid = 3618 AND e.isDelete = 0 WHERE (1=1) and b.categoryId IN (110092588) ) count

#52（261 次，最大/平均 19.916/4.403 秒）

SELECT count(1) count from( SELECT a.*, b.name AS buName, c.name AS invName,c.brandName,c.spec,c.status, c.number AS invNumber FROM t_scm_offer_order_info AS a LEFT JOIN t_bs_contact AS b ON a.buId = b.id AND b.sid = 2017 AND b.type < 0 LEFT JOIN t_bs_goods AS c ON a.invId = c.id WHERE a.isDelete = 0 and a.sid = 2017 and a.billDate>="2026-08-03" and a.billDate<="2026-09-03" and a.obsolete = 0 ) count

#53（256 次，最大/平均 1.531/1.089 秒）

SELECT a.barCode, a.quantityUM, b.id as invId, b.number, b.brandName, b.skuId, b.status, b. NAME, b.spec, b.productCode, b.categoryName, b.minNum as qty FROM t_bs_goods AS b LEFT JOIN t_bs_goods_barcode AS a ON a.itemCode = b.skuId /* AND b.isDelete = 0*/ WHERE b.sid = 1 /*and a.companyCode = '1001' */ and a.barCode = '6941743525020' HAVING skuId IS NOT NULL

#54（255 次，最大/平均 4.370/1.910 秒）

SELECT `accId`, `billDate`, sum(payment) as payment FROM `t_scm_account_info_0` WHERE `sid` = '3216' AND `isDelete` =0 AND `billDate` < '2026-09-01' GROUP BY `accId`

#55（249 次，最大/平均 4.581/1.845 秒）

select `billNo` from `t_scm_po_order_info_4` where `sid` = 1060 and (`skuId` like '%PR106026080408362896%' or `invName` like '%PR106026080408362896%' or `srcOrderNo` like '%PR106026080408362896%' or `billNo` like '%PR106026080408362896%') and `isDelete` = 0

#56（241 次，最大/平均 61.674/2.717 秒）

SELECT count(1) count from( SELECT a.id, b.billNo as stlNo,b.billDate as stlbillDate,b.amount as totalAmount,b.billStatus as saleSatatus, a.transType,a.amount as thisAmount,a.diffAmount as thisDiffAmount,a.description, IFNULL(c.payAmount,0) AS payAmount,IFNULL(c.diffAmount,0) AS diffAmount FROM t_scm_payment_info_8 AS a LEFT JOIN t_scm_sa_invoice_0_40 AS b ON a.stlId = b.id AND b.sid = 2792 LEFT JOIN ( SELECT SUM(IFNULL(amount, 0)) AS payAmount, SUM(IFNULL(diffAmount, 0)) AS diffAmount, stlId FROM t_scm_payment_info_8 WHERE isDelete = 0 AND billType = "RECEIPT" AND sid = 2792 AND transType IN (150601, 150602) AND billStatus NOT IN (6) GROUP BY stlId ) AS c ON a.stlId = c.stlId WHERE a.isDelete = 0 AND a.billType = "RECEIPT" and a.sid = 2792 AND b.billStatus NOT IN (6) and a.iid = 936104752041689088 ) count

#57（236 次，最大/平均 22.931/2.591 秒）

SELECT a.id, a.iid, a.billNo, a.billType, a.billDate, a.buId, a.invId, a.transTypeName, a.transType, a.price, a.locationId, a.salesId, a.qty, a.amount, a.deduction, a.disAmount, a.allCost, b.name AS invName, b.number AS invNumber, b.spec AS invSpec, b.unitName AS mainUnit, b.brandName, b.skuId, b.minNum, b.packSpec, b.categoryName, b.productCode, c.number AS contactNo, c.name AS contactName, d.name AS locationName, d.locationNo, e.number AS salesNo, e.name AS salesName FROM ( SELECT a.id, a.iid, a.billNo, a.billType, a.billDate, a.buId, a.invId, a.transTypeName, a.transType, a.locationId, a.salesId, a.price, sum(a.qty) AS qty, sum( CASE WHEN a.transType = 150601 THEN abs(a.qty * a.price) ELSE - abs(a.qty * a.price) END ) AS amount, sum( CASE WHEN a.transType = 150601 THEN a.deduction ELSE - a.deduction END ) AS deduction, sum( CASE WHEN a.disAmount = 0 THEN a.amount ELSE a.disAmount END ) AS disAmount, sum( CASE WHEN a.costPrice != 0 THEN - a.costPrice * a.qty WHEN b.price THEN - b.price * a.qty ELSE 0 END ) AS allCost FROM t_scm_sa_invoice_info_0_34 AS a LEFT JOIN (select sid,invId,locationId,price from t_bs_cost_price_day_2 as g inner join ( select max(id) maxId from t_bs_cost_price_day_2 where sid=3618 group by invId,locationId ) h on g.id=h.maxId) AS b ON a.invId = b.invId AND a.locationId = b.locationId AND a.sid = b.sid LEFT JOIN t_scm_sa_invoice_0_34 AS f ON a.iid = f.id AND f.sid = 3618 WHERE 1=1 AND a.isDelete = 0 AND f.billStatus <> 6 and a.billType="SALE" and a.sid = 3618 and f.billStatus < 6 and a.billDate>="2025-09-04" and a.billDate<="2026-09-03" group by a.invId,a.locationId ) AS a LEFT JOIN t_bs_goods AS b ON a.invId = b.id AND b.sid IN (3618, 1) AND b.isDelete = 0 LEFT JOIN t_bs_contact AS c ON a.buId = c.id AND c.sid = 3618 AND c.isDelete = 0 LEFT JOIN t_bs_storage AS d ON a.locationId = d.id AND d.sid = 3618 AND d.isDelete = 0 LEFT JOIN t_bs_staff AS e ON a.salesId = e.id AND e.sid = 3618 AND e.isDelete = 0 WHERE (1=1) and b.categoryId IN (110092588)

#58（236 次，最大/平均 37.254/9.640 秒）

SELECT COUNT(*) AS `numrows` FROM `t_scm_sa_order_2` WHERE `billType` = 'SALE' AND `transType` = '170502' AND `sid` = '1058' AND `billStatus` IN (0, 1, 2) AND `isDelete` =0 AND ( `billNo` LIKE '%XD1058202609030006%' ESCAPE '!' OR `description` LIKE '%XD1058202609030006%' ESCAPE '!' )

#59（219 次，最大/平均 27.382/2.361 秒）

SELECT a.id, b.billNo as stlNo,b.billDate as stlbillDate,b.amount as totalAmount,b.billStatus as saleSatatus, a.transType,a.amount as thisAmount,a.diffAmount as thisDiffAmount,a.description, IFNULL(c.payAmount,0) AS payAmount,IFNULL(c.diffAmount,0) AS diffAmount FROM t_scm_payment_info_8 AS a LEFT JOIN t_scm_sa_invoice_0_40 AS b ON a.stlId = b.id AND b.sid = 2792 LEFT JOIN ( SELECT SUM(IFNULL(amount, 0)) AS payAmount, SUM(IFNULL(diffAmount, 0)) AS diffAmount, stlId FROM t_scm_payment_info_8 WHERE isDelete = 0 AND billType = "RECEIPT" AND sid = 2792 AND transType IN (150601, 150602) AND billStatus NOT IN (6) GROUP BY stlId ) AS c ON a.stlId = c.stlId WHERE a.isDelete = 0 AND a.billType = "RECEIPT" and a.sid = 2792 AND b.billStatus NOT IN (6) and a.iid = 936104752041689088 order by a.id desc limit 0,200

#60（213 次，最大/平均 2.082/1.451 秒）

SELECT q.sid,COUNT(*) matched,SUM(CASE WHEN q.guide_plan_id=0 THEN 1 ELSE 0 END) no_plan,SUM(CASE WHEN q.guide_plan_id=0 AND (q.low_price<>CAST(TRUNCATE(g.lowPrice * 100, 0) AS SIGNED) OR q.guide_price<>CAST(TRUNCATE(g.lowPrice * 100, 0) AS SIGNED)) THEN 1 ELSE 0 END) no_plan_mismatch,SUM(CASE WHEN q.guide_plan_id>0 AND q.low_price<>CAST(TRUNCATE(g.lowPrice * 100, 0) AS SIGNED) THEN 1 ELSE 0 END) plan_low_mismatch,SUM(CASE WHEN q.guide_plan_id>0 AND q.guide_price<>CAST(TRUNCATE(g.lowPrice * 100, 0) AS SIGNED) THEN 1 ELSE 0 END) plan_guide_mismatch FROM t_quote_goods_base_53 q INNER JOIN t_bs_goods g ON g.id=q.inv_id WHERE q.sid IN (2677,2805,2869,2933,2997,3061,3125,3253,3317,3381) AND q.inv_id IN (/* 原始 SQL 已读取；此处折叠 1898 个参数 */) AND g.sid=1 AND g.isDelete=0 AND g.modifyTime >= '2026-09-01 00:00:01' AND g.modifyTime <= '2026-09-01 00:05:01' GROUP BY q.sid

#61（201 次，最大/平均 2.955/1.948 秒）

select count(*) as aggregate from `kxj_repair_depot` inner join (select DISTINCT depot_id from `kxj_user_depot_relation` where `status` = 1 and `switch_time` != '') as `l` on `kxj_repair_depot`.`id` = `l`.`depot_id` where `status` IN (1, 0) and `province` = '520000' and `city` = '522600' and `area` = '522626'

3.6 “具体 SQL”完整度核对结论

本次重新进入用户提供的 DAS 链接后，页面显示窗口为 2026-09-02 07:40:00～13:40:00。通过页面 DOM 实际读取到第 1 页 50 条和第 2 页前 11 条的 SQL 单元格，证据不是根据表名或 SQL 指纹推测出来的。

核对结果如下：

因此，当前文档已经不是“只有指纹”，但也不能表述为“61 条全部是可直接执行的完整 SQL”。要得到 #7 的完整原文，以及所有长 IN 的完整参数，仍需从 DAS 的详情复制/导出通道或应用/数据库审计日志取得；仅凭当前列表页不能补齐。

4. 业务链路与代码入口

4.1 应收、客户授信和付款

业务目的：销售开单、销售出库或收款相关页面需要知道客户销售金额、已收金额、折让、历史欠款和授信余额。

当前入口：

慢的本质： 外层最终只需要客户汇总或一个余额，但付款子查询经常先按整个分表的 stlId 聚合，再与销售单连接；若没有先把客户筛选出的销售单 ID传给付款查询，就会形成很大的派生表。应收余额还存在“销售单明细返回给 PHP”的历史实现和“数据库聚合”的当前实现两套版本风险。

重要代码事实核对： 当前工作区 staging 分支的 ContactModel::receivableBalance()（约 384 行）仍是单条聚合 SQL，并在会话中调整临时表大小；git log 显示来自 20244282ce 和 96d888caf7。活动任务索引中“已回退到旧版两条 SQL”的文字与当前文件不一致，应以当前文件和目标部署版本为准，发布前必须核对线上 SHA。

优化难度：高。 金额结果必须覆盖销售、销退、负数付款、折让、超收、撤销和历史补录。推荐顺序是：

1. 用同一 REPEATABLE READ 快照对比旧 PHP 口径与新 SQL 口径；
2. 先把外层客户筛选结果变成销售单 ID集合，再聚合付款；
3. 若仍慢，按 ID范围或临时 ID表拆分，但每段只返回一行金额；
4. 中长期维护 sid + buId 应收汇总表，在销售、收款、退款、折让和撤销事件成功后更新。

禁止直接做的事： 不要只把 LEFT JOIN 改成 INNER JOIN，不要把 billStatus <> 6 随意改成 billStatus < 6，不要因为一个负数付款样本就改变正负号公式，也不要在没有结果集对比时上线新口径。

4.2 最近销售价

业务场景：销售下单、报价、导入出库单、移动商城或智能询价展示客户最近成交价。

代码链路： InventoryService::getRecentSalePrice()/getRecentSalePrice_new() → SaInvoiceInfoModel::getRecentSalePrice()；报价流程还从 QuoteManagerBaseSer::getRecentSalePrices() 进入；批量导入在 application/Services/Import/Type/SaleOutGoodsService.php 使用。

当前代码通过 MAX(id) 取得销售明细最新记录，并通过 activityId=0 排除活动价；旧 SQL 指纹中还出现过 GROUP_CONCAT(... ORDER BY createTime DESC) 和关联销售单主表的写法。不能直接把最大 ID当作最新时间，应验证 ID 与业务时间是否始终单调，并用“业务时间 + 同时间最大 ID”确定唯一最新行。

低风险动作是明确字段、去掉 SELECT *、去掉无用派生表、去重 invIds、对单批和批量统一入口。高风险点是活动价排除条件、客户维度、历史数据缺少 activityId 的兼容性。

4.3 成本价

业务场景：销售出库、销售退货、盘点、调拨、库存报表和利润计算需要按 invId + locationId 得到指定日期前最新成本价。

代码链路： application/models/bs/CostPriceModel.php::getCostPrices()；调用方包括 SaOrderSer、NormalSaleSer、Price/GetPrice.php、PDA/GPDA 盘点、调拨和多个报表服务。

当前分表按 sid % BS_COST_PRICE_DAY_NUM 选择。方法在进入最新记录查询前会构造 sid、商品集合、货位、日期/版本条件；超过 1000 个商品会拆成多个 IN 条件。页面慢点表现为扫描最多 656.81K 行，说明大批量商品和历史日期范围放大了查询。

建议先验证按 (invId, locationId) 取 MAX(id) 后回表取 price，并保留现有日期/版本条件；再比较 FORCE INDEX(UK_SILI) 与优化器自主选索引的计划。验收必须逐商品、逐货位对比价格和空值行为，不能只比较返回行数。

4.4 商品条码与 PDA

业务场景：PDA 扫码、盘点和手工选择商品时，通过条码或物料编码找到商品主档，再查询库存和货位。

代码链路： application/models/Data_model_app.php::getPdaSkusByBarcode() → application/Services/Pda/TakeStockSer.php::getScanData()。

当前 SQL 从 t_bs_goods 左连接 t_bs_goods_barcode，按条码或 itemCode过滤，按 itemCode 分组并用 GROUP_CONCAT拼条码。这里有三个不能混用的入口：条码扫描、物料编码精确匹配、手工指定 inv_id。只针对条码查询时可以评估以条码表为驱动的内连接；但不能用同一个改写覆盖手工选品路径，也不能无证据删除 GROUP BY/HAVING。

优先验证条码表 itemCode/barcode 索引、商品表 sid/id/skuId索引和条码重复数据。结果对比必须包含商品数量、主条码、条码拼接值、排序和无匹配时的返回。

4.5 销售单列表、详情、COUNT 和对账单

业务场景：出库列表、销售单详情、客户对账单和销售报表展示订单主信息、客户、销售员、门店、收款、来源订单以及分页总数。

代码链路：

querySaleInvoice() 目前 SELECT a.*，同时连接客户、客户扩展、付款聚合、员工、账户、门店和销售订单。即使外层最终只返回一个详情行，付款派生表也可能先按整个付款分表 GROUP BY stlId，造成百万级扫描。列表则有“先 COUNT 再查当前页”的固定放大。

推荐先按主表条件定位当前页或详情 ID，再按这些 ID 查询付款和扩展信息；对于总页数，如果产品只需要“是否有下一页”，可以用 rows + 1，如果必须展示精确页数则评估短缓存或统计快照。任何 COUNT 改造都要核对筛选条件、状态边界、排序和权限过滤。

4.6 采购订单、采购发票和账户流水

采购订单代码链路： PoOrderInfoSer::getPageList() → PoOrderInfoModel::getPageList()，当前明细查询按 sid + iid + isDelete 过滤，同时对商品名做模糊搜索，并单独 COUNT。

采购发票/付款报表代码链路： ReportModel::splitContact2() 中采购单据和采购付款汇总；ReportService 的采购报表方法继续拼接客户和时间条件。

账户流水代码链路： application/models/Data_model.php::get_account_info()，按 sid % SCM_ACCOUNT_SUB_NUM选择分表，连接客户、收支分类、账户和付款信息。

这些查询的共同风险是把列表字段、汇总字段和关联表字段混在一起，并在大集合上 GROUP BY。建议按页面拆出“主单列表”“汇总金额”“详情扩展”三类查询，明确每条查询只返回所需字段。采购金额、付款和账户流水也属于财务口径，必须用固定单据集合核对总额。

4.7 机器人会话与会话记录

业务场景：机器人统计页面按会话、会话记录、微信昵称、文本或服务站筛选并展示会话链路；部分任务会按 ID范围批量读取历史数据。

代码链路： application/controllers/RobotStat.php、RobotStatV2.php → ConversationModel、ConversationRecordModel；表包括 t_scm_robot_conversation、t_scm_robot_conversation_record 和历史表。

排名 31、42、44、47 的共同特点是扫描/返回行大，尤其 ID范围读取平均返回接近百万行。此类问题不能只建索引：如果业务真的要搬运大量会话，就需要游标分页、时间范围、字段投影或异步导出；如果页面只显示最近一页，应检查是否错误地先读全量再在 PHP 截断。

修改风险在于统计口径和会话完整性：需要保证按 cv_id 的记录顺序、首条消息判断、过滤特殊服务站和模糊搜索结果不变。建议先采集实际页面需要的字段，再限制查询列。

4.8 调拨申请

StfApplyModel::getPageList() 同时支持申请方和发货方：当不是特定类型时使用 apply_sid = ? OR deliver_sid = ?；还支持单号精确集合和 %keyword% 模糊查询，并先 COUNT 后分页。当前 SQL 最高扫描 1.71M 行。

候选方案是将申请方和发货方拆成两个索引可用的分支后 UNION ALL，再按主键去重；但必须先确认同一申请单可能同时满足两个角色，不能直接 UNION ALL 导致重复。另一个低风险动作是当用户没有输入搜索词时不要拼接 LIKE '%%'，并评估是否可用游标分页。

4.9 报价基础数据和价格变更日志

报价基础数据来自 QuoteGoodsBaseModel 及报价任务；价格变更日志来自 QuotePriceChangeLogModel::getBatchUpdateList()，由 QuoteManagerBaseSer::handlePriceChange() 分批读取 1000 条后按服务站处理并批量更新状态。

价格变更查询的过滤字段固定为 change_type、bill_date、version、status，但当前代码使用 mix_where() 后没有指定列，也没有明确排序。可先做 SELECT 列收敛、按主键游标读取和联合索引评估；必须确认处理失败重跑、批次边界和状态更新幂等。

4.10 t_sale_order / t_sale_order_detail 族（兄弟服务）

这两张表不属于当前 DGJ2 主仓库的模型。已在 www/saas 定位到 SaleOrder、SaleOrderDetail、SaleOrderRepository::search() 和两个搜索服务入口：服务端将销售订单主表和明细表按 order_id 关联，并按 contact_id/status/create_time/sku_id 筛选后分页。DAS 中的 ID 范围读取、明细 ID 范围读取和订单号 LIKE 不能仅凭表名改 DGJ2；应先确认实际部署服务、SQL 完整条件、索引和调用页面，再安排高风险改造。

4.11 生产日志核查边界

在 2026-09-02 07:40～13:40 的精确生产日志窗口内，组合检索 receivableBalance + t_scm_sa_invoice_0_10、getCustomerAccount + t_scm_sa_invoice_0_10、querySaleInvoice + t_scm_sa_invoice、getBatchUpdateList + t_price_change_log、getCostPrices + t_bs_cost_price_day 均没有命中。应用日志通常不记录完整 SQL 或方法名，所以这只能作为“未找到可直接关联的日志”证据，不能作为“没有接口调用”的结论。

5. 每个业务族的“为什么慢、先怎么改、风险是什么”

6. 建议的落地顺序

第一阶段：不改业务口径，做低风险 SQL/调用治理

1. 价格变更日志：明确列、主键游标、目标索引 EXPLAIN。
2. 成本价：删除重复 COUNT 的候选实现，比较 MAX(id) 回表方案，先在预发验证。
3. 条码：将扫码精确查询和手工选品查询分开，避免一个 SQL 兼容所有语义。
4. 列表分页：统计确实需要总页数的页面，避免无意义的 COUNT；对可行页面用 rows+1。
5. 调拨申请：确认申请方/发货方交集后，再评估 UNION 分支。

第二阶段：销售/采购列表与付款派生表改造

1. 详情查询先取主单，再查询付款和扩展信息；避免为一行详情先聚合整张付款表。
2. 列表查询只查当前页主单 ID，再批量查询客户、付款、门店和员工信息。
3. 报表查询按客户集合或单据集合限制付款聚合，禁止付款子查询无边界地按全表 stlId 分组。
4. 所有 SELECT * 改为页面实际需要的列，并给每个大查询保留 SQL 计时日志。

第三阶段：应收汇总与机器人批处理

1. 应收先完成固定单据集的结果一致性验证，再决定是否继续使用单条聚合、ID范围分段或汇总表。
2. 应收接口增加请求级/短 TTL 缓存时，缓存键必须包含 sid + buId，并明确收款、退款、撤销后的失效策略。
3. 机器人统计改为按时间/ID游标读取，默认限制字段，导出任务异步化。
4. t_sale_order 相关 SQL 先完成兄弟服务定位，不能在 DGJ2 中凭表名推断入口。

7. 验收与回滚

7.1 每条 SQL 必须记录的性能数据

• 冷/热缓存分别记录，不能只拿第二次执行时间当作真实耗时。
• 使用同一参数、同一时间窗口和同一数据快照。
• 记录总墙钟时间、每条 SQL 时间、扫描行、返回行、临时表磁盘溢出和执行计划。
• 并发验证至少记录 P50/P95/P99；DAS 单次样本不能替代高并发结论。
• 结果正确性与性能是两个独立门槛，不能因为耗时下降就跳过金额和页面回归。

7.2 通用结果对比

-- 生产只读验证示例：先在目标库确认分表、索引和执行计划
EXPLAIN <old_sql>;
EXPLAIN <candidate_sql>;

-- 结果对比时使用同一参数和同一 REPEATABLE READ 快照
-- 列表类：按主键排序后做集合差异
-- 金额类：按 sid、buId、单据ID分别比对 decimal 值
-- 最新价/成本价：按 invId、locationId 比对来源记录和 price

7.3 回滚方式

8. 当前待补证据

1. 阿里云 RAM 登录后重新读取 DAS 详情页，补齐当前 200 条明细中的 51～200 条；若页面仍不刷新，使用 DAS 导出任务或其接口获取完整结果，但创建导出任务前需单独确认。
2. 针对每个高频表分表执行 SHOW CREATE TABLE、SHOW INDEX 和 EXPLAIN；当前稿没有把本地 schema 或历史下载文件当成生产证据。
3. 对排名 14、15、34、45 的 t_sale_order 族 SQL，确认实际服务、代码仓库、环境和调用入口。
4. 对排名 37、40、48 及采购发票 SQL，使用完整 SQL 文本补齐物理表、过滤条件和调用者。
5. 核对线上部署 SHA，尤其是 ContactModel::receivableBalance() 当前聚合版本与历史任务索引描述不一致的问题。

8.1 2026-09-04 复核结果

• 用户已将 DAS 详情页切到前台并确认页面加载完成；本轮浏览器只读读取仍在 DAS 页面/内嵌内容处超时，未能形成可复核的 51～200 条数据，因此本稿仍只对前 50 条作逐条结论。
• 旧 Confluence 页面《站管家 MySQL 慢查询优化：前后对比与验收》已通过 REST 只读读取确认：空间为“开发中心”（kzPlatform），父页面为《线上慢SQL》（页面 ID 22481697），旧页面 ID 73510965、版本 9。
• 目标标题《站管家 2026-09-02 DAS 剩余慢查询分析与优化排期》在同一空间下暂无重复页面。创建新页面前应再次确认；创建后必须回读标题、父页面、版本和正文。

发布前说明：本稿当前可以作为“前 50 条已确认慢查询 + 业务族优化排期”使用；在 RAM 登录并补读 51～200 条之前，不应对外宣称已覆盖 DAS 的 686 个模板。

9. 代码证据索引

• application/models/bs/ContactModel.php::receivableBalance()
• application/models/report/ReportModel.php::splitContact2()、getpAmount()
• application/models/scm/InvSaModel.php::querySaleInvoice()、querySaleInvoiceStatement()、getOutBoundList()
• application/service/scm/InvSaService.php::outBoundList()
• application/service/scm/ReceiptService.php::getCustomerAccount()、getCreditByBuId()
• application/models/saOrders/SaInvoiceInfoModel.php::getRecentSalePrice()
• application/models/saOrders/SaOrderInfoModel.php::getRecentSalePrice()
• application/models/bs/CostPriceModel.php::getCostPrices()
• application/models/Data_model_app.php::getPdaSkusByBarcode()
• application/models/stf/StfApplyModel.php::getPageList()
• application/models/orders/PoOrderInfoModel.php::getPageList()
• application/models/bs/QuotePriceChangeLogModel.php::getBatchUpdateList()
• application/Services/BaseData/QuoteManagerBaseSer.php::handlePriceChange()
• application/models/Data_model.php::get_account_info()
• application/models/moveMall/ConversationModel.php、ConversationRecordModel.php
• application/controllers/RobotStat.php、RobotStatV2.php