SELECT * FROM `lay_tcm_yaowu_attr` WHERE `yaowu_id` = 294 [ RunTime:0.001263s ]
SHOW FULL COLUMNS FROM `lay_tcm_yaofang` [ RunTime:0.000843s ]
SELECT `tcm_yaofang`.*,`tcm_yaofang_logic`.`role`,tcm_yaofang_logic. role_sort,tcm_yaofang_logic. yaowu_id FROM `lay_tcm_yaofang` `tcm_yaofang` INNER JOIN `lay_tcm_yaofang_logic` `tcm_yaofang_logic` ON `tcm_yaofang_logic`.`yaofang_id`=`tcm_yaofang`.`id` WHERE `tcm_yaofang_logic`.`yaowu_id` = '294' AND `tcm_yaofang_logic`.`role` IN ('君','臣') ORDER BY field(tcm_yaofang_logic.role, '君', '臣') ASC,`tcm_yaofang_logic`.`role_sort` DESC LIMIT 5 [ RunTime:0.001500s ]
