[ SQL ] SHOW COLUMNS FROM `ye_category` [ RunTime:0.000348s ]
[ 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.000175s ]
[ 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.000166s ]
[ 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.000154s ]
[ SQL ] SHOW COLUMNS FROM `ye_article` [ RunTime:0.000364s ]
[ SQL ] SHOW COLUMNS FROM `ye_user` [ RunTime:0.000316s ]
[ 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.027373s ]
[ 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.017566s ]
[ 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.016684s ]
[ 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.017427s ]
[ 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.020431s ]
[ 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.016918s ]
[ 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.013599s ]
[ 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.018980s ]
[ 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.029810s ]
[ 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.020501s ]
[ 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.022247s ]
[ 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.017835s ]
[ 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.018186s ]
[ 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.013780s ]
[ 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.023696s ]
[ 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.017880s ]
[ 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.020637s ]
[ 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.020546s ]
[ 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.021220s ]
[ 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.025803s ]
[ 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.020920s ]
[ 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.017897s ]
[ 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.017894s ]
[ 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.020972s ]
[ 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.018032s ]
[ 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.013109s ]
[ 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.000518s ]
[ 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.017280s ]
[ 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.017166s ]
[ 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.033775s ]
[ 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.033831s ]
[ 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.029176s ]
[ 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.026150s ]
[ 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.137629s ]
[ 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.141150s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `ye_article` WHERE `status` = 1 AND `display` = 1 AND `update_time` > '2025-05-12 00:00:00' [ RunTime:0.084427s ]
[ SQL ] SHOW COLUMNS FROM `ye_ads` [ RunTime:0.000288s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 18 AND `start_time` < 1747038595 AND `end_time` > 1747038595 ORDER BY `sort` DESC [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `ye_ads` WHERE `status` = 1 AND `list_id` = 21 AND `start_time` < 1747038595 AND `end_time` > 1747038595 ORDER BY `sort` DESC [ RunTime:0.000140s ]