[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000776s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000388s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000707s ]
[ 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.000346s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000507s ]
[ 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.000227s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000674s ]
[ 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 ( 1753244772>= a.plug_ad_starsttime and 1753244772<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000523s ]
[ 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 ( 1753244772>= a.plug_ad_starsttime and 1753244772<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000373s ]
[ 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 ( 1753244772>= a.plug_ad_starsttime and 1753244772<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000404s ]
[ 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 ( 1753244772>= a.plug_ad_starsttime and 1753244772<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000373s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008345s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008338s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.007916s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.000668s ]
[ 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` = '20106' 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.000639s ]
[ SQL ] UPDATE `jm_news` SET `news_hits`=`news_hits`+1 WHERE `n_id` = 20106 [ RunTime:0.004181s ]
[ 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 1752639972 AND 1753244772 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.920849s ]
[ 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` < 20106 AND `news_columnid` = 20 LIMIT 1 [ RunTime:0.000432s ]
[ 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` > 20106 AND `news_columnid` = 20 LIMIT 1 [ RunTime:0.000467s ]
[ SQL ] SHOW COLUMNS FROM `jm_shop` [ RunTime:0.014656s ]
[ 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.000857s ]
