short - cute - videos

Newest short.lt video | Best video of the day | Best video of the week | Best video of the month

All short video, funny video, video with children, animals video, cars video and some more short video (2016 birželis)

  BENCHMARKS  
Loading Time: Base Classes  0.0015
Controller Execution Time ( Listing / Index )  0.0119
Total Execution Time  0.0134
  GET DATA  
No GET data exists
  MEMORY USAGE  
683,056 bytes
  POST DATA  
No POST data exists
  URI STRING  
video-list/all-videos/2016-06
  CLASS/METHOD  
listing/index
  DATABASE:  u278561375_short   QUERIES: 6  (Hide)
0.0002   SELECT vc.*
                      
FROM video_categories AS vc
                     WHERE vc
.category_url_lt LIKE 'all-videos'
                     
LIMIT 1
                     
#getCategoryInfoByName LT 
0.0001   SELECT vc.*
                          
FROM video_categories AS vc
                         WHERE vc
.category_url_en LIKE 'all-videos'
                         
LIMIT 1
                         
#getCategoryInfoByName EN 
0.0008   #getExsistingVideoDates
                
SELECT YEAR(publish_date) AS year, DATE_FORMAT(publish_date, '%m') as month, COUNT(id)
                
FROM video
                GROUP BY year
, month
                HAVING year 
> 0
                ORDER BY year DESC
, month DESC 
0.0009   SELECT SQL_CALC_FOUND_ROWS *, CASE WHEN (publish_date > DATE(2026-09-24) + INTERVAL -1 DAY) THEN 1 ELSE 0 END AS video_is_new
FROM 
(`video`)
WHERE `show_status` =  '1'
AND (show_lang = 'en' OR show_lang = 'all')
AND 
date(publish_date) >= '2016-06-01' AND date(publish_date) < '2016-06-01' + INTERVAL 1 MONTH
ORDER BY 
`publish_date` desc 
0.0001   SELECT FOUND_ROWS() as fr 
0.0002   SELECT *
FROM (`video_categories`)
WHERE `show_status` =  '1'
ORDER BY `sort` 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)