国家法规--广东信锋

基本文件流程错误 SQL 调试

[ DB ] CONNECT:[ UseTime:1.867800s ] mysql:host=localhost;port=3306;dbname=ruilee_xinfeng;charset=utf8
[ SQL ] SHOW COLUMNS FROM `rui_channel` [ RunTime:0.404757s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 ORDER BY `weigh` ASC [ RunTime:0.216581s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.069437s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.088701s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.118336s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 96 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.048335s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.019499s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.028325s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.031128s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.036971s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 97 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.060517s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.080822s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.076322s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.058973s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.162262s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.227450s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.295660s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.330995s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.159439s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.014433s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004537s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 98 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004119s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004757s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004099s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004280s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005576s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004499s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.006123s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005226s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005164s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005042s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005088s ]
[ SQL ] SHOW COLUMNS FROM `rui_slide` [ RunTime:0.005978s ]
[ SQL ] SELECT `slide`.*,article.title as article_title,category.title as category_title FROM `rui_slide` `slide` LEFT JOIN `rui_category` `category` ON `slide`.`channel_id`=`category`.`id` LEFT JOIN `rui_article` `article` ON `article`.`id`=`slide`.`article_id` WHERE `category`.`title` = 'banner_top' AND `slide`.`status` = '1' [ RunTime:0.004946s ]
[ SQL ] SELECT `slide`.*,article.title as article_title,category.title as category_title FROM `rui_slide` `slide` LEFT JOIN `rui_category` `category` ON `slide`.`channel_id`=`category`.`id` LEFT JOIN `rui_article` `article` ON `article`.`id`=`slide`.`article_id` WHERE `category`.`title` = 'logo' AND `slide`.`status` = '1' [ RunTime:0.005887s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 125 LIMIT 1 [ RunTime:0.004417s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004796s ]
[ SQL ] SHOW COLUMNS FROM `rui_article` [ RunTime:0.005315s ]
[ SQL ] SELECT `article`.`id`,`article`.`external_links`,`article`.`title`,`article`.`cover`,`article`.`channel_id`,`article`.`describe`,`article`.`is_top`,`article`.`create_time` FROM `rui_article` `article` WHERE `article`.`channel_id` = '125' AND `article`.`status` = '1' ORDER BY `is_top` DESC,`create_time` DESC [ RunTime:0.006595s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 125 LIMIT 1 [ RunTime:0.004704s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004437s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.004943s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005154s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005228s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.005092s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004921s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005108s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.006342s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005375s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004769s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005106s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005506s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.006292s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.005973s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008109s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008463s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.010282s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 0 ORDER BY `weigh` ASC [ RunTime:0.007988s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008240s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008869s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.011707s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008238s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008566s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.007511s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008371s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008282s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.007114s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.007525s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.007497s ]