部委法规--广东信锋

基本文件流程错误 SQL 调试

[ DB ] CONNECT:[ UseTime:0.011419s ] mysql:host=localhost;port=3306;dbname=ruilee_xinfeng;charset=utf8
[ SQL ] SHOW COLUMNS FROM `rui_channel` [ RunTime:0.001879s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 ORDER BY `weigh` ASC [ RunTime:0.001453s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001052s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000980s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000976s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 96 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000969s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000968s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000964s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000941s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000973s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 97 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000990s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000971s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000963s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000970s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000999s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001360s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001060s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001040s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001063s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001037s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001063s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 98 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001033s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001044s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001039s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001034s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001007s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001055s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001106s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001065s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001110s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001123s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001078s ]
[ SQL ] SHOW COLUMNS FROM `rui_slide` [ RunTime:0.001716s ]
[ 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.001251s ]
[ 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.001181s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 126 LIMIT 1 [ RunTime:0.001022s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001069s ]
[ SQL ] SHOW COLUMNS FROM `rui_article` [ RunTime:0.001851s ]
[ 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` = '126' AND `article`.`status` = '1' ORDER BY `is_top` DESC,`create_time` DESC [ RunTime:0.002678s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 126 LIMIT 1 [ RunTime:0.000872s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001024s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.000865s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001053s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001077s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.000908s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001066s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001072s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.001096s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001034s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001089s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001010s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001019s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.001097s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001096s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001081s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000937s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000976s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 0 ORDER BY `weigh` ASC [ RunTime:0.001052s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001393s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001021s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001052s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001093s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000994s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001036s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000985s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001013s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001012s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001010s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000990s ]