地方法规--广东信锋

基本文件流程错误 SQL 调试

[ DB ] CONNECT:[ UseTime:0.010981s ] mysql:host=localhost;port=3306;dbname=ruilee_xinfeng;charset=utf8
[ SQL ] SHOW COLUMNS FROM `rui_channel` [ RunTime:0.001712s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 ORDER BY `weigh` ASC [ RunTime:0.001273s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001003s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000955s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000930s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 96 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000934s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000983s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001001s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001005s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001005s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 97 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001003s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001044s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001008s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001141s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001076s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001030s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001035s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000975s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001340s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001158s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 98 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001006s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001200s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001114s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002908s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001175s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001249s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001170s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001070s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001185s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001221s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001020s ]
[ SQL ] SHOW COLUMNS FROM `rui_slide` [ RunTime:0.002898s ]
[ 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.001491s ]
[ 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.003812s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 127 LIMIT 1 [ RunTime:0.007531s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.008371s ]
[ SQL ] SHOW COLUMNS FROM `rui_article` [ RunTime:0.022641s ]
[ 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` = '127' AND `article`.`status` = '1' ORDER BY `is_top` DESC,`create_time` DESC [ RunTime:0.033009s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 127 LIMIT 1 [ RunTime:0.012077s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.009437s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.002794s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002016s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001692s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `id` = 123 LIMIT 1 [ RunTime:0.002018s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002639s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001934s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.001689s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001765s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.007462s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.013400s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004628s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC [ RunTime:0.009279s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.011375s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.017629s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.012821s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.011671s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 0 ORDER BY `weigh` ASC [ RunTime:0.007335s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003377s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002853s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002830s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001278s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001399s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001127s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001062s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001167s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001372s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001221s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001403s ]