[ SQL ] SHOW COLUMNS FROM `ye_category` [ RunTime:0.000287s ]
[ SQL ] SELECT * FROM `ye_category` WHERE `status` = 1 AND `display` = 1 AND `index_tags` LIKE '%,1,%' ORDER BY `sort` DESC LIMIT 0,8 [ RunTime:0.000132s ]
[ SQL ] SELECT * FROM `ye_category` WHERE `status` = 1 AND `display` = 1 AND `index_tags` LIKE '%,3,%' ORDER BY `sort` DESC LIMIT 0,4 [ RunTime:0.000111s ]
[ SQL ] SELECT * FROM `ye_category` WHERE `status` = 1 AND `display` = 1 AND `index_tags` LIKE '%,2,%' ORDER BY `sort` DESC LIMIT 0,50 [ RunTime:0.000118s ]
[ SQL ] SHOW COLUMNS FROM `ye_article` [ RunTime:0.000315s ]
[ SQL ] SHOW COLUMNS FROM `ye_user` [ RunTime:0.000243s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 282 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.028299s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 283 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018097s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 285 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.016959s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 286 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.017710s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 287 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.023681s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 288 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.016532s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 289 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018342s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 290 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.019992s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 261 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.031404s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 278 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.021778s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 5 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.023559s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 275 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018674s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 100 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.019386s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 103 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.017859s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 123 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.027079s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 160 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.021398s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 202 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.022016s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 203 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.024293s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 264 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.023557s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 266 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.027808s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 267 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.021983s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 270 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018731s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 276 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018978s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 171 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.023078s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 7 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018998s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 271 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.013101s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 274 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.000513s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 280 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018241s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 281 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.018043s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 291 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.036186s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 292 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.036788s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 293 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.031843s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `category_id` = 294 AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC,`sort` DESC LIMIT 0,10 [ RunTime:0.027498s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `article`.`status` = 1 AND `display` = 1 AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `update_time` DESC LIMIT 0,12 [ RunTime:0.155840s ]
[ SQL ] SELECT `article`.`id`,`article`.`admin_id`,`article`.`title`,`article`.`category_id`,`article`.`desc`,`article`.`sort`,`article`.`position`,`article`.`cover`,`article`.`cover_path`,`article`.`display`,`article`.`tags`,`article`.`view`,`article`.`comment`,`article`.`status`,`article`.`mark`,`article`.`vist`,`article`.`keyword`,`article`.`sale_type`,`article`.`type`,`article`.`price`,`article`.`source_price`,`article`.`agent_type`,`article`.`file_down_url`,`article`.`file_down_url_back`,`article`.`download_count`,`article`.`media_url`,`article`.`is_alone`,`article`.`article_from`,`article`.`author_id`,`article`.`author_free`,`article`.`author_money`,`article`.`author_valid`,`article`.`author_valid_remark`,`article`.`reward_count`,`article`.`reward_money`,`article`.`is_need_update`,`article`.`auto_update_time`,`article`.`create_user`,`article`.`create_time`,`article`.`update_time`,`article`.`update_user`,`article`.`remark`,`article`.`data_from`,`article`.`file_type`,`article`.`file_words`,`article`.`file_size`,`article`.`file_down_url_2021`,`article`.`file_page_num`,`article`.`file_bili`,`article`.`file_mold`,`article`.`is_push_baidu`,`article`.`industry_ids`,`article`.`is_star`,`user`.`id` AS `user__id`,`user`.`openid` AS `user__openid`,`user`.`openid_pc` AS `user__openid_pc`,`user`.`openid_weapp` AS `user__openid_weapp`,`user`.`nickname` AS `user__nickname`,`user`.`unionid` AS `user__unionid`,`user`.`sex` AS `user__sex`,`user`.`province` AS `user__province`,`user`.`city` AS `user__city`,`user`.`country` AS `user__country`,`user`.`headimgurl` AS `user__headimgurl`,`user`.`reg_ip` AS `user__reg_ip`,`user`.`status` AS `user__status`,`user`.`is_subscribe` AS `user__is_subscribe`,`user`.`last_login_time` AS `user__last_login_time`,`user`.`last_login_ip` AS `user__last_login_ip`,`user`.`from_client` AS `user__from_client`,`user`.`email` AS `user__email`,`user`.`mobile` AS `user__mobile`,`user`.`point` AS `user__point`,`user`.`sha1` AS `user__sha1`,`user`.`remark` AS `user__remark`,`user`.`username` AS `user__username`,`user`.`wechat` AS `user__wechat`,`user`.`from_user_id` AS `user__from_user_id`,`user`.`is_agent` AS `user__is_agent`,`user`.`parent1` AS `user__parent1`,`user`.`parent2` AS `user__parent2`,`user`.`parent3` AS `user__parent3`,`user`.`parent_path` AS `user__parent_path`,`user`.`total_parent1` AS `user__total_parent1`,`user`.`last_pay_time` AS `user__last_pay_time`,`user`.`first_pay_time` AS `user__first_pay_time`,`user`.`pay_amount` AS `user__pay_amount`,`user`.`create_time` AS `user__create_time`,`user`.`update_time` AS `user__update_time`,`user`.`user_group_id` AS `user__user_group_id`,`user`.`down_count` AS `user__down_count`,`user`.`down_limit` AS `user__down_limit`,`user`.`platform` AS `user__platform`,`user`.`fans` AS `user__fans`,`user`.`is_disabled_author` AS `user__is_disabled_author` FROM `ye_article` `article` LEFT JOIN `ye_user` `user` ON `article`.`author_id`=`user`.`id` WHERE `article`.`id` > '1' AND `article`.`status` = 1 AND `display` = 1 AND `cover_path` <> '' AND ( `author_valid` != 'D' AND (( author_valid = 'W' AND article_from = 10 ) OR ( author_valid = 'T' AND article_from = 20 )) ) ORDER BY `create_time` DESC LIMIT 5,5 [ RunTime:0.162309s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ye_article` WHERE `status` = 1 AND `display` = 1 AND `update_time` > '2025-07-15 00:00:00' [ RunTime:0.000106s ]
[ SQL ] SHOW COLUMNS FROM `ye_ads` [ RunTime:0.000264s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 18 AND `start_time` < 1752541683 AND `end_time` > 1752541683 ORDER BY `sort` DESC [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 21 AND `start_time` < 1752541683 AND `end_time` > 1752541683 ORDER BY `sort` DESC [ RunTime:0.000134s ]
