getlist 调试

PID: 38
WHERE (原始):
Array
(
    [status] => 1
    [pid] => 38
    [city_id] => 3507
)
手动 SQL: SELECT COUNT(*) FROM modoer_subject s WHERE s.status = '1' AND s.pid = '38' AND s.city_id = '3507' AND (s.pid = 38 OR s.catid = 38)
手动 SQL 返回值: 64
getcount 返回: 64
WHERE (移除attid后):
Array
(
    [status] => 1
    [pid] => 38
    [city_id] => 3507
)
JOIN 表: modoer_subject_taoci
添加分类条件: (s.pid = 38 OR s.catid = 38)
主查询 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_shangjia FROM modoer_subject s LEFT JOIN modoer_subject_taoci sf ON s.sid = sf.sid WHERE (s.pid = 38 OR s.catid = 38) AND s.status = '1' AND s.pid = '38' AND s.city_id = '3507' ORDER BY null
COUNT结果: 64
数据行数: 0
北京商业计划书_范本频道_95商服网
北京站

——原中国政务服务网——

服务分类

选择您所在的城市

扫一扫,进入手机站