[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000811s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000385s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000203s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000641s ]
[ 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.000370s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000602s ]
[ 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.000311s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000560s ]
[ 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 ( 1752077647>= a.plug_ad_starsttime and 1752077647<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000509s ]
[ 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 ( 1752077647>= a.plug_ad_starsttime and 1752077647<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000513s ]
[ 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 ( 1752077647>= a.plug_ad_starsttime and 1752077647<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000447s ]
[ 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 ( 1752077647>= a.plug_ad_starsttime and 1752077647<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000467s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.009447s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.012548s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.012509s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.001064s ]
[ 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` = '40428' 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.000734s ]
[ SQL ] UPDATE `jm_news` SET `news_hits`=`news_hits`+1 WHERE `n_id` = 40428 [ RunTime:0.004218s ]
[ 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 1751472847 AND 1752077647 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:3.070400s ]
[ 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` < 40428 AND `news_columnid` = 20 LIMIT 1 [ RunTime:0.000678s ]
[ 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` > 40428 AND `news_columnid` = 20 LIMIT 1 [ RunTime:0.000960s ]
[ SQL ] SHOW COLUMNS FROM `jm_shop` [ RunTime:0.000755s ]
[ SQL ] SELECT `s`.`id`,`s`.`mid`,`s`.`shoptitle`,`s`.`shoptxt`,`s`.`shopmoney`,`s`.`shopsum`,`s`.`shopbq`,`s`.`shopimg`,`s`.`shopquyu`,`s`.`pseo_keys`,`s`.`histsum`,`s`.`catetime`,`s`.`shoporder_sum`,`c`.`name`,`c`.`oname`,`c`.`seo_title`,`c`.`seo_keys`,`c`.`seo_desc`,`l`.`realname`,`l`.`nickname`,`l`.`avatar`,`j`.`pmdsum`,`j`.`pfyd`,`j`.`projectjc`,`j`.`pindustry`,`j`.`pindustryson` FROM `jm_shop` `s` INNER JOIN `jm_course` `c` ON `s`.`shopclass`=`c`.`id` INNER JOIN `jm_member_list` `l` ON `s`.`mid`=`l`.`id` LEFT JOIN `jm_project` `j` ON `l`.`id`=`j`.`mid` WHERE ( s.isopen =1 and s.isshow=0 and s.is_back=0 and s.recommend =0 ) ORDER BY `s`.`catetime` DESC LIMIT 3 [ RunTime:0.003405s ]
