SELECT * FROM `mac_person` WHERE `id` = 889348 LIMIT 1 [ RunTime:0.005715s ]
SHOW FULL COLUMNS FROM `mac_credits` [ RunTime:0.006822s ]
SELECT `c`.`tmdb_vid`,`c`.`character`,`c`.`cast_id`,`v`.`title`,`v`.`release_date`,`v`.`id`,`v`.`poster_path`,`v`.`genres`,`v`.`vote_average` FROM `mac_credits` `c` LEFT JOIN `mac_video` `v` ON `c`.`tmdb_vid`=`v`.`tmdb_id` WHERE `v`.`adult` <> '1' AND `c`.`pid` = '889348' GROUP BY `c`.`tmdb_vid`,`c`.`character`,`c`.`cast_id`,`v`.`title`,`v`.`release_date`,`v`.`id`,`v`.`poster_path`,`v`.`genres`,`v`.`vote_average` [ RunTime:0.007221s ]
SELECT `tmdb_vid` FROM `mac_credits` WHERE `pid` = 889348 [ RunTime:0.005553s ]
SELECT c.pid, p.name,p.profile_path,p.id,p.gender,COUNT(*) as collaborate_count FROM `mac_credits` `c` INNER JOIN `mac_person` `p` ON `c`.`pid`=`p`.`id` WHERE `c`.`tmdb_vid` = '157047' AND `c`.`pid` <> '889348' AND `p`.`adult` <> '1' GROUP BY `c`.`pid`,`p`.`name`,`p`.`profile_path`,`p`.`id`,`p`.`gender` ORDER BY `collaborate_count` DESC LIMIT 14 [ RunTime:0.011402s ]