企业文化--广东信锋

基本文件流程错误 SQL 调试

[ DB ] CONNECT:[ UseTime:0.022861s ] mysql:host=localhost;port=3306;dbname=ruilee_xinfeng;charset=utf8
[ SQL ] SHOW COLUMNS FROM `rui_channel` [ RunTime:0.002502s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 ORDER BY `weigh` ASC [ RunTime:0.001404s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001989s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002214s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004028s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 96 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003165s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 103 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002162s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 125 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001334s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001303s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 97 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002064s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 104 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003321s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 126 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003220s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004688s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001270s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001348s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 105 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001274s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 127 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002679s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002381s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001459s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001250s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 98 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001761s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 106 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001474s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 128 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001159s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 107 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002129s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001795s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001415s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002032s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003311s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.003244s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.004171s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002785s ]
[ SQL ] SHOW COLUMNS FROM `rui_slide` [ RunTime:0.031012s ]
[ 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.006630s ]
[ 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.011890s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 117 LIMIT 1 [ RunTime:0.022886s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.040187s ]
[ SQL ] SHOW COLUMNS FROM `rui_article` [ RunTime:0.051122s ]
[ SQL ] UPDATE `rui_article` SET `views` = `views` + 1 WHERE `id` = 1843 [ RunTime:0.034303s ]
[ SQL ] SELECT `article`.*,admin_user.nickname as admin_title FROM `rui_article` `article` LEFT JOIN `rui_admin_user` `admin_user` ON `admin_user`.`id`=`article`.`admin_id` WHERE ( article.id =1843 ) LIMIT 1 [ RunTime:0.011776s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 117 LIMIT 1 [ RunTime:0.001532s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001112s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `id` = 80 LIMIT 1 [ RunTime:0.000867s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001183s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001219s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `id` = 80 LIMIT 1 [ RunTime:0.001064s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001853s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001253s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC [ RunTime:0.001559s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001022s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001231s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001177s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001033s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001194s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002258s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001056s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC [ RunTime:0.001454s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 88 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001086s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 117 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001942s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 91 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001603s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 89 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.002258s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 118 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001176s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 119 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001159s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 129 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001629s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `is_nav_display` = 1 AND `status` = 1 AND `pid` = 0 ORDER BY `weigh` ASC [ RunTime:0.014129s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001691s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 80 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001613s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 81 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001694s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001078s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 82 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.010065s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001033s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 83 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.001041s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 123 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000953s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 124 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000934s ]
[ SQL ] SELECT * FROM `rui_channel` WHERE `status` = 1 AND `pid` = 87 ORDER BY `weigh` ASC LIMIT 1 [ RunTime:0.000994s ]