შავი სია (2013)
The Blacklist / ქართულად, ინგლისურად

    7.9
    0
    0

    ჟანრი:დეტექტივი, დეტექტივი, დრამა, კრიმინალური

    ტელეარხი: NBC

    სტუდია: Sony Pictures Television Studios, Davis Entertainment, Universal Television

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

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

    ქვეყანა: აშშ

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

    FBI-ს (გამოძიების ფედერალური ბიუროს) ახალი პროფაილერის ცხოვრება თავდაყირა დგება მას შემდეგ, რაც მისტიური დამნაშავე, სახელად რეიმონდ რედინგტონი, რომელიც ათწლეულების განმავლობაში ძებნაში იმყოფებოდა, ნებაყოფლობით ბარდება პოლიციას და დაიჟინებს, რომ მხოლოდ მასთან შეხვედრის შემდეგ დაიწყებს საუბარს...

      КРИТЕРИИ  
    Loading Time: Base Classes  0.0035
    Controller Execution Time ( Watch / Serials )  2.5037
    Total Execution Time  2.5073
      GET ДАННЫЕ  
    Нет данных GET
      ИСПОЛЬЗОВАНИЕ ПАМЯТИ  
    1,181,760 bytes
      POST ДАННЫЕ  
    Нет данных POST
      URI СТРОКА  
    serial/752/the-blacklist
      КЛАСС/МЕТОД  
    watch/serials
      БАЗА ДАННЫХ:  mekobre_adm (Watch:$db)   ЗАПРОСЫ: 11 (0.6560 секунд)  (Спрятать)
    0.0019  
                    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`='752'
                    
    GROUP BY
                        
    `videos`.`category
                    
    ORDER BY 
                        
    `videos`.`categoryASC
                    LIMIT 1
                 
    0.0038  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

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

                
    WHERE 

                    
    `taggable_id` = '752' AND 
                    `
    tags`.`type` = 'genre'
             
    0.0029  
                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` = '752' AND `seasons`.`number`=`videos`.`season_num`
                
    GROUP BY `seasons`.`number`
             
    0.0020  
                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` = '752' 
                
    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` = '752'  AND `videos`.`category`='full'
                
    ORDER BY 
                    
    `videos`.`episode_num` + 0, `videos`.`languageASC
                LIMIT 1
             
    0.0001  
                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` = '752'  AND `videos`.`category`='full'
                
    ORDER BY 
                    
    `videos`.`episode_num` + 0, `videos`.`languageASC
                LIMIT 1
             
    0.0007  
                SELECT 
                    
    `tags`.`id`,
                    `
    tags`.`name`,
                    `
    tags`.`display_name`
                   
                
    FROM 

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

                
    WHERE 

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

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

                
    WHERE 

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

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

                
    WHERE 

                    
    `taggable_id` = '752' AND 
                    `
    tags`.`type` = 'production_country'
             
    0.0041  
                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` = '752' AND 
                    `
    creditables`.`creditable_type` = 'App\\Title'
                    
                
    ORDER BY 
                    
    `creditables`.`orderASC
             
    0.6386  
                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`!='752' 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 ЗАГОЛОВКИ  (Показать)
      ПЕРЕМЕННЫЕ КОНФИГУРАЦИИ  (Показать)