რეზიდენტი (2017)
The Resident / ქართულად, ინგლისურად

    7.8
    0
    0

    ჟანრი:დრამა

    ტელეარხი: FOX

    სტუდია: Fuqua Films, 20th Century Fox Television, 3 Art Entertainment

    გამოშვების წელი: 2017

    ხანგრძლივობა: 42 წთ

    ქვეყანა: აშშ

    ფილმის სიუჟეტი:

    მთავარი გმირი დეივონ პრავიშია, ახალგაზრდა სტაჟიორი იდეალური შეხედულებებით ცხოვრებაზე. ის დარწმუნებულია მისი არჩეული პროფესიის სისწორეში და იმაში, რომ ადამინების დახმარება უნდა. მისი მიზნის მისაღწევად იგი მზადაა ყველაფერი გაიღოს მსხვერპლად. თუმცა როდესაც იგი ჩესტეინის საავადმყოფოში იწყებს მუშაობას, ხვდება, რომ სამყაროს ვარდისფერი სათვალეებით უყურებდა და დრო მოვიდა რეალობას სამედიცინო გზით შეეჭიდოს.

      КРИТЕРИИ  
    Loading Time: Base Classes  0.0053
    Controller Execution Time ( Watch / Serials )  2.5715
    Total Execution Time  2.5770
      GET ДАННЫЕ  
    Нет данных GET
      ИСПОЛЬЗОВАНИЕ ПАМЯТИ  
    928,360 bytes
      POST ДАННЫЕ  
    Нет данных POST
      URI СТРОКА  
    serial/523/the-resident
      КЛАСС/МЕТОД  
    watch/serials
      БАЗА ДАННЫХ:  mekobre_adm (Watch:$db)   ЗАПРОСЫ: 11 (0.8229 секунд)  (Спрятать)
    0.0018  
                    SELECT 
                        
                        CONCAT
    (''GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`language`, ''))'') as `langs`,
                        
    CONCAT(''GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`category`, ''))'') as `cats`,
                        `
    videos`.`category`,
                        `
    titles`.*
                        
                    
    FROM 
                        
    `titles
                    
    LEFT JOIN `videos`
                        
    ON `videos`.`title_id`=`titles`.`id`
                    
    WHERE 
                        
    `titles`.`is_series`='1' AND  `titles`.`id`='523'
                    
    GROUP BY
                        
    `videos`.`category
                    
    ORDER BY 
                        
    `videos`.`categoryASC
                    LIMIT 1
                 
    0.0006  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

                    
    `taggables
                    
                
    LEFT JOIN `tags`
                    
    ON `taggables`.`tag_id`=`tags`.`id`

                
    WHERE 

                    
    `taggable_id` = '523' AND 
                    `
    tags`.`type` = 'genre'
             
    0.0018  
                SELECT 
                    
    `seasons`.`id`,
                    `
    seasons`.`number`,
                    `
    seasons`.`episode_count`,
                    `
    seasons`.`updated_at`
                
    FROM 
                    
    `seasons`
                
    LEFT JOIN 
                    
    `videos`
                    
    ON `seasons`.`title_id`=`videos`.`title_id`
                
    WHERE 
                    
    `seasons`.`title_id` = '523' AND `seasons`.`number`=`videos`.`season_num`
                
    GROUP BY `seasons`.`number`
             
    0.0016  
                SELECT 
                    
    `videos`.`id`,
                    `
    videos`.`url`,
                    `
    videos`.`type`,
                    `
    videos`.`quality`,
                    `
    videos`.`season_num`,
                    `
    videos`.`episode_num`,
                    `
    videos`.`source`,
                    `
    videos`.`approved`,
                    `
    videos`.`language`,
                    `
    videos`.`category`
                
    FROM 
                    
    `videos
                
    LEFT JOIN `titles`
                    
    ON `videos`.`title_id`=`titles`.`id`
                
    WHERE 
                    
    `titles`.`id` = '523' 
                
    ORDER BY 
                    
    `videos`.`episode_num` + 0
             
    0.0011  
                SELECT 
                    
    `videos`.`id`,
                    `
    videos`.`url`,
                    `
    videos`.`type`,
                    `
    videos`.`quality`,
                    `
    videos`.`season_num`,
                    `
    videos`.`episode_num`,
                    `
    videos`.`source`,
                    `
    videos`.`approved`,
                    `
    videos`.`language`,
                    `
    videos`.`category`
                
    FROM 
                    
    `videos
                
    LEFT JOIN `titles`
                    
    ON `videos`.`title_id`=`titles`.`id`
                
    WHERE 
                    
    `titles`.`id` = '523'  AND `videos`.`category`='full'
                
    ORDER BY 
                    
    `videos`.`episode_num` + 0, `videos`.`languageASC
                LIMIT 1
             
    0.0002  
                SELECT 
                    
    `videos`.`id`,
                    `
    videos`.`url`,
                    `
    videos`.`type`,
                    `
    videos`.`quality`,
                    `
    videos`.`season_num`,
                    `
    videos`.`episode_num`,
                    `
    videos`.`source`,
                    `
    videos`.`approved`,
                    `
    videos`.`language`,
                    `
    videos`.`category`
                
    FROM 
                    
    `videos
                
    LEFT JOIN `titles`
                    
    ON `videos`.`title_id`=`titles`.`id`
                
    WHERE 
                    
    `titles`.`id` = '523'  AND `videos`.`category`='full'
                
    ORDER BY 
                    
    `videos`.`episode_num` + 0, `videos`.`languageASC
                LIMIT 1
             
    0.0008  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

                    
    `taggables
                    
                
    LEFT JOIN `tags`
                    
    ON `taggables`.`tag_id`=`tags`.`id`

                
    WHERE 

                    
    `taggable_id` = '523' AND 
                    `
    tags`.`type` = 'keyword' AND 
                    `
    tags`.`prod` = 'networks'
             
    0.0005  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

                    
    `taggables
                    
                
    LEFT JOIN `tags`
                    
    ON `taggables`.`tag_id`=`tags`.`id`

                
    WHERE 

                    
    `taggable_id` = '523' AND 
                    `
    tags`.`type` = 'keyword' AND 
                    `
    tags`.`prod` = 'companies'
             
    0.0005  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

                    
    `taggables
                    
                
    LEFT JOIN `tags`
                    
    ON `taggables`.`tag_id`=`tags`.`id`

                
    WHERE 

                    
    `taggable_id` = '523' AND 
                    `
    tags`.`type` = 'production_country'
             
    0.0044  
                SELECT 
                    
    `people`.`id`,
                    `
    people`.`name`,
                    `
    people`.`original_name`,
                    `
    people`.`poster`,
                    `
    people`.`known_for`,
                    `
    people`.`gender`,
                    `
    creditables`.`department`,
                    `
    creditables`.`job`,
                    `
    creditables`.`order`,
                    `
    creditables`.`character`
                    
                
    FROM 

                    
    `creditables
                    
                
    LEFT JOIN `people`
                    
    ON `creditables`.`person_id`=`people`.`id`

                
    WHERE 

                    
    `creditables`.`creditable_id` = '523' AND 
                    `
    creditables`.`creditable_type` = 'App\\Title'
                    
                
    ORDER BY 
                    
    `creditables`.`orderASC
             
    0.8096  
                SELECT 
                    CONCAT
    (''GROUP_CONCAT(DISTINCT CONCAT('', `videos`.`language`, ''))'') as `langs`,
                    `
    titles`.`id`,
                    `
    titles`.`name`,
                    `
    titles`.`original_title`,
                    `
    titles`.`tmdb_vote_average`,
                    `
    titles`.`year`,
                    `
    titles`.`poster`,
                    `
    titles`.`backdrop`,
                    `
    titles`.`imdb_id`,
                    `
    titles`.`tmdb_id`,
                    `
    titles`.`season_count`,
                    `
    titles`.`episode_count`,
                    `
    titles`.`certification`,
                    `
    titles`.`language` as translation,
                    `
    titles`.`is_series`,
                    `
    videos`.`language`
                
    FROM 
                    
    `titles
                
    LEFT JOIN `videos`
                    
    ON `videos`.`title_id`=`titles`.`id`
                
    LEFT JOIN `taggables`
                    
    ON `titles`.`id`=`taggables`.`taggable_id`
                
    LEFT JOIN `tags`
                    
    ON `taggables`.`tag_id`=`tags`.`id`
                
    WHERE 
                    
    `titles`.`is_series`='1'  AND `titles`.`id`!='523' AND `tags`.`type`='genre'  AND `titles`.`nameLIKE CONCAT('%', `titles`.`name` ,'%')
                
    GROUP BY 
                    
    `titles`.`id`
                
    HAVING 
                    
    `videos`.`languageIS NOT NULL
                ORDER BY 
                    RAND
    ()
                
    LIMIT 8
             
      HTTP ЗАГОЛОВКИ  (Показать)
      ПЕРЕМЕННЫЕ КОНФИГУРАЦИИ  (Показать)