PA ON是什么意思
时间: 2023-08-27 12:13:40 浏览: 101
PA ON是指功率放大器(Power Amplifier)的开启状态。在无线通信中,PA ON表示功率放大器被打开,开始放大信号以便发送给接收器。当PA ON时,信号经过PA进行放大,以便在传输过程中能够达到适当的功率水平。 PA ON状态是由控制器或软件通过控制GPIO或MIPI PA进行控制的。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* *3* [高通芯片校准中的RGI、ICQ是什么意思,校准的特征化是什么意思?(转)](https://blog.csdn.net/vikinga3/article/details/81805364)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v92^chatsearchT3_1"}}] [.reference_item style="max-width: 100%"]
[ .reference_list ]
相关问题
把这段sql代码转换mybatisplus代码:SELECT p.id, p.identifier,c.company_order,p.business_source,p.salesmen,p.charge,p.contract_sign_date,p.total_money,IFNULL(pa.invoice_money,0.00) invoice_money,IF(pa.invoice_money IS NULL,p.total_money,p.total_money-pa.invoice_money) invoice_money_notready,IFNULL(pa.invoice_money_rate,0.00) invoice_money_rate FROM `ly_project` p LEFT JOIN `ly_project_amount` pa ON pa.project_id = p.id LEFT JOIN `ly_contract` c ON c.id = p.contract_id WHERE p.identifier LIKE '%2305106%' AND c.company_order LIKE '%海量%' ORDER BY p.contract_sign_date
以下是将 SQL 代码转换为 MyBatis Plus 代码的示例:
```java
QueryWrapper<Project> queryWrapper = new QueryWrapper<>();
queryWrapper.select("p.id", "p.identifier", "c.company_order", "p.business_source", "p.salesmen", "p.charge", "p.contract_sign_date", "p.total_money", "IFNULL(pa.invoice_money,0.00) invoice_money", "IF(pa.invoice_money IS NULL,p.total_money,p.total_money-pa.invoice_money) invoice_money_notready", "IFNULL(pa.invoice_money_rate,0.00) invoice_money_rate")
.eq("p.identifier", "%2305106%")
.like("c.company_order", "海量")
.orderByAsc("p.contract_sign_date")
.leftJoin(ProjectAmount.class, "pa", "pa.project_id = p.id")
.leftJoin(Contract.class, "c", "c.id = p.contract_id");
List<Project> projectList = projectMapper.selectList(queryWrapper);
```
这段代码中,我们使用了 MyBatis Plus 提供的 `QueryWrapper` 类来构造查询条件,使用 `select` 方法来指定需要查询的字段,使用 `eq` 和 `like` 方法来添加查询条件,使用 `orderByAsc` 方法来指定排序方式,使用 `leftJoin` 方法来添加左连接的表和连接条件。最后,我们调用 `selectList` 方法来执行查询,并将结果保存在 `projectList` 变量中。
帮我优化如下sql:SELECT T1.quyu, T2.lastNum, T3.jdNum, T4.xcNum FROM (SELECT STREET AS quyu FROM STREET_YXW WHERE 1=1 GROUP BY STREET ) T1 LEFT JOIN ( SELECT T2.STREET_NAME AS quyu,COUNT(*) AS lastNum FROM V_FIRESAFETYREGISTER_DYC T1 LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T2 ON LEFT(T1.HOUSEID,19) = T2.BUILDING_CODE WHERE T1.LASTLOGOUTTIME IS NOT NULL and date_format(T1.LASTLOGOUTTIME,'%Y') = ? GROUP BY T2.STREET_NAME ) T2 ON T1.quyu = T2.quyu LEFT JOIN ( SELECT T3.STREET_NAME AS quyu,COUNT(DISTINCT T1.FIREID) AS jdNum FROM V_SX_FIRESAFETYPLAN T1 LEFT JOIN V_FIRESAFETYREGISTER_DYC T2 ON T1.FIREID = T2.ID LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T3 ON LEFT(T2.HOUSEID,19) = T3.BUILDING_CODE WHERE T1.DATE_NEW IS NOT NULL and date_format(T1.DATE_NEW,'%Y') = ? GROUP BY T3.STREET_NAME ) T3 ON T1.quyu = T3.quyu LEFT JOIN ( SELECT T3.STREET_NAME AS quyu,COUNT(*) as xcNum FROM V_SX_FIRESAFETYTRAINING T1 LEFT JOIN V_FIRESAFETYREGISTER_DYC T2 ON T1.FIREID = T2.ID LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T3 ON LEFT(T2.HOUSEID,19) = T3.BUILDING_CODE WHERE T1.TRAININGTIME IS NOT NULL and date_format(T1.TRAININGTIME,'%Y') = ? GROUP BY T3.STREET_NAME ) T4 ON T1.quyu = T4.quyu ORDER BY T2.lastNum limit ?,?
可以尝试以下优化:
1. 对于子查询中的表,添加合适的索引以提高查询效率;
2. 可以考虑将子查询改为临时表,避免多次重复查询;
3. 在需要排序的字段上添加索引;
4. 尽量避免在 JOIN 条件中使用函数,可以将日期比较条件提取到 WHERE 子句中。
优化后的 SQL 如下:
```
CREATE TEMPORARY TABLE tmp_street AS
SELECT STREET AS quyu FROM STREET_YXW WHERE 1=1 GROUP BY STREET;
CREATE TEMPORARY TABLE tmp_lastNum AS
SELECT T2.STREET_NAME AS quyu, COUNT(*) AS lastNum
FROM V_FIRESAFETYREGISTER_DYC T1
LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T2 ON LEFT(T1.HOUSEID, 19) = T2.BUILDING_CODE
WHERE T1.LASTLOGOUTTIME IS NOT NULL AND date_format(T1.LASTLOGOUTTIME,'%Y') = ?
GROUP BY T2.STREET_NAME;
CREATE TEMPORARY TABLE tmp_jdNum AS
SELECT T3.STREET_NAME AS quyu, COUNT(DISTINCT T1.FIREID) AS jdNum
FROM V_SX_FIRESAFETYPLAN T1
LEFT JOIN V_FIRESAFETYREGISTER_DYC T2 ON T1.FIREID = T2.ID
LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T3 ON LEFT(T2.HOUSEID, 19) = T3.BUILDING_CODE
WHERE T1.DATE_NEW IS NOT NULL AND date_format(T1.DATE_NEW,'%Y') = ?
GROUP BY T3.STREET_NAME;
CREATE TEMPORARY TABLE tmp_xcNum AS
SELECT T3.STREET_NAME AS quyu, COUNT(*) AS xcNum
FROM V_SX_FIRESAFETYTRAINING T1
LEFT JOIN V_FIRESAFETYREGISTER_DYC T2 ON T1.FIREID = T2.ID
LEFT JOIN V_HSE_COMB_BUILDING_INFO_PA T3 ON LEFT(T2.HOUSEID, 19) = T3.BUILDING_CODE
WHERE T1.TRAININGTIME IS NOT NULL AND date_format(T1.TRAININGTIME,'%Y') = ?
GROUP BY T3.STREET_NAME;
SELECT T1.quyu, T2.lastNum, T3.jdNum, T4.xcNum
FROM tmp_street T1
LEFT JOIN tmp_lastNum T2 ON T1.quyu = T2.quyu
LEFT JOIN tmp_jdNum T3 ON T1.quyu = T3.quyu
LEFT JOIN tmp_xcNum T4 ON T1.quyu = T4.quyu
ORDER BY T2.lastNum
LIMIT ?,?;
```
请注意,这只是一种可能的优化方案,具体的优化方法还要根据数据库的实际情况进行调整。