[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000763s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000392s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000616s ]
[ 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.000267s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000550s ]
[ 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.000198s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000549s ]
[ 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 ( 1751880138>= a.plug_ad_starsttime and 1751880138<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000490s ]
[ 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 ( 1751880138>= a.plug_ad_starsttime and 1751880138<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000379s ]
[ 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 ( 1751880138>= a.plug_ad_starsttime and 1751880138<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000364s ]
[ 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 ( 1751880138>= a.plug_ad_starsttime and 1751880138<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000413s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008836s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008484s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008197s ]
[ SQL ] SHOW COLUMNS FROM `jm_menu` [ RunTime:0.000671s ]
[ SQL ] SELECT * FROM `jm_menu` WHERE `id` = 87 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.000852s ]
[ SQL ] SELECT `n`.`n_id`,`n`.`news_columnid`,`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 `u`.`status` = 2 AND `m`.`menu_open` = 1 AND `n`.`news_open` = 1 AND `n`.`news_back` = 0 AND `n`.`news_columnid` = '87' ORDER BY `n`.`news_time` DESC LIMIT 0,15 [ RunTime:0.007032s ]
[ 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` = 87 ORDER BY `n`.`n_id` DESC LIMIT 9 [ RunTime:0.005479s ]
关注我们
