[ SQL ] SHOW COLUMNS FROM `fa_stats_perday` [ RunTime:0.000844s ]
[ SQL ] SELECT * FROM `fa_stats_perday` WHERE `ip` = 873978636 AND `date` = '2021-11-30' AND `robot` = 1 LIMIT 1 [ RunTime:0.000728s ]
[ SQL ] UPDATE `fa_stats_perday` SET `lasttime`='2021-11-30 14:30:27',`times`=times+1 WHERE `ip` = 873978636 AND `date` = '2021-11-30' AND `robot` = 1 [ RunTime:0.000793s ]
[ SQL ] SHOW COLUMNS FROM `fa_person` [ RunTime:0.000990s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `nameid` = 2312223 LIMIT 1 [ RunTime:0.001184s ]
[ SQL ] UPDATE `fa_person` SET `viewnum`=`viewnum`+1 WHERE `id` = 2154817 [ RunTime:0.002283s ]
[ SQL ] UPDATE `fa_person` SET `descending`=0 WHERE `id` = 2154817 [ RunTime:0.000704s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `nameid` = 2312223 LIMIT 1 [ RunTime:0.000759s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_detail` [ RunTime:0.000857s ]
[ SQL ] SELECT * FROM `fa_person_detail` WHERE `p_id` = 2154817 [ RunTime:0.001536s ]
[ 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` = '2154817' LIMIT 1 [ RunTime:0.000797s ]
[ 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` = '2154817' ORDER BY `im`.`sort` DESC,`im`.`id` DESC LIMIT 0,5 [ RunTime:0.000833s ]
[ SQL ] SELECT `dclick`,`lastctime` FROM `fa_person` WHERE `id` = 2154817 LIMIT 1 [ RunTime:0.000729s ]
[ SQL ] UPDATE `fa_person` SET `dclick`=1,`lastctime`=1638253827 WHERE `id` = 2154817 [ RunTime:0.001564s ]
[ SQL ] SHOW COLUMNS FROM `fa_user_list` [ RunTime:0.000991s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_user_list` WHERE `uid` = -1 AND `is_del` = 0 AND `type` = '0' LIMIT 1 [ RunTime:0.000743s ]
[ 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.000759s ]
[ SQL ] SHOW COLUMNS FROM `fa_user_list_detail` [ RunTime:0.000838s ]
[ 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.000687s ]
[ SQL ] SELECT `list_id` FROM `fa_user_list_detail` WHERE `uid` IS NULL AND `type` = 'person' AND `t_id` = 2312223 [ RunTime:0.000653s ]
[ 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` = '2154817' LIMIT 1 [ RunTime:0.001399s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_rank` [ RunTime:0.000852s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 2154817 AND `date` = '2021-11-28' LIMIT 1 [ RunTime:0.001139s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 2154817 AND `date` LIKE '2021-10%' ORDER BY `date` ASC LIMIT 1 [ RunTime:0.001382s ]
[ SQL ] SELECT `rank` FROM `fa_person_rank` WHERE `p_id` = 2154817 AND `date` LIKE '2020%' ORDER BY `date` ASC LIMIT 1 [ RunTime:0.002117s ]
[ SQL ] SELECT * FROM fa_person_rank_log where p_id='2154817' order by id desc limit 1 [ RunTime:0.000753s ]
[ SQL ] SHOW COLUMNS FROM `fa_maker` [ RunTime:0.000830s ]
[ SQL ] SELECT `id`,`name2` FROM `fa_maker` [ RunTime:0.000801s ]
[ SQL ] SELECT * FROM `fa_person` WHERE `id` = 2154817 LIMIT 1 [ RunTime:0.000759s ]
[ SQL ] SELECT `p_id`,`content`,`econtent`,`espuose`,`spuose`,`trademark`,`etrademark`,`trivia`,`etrivia`,`other`,`eother`,`quotes` FROM `fa_person_detail` WHERE `p_id` = 2154817 [ RunTime:0.000689s ]
[ SQL ] SHOW COLUMNS FROM `fa_person_text` [ RunTime:0.000813s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 2154817 AND `status` = 1 AND `type` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 2 [ RunTime:0.001178s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 2154817 AND `status` = 1 AND `type` = 2 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000761s ]
[ SQL ] SELECT * FROM `fa_person_text` WHERE `p_id` = 2154817 AND `status` = 1 AND `type` = 3 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000783s ]
[ SQL ] SHOW COLUMNS FROM `fa_movie_person` [ RunTime:0.000802s ]
[ 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` = '2154817' 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.061018s ]
[ 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` = '2154817' 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.002441s ]
[ 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` = '2154817' AND `m`.`status` = 1 AND `m`.`parent_imdb_id` = 0 ORDER BY `m`.`viewnum` DESC [ RunTime:0.002328s ]
[ 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` = '2154817' [ RunTime:0.000795s ]
[ 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` = '2154817' [ RunTime:0.000732s ]
[ SQL ] SHOW COLUMNS FROM `fa_awards_active` [ RunTime:0.000854s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_awards_active` WHERE `nominating` = 0 AND `p_id` = 2154817 LIMIT 1 [ RunTime:0.001197s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_awards_active` WHERE `nominating` = 1 AND `p_id` = 2154817 LIMIT 1 [ RunTime:0.000728s ]
[ SQL ] SELECT * FROM `fa_awards_active` WHERE `type` = 2 AND `p_id` = 2154817 ORDER BY `year` DESC [ RunTime:0.000799s ]
[ SQL ] SHOW COLUMNS FROM `fa_talk` [ RunTime:0.000831s ]
[ SQL ] SELECT * FROM `fa_talk` WHERE `p_id` = 2154817 ORDER BY `reply_num` DESC,`id` DESC LIMIT 0,3 [ RunTime:0.000718s ]
[ SQL ] SELECT * FROM `fa_talk` WHERE `p_id` = 2154817 ORDER BY `id` DESC LIMIT 0,3 [ RunTime:0.000727s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_talk` WHERE `p_id` = 2154817 LIMIT 1 [ RunTime:0.000685s ]
[ SQL ] SELECT `nameid`,`name` FROM `fa_person` WHERE `nameid` IN ('') [ RunTime:0.000679s ]
[ SQL ] SHOW COLUMNS FROM `fa_movie` [ RunTime:0.000927s ]
[ SQL ] SELECT `imdb_id`,`title` FROM `fa_movie` WHERE `imdb_id` IN (781550,4567904,4453604) [ RunTime:0.001894s ]
[ SQL ] SELECT `nameid`,`name` FROM `fa_person` WHERE `nameid` IN (438734,994365) [ RunTime:0.001136s ]
[ SQL ] SELECT `imdb_id`,`title` FROM `fa_movie` WHERE `imdb_id` IN ('') [ RunTime:0.000686s ]
[ SQL ] SHOW COLUMNS FROM `fa_comment_list` [ RunTime:0.000820s ]
[ SQL ] SELECT * FROM `fa_comment_list` `a` WHERE `a`.`parentid` = 0 AND `a`.`article_type` = 'person' AND `a`.`article_id` = '2312223' AND `a`.`status` = 1 AND `a`.`is_del` = 0 ORDER BY `a`.`id` DESC LIMIT 0,3 [ RunTime:0.000805s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_comment_list` `a` WHERE `a`.`parentid` = 0 AND `a`.`article_type` = 'person' AND `a`.`article_id` = '2312223' AND `a`.`status` = 1 AND `a`.`is_del` = 0 LIMIT 1 [ RunTime:0.000724s ]
编辑
冀公网安备 13019902000295号
还没有用户评论，快来抢沙发吧！