免费发布保定满城区,一般纳税人公司转让信息- 95商服网

getlist 调试

PID: 740
WHERE (原始):

Array
(
    [status] => 1
    [pid] => 740
    [city_id] => 4068
)

手动 SQL: SELECT COUNT(*) FROM modoer_subject s WHERE s.status = '1' AND s.pid = '740' AND s.city_id = '4068' AND (s.pid = 740 OR s.catid = 740)

手动 SQL 返回值: 8

getcount 返回: 8

WHERE (移除attid后):

Array
(
    [status] => 1
    [pid] => 740
    [city_id] => 4068
)

JOIN 表: modoer_subject_zhr
添加分类条件: (s.pid = 740 OR s.catid = 740)

主查询 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,subname,c_tab,c_fenlei,c_nianx,c_ziben,c_nashui,c_lianxiren,tel FROM modoer_subject s LEFT JOIN modoer_subject_zhr sf ON s.sid = sf.sid WHERE (s.pid = 740 OR s.catid = 740) AND s.status = '1' AND s.pid = '740' AND s.city_id = '4068' ORDER BY null

COUNT结果: 8
数据行数: 0