Unknown column 'rtype' in 'where clause' [ SQL语句 ] : SELECT a.id AS id,a.book_id AS book_id,a.num AS num,a.order_id AS order_id,a.rank_type AS rank_type,a.day_type AS day_type,a.datetime AS datetime,a.book_name AS book_name,a.book_cover AS book_cover,a.book_author AS book_author,a.book_desc AS book_desc,a.book_platform AS book_platform,a.book_cp_id AS book_cp_id,a.type AS type,b.name AS name,b.cover AS cover,b.allonym AS allonym,b.words AS words,b.sign_model AS sign_model,b.is_vip AS is_vip,b.progress AS progress,c.name AS cname,d.title AS title,d.chapter_id AS chapter_id,d.is_vip AS is_vip,d.renewal_time AS renewal_time,f.summary AS summary FROM cm_book_rank_log a LEFT JOIN cm_book_info b ON a.book_id=b.book_id LEFT JOIN cm_book_category c ON b.category_id=c.id LEFT JOIN cm_book_chapter_renewal d ON a.book_id=d.book_id LEFT JOIN cm_book_descr f ON a.book_id=f.book_id WHERE datetime=20240419 and rank_type=rtype and b.status=1 and b.read_limit!=1 and day_type=1 and !find_in_set(rtype,b.ranking_list_no) LIMIT 1

FILE: /webuse/ayhy/ThinkPHP/Lib/Driver/Db/DbMysql.class.php 　LINE: 320

[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Driver/Db/DbMysql.class.php (320) trace(Unknown column 'rtype' in 'where clause'
[ SQL语句 ] : SELECT a.id AS id,a.book_id AS book_id,a.num AS num,a.order_id AS order_id,a.rank_type AS rank_type,a.day_type AS day_type,a.datetime AS datetime,a.book_name AS book_name,a.book_cover AS book_cover,a.book_author AS book_author,a.book_desc AS book_desc,a.book_platform AS book_platform,a.book_cp_id AS book_cp_id,a.type AS type,b.name AS name,b.cover AS cover,b.allonym AS allonym,b.words AS words,b.sign_model AS sign_model,b.is_vip AS is_vip,b.progress AS progress,c.name AS cname,d.title AS title,d.chapter_id AS chapter_id,d.is_vip AS is_vip,d.renewal_time AS renewal_time,f.summary AS summary FROM cm_book_rank_log a LEFT JOIN cm_book_info b ON a.book_id=b.book_id LEFT JOIN cm_book_category c ON b.category_id=c.id LEFT JOIN cm_book_chapter_renewal d ON a.book_id=d.book_id LEFT JOIN cm_book_descr f ON a.book_id=f.book_id WHERE datetime=20240419 and rank_type=rtype and b.status=1 and b.read_limit!=1 and day_type=1 and !find_in_set(rtype,b.ranking_list_no) LIMIT 1 , , ERR)
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Driver/Db/DbMysql.class.php (107) DbMysql->error()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Core/Db.class.php (739) DbMysql->query(SELECT a.id AS id,a.book_id AS book_id,a.num AS num,a.order_id AS order_id,a.rank_type AS rank_type,a.day_type AS day_type,a.datetime AS datetime,a.book_name AS book_name,a.book_cover AS book_cover,a.book_author AS book_author,a.book_desc AS book_desc,a.book_platform AS book_platform,a.book_cp_id AS book_cp_id,a.type AS type,b.name AS name,b.cover AS cover,b.allonym AS allonym,b.words AS words,b.sign_model AS sign_model,b.is_vip AS is_vip,b.progress AS progress,c.name AS cname,d.title AS title,d.chapter_id AS chapter_id,d.is_vip AS is_vip,d.renewal_time AS renewal_time,f.summary AS summary FROM cm_book_rank_log a LEFT JOIN cm_book_info b ON a.book_id=b.book_id LEFT JOIN cm_book_category c ON b.category_id=c.id LEFT JOIN cm_book_chapter_renewal d ON a.book_id=d.book_id LEFT JOIN cm_book_descr f ON a.book_id=f.book_id WHERE datetime=20240419 and rank_type=rtype and b.status=1 and b.read_limit!=1 and day_type=1 and !find_in_set(rtype,b.ranking_list_no) LIMIT 1 )
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Core/Model.class.php (597) Db->select(Array)
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Extend/Vendor/Info/Common/Common.class.php (1163) Model->find()
[24-04-20 21:44:04] /webuse/ayhy/www/Web/Lib/Action/TopAction.class.php (142) Common->rank(2024-04-19, rtype, 1, 1, 50)
[24-04-20 21:44:04] () TopAction->All()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Core/App.class.php (172) ReflectionMethod->invoke()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Core/App.class.php (208) App::exec()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Lib/Core/Think.class.php (39) App::run()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/Common/runtime.php (243) Think::start()
[24-04-20 21:44:04] /webuse/ayhy/ThinkPHP/ThinkPHP.php (30) require(/webuse/ayhy/ThinkPHP/Common/runtime.php)
[24-04-20 21:44:04] /webuse/ayhy/www/index.php (17) require(/webuse/ayhy/ThinkPHP/ThinkPHP.php)