[ SQL ] SHOW COLUMNS FROM `jm_member_list` [ RunTime:0.000719s ]
[ SQL ] SELECT * FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.001186s ]
[ SQL ] SELECT `is_state` FROM `jm_member_list` WHERE `id` IS NULL LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SHOW COLUMNS FROM `jm_message` [ RunTime:0.000614s ]
[ 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.000275s ]
[ SQL ] SHOW COLUMNS FROM `jm_problem` [ RunTime:0.000481s ]
[ 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.000206s ]
[ SQL ] SHOW COLUMNS FROM `jm_plug_ad` [ RunTime:0.000508s ]
[ 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 ( 1751909529>= a.plug_ad_starsttime and 1751909529<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 0,1 [ RunTime:0.000473s ]
[ 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 ( 1751909529>= a.plug_ad_starsttime and 1751909529<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 1,1 [ RunTime:0.000339s ]
[ 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 ( 1751909529>= a.plug_ad_starsttime and 1751909529<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 2,1 [ RunTime:0.000349s ]
[ 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 ( 1751909529>= a.plug_ad_starsttime and 1751909529<=a.plug_ad_aendime ) ORDER BY `a`.`plug_ad_order` ASC LIMIT 3,1 [ RunTime:0.000440s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008684s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.008114s ]
[ SQL ] SHOW TABLE STATUS FROM lv [ RunTime:0.007670s ]
[ SQL ] SHOW COLUMNS FROM `jm_menu` [ RunTime:0.000638s ]
[ SQL ] SELECT * FROM `jm_menu` WHERE `id` = 30 LIMIT 1 [ RunTime:0.000270s ]
[ SQL ] SHOW COLUMNS FROM `jm_news` [ RunTime:0.000609s ]
[ SQL ] SELECT COUNT(*) AS tp_count 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` = '30' AND `n`.`news_flag` = 'h' LIMIT 1 [ RunTime:0.061256s ]
[ 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` = '30' AND `n`.`news_flag` = 'h' ORDER BY `n`.`news_time` DESC LIMIT 0,15 [ RunTime:0.068497s ]
关注我们
