[ SQL ] SHOW COLUMNS FROM `fa_stats_perday` [ RunTime:0.000854s ]
[ SQL ] SELECT * FROM `fa_stats_perday` WHERE `ip` = 873978636 AND `date` = '2021-11-30' AND `robot` = 1 LIMIT 1 [ RunTime:0.000756s ]
[ SQL ] UPDATE `fa_stats_perday` SET `lasttime`='2021-11-30 13:58:00',`times`=times+1 WHERE `ip` = 873978636 AND `date` = '2021-11-30' AND `robot` = 1 [ RunTime:0.000730s ]
[ SQL ] SHOW COLUMNS FROM `fa_person` [ RunTime:0.000912s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `nameid` = 5736708 LIMIT 1 [ RunTime:0.001212s ]
[ SQL ] UPDATE `fa_person` SET `viewnum`=`viewnum`+1 WHERE `id` = 5860160 [ RunTime:0.002230s ]
[ SQL ] UPDATE `fa_person` SET `descending`=0 WHERE `id` = 5860160 [ RunTime:0.000734s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `nameid` = 5736708 LIMIT 1 [ RunTime:0.000771s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_detail` [ RunTime:0.000837s ]
[ SQL ] SELECT * FROM `fa_person_detail` WHERE `p_id` = 5860160 [ RunTime:0.001515s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_person` `p` INNER JOIN `fa_images` `im` ON `p`.`id`=`im`.`p_id` LEFT JOIN `fa_movie` `m` ON `m`.`id`=`im`.`m_id` WHERE `im`.`status` = 1 AND `p_id` = '5860160' LIMIT 1 [ RunTime:0.000794s ]
[ SQL ] SELECT `im`.`id`,`im`.`image`,`im`.`desc`,`im`.`title`,`m`.`year`,m.title as mtitle FROM `fa_person` `p` INNER JOIN `fa_images` `im` ON `p`.`id`=`im`.`p_id` LEFT JOIN `fa_movie` `m` ON `m`.`id`=`im`.`m_id` WHERE `im`.`status` = 1 AND `p_id` = '5860160' ORDER BY `im`.`sort` DESC,`im`.`id` DESC LIMIT 0,5 [ RunTime:0.000854s ]
[ SQL ] SELECT `dclick`,`lastctime` FROM `fa_person` WHERE `id` = 5860160 LIMIT 1 [ RunTime:0.000721s ]
[ SQL ] UPDATE `fa_person` SET `dclick`=1,`lastctime`=1638251880 WHERE `id` = 5860160 [ RunTime:0.001833s ]
[ SQL ] SHOW COLUMNS FROM `fa_user_list` [ RunTime:0.000958s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_user_list` WHERE `uid` = -1 AND `is_del` = 0 AND `type` = '0' LIMIT 1 [ RunTime:0.000789s ]
[ SQL ] SELECT * FROM `fa_user_list` WHERE `uid` = -1 AND `is_del` = 0 AND `type` = '0' ORDER BY `sort` ASC,`id` DESC LIMIT 0,15 [ RunTime:0.000874s ]
[ SQL ] SHOW COLUMNS FROM `fa_user_list_detail` [ RunTime:0.000883s ]
[ SQL ] SELECT `id`,`list_id` FROM `fa_user_list_detail` WHERE `uid` IS NULL AND `is_del` = 0 AND `list_id` IN (1) [ RunTime:0.000702s ]
[ SQL ] SELECT `list_id` FROM `fa_user_list_detail` WHERE `uid` IS NULL AND `type` = 'person' AND `t_id` = 5736708 [ RunTime:0.000701s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_person` `p` INNER JOIN `fa_video_person` `vp` ON `p`.`id`=`vp`.`person_id` INNER JOIN `fa_video` `v` ON `v`.`id`=vp.v_id and v.status=1 INNER JOIN `fa_video_typename` `vt` ON `vt`.`id`=`vp`.`type_id` WHERE `p`.`id` = '5860160' LIMIT 1 [ RunTime:0.001402s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_rank` [ RunTime:0.000827s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 5860160 AND `date` = '2021-11-28' LIMIT 1 [ RunTime:0.001111s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 5860160 AND `date` LIKE '2021-10%' ORDER BY `date` ASC LIMIT 1 [ RunTime:0.001192s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 5860160 AND `date` LIKE '2020%' ORDER BY `date` ASC LIMIT 1 [ RunTime:0.002994s ]
[ SQL ] SELECT * FROM fa_person_rank_log where p_id='5860160' order by id desc limit 1 [ RunTime:0.000710s ]
[ SQL ] SHOW COLUMNS FROM `fa_maker` [ RunTime:0.000824s ]
[ SQL ] SELECT `id`,`name2` FROM `fa_maker` [ RunTime:0.000820s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `id` = 5860160 LIMIT 1 [ RunTime:0.000741s ]
[ SQL ] SELECT `p_id`,`content`,`econtent`,`espuose`,`spuose`,`trademark`,`etrademark`,`trivia`,`etrivia`,`other`,`eother`,`quotes` FROM `fa_person_detail` WHERE `p_id` = 5860160 [ RunTime:0.000769s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_text` [ RunTime:0.000852s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 5860160 AND `status` = 1 AND `type` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 2 [ RunTime:0.001188s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 5860160 AND `status` = 1 AND `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000764s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 5860160 AND `status` = 1 AND `type` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000721s ]
[ SQL ] SHOW COLUMNS FROM `fa_movie_person` [ RunTime:0.000808s ]
[ SQL ] SELECT `m`.`imdb_id`,`m`.`title`,`m`.`etitle`,`m`.`rate`,`m`.`year`,`m`.`image`,`m`.`country`,`mp`.`maker_id`,`mp`.`role`,`mp`.`erole` FROM `fa_movie_person` `mp` RIGHT JOIN `fa_movie` `m` ON `mp`.`m_id`=`m`.`id` WHERE `mp`.`p_id` = '5860160' AND `m`.`parent_imdb_id` = 0 AND `m`.`status` = 1 AND `mp`.`maker_id` IN ('1','2','3','4','5','6','7','8') GROUP BY `m`.`id` ORDER BY `m`.`rate_num` DESC LIMIT 5 [ RunTime:0.004952s ]
[ SQL ] SELECT `m`.`imdb_id`,`m`.`title`,`m`.`etitle`,`m`.`rate`,`m`.`year`,`m`.`image`,`m`.`country`,`mp`.`maker_id`,`mp`.`role`,`mp`.`erole` FROM `fa_movie_person` `mp` RIGHT JOIN `fa_movie` `m` ON `mp`.`m_id`=`m`.`id` WHERE `mp`.`p_id` = '5860160' AND `m`.`parent_imdb_id` = 0 AND `m`.`status` = 1 AND ( `m`.`showdate` < '2021-11-30' and `m`.`showdate` > '2020-11-30' ) GROUP BY `m`.`id` ORDER BY `m`.`showdate` DESC LIMIT 5 [ RunTime:0.000959s ]
[ SQL ] SELECT `m`.`id`,`m`.`imdb_id`,`m`.`parent_imdb_id`,`m`.`parent_season`,`m`.`title`,`m`.`etitle`,`m`.`rate`,`mp`.`role`,`mp`.`erole`,`mp`.`maker_id`,`m`.`year`,`m`.`image`,`m`.`country`,`m`.`type`,`genre_ids` FROM `fa_person` `p` INNER JOIN `fa_movie_person` `mp` ON `mp`.`p_id`=`p`.`id` INNER JOIN `fa_movie` `m` ON `m`.`id`=`mp`.`m_id` WHERE `p`.`id` = '5860160' AND `m`.`status` = 1 AND `m`.`parent_imdb_id` = 0 ORDER BY `m`.`viewnum` DESC [ RunTime:0.001008s ]
[ SQL ] SELECT `m`.`title`,`a`.`intro`,`a`.`publish_date` FROM `fa_person` `s` INNER JOIN `fa_person_music` `m` ON `m`.`p_id`=`s`.`nameid` INNER JOIN `fa_person_album` `a` ON `a`.`id`=`m`.`album_id` WHERE `s`.`nameid` = '5860160' [ RunTime:0.001166s ]
[ SQL ] SELECT `m`.`title`,`m`.`etitle`,`m`.`year`,`r`.`money` FROM `fa_person` `s` INNER JOIN `fa_person_remuneration` `r` ON `r`.`p_id`=`s`.`id` INNER JOIN `fa_movie` `m` ON `m`.`id`=`r`.`m_id` WHERE `s`.`id` = '5860160' [ RunTime:0.000699s ]
[ SQL ] SHOW COLUMNS FROM `fa_awards_active` [ RunTime:0.000868s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_awards_active` WHERE `nominating` = 0 AND `p_id` = 5860160 LIMIT 1 [ RunTime:0.000758s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_awards_active` WHERE `nominating` = 1 AND `p_id` = 5860160 LIMIT 1 [ RunTime:0.000750s ]
[ SQL ] SELECT * FROM `fa_awards_active` WHERE `type` = 2 AND `p_id` = 5860160 ORDER BY `year` DESC [ RunTime:0.000751s ]
[ SQL ] SHOW COLUMNS FROM `fa_talk` [ RunTime:0.000804s ]
[ SQL ] SELECT * FROM `fa_talk` WHERE `p_id` = 5860160 ORDER BY `reply_num` DESC,`id` DESC LIMIT 0,3 [ RunTime:0.000708s ]
[ SQL ] SELECT * FROM `fa_talk` WHERE `p_id` = 5860160 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000771s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_talk` WHERE `p_id` = 5860160 LIMIT 1 [ RunTime:0.000683s ]
[ SQL ] SELECT id as maker_id,`name`,`ename` FROM `fa_maker` ORDER BY `msort` ASC [ RunTime:0.000888s ]
[ SQL ] SELECT `nameid`,`name` FROM `fa_person` WHERE `nameid` IN (1710152) [ RunTime:0.001214s ]
[ SQL ] SHOW COLUMNS FROM `fa_movie` [ RunTime:0.001013s ]
[ SQL ] SELECT `imdb_id`,`title` FROM `fa_movie` WHERE `imdb_id` IN ('') [ RunTime:0.000671s ]
[ SQL ] SHOW COLUMNS FROM `fa_comment_list` [ RunTime:0.000933s ]
[ SQL ] SELECT * FROM `fa_comment_list` `a` WHERE `a`.`parentid` = 0 AND `a`.`article_type` = 'person' AND `a`.`article_id` = '5736708' AND `a`.`status` = 1 AND `a`.`is_del` = 0 ORDER BY `a`.`id` DESC LIMIT 0,3 [ RunTime:0.000800s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_comment_list` `a` WHERE `a`.`parentid` = 0 AND `a`.`article_type` = 'person' AND `a`.`article_id` = '5736708' AND `a`.`status` = 1 AND `a`.`is_del` = 0 LIMIT 1 [ RunTime:0.000705s ]
编辑
冀公网安备 13019902000295号
还没有用户评论，快来抢沙发吧！