[ SQL ] SHOW COLUMNS FROM `ye_category` [ RunTime:0.000295s ]
[ 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.000101s ]
[ 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.000117s ]
[ SQL ] SHOW COLUMNS FROM `ye_article` [ RunTime:0.000316s ]
[ SQL ] SHOW COLUMNS FROM `ye_user` [ RunTime:0.000253s ]
[ 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.030268s ]
[ 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.019248s ]
[ 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.016869s ]
[ 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.019108s ]
[ 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.021600s ]
[ 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.016629s ]
[ 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.018821s ]
[ 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.021103s ]
[ 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.032771s ]
[ 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.022644s ]
[ 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.024664s ]
[ 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.019399s ]
[ 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.020282s ]
[ 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.017210s ]
[ 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.026209s ]
[ 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.020011s ]
[ 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.023121s ]
[ 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.022225s ]
[ 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.023315s ]
[ 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.028837s ]
[ 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.023230s ]
[ 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.019488s ]
[ 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.020045s ]
[ 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.041971s ]
[ 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.019306s ]
[ 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.013206s ]
[ 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.000522s ]
[ 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.018586s ]
[ 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.020055s ]
[ 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.038556s ]
[ 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.040205s ]
[ 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.033847s ]
[ 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.029061s ]
[ 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.152284s ]
[ 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.159269s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ye_article` WHERE `status` = 1 AND `display` = 1 AND `update_time` > '2025-11-03 00:00:00' [ RunTime:0.093906s ]
[ SQL ] SHOW COLUMNS FROM `ye_ads` [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 18 AND `start_time` < 1762169773 AND `end_time` > 1762169773 ORDER BY `sort` DESC [ RunTime:0.000174s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 21 AND `start_time` < 1762169773 AND `end_time` > 1762169773 ORDER BY `sort` DESC [ RunTime:0.000142s ]
