SELECT * FROM `mac_person` WHERE `id` = 975690 LIMIT 1 [ RunTime:0.006456s ]
SHOW FULL COLUMNS FROM `mac_credits` [ RunTime:0.007705s ]
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` = '975690' 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.009949s ]
SELECT `tmdb_vid` FROM `mac_credits` WHERE `pid` = 975690 [ RunTime:0.006352s ]
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` IN ('208367','222680') AND `c`.`pid` <> '975690' 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.014458s ]