招标咨询--广东信锋

基本文件流程错误 SQL 调试

[ DB ] CONNECT:[ UseTime:0.011720s ] mysql:host=localhost;port=3306;dbname=ruilee_xinfeng;charset=utf8
[ SQL ] SHOW COLUMNS FROM `rui_channel` [ RunTime:0.001888s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 ORDER BY `weigh` ASC [ RunTime:0.001308s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000979s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000912s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000899s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 96 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000871s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000888s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000891s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000907s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000911s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 97 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000909s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000931s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001148s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001217s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000947s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000907s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000936s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001012s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001079s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001048s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000936s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 98 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000941s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000926s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000988s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001120s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001000s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001008s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001061s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001021s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000978s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001320s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001039s ]
[ SQL ] SHOW COLUMNS FROM `rui_slide` [ RunTime:0.001861s ]
[ 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.001168s ]
[ 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.001032s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 107 LIMIT 1 [ RunTime:0.002541s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001279s ]
[ SQL ] SHOW COLUMNS FROM `rui_article` [ RunTime:0.001907s ]
[ 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` = '107' AND `article`.`status` = '1' ORDER BY `is_top` DESC,`create_time` DESC [ RunTime:0.003534s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 107 LIMIT 1 [ RunTime:0.001752s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001164s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 83 LIMIT 1 [ RunTime:0.001224s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001095s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `id` = 83 LIMIT 1 [ RunTime:0.001043s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001286s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001272s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC [ RunTime:0.001529s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002036s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001222s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001094s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003124s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003573s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC [ RunTime:0.006071s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.009957s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.017664s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.015402s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.019653s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.023929s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 0 ORDER BY `weigh` ASC [ RunTime:0.024121s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.028447s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.023053s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.006633s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001594s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001544s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001322s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001738s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001029s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002301s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001037s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000892s ]