SELECT * FROM `mac_person` WHERE `id` = 653115 LIMIT 1 [ RunTime:0.006591s ]
SHOW FULL COLUMNS FROM `mac_credits` [ RunTime:0.007531s ]
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` = '653115' 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.008151s ]
SELECT `tmdb_vid` FROM `mac_credits` WHERE `pid` = 653115 [ RunTime:0.006206s ]
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 ('69755','223301') AND `c`.`pid` <> '653115' 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.013590s ]
