下面是查询语句
$list = $Service->with('images,videos')->order(['id' => 'DESC'])->page('1,12')->select();
日志文件里面是这样的:[ sql ] [ SQL ] SHOW COLUMNS FROM `tp5_service` [ RunTime:0.046922s ]
[ sql ] [ SQL ] SELECT * FROM `tp5_service` ORDER BY `id` DESC LIMIT 0,12 [ RunTime:0.047751s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `tp5_service_images` [ RunTime:0.046390s ]
[ sql ] [ SQL ] SELECT * FROM `tp5_service_images` WHERE ( `service_id` = 13 AND `service_id` IN (31,30,29,27,23,22,21,20,19,18,17,13) ) [ RunTime:0.046176s ]
[ sql ] [ SQL ] SHOW COLUMNS FROM `tp5_service_videos` [ RunTime:0.047109s ]
[ sql ] [ SQL ] SELECT * FROM `tp5_service_videos` WHERE ( `service_id` = 13 AND `service_id` IN (31,30,29,27,23,22,21,20,19,18,17,13) ) [ RunTime:0.045816s ]
[ sql ] [ SQL ] SELECT COUNT(id) AS tp_count FROM `tp5_service` LIMIT 1 [ RunTime:0.052411s ]
查询条件里面多了`service_id` = 13这个,那只能获取一个组数据,另外的数据都获取不了。系统里面很多地方用了预加载,都出现这个问题。
最佳答案
