[ DB ] CONNECT:[ UseTime:0.000727s ] mysql:host=236server;port=3306;dbname=spacj;charset=utf8
[ SQL ] SHOW COLUMNS FROM `mj_channel_type` [ RunTime:0.000590s ]
[ SQL ] SELECT `type_dir`,`id` FROM `mj_channel_type` WHERE `is_show` = 1 [ RunTime:0.000296s ]
[ SQL ] SELECT * FROM `mj_channel_type` WHERE `pid` = 0 [ RunTime:0.000354s ]
[ SQL ] SHOW COLUMNS FROM `mj_ulinks` [ RunTime:0.000412s ]
[ SQL ] SELECT * FROM `mj_ulinks` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000240s ]
[ SQL ] SHOW COLUMNS FROM `mj_tag` [ RunTime:0.000380s ]
[ SQL ] SELECT * FROM `mj_tag` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000244s ]
[ SQL ] SHOW COLUMNS FROM `mj_user_article` [ RunTime:0.000579s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `mj_user_article` `a` LEFT JOIN `mj_channel_type` `t` ON `a`.`type_id`=`t`.`id` WHERE `status` = 1 AND `release_time` < 1615170738 AND ( `a`.`title` LIKE '%稀土永磁板块%' OR `a`.`keyword` LIKE '%稀土永磁板块%' ) LIMIT 1 [ RunTime:0.034285s ]
[ SQL ] SELECT `a`.*,`t`.`type_dir` FROM `mj_user_article` `a` LEFT JOIN `mj_channel_type` `t` ON `a`.`type_id`=`t`.`id` WHERE `status` = 1 AND `release_time` < 1615170738 AND ( `a`.`title` LIKE '%稀土永磁板块%' OR `a`.`keyword` LIKE '%稀土永磁板块%' ) ORDER BY `a`.`id` DESC LIMIT 0,20 [ RunTime:0.315004s ]
[ SQL ] SELECT `a`.`id`,`a`.`title`,`t`.`type_dir`,`t`.`type_name`,`a`.`publish_time`,`a`.`or_img` FROM `mj_user_article` `a` INNER JOIN `mj_channel_type` `t` ON `a`.`type_id`=`t`.`id` WHERE `a`.`status` = 1 AND `a`.`release_time` < 1615170738 ORDER BY `a`.`id` DESC LIMIT 20 [ RunTime:0.000685s ]
[ SQL ] SELECT `a`.`id`,`a`.`title`,`t`.`type_dir`,`t`.`type_name`,`a`.`publish_time` FROM `mj_user_article` `a` INNER JOIN `mj_channel_type` `t` ON `a`.`type_id`=`t`.`id` WHERE `a`.`status` = 1 AND `a`.`release_time` < 1615170738 ORDER BY `a`.`ua` ASC,`a`.`click` DESC LIMIT 20 [ RunTime:0.020493s ]
[ SQL ] SELECT * FROM `mj_tag` ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000317s ]
