getlist 调试

PID: 669
WHERE (原始): 
Array
(
    [status] => 1
    [pid] => 669
    [city_id] => 8704
)
手动 SQL: SELECT COUNT(*) FROM modoer_subject s WHERE s.status = '1' AND s.pid = '669' AND s.city_id = '8704' AND (s.pid = 669 OR s.catid = 669)
手动 SQL 返回值: 2
getcount 返回: 2
WHERE (移除attid后): 
Array
(
    [status] => 1
    [pid] => 669
    [city_id] => 8704
)
JOIN 表: modoer_subject_my
添加分类条件: (s.pid = 669 OR s.catid = 669)
主查询 SQL (估计):
SELECT s.sid,pid,catid,domain,name,avgsort,sort1,sort2,sort3,sort4,sort5,sort6,sort7,sort8,best,finer,pageviews,reviews,pictures,favorites,thumb,aid,map_lat,map_lng,c_jigou,c_banli,c_liucheng,c_fanwen FROM modoer_subject s LEFT JOIN modoer_subject_my sf ON s.sid = sf.sid WHERE (s.pid = 669 OR s.catid = 669) AND s.status = '1' AND s.pid = '669' AND s.city_id = '8704' ORDER BY null
COUNT结果: 2
数据行数: 0
铁岭政府各部门网上办事大厅入口

选择您所在的城市

铁岭各部门网上办事大厅入口 Tieling Business Affairs Hall
企业办事 个人办事
我要提问 最新问答
更多>> 办理指南
铁岭办事机构分类 Institutional classification
政务中心数据资源局市场监管局税务局科技局工信局人社局医保局卫健局教育局文旅局发改委商务局供销社国资委财政局金融局统计局审计局民政局退役军人事务局信访局综合执法局民宗局司法局公安局外事办海关住建局交通局水利局气象局应急管理局农业农村局消防救援局林草局自然资源局生态环境局烟草专卖局人民政府
                  企业办事指南
                  个人办事指南
                  铁岭服务
                  © 2010-2026 95商服网 All Rights Reserved. Powered By 澄洺文化 京ICP备18049654号