[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000817s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000175s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000697s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `jm_message` `m` INNER JOIN `jm_member_list` `u` ON `m`.`mid`=`u`.`id` WHERE `m`.`show` = 0 AND `m`.`status` = 0 LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000457s ]
[ SQL ] SELECT `p`.* FROM `jm_problem` `p` WHERE `p`.`id` = 2 AND `p`.`is_delete` = 1 AND `p`.`status` = 1 ORDER BY `p`.`listorder` ASC LIMIT 1 [ RunTime:0.000245s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000507s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1752710974>= a.plug_ad_starsttime and 1752710974<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000479s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1752710974>= a.plug_ad_starsttime and 1752710974<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000350s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1752710974>= a.plug_ad_starsttime and 1752710974<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000388s ]
[ SQL ] SELECT * FROM `jm_plug_ad` `a` LEFT JOIN `jm_plug_adtype` `t` ON `a`.`plug_ad_adtypeid`=`t`.`plug_adtype_id` WHERE ( a.plug_ad_open= 1 and a.plug_ad_adtypeid =1 ) AND ( 1752710974>= a.plug_ad_starsttime and 1752710974<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000343s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008474s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.009855s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.007979s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.000694s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`nmid`,`n`.`news_columnid`,`n`.`news_title`,`n`.`news_key`,`n`.`news_tag`,`n`.`news_flag`,`n`.`news_auto`,`n`.`news_source`,`n`.`news_hits`,`n`.`news_img`,`n`.`news_imgs`,`n`.`news_scontent`,`n`.`news_content`,`n`.`news_time`,`n`.`news_like`,`n`.`comment_count`,`m`.`id`,`m`.`menu_name`,`m`.`menu_seo_title`,`m`.`menu_seo_key`,`m`.`menu_seo_des`,`u`.`id`,`u`.`realname`,`u`.`nickname`,`u`.`avatar` FROM `jm_news` `n` INNER JOIN `jm_menu` `m` ON `n`.`news_columnid`=`m`.`id` INNER JOIN `jm_member_list` `u` ON `n`.`nmid`=`u`.`id` WHERE `n`.`n_id` = '47987' AND `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `m`.`mnoshow` = 0 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 LIMIT 1 [ RunTime:0.001273s ]
[ SQL ] UPDATE `jm_news` SET `news_hits`=`news_hits`+1 WHERE `n_id` = 47987 [ RunTime:0.004270s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`nmid`,`n`.`news_title`,`n`.`news_key`,`n`.`news_tag`,`n`.`news_flag`,`n`.`news_auto`,`n`.`news_source`,`n`.`news_hits`,`n`.`news_img`,`n`.`news_scontent`,`n`.`news_content`,`n`.`news_time`,`m`.`menu_name`,`m`.`menu_seo_title`,`m`.`menu_seo_key`,`m`.`menu_seo_des`,`u`.`id`,`u`.`realname`,`u`.`nickname`,`u`.`avatar` FROM `jm_news` `n` INNER JOIN `jm_menu` `m` ON `n`.`news_columnid`=`m`.`id` INNER JOIN `jm_member_list` `u` ON `n`.`nmid`=`u`.`id` WHERE `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `m`.`mnoshow` = 0 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 AND `n`.`news_columnid` = 44 ORDER BY `n`.`n_id` DESC LIMIT 9 [ RunTime:0.062959s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`nmid`,`n`.`news_title`,`n`.`news_key`,`n`.`news_tag`,`n`.`news_flag`,`n`.`news_auto`,`n`.`news_source`,`n`.`news_hits`,`n`.`news_img`,`n`.`news_scontent`,`n`.`news_content`,`n`.`news_time`,`m`.`menu_name`,`m`.`menu_seo_title`,`m`.`menu_seo_key`,`m`.`menu_seo_des`,`u`.`id`,`u`.`realname`,`u`.`nickname`,`u`.`type`,`u`.`avatar` FROM `jm_news` `n` INNER JOIN `jm_menu` `m` ON `n`.`news_columnid`=`m`.`id` INNER JOIN `jm_member_list` `u` ON `n`.`nmid`=`u`.`id` WHERE `news_time` BETWEEN 1752106174 AND 1752710974 AND `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `m`.`mnoshow` = 0 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 ORDER BY `n`.`news_hits` DESC LIMIT 9 [ RunTime:2.933380s ]
[ SQL ] SELECT `n_id`,`nmid`,`news_columnid`,`news_title`,`news_key`,`news_tag`,`news_flag`,`news_auto`,`news_source`,`news_time`,`news_imgs`,`news_img` FROM `jm_news` WHERE `news_open` = 1 AND `n_id` < 47987 AND `news_columnid` = 44 LIMIT 1 [ RunTime:0.000486s ]
[ SQL ] SELECT `n_id`,`nmid`,`news_columnid`,`news_title`,`news_key`,`news_tag`,`news_flag`,`news_auto`,`news_source`,`news_time` FROM `jm_news` WHERE `news_open` = 1 AND `n_id` > 47987 AND `news_columnid` = 44 LIMIT 1 [ RunTime:0.000389s ]
